From 9a5f45d31446019840d3052b31c06d1f43fb12ed Mon Sep 17 00:00:00 2001
From: z0rglub <z0rglub@piwigo.org>
Date: Sat, 3 Jan 2004 20:58:07 +0000
Subject: usage of database info users.forbidden_categories

git-svn-id: http://piwigo.org/svn/branches/release-1_3@250 68402e56-0260-453c-a942-63ccdbb3a9ee
---
 comments.php | 11 +++--------
 1 file changed, 3 insertions(+), 8 deletions(-)

diff --git a/comments.php b/comments.php
index 83fe67e08..e4159a107 100644
--- a/comments.php
+++ b/comments.php
@@ -169,15 +169,10 @@ $query.=     ', '.PREFIX_TABLE.'image_category AS ic';
 $query.= ' WHERE c.image_id = ic.image_id';
 $query.= ' AND date > '.$maxtime;
 // we must not show pictures of a forbidden category
-$restricted_cats = get_all_restrictions( $user['id'],$user['status'] );
-if ( count( $restricted_cats ) > 0 )
+if ( $user['forbidden_categories'] != '' )
 {
-  $query.= ' AND category_id NOT IN (';
-  foreach ( $restricted_cats as $i => $restricted_cat ) {
-    if ( $i > 0 ) $query.= ',';
-    $query.= $restricted_cat;
-  }
-  $query.= ')';
+  $query.= ' AND category_id NOT IN ';
+  $query.= '('.$user['forbidden_categories'].')';
 }
 $query.= ' ORDER BY ic.image_id DESC';
 $query.= ';';
-- 
cgit v1.2.3