0)
{
$query .= 'id = '.$page['image_id'];
}
else
{// url given by file name
assert( !empty($page['image_file']) );
$query .= 'file LIKE \'' .
str_replace(array('_','%'), array('/_','/%'), $page['image_file'] ).
'.%\' ESCAPE \'/\' LIMIT 1';
}
if ( ! ( $row = pwg_db_fetch_assoc(pwg_query($query)) ) )
{// element does not exist
page_not_found( 'The requested image does not exist',
duplicate_index_url()
);
}
if ($row['level']>$user['level'])
{
access_denied();
}
$page['image_id'] = $row['id'];
$page['image_file'] = $row['file'];
if ( !isset($page['rank_of'][$page['image_id']]) )
{// the image can still be non accessible (filter/cat perm) and/or not in the set
global $filter;
if ( !empty($filter['visible_images']) and
!in_array($page['image_id'], explode(',',$filter['visible_images']) ) )
{
page_not_found( 'The requested image is filtered',
duplicate_index_url()
);
}
if ('categories'==$page['section'] and !isset($page['category']) )
{// flat view - all items
access_denied();
}
else
{// try to see if we can access it differently
$query = '
SELECT id
FROM '.IMAGES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON id=image_id
WHERE id='.$page['image_id']
. get_sql_condition_FandF(
array('forbidden_categories' => 'category_id'),
" AND"
).'
LIMIT 1';
if ( pwg_db_num_rows( pwg_query($query) ) == 0 )
{
access_denied();
}
else
{
if ('best_rated'==$page['section'])
{
$page['rank_of'][$page['image_id']] = count($page['items']);
array_push($page['items'], $page['image_id'] );
}
else
{
$url = make_picture_url(
array(
'image_id' => $page['image_id'],
'image_file' => $page['image_file'],
'section' => 'categories',
'flat' => true,
)
);
set_status_header( 'recent_pics'==$page['section'] ? 301 : 302);
redirect_http( $url );
}
}
}
}
}
// There is cookie, so we must handle it at the beginning
if ( isset($_GET['metadata']) )
{
if ( pwg_get_session_var('show_metadata') == null )
{
pwg_set_session_var('show_metadata', 1 );
} else {
pwg_unset_session_var('show_metadata');
}
}
// add default event handler for rendering element content
add_event_handler(
'render_element_content',
'default_picture_content',
EVENT_HANDLER_PRIORITY_NEUTRAL,
2
);
// add default event handler for rendering element description
add_event_handler('render_element_description', 'nl2br');
trigger_action('loc_begin_picture');
// this is the default handler that generates the display for the element
function default_picture_content($content, $element_info)
{
if ( !empty($content) )
{// someone hooked us - so we skip;
return $content;
}
if (!isset($element_info['image_url']))
{ // nothing to do
return $content;
}
global $user, $page, $template;
$template->set_filenames(
array('default_content'=>'picture_content.tpl')
);
if ( !$page['slideshow'] and isset($element_info['high_url']) )
{
$uuid = uniqid(rand());
$template->assign(
'high',
array(
'U_HIGH' => $element_info['high_url'],
'UUID' => $uuid,
)
);
}
$template->assign( array(
'SRC_IMG' => $element_info['image_url'],
'ALT_IMG' => $element_info['file'],
'WIDTH_IMG' => @$element_info['scaled_width'],
'HEIGHT_IMG' => @$element_info['scaled_height'],
)
);
return $template->parse( 'default_content', true);
}
// +-----------------------------------------------------------------------+
// | initialization |
// +-----------------------------------------------------------------------+
// caching first_rank, last_rank, current_rank in the displayed
// section. This should also help in readability.
$page['first_rank'] = 0;
$page['last_rank'] = count($page['items']) - 1;
$page['current_rank'] = $page['rank_of'][ $page['image_id'] ];
// caching current item : readability purpose
$page['current_item'] = $page['image_id'];
if ($page['current_rank'] != $page['first_rank'])
{
// caching first & previous item : readability purpose
$page['previous_item'] = $page['items'][ $page['current_rank'] - 1 ];
$page['first_item'] = $page['items'][ $page['first_rank'] ];
}
if ($page['current_rank'] != $page['last_rank'])
{
// caching next & last item : readability purpose
$page['next_item'] = $page['items'][ $page['current_rank'] + 1 ];
$page['last_item'] = $page['items'][ $page['last_rank'] ];
}
$url_up = duplicate_index_url(
array(
'start' =>
floor($page['current_rank'] / $user['nb_image_page'])
* $user['nb_image_page']
),
array(
'start',
)
);
$url_self = duplicate_picture_url();
// +-----------------------------------------------------------------------+
// | actions |
// +-----------------------------------------------------------------------+
/**
* Actions are favorite adding, user comment deletion, setting the picture
* as representative of the current category...
*
* Actions finish by a redirection
*/
if (isset($_GET['action']))
{
switch ($_GET['action'])
{
case 'add_to_favorites' :
{
$query = '
INSERT INTO '.FAVORITES_TABLE.'
(image_id,user_id)
VALUES
('.$page['image_id'].','.$user['id'].')
;';
pwg_query($query);
redirect($url_self);
break;
}
case 'remove_from_favorites' :
{
$query = '
DELETE FROM '.FAVORITES_TABLE.'
WHERE user_id = '.$user['id'].'
AND image_id = '.$page['image_id'].'
;';
pwg_query($query);
if ('favorites' == $page['section'])
{
redirect($url_up);
}
else
{
redirect($url_self);
}
break;
}
case 'set_as_representative' :
{
if (is_admin() and !is_adviser() and isset($page['category']))
{
$query = '
UPDATE '.CATEGORIES_TABLE.'
SET representative_picture_id = '.$page['image_id'].'
WHERE id = '.$page['category']['id'].'
;';
pwg_query($query);
}
redirect($url_self);
break;
}
case 'toggle_metadata' :
{
break;
}
case 'add_to_caddie' :
{
fill_caddie(array($page['image_id']));
redirect($url_self);
break;
}
case 'rate' :
{
include_once(PHPWG_ROOT_PATH.'include/functions_rate.inc.php');
rate_picture(
$page['image_id'],
isset($_POST['rate']) ? $_POST['rate'] : $_GET['rate']
);
redirect($url_self);
}
case 'edit_comment' :
{
check_pwg_token();
include_once(PHPWG_ROOT_PATH.'include/functions_comment.inc.php');
check_input_parameter('comment_to_edit', $_GET, false, PATTERN_ID);
$author_id = get_comment_author_id($_GET['comment_to_edit']);
if (can_manage_comment('edit', $author_id))
{
if (!empty($_POST['content']))
{
update_user_comment(
array(
'comment_id' => $_GET['comment_to_edit'],
'image_id' => $page['image_id'],
'content' => $_POST['content']
),
$_POST['key']
);
redirect($url_self);
}
else
{
$edit_comment = $_GET['comment_to_edit'];
break;
}
}
}
case 'delete_comment' :
{
check_pwg_token();
include_once(PHPWG_ROOT_PATH.'include/functions_comment.inc.php');
check_input_parameter('comment_to_delete', $_GET, false, PATTERN_ID);
$author_id = get_comment_author_id($_GET['comment_to_delete']);
if (can_manage_comment('delete', $author_id))
{
delete_user_comment($_GET['comment_to_delete']);
}
redirect($url_self);
}
case 'validate_comment' :
{
check_pwg_token();
include_once(PHPWG_ROOT_PATH.'include/functions_comment.inc.php');
check_input_parameter('comment_to_validate', $_GET, false, PATTERN_ID);
$author_id = get_comment_author_id($_GET['comment_to_validate']);
if (can_manage_comment('validate', $author_id))
{
validate_user_comment($_GET['comment_to_validate']);
}
redirect($url_self);
}
}
}
// incrementation of the number of hits, we do this only if no action
if (trigger_event('allow_increment_element_hit_count', !isset($_POST['content']) ) )
{
$query = '
UPDATE
'.IMAGES_TABLE.'
SET hit = hit+1
WHERE id = '.$page['image_id'].'
;';
pwg_query($query);
}
//---------------------------------------------------------- related categories
$query = '
SELECT category_id,uppercats,commentable,global_rank
FROM '.IMAGE_CATEGORY_TABLE.'
INNER JOIN '.CATEGORIES_TABLE.' ON category_id = id
WHERE image_id = '.$page['image_id'].'
'.get_sql_condition_FandF
(
array
(
'forbidden_categories' => 'category_id',
'visible_categories' => 'category_id'
),
'AND'
).'
;';
$result = pwg_query($query);
$related_categories = array();
while ($row = pwg_db_fetch_assoc($result))
{
$row['commentable'] = boolean_to_string($row['commentable']);
array_push($related_categories, $row);
}
usort($related_categories, 'global_rank_compare');
//-------------------------first, prev, current, next & last picture management
$picture = array();
$ids = array($page['image_id']);
if (isset($page['previous_item']))
{
array_push($ids, $page['previous_item']);
array_push($ids, $page['first_item']);
}
if (isset($page['next_item']))
{
array_push($ids, $page['next_item']);
array_push($ids, $page['last_item']);
}
$query = '
SELECT *
FROM '.IMAGES_TABLE.'
WHERE id IN ('.implode(',', $ids).')
;';
$result = pwg_query($query);
while ($row = pwg_db_fetch_assoc($result))
{
if (isset($page['previous_item']) and $row['id'] == $page['previous_item'])
{
$i = 'previous';
}
else if (isset($page['next_item']) and $row['id'] == $page['next_item'])
{
$i = 'next';
}
else if (isset($page['first_item']) and $row['id'] == $page['first_item'])
{
$i = 'first';
}
else if (isset($page['last_item']) and $row['id'] == $page['last_item'])
{
$i = 'last';
}
else
{
$i = 'current';
}
$picture[$i] = $row;
$picture[$i]['is_picture'] = false;
if (in_array(get_extension($row['file']), $conf['picture_ext']))
{
$picture[$i]['is_picture'] = true;
}
// ------ build element_path and element_url
$picture[$i]['element_path'] = get_element_path($picture[$i]);
$picture[$i]['element_url'] = get_element_url($picture[$i]);
// ------ build image_path and image_url
if ($i=='current' or $i=='next')
{
$picture[$i]['image_path'] = get_image_path( $picture[$i] );
$picture[$i]['image_url'] = get_image_url( $picture[$i] );
}
if ($i=='current')
{
if ( $picture[$i]['is_picture'] )
{
if ( $user['enabled_high']=='true' )
{
$hi_url=get_high_url($picture[$i]);
if ( !empty($hi_url) )
{
$picture[$i]['high_url'] = $hi_url;
$picture[$i]['download_url'] = get_download_url('h',$picture[$i]);
}
}
}
else
{ // not a pic - need download link
$picture[$i]['download_url'] = get_download_url('e',$picture[$i]);
}
}
$picture[$i]['thumbnail'] = get_thumbnail_url($row);
if ( !empty( $row['name'] ) )
{
$picture[$i]['name'] = $row['name'];
}
else
{
$file_wo_ext = get_filename_wo_extension($row['file']);
$picture[$i]['name'] = str_replace('_', ' ', $file_wo_ext);
}
$picture[$i]['url'] = duplicate_picture_url(
array(
'image_id' => $row['id'],
'image_file' => $row['file'],
),
array(
'start',
)
);
if ('previous'==$i and $page['previous_item']==$page['first_item'])
{
$picture['first'] = $picture[$i];
}
if ('next'==$i and $page['next_item']==$page['last_item'])
{
$picture['last'] = $picture[$i];
}
}
// calculation of width and height for the current picture
if (empty($picture['current']['width']))
{
$taille_image = @getimagesize($picture['current']['image_path']);
if ($taille_image!==false)
{
$picture['current']['width'] = $taille_image[0];
$picture['current']['height']= $taille_image[1];
}
}
if (!empty($picture['current']['width']))
{
list(
$picture['current']['scaled_width'],
$picture['current']['scaled_height']
) = get_picture_size(
$picture['current']['width'],
$picture['current']['height'],
@$user['maxwidth'],
@$user['maxheight']
);
}
$slideshow_params = array();
$slideshow_url_params = array();
if (isset($_GET['slideshow']))
{
$page['slideshow'] = true;
$page['meta_robots'] = array('noindex'=>1, 'nofollow'=>1);
$slideshow_params = decode_slideshow_params($_GET['slideshow']);
$slideshow_url_params['slideshow'] = encode_slideshow_params($slideshow_params);
if ($slideshow_params['play'])
{
$id_pict_redirect = '';
if (isset($page['next_item']))
{
$id_pict_redirect = 'next';
}
else
{
if ($slideshow_params['repeat'] and isset($page['first_item']))
{
$id_pict_redirect = 'first';
}
}
if (!empty($id_pict_redirect))
{
// $refresh, $url_link and $title are required for creating
// an automated refresh page in header.tpl
$refresh = $slideshow_params['period'];
$url_link = add_url_params(
$picture[$id_pict_redirect]['url'],
$slideshow_url_params
);
}
}
}
else
{
$page['slideshow'] = false;
}
if ($page['slideshow'] and $conf['light_slideshow'])
{
$template->set_filenames( array('slideshow' => 'slideshow.tpl'));
}
else
{
$template->set_filenames( array('picture' => 'picture.tpl'));
}
$title = $picture['current']['name'];
$title_nb = ($page['current_rank'] + 1).'/'.count($page['items']);
// metadata
$url_metadata = duplicate_picture_url();
$url_metadata = add_url_params( $url_metadata, array('metadata'=>null) );
// do we have a plugin that can show metadata for something else than images?
$metadata_showable = trigger_event(
'get_element_metadata_available',
(
($conf['show_exif'] or $conf['show_iptc'])
and isset($picture['current']['image_path'])
),
$picture['current']['path']
);
if ( $metadata_showable and pwg_get_session_var('show_metadata') )
{
$page['meta_robots']=array('noindex'=>1, 'nofollow'=>1);
}
$page['body_id'] = 'thePicturePage';
// allow plugins to change what we computed before passing data to template
$picture = trigger_event('picture_pictures_data', $picture);
if (isset($picture['next']['image_url'])
and $picture['next']['is_picture'] )
{
$template->assign('U_PREFETCH', $picture['next']['image_url'] );
}
//------------------------------------------------------- navigation management
foreach (array('first','previous','next','last', 'current') as $which_image)
{
if (isset($picture[$which_image]))
{
$template->assign(
$which_image,
array_merge(
$picture[$which_image],
array(
'TITLE' => $picture[$which_image]['name'],
'THUMB_SRC' => $picture[$which_image]['thumbnail'],
// Params slideshow was transmit to navigation buttons
'U_IMG' =>
add_url_params(
$picture[$which_image]['url'], $slideshow_url_params),
)
)
);
if ($conf['picture_download_icon'] and !empty($picture['current']['download_url']))
{
$template->append($which_image, array('U_DOWNLOAD' => $picture['current']['download_url']), true);
}
}
}
if ($page['slideshow'])
{
$tpl_slideshow = array();
//slideshow end
$template->assign(
array(
'U_SLIDESHOW_STOP' => $picture['current']['url'],
)
);
foreach (array('repeat', 'play') as $p)
{
$var_name =
'U_'
.($slideshow_params[$p] ? 'STOP_' : 'START_')
.strtoupper($p);
$tpl_slideshow[$var_name] =
add_url_params(
$picture['current']['url'],
array('slideshow' =>
encode_slideshow_params(
array_merge($slideshow_params,
array($p => ! $slideshow_params[$p]))
)
)
);
}
foreach (array('dec', 'inc') as $op)
{
$new_period = $slideshow_params['period'] + ((($op == 'dec') ? -1 : 1) * $conf['slideshow_period_step']);
$new_slideshow_params =
correct_slideshow_params(
array_merge($slideshow_params,
array('period' => $new_period)));
if ($new_slideshow_params['period'] === $new_period)
{
$var_name = 'U_'.strtoupper($op).'_PERIOD';
$tpl_slideshow[$var_name] =
add_url_params(
$picture['current']['url'],
array('slideshow' => encode_slideshow_params($new_slideshow_params)
)
);
}
}
$template->assign('slideshow', $tpl_slideshow );
}
elseif ($conf['picture_slideshow_icon'])
{
$template->assign(
array(
'U_SLIDESHOW_START' =>
add_url_params(
$picture['current']['url'],
array( 'slideshow'=>''))
)
);
}
$template->assign(
array(
'SECTION_TITLE' => $page['title'],
'PHOTO' => $title_nb,
'SHOW_PICTURE_NAME_ON_TITLE' => $conf['show_picture_name_on_title'],
'IS_HOME' => ('categories'==$page['section'] and !isset($page['category']) ),
'LEVEL_SEPARATOR' => $conf['level_separator'],
'U_UP' => $url_up,
'DISPLAY_NAV_BUTTONS' => $conf['picture_navigation_icons'],
'DISPLAY_NAV_THUMB' => $conf['picture_navigation_thumb']
)
);
if ($conf['picture_metadata_icon'])
{
$template->assign('U_METADATA', $url_metadata);
}
//------------------------------------------------------- upper menu management
// admin links
if (is_admin())
{
if (isset($page['category']))
{
$template->assign(
array(
'U_SET_AS_REPRESENTATIVE' => add_url_params($url_self,
array('action'=>'set_as_representative')
)
)
);
}
$url_admin =
get_root_url().'admin.php?page=picture_modify'
.'&cat_id='.(isset($page['category']) ? $page['category']['id'] : '')
.'&image_id='.$page['image_id'];
$template->assign(
array(
'U_CADDIE' => add_url_params($url_self,
array('action'=>'add_to_caddie')
),
'U_ADMIN' => $url_admin,
)
);
$template->assign('available_permission_levels', get_privacy_level_options());
}
// favorite manipulation
if (!is_a_guest() and $conf['picture_favorite_icon'])
{
// verify if the picture is already in the favorite of the user
$query = '
SELECT COUNT(*) AS nb_fav
FROM '.FAVORITES_TABLE.'
WHERE image_id = '.$page['image_id'].'
AND user_id = '.$user['id'].'
;';
$row = pwg_db_fetch_assoc( pwg_query($query) );
$is_favorite = $row['nb_fav'] != 0;
$template->assign(
'favorite',
array(
'IS_FAVORITE' => $is_favorite,
'FAVORITE_IMG' =>
get_root_url().get_themeconf('icon_dir').(!$is_favorite ? '/favorite.png' : '/del_favorite.png' ),
'FAVORITE_HINT' => l10n( !$is_favorite ? 'add this image to your favorites' : 'delete this image from your favorites'),
'U_FAVORITE' => add_url_params(
$url_self,
array('action'=> !$is_favorite ? 'add_to_favorites' : 'remove_from_favorites' )
),
)
);
}
//--------------------------------------------------------- picture information
// legend
if (isset($picture['current']['comment'])
and !empty($picture['current']['comment']))
{
$template->assign(
'COMMENT_IMG',
trigger_event('render_element_description',
$picture['current']['comment'])
);
}
$infos = array();
// author
if (!empty($picture['current']['author']))
{
$infos['INFO_AUTHOR'] =
// FIXME because of search engine partial rewrite, giving the author
// name threw GET is not supported anymore. This feature should come
// back later, with a better design
// ''.$picture['current']['author'].'';
$picture['current']['author'];
}
// creation date
if (!empty($picture['current']['date_creation']))
{
$val = format_date($picture['current']['date_creation']);
$url = make_index_url(
array(
'chronology_field'=>'created',
'chronology_style'=>'monthly',
'chronology_view'=>'list',
'chronology_date' => explode('-', $picture['current']['date_creation'])
)
);
$infos['INFO_CREATION_DATE'] =
''.$val.'';
}
// date of availability
$val = format_date($picture['current']['date_available']);
$url = make_index_url(
array(
'chronology_field'=>'posted',
'chronology_style'=>'monthly',
'chronology_view'=>'list',
'chronology_date' => explode(
'-',
substr($picture['current']['date_available'], 0, 10)
)
)
);
$infos['INFO_POSTED_DATE'] = ''.$val.'';
// size in pixels
if ($picture['current']['is_picture'] and isset($picture['current']['width']) )
{
if ($picture['current']['scaled_width'] !== $picture['current']['width'] )
{
$infos['INFO_DIMENSIONS'] =
''.
$picture['current']['width'].'*'.$picture['current']['height'].'';
}
else
{
$infos['INFO_DIMENSIONS'] =
$picture['current']['width'].'*'.$picture['current']['height'];
}
}
// filesize
if (!empty($picture['current']['filesize']))
{
$infos['INFO_FILESIZE'] =
sprintf(l10n('%d Kb'), $picture['current']['filesize']);
}
// number of visits
$infos['INFO_VISITS'] = $picture['current']['hit'];
// file
$infos['INFO_FILE'] = $picture['current']['file'];
$template->assign($infos);
$template->assign('display_info', unserialize($conf['picture_informations']));
// related tags
$tags = get_common_tags( array($page['image_id']), -1);
if ( count($tags) )
{
foreach ($tags as $tag)
{
$template->append(
'related_tags',
array_merge( $tag,
array(
'URL' => make_index_url(
array(
'tags' => array($tag)
)
),
'U_TAG_IMAGE' => duplicate_picture_url(
array(
'section' => 'tags',
'tags' => array($tag)
)
)
)
)
);
}
}
// related categories
if ( count($related_categories)==1 and
isset($page['category']) and
$related_categories[0]['category_id']==$page['category']['id'] )
{ // no need to go to db, we have all the info
$template->append(
'related_categories',
get_cat_display_name( $page['category']['upper_names'] )
);
}
else
{ // use only 1 sql query to get names for all related categories
$ids = array();
foreach ($related_categories as $category)
{// add all uppercats to $ids
$ids = array_merge($ids, explode(',', $category['uppercats']) );
}
$ids = array_unique($ids);
$query = '
SELECT id, name, permalink
FROM '.CATEGORIES_TABLE.'
WHERE id IN ('.implode(',',$ids).')';
$cat_map = hash_from_query($query, 'id');
foreach ($related_categories as $category)
{
$cats = array();
foreach ( explode(',', $category['uppercats']) as $id )
{
$cats[] = $cat_map[$id];
}
$template->append('related_categories', get_cat_display_name($cats) );
}
}
// maybe someone wants a special display (call it before page_header so that
// they can add stylesheets)
$element_content = trigger_event(
'render_element_content',
'',
$picture['current']
);
$template->assign( 'ELEMENT_CONTENT', $element_content );
// +-----------------------------------------------------------------------+
// | sub pages |
// +-----------------------------------------------------------------------+
include(PHPWG_ROOT_PATH.'include/picture_rate.inc.php');
include(PHPWG_ROOT_PATH.'include/picture_comment.inc.php');
if ($metadata_showable and pwg_get_session_var('show_metadata') <> null )
{
include(PHPWG_ROOT_PATH.'include/picture_metadata.inc.php');
}
include(PHPWG_ROOT_PATH.'include/page_header.php');
trigger_action('loc_end_picture');
if ($page['slideshow'] and $conf['light_slideshow'])
{
$template->pparse('slideshow');
}
else
{
$template->pparse('picture');
}
//------------------------------------------------------------ log informations
pwg_log($picture['current']['id'], 'picture');
include(PHPWG_ROOT_PATH.'include/page_tail.php');
?>