Administrative and Maintenance Tools - Schedule vB's tasks with a host crontab

Schedule vB's tasks with a host crontab

!!! Warning You run this script at your OWN risk, I will not be responsible for any damage caused !!!

Description:

vBulletins schedule tasks only run when a user is browsing your forum. With the release of 3.6 and RSS imports this has caused problems for slow moving forums importing fast moving RSS feeds (If a news item passes fully through the RSS feed before a visitor browses your forums causing the import to be processed then content could be lost)

Solution:

If your host supports "Cron Jobs" you can call the attached PHP file periodically to force vBulletin to catch up with its internal scheduled tasks.

Installation

1. Download the attached file and edit the variables at the top to match your forum installation
2. Upload the file to somewhere on your host
3. Schedule this file to run at an appropriate interval

eg. (to run every hour at 15m past the hour, 12:15 - 13:15 - 14:15 - etc.)

15 * * * * /usr/bin/php -f /home/myuser/exec-cron.php >/dev/null 2>&1

Detailed Information

Unfortunatly running the cron.php from the vBulletin files will only process the next pending single task, This short script simply queries the scheduled task database to count how many tasks are pending, it then calls the cron.php routine that number of times - thus your scheduled tasks are kept up to date.

This is my first ever PHP script so please don't expect a masterpiece from a rocket scientist, if anyone has any comments or suggestions please drop me a PM

[Nxs]

I wasn't at all sure which forum to drop this script into, but as it relates mostly to the new RSS feature in 3.6 I guessed here was as good a place, sorry if it isn't.

[Evercraft]

Very nice!

[Milad]

very good work

Now vBulletin has real cronjop

[Nxs]

Originally Posted by Milad

very good work

Now vBulletin has real cronjop

Well, only if you schedule this script to run every minute - and i'm sure your host will have something to say about that

Mine just runs every hour and typicaly has about 5 or 6 jobs to run at that point if no one has visited the forums in that time, works really well for importing RSS feeds tho.

[jmw]

Does this work with 3.6.5? It appears the "15 minute after the hour" example has the file name backwards.

[dooch]

yes it does work with 3.6.5 I had to change it slightly for non-localhost connections Here is the part you need to change.

PHP Code:

$ec_localhost = "localhost";     //Dooch's Additional bit.  Add your remote mysql db info her eif not localhost!
$ec_dbname = "db";            // your vBulletin database
$ec_dbuser = "user";           // user with READ access
$ec_dbpass = "passw";           // password for the above user
$ec_dbprefix = "";                // database prefix, if required

// This should be the location of your forum folder (where cron.php resides)
$ec_pathtoforum = "path";

// Specify the FULL location of your PHP installation (how to call php)
$ec_pathtophp = "/usr/bin/php";

// Maximum number of tasks to run on one pass
$ec_max = 10;

/**************************************************
 ****  DO NOT CHANGE THE CODE BELOW THIS LINE  ****
 **************************************************/


// Connect to MySQL
$ec_link = mysql_connect($ec_localhost,$ec_dbuser,$ec_dbpass);  //note the change here for non-localhost dudes. ;) 


Nice work dude!

INSTALLED

Thanks

Dooch

[NiTRoN]

Sweet this is excellent for small boards.. I've been waiting sooooooo loooooong for this..

[trilljester]

This is working nicely. I can't believe that VB doesn't offer something like this to run the scheduled tasks, because without traffic, those tasks will not run. That's just stupid.

Thanks!

[gamma912]

yea thats true - Thanks Im using it now it works great