[php-blog-cvs] serendipity db.sql,1.1.1.1,1.2 search.php,1.1.1.1,1.2 serendipity_functions.inc.php,1.3,1.4

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

Update of /cvsroot/php-blog/serendipity
In directory sc8-pr-cvs1:/tmp/cvs-serv1963

Modified Files:
	db.sql search.php serendipity_functions.inc.php 
Log Message:
make fulltext work


Index: db.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/db.sql,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -u -d -r1.1.1.1 -r1.2
--- db.sql	28 Mar 2003 20:05:24 -0000	1.1.1.1
+++ db.sql	29 Mar 2003 16:44:46 -0000	1.2
@@ -47,7 +47,7 @@
   categoryid int(11) default null
 );
 
-CREATE {FULLTEXT} INDEX title on {PREFIX}entries (title,body,extended);
+CREATE FULLTEXT INDEX entry on {PREFIX}entries (title,body,extended);
 
 #
 # table structure for table '{PREFIX}references'

Index: search.php
===================================================================
RCS file: /cvsroot/php-blog/serendipity/search.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -u -d -r1.1.1.1 -r1.2
--- search.php	28 Mar 2003 20:05:26 -0000	1.1.1.1
+++ search.php	29 Mar 2003 16:44:46 -0000	1.2
@@ -1,5 +1,5 @@
 <?php
 session_start();
 include_once("serendipity_config.inc.php");
-include_once("serendipity_genpage.php");
+include_once("serendipity_genpage.inc.php");
 ?>

Index: serendipity_functions.inc.php
===================================================================
RCS file: /cvsroot/php-blog/serendipity/serendipity_functions.inc.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- serendipity_functions.inc.php	29 Mar 2003 16:13:08 -0000	1.3
+++ serendipity_functions.inc.php	29 Mar 2003 16:44:46 -0000	1.4
@@ -253,7 +253,7 @@
 	global $serendipity;
 
     $querystring = "SELECT id, author, timestamp, comments, title, body, extended FROM ".$serendipity["dbPrefix"]."entries
-                    WHERE MATCH (title, extended, body) AGAINST ('".addslashes($term)."') ORDER BY timestamp DESC";
+                    WHERE MATCH (title,body,extended) AGAINST ('".addslashes($term)."') ORDER BY timestamp DESC";
 
 	return serendipity_db_query($querystring);
 }