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 :
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

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 !