Subversion Repositories svnkaklik

<?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 ) )

  {