From 4afa14cc8d3f26f841c92b083355004251d75087 Mon Sep 17 00:00:00 2001
From: rvelices <rv-github@modusoptimus.com>
Date: Fri, 12 Oct 2007 03:27:34 +0000
Subject: - 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
---
 qsearch.php | 24 ++++++++++++++++++++----
 1 file changed, 20 insertions(+), 4 deletions(-)

(limited to 'qsearch.php')

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(
-- 
cgit v1.2.3