<?php
/***************************************************************************
 *                              thumb_random.php                              *
 *                            -------------------                          *
 *   application   : PhpWebGallery 1.4 <http://phpwebgallery.net>          *
 *   author        : Pierrick LE GALL <pierrick@z0rglub.com>               *
 *                                                                         *
 *   $Id: random.php,v 1.2 2004/11/06 14:32:03 z0rglub Exp $
 *                                                                         *
 ***************************************************************************/

/***************************************************************************
 *                                                                         *
 *   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;                                         *
 *                                                                         *
 ***************************************************************************/
//--------------------------------------------------------------- configuration
define('PHPWG_ROOT_PATH', 'media.trains-idf.net/' ); // relative path to your gallery
//-------------------------------------------------------------------- includes
include_once( PHPWG_ROOT_PATH.'include/common.inc.php' );
//------------------------------------------------------------- which picture ?
$where = '';
if ( $user['forbidden_categories'] != '' )
{
  $where = 'WHERE category_id NOT IN ('.$user['forbidden_categories'].')';
}
$query = '
SELECT id, path, tn_ext, category_id
  FROM '.IMAGES_TABLE.'
    INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id
  '.$where.'
  ORDER BY RAND(NOW())
  LIMIT 0, 1;';
$result = mysql_query( $query );
if (mysql_num_rows($result) > 0)
{
  $row = mysql_fetch_array( $result );
  //-------------------------- thumbnail URL and direct link to related picture
  // URL of the thumbnail
  $thumb_url = get_thumbnail_src($row['path'], $row['tn_ext']);
  if (substr($thumb_url, 0 , 12) == './galleries/')
  {
    $thumb_url = PHPWG_ROOT_PATH.substr($thumb_url,2);
  }
  // link to the gallery
  $thumb_link = PHPWG_ROOT_PATH.'picture.php?cat='.$row['category_id']
  .'&amp;image_id='.$row['id'];
  //------------------------------ display thumbnail with related picture link
  echo '<a href="'.$thumb_link.'" class="thumblink">
  <img src="'.$thumb_url.'" alt="" class="thumbnail" />
  </a>';
}
?>