<?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', 'abonnes16S/' ); // 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 );
 // print $row['path'];
  //-------------------------- thumbnail URL and direct link to related picture
  // URL of the thumbnail
 $thumb_url = PHPWG_ROOT_PATH.ereg_replace("^(.*)/([^/]*)$", "\\1/thumbnail/".$conf['prefix_thumbnail']."\\2", $row['path']);
  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 '<table align="center" width="450px" border="0" cellpadding="0" cellspacing="0">
  <tbody>
    <tr>
      <td><a href="'.$thumb_link.'" class="thumblink">
  <img src="'.$thumb_url.'" alt="" class="thumbnail" border="0"/>
  </a></td>
      <td><a href="'.$thumb_link.'" class="thumblink">
  <img src="'.$thumb_url.'" alt="" class="thumbnail" border="0"/>
  </a></td>
      <td><a href="'.$thumb_link.'" class="thumblink">
  <img src="'.$thumb_url.'" alt="" class="thumbnail" border="0"/>
  </a></td>
    </tr>
    <tr>
      <td><a href="'.$thumb_link.'" class="thumblink">
  <img src="'.$thumb_url.'" alt="" class="thumbnail" border="0"/>
  </a></td>
      <td><a href="'.$thumb_link.'" class="thumblink">
  <img src="'.$thumb_url.'" alt="" class="thumbnail" border="0"/>
  </a></td>
      <td><a href="'.$thumb_link.'" class="thumblink">
  <img src="'.$thumb_url.'" alt="" class="thumbnail" border="0"/>
  </a></td>
    </tr>
    <tr>
      <td><a href="'.$thumb_link.'" class="thumblink">
  <img src="'.$thumb_url.'" alt="" class="thumbnail" border="0"/>
  </a></td>
      <td><a href="'.$thumb_link.'" class="thumblink">
  <img src="'.$thumb_url.'" alt="" class="thumbnail" border="0"/>
  </a></td>
      <td><a href="'.$thumb_link.'" class="thumblink">
  <img src="'.$thumb_url.'" alt="" class="thumbnail" border="0"/>
  </a></td>
    </tr>
  </tbody>
</table>';
}
?>