<?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', '../photos/' ); // relative path to your gallery
$counter = 3; // how many picture you want (Must be > 0)
$picture_size = 0; // let to 0 for thumbnails otherwise set it to max height
//-------------------------------------------------------------------- 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, '.$counter.';'; 
$result = mysql_query( $query );
while ($row = mysql_fetch_array($result, MYSQL_BOTH))
{
  //-------------------------- 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'];
  if ( $picture_size == 0) {
  //------------------------------ display thumbnail with related picture link
    echo '<a href="'.$thumb_link.'" class="thumblink" target="_blank">
    <img src="'.$thumb_url.'" alt="" class="thumbnail" border="0"/>
    </a>';
  }  else {
  //------------------------------ display original picture in a specific size
    $picture_url = $row['path'];
    if (substr($picture_url, 0 , 12) == './galleries/')
    {    $picture_url = PHPWG_ROOT_PATH.substr($picture_url,2);    };
    echo '<a href="'.$thumb_link.'" class="thumblink">
    <img src="'.$picture_url.'" alt="" class="thumbnail" height="'.$picture_size.'" />
    </a>';
  };
}
?>