##############################################################################
## MOD Title: Random picture                                                 #
## MOD Author: z0rglub < pierrick@z0rglub.com > (Pierrick LE GALL)           #
##             http://www.z0rglub.com                                        #
## MOD Description: Display a random picture of the PhpWebGallery database   #
##                  outside the gallery                                      #
## MOD Version: 1.0.0 (works with PhpWebGallery 1.3)                         #
##                                                                           #
## Installation Level: easy                                                  #
## Installation Time: 5 Minutes                                              #
## Files To Edit: random.php                                                 #
## Included Files: random.php                                                #
##############################################################################
## MOD History:                                                              #
##                                                                           #
##   2003-11-01 - Version 1.0.0                                              #
##      - Initial Release :-)                                                #
##                                                                           #
##############################################################################

#
#-----[ COPY ]----------------------------------------------------------------
#
copy random.php TO the directory you want on the same website as PhpWebGallery
#
#-----[ OPEN ]----------------------------------------------------------------
#
random.php
#
#-----[ FIND ]----------------------------------------------------------------
#
define( PREFIX_INCLUDE, '../../devel/' ); // relative path to your gallery
#
#-----[ IN-LINE FIND ]--------------------------------------------------------
#
'../../devel/'
#
#-----[ IN-LINE REPLACE WITH ]------------------------------------------------
# examples : './gallery/', './phpwebgallery/', '../photos/'
'relative/path/to/my/gallery/'
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------------
#
# EoM

<?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, '../../devel/' ); // 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,forbidden_categories';
$query.= ' FROM '.PREFIX_TABLE.'users';
$query.= ' WHERE id = '.USER_ID;
$query.= ';';
$row = mysql_fetch_array( mysql_query( $query ) );
$user_status = $row['status'];
$restricted_cats = $row['forbidden_categories'];
//------------------------------------------------------------- which picture ?
$query = 'SELECT id,file,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 (';
  $query.= $restricted_cats;
  $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 = '../../../photos/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'];
//------------------------------------------------------------- display picture
echo '<a href="'.$thumb_link.'">';
echo '<img src="'.$thumb_url.'" alt="" style="border:none;" />';
echo '</a>';
?>