aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorrvelices <rv-github@modusoptimus.com>2007-02-14 05:45:20 +0000
committerrvelices <rv-github@modusoptimus.com>2007-02-14 05:45:20 +0000
commit58a359e3c17b711be1663985e5e7801407eb50ed (patch)
tree32afe0d1840980e83dabf9236a90925e657daf78
parentdf3b43d35601551c3344bf051cdef4ab67de505a (diff)
- fill #searches.last_seen column
- small correction on my previous commit (functions_tag.inc.php) - web service tags.getImages correction git-svn-id: http://piwigo.org/svn/trunk@1816 68402e56-0260-453c-a942-63ccdbb3a9ee
-rw-r--r--include/functions_tag.inc.php1
-rw-r--r--include/ws_functions.inc.php13
-rw-r--r--qsearch.php4
-rw-r--r--search.php4
4 files changed, 8 insertions, 14 deletions
diff --git a/include/functions_tag.inc.php b/include/functions_tag.inc.php
index c9f239ef7..4f8c95563 100644
--- a/include/functions_tag.inc.php
+++ b/include/functions_tag.inc.php
@@ -258,6 +258,7 @@ SELECT id, name, url_name, count(*) counter
if ($max_tags>0)
{
$query .= '
+ ORDER BY counter DESC
LIMIT 0,'.$max_tags;
}
diff --git a/include/ws_functions.inc.php b/include/ws_functions.inc.php
index 5c0221e7e..dca9740d1 100644
--- a/include/ws_functions.inc.php
+++ b/include/ws_functions.inc.php
@@ -656,7 +656,6 @@ function ws_session_getStatus($params, &$service)
*/
function ws_tags_getList($params, &$service)
{
- global $user;
$tags = get_available_tags();
if ($params['sort_by_counter'])
{
@@ -687,7 +686,7 @@ function ws_tags_getList($params, &$service)
function ws_tags_getImages($params, &$service)
{
@include_once(PHPWG_ROOT_PATH.'include/functions_picture.inc.php');
- global $user, $conf;
+ global $conf;
// first build all the tag_ids we are interested in
$tag_ids = array();
@@ -704,6 +703,8 @@ function ws_tags_getImages($params, &$service)
in_array($tag['name'], $params['tag_name'])
or
in_array($tag['url_name'], $params['tag_url_name'])
+ or
+ in_array($tag['id'], $params['tag_id'])
)
{
$tag_ids[] = $tag['id'];
@@ -711,14 +712,6 @@ function ws_tags_getImages($params, &$service)
}
unset($tags);
- foreach( $params['tag_id'] as $tag_id )
- {
- if ( (int)$tag_id > 0 )
- {
- $tag_ids[] = $tag_id;
- }
- }
-
$tag_ids = array_unique( $tag_ids );
$image_ids = array();
diff --git a/qsearch.php b/qsearch.php
index c993d4386..da5188196 100644
--- a/qsearch.php
+++ b/qsearch.php
@@ -37,9 +37,9 @@ $search['q']=$_GET['q'];
$query ='
INSERT INTO '.SEARCH_TABLE.'
- (rules)
+ (rules, last_seen)
VALUES
- (\''.serialize($search).'\')
+ (\''.serialize($search).'\', NOW() )
;';
pwg_query($query);
diff --git a/search.php b/search.php
index c8efc4719..22953bda3 100644
--- a/search.php
+++ b/search.php
@@ -134,9 +134,9 @@ if (isset($_POST['submit']))
// thumbnails page and picture page.
$query ='
INSERT INTO '.SEARCH_TABLE.'
- (rules)
+ (rules, last_seen)
VALUES
- (\''.serialize($search).'\')
+ (\''.serialize($search).'\', NOW())
;';
pwg_query($query);