- 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

git-svn-id: http://piwigo.org/svn/trunk@2135 68402e56-0260-453c-a942-63ccdbb3a9ee

1 files changed, 20 insertions, 4 deletions

diff --git a/qsearch.php b/qsearch.php
index 2635ea31a..a53d9fa3e 100644
--- a/qsearch.php
+++ b/qsearch.php
@@ -39,15 +39,31 @@ if (empty($_GET['q']))
 $search = array();
 $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)
   VALUES
   (\''.addslashes(serialize($search)).'\', NOW() )
 ;';
-pwg_query($query);
-
-$search_id = mysql_insert_id();
+  pwg_query($query);
+  $search_id = mysql_insert_id();
+}
 
 redirect(
   make_index_url(