Miscellaneous Hacks - vbGallery Addon: Photo of the Day

This script will randomly select a photo from vbGallery and create a new thread in a specific forum with the photo and it's description. The script is run as a scheduled task in Vbulletin's Scheduled Tasks Manager.

Before uploading the script, you need to set which categories you want the photos to be selected from, the minimum width of the photo and the minimum amount of views that the photo has received.

Installation is easy, simply upload this script to the forums/includes/cron/ directory and create a new scheduled task. (See screen shot for suggested scheduled task parameters)

Tested on Vbulletin 3.6.4 and vbGallery 2.2
Confirmed to work on Vbulletin 3.6.8 and vbGallery 2.3
Confirmed to work on Vbulletin 3.7.0 and vbGallery 2.4.3
Confirmed to work on Vbulletin 3.8.2 and vbGallery 2.4.3
Confirmed to work on Vbulletin 3.8.3 and vbGallery 2.5

Please click install if you use this script.

This hack has been ported to PhotoPlog by TCooper.

[Zorck]

Originally Posted by trancetopia

Hi, are you planning to release a photopost pro version of this? Pretty please!

That well be nice!

[goblues]

Originally Posted by GrendelKhan{TSU

now all we need is a vbCMPS add-on for this and its perfect!!

If one isn't made by this weekend, I will take a look at it.

[0ptima]

Originally Posted by trancetopia

Hi, are you planning to release a photopost pro version of this? Pretty please!

Originally Posted by goblues

If one isn't made by this weekend, I will take a look at it.

I dont have access to photo post pro, so go ahead and port the hack.

[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.

[goblues]

Originally Posted by 0ptima

I dont have access to photo post pro, so go ahead and port the hack.

Me neither. I was referring to the CMPS module. I wish I had photopost pro.

[0ptima]

Originally Posted by goblues

Me neither. I was referring to the CMPS module. I wish I had photopost pro.

oops! I dont use CMPS, please go ahead and create a module.

[993ti]

It creates a topic every minute after midnight, lol.
Not sure what causes it but i've set it to execute at 00.01 now.
Will check what it does with that setting

[goblues]

Mine did the same thing the first night, however the second night went fine.

[0ptima]

Originally Posted by 993ti

It creates a topic every minute after midnight, lol.
Not sure what causes it but i've set it to execute at 00.01 now.
Will check what it does with that setting

Sorry about posting a screen shot of the cron with an incorrect setting. I updated the screen shot in this thread and in the zip file.

[TRR]

0ptoma, would you ever consider doing this same exact thing from vbclassifieds, and zoints profiles? I really like this feature.