Open codebase.php, find (right at the end)
case 'randalb': // Random albums
case 'randuseralb': // Random albums in user categories
case 'randpublicalb': // Random albums in public categories
$condition = array(
'randalb' => '',
'randuseralb' => 'AND a.category > '.FIRST_USER_CAT,
'randpublicalb' => 'AND a.category < '.FIRST_USER_CAT
);
$album_name = cpg_fetch_icon('alb_mgr', 2)." ".$lang_plugin_more_meta_albums[$meta['album'].'_title'];
if ($CURRENT_CAT_NAME) {
$album_name .= " - $CURRENT_CAT_NAME";
}
$query = "SELECT COUNT(*)
FROM {$CONFIG['TABLE_PICTURES']} AS r
INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON a.aid = r.aid
$RESTRICTEDWHERE
AND approved = 'YES'
{$condition[$meta['album']]}
GROUP BY r.aid
HAVING COUNT(r.pid) > 0
ORDER BY RAND()";
$result = cpg_db_query($query);
$count = mysql_num_rows($result);
mysql_free_result($result);
$query = "SELECT p.*
FROM {$CONFIG['TABLE_PICTURES']} AS r
INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON a.aid = r.aid
$RESTRICTEDWHERE
AND approved = 'YES'
{$condition[$meta['album']]}
GROUP BY r.aid
HAVING COUNT(r.pid) > 0
ORDER BY RAND()
{$meta['limit']}";
$result = cpg_db_query($query);
$rowset = cpg_db_fetch_rowset($result);
mysql_free_result($result);
build_caption($rowset, array('ctime'));
break;
and replace with
case 'randalb': // Random albums
case 'randuseralb': // Random albums in user categories
case 'randpublicalb': // Random albums in public categories
$condition = array(
'randalb' => '',
'randuseralb' => 'AND r.category > '.FIRST_USER_CAT,
'randpublicalb' => 'AND r.category < '.FIRST_USER_CAT
);
$album_name = cpg_fetch_icon('alb_mgr', 2)." ".$lang_plugin_more_meta_albums[$meta['album'].'_title'];
if ($CURRENT_CAT_NAME) {
$album_name .= " - $CURRENT_CAT_NAME";
}
$query = "SELECT COUNT(*)
FROM {$CONFIG['TABLE_PICTURES']} AS p
INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS r ON r.aid = p.aid
$RESTRICTEDWHERE
AND approved = 'YES'
{$condition[$meta['album']]}
GROUP BY p.aid
HAVING COUNT(p.pid) > 0
ORDER BY RAND()";
$result = cpg_db_query($query);
$count = mysql_num_rows($result);
mysql_free_result($result);
$query = "SELECT p.*
FROM {$CONFIG['TABLE_PICTURES']} AS p
INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS r ON r.aid = p.aid
$RESTRICTEDWHERE
AND approved = 'YES'
{$condition[$meta['album']]}
GROUP BY p.aid
HAVING COUNT(p.pid) > 0
ORDER BY RAND()
{$meta['limit']}";
$result = cpg_db_query($query);
$rowset = cpg_db_fetch_rowset($result);
mysql_free_result($result);
build_caption($rowset, array('ctime'));
break;