history - merge album/tags link into a single column (table is already very large and these columns are mutually exclusive

- add tags link in the history table

git-svn-id: http://piwigo.org/svn/trunk@23151 68402e56-0260-453c-a942-63ccdbb3a9ee

1 files changed, 7 insertions, 2 deletions

diff --git a/admin/history.php b/admin/history.php
index 0412113f5..25a25ee67 100644
--- a/admin/history.php
+++ b/admin/history.php
@@ -337,9 +337,14 @@ SELECT
     $query = '
 SELECT
     id,
-    name
+    name, url_name
   FROM '.TAGS_TABLE;
-    $name_of_tag = simple_hash_from_query($query, 'id', 'name');
+    $name_of_tag = array();
+    $result = pwg_query($query);
+    while ($row=pwg_db_fetch_assoc($result))
+    {
+      $name_of_tag[ $row['id'] ] = '<a href="'.make_index_url( array('tags'=>array($row))).'">'.trigger_event("render_tag_name", $row['name']).'</a>';
+    }
   }
 
   $i = 0;