Changeset 1815 for trunk/include/ws_functions.inc.php

Timestamp:

Feb 14, 2007, 2:37:38 AM (17 years ago)

Author:

rvelices

Message:

tags returned by get_all_tags, get_available_tags contain id key instead of tag_id
(as expected by make_index_url, as $pagetags was and as the database model is)

File:

• trunk/include/ws_functions.inc.php (modified) (4 diffs)

trunk/include/ws_functions.inc.php

@@ -538 +538 @@
 
   //-------------------------------------------------------------- related tags
-  $query = '
-SELECT id, name, url_name
-  FROM '.IMAGE_TAG_TABLE.'
-    INNER JOIN '.TAGS_TABLE.' ON tag_id = id
-  WHERE image_id = '.$image_row['id'].'
-;';
-  $result = pwg_query($query);
-  $related_tags = array();
-  while ($row = mysql_fetch_assoc($result))
-  {
-    $row['url'] = make_index_url(
+  $related_tags = get_common_tags( array($image_row['id']), -1 );
+  foreach( $related_tags as $i=>$tag)
+  {
+    $tag['url'] = make_index_url(
         array(
-          'tags' => array($row)
+          'tags' => array($tag)
           )
       );
-    $row['page_url'] = make_picture_url(
+    $tag['page_url'] = make_picture_url(
         array(
           'image_id' => $image_row['id'],
           'image_file' => $image_row['file'],
-          'tags' => array($row),
+          'tags' => array($tag),
           )
       );
-    array_push($related_tags, $row);
+    unset($tag['counter']);
+    $related_tags[$i]=$tag;
   }
   //---------------------------------------------------------- related comments
@@ -675 +669 @@
   for ($i=0; $i<count($tags); $i++)
   {
-    $tags[$i]['id'] = (int)$tags[$i]['tag_id'];
+    $tags[$i]['id'] = (int)$tags[$i]['id'];
     $tags[$i]['counter'] = (int)$tags[$i]['counter'];
-    unset($tags[$i]['tag_id']);
     $tags[$i]['url'] = make_index_url(
         array(
@@ -703 +696 @@
   for( $i=0; $i<count($tags); $i++ )
   {
-    $tags[$i]['tag_id']=(int)$tags[$i]['tag_id'];
-    $tags[$i]['id']=(int)$tags[$i]['tag_id']; //required by make_xxx_url
+    $tags[$i]['id']=(int)$tags[$i]['id'];
   }
   foreach( $tags as $tag )
   {
-    $tags_by_id[ $tag['tag_id'] ] = $tag;
+    $tags_by_id[ $tag['id'] ] = $tag;
     if (
         in_array($tag['name'], $params['tag_name'])
@@ -715 +707 @@
        )
     {
-      $tag_ids[] = $tag['tag_id'];
+      $tag_ids[] = $tag['id'];
     }
   }