[pLog-svn] r564 - plog/trunk/class/dao

[subaochen at devel.plogworld.net]

Author: subaochen
Date: 2004-12-23 07:58:09 +0000 (Thu, 23 Dec 2004)
New Revision: 564

Modified:
   plog/trunk/class/dao/searchengine.class.php
Log:
search article works now, but only for english.


Modified: plog/trunk/class/dao/searchengine.class.php
===================================================================
--- plog/trunk/class/dao/searchengine.class.php	2004-12-22 15:15:13 UTC (rev 563)
+++ plog/trunk/class/dao/searchengine.class.php	2004-12-23 07:58:09 UTC (rev 564)
@@ -167,7 +167,7 @@
 							t.mangled_topic AS mangled_topic, a.status AS status, a.slug AS slug,
 							1 AS relevance
                             FROM {$prefix}articles a, {$prefix}articles_text t
-                            WHERE {$where_string} AND a.status = $status";
+                            WHERE {$where_string} AND a.id=t.article_id AND a.status = $status";
 			if( $blogId > 0 ) 
 				$searchQuery .= " AND a.blog_id = '".Db::qstr($blogId)."'";
 			if( $userId > 0 ) 
@@ -176,6 +176,8 @@
 				$searchQuery .= " AND a.date+0 LIKE '$date%' ";
 				
             $searchQuery .=" ORDER BY relevance DESC";
+
+            $this->log->debug("search article query is:".$searchQuery);
 			
 			return $searchQuery;
 		}
@@ -380,4 +382,4 @@
             return $results;
 		}
     }
-?>
\ No newline at end of file
+?>