Look up I post snatched table no I think maybe problem is in fuctions.php and cleanup
my original fuctions.php
PHP Code:
function autoclean() {
global $autoclean_interval;
$now = time();
$docleanup = 0;
$res = mysql_query("SELECT value_u FROM avps WHERE arg = 'lastcleantime'");
$row = mysql_fetch_array($res);
if (!$row) {
mysql_query("INSERT INTO avps (arg, value_u) VALUES ('lastcleantime',$now)");
return;
}
$ts = $row[0];
if ($ts + $autoclean_interval > $now)
return;
mysql_query("UPDATE avps SET value_u=$now WHERE arg='lastcleantime' AND value_u = $ts");
if (!mysql_affected_rows())
return;
docleanup();
}
replace with
PHP Code:
function autoclean()
{
global $autoclean_interval, $autoslowclean_interval, $optimizedb_interval, $backupdb_interval, $autohitrun_interval;
$now = gmtime();
/* Better cleanup function with db-optimization dbbackup - //==added hitandrun==// by x0r @ tbdev.net */
$w00p = sql_query("SELECT arg, value_u FROM avps") or sqlerr(__FILE__, __LINE__);
while ($row = mysql_fetch_assoc($w00p)) {
if ($row['arg'] == "lastcleantime" && ($row['value_u'] + $autoclean_interval) < $now) {
sql_query("UPDATE avps SET value_u = '$now' WHERE arg = 'lastcleantime'") or sqlerr(__FILE__, __LINE__);
docleanup();
} else if ($row['arg'] == "lastslowcleantime" && ($row['value_u'] + $autoslowclean_interval) < $now) {
sql_query("UPDATE avps SET value_u = '$now' WHERE arg = 'lastslowcleantime'") or sqlerr(__FILE__, __LINE__);
doslowcleanup();
} else if ($row['arg'] == "lastoptimizedbtime" && ($row['value_u'] + $optimizedb_interval) < $now) {
sql_query("UPDATE avps SET value_u = '$now' WHERE arg = 'lastoptimizedbtime'") or sqlerr(__FILE__, __LINE__);
dooptimizedb();
} else if ($row['arg'] == "lastbackupdbtime" && ($row['value_u'] + $backupdb_interval) < $now) {
sql_query("UPDATE avps SET value_u = '$now' WHERE arg = 'lastbackupdbtime'") or sqlerr(__FILE__, __LINE__);
dobackupdb();
} else if ($row['arg'] == "lastautohitruntime" && ($row['value_u'] + $autohitrun_interval) < $now) {
sql_query("UPDATE avps SET value_u = '$now' WHERE arg = 'lastautohitruntime'") or sqlerr(__FILE__, __LINE__);
doautohitrun();
}
}
mysql_free_result($w00p);
return;
}