[sv1cec]

After a lot of trial-and-error, I've managed to improve on Jag's script above.

The script below, will test every warning to see if it is more than a month old. If it is, it will erase the warning and reduce the points of the member by the number of points that warning had.

One question Jag, that number you used, $date = $today-240800, the 240800, where does it come from? I believe that it should be $date = $today-2592000 (for 30 days x 24 hours x 60 minutes x 60 seconds).

Here is my script:

PHP Code:

<?php
/*======================================================================*\
|| #################################################################### ||
|| # vB3 Warn System V1 By Zero Tolerance [http://gzevolution.net]    ||
|| #################################################################### ||
\*======================================================================*/

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

// #################### DEFINE IMPORTANT CONSTANTS #######################
define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'kill_warns');

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

// Global Requirements & Functions
    require_once('./global.php');
    require_once('./includes/functions_user.php');


$DB=$DB_site; // What? Its easier to write ^_^;
$warn_page=""; // Template Var

$today = time();
$date = $today-2592000;

$warn=$DB->query("select w.*,wt.*,u.* from ".TABLE_PREFIX."warnings w left join ".TABLE_PREFIX."warning_types wt on(wt.tid=w.warned_warning_id) left join ".TABLE_PREFIX."user u on(u.userid=w.warned_user)");

while($warns=$DB->fetch_array($warn))
{
// update user's warn level
if (vbdate($vboptions['dateformat'], $warns[warned_time]) == vbdate($vboptions['dateformat'],$date)) 
{
$level=($warns['warning_level']-$warns['warn_points']);
$level=(int)$level;
if($level<1){$level=0;}

$DB->query("update ".TABLE_PREFIX."user set warning_level='{$level}' where userid='{$warns['userid']}'");
$DB_site->query("DELETE FROM " . TABLE_PREFIX . "warnings WHERE wid='{$warns['wid']}'");
}
}

log_cron_action('Old Warnings deleting script was run', $nextitem);

?>

Rgds