0,0 → 1,1042 |
<?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: picture.php,v $ |
// | last update : $Date: 2005/03/12 10:27:43 $ |
// | last modifier : $Author: plg $ |
// | revision : $Revision: 1.69 $ |
// +-----------------------------------------------------------------------+ |
// | 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. | |
// +-----------------------------------------------------------------------+ |
|
$rate_items = array(0,1,2,3,4,5); |
//--------------------------------------------------------------------- include |
define('PHPWG_ROOT_PATH','./'); |
include_once(PHPWG_ROOT_PATH.'include/common.inc.php'); |
//-------------------------------------------------- access authorization check |
check_cat_id( $_GET['cat'] ); |
check_login_authorization(); |
if ( isset( $page['cat'] ) and is_numeric( $page['cat'] ) ) |
{ |
check_restrictions( $page['cat'] ); |
} |
//---------------------------------------- incrementation of the number of hits |
$query = ' |
UPDATE '.IMAGES_TABLE.' |
SET hit = hit+1 |
WHERE id = '.$_GET['image_id'].' |
;'; |
@pwg_query( $query ); |
//-------------------------------------------------------------- initialization |
initialize_category( 'picture' ); |
// retrieving the number of the picture in its category (in order) |
$query = ' |
SELECT DISTINCT(id) |
FROM '.IMAGES_TABLE.' |
INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id |
'.$page['where'].' |
'.$conf['order_by'].' |
;'; |
$result = pwg_query( $query ); |
$page['num'] = 0; |
$belongs = false; |
while ($row = mysql_fetch_array($result)) |
{ |
if ($row['id'] == $_GET['image_id']) |
{ |
$belongs = true; |
break; |
} |
$page['num']++; |
} |
// if this image_id doesn't correspond to this category, an error message is |
// displayed, and execution is stopped |
if (!$belongs) |
{ |
echo '<div style="text-align:center;">'.$lang['access_forbiden'].'<br />'; |
echo '<a href="'.add_session_id( PHPWG_ROOT_PATH.'category.php' ).'">'; |
echo $lang['thumbnails'].'</a></div>'; |
exit(); |
} |
//---------------------------------------------------------- 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 = '.$_GET['image_id']; |
if ($user['forbidden_categories'] != '') |
{ |
$query.= ' |
AND category_id NOT IN ('.$user['forbidden_categories'].')'; |
} |
$query.= ' |
;'; |
$result = pwg_query($query); |
$related_categories = array(); |
while ($row = mysql_fetch_array($result)) |
{ |
array_push($related_categories, $row); |
} |
usort($related_categories, 'global_rank_compare'); |
//------------------------------------- prev, current & next picture management |
$picture = array(); |
|
if ($page['num'] == 0) |
{ |
$has_prev = false; |
} |
else |
{ |
$has_prev = true; |
} |
|
if ($page['num'] == $page['cat_nb_images'] - 1) |
{ |
$has_next = false; |
} |
else |
{ |
$has_next = true; |
} |
|
$query = ' |
SELECT DISTINCT(i.id), i.* |
FROM '.IMAGES_TABLE.' AS i |
INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON i.id = ic.image_id |
'.$page['where'].' |
'.$conf['order_by'].' |
'; |
|
if ( !$has_prev ) |
{ |
$query.= ' LIMIT 0,2'; |
} |
else |
{ |
$query.= ' LIMIT '.($page['num'] - 1).',3'; |
} |
$query.= ';'; |
|
$result = pwg_query( $query ); |
$indexes = array('prev', 'current', 'next'); |
|
foreach (array('prev', 'current', 'next') as $i) |
{ |
if ($i == 'prev' and !$has_prev) |
{ |
continue; |
} |
if ($i == 'next' and !$has_next) |
{ |
break; |
} |
|
$row = mysql_fetch_array($result); |
foreach (array_keys($row) as $key) |
{ |
if (!is_numeric($key)) |
{ |
$picture[$i][$key] = $row[$key]; |
} |
} |
|
$picture[$i]['is_picture'] = false; |
if (in_array(get_extension($row['file']), $conf['picture_ext'])) |
{ |
$picture[$i]['is_picture'] = true; |
} |
|
$cat_directory = dirname($row['path']); |
$file_wo_ext = get_filename_wo_extension($row['file']); |
|
$icon = PHPWG_ROOT_PATH.'template/'.$user['template'].'/mimetypes/'; |
$icon.= strtolower(get_extension($row['file'])).'.png'; |
|
if (isset($row['representative_ext']) and $row['representative_ext'] != '') |
{ |
$picture[$i]['src'] = $cat_directory.'/pwg_representative/'; |
$picture[$i]['src'].= $file_wo_ext.'.'.$row['representative_ext']; |
} |
else |
{ |
$picture[$i]['src'] = $icon; |
} |
// special case for picture files |
if ($picture[$i]['is_picture']) |
{ |
$picture[$i]['src'] = $row['path']; |
// if we are working on the "current" element, we search if there is a |
// high quality picture |
// FIXME : with remote pictures, this "remote fopen" takes long... |
if ($i == 'current') |
{ |
if (@fopen($cat_directory.'/pwg_high/'.$row['file'], 'r')) |
{ |
$picture[$i]['high'] = $cat_directory.'/pwg_high/'.$row['file']; |
} |
} |
} |
|
// if picture is not a file, we need the download link |
if (!$picture[$i]['is_picture']) |
{ |
$picture[$i]['download'] = $row['path']; |
} |
|
$picture[$i]['thumbnail'] = get_thumbnail_src($row['path'], @$row['tn_ext']); |
|
if ( !empty( $row['name'] ) ) |
{ |
$picture[$i]['name'] = $row['name']; |
} |
else |
{ |
$picture[$i]['name'] = str_replace('_', ' ', $file_wo_ext); |
} |
|
$picture[$i]['url'] = PHPWG_ROOT_PATH.'picture.php'; |
$picture[$i]['url'].= get_query_string_diff(array('image_id','add_fav', |
'slideshow','rate')); |
$picture[$i]['url'].= '&image_id='.$row['id']; |
} |
|
$url_up = PHPWG_ROOT_PATH.'category.php?cat='.$page['cat'].'&'; |
$url_up.= 'num='.$page['num']; |
if ( $page['cat'] == 'search' ) |
{ |
$url_up.= "&search=".$_GET['search']; |
} |
if ( $page['cat'] == 'list' ) |
{ |
$url_up.= "&list=".$_GET['list']; |
} |
|
$url_admin = PHPWG_ROOT_PATH.'admin.php?page=picture_modify'; |
$url_admin.= '&cat_id='.$page['cat']; |
$url_admin.= '&image_id='.$_GET['image_id']; |
|
$url_slide = $picture['current']['url']; |
$url_slide.= '&slideshow='.$conf['slideshow_period']; |
//----------------------------------------------------------- rate registration |
if (isset($_GET['rate']) |
and $conf['rate'] |
and !$user['is_the_guest'] |
and in_array($_GET['rate'], $rate_items)) |
{ |
$query = ' |
DELETE |
FROM '.RATE_TABLE.' |
WHERE user_id = '.$user['id'].' |
AND element_id = '.$_GET['image_id'].' |
;'; |
pwg_query($query); |
$query = ' |
INSERT INTO '.RATE_TABLE.' |
(user_id,element_id,rate) |
VALUES |
('.$user['id'].','.$_GET['image_id'].','.$_GET['rate'].') |
;'; |
pwg_query($query); |
|
// update of images.average_rate field |
$query = ' |
SELECT ROUND(AVG(rate),2) AS average_rate |
FROM '.RATE_TABLE.' |
WHERE element_id = '.$_GET['image_id'].' |
;'; |
$row = mysql_fetch_array(pwg_query($query)); |
$query = ' |
UPDATE '.IMAGES_TABLE.' |
SET average_rate = '.$row['average_rate'].' |
WHERE id = '.$_GET['image_id'].' |
;'; |
pwg_query($query); |
} |
//--------------------------------------------------------- favorite management |
if ( isset( $_GET['add_fav'] ) ) |
{ |
$query = 'DELETE FROM '.FAVORITES_TABLE; |
$query.= ' WHERE user_id = '.$user['id']; |
$query.= ' AND image_id = '.$picture['current']['id']; |
$query.= ';'; |
$result = pwg_query( $query ); |
|
if ( $_GET['add_fav'] == 1 ) |
{ |
$query = 'INSERT INTO '.FAVORITES_TABLE; |
$query.= ' (image_id,user_id) VALUES'; |
$query.= ' ('.$picture['current']['id'].','.$user['id'].')'; |
$query.= ';'; |
$result = pwg_query( $query ); |
} |
if ( !$_GET['add_fav'] and $page['cat'] == 'fav' ) |
{ |
if (!$has_prev and !$has_next) |
{ |
// there is no favorite picture anymore we redirect the user to the |
// category page |
$url = add_session_id($url_up); |
redirect($url); |
} |
else if (!$has_prev) |
{ |
$url = str_replace( '&', '&', $picture['next']['url'] ); |
$url = add_session_id( $url, true); |
} |
else |
{ |
$url = str_replace('&', '&', $picture['prev']['url'] ); |
$url = add_session_id( $url, true); |
} |
redirect( $url ); |
} |
} |
|
//------------------------------------------------------ comment registeration |
if ( isset( $_POST['content'] ) && !empty($_POST['content']) ) |
{ |
$register_comment = true; |
$author = !empty($_POST['author'])?$_POST['author']:$lang['guest']; |
// if a guest try to use the name of an already existing user, he must be |
// rejected |
if ( $author != $user['username'] ) |
{ |
$query = 'SELECT COUNT(*) AS user_exists'; |
$query.= ' FROM '.USERS_TABLE; |
$query.= " WHERE username = '".$author."'"; |
$query.= ';'; |
$row = mysql_fetch_array( pwg_query( $query ) ); |
if ( $row['user_exists'] == 1 ) |
{ |
$template->assign_block_vars( |
'information', |
array('INFORMATION'=>$lang['comment_user_exists'])); |
$register_comment = false; |
} |
} |
|
if ( $register_comment ) |
{ |
// anti-flood system |
$reference_date = time() - $conf['anti-flood_time']; |
$query = 'SELECT id FROM '.COMMENTS_TABLE; |
$query.= ' WHERE date > FROM_UNIXTIME('.$reference_date.')'; |
$query.= " AND author = '".$author."'"; |
$query.= ';'; |
if ( mysql_num_rows( pwg_query( $query ) ) == 0 |
or $conf['anti-flood_time'] == 0 ) |
{ |
$query = 'INSERT INTO '.COMMENTS_TABLE; |
$query.= ' (author,date,image_id,content,validated) VALUES ('; |
$query.= "'".$author."'"; |
$query.= ',NOW(),'.$_GET['image_id']; |
$query.= ",'".htmlspecialchars( $_POST['content'], ENT_QUOTES)."'"; |
if ( !$conf['comments_validation'] or $user['status'] == 'admin' ) |
{ |
$query.= ",'true'"; |
} |
else |
{ |
$query.= ",'false'"; |
} |
$query.= ');'; |
pwg_query( $query ); |
// information message |
$message = $lang['comment_added']; |
if ( $conf['comments_validation'] and $user['status'] != 'admin' ) |
{ |
$message.= '<br />'.$lang['comment_to_validate']; |
} |
$template->assign_block_vars('information', |
array('INFORMATION'=>$message)); |
// notification to the administrators |
if ( $conf['mail_notification'] ) |
{ |
// find any related category (can be unreachable to this admin) |
$category = $related_categories[0]; |
// locally, we change the $conf['level_separator'] |
$conf_separator = $conf['level_separator']; |
$conf['level_separator'] = ' > '; |
$cat_name = get_cat_display_name_cache($category['uppercats'], |
'', |
false); |
$conf['level_separator'] = $conf_separator; |
|
$cat_name = strip_tags( $cat_name ); |
notify( 'comment', $cat_name.' > '.$picture['current']['name']); |
} |
} |
else |
{ |
// information message |
$template->assign_block_vars( |
'information', |
array('INFORMATION'=>$lang['comment_anti-flood'])); |
} |
} |
} |
// comment deletion |
if ( isset( $_GET['del'] ) |
and is_numeric( $_GET['del'] ) |
and $user['status'] == 'admin' ) |
{ |
$query = 'DELETE FROM '.COMMENTS_TABLE; |
$query.= ' WHERE id = '.$_GET['del']; |
$query.= ';'; |
pwg_query( $query ); |
} |
|
// |
// Start output of page |
// |
|
$title = $picture['current']['name']; |
$refresh = 0; |
if ( isset( $_GET['slideshow'] ) and $has_next ) |
{ |
$refresh= $_GET['slideshow']; |
$url_link = $picture['next']['url'].'&slideshow='.$refresh; |
} |
|
$title_img = $picture['current']['name']; |
$title_nb = ''; |
if (is_numeric( $page['cat'] )) |
{ |
$title_img = replace_space(get_cat_display_name($page['cat_name'])); |
$n = $page['num'] + 1; |
$title_nb = $n.'/'.$page['cat_nb_images']; |
} |
else if ( $page['cat'] == 'search' ) |
{ |
$title_img = replace_search( $title_img, $_GET['search'] ); |
} |
|
// calculation of width and height |
if (empty($picture['current']['width'])) |
{ |
$taille_image = @getimagesize($picture['current']['src']); |
$original_width = $taille_image[0]; |
$original_height = $taille_image[1]; |
} |
else |
{ |
$original_width = $picture['current']['width']; |
$original_height = $picture['current']['height']; |
} |
|
$picture_size = get_picture_size($original_width, $original_height, |
@$user['maxwidth'], @$user['maxheight']); |
|
// metadata |
if ($conf['show_exif'] or $conf['show_iptc']) |
{ |
$metadata_showable = true; |
} |
else |
{ |
$metadata_showable = false; |
} |
|
$url_metadata = PHPWG_ROOT_PATH.'picture.php'; |
$url_metadata .= get_query_string_diff(array('add_fav', 'slideshow', 'show_metadata')); |
if ($metadata_showable and !isset($_GET['show_metadata'])) |
{ |
$url_metadata.= '&show_metadata=1'; |
} |
|
include(PHPWG_ROOT_PATH.'include/page_header.php'); |
$template->set_filenames(array('picture'=>'picture.tpl')); |
|
$template->assign_vars(array( |
'CATEGORY' => $title_img, |
'PHOTO' => $title_nb, |
'TITLE' => $picture['current']['name'], |
'SRC_IMG' => $picture['current']['src'], |
'ALT_IMG' => $picture['current']['file'], |
'WIDTH_IMG' => $picture_size[0], |
'HEIGHT_IMG' => $picture_size[1], |
|
'LEVEL_SEPARATOR' => $conf['level_separator'], |
|
'L_HOME' => $lang['home'], |
'L_SLIDESHOW' => $lang['slideshow'], |
'L_STOP_SLIDESHOW' => $lang['slideshow_stop'], |
'L_PREV_IMG' =>$lang['previous_page'].' : ', |
'L_NEXT_IMG' =>$lang['next_page'].' : ', |
'L_ADMIN' =>$lang['link_info_image'], |
'L_COMMENT_TITLE' =>$lang['comments_title'], |
'L_ADD_COMMENT' =>$lang['comments_add'], |
'L_DELETE_COMMENT' =>$lang['comments_del'], |
'L_DELETE' =>$lang['delete'], |
'L_SUBMIT' =>$lang['submit'], |
'L_AUTHOR' =>$lang['author'], |
'L_COMMENT' =>$lang['comment'], |
'L_DOWNLOAD' => $lang['download'], |
'L_DOWNLOAD_HINT' => $lang['download_hint'], |
'L_PICTURE_METADATA' => $lang['picture_show_metadata'], |
'L_PICTURE_HIGH' => $lang['picture_high'], |
'L_UP_HINT' => $lang['home_hint'], |
'L_UP_ALT' => $lang['home'], |
|
'U_HOME' => add_session_id(PHPWG_ROOT_PATH.'category.php'), |
'U_UP' => add_session_id($url_up), |
'U_METADATA' => add_session_id($url_metadata), |
'U_ADMIN' => add_session_id($url_admin), |
'U_SLIDESHOW'=> add_session_id($url_slide), |
'U_ADD_COMMENT' => add_session_id(str_replace( '&', '&', $_SERVER['REQUEST_URI'] )) |
) |
); |
//------------------------------------------------------- upper menu management |
// download link if file is not a picture |
if (!$picture['current']['is_picture']) |
{ |
$template->assign_block_vars( |
'download', |
array('U_DOWNLOAD' => $picture['current']['download'])); |
} |
else |
{ |
$template->assign_block_vars( |
'ecard', |
array('U_ECARD' => $picture['current']['url'])); |
} |
// display a high quality link if present |
if (isset($picture['current']['high'])) |
{ |
$full_size = @getimagesize($picture['current']['high']); |
$full_width = $full_size[0]; |
$full_height = $full_size[1]; |
$uuid = uniqid(rand()); |
$template->assign_block_vars('high', array( |
'U_HIGH' => $picture['current']['high'], |
'UUID'=>$uuid, |
'WIDTH_IMG'=>($full_width + 16), |
'HEIGHT_IMG'=>($full_height + 16) |
)); |
} |
//------------------------------------------------------- favorite manipulation |
if ( !$user['is_the_guest'] ) |
{ |
// verify if the picture is already in the favorite of the user |
$query = 'SELECT COUNT(*) AS nb_fav'; |
$query.= ' FROM '.FAVORITES_TABLE.' WHERE image_id = '.$_GET['image_id']; |
$query.= ' AND user_id = '.$user['id'].';'; |
$result = pwg_query( $query ); |
$row = mysql_fetch_array( $result ); |
if (!$row['nb_fav']) |
{ |
$url = PHPWG_ROOT_PATH.'picture.php'; |
$url.= get_query_string_diff(array('rate','add_fav')); |
$url.= '&add_fav=1'; |
|
$template->assign_block_vars( |
'favorite', |
array( |
'FAVORITE_IMG' => PHPWG_ROOT_PATH.'template/'.$user['template'].'/theme/favorite.gif', |
'FAVORITE_HINT' =>$lang['add_favorites_hint'], |
'FAVORITE_ALT' =>$lang['add_favorites_alt'], |
'U_FAVORITE' => $url |
)); |
} |
else |
{ |
$url = PHPWG_ROOT_PATH.'picture.php'; |
$url.= get_query_string_diff(array('rate','add_fav')); |
$url.= '&add_fav=0'; |
|
$template->assign_block_vars( |
'favorite', |
array( |
'FAVORITE_IMG' => PHPWG_ROOT_PATH.'template/'.$user['template'].'/theme/del_favorite.gif', |
'FAVORITE_HINT' =>$lang['del_favorites_hint'], |
'FAVORITE_ALT' =>$lang['del_favorites_alt'], |
'U_FAVORITE'=> $url |
)); |
} |
} |
//------------------------------------ admin link for information modifications |
if ( $user['status'] == 'admin' ) |
{ |
$template->assign_block_vars('admin', array()); |
} |
|
//-------------------------------------------------------- navigation management |
if ($has_prev) |
{ |
$template->assign_block_vars( |
'previous', |
array( |
'TITLE_IMG' => $picture['prev']['name'], |
'IMG' => $picture['prev']['thumbnail'], |
'U_IMG' => add_session_id($picture['prev']['url']) |
)); |
} |
|
if ($has_next) |
{ |
$template->assign_block_vars( |
'next', |
array( |
'TITLE_IMG' => $picture['next']['name'], |
'IMG' => $picture['next']['thumbnail'], |
'U_IMG' => add_session_id($picture['next']['url']) |
)); |
} |
|
//--------------------------------------------------------- picture information |
// legend |
if (isset($picture['current']['comment']) |
and !empty($picture['current']['comment'])) |
{ |
$template->assign_block_vars( |
'legend', |
array( |
'COMMENT_IMG' => nl2br($picture['current']['comment']) |
)); |
} |
|
// author |
if ( !empty($picture['current']['author']) ) |
{ |
$search_url = PHPWG_ROOT_PATH.'category.php?cat=search'; |
$search_url.= '&search=author:'.$picture['current']['author']; |
|
$value = '<a href="'; |
$value.= add_session_id($search_url); |
$value.= '">'.$picture['current']['author'].'</a>'; |
|
$template->assign_block_vars( |
'info_line', |
array( |
'INFO'=>$lang['author'], |
'VALUE'=>$value |
)); |
} |
// creation date |
if ( !empty($picture['current']['date_creation']) ) |
{ |
$search_url = PHPWG_ROOT_PATH.'category.php?cat=search'; |
$search_url.= '&search='; |
$search_url.= 'date_creation:'.$picture['current']['date_creation']; |
|
$value = '<a href="'; |
$value.= add_session_id($search_url); |
$value.= '">'.format_date($picture['current']['date_creation']).'</a>'; |
|
$template->assign_block_vars( |
'info_line', |
array( |
'INFO'=>$lang['creation_date'], |
'VALUE'=>$value |
)); |
} |
// date of availability |
$search_url = PHPWG_ROOT_PATH.'category.php?cat=search'; |
$search_url.= '&search='; |
$search_url.= 'date_available:'.$picture['current']['date_available']; |
|
$value = '<a href="'; |
$value.= add_session_id($search_url); |
$value.= '">'.format_date($picture['current']['date_available']).'</a>'; |
|
$template->assign_block_vars( |
'info_line', |
array( |
'INFO'=>$lang['registration_date'], |
'VALUE'=>$value |
)); |
// size in pixels |
if ($picture['current']['is_picture']) |
{ |
if ($original_width != $picture_size[0] |
or $original_height != $picture_size[1]) |
{ |
$content = '[ <a href="'.$picture['current']['src'].'" '; |
$content.= ' title="'.$lang['true_size'].'">'; |
$content.= $original_width.'*'.$original_height.'</a> ]'; |
} |
else |
{ |
$content = $original_width.'*'.$original_height; |
} |
$template->assign_block_vars( |
'info_line', |
array( |
'INFO'=>$lang['size'], |
'VALUE'=>$content |
)); |
} |
// file |
$template->assign_block_vars('info_line', array( |
'INFO'=>$lang['file'], |
'VALUE'=>$picture['current']['file'] |
)); |
// filesize |
if (empty($picture['current']['filesize'])) |
{ |
if (!$picture['current']['is_picture']) |
{ |
$filesize = floor(filesize($picture['current']['download'])/1024); |
} |
else |
{ |
$filesize = floor(filesize($picture['current']['src'])/1024); |
} |
} |
else |
{ |
$filesize = $picture['current']['filesize']; |
} |
|
$template->assign_block_vars('info_line', array( |
'INFO'=>$lang['filesize'], |
'VALUE'=>$filesize.' KB' |
)); |
// keywords |
if (!empty($picture['current']['keywords'])) |
{ |
$keywords = explode(',', $picture['current']['keywords']); |
$content = ''; |
$url = PHPWG_ROOT_PATH.'category.php?cat=search&search=keywords:'; |
foreach ($keywords as $i => $keyword) |
{ |
$local_url = add_session_id($url.$keyword); |
if ($i > 0) |
{ |
$content.= ','; |
} |
$content.= '<a href="'.$local_url.'">'.$keyword.'</a>'; |
} |
$template->assign_block_vars( |
'info_line', |
array( |
'INFO'=>$lang['keywords'], |
'VALUE'=>$content |
)); |
} |
// number of visits |
$template->assign_block_vars( |
'info_line', |
array( |
'INFO'=>$lang['visited'], |
'VALUE'=>$picture['current']['hit'].' '.$lang['times'] |
)); |
// rate results |
if ($conf['rate']) |
{ |
$query = ' |
SELECT COUNT(rate) AS count |
, ROUND(AVG(rate),2) AS average |
, ROUND(STD(rate),2) AS STD |
FROM '.RATE_TABLE.' |
WHERE element_id = '.$picture['current']['id'].' |
;'; |
$row = mysql_fetch_array(pwg_query($query)); |
if ($row['count'] == 0) |
{ |
$value = $lang['no_rate']; |
} |
else |
{ |
$value = $row['average']; |
$value.= ' ('; |
$value.= $row['count'].' '.$lang['rates']; |
$value.= ', '.$lang['standard_deviation'].' : '.$row['STD']; |
$value.= ')'; |
} |
|
$template->assign_block_vars( |
'info_line', |
array( |
'INFO' => $lang['element_rate'], |
'VALUE' => $value |
)); |
} |
// related categories |
$cat_output = ''; |
$page['show_comments'] = false; |
foreach ($related_categories as $category) |
{ |
if ($cat_output != '') |
{ |
$cat_output.= '<br />'; |
} |
|
if (count($related_categories) > 3) |
{ |
$cat_output .= get_cat_display_name_cache($category['uppercats']); |
} |
else |
{ |
$cat_info = get_cat_info($category['category_id']); |
$cat_output .= get_cat_display_name($cat_info['name']); |
} |
// the picture is commentable if it belongs at least to one category which |
// is commentable |
if ($category['commentable'] == 'true') |
{ |
$page['show_comments'] = true; |
} |
} |
$template->assign_block_vars( |
'info_line', |
array( |
'INFO' => $lang['categories'], |
'VALUE' => $cat_output |
)); |
// metadata |
if ($metadata_showable and isset($_GET['show_metadata'])) |
{ |
include_once(PHPWG_ROOT_PATH.'/include/functions_metadata.inc.php'); |
$template->assign_block_vars('metadata', array()); |
if ($conf['show_exif']) |
{ |
if (!function_exists('read_exif_data')) |
{ |
die('Exif extension not available, admin should disable exif display'); |
} |
|
if ($exif = @read_exif_data($picture['current']['src'])) |
{ |
$template->assign_block_vars( |
'metadata.headline', |
array('TITLE' => 'EXIF Metadata') |
); |
|
foreach ($conf['show_exif_fields'] as $field) |
{ |
if (strpos($field, ';') === false) |
{ |
if (isset($exif[$field])) |
{ |
$key = $field; |
if (isset($lang['exif_field_'.$field])) |
{ |
$key = $lang['exif_field_'.$field]; |
} |
|
$template->assign_block_vars( |
'metadata.line', |
array( |
'KEY' => $key, |
'VALUE' => $exif[$field] |
) |
); |
} |
} |
else |
{ |
$tokens = explode(';', $field); |
if (isset($exif[$tokens[0]][$tokens[1]])) |
{ |
$key = $tokens[1]; |
if (isset($lang['exif_field_'.$tokens[1]])) |
{ |
$key = $lang['exif_field_'.$tokens[1]]; |
} |
|
$template->assign_block_vars( |
'metadata.line', |
array( |
'KEY' => $key, |
'VALUE' => $exif[$tokens[0]][$tokens[1]] |
) |
); |
} |
} |
} |
} |
} |
if ($conf['show_iptc']) |
{ |
$iptc = get_iptc_data($picture['current']['src'], |
$conf['show_iptc_mapping']); |
|
if (count($iptc) > 0) |
{ |
$template->assign_block_vars( |
'metadata.headline', |
array('TITLE' => 'IPTC Metadata') |
); |
} |
|
foreach ($iptc as $field => $value) |
{ |
$key = $field; |
if (isset($lang[$field])) |
{ |
$key = $lang[$field]; |
} |
|
$template->assign_block_vars( |
'metadata.line', |
array( |
'KEY' => $key, |
'VALUE' => $value |
) |
); |
} |
} |
} |
//slideshow end |
if ( isset( $_GET['slideshow'] ) ) |
{ |
if ( !is_numeric( $_GET['slideshow'] ) ) $_GET['slideshow'] = $conf['slideshow_period']; |
|
$template->assign_block_vars('stop_slideshow', array( |
'U_SLIDESHOW'=>add_session_id( $picture['current']['url'] ) |
)); |
} |
|
//------------------------------------------------------------------- rate form |
if ($conf['rate'] and !$user['is_the_guest']) |
{ |
$query = ' |
SELECT rate |
FROM '.RATE_TABLE.' |
WHERE user_id = '.$user['id'].' |
AND element_id = '.$_GET['image_id'].' |
;'; |
$result = pwg_query($query); |
if (mysql_num_rows($result) > 0) |
{ |
$row = mysql_fetch_array($result); |
$sentence = $lang['already_rated']; |
$sentence.= ' ('.$row['rate'].'). '; |
$sentence.= $lang['update_rate']; |
} |
else |
{ |
$sentence = $lang['never_rated'].'. '.$lang['to_rate']; |
} |
$template->assign_block_vars( |
'rate', |
array('SENTENCE' => $sentence) |
); |
|
|
foreach ($rate_items as $num => $mark) |
{ |
if ($num > 0) |
{ |
$separator = '|'; |
} |
else |
{ |
$separator = ''; |
} |
|
$url = PHPWG_ROOT_PATH.'picture.php'; |
$url.= get_query_string_diff(array('rate','add_fav')); |
$url.= '&rate='.$mark; |
|
$template->assign_block_vars( |
'rate.rate_option', |
array( |
'OPTION' => $mark, |
'URL' => $url, |
'SEPARATOR' => $separator |
)); |
} |
} |
//---------------------------------------------------- users's comments display |
if ($page['show_comments']) |
{ |
// number of comment for this picture |
$query = 'SELECT COUNT(*) AS nb_comments'; |
$query.= ' FROM '.COMMENTS_TABLE.' WHERE image_id = '.$_GET['image_id']; |
$query.= " AND validated = 'true'"; |
$query.= ';'; |
$row = mysql_fetch_array( pwg_query( $query ) ); |
|
// navigation bar creation |
$url = PHPWG_ROOT_PATH.'picture.php'; |
$url.= get_query_string_diff(array('rate','add_fav')); |
|
if (!isset( $_GET['start'] ) |
or !is_numeric( $_GET['start'] ) |
or ( is_numeric( $_GET['start'] ) and $_GET['start'] < 0 ) ) |
{ |
$page['start'] = 0; |
} |
else |
{ |
$page['start'] = $_GET['start']; |
} |
$page['navigation_bar'] = create_navigation_bar( $url, $row['nb_comments'], |
$page['start'], |
$conf['nb_comment_page'], |
'' ); |
$template->assign_block_vars('comments', array( |
'NB_COMMENT'=>$row['nb_comments'], |
'NAV_BAR'=>$page['navigation_bar'])); |
|
$query = 'SELECT id,author,date,image_id,content'; |
$query.= ' FROM '.COMMENTS_TABLE.' WHERE image_id = '.$_GET['image_id']; |
$query.= " AND validated = 'true'"; |
$query.= ' ORDER BY date ASC'; |
$query.= ' LIMIT '.$page['start'].', '.$conf['nb_comment_page'].';'; |
$result = pwg_query( $query ); |
|
while ( $row = mysql_fetch_array( $result ) ) |
{ |
$template->assign_block_vars( |
'comments.comment', |
array( |
'COMMENT_AUTHOR'=>empty($row['author'])?$lang['guest']:$row['author'], |
'COMMENT_DATE'=>format_date($row['date'], 'mysql_datetime', true), |
'COMMENT'=>parse_comment_content($row['content']) |
)); |
|
if ( $user['status'] == 'admin' ) |
{ |
$template->assign_block_vars( |
'comments.comment.delete', |
array('U_COMMENT_DELETE'=>add_session_id( $url.'&del='.$row['id']) |
)); |
} |
} |
|
if (!$user['is_the_guest'] |
or ($user['is_the_guest'] and $conf['comments_forall'])) |
{ |
$template->assign_block_vars('comments.add_comment', array()); |
// display author field if the user is not logged in |
if (!$user['is_the_guest']) |
{ |
$template->assign_block_vars( |
'comments.add_comment.author_known', |
array('KNOWN_AUTHOR'=>$user['username']) |
); |
} |
else |
{ |
$template->assign_block_vars( |
'comments.add_comment.author_field', array() |
); |
} |
} |
} |
//------------------------------------------------------------ log informations |
pwg_log( 'picture', $title_img, $picture['current']['file'] ); |
mysql_close(); |
|
$template->parse('picture'); |
include(PHPWG_ROOT_PATH.'include/page_tail.php'); |
?> |