Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Nick R · 06-18-2006, 06:07 PM

Ok, i will update this later but alot of people have been asking for this so i might as well make it.

Items needed:
vBulletin 3.5.x or vBulletin 3.6

Skills needed:
Know what query you want to run.

Ok here goes nothing:

1.) open up a text editor eg. ultra edit 32 or notepad
2.) Save the file with a name and .php at the end (NOT .txt)
3.) Add this to the start of the file:

PHP Code:

  <?php
/*======================================================================*\
|| #################################################################### ||
|| # Name of Cron by Author                                ||
|| #################################################################### ||
\*======================================================================*/

// ---------------------------------------------------
// Start Set PHP Environment
// ---------------------------------------------------

error_reporting(E_ALL & ~E_NOTICE);
if (!is_object($vbulletin->db))
{
    exit;
}

// ---------------------------------------------------
// Start Cronjob
// ---------------------------------------------------

4.) Then you can put what query you want to run. eg. to clear the strikes table you would put:

PHP Code:

  global $vbulletin;
$vbulletin->db->query("delete from " . TABLE_PREFIX . "strikes");

5.) Then Log your action:

PHP Code:

  log_cron_action('What you want to be in the log file eg. The strikes table has been cleared.', $nextitem);

6.) Then finish off the script:

PHP Code:

  // ---------------------------------------------------
// End Cronjob
// ---------------------------------------------------

?>

7.) Then save your file and upload.
8.) Go into admincp and add a scheduled task with your file as the path.

Voila your done. A full example for clearing the strikes table is:

PHP Code:

  <?php
/*======================================================================*\
|| #################################################################### ||
|| # Strikes prune cron Created By Nick                                                ||
|| #################################################################### ||
\*======================================================================*/

// ---------------------------------------------------
// Start Set PHP Environment
// ---------------------------------------------------

error_reporting(E_ALL & ~E_NOTICE);
if (!is_object($vbulletin->db))
{
    exit;
}

// ---------------------------------------------------
// Start Cronjob
// ---------------------------------------------------

global $vbulletin;
$vbulletin->db->query("delete from " . TABLE_PREFIX . "strikes");

log_cron_action('Strikes pruned', $nextitem);

// ---------------------------------------------------
// End Cronjob
// ---------------------------------------------------

?>

Norman · 06-18-2006, 07:53 PM

Man I love you! Really really thanks!!

Now I try it!

Nick R · 06-18-2006, 07:53 PM

oh and yeah and feel free to add. i did it in a rush.

*Reeve of Shinra* · 06-18-2006, 09:00 PM

This is great! Thank you

*bookmarks*

Nick R · 06-19-2006, 04:25 PM

no problem :D

06-19-2006, 04:45 PM

really nice tut m8
many will find this helpful i'm sure me included

The Ottoman · 07-25-2006, 02:25 AM

Spot on dude.... Thanks.

Nick R · 07-25-2006, 06:38 AM

no probs :p

marksyzm · 10-14-2006, 05:47 PM

Perfect, thanks

G_man · 10-14-2006, 07:48 PM

Never got around to thanking you, so will do it now.

This is one of most useful Tut's I've seen. Cheers.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[How To] Run vBulletin On your P.C.	Ken Iovino	vBulletin Modification Tutorials	83	11-02-2009 05:16 AM
[How To] Add Options per forum	Ken Iovino	vBulletin Modification Tutorials	10	03-03-2007 06:25 PM
[How To] Run a vb page outside of the forum directory	Junior	vBulletin Modification Tutorials	7	01-10-2007 10:05 PM
[How to] For new members	Rex	Growing Your vB Forum	4	05-26-2006 05:46 PM

Member Log In

Site Navigation

Latest Modifications

Latest Template Mods

Latest Styles

Latest Graphics

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)