Permalink
Fetching contributors…
Cannot retrieve contributors at this time
58 lines (50 sloc) 3.2 KB
<?php
// +-----------------------------------------------------------------------+
// | Phyxo - Another web based photo gallery |
// | Copyright(C) 2014-2015 Nicolas Roudaire http://www.phyxo.net/ |
// +-----------------------------------------------------------------------+
// | Copyright(C) 2008-2014 Piwigo Team http://piwigo.org |
// | Copyright(C) 2003-2008 PhpWebGallery Team http://phpwebgallery.net |
// | Copyright(C) 2002-2003 Pierrick LE GALL http://le-gall.net/pierrick |
// +-----------------------------------------------------------------------+
// | 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 |
// | |
// | This program is distributed in the hope that it will be useful, but |
// | WITHOUT ANY WARRANTY; without even the implied warranty of |
// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU |
// | General Public License for more details. |
// | |
// | You should have received a copy of the GNU General Public License |
// | along with this program; if not, write to the Free Software |
// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, |
// | USA. |
// +-----------------------------------------------------------------------+
// +-----------------------------------------------------------------------+
// | define and include |
// +-----------------------------------------------------------------------+
define('PHPWG_ROOT_PATH','./');
include_once( PHPWG_ROOT_PATH.'include/common.inc.php' );
// +-----------------------------------------------------------------------+
// | Check Access and exit when user status is not ok |
// +-----------------------------------------------------------------------+
$services['users']->checkStatus(ACCESS_GUEST);
// +-----------------------------------------------------------------------+
// | generate random element list |
// +-----------------------------------------------------------------------+
$query = 'SELECT id FROM '.IMAGES_TABLE;
$query .= ' LEFT JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id';
$query .= ' '.get_sql_condition_FandF(array(
'forbidden_categories' => 'category_id',
'visible_categories' => 'category_id',
'visible_images' => 'id'
),
'WHERE'
);
$query .= ' ORDER BY '.$conn::RANDOM_FUNCTION.'()';
$query .= ' LIMIT '.min(50, $conf['top_number'], $user['nb_image_page']).';';
// +-----------------------------------------------------------------------+
// | redirect |
// +-----------------------------------------------------------------------+
redirect(make_index_url(array('list' => $conn->query2array($query, null, 'id'))));