CronJob / Execute PHP file question?

[PhilMcKrackon]

I have a very simple php file I have created that dumps some table data to a file on my server. Can some one point me to some instructions on what needs to be added to the PHP file and what I should do in the scheduled tasks section of VBulletin to run the file automatically? I just need a nudge in the right direction...

If I direct my browser to the PHP page the script runs correctly and the dump file is created, but I am unsure on what to do to get VB to execute it automatically for me.

Thanks,

<?php
$host = "localhost";
$mysql_user = "????";
$mysql_password = "?????";
$sdatabase = "????";
$slink = mysql_connect("$host", "$mysql_user", "$mysql_password") or die('Database Connection Failed. Wait a moment.');
mysql_select_db ("$sdatabase", $slink);
$file = fopen("linkimages.pvc", "w");
fwrite($file,"/cmp=90 \n");
fwrite($file,"/bts=1200 \n");
fwrite($file,"/cdo=IvFxjSUmbcorg \n");
fwrite($file,"/irp=15 \n");
fwrite($file,"/ift=JPEG \n");
$urls = mysql_query("SELECT linkid,linkurl FROM adv_links ORDER by linkid ASC");
while ($urlrow = mysql_fetch_array($urls)) {
fwrite($file,"| URL=");
fwrite($file, $urlrow[1]);
fwrite($file, " | "); 
fwrite($file,"ifn=");
fwrite($file, $urlrow[0]);
fwrite($file,"_t.jpg |\n");
}
fclose($file); 
?>

[Lynne]

This is the basic form I use for my cron jobs:

PHP Code:

<?php

// ########### SET PHP ENVIRONMENT ##################
error_reporting(E_ALL & ~E_NOTICE);

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

// ########################################################################
// ######################### START MAIN SCRIPT ############################
// ########################################################################

all your php goes here.  Use standard vbulletin calls for your queries.  ie:
$mysquery = $vbulletin->db->query_read("
    SELECT this, that
    FROM " . TABLE_PREFIX . "table
    WHERE whatever
");



?>

[PhilMcKrackon]

Thanks for the reply, I still had a fit trying to get this to run inside of VB but I was able to get it to run by setting up a cronjob inside the web cpanel. The syntax was php -q /home/name/forums/.../filename.php as the GET statement is disabled on my server.

I had to add the path to php.exe on my server wich happened to be #!/usr/lib/php

Now it executes perfectly.

Thanks for the help.