From b57ab43510656863f6e8303115a03a0479808f9b Mon Sep 17 00:00:00 2001 From: rvelices Date: Thu, 25 Oct 2012 20:01:14 +0000 Subject: related categories on picture page contain status and visible db fields (useful for example for "social" plugins to know if a photo is public or not) git-svn-id: http://piwigo.org/svn/trunk@18747 68402e56-0260-453c-a942-63ccdbb3a9ee --- include/picture_comment.inc.php | 2 +- picture.php | 14 ++++---------- 2 files changed, 5 insertions(+), 11 deletions(-) diff --git a/include/picture_comment.inc.php b/include/picture_comment.inc.php index 5d007d4ea..df823edbc 100644 --- a/include/picture_comment.inc.php +++ b/include/picture_comment.inc.php @@ -31,7 +31,7 @@ $page['show_comments'] = false; foreach ($related_categories as $category) { - if ($category['commentable']) + if ($category['commentable']=='true') { $page['show_comments'] = true; break; diff --git a/picture.php b/picture.php index d291de151..e394ddf96 100644 --- a/picture.php +++ b/picture.php @@ -453,7 +453,7 @@ UPDATE //---------------------------------------------------------- related categories $query = ' -SELECT category_id,uppercats,commentable,global_rank +SELECT id,uppercats,commentable,visible,status,global_rank FROM '.IMAGE_CATEGORY_TABLE.' INNER JOIN '.CATEGORIES_TABLE.' ON category_id = id WHERE image_id = '.$page['image_id'].' @@ -461,19 +461,13 @@ SELECT category_id,uppercats,commentable,global_rank ( array ( - 'forbidden_categories' => 'category_id', - 'visible_categories' => 'category_id' + 'forbidden_categories' => 'id', + 'visible_categories' => 'id' ), 'AND' ).' ;'; -$result = pwg_query($query); -$related_categories = array(); -while ($row = pwg_db_fetch_assoc($result)) -{ - $row['commentable'] = get_boolean($row['commentable']); - array_push($related_categories, $row); -} +$related_categories = array_from_query($query); usort($related_categories, 'global_rank_compare'); //-------------------------first, prev, current, next & last picture management $picture = array(); -- cgit v1.2.3