aboutsummaryrefslogtreecommitdiffstats
path: root/include
diff options
context:
space:
mode:
authorrvelices <rv-github@modusoptimus.com>2008-07-01 02:10:13 +0000
committerrvelices <rv-github@modusoptimus.com>2008-07-01 02:10:13 +0000
commitecb61ba267303517603c82cb8ddb6127b6b1d9f6 (patch)
treebd0033afae702dbcd2832d731f383a9cf4c477bc /include
parent8908a2d01d3c125fb7265ba86d72ed972533437e (diff)
- 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
Diffstat (limited to '')
-rw-r--r--include/functions_tag.inc.php12
1 files changed, 5 insertions, 7 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))
{