Changeset 2135 for trunk/qsearch.php

Timestamp:

Oct 12, 2007, 5:27:34 AM (17 years ago)

Author:

rvelices

Message:

• fix plugin menu link broken with xamp (realpath behaves differently)
• complete quick search rewriting
  • now we can quote phrases as in google "New York" is not the same as New York
  • user comments not searched anymore (faster)
  • the big full text query does not use joins anymore (faster)
  • related tags not shown on the index page, but now you can see the matching tags and matching categories

File:

• trunk/qsearch.php (modified) (2 diffs)

trunk/qsearch.php

@@ -40 +40 @@
 $search['q']=$_GET['q'];
 
-$query ='
+$query = '
+SElECT id FROM '.SEARCH_TABLE.'
+  WHERE rules = \''.addslashes(serialize($search)).'\'
+;';
+$search_id = array_from_query( $query, 'id');
+if ( !empty($search_id) )
+{
+  $search_id = $search_id[0];
+  $query = '
+UPDATE '.SEARCH_TABLE.'
+  SET last_seen=NOW()
+  WHERE id='.$search_id;
+  pwg_query($query);
+}
+else
+{
+  $query ='
 INSERT INTO '.SEARCH_TABLE.'
   (rules, last_seen)
@@ -46 +62 @@
   (\''.addslashes(serialize($search)).'\', NOW() )
 ;';
-pwg_query($query);
-
-$search_id = mysql_insert_id();
+  pwg_query($query);
+  $search_id = mysql_insert_id();
+}
 
 redirect(