how to make vbulletin cronjob

[xserverx]

Hello
I have 2 queries I would like to execute it every 30min but I don't know how to add it to cronjob

can any one assist me ? please attach he php file that I need to upload to cron directory

queries are :

PHP Code:

update user   JOIN userfield ON user.userid = userfield.userid set user.usergroupid = 2  WHERE user.usergroupid = 4 and userfield.field14 = 'female' 
update user   JOIN userfield ON user.userid = userfield.userid set user.usergroupid = 16  WHERE user.usergroupid = 4 and userfield.field14 = 'male' 


thank you

[Lynne]

Basic format for a php file to run a scheduled task in vb:

PHP Code:

<?php

error_reporting(E_ALL & ~E_NOTICE);

if (!is_object($vbulletin->db))
{
    exit;
}

// all your stuff here - like queries  example:

$vbulletin->db->query("
    UPDATE " . TABLE_PREFIX . "whatever
    SET something = something"
);

log_cron_action('Your Text Here', $nextitem);

?>

[Lee Roberts]

Thanks Lynne !