coppermine-gallery.com/forum

Support => Older/other versions => cpg1.1d PHPnuke Support (deprecated) => Topic started by: Aadilya on October 01, 2003, 07:14:54 PM

Title: Excluding Album(s) from Random Image block
Post by: Aadilya on October 01, 2003, 07:14:54 PM
Is there a way to exclude the pictures in a specific album from appearing in my "Random Images" block?

Aad
Title: Excluding Album(s) from Random Image block
Post by: gtroll on October 02, 2003, 02:06:00 AM
In block-Random_pictures.php
aid!=4 AND aid!=6 AND aid!=7 were the directories i wanted to exclude change those aid to your own..
~= line 48 was$result = sql_query("SELECT count(*) from cpg_pictures", $dbi);

change to
$result = sql_query("SELECT count(*) from cpg_pictures WHERE aid!=4 AND aid!=6 AND aid!=7", $dbi);

~=line 59 was$result2 = sql_query("SELECT pid, aid, filepath, filename  from cpg_pictures WHERE approved='YES' LIMIT $random_number,1", $dbi);
change to:$result2 = sql_query("SELECT pid, aid, filepath, filename  from cpg_pictures WHERE aid!=4 AND aid!=6 AND aid!=7  AND approved='YES' LIMIT $random_number,1", $dbi);