From ecb61ba267303517603c82cb8ddb6127b6b1d9f6 Mon Sep 17 00:00:00 2001
From: rvelices <rv-github@modusoptimus.com>
Date: Tue, 1 Jul 2008 02:10:13 +0000
Subject: - tags improvement : pass to templates all fields in table #tags
 (handy for plugins such as type tags)

git-svn-id: http://piwigo.org/svn/branches/branch-1_7@2410 68402e56-0260-453c-a942-63ccdbb3a9ee
---
 include/functions_tag.inc.php | 12 +++++-------
 tags.php                      | 23 +++++++++++++----------
 2 files changed, 18 insertions(+), 17 deletions(-)

diff --git a/include/functions_tag.inc.php b/include/functions_tag.inc.php
index b631b1a45..dc3c1d50d 100644
--- a/include/functions_tag.inc.php
+++ b/include/functions_tag.inc.php
@@ -40,9 +40,9 @@ function get_available_tags()
 {
   // we can find top fatter tags among reachable images
   $tags_query = '
-SELECT id, name, url_name, count(*) counter
+SELECT t.*, count(*) counter
   FROM '.IMAGE_TAG_TABLE.'
-    INNER JOIN '.TAGS_TABLE.' ON tag_id = id';
+    INNER JOIN '.TAGS_TABLE.' t ON tag_id = id';
 
   $where_tag_img =
     get_sql_condition_FandF
@@ -101,9 +101,7 @@ SELECT DISTINCT image_id
 function get_all_tags()
 {
   $query = '
-SELECT id,
-       name,
-       url_name
+SELECT *
   FROM '.TAGS_TABLE.'
 ;';
   $result = pwg_query($query);
@@ -245,9 +243,9 @@ function get_common_tags($items, $max_tags, $excluded_tag_ids=null)
     return array();
   }
   $query = '
-SELECT id, name, url_name, count(*) counter
+SELECT t.*, count(*) counter
   FROM '.IMAGE_TAG_TABLE.'
-    INNER JOIN '.TAGS_TABLE.' ON tag_id = id
+    INNER JOIN '.TAGS_TABLE.' t ON tag_id = id
   WHERE image_id IN ('.implode(',', $items).')';
   if (!empty($excluded_tag_ids))
   {
diff --git a/tags.php b/tags.php
index 8ed0e36c6..131a68efd 100644
--- a/tags.php
+++ b/tags.php
@@ -91,16 +91,19 @@ foreach ($tags as $tag)
 {
   $template->assign_block_vars(
     'tag',
-    array(
-      'URL' => make_index_url(
-        array(
-          'tags' => array($tag),
-          )
-        ),
-
-      'NAME' => $tag['name'],
-      'TITLE' => $tag['counter'],
-      'CLASS' => 'tagLevel'.$tag['level'],
+    array_merge(
+      $tag,
+      array(
+        'URL' => make_index_url(
+          array(
+            'tags' => array($tag),
+            )
+          ),
+
+        'NAME' => $tag['name'],
+        'TITLE' => $tag['counter'],
+        'CLASS' => 'tagLevel'.$tag['level'],
+        )
       )
     );
 }
-- 
cgit v1.2.3