source: trunk/category.php @ 801

Last change on this file since 801 was 801, checked in by plg, 19 years ago
  • new feature : RSS notification feed. Feed generator is an external tool (FeedCreator class v1.7.2). New file feed.php
  • new database field : comments.validation_date (datetime). This field is required for notification feed.
  • new database field : users.feed_id (varchar(50)). users.feed_id is an alias of users.id but is much more complicated to find (50 characters, figures or letters, case sensitive) : the purpose is to keep it secret (as far as possible).
  • new database field : users.last_feed_check (datetime)
  • new database field : users.registration_date (datetime)
  • bug fixed : no need to add the (unavailable) session id to install.php in the installation form.
  • modified database field : images.date_available become more precise (date to datetime). This precision is needed for notification feed.
  • new index : comments_i1 (validation_date). Might be useful for feed queries.
  • new index : comments_i2 (image_id). Useful each time you want to have informations about an element and its associated comments.
  • version 9.11 of mysqldump outputs database field names and table names with backquote "`" (didn't find how to take them off)
  • Property svn:eol-style set to native
  • Property svn:keywords set to Author Date Id Revision
File size: 12.1 KB
Line 
1<?php
2// +-----------------------------------------------------------------------+
3// | PhpWebGallery - a PHP based picture gallery                           |
4// | Copyright (C) 2002-2003 Pierrick LE GALL - pierrick@phpwebgallery.net |
5// | Copyright (C) 2003-2005 PhpWebGallery Team - http://phpwebgallery.net |
6// +-----------------------------------------------------------------------+
7// | branch        : BSF (Best So Far)
8// | file          : $RCSfile$
9// | last update   : $Date: 2005-07-16 14:29:35 +0000 (Sat, 16 Jul 2005) $
10// | last modifier : $Author: plg $
11// | revision      : $Revision: 801 $
12// +-----------------------------------------------------------------------+
13// | This program is free software; you can redistribute it and/or modify  |
14// | it under the terms of the GNU General Public License as published by  |
15// | the Free Software Foundation                                          |
16// |                                                                       |
17// | This program is distributed in the hope that it will be useful, but   |
18// | WITHOUT ANY WARRANTY; without even the implied warranty of            |
19// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU      |
20// | General Public License for more details.                              |
21// |                                                                       |
22// | You should have received a copy of the GNU General Public License     |
23// | along with this program; if not, write to the Free Software           |
24// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, |
25// | USA.                                                                  |
26// +-----------------------------------------------------------------------+
27
28//--------------------------------------------------------------------- include
29define('PHPWG_ROOT_PATH','./');
30include_once( PHPWG_ROOT_PATH.'include/common.inc.php' );
31//---------------------------------------------------------------------- logout
32if ( isset( $_GET['act'] )
33     and $_GET['act'] == 'logout'
34     and isset( $_COOKIE['id'] ) )
35{
36  // cookie deletion if exists
37  setcookie( 'id', '', 0, cookie_path() );
38  $url = 'category.php';
39  redirect( $url );
40}
41//-------------------------------------------------- access authorization check
42if (isset($_GET['cat']))
43{
44  check_cat_id($_GET['cat']);
45}
46check_login_authorization();
47if (isset($page['cat']) and is_numeric($page['cat']))
48{
49  check_restrictions($page['cat']);
50}
51//-------------------------------------------------------------- initialization
52// detection of the start picture to display
53if ( !isset( $_GET['start'] )
54     or !is_numeric( $_GET['start'] )
55     or ( is_numeric( $_GET['start'] ) and $_GET['start'] < 0 ) )
56{
57  $page['start'] = 0;
58}
59else
60{
61  $page['start'] = $_GET['start'];
62}
63
64// Sometimes, a "num" is provided in the URL. It is the number
65// of the picture to show. This picture must be in the thumbnails page.
66// We have to find the right $page['start'] that show the num picture
67// in this category
68if ( isset( $_GET['num'] )
69     and is_numeric( $_GET['num'] )
70     and $_GET['num'] >= 0 )
71{
72  $page['start'] = floor( $_GET['num'] / $user['nb_image_page'] );
73  $page['start']*= $user['nb_image_page'];
74}
75
76initialize_category();
77
78// caddie filling :-)
79if (isset($_GET['caddie']))
80{
81//  include_once(PHPWG_ROOT_PATH.'admin/include/functions.php');
82 
83  $query = '
84SELECT DISTINCT(id)
85  FROM '.IMAGES_TABLE.' AS i
86    INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id
87  '.$page['where'].'
88;';
89  fill_caddie(array_from_query($query, 'id'));
90}
91
92// creation of the array containing the cat ids to expand in the menu
93// $page['tab_expand'] contains an array with the category ids
94// $page['expand'] contains the string to display in URL with comma
95$page['tab_expand'] = array();
96if ( isset( $page['cat'] ) and is_numeric( $page['cat'] ) )
97{
98  // the category displayed (in the URL cat=23) must be seen in the menu ->
99  // parent categories must be expanded
100  $uppercats = explode( ',', $page['uppercats'] );
101  foreach ( $uppercats as $uppercat ) {
102    array_push( $page['tab_expand'], $uppercat );
103  }
104}
105// in case of expanding all authorized cats $page['tab_expand'] is empty
106if ( $user['expand'] )
107{
108  $page['tab_expand'] = array();
109}
110//----------------------------------------------------- template initialization
111//
112// Start output of page
113//
114$title = $page['title'];
115include(PHPWG_ROOT_PATH.'include/page_header.php');
116
117$template->set_filenames( array('category'=>'category.tpl') );
118//-------------------------------------------------------------- category title
119if (isset($page['cat']) and is_numeric($page['cat']))
120{
121  $template_title = get_cat_display_name($page['cat_name'],
122                                         'category.php?cat=',
123                                         false);
124}
125else
126{
127  $template_title = $page['title'];
128}
129
130if ( isset( $page['cat_nb_images'] ) and $page['cat_nb_images'] > 0 )
131{
132  $template_title.= ' ['.$page['cat_nb_images'].']';
133}
134
135$icon_recent = get_icon(date('Y-m-d'));
136
137$template->assign_vars(array(
138  'NB_PICTURE' => count_user_total_images(),
139  'TITLE' => $template_title,
140  'USERNAME' => $user['username'],
141  'TOP_NUMBER'=>$conf['top_number'],
142  'MENU_CATEGORIES_CONTENT'=>get_categories_menu(),
143
144  'L_CATEGORIES' => $lang['categories'],
145  'L_HINT_CATEGORY' => $lang['hint_category'],
146  'L_SUBCAT' => $lang['sub-cat'],
147  'L_IMG_AVAILABLE' => $lang['images_available'],
148  'L_TOTAL' => $lang['total'],
149  'L_SPECIAL_CATEGORIES' => $lang['special_categories'],
150  'L_SUMMARY' => $lang['title_menu'],
151  'L_UPLOAD' => $lang['upload_picture'],
152  'L_COMMENT' => $lang['comments'],
153  'L_IDENTIFY' => $lang['identification'],
154  'L_SUBMIT' => $lang['menu_login'],
155  'L_USERNAME' => $lang['login'],
156  'L_PASSWORD' => $lang['password'],
157  'L_HELLO' => $lang['hello'],
158  'L_REGISTER' => $lang['ident_register'],
159  'L_LOGIN' => $lang['menu_login'],
160  'L_LOGOUT' => $lang['logout'],
161  'L_ADMIN' => $lang['admin'],
162  'L_ADMIN_HINT' => $lang['hint_admin'],
163  'L_PROFILE' => $lang['customize'],
164  'L_PROFILE_HINT' => $lang['hint_customize'],
165  'L_REMEMBER_ME' => $lang['remember_me'],
166 
167  'F_IDENTIFY' => add_session_id( PHPWG_ROOT_PATH.'identification.php' ),
168  'T_RECENT' => $icon_recent,
169
170  'U_HOME' => add_session_id( PHPWG_ROOT_PATH.'category.php' ),
171  'U_REGISTER' => add_session_id( PHPWG_ROOT_PATH.'register.php' ),
172  'U_LOGOUT' => PHPWG_ROOT_PATH.'category.php?act=logout',
173  'U_ADMIN'=>add_session_id( PHPWG_ROOT_PATH.'admin.php' ),
174  'U_PROFILE'=>add_session_id(PHPWG_ROOT_PATH.'profile.php?'.str_replace( '&', '&amp;', $_SERVER['QUERY_STRING'] )),
175  'U_CADDIE'=>add_session_id(PHPWG_ROOT_PATH.'category.php'.get_query_string_diff(array('caddie')).'&amp;caddie=1')
176  )
177);
178//-------------------------------------------------------------- external links
179if (count($conf['links']) > 0)
180{
181  $template->assign_block_vars('links', array());
182
183  foreach ($conf['links'] as $url => $label)
184  {
185    $template->assign_block_vars(
186      'links.link',
187      array(
188        'URL' => $url,
189        'LABEL' => $label
190        ));
191  }
192}
193//---------------------------------------------------------- special categories
194// favorites categories
195if ( !$user['is_the_guest'] )
196{
197  $template->assign_block_vars('username', array());
198
199  $template->assign_block_vars(
200    'special_cat',
201    array(
202      'URL' => add_session_id(PHPWG_ROOT_PATH.'category.php?cat=fav'),
203      'TITLE' => $lang['favorite_cat_hint'],
204      'NAME' => $lang['favorite_cat']
205      ));
206}
207// most visited
208$template->assign_block_vars(
209  'special_cat',
210  array(
211    'URL' => add_session_id(PHPWG_ROOT_PATH.'category.php?cat=most_visited'),
212    'TITLE' => $lang['most_visited_cat_hint'],
213    'NAME' => $lang['most_visited_cat']
214    ));
215// best rated
216$template->assign_block_vars(
217  'special_cat',
218  array(
219    'URL' => add_session_id(PHPWG_ROOT_PATH.'category.php?cat=best_rated'),
220    'TITLE' => $lang['best_rated_cat_hint'],
221    'NAME' => $lang['best_rated_cat']
222    ));
223// random
224$template->assign_block_vars(
225  'special_cat',
226  array(
227    'URL' => add_session_id(PHPWG_ROOT_PATH.'random.php'),
228    'TITLE' => $lang['random_cat_hint'],
229    'NAME' => $lang['random_cat']
230    ));
231// recent pics
232$template->assign_block_vars(
233  'special_cat',
234  array(
235    'URL' => add_session_id(PHPWG_ROOT_PATH.'category.php?cat=recent_pics'),
236    'TITLE' => $lang['recent_pics_cat_hint'],
237    'NAME' => $lang['recent_pics_cat']
238    ));
239// recent cats
240$template->assign_block_vars(
241  'special_cat',
242  array(
243    'URL' => add_session_id(PHPWG_ROOT_PATH.'category.php?cat=recent_cats'),
244    'TITLE' => $lang['recent_cats_cat_hint'],
245    'NAME' => $lang['recent_cats_cat']
246    ));
247// calendar
248$template->assign_block_vars(
249  'special_cat',
250  array(
251    'URL' => add_session_id(PHPWG_ROOT_PATH.'category.php?cat=calendar'),
252    'TITLE' => $lang['calendar_hint'],
253    'NAME' => $lang['calendar']
254    ));
255//--------------------------------------------------------------------- summary
256
257if ( !$user['is_the_guest'] )
258{
259  $template->assign_block_vars('logout',array());
260  // administration link
261  if ( $user['status'] == 'admin' )
262  {
263    $template->assign_block_vars('logout.admin', array());
264  }
265}
266else
267{
268  $template->assign_block_vars('login',array());
269  if ($conf['authorize_remembering'])
270  {
271    $template->assign_block_vars('login.remember_me',array());
272  }
273}
274
275// search link
276$template->assign_block_vars('summary', array(
277'TITLE'=>$lang['hint_search'],
278'NAME'=>$lang['search'],
279'U_SUMMARY'=>add_session_id( 'search.php' ),
280));
281
282// comments link
283$template->assign_block_vars('summary', array(
284'TITLE'=>$lang['hint_comments'],
285'NAME'=>$lang['comments'],
286'U_SUMMARY'=>add_session_id( 'comments.php' ),
287));
288
289// about link
290$template->assign_block_vars('summary', array(
291'TITLE'=>$lang['hint_about'],
292'NAME'=>$lang['about'],
293'U_SUMMARY'=>add_session_id( 'about.php?'.str_replace( '&', '&amp;', $_SERVER['QUERY_STRING'] ) )
294));
295
296// notification feed
297$template->assign_block_vars(
298  'summary',
299  array(
300    'TITLE'=>l10n('RSS notification feed'),
301    'NAME'=>l10n('Notification feed'),
302    'U_SUMMARY'=>
303    'feed.php'.(ANONYMOUS != $user['id'] ? '?feed='.$user['feed_id'] : '')
304));
305
306//------------------------------------------------------ main part : thumbnails
307if (isset($page['cat'])
308    and ((is_numeric($page['cat']) and $page['cat_nb_images'] != 0)
309         or in_array($page['cat'],
310                     array('search'
311                           ,'most_visited'
312                           ,'recent_pics'
313                           ,'best_rated'
314                           ,'list'
315                           ,'fav'
316                       ))))
317{
318  include(PHPWG_ROOT_PATH.'include/category_default.inc.php');
319
320  if ('admin' == $user['status'])
321  {
322    $template->assign_block_vars('caddie', array());
323  }
324}
325elseif (isset($page['cat']) and $page['cat'] == 'calendar')
326{
327  include(PHPWG_ROOT_PATH.'include/category_calendar.inc.php');
328}
329elseif (isset($page['cat']) and $page['cat'] == 'recent_cats')
330{
331  include(PHPWG_ROOT_PATH.'include/category_recent_cats.inc.php');
332}
333else
334{
335  include(PHPWG_ROOT_PATH.'include/category_subcats.inc.php');
336}
337//------------------------------------------------------- category informations
338if ( isset ( $page['cat'] ) )
339{
340  // upload a picture in the category
341  if (is_numeric($page['cat'])
342      and $page['cat_site_id'] == 1
343      and $page['cat_dir'] != ''
344      and $page['cat_uploadable'])
345  {
346    $url = PHPWG_ROOT_PATH.'upload.php?cat='.$page['cat'];
347    $template->assign_block_vars(
348      'upload',
349      array('U_UPLOAD'=>add_session_id( $url ))
350      );
351  }
352
353  if ( $page['navigation_bar'] != ''
354       or ( isset( $page['comment'] ) and $page['comment'] != '' ) )
355  {
356    $template->assign_block_vars('cat_infos',array());
357  }
358 
359  // navigation bar
360  if ( $page['navigation_bar'] != '' )
361  { 
362    $template->assign_block_vars(
363      'cat_infos.navigation',
364      array('NAV_BAR' => $page['navigation_bar'])
365      );
366  }
367  // category comment
368  if ( isset( $page['comment'] ) and $page['comment'] != '' )
369  {
370    $template->assign_block_vars(
371      'cat_infos.comment',
372      array('COMMENTS' => $page['comment'])
373      );
374  }
375}
376//------------------------------------------------------------ log informations
377pwg_log( 'category', $page['title'] );
378mysql_close();
379
380$template->parse('category');
381include(PHPWG_ROOT_PATH.'include/page_tail.php');
382?>
Note: See TracBrowser for help on using the repository browser.