aboutsummaryrefslogtreecommitdiffstats
path: root/include/functions_category.inc.php
diff options
context:
space:
mode:
authorz0rglub <z0rglub@piwigo.org>2004-01-25 22:05:43 +0000
committerz0rglub <z0rglub@piwigo.org>2004-01-25 22:05:43 +0000
commit9667411577982b2289c79bdf0e2cc30bfbf2d19b (patch)
tree47f8e8ce068362d4710299cd998557ad168aa0b2 /include/functions_category.inc.php
parente39dc7c0ab3aef034bd5b8720b2b7ea1a21f96a7 (diff)
didn't take correctly into account forbidden categories
git-svn-id: http://piwigo.org/svn/branches/release-1_3@320 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
-rw-r--r--include/functions_category.inc.php19
1 files changed, 9 insertions, 10 deletions
diff --git a/include/functions_category.inc.php b/include/functions_category.inc.php
index beacda9e1..77f0234a3 100644
--- a/include/functions_category.inc.php
+++ b/include/functions_category.inc.php
@@ -407,7 +407,7 @@ function get_cat_display_name( $array_cat_names, $separation,
function initialize_category( $calling_page = 'category' )
{
pwg_debug( 'start initialize_category' );
- global $page,$lang,$user,$conf, $where_append;
+ global $page,$lang,$user,$conf;
if ( isset( $page['cat'] ) )
{
@@ -416,10 +416,7 @@ function initialize_category( $calling_page = 'category' )
$page['nb_image_page'] = $user['nb_image_page'];
// $url is used to create the navigation bar
$url = './category.php?cat='.$page['cat'];
- if ( isset($page['expand']) )
- {
- $url.= '&amp;expand='.$page['expand'];
- }
+ if ( isset($page['expand']) ) $url.= '&amp;expand='.$page['expand'];
// simple category
if ( is_numeric( $page['cat'] ) )
{
@@ -442,8 +439,8 @@ function initialize_category( $calling_page = 'category' )
// we must not show pictures of a forbidden category
if ( $user['forbidden_categories'] != '' )
{
- $query.= ' AND category_id NOT IN ';
- $query.= '('.$user['forbidden_categories'].')';
+ $forbidden = ' category_id NOT IN ';
+ $forbidden.= '('.$user['forbidden_categories'].')';
}
}
// search result
@@ -488,7 +485,7 @@ function initialize_category( $calling_page = 'category' )
}
}
$page['where'].= ' )';
- $page['where'].= $where_append;
+ if ( isset( $forbidden ) ) $page['where'].= ' AND '.$forbidden;
$query = 'SELECT COUNT(DISTINCT(id)) AS nb_total_images';
$query.= ' FROM '.PREFIX_TABLE.'images';
@@ -522,7 +519,7 @@ function initialize_category( $calling_page = 'category' )
$date = time() - 60*60*24*$user['short_period'];
$page['where'] = " WHERE date_available > '";
$page['where'].= date( 'Y-m-d', $date )."'";
- $page['where'].= $where_append;
+ if ( isset( $forbidden ) ) $page['where'].= ' AND '.$forbidden;
$query = 'SELECT COUNT(DISTINCT(id)) AS nb_total_images';
$query.= ' FROM '.PREFIX_TABLE.'images';
@@ -535,7 +532,9 @@ function initialize_category( $calling_page = 'category' )
else if ( $page['cat'] == 'most_visited' )
{
$page['title'] = $conf['top_number'].' '.$lang['most_visited_cat'];
- $page['where'] = ' WHERE category_id != -1'.$where_append;
+
+ if ( isset( $forbidden ) ) $page['where'] = ' WHERE '.$forbidden;
+ else $page['where'] = '';
$conf['order_by'] = ' ORDER BY hit DESC, file ASC';
$page['cat_nb_images'] = $conf['top_number'];
if ( isset( $page['start'] )