Changeset 1891

Timestamp:

Mar 11, 2007, 4:11:53 PM (17 years ago)

Author:

plg

Message:

New: in history search, display tag names instead of tag ids in filtered
lines.

File:

• trunk/admin/history.php (modified) (5 diffs)

trunk/admin/history.php

@@ -303 +303 @@
     }
 
+    if (isset($row['tag_ids']))
+    {
+      foreach (explode(',', $row['tag_ids']) as $tag_id)
+      {
+        array_push($tag_ids, $tag_id);
+      }
+    }
+
     array_push(
       $history_lines,
@@ -379 +387 @@
 
     // echo '<pre>'; print_r($high_filesize_of_image); echo '</pre>';
+  }
+
+  if (count($tag_ids) > 0)
+  {
+    $tag_ids = array_unique($tag_ids);
+
+    $query = '
+SELECT
+    id,
+    name
+  FROM '.TAGS_TABLE.'
+  WHERE id IN ('.implode(', ', $tag_ids).')
+;';
+    $name_of_tag = array();
+
+    $result = pwg_query($query);
+    while ($row = mysql_fetch_array($result))
+    {
+      $name_of_tag[ $row['id'] ] = $row['name'];
+    }
   }
   
@@ -428 +456 @@
     $user_string.= '&amp;user_id='.$line['user_id'];
     $user_string.= '">+</a>';
+
+    $tags_string = '';
+    if (isset($line['tag_ids']))
+    {
+      $tags_string = preg_replace(
+        '/(\d+)/e',
+        '$name_of_tag["$1"]',
+        str_replace(
+          ',',
+          ', ',
+          $line['tag_ids']
+          )
+        );
+    }
     
     $template->assign_block_vars(
@@ -456 +498 @@
                 : 'deleted '.$line['category_id'] )
           : '',
-        'TAGS'       => $line['tag_ids'],
+        'TAGS'       => $tags_string,
         'T_CLASS'   => ($i % 2) ? 'row1' : 'row2',
         )
@@ -602 +644 @@
   $selected = '';
 
-  if ($row['id'] == $form['user'])
+  if (isset($form['user'])
+      and $row['id'] == $form['user'])
   {
     $selected = 'selected="selected"';