Help needed with toplist

[Raphael]

I have a toplist script which resets daily at 00:00. Can someone help me to restet this toplist after two days?

Here are config.php and update.php


config.php

<?php
$mysqlhost = "";
$database = "";
$mysqluser = "";
$password = "";
$sections = "";
$sites = "";
$ban = "";
$tmp = "";
$news = "";
$rekl = "";
$in_dir = "in";
$out_dir = "out";
$admin_dir = "admin";
$update_file = "updates.dat";
$connection = mysql_connect($mysqlhost, $mysqluser, $password);
if(!$connection)
{
header("Content-type: text/vnd.wap.wml; charset=utf-8");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-cache, must-relative");
$error = mysql_error();
echo <<< END
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE wml PUBLIC '-//WAPFORUM//DTD WML 1.3//EN' 'http://www.wapforum.org/DTD/wml13.dtd'><wml>
<card id='error' title='Error'>
<p align='left'>
No connection to MySQL<br/>
<a href='/'>Home</a><br/>
</p>
</card>
</wml>
END;
exit();
}
if(!mysql_select_db($database, $connection))
{
header("Content-type: text/vnd.wap.wml; charset=utf-8");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-cache, must-relative");
$error = mysql_error();
echo <<< END
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE wml PUBLIC '-//WAPFORUM//DTD WML 1.3//EN' 'http://www.wapforum.org/DTD/wml13.dtd'><wml>
<card id='error' title='Error'>
<p align='left'>
The database could not be accessed<br/>
<a href='/'>Home</a><br/>
</p>
</card>
</wml>
END;
exit();
}
$sp = dirname($_SERVER['PHP_SELF']);
if(strpos($sp, $admin_dir) == false && strpos($sp, $in_dir) == false && strpos($sp, $out_dir) == false)
{
$fd = fopen($update_file, "r");
flock($fd, LOCK_EX + LOCK_SH);
$buff = fgets($fd);
if($buff != date("d"))
{
define("OK", "OK");
$fdesc = fopen($update_file, "w");
fputs($fdesc, date("d"));
include("update.php");
fclose($fdesc);
}
flock($fd, LOCK_UN);
fclose($fd);
}
if(isset($_GET['version']))
{
$version = $_GET['version'];
}
else
{
$version = "html";  //Default HTML
}
switch($version)
{
case 'wml':
$version = 0;
break;
case 'html':
$version = 1;
break;
default:
$version = 0;
break;
}
if($version == 1)
{
$font = "Comic Sans MS";
$color = "#3366FF";
$background = "#DFE6EF";
$links = "#3A4F6C";
$form_color = "#3A4F6C";
$favicon = "/favicon.ico";
}
?>

update.php

<?php
if(!defined("OK")) die();

$sql = mysql_query("SELECT * FROM `".$sites."` WHERE `all_in` != 0;");

$date = date("d-m-Y_H-i-s");

$fd = fopen("./logs/".$date.".txt", "w");
$data = "LOGS DATE: ".date("d-m-Y H:i:s")."\n";

while($sa = mysql_fetch_array($sql))
{
$data .= $sa['site']."|".$sa['in']."/".$sa['out']."|".$sa['all_in']."/".$sa['all_out']."\n";
}

fwrite($fd, $data);
fclose($fd);

$fp = fopen("month.dat", "r");
flock($fp, LOCK_EX + LOCK_SH);

$buffer = fgets($fp);

    if($buffer != date("m"))
    {
    $fdp = fopen("month.dat", "w");
    fputs($fdp, date("m"));
    fclose($fdp);
    mysql_unbuffered_query("UPDATE `".$sites."` SET `all_in` = 0, `all_out` = 0;");
    }

flock($fp, LOCK_UN);
fclose($fp);

mysql_unbuffered_query("TRUNCATE TABLE `".$tmp."`;");
mysql_unbuffered_query("UPDATE `".$sites."` SET `in` = 0, `out` = 0;");
mysql_unbuffered_query("DELETE FROM `".$sites."` WHERE `all_in` = 0 AND `days` > 2;");
?>

[s3nzo]

update.php

<?php
if(!defined("OK")) die();

$sql = mysql_query("SELECT * FROM `".$sites."` WHERE `all_in` != 0;");

$date = date("d-m-Y_H-i-s");

$fd = fopen("./logs/".$date.".txt", "w");
$data = "LOGS DATE: ".date("d-m-Y H:i:s")."\n";

while($sa = mysql_fetch_array($sql))
{
$data .= $sa['site']."|".$sa['in']."/".$sa['out']."|".$sa['all_in']."/".$sa['all_out']."\n";
}

fwrite($fd, $data);
fclose($fd);

$fp = fopen("month.dat", "r");
flock($fp, LOCK_EX + LOCK_SH);

$buffer = fgets($fp);

    if($buffer != date("m"))
    {
    $fdp = fopen("month.dat", "w");
    fputs($fdp, date("m"));
    fclose($fdp);
    mysql_unbuffered_query("UPDATE `".$sites."` SET `all_in` = 0, `all_out` = 0;");
    }

flock($fp, LOCK_UN);
fclose($fp);

mysql_unbuffered_query("TRUNCATE TABLE `".$tmp."`;");
if(is_int(date("d") / 2))
    mysql_unbuffered_query("UPDATE `".$sites."` SET `in` = 0, `out` = 0;");
mysql_unbuffered_query("DELETE FROM `".$sites."` WHERE `all_in` = 0 AND `days` > 2;");
?>

[Raphael]

@s3nzo not working