<?php
/***************************************************************************
 *                                 random.php                              *
 *                            -------------------                          *
 *   application   : PhpWebGallery 1.3 <http://phpwebgallery.net>          *
 *   author        : Pierrick LE GALL <pierrick@z0rglub.com>               *
 *                                                                         *
 *   $Id: random.php,v 1.1.1.1 2003/11/01 10:31:53 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( PREFIX_INCLUDE, 'photos/' ); // relative path to your gallery
define( USER_ID, 2 ); // 2 is the guest, 1 the webmaster
//-------------------------------------------------------------------- includes
include( PREFIX_INCLUDE.'include/functions.inc.php' );
database_connection();
//-------------------------------------------------- configuraiton informations
$query = 'SELECT prefix_thumbnail';
$query.= ' FROM '.PREFIX_TABLE.'config';
$query.= ';';
$row = mysql_fetch_array( mysql_query( $query ) );
$prefix_thumbnail = $row['prefix_thumbnail'];
//----------------------------------------------------------- user informations
$query = 'SELECT status';
$query.= ' FROM '.PREFIX_TABLE.'users';
$query.= ' WHERE id = '.USER_ID;
$query.= ';';
$row = mysql_fetch_array( mysql_query( $query ) );
$user_status = $row['status'];


//-----------------fonction enlev&eacute;e--------$restricted_cats = get_all_restrictions( USER_ID, $user_status );
//------------------------------------------------------------- which picture ?
$query = 'SELECT id,file,author,storage_category_id,tn_ext,category_id';
$query.= ' FROM '.PREFIX_TABLE.'images';
$query.= ' LEFT JOIN '.PREFIX_TABLE.'image_category AS ic ON id = ic.image_id';
if ( count( $restricted_cats ) > 0 )
{
  $query.= ' WHERE category_id NOT IN (';
  foreach ( $restricted_cats as $i => $restricted_cat ) {
    if ( $i > 0 ) $query.= ',';
    $query.= $restricted_cat;
  }
  $query.= ')';
}
$query.= ' ORDER BY RAND()';
$query.= ' LIMIT 0,1';
$query.= ';';

$result = mysql_query( $query );
$row = mysql_fetch_array( $result );




// create directory where the thumbnail can be found
$site_url = get_site_url( $row['storage_category_id'] );
if ( $site_url == './galleries/' ) $site_url = PREFIX_INCLUDE.'galleries/';
$cat_directory = $site_url.get_local_dir( $row['storage_category_id'] );
// file to display
$file = get_filename_wo_extension( $row['file'] );
// URL of the thumbnail
$thumb_url = $cat_directory.'thumbnail/';
$thumb_url.= $prefix_thumbnail.$file.'.'.$row['tn_ext'];
// link to the gallery
$thumb_link = PREFIX_INCLUDE.'picture.php';
$thumb_link.= '?cat='.$row['category_id'];
$thumb_link.= '&amp;image_id='.$row['id'];

// afficher id catégorie
$id_categorie = $row['storage_category_id'];

// afficher auteur
  $auteur = 'Photographe: <b>'.$row['author'].'</b>';

//------------------------------------------------------------- display picture
echo ''.$id_categorie;
echo '<a href="'.$thumb_link.'" target="_blank">';
echo '<div align="center"><img src="'.$thumb_url.'" alt="" style="border:1px solid black;"/><div>';
echo '</a>';
echo ''.$auteur ;
  
?>