Changeset 1816

Timestamp:

Feb 14, 2007, 6:45:20 AM (17 years ago)

Author:

rvelices

Message:

• fill #searches.last_seen column
• small correction on my previous commit (functions_tag.inc.php)
• web service tags.getImages correction

Location:

trunk

Files:

• include/functions_tag.inc.php (modified) (1 diff)
• include/ws_functions.inc.php (modified) (4 diffs)
• qsearch.php (modified) (1 diff)
• search.php (modified) (1 diff)

trunk/include/functions_tag.inc.php

@@ -259 +259 @@
   {
     $query .= '
+  ORDER BY counter DESC
   LIMIT 0,'.$max_tags;
   }

trunk/include/ws_functions.inc.php

@@ -657 +657 @@
 function ws_tags_getList($params, &$service)
 {
-  global $user;
   $tags = get_available_tags();
   if ($params['sort_by_counter'])
@@ -688 +687 @@
 {
   @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
@@ -705 +704 @@
       or
         in_array($tag['url_name'], $params['tag_url_name'])
+      or
+        in_array($tag['id'], $params['tag_id'])
        )
     {
@@ -711 +712 @@
   }
   unset($tags);
-
-  foreach( $params['tag_id'] as $tag_id )
-  {
-    if ( (int)$tag_id > 0 )
-    {
-      $tag_ids[] = $tag_id;
-    }
-  }
 
   $tag_ids = array_unique( $tag_ids );

trunk/qsearch.php

@@ -38 +38 @@
 $query ='
 INSERT INTO '.SEARCH_TABLE.'
-  (rules)
+  (rules, last_seen)
   VALUES
-  (\''.serialize($search).'\')
+  (\''.serialize($search).'\', NOW() )
 ;';
 pwg_query($query);

trunk/search.php

@@ -135 +135 @@
     $query ='
 INSERT INTO '.SEARCH_TABLE.'
-  (rules)
+  (rules, last_seen)
   VALUES
-  (\''.serialize($search).'\')
+  (\''.serialize($search).'\', NOW())
 ;';
     pwg_query($query);