aboutsummaryrefslogtreecommitdiffstats
path: root/qsearch.php
diff options
context:
space:
mode:
authorrvelices <rv-github@modusoptimus.com>2007-10-12 03:27:34 +0000
committerrvelices <rv-github@modusoptimus.com>2007-10-12 03:27:34 +0000
commit4afa14cc8d3f26f841c92b083355004251d75087 (patch)
tree99606ff8bf43f5c30f50d191f3593a5ca6a43260 /qsearch.php
parent36e0e6e8f1a455367f363048fc1825aebbd67eee (diff)
- 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
Diffstat (limited to 'qsearch.php')
-rw-r--r--qsearch.php24
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(