[Comoblog-commit] comoblog/modules/mod_search/include blog_search.inc.php,1.2,1.3

[Mark W. \(a. serialmonkey\) <mar...@us...>]

Update of /cvsroot/comoblog/comoblog/modules/mod_search/include
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9196/include

Modified Files:
	blog_search.inc.php 
Log Message:
1361701 - Fixed site_url issues and search results after post deletion

Index: blog_search.inc.php
===================================================================
RCS file: /cvsroot/comoblog/comoblog/modules/mod_search/include/blog_search.inc.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- blog_search.inc.php	5 Oct 2005 01:38:32 -0000	1.2
+++ blog_search.inc.php	25 Nov 2005 04:31:16 -0000	1.3
@@ -6,8 +6,9 @@
     $search_string = strtolower($search_string);
     $posts = array();
     
-    $query = "select distinct post_id from ".CFG_MYSQL_TABPREFIX."blog_search_index 
-              where word like '%".$search_string."%'";
+    $query = "select distinct s.post_id from ".CFG_MYSQL_TABPREFIX."blog_search_index s, ".CFG_MYSQL_TABPREFIX."posts p 
+              where s.word like '%".$search_string."%'
+		and s.post_id = p.post_id";
               
     $res = mysql_query($query);