diff options
author | rvelices <rv-github@modusoptimus.com> | 2007-10-12 03:27:34 +0000 |
---|---|---|
committer | rvelices <rv-github@modusoptimus.com> | 2007-10-12 03:27:34 +0000 |
commit | 4afa14cc8d3f26f841c92b083355004251d75087 (patch) | |
tree | 99606ff8bf43f5c30f50d191f3593a5ca6a43260 /qsearch.php | |
parent | 36e0e6e8f1a455367f363048fc1825aebbd67eee (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.php | 24 |
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( |