aboutsummaryrefslogtreecommitdiffstats
path: root/BSF/include/section_init.inc.php
diff options
context:
space:
mode:
authorvdigital <vdigital@piwigo.org>2008-05-23 21:05:41 +0000
committervdigital <vdigital@piwigo.org>2008-05-23 21:05:41 +0000
commit77fd1f51a3c5f5a52f72ef8a299fe368228e2285 (patch)
treea67ede42904657ccf3349ecdaef1cec8b8e36ff8 /BSF/include/section_init.inc.php
parent553727dffacc48e8337c1d141f2a25af359e74b1 (diff)
git-svn-id: http://piwigo.org/svn/trunk@2357 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'BSF/include/section_init.inc.php')
-rw-r--r--BSF/include/section_init.inc.php620
1 files changed, 620 insertions, 0 deletions
diff --git a/BSF/include/section_init.inc.php b/BSF/include/section_init.inc.php
new file mode 100644
index 000000000..ffd6cac1a
--- /dev/null
+++ b/BSF/include/section_init.inc.php
@@ -0,0 +1,620 @@
+<?php
+// +-----------------------------------------------------------------------+
+// | Piwigo - a PHP based picture gallery |
+// +-----------------------------------------------------------------------+
+// | Copyright(C) 2008 Piwigo Team http://piwigo.org |
+// | Copyright(C) 2003-2008 PhpWebGallery Team http://phpwebgallery.net |
+// | Copyright(C) 2002-2003 Pierrick LE GALL http://le-gall.net/pierrick |
+// +-----------------------------------------------------------------------+
+// | 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. |
+// +-----------------------------------------------------------------------+
+
+/**
+ * This included page checks section related parameter and provides
+ * following informations:
+ *
+ * - $page['title']
+ *
+ * - $page['items']: ordered list of items to display
+ *
+ */
+
+// "index.php?/category/12-foo/start-24" or
+// "index.php/category/12-foo/start-24"
+// must return :
+//
+// array(
+// 'section' => '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(
+ '/',
+ preg_replace('#^/#', '', $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;
+ }
+ 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
+ {
+ 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 (pwg_get_session_var('image_order',0) > 0)
+{
+ $orders = get_category_preferred_image_orders();
+
+ $conf['order_by'] = str_replace(
+ 'ORDER BY ',
+ 'ORDER BY '.$orders[ pwg_get_session_var('image_order',0) ][1].',',
+ $conf['order_by']
+ );
+ $page['super_order_by'] = true;
+}
+
+$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('no_category');
+ }
+
+ 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)
+ 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
+ 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');
+ }
+
+ $title = get_tags_content_title();
+
+ $page = array_merge(
+ $page,
+ array(
+ 'title' => $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']);
+ if ( !empty($search_result['items']) and !isset($search_result['as_is']) )
+ {
+ $query = '
+SELECT DISTINCT(id)
+ FROM '.IMAGES_TABLE.'
+ INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id
+ WHERE id IN ('.implode(',', $search_result['items']).')
+ '.$forbidden.'
+ '.$conf['order_by'].'
+;';
+ $page['items'] = array_from_query($query, 'id');
+ }
+ else
+ {
+ $page['items'] = $search_result['items'];
+ if ( isset($search_result['qs']) )
+ {//save the details of the query search
+ $page['qsearch_details'] = $search_result['qs'];
+ }
+ }
+
+ $page = array_merge(
+ $page,
+ array(
+ 'title' => '<a href="'.duplicate_index_url(array('start'=>0)).'">'
+ .l10n('search_result').'</a>',
+ )
+ );
+ }
+// +-----------------------------------------------------------------------+
+// | favorite section |
+// +-----------------------------------------------------------------------+
+ else if ($page['section'] == 'favorites')
+ {
+ check_user_favorites();
+
+ $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' => 'image_id'
+ ),
+ 'AND'
+ ).'
+ '.$conf['order_by'].'
+;';
+
+ $page = array_merge(
+ $page,
+ array(
+ 'title' => l10n('favorites'),
+ 'items' => array_from_query($query, 'image_id'),
+ )
+ );
+ }
+// +-----------------------------------------------------------------------+
+// | recent pictures section |
+// +-----------------------------------------------------------------------+
+ else if ($page['section'] == 'recent_pics')
+ {
+ $query = '
+SELECT DISTINCT(id)
+ FROM '.IMAGES_TABLE.'
+ INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id
+ WHERE
+ date_available >= SUBDATE(
+ CURRENT_DATE,INTERVAL '.$user['recent_period'].' DAY)
+ '.$forbidden.'
+ '.$conf['order_by'].'
+;';
+
+ $page = array_merge(
+ $page,
+ array(
+ 'title' => '<a href="'.duplicate_index_url(array('start'=>0)).'">'
+ .l10n('recent_pics_cat').'</a>',
+ 'items' => array_from_query($query, 'id'),
+ )
+ );
+ }
+// +-----------------------------------------------------------------------+
+// | recently updated categories section |
+// +-----------------------------------------------------------------------+
+ else if ($page['section'] == 'recent_cats')
+ {
+ $page = array_merge(
+ $page,
+ array(
+ 'title' => l10n('recent_cats_cat'),
+ )
+ );
+ }
+// +-----------------------------------------------------------------------+
+// | 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)
+ FROM '.IMAGES_TABLE.'
+ INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id
+ WHERE hit > 0
+ '.$forbidden.'
+ '.$conf['order_by'].'
+ LIMIT 0, '.$conf['top_number'].'
+;';
+
+ $page = array_merge(
+ $page,
+ array(
+ 'title' => '<a href="'.duplicate_index_url(array('start'=>0)).'">'
+ .$conf['top_number'].' '.l10n('most_visited_cat').'</a>',
+ '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)
+ 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 0, '.$conf['top_number'].'
+;';
+ $page = array_merge(
+ $page,
+ array(
+ 'title' => '<a href="'.duplicate_index_url(array('start'=>0)).'">'
+ .$conf['top_number'].' '.l10n('best_rated_cat').'</a>',
+ 'items' => array_from_query($query, 'id'),
+ )
+ );
+ }
+// +-----------------------------------------------------------------------+
+// | list section |
+// +-----------------------------------------------------------------------+
+ else if ($page['section'] == 'list')
+ {
+ $query ='
+SELECT DISTINCT(id)
+ 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' => '<a href="'.duplicate_index_url(array('start'=>0)).'">'
+ .l10n('random_cat').'</a>',
+ 'items' => array_from_query($query, 'id'),
+ )
+ );
+ }
+}
+
+// +-----------------------------------------------------------------------+
+// | chronology |
+// +-----------------------------------------------------------------------+
+
+if (isset($page['chronology_field']))
+{
+ include_once( PHPWG_ROOT_PATH.'include/functions_calendar.inc.php' );
+ initialize_calendar();
+}
+
+if (script_basename() == 'picture'
+ and !isset($page['image_id']) )
+{
+ if ( !empty($page['items']) )
+ {
+ $query = '
+SELECT id,file
+ FROM '.IMAGES_TABLE .'
+ WHERE file LIKE "' . $page['image_file'] . '.%" ESCAPE "|"';
+ if ( count($page['items']) < 500)
+ {// for very large item sets do not add IN - because slow
+ $query .= '
+ AND id IN ('.implode(',',$page['items']).')
+ LIMIT 0,1';
+ }
+ $result = pwg_query($query);
+ switch (mysql_num_rows($result))
+ {
+ case 0: break;
+ case 1:
+ list($page['image_id'], $page['image_file']) = mysql_fetch_row($result);
+ break;
+ default: // more than 1 file name match
+ while ($row = mysql_fetch_row($result) )
+ {
+ if ( in_array($row[0], $page['items']) )
+ {
+ list($page['image_id'], $page['image_file']) = $row;
+ break;
+ }
+ }
+ }
+ }
+ if ( !isset($page['image_id']) )
+ {
+ $page['image_id'] = -1; // will fail in picture.php
+ }
+}
+
+// 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');
+?> \ No newline at end of file