Go to most recent revision | Blame | Last modification | View Log | Download
<?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_category.inc.php,v $// | last update : $Date: 2005/05/02 20:59:47 $// | last modifier : $Author: plg $// | revision : $Revision: 1.66.2.1 $// +-----------------------------------------------------------------------+// | 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. |// +-----------------------------------------------------------------------+/*** Provides functions to handle categories.***//*** Is the category accessible to the connected user ?** Note : if the user is not authorized to see this category, page creation* ends (exit command in this function)** @param int category id to verify* @return void*/function check_restrictions( $category_id ){global $user,$lang;if ( in_array( $category_id, $user['restrictions'] ) ){echo '<div style="text-align:center;">'.$lang['access_forbiden'].'<br />';echo '<a href="'.add_session_id( './category.php' ).'">';echo $lang['thumbnails'].'</a></div>';exit();}}/*** Checks whether the argument is a right parameter category id** The argument is a right parameter if corresponds to one of these :** - is numeric and corresponds to a category in the database* - equals 'fav' (for favorites)* - equals 'search' (when the result of a search is displayed)* - equals 'most_visited'* - equals 'best_rated'* - equals 'recent_pics'* - equals 'recent_cats'* - equals 'calendar'* - equals 'list'** The function fills the global var $page['cat'] and returns nothing** @param mixed category id or special category name* @return void*/function check_cat_id( $cat ){global $page;unset( $page['cat'] );if ( isset( $cat ) ){if ( isset( $page['plain_structure'][$cat] ) ){$page['cat'] = $cat;}else if ( is_numeric( $cat ) ){$query = 'SELECT id';$query.= ' FROM '.CATEGORIES_TABLE.' WHERE id = '.$cat.';';$result = pwg_query( $query );if ( mysql_num_rows( $result ) != 0 ){$page['cat'] = $cat;}}if ( $cat == 'fav'or $cat == 'most_visited'or $cat == 'best_rated'or $cat == 'recent_pics'or $cat == 'recent_cats'or $cat == 'calendar' ){$page['cat'] = $cat;}if ($cat == 'search' and isset($_GET['search'])){$page['cat'] = $cat;}if ($cat == 'list'and isset($_GET['list'])and preg_match('/^\d+(,\d+)*$/', $_GET['list'])){$page['cat'] = 'list';}}}function get_categories_menu(){global $page,$user;$infos = array('');$query = 'SELECT name,id,date_last,nb_images,global_rankFROM '.CATEGORIES_TABLE.'WHERE 1 = 1'; // stupid but permit using AND after it !if (!$user['expand']){$query.= 'AND (id_uppercat is NULL';if (isset ($page['tab_expand']) and count($page['tab_expand']) > 0){$query.= ' OR id_uppercat IN ('.implode(',',$page['tab_expand']).')';}$query.= ')';}if ($user['forbidden_categories'] != ''){$query.= 'AND id NOT IN ('.$user['forbidden_categories'].')';}$query.= ';';$result = pwg_query($query);$cats = array();while ($row = mysql_fetch_array($result)){array_push($cats, $row);}usort($cats, 'global_rank_compare');return get_html_menu_category($cats);}function count_user_total_images(){global $user;$query = 'SELECT SUM(nb_images) AS total';$query.= ' FROM '.CATEGORIES_TABLE;if ( count( $user['restrictions'] ) > 0 )$query.= ' WHERE id NOT IN ('.$user['forbidden_categories'].')';$query.= ';';$row = mysql_fetch_array( pwg_query( $query ) );if ( !isset( $row['total'] ) ) $row['total'] = 0;return $row['total'];}/*** Retrieve informations about a category in the database** Returns an array with following keys :** - comment* - dir : directory, might be empty for virtual categories* - name : an array with indexes from 0 (lowest cat name) to n (most* uppercat name findable)* - nb_images* - id_uppercat* - site_id* -** @param int category id* @return array*/function get_cat_info( $id ){$infos = array('nb_images','id_uppercat','comment','site_id','dir','date_last','uploadable','status','visible','representative_picture_id','uppercats','commentable');$query = 'SELECT '.implode(',', $infos).'FROM '.CATEGORIES_TABLE.'WHERE id = '.$id.';';$row = mysql_fetch_array(pwg_query($query));$cat = array();foreach ($infos as $info){if (isset($row[$info])){$cat[$info] = $row[$info];}else{$cat[$info] = '';}// If the field is true or false, the variable is transformed into a// boolean value.if ($cat[$info] == 'true' or $cat[$info] == 'false'){$cat[$info] = get_boolean( $cat[$info] );}}$cat['comment'] = nl2br($cat['comment']);$names = array();$query = 'SELECT name,idFROM '.CATEGORIES_TABLE.'WHERE id IN ('.$cat['uppercats'].');';$result = pwg_query($query);while($row = mysql_fetch_array($result)){$names[$row['id']] = $row['name'];}// category names must be in the same order than uppercats list$cat['name'] = array();foreach (explode(',', $cat['uppercats']) as $cat_id){$cat['name'][$cat_id] = $names[$cat_id];}return $cat;}// get_complete_dir returns the concatenation of get_site_url and// get_local_dir// Example : "pets > rex > 1_year_old" is on the the same site as the// PhpWebGallery files and this category has 22 for identifier// get_complete_dir(22) returns "./galleries/pets/rex/1_year_old/"function get_complete_dir( $category_id ){return get_site_url($category_id).get_local_dir($category_id);}// get_local_dir returns an array with complete path without the site url// Example : "pets > rex > 1_year_old" is on the the same site as the// PhpWebGallery files and this category has 22 for identifier// get_local_dir(22) returns "pets/rex/1_year_old/"function get_local_dir( $category_id ){global $page;$uppercats = '';$local_dir = '';if ( isset( $page['plain_structure'][$category_id]['uppercats'] ) ){$uppercats = $page['plain_structure'][$category_id]['uppercats'];}else{$query = 'SELECT uppercats';$query.= ' FROM '.CATEGORIES_TABLE.' WHERE id = '.$category_id;$query.= ';';$row = mysql_fetch_array( pwg_query( $query ) );$uppercats = $row['uppercats'];}$upper_array = explode( ',', $uppercats );$database_dirs = array();$query = 'SELECT id,dir';$query.= ' FROM '.CATEGORIES_TABLE.' WHERE id IN ('.$uppercats.')';$query.= ';';$result = pwg_query( $query );while( $row = mysql_fetch_array( $result ) ){$database_dirs[$row['id']] = $row['dir'];}foreach ($upper_array as $id){$local_dir.= $database_dirs[$id].'/';}return $local_dir;}// retrieving the site url : "http://domain.com/gallery/" or// simply "./galleries/"function get_site_url($category_id){global $page;$query = 'SELECT galleries_urlFROM '.SITES_TABLE.' AS s,'.CATEGORIES_TABLE.' AS cWHERE s.id = c.site_idAND c.id = '.$category_id.';';$row = mysql_fetch_array(pwg_query($query));return $row['galleries_url'];}// initialize_category initializes ;-) the variables in relation// with category :// 1. calculation of the number of pictures in the category// 2. determination of the SQL query part to ask to find the right category// $page['where'] is not the same if we are in// - simple category// - search result// - favorites displaying// - most visited pictures// - best rated pictures// - recent pictures// - defined list (used for random)// 3. determination of the title of the page// 4. creation of the navigation barfunction initialize_category( $calling_page = 'category' ){pwg_debug( 'start initialize_category' );global $page,$lang,$user,$conf;if ( isset( $page['cat'] ) ){// $page['nb_image_page'] is the number of picture to display on this page// By default, it is the same as the $user['nb_image_page']$page['nb_image_page'] = $user['nb_image_page'];// $url is used to create the navigation bar$url = PHPWG_ROOT_PATH.'category.php?cat='.$page['cat'];if ( isset($page['expand']) ) $url.= '&expand='.$page['expand'];// simple categoryif ( is_numeric( $page['cat'] ) ){$result = get_cat_info( $page['cat'] );$page['comment'] = $result['comment'];$page['cat_dir'] = $result['dir'];$page['cat_name'] = $result['name'];$page['cat_nb_images'] = $result['nb_images'];$page['cat_site_id'] = $result['site_id'];$page['cat_uploadable'] = $result['uploadable'];$page['cat_commentable'] = $result['commentable'];$page['uppercats'] = $result['uppercats'];$page['title'] =get_cat_display_name($page['cat_name'],'',false);$page['where'] = ' WHERE category_id = '.$page['cat'];}else{if ($page['cat'] == 'search'or $page['cat'] == 'most_visited'or $page['cat'] == 'recent_pics'or $page['cat'] == 'recent_cats'or $page['cat'] == 'best_rated'or $page['cat'] == 'calendar'or $page['cat'] == 'list'){// we must not show pictures of a forbidden categoryif ( $user['forbidden_categories'] != '' ){$forbidden = ' category_id NOT IN ';$forbidden.= '('.$user['forbidden_categories'].')';}}// search resultif ( $page['cat'] == 'search' ){// analyze search string given in URL (created in search.php)$tokens = explode('|', $_GET['search']);if (isset($tokens[1]) and $tokens[1] == 'AND'){$search['mode'] = 'AND';}else{$search['mode'] = 'OR';}$search_tokens = explode('--', $tokens[0]);foreach ($search_tokens as $search_token){$tokens = explode(':', $search_token);$field_name = $tokens[0];$field_content = $tokens[1];$tokens = explode('~', $tokens[1]);if (isset($tokens[1])){$search['fields'][$field_name]['mode'] = $tokens[1];}else{$search['fields'][$field_name]['mode'] = '';}$search['fields'][$field_name]['words'] = array();$tokens = explode(',', $tokens[0]);foreach ($tokens as $token){array_push($search['fields'][$field_name]['words'],htmlentities($token));}}$page['title'] = $lang['search_result'];if ( $calling_page == 'picture' ){$page['title'].= ' : <span style="font-style:italic;">';$page['title'].= $_GET['search']."</span>";}// SQL where clauses are stored in $clauses array during query// construction$clauses = array();$textfields = array('file', 'name', 'comment', 'keywords', 'author');foreach ($textfields as $textfield){if (isset($search['fields'][$textfield])){$local_clauses = array();foreach ($search['fields'][$textfield]['words'] as $word){array_push($local_clauses, $textfield." LIKE '%".$word."%'");}// adds brackets around where clausesarray_walk($local_clauses,create_function('&$s','$s="(".$s.")";'));array_push($clauses,implode(' '.$search['fields'][$textfield]['mode'].' ',$local_clauses));}}if (isset($search['fields']['allwords'])){$fields = array('file', 'name', 'comment', 'keywords', 'author');// in the OR mode, request bust be :// ((field1 LIKE '%word1%' OR field2 LIKE '%word1%')// OR (field1 LIKE '%word2%' OR field2 LIKE '%word2%'))//// in the AND mode :// ((field1 LIKE '%word1%' OR field2 LIKE '%word1%')// AND (field1 LIKE '%word2%' OR field2 LIKE '%word2%'))$word_clauses = array();foreach ($search['fields']['allwords']['words'] as $word){$field_clauses = array();foreach ($fields as $field){array_push($field_clauses, $field." LIKE '%".$word."%'");}// adds brackets around where clausesarray_push($word_clauses, implode(' OR ', $field_clauses));}array_walk($word_clauses, create_function('&$s','$s="(".$s.")";'));array_push($clauses,implode(' '.$search['fields']['allwords']['mode'].' ',$word_clauses));}$datefields = array('date_available', 'date_creation');foreach ($datefields as $datefield){$key = $datefield;if (isset($search['fields'][$key])){$local_clause = $datefield." = '";$local_clause.= str_replace('.', '-',$search['fields'][$key]['words'][0]);$local_clause.= "'";array_push($clauses, $local_clause);}foreach (array('after','before') as $suffix){$key = $datefield.'-'.$suffix;if (isset($search['fields'][$key])){$local_clause = $datefield;if ($suffix == 'after'){$local_clause.= ' >';}else{$local_clause.= ' <';}if (isset($search['fields'][$key]['mode'])and $search['fields'][$key]['mode'] == 'inc'){$local_clause.= '=';}$local_clause.= " '";$local_clause.= str_replace('.', '-',$search['fields'][$key]['words'][0]);$local_clause.= "'";array_push($clauses, $local_clause);}}}if (isset($search['fields']['cat'])){if ($search['fields']['cat']['mode'] == 'sub_inc'){// searching all the categories id of sub-categories$cat_ids = get_subcat_ids($search['fields']['cat']['words']);}else{$cat_ids = $search['fields']['cat']['words'];}$local_clause = 'category_id IN ('.implode(',', $cat_ids).')';array_push($clauses, $local_clause);}// adds brackets around where clausesarray_walk($clauses, create_function('&$s', '$s = "(".$s.")";'));$page['where'] = 'WHERE '.implode(' '.$search['mode'].' ', $clauses);if ( isset( $forbidden ) ) $page['where'].= ' AND '.$forbidden;$query = 'SELECT COUNT(DISTINCT(id)) AS nb_total_imagesFROM '.IMAGES_TABLE.'INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id'.$page['where'].';';$url.= '&search='.$_GET['search'];}// favorites displayingelse if ( $page['cat'] == 'fav' ){check_user_favorites();$page['title'] = $lang['favorites'];$page['where'] = ', '.FAVORITES_TABLE.' AS fav';$page['where'].= ' WHERE user_id = '.$user['id'];$page['where'].= ' AND fav.image_id = id';$query = 'SELECT COUNT(*) AS nb_total_images';$query.= ' FROM '.FAVORITES_TABLE;$query.= ' WHERE user_id = '.$user['id'];$query.= ';';}// pictures within the short periodelse if ( $page['cat'] == 'recent_pics' ){$page['title'] = $lang['recent_pics_cat'];// We must find the date corresponding to :// today - $conf['periode_courte']$date = time() - 60*60*24*$user['recent_period'];$page['where'] = " WHERE date_available > '";$page['where'].= date( 'Y-m-d', $date )."'";if ( isset( $forbidden ) ) $page['where'].= ' AND '.$forbidden;$query = 'SELECT COUNT(DISTINCT(id)) AS nb_total_imagesFROM '.IMAGES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS icON id = ic.image_id'.$page['where'].';';}// categories containing recent pictureselse if ( $page['cat'] == 'recent_cats' ){$page['title'] = $lang['recent_cats_cat'];$page['cat_nb_images'] = 0;}// most visited pictureselse if ( $page['cat'] == 'most_visited' ){$page['title'] = $conf['top_number'].' '.$lang['most_visited_cat'];$page['where'] = 'WHERE hit > 0';if (isset($forbidden)){$page['where'] = "\n".' AND '.$forbidden;}$conf['order_by'] = ' ORDER BY hit DESC, file ASC';// $page['cat_nb_images'] equals $conf['top_number'] unless there// are less visited items$query ='SELECT COUNT(DISTINCT(id)) AS countFROM '.IMAGES_TABLE.'INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id'.$page['where'].';';$row = mysql_fetch_array(pwg_query($query));if ($row['count'] < $conf['top_number']){$page['cat_nb_images'] = $row['count'];}else{$page['cat_nb_images'] = $conf['top_number'];}unset($query);if ( isset( $page['start'] )and ($page['start']+$user['nb_image_page']>=$conf['top_number'])){$page['nb_image_page'] = $conf['top_number'] - $page['start'];}}else if ( $page['cat'] == 'calendar' ){$page['cat_nb_images'] = 0;$page['title'] = $lang['calendar'];if (isset($_GET['year'])and preg_match('/^\d+$/', $_GET['year'])){$page['calendar_year'] = (int)$_GET['year'];}if (isset($_GET['month'])and preg_match('/^(\d+)\.(\d{2})$/', $_GET['month'], $matches)){$page['calendar_year'] = (int)$matches[1];$page['calendar_month'] = (int)$matches[2];}if (isset($_GET['day'])and preg_match('/^(\d+)\.(\d{2})\.(\d{2})$/',$_GET['day'],$matches)){$page['calendar_year'] = (int)$matches[1];$page['calendar_month'] = (int)$matches[2];$page['calendar_day'] = (int)$matches[3];}if (isset($page['calendar_year'])){$page['title'] .= ' (';if (isset($page['calendar_day'])){if ($page['calendar_year'] >= 1970){$unixdate = mktime(0,0,0,$page['calendar_month'],$page['calendar_day'],$page['calendar_year']);$page['title'].= $lang['day'][date("w", $unixdate)];}$page['title'].= ' '.$page['calendar_day'].', ';}if (isset($page['calendar_month'])){$page['title'] .= $lang['month'][$page['calendar_month']].' ';}$page['title'] .= $page['calendar_year'];$page['title'] .= ')';}$page['where'] = 'WHERE '.$conf['calendar_datefield'].' IS NOT NULL';if (isset($forbidden)){$page['where'].= ' AND '.$forbidden;}}else if ($page['cat'] == 'best_rated'){$page['title'] = $conf['top_number'].' '.$lang['best_rated_cat'];$page['where'] = ' WHERE average_rate IS NOT NULL';if (isset($forbidden)){$page['where'].= ' AND '.$forbidden;}$conf['order_by'] = ' ORDER BY average_rate DESC, id ASC';// $page['cat_nb_images'] equals $conf['top_number'] unless there// are less rated items$query ='SELECT COUNT(DISTINCT(id)) AS countFROM '.IMAGES_TABLE.'INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id'.$page['where'].';';$row = mysql_fetch_array(pwg_query($query));if ($row['count'] < $conf['top_number']){$page['cat_nb_images'] = $row['count'];}else{$page['cat_nb_images'] = $conf['top_number'];}unset($query);if (isset($page['start'])and ($page['start']+$user['nb_image_page']>=$conf['top_number'])){$page['nb_image_page'] = $conf['top_number'] - $page['start'];}}else if ($page['cat'] == 'list'){$page['title'] = $lang['random_cat'];$page['where'] = 'WHERE 1=1';if (isset($forbidden)){$page['where'].= ' AND '.$forbidden;}$page['where'].= ' AND image_id IN ('.$_GET['list'].')';$page['cat_nb_images'] = count(explode(',', $_GET['list']));$url.= '&list='.$_GET['list'];}if (isset($query)){$result = pwg_query( $query );$row = mysql_fetch_array( $result );$page['cat_nb_images'] = $row['nb_total_images'];}}if ( $calling_page == 'category' ){$page['navigation_bar'] =create_navigation_bar( $url, $page['cat_nb_images'], $page['start'],$user['nb_image_page'], 'back' );}}else{$page['title'] = $lang['no_category'];}pwg_debug( 'end initialize_category' );}function display_select_categories($categories,$selecteds,$blockname,$fullname = true){global $template;foreach ($categories as $category){$selected = '';if (in_array($category['id'], $selecteds)){$selected = ' selected="selected"';}if ($fullname){$option = get_cat_display_name_cache($category['uppercats'],'',false);}else{$option = str_repeat(' ',(3 * substr_count($category['global_rank'], '.')));$option.= '- '.$category['name'];}$template->assign_block_vars($blockname,array('SELECTED'=>$selected,'VALUE'=>$category['id'],'OPTION'=>$option));}}function display_select_cat_wrapper($query, $selecteds, $blockname,$fullname = true){$result = pwg_query($query);$categories = array();if (!empty($result)){while ($row = mysql_fetch_array($result)){array_push($categories, $row);}}usort($categories, 'global_rank_compare');display_select_categories($categories, $selecteds, $blockname, $fullname);}/*** returns all subcategory identifiers of given category ids** @param array ids* @return array*/function get_subcat_ids($ids){$query = 'SELECT DISTINCT(id)FROM '.CATEGORIES_TABLE.'WHERE ';foreach ($ids as $num => $category_id){if ($num > 0){$query.= 'OR ';}$query.= 'uppercats REGEXP \'(^|,)'.$category_id.'(,|$)\'';}$query.= ';';$result = pwg_query($query);$subcats = array();while ($row = mysql_fetch_array($result)){array_push($subcats, $row['id']);}return $subcats;}function global_rank_compare($a, $b){return strnatcasecmp($a['global_rank'], $b['global_rank']);}?>