$end; $i--)
{
if($begin == 0) $tmp2 = "";
else
{
$tmp2 = " AND putdate >= DATE_FORMAT( NOW( ) , '%Y-%m-%d 23:59:59' ) - INTERVAL ".$i." DAY ";
$tmp1 = " putdate < DATE_FORMAT( NOW( ) , '%Y-%m-%d 23:59:59' ) - INTERVAL ".($i-1)." DAY ";
}
$sql1="INSERT INTO thits SELECT ROUND((max(unix_timestamp(putdate))-min(unix_timestamp(putdate)))/60)*60+60
FROM `ip`
WHERE systems != 'none' AND
systems != 'robot_yandex' AND
systems != 'robot_google' AND
systems != 'robot_rambler' AND
systems != 'robot_aport' AND
systems != 'robot_msn' AND
$tmp1
$tmp2
GROUP BY ip";
mysql_query($sql1);
}
$sql3="SELECT count(hits) AS hits2 FROM thits GROUP BY hits ORDER BY hits2 DESC";
$res2 = mysql_query($sql3);
if (mysql_num_rows($res2)>0)
{
$total=mysql_result($res2,0);
$sql2="SELECT hits, count(hits) AS hits2 FROM thits GROUP BY hits ORDER BY hits";
$res = mysql_query($sql2);
while($deep = mysql_fetch_array($res))
{
echo "
