script cron

[Bombowiec89]

Hi, can someone help me, now he tries a few days, but does not go.

It needs a script to perform my command for vbulletin cron.

I tried different ways db_query_write etc, but still was bad.


It needs a cron to me in such a command, practised

UPDATE `MYDATABASENAME`.`PREFIX_setting` SET `value` = '50' WHERE CONVERT( `vBsetting`.`varname` USING utf8 ) = 'zbomb' LIMIT 1 ;

I can give someone ready code.

Sory for my bad english.

[Dismounted]

Please post your whole script. Also, is this cron a vBulletin Scheduled Task, or a Unix cronjob?

[Bombowiec89]

vBulletin Scheduled task.

[Marco van Herwaarden]

And the contents of the script?

[Lynne]

If it is a scheduled task, you need more in your script than just that query. Something more like:

PHP Code:

<?php

/*======================================================================*\
|| #################################################################### ||
|| # Cron Job to do whatever           ||
|| # Last Modified: Whenever                                  ||
|| #################################################################### ||
\*======================================================================*/ 

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

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

All your actions here... like
$query="UPDATE whatever";
$vbulletin->db->query_write($query); 

log_cron_action('Update whatever', $nextitem);

?>