[0ptima]

Originally Posted by GrendelKhan{TSU

that said, I got a ton of categories... and its a pain to list em all. Can you add an "all categories" default or something? like 0 = all categories. or however that works. and make it so you EXCLUDE certain ones?

I'll try to add that option this weekend. In the mean time, you can replace this SQL

PHP Code:

// select the random image from the photo gallery
$result= $vbulletin->db->query_read("SELECT imageid, userid, username, filename, title, description
       FROM " . TABLE_PREFIX . "ppgal_images 
       WHERE catid IN ($includecatids)
       AND width  > $width
       AND views > $views      
       ORDER BY RAND(NOW()) 
       LIMIT 1"); 


with this

PHP Code:

// select the random image from the photo gallery
$result= $vbulletin->db->query_read("SELECT imageid, userid, username, filename, title, description
       FROM " . TABLE_PREFIX . "ppgal_images 
       WHERE  width  > $width
       AND views > $views      
       ORDER BY RAND(NOW()) 
       LIMIT 1"); 


The only problem is that it will select from private categories as well. Once I update the hack, ill have it exclude the private categories.