'categories', // 'category' => array('id'=>12, ...), // 'start' => 24 // ); $page['items'] = array(); // some ISPs set PATH_INFO to empty string or to SCRIPT_FILENAME while in the // default apache implementation it is not set if ( $conf['question_mark_in_urls']==false and isset($_SERVER["PATH_INFO"]) and !empty($_SERVER["PATH_INFO"]) ) { $rewritten = $_SERVER["PATH_INFO"]; $rewritten = str_replace('//', '/', $rewritten); $path_count = count( explode('/', $rewritten) ); $page['root_path'] = PHPWG_ROOT_PATH.str_repeat('../', $path_count-1); } else { $rewritten = ''; foreach (array_keys($_GET) as $keynum => $key) { $rewritten = $key; break; } $page['root_path'] = PHPWG_ROOT_PATH; } // deleting first "/" if displayed $tokens = explode('/', ltrim($rewritten, '/') ); // $tokens = array( // 0 => category, // 1 => 12-foo, // 2 => start-24 // ); $next_token = 0; if (script_basename() == 'picture') // basename without file extention { // the first token must be the identifier for the picture if ( isset($_GET['image_id']) and isset($_GET['cat']) and is_numeric($_GET['cat']) ) {// url compatibility with versions below 1.6 $url = make_picture_url( array( 'section' => 'categories', 'category' => get_cat_info($_GET['cat']), 'image_id' => $_GET['image_id'] ) ); redirect($url); } $token = $tokens[$next_token]; $next_token++; if ( is_numeric($token) ) { $page['image_id'] = $token; if ($page['image_id']==0) { bad_request('invalid picture identifier'); } } else { preg_match('/^(\d+-)?(.*)?$/', $token, $matches); if (isset($matches[1]) and is_numeric($matches[1]=rtrim($matches[1],'-')) ) { $page['image_id'] = $matches[1]; if ( !empty($matches[2]) ) { $page['image_file'] = $matches[2]; } } else { $page['image_id'] = 0; // more work in picture.php if ( !empty($matches[2]) ) { $page['image_file'] = $matches[2]; } else { bad_request('picture identifier is missing'); } } } } $page = array_merge( $page, parse_section_url( $tokens, $next_token) ); if ( !isset($page['section']) ) { $page['section'] = 'categories'; switch (script_basename()) { case 'picture': break; case 'index': { // No section defined, go to selected url if (!empty($conf['random_index_redirect']) and empty($tokens[$next_token]) ) { $random_index_redirect = array(); foreach ($conf['random_index_redirect'] as $random_url => $random_url_condition) { if (empty($random_url_condition) or eval($random_url_condition)) { $random_index_redirect[] = $random_url; } } if (!empty($random_index_redirect)) { redirect($random_index_redirect[mt_rand(0, count($random_index_redirect)-1)]); } } break; } default: trigger_error('script_basename "'.script_basename().'" unknown', E_USER_WARNING); } } $page = array_merge( $page, parse_well_known_params_url( $tokens, $next_token) ); if ( script_basename()=='picture' and 'categories'==$page['section'] and !isset($page['category']) and !isset($page['chronology_field']) ) { //access a picture only by id, file or id-file without given section $page['flat']=true; } // $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']; // if flat mode is active, we must consider the image set as a standard set // and not as a category set because we can't use the #image_category.rank : // displayed images are not directly linked to the displayed category if ('categories' == $page['section'] and !isset($page['flat'])) { $conf['order_by'] = $conf['order_by_inside_category']; } if (pwg_get_session_var('image_order',0) > 0) { $image_order_id = pwg_get_session_var('image_order'); $orders = get_category_preferred_image_orders(); // the current session stored image_order might be not compatible with // current image set, for example if the current image_order is the rank // and that we are displaying images related to a tag. // // In case of incompatibility, the session stored image_order is removed. if ($orders[$image_order_id][2]) { $conf['order_by'] = str_replace( 'ORDER BY ', 'ORDER BY '.$orders[$image_order_id][1].',', $conf['order_by'] ); $page['super_order_by'] = true; } else { pwg_unset_session_var('image_order'); $page['super_order_by'] = false; } } $forbidden = get_sql_condition_FandF( array ( 'forbidden_categories' => 'category_id', 'visible_categories' => 'category_id', 'visible_images' => 'id' ), 'AND' ); // +-----------------------------------------------------------------------+ // | category | // +-----------------------------------------------------------------------+ if ('categories' == $page['section']) { if (isset($page['category'])) { $page = array_merge( $page, array( 'comment' => trigger_event( 'render_category_description', $page['category']['comment'], 'main_page_category_description' ), 'title' => get_cat_display_name($page['category']['upper_names'], '', false), ) ); } else { $page['title'] = ''.l10n('Home').''; } if ( (!isset($page['chronology_field'])) and ( (isset($page['category'])) or (isset($page['flat'])) ) ) { if ( !empty($page['category']['image_order']) and !isset($page['super_order_by']) ) { $conf[ 'order_by' ] = ' ORDER BY '.$page['category']['image_order']; } if (isset($page['flat'])) {// flat categories mode if ( isset($page['category']) ) { // get all allowed sub-categories $query = ' SELECT id FROM '.CATEGORIES_TABLE.' WHERE uppercats LIKE "'.$page['category']['uppercats'].',%" ' .get_sql_condition_FandF( array ( 'forbidden_categories' => 'id', 'visible_categories' => 'id', ), "\n AND" ); $subcat_ids = array_from_query($query, 'id'); $subcat_ids[] = $page['category']['id']; $where_sql = 'category_id IN ('.implode(',',$subcat_ids).')'; // remove categories from forbidden because just checked above $forbidden = get_sql_condition_FandF( array( 'visible_images' => 'id' ), 'AND' ); } else { $where_sql = '1=1'; } } else {// Normal mode $where_sql = 'category_id = '.$page['category']['id']; } // Main query $query = ' SELECT DISTINCT(image_id)'.get_extra_fields($conf['order_by']).' FROM '.IMAGE_CATEGORY_TABLE.' INNER JOIN '.IMAGES_TABLE.' ON id = image_id WHERE '.$where_sql.' '.$forbidden.' '.$conf['order_by'].' ;'; $page['items'] = array_from_query($query, 'image_id'); } //otherwise the calendar will requery all subitems } // special sections else { // +-----------------------------------------------------------------------+ // | tags section | // +-----------------------------------------------------------------------+ if ($page['section'] == 'tags') { $page['tag_ids'] = array(); foreach ($page['tags'] as $tag) { array_push($page['tag_ids'], $tag['id']); } $items = get_image_ids_for_tags($page['tag_ids']); // permissions depends on category, so to only keep images that are // reachable to the connected user, we need to check category // associations if (!empty($items) ) { $query = ' SELECT DISTINCT image_id'.get_extra_fields($conf['order_by']).' FROM '.IMAGE_CATEGORY_TABLE.' INNER JOIN '.IMAGES_TABLE.' ON image_id=id WHERE image_id IN ('.implode(',', $items).') '.$forbidden. $conf['order_by'].' ;'; $items = array_from_query($query, 'image_id'); } $page = array_merge( $page, array( 'title' => get_tags_content_title(), 'items' => $items, ) ); } // +-----------------------------------------------------------------------+ // | search section | // +-----------------------------------------------------------------------+ if ($page['section'] == 'search') { include_once( PHPWG_ROOT_PATH .'include/functions_search.inc.php' ); $search_result = get_search_results($page['search'], @$page['super_order_by'] ); if ( isset($search_result['qs']) ) {//save the details of the query search $page['qsearch_details'] = $search_result['qs']; } $page = array_merge( $page, array( 'items' => $search_result['items'], 'title' => '' .l10n('Search results').'', ) ); } // +-----------------------------------------------------------------------+ // | favorite section | // +-----------------------------------------------------------------------+ else if ($page['section'] == 'favorites') { check_user_favorites(); $page = array_merge( $page, array( 'title' => l10n('Favorites') ) ); if (!empty($_GET['action']) && ($_GET['action'] == 'remove_all_from_favorites')) { $query = ' DELETE FROM '.FAVORITES_TABLE.' WHERE user_id = '.$user['id'].' ;'; pwg_query($query); redirect(make_index_url( array('section'=>'favorites') )); } else { $query = ' SELECT image_id FROM '.FAVORITES_TABLE.' INNER JOIN '.IMAGES_TABLE.' ON image_id = id WHERE user_id = '.$user['id'].' '.get_sql_condition_FandF ( array ( 'visible_images' => 'id' ), 'AND' ).' '.$conf['order_by'].' ;'; $page = array_merge( $page, array( 'items' => array_from_query($query, 'image_id'), ) ); if (count($page['items'])>0) { $template->assign( 'favorite', array( 'FAVORITE_IMG' => get_root_url().get_themeconf('icon_dir').'/del_all_favorites.png', 'U_FAVORITE' => add_url_params( make_index_url( array('section'=>'favorites') ), array('action'=>'remove_all_from_favorites') ), ) ); } } } // +-----------------------------------------------------------------------+ // | recent pictures section | // +-----------------------------------------------------------------------+ else if ($page['section'] == 'recent_pics') { if ( !isset($page['super_order_by']) ) { $conf['order_by'] = str_replace( 'ORDER BY ', 'ORDER BY date_available DESC,', $conf['order_by'] ); } $query = ' SELECT DISTINCT(id)'.get_extra_fields($conf['order_by']).' FROM '.IMAGES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id WHERE date_available >= '.pwg_db_get_recent_period_expression($user['recent_period']).' '.$forbidden.' '.$conf['order_by'].' ;'; $page = array_merge( $page, array( 'title' => '' .l10n('Recent pictures').'', 'items' => array_from_query($query, 'id'), ) ); } // +-----------------------------------------------------------------------+ // | recently updated categories section | // +-----------------------------------------------------------------------+ else if ($page['section'] == 'recent_cats') { $page = array_merge( $page, array( 'title' => l10n('Recent categories'), ) ); } // +-----------------------------------------------------------------------+ // | most visited section | // +-----------------------------------------------------------------------+ else if ($page['section'] == 'most_visited') { $page['super_order_by'] = true; $conf['order_by'] = ' ORDER BY hit DESC, file ASC'; $query = ' SELECT DISTINCT(id), hit, file FROM '.IMAGES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id WHERE hit > 0 '.$forbidden.' '.$conf['order_by'].' LIMIT '.$conf['top_number'].' ;'; $page = array_merge( $page, array( 'title' => '' .$conf['top_number'].' '.l10n('Most visited').'', 'items' => array_from_query($query, 'id'), ) ); } // +-----------------------------------------------------------------------+ // | best rated section | // +-----------------------------------------------------------------------+ else if ($page['section'] == 'best_rated') { $page['super_order_by'] = true; $conf['order_by'] = ' ORDER BY average_rate DESC, id ASC'; $query =' SELECT DISTINCT(id), average_rate FROM '.IMAGES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id WHERE average_rate IS NOT NULL '.$forbidden.' '.$conf['order_by'].' LIMIT '.$conf['top_number'].' ;'; $page = array_merge( $page, array( 'title' => '' .$conf['top_number'].' '.l10n('Best rated').'', 'items' => array_from_query($query, 'id'), ) ); } // +-----------------------------------------------------------------------+ // | list section | // +-----------------------------------------------------------------------+ else if ($page['section'] == 'list') { $query =' SELECT DISTINCT(id)'.get_extra_fields($conf['order_by']).' FROM '.IMAGES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id WHERE image_id IN ('.implode(',', $page['list']).') '.$forbidden.' '.$conf['order_by'].' ;'; $page = array_merge( $page, array( 'title' => '' .l10n('Random pictures').'', 'items' => array_from_query($query, 'id'), ) ); } } // +-----------------------------------------------------------------------+ // | chronology | // +-----------------------------------------------------------------------+ if (isset($page['chronology_field'])) { include_once( PHPWG_ROOT_PATH.'include/functions_calendar.inc.php' ); initialize_calendar(); } // add meta robots noindex, nofollow to avoid unnecesary robot crawls $page['meta_robots']=array(); if ( isset($page['chronology_field']) or ( isset($page['flat']) and isset($page['category']) ) or 'list'==$page['section'] or 'recent_pics'==$page['section'] ) { $page['meta_robots']=array('noindex'=>1, 'nofollow'=>1); } elseif ('tags' == $page['section']) { if ( count($page['tag_ids'])>1 ) { $page['meta_robots']=array('noindex'=>1, 'nofollow'=>1); } } elseif ('recent_cats'==$page['section']) { $page['meta_robots']['noindex']=1; } elseif ('search'==$page['section']) { $page['meta_robots']['nofollow']=1; } if ( $filter['enabled'] ) { $page['meta_robots']['noindex']=1; } // see if we need a redirect because of a permalink if ( 'categories'==$page['section'] and isset($page['category']) ) { $need_redirect=false; if ( empty($page['category']['permalink']) ) { if ( $conf['category_url_style'] == 'id-name' and @$page['hit_by']['cat_url_name'] !== str2url($page['category']['name']) ) { $need_redirect=true; } } else { if ( $page['category']['permalink'] !== @$page['hit_by']['cat_permalink'] ) { $need_redirect=true; } } if ($need_redirect) { $redirect_url = ( script_basename()=='picture' ? duplicate_picture_url() : duplicate_index_url() ); if (!headers_sent()) { // this is a permanent redirection set_status_header(301); redirect_http( $redirect_url ); } redirect( $redirect_url ); } unset( $need_redirect, $page['hit_by'] ); } trigger_action('loc_end_section_init'); ?>