From e22eb49fec3e82a49cefc9a90d5a39e4453fa58f Mon Sep 17 00:00:00 2001
From: z0rglub <z0rglub@piwigo.org>
Date: Thu, 21 Oct 2004 21:17:07 +0000
Subject: new feature : related categories are displayed under the picture

git-svn-id: http://piwigo.org/svn/trunk@568 68402e56-0260-453c-a942-63ccdbb3a9ee
---
 picture.php | 33 ++++++++++++++++++++++++++++++---
 1 file changed, 30 insertions(+), 3 deletions(-)

diff --git a/picture.php b/picture.php
index a94b7ff68..94bba0c0c 100644
--- a/picture.php
+++ b/picture.php
@@ -714,9 +714,36 @@ SELECT COUNT(rate) AS count
       'VALUE' => $value
       ));
 }
-
-//metadata
-
+// related categories
+$query = '
+SELECT category_id
+  FROM '.IMAGE_CATEGORY_TABLE.'
+  WHERE image_id = '.$_GET['image_id'];
+if ($user['forbidden_categories'] != '')
+{
+  $query.= '
+    AND category_id NOT IN ('.$user['forbidden_categories'].')';
+}
+$query.= '
+;';
+$result = mysql_query($query);
+$categories = '';
+while ($row = mysql_fetch_array($result))
+{
+  if ($categories != '')
+  {
+    $categories.= '<br />';
+  }
+  $cat_info = get_cat_info($row['category_id']);
+  $categories .= get_cat_display_name($cat_info['name'], ' &gt;');
+}
+$template->assign_block_vars(
+  'info_line',
+  array(
+    'INFO'  => $lang['categories'],
+    'VALUE' => $categories
+    ));
+// metadata
 if ($metadata_showable and isset($_GET['show_metadata']))
 {
   include_once(PHPWG_ROOT_PATH.'/include/functions_metadata.inc.php');
-- 
cgit v1.2.3