| 0,0 → 1,109 |
|---|
| <?php |
| // +-----------------------------------------------------------------------+ |
| // | PhpWebGallery - a PHP based picture gallery | |
| // | Copyright (C) 2002-2003 Pierrick LE GALL - pierrick@phpwebgallery.net | |
| // | Copyright (C) 2003-2005 PhpWebGallery Team - http://phpwebgallery.net | |
| // +-----------------------------------------------------------------------+ |
| // | branch : BSF (Best So Far) |
| // | file : $RCSfile: functions_group.inc.php,v $ |
| // | last update : $Date: 2005/01/07 23:10:51 $ |
| // | last modifier : $Author: plg $ |
| // | revision : $Revision: 1.8 $ |
| // +-----------------------------------------------------------------------+ |
| // | This program is free software; you can redistribute it and/or modify | |
| // | it under the terms of the GNU General Public License as published by | |
| // | the Free Software Foundation | |
| // | | |
| // | This program is distributed in the hope that it will be useful, but | |
| // | WITHOUT ANY WARRANTY; without even the implied warranty of | |
| // | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU | |
| // | General Public License for more details. | |
| // | | |
| // | You should have received a copy of the GNU General Public License | |
| // | along with this program; if not, write to the Free Software | |
| // | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, | |
| // | USA. | |
| // +-----------------------------------------------------------------------+ |
| |
| // get_group_restrictions returns an array containing all unaccessible |
| // category ids. |
| function get_group_restrictions( $group_id ) |
| { |
| // 1. retrieving ids of private categories |
| $query = 'SELECT id FROM '.CATEGORIES_TABLE; |
| $query.= " WHERE status = 'private'"; |
| $query.= ';'; |
| $result = pwg_query( $query ); |
| $privates = array(); |
| while ( $row = mysql_fetch_array( $result ) ) |
| { |
| array_push( $privates, $row['id'] ); |
| } |
| // 2. retrieving all authorized categories for the group |
| $authorized = array(); |
| $query = 'SELECT cat_id FROM '.GROUP_ACCESS_TABLE; |
| $query.= ' WHERE group_id = '.$group_id; |
| $query.= ';'; |
| $result = pwg_query( $query ); |
| while ( $row = mysql_fetch_array( $result ) ) |
| { |
| array_push( $authorized, $row['cat_id'] ); |
| } |
| |
| $forbidden = array(); |
| foreach ( $privates as $private ) { |
| if ( !in_array( $private, $authorized ) ) |
| { |
| array_push( $forbidden, $private ); |
| } |
| } |
| |
| return $forbidden; |
| } |
| |
| // get_all_group_restrictions returns an array with ALL unaccessible |
| // category ids, including sub-categories |
| function get_all_group_restrictions( $group_id ) |
| { |
| $restricted_cats = get_group_restrictions( $group_id ); |
| foreach ( $restricted_cats as $restricted_cat ) { |
| $sub_restricted_cats = get_subcats_id( $restricted_cat ); |
| foreach ( $sub_restricted_cats as $sub_restricted_cat ) { |
| array_push( $restricted_cats, $sub_restricted_cat ); |
| } |
| } |
| return $restricted_cats; |
| } |
| |
| // The function is_group_allowed returns : |
| // - 0 : if the category is allowed with this $restrictions array |
| // - 1 : if this category is not allowed |
| // - 2 : if an uppercat category is not allowed |
| function is_group_allowed( $category_id, $restrictions ) |
| { |
| $lowest_category_id = $category_id; |
| |
| $is_root = false; |
| while ( !$is_root and !in_array( $category_id, $restrictions ) ) |
| { |
| $query = 'SELECT id_uppercat FROM '.CATEGORIES_TABLE; |
| $query.= ' WHERE id = '.$category_id; |
| $query.= ';'; |
| $row = mysql_fetch_array( pwg_query( $query ) ); |
| if ( !isset( $row['id_uppercat'] ) ) $row['id_uppercat'] = ''; |
| if ( $row['id_uppercat'] == '' ) $is_root = true; |
| $category_id = $row['id_uppercat']; |
| } |
| |
| if ( in_array( $lowest_category_id, $restrictions ) ) |
| { |
| return 1; |
| } |
| if ( in_array( $category_id, $restrictions ) ) |
| { |
| return 2; |
| } |
| // this group is allowed to go in this category |
| return 0; |
| } |
| ?> |