php-blog-cvs

[<ste...@us...>]

Update of /cvsroot/php-blog/jBlog
In directory sc8-pr-cvs1:/tmp/cvs-serv6019

Modified Files:
	db.sql jBlog_functions.inc.php 
Log Message:
fix entry searching.  you need to drop the fulltext index "title" and recreate
it, adding the extended entry.



Index: db.sql
===================================================================
RCS file: /cvsroot/php-blog/jBlog/db.sql,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -d -r1.8 -r1.9
--- db.sql	6 Mar 2003 01:10:54 -0000	1.8
+++ db.sql	6 Mar 2003 05:41:42 -0000	1.9
@@ -46,7 +46,7 @@
   author varchar(20) default null,
   authorid int(11) default null,
   primary key  (id),
-  fulltext key title (title,body)
+  fulltext key title (title,body,extended)
 ) type=myisam;
 
 #

Index: jBlog_functions.inc.php
===================================================================
RCS file: /cvsroot/php-blog/jBlog/jBlog_functions.inc.php,v
retrieving revision 1.17
retrieving revision 1.18
diff -u -d -r1.17 -r1.18
--- jBlog_functions.inc.php	6 Mar 2003 04:32:45 -0000	1.17
+++ jBlog_functions.inc.php	6 Mar 2003 05:41:42 -0000	1.18
@@ -220,24 +220,16 @@
 function jBlog_searchEntries($term) {
 	global $jBlog;
 
-	if (strlen($term)<4)
+	/* if (strlen($term) < 4) {
     	return false;
+    } */
 
     $querystring = "SELECT id, timestamp, comments, title, body, extended FROM ".$jBlog["dbPrefix"]."entries
-                    WHERE MATCH (title, extended) AGAINST ('".addslashes($term)."') ORDER BY timestamp DESC";
+                    WHERE MATCH (title, extended, body) AGAINST ('".addslashes($term)."') ORDER BY timestamp DESC";
     $query       = mysql_db_query($jBlog["dbName"], $querystring);
     while($row = mysql_fetch_assoc($query)) {
 		$ret[] = $row;
-/*
-                 array("id"        => $row[0],
-        			   "timestamp" => $row[1],
-                       "comments"  => $row[2],
-                       "title"     => $row[3],
-                       "body"      => $row[4],
-                       "extended"  => $row[5]);
-*/
     }
-
     return $ret;
 }