From b35dc19ab6da173cc663e49cb32389d7e6dbfdee Mon Sep 17 00:00:00 2001 From: gweltas Date: Thu, 2 Dec 2004 15:42:57 +0000 Subject: Update of the user preferences panel. Deletion of some PREFIX_TABLE occurences git-svn-id: http://piwigo.org/svn/trunk@630 68402e56-0260-453c-a942-63ccdbb3a9ee --- include/functions_group.inc.php | 9 +++------ 1 file changed, 3 insertions(+), 6 deletions(-) (limited to 'include/functions_group.inc.php') diff --git a/include/functions_group.inc.php b/include/functions_group.inc.php index 8fc6408ad..b02b005f1 100644 --- a/include/functions_group.inc.php +++ b/include/functions_group.inc.php @@ -30,8 +30,7 @@ function get_group_restrictions( $group_id ) { // 1. retrieving ids of private categories - $query = 'SELECT id'; - $query.= ' FROM '.PREFIX_TABLE.'categories'; + $query = 'SELECT id FROM '.CATEGORIES_TABLE; $query.= " WHERE status = 'private'"; $query.= ';'; $result = pwg_query( $query ); @@ -42,8 +41,7 @@ function get_group_restrictions( $group_id ) } // 2. retrieving all authorized categories for the group $authorized = array(); - $query = 'SELECT cat_id'; - $query.= ' FROM '.PREFIX_TABLE.'group_access'; + $query = 'SELECT cat_id FROM '.GROUP_ACCESS_TABLE; $query.= ' WHERE group_id = '.$group_id; $query.= ';'; $result = pwg_query( $query ); @@ -88,8 +86,7 @@ function is_group_allowed( $category_id, $restrictions ) $is_root = false; while ( !$is_root and !in_array( $category_id, $restrictions ) ) { - $query = 'SELECT id_uppercat'; - $query.= ' FROM '.PREFIX_TABLE.'categories'; + $query = 'SELECT id_uppercat FROM '.CATEGORIES_TABLE; $query.= ' WHERE id = '.$category_id; $query.= ';'; $row = mysql_fetch_array( pwg_query( $query ) ); -- cgit v1.2.3