Файл: panel/statistic.php
Строк: 136
<?
include_once '../sys/includes/start.php';
include_once '../sys/includes/compress.php';
include_once '../sys/includes/sess.php';
include_once '../sys/includes/home.php';
include_once '../sys/includes/settings.php';
include_once '../sys/includes/db_connect.php';
include_once '../sys/includes/ipua.php';
include_once '../sys/includes/fnc.php';
include_once '../sys/includes/adm_check.php';
include_once '../sys/includes/user.php';
user_access('adm_statistic',null,'index.php?'.SID);
adm_check();
$set['title']='Статистика сайта';
include_once '../sys/includes/header.php';
title();
auter();
for ($i=0;$i<24;$i++)
{
$hit=mysql_result(mysql_query("SELECT COUNT(*) FROM `visit_today` WHERE `time` >= '".mktime($i,0,0)."' AND `time` < '".mktime($i+1,0,0)."'"),0);
$host=mysql_result(mysql_query("SELECT COUNT(DISTINCT `ip`) FROM `visit_today` WHERE `time` >= '".mktime($i,0,0)."' AND `time` < '".mktime($i+1,0,0)."'"),0);
$user_reg=mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `date_reg` >= '".mktime($i,0,0)."' AND `date_reg` < '".mktime($i+1,0,0)."'"),0);
$forum_them=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_t` WHERE `time_create` >= '".mktime($i,0,0)."' AND `time_create` < '".mktime($i+1,0,0)."'"),0);
$forum_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_p` WHERE `time` >= '".mktime($i,0,0)."' AND `time` < '".mktime($i+1,0,0)."'"),0);
$stat[]=array('hit'=>$hit,'host'=>$host,'time'=>mktime($i,0,0),'for_th'=>$forum_them,'for_p'=>$forum_post,'user'=>$user_reg);
}
echo "<table style='width:100%' cellspacing='1' cellpadding='1'><tr>";
echo "<td class='pan_s'><center>";
echo "Текущие сутки:";
echo "</center></td>";
echo "</tr></table>";
echo "<table border='1'>";
echo "<tr>";
echo "<td class='pan_s'><center><b>Час</b></center></td>";
echo "<td class='pan_s'><center><b>Хиты</b></center></td>";
echo "<td class='pan_s'><center><b>Хосты</b></center></td>";
echo "<td class='pan_s'><center><b>Рег.</b></center></td>";
echo "<td class='pan_s'><center><b>Форум-темы</b></center></td>";
echo "<td class='pan_s'><center><b>Форум-посты</b></center></td>";
echo "</tr>";
for ($i=0;$i<sizeof($stat);$i++)
{
if ($time<$stat[$i]['time'])continue;
echo "<tr>";
echo "<td class='pan_s'><center>".date('H',$stat[$i]['time']+$user['set_timesdvig']*60*60)."</td>";
echo "<td class='pan_s'><center>".$stat[$i]['hit']."</center></td>";
echo "<td class='pan_s'><center>".$stat[$i]['host']."</center></td>";
echo "<td class='pan_s'><center>".$stat[$i]['user']."</center></td>";
echo "<td class='pan_s'><center>".$stat[$i]['for_th']."</center></td>";
echo "<td class='pan_s'><center>".$stat[$i]['for_p']."</center></td>";
echo "</tr>";
}
echo "</table><br />";
unset($stat);
echo "<table style='width:100%' cellspacing='1' cellpadding='1'><tr>";
echo "<td class='pan_s'><center>";
echo "Последний месяц:";
echo "</center></td>";
echo "</tr></table>";
$k_day=mysql_result(mysql_query("SELECT COUNT(*) FROM `visit_everyday`"),0);
$q=mysql_query("SELECT * FROM `visit_everyday` ORDER BY `time` ASC LIMIT ".max($k_day-30,0).", 30");
while ($result=mysql_fetch_assoc($q))
{
$day_st=mktime(0, 0, 0, date('n', $result['time']), date('j', $result['time']));
$day_fn=mktime(0, 0, 0, date('n', $result['time']), date('j', $result['time'])+1);
$user_reg=mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `date_reg` >= '$day_st' AND `date_reg` < '$day_fn'"),0);
$forum_them=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_t` WHERE `time_create` >= '$day_st' AND `time_create` < '$day_fn'"),0);
$forum_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_p` WHERE `time` >= '$day_st' AND `time` < '$day_fn'"),0);
$stat[]=array('host'=>($result['host_ip_ua']<$result['host']*2?$result['host_ip_ua']:$result['host']),'hit'=>$result['hit'],'time'=>$result['time'],'for_th'=>$forum_them,'for_p'=>$forum_post,'user'=>$user_reg);
}
echo "<table border='1'><tr>";
echo "<td class='pan_s'><center><b>Дата</b></center></td>";
echo "<td class='pan_s'><center><b>Хиты</b></center></td>";
echo "<td class='pan_s'><center><b>Хосты</b></center></td>";
echo "<td class='pan_s'><center><b>Рег.</b></center></td>";
echo "<td class='pan_s'><center><b>Форум-темы</b></center></td>";
echo "<td class='pan_s'><center><b>Форум-посты</b></center></td>";
echo "</tr>";
for ($i=0;$i<sizeof($stat);$i++)
{
echo "<tr>";
echo "<td class='pan_s'><center>".date('d.m.Y',$stat[$i]['time'])."</center></td>";
echo "<td class='pan_s'><center>".$stat[$i]['hit']."</center></td>";
echo "<td class='pan_s'><center>".$stat[$i]['host']."</center></td>";
echo "<td class='pan_s'><center>".$stat[$i]['user']."</center></td>";
echo "<td class='pan_s'><center>".$stat[$i]['for_th']."</center></td>";
echo "<td class='pan_s'><center>".$stat[$i]['for_p']."</center></td>";
echo "</tr>";
}
echo "</table>";
if (user_access('adm_panel_show'))
{
echo "<a href='/panel/'><div class='foot'>";
echo "<img src='/s-klub/img/left.png'> Админка";
echo "</div></a>";
}
include_once '../sys/includes/footer.php';
?>