View file BOTTOM_SITE/stat.php

<?
include_once 'sys/inc/start.php';
include_once 'sys/inc/compress.php';
include_once 'sys/inc/sess.php';
include_once 'sys/inc/home.php';
include_once 'sys/inc/settings.php';
include_once 'sys/inc/db_connect.php';
include_once 'sys/inc/ipua.php';
include_once 'sys/inc/fnc.php';
include_once 'sys/inc/user.php';

$set['title']='Статистика сайта';
include_once 'sys/inc/thead.php';
title();
err();
aut();
echo"<div class='menu'>\n";
echo"<div class='foot'>\n";
echo"Сегодня\n";
echo "</div>\n";
$day_st=mktime(0, 0, 0, date('n', time()), date('j',time()));
$day_fn=mktime(0, 0, 0, date('n', time()), date('j', time())+1);

$hit=mysql_result(mysql_query("SELECT COUNT(*) FROM `visit_today`"),0);
$host=mysql_result(mysql_query("SELECT COUNT(DISTINCT `ip`) FROM `visit_today`"),0);
$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);

$news=mysql_result(mysql_query("SELECT COUNT(*) FROM `news` WHERE `time` >= '$day_st' AND `time` < '$day_fn'"),0);
$chat=mysql_result(mysql_query("SELECT COUNT(*) FROM `chat_post` WHERE `time` >= '$day_st' AND `time` < '$day_fn'"),0);
$guest=mysql_result(mysql_query("SELECT COUNT(*) FROM `guest` WHERE `time` >= '$day_st' AND `time` < '$day_fn'"),0);
$gallery=mysql_result(mysql_query("SELECT COUNT(*) FROM `gallery` WHERE `time_create` >= '$day_st' AND `time_create` < '$day_fn'"),0);
$loads=mysql_result(mysql_query("SELECT COUNT(*) FROM `loads_list` WHERE `time` >= '$day_st' AND `time` < '$day_fn'"),0);
	echo"Хосты: $host<br />\n";
	echo"Хиты: $hit<br />\n";
	echo"Регистраций: $user_reg <br />\n";
	echo"Тем в форуме: $forum_them<br />\n";
	echo"Сообщений в форум: $forum_post <br />\n";
	echo"Новостей: $news<br />\n";
	echo"Сообщений в чате: $chat<br />\n";
	echo"Надписей на стене: $guest<br />\n";
	echo"Фотоальбомы: $gallery<br />\n";
	echo"Загрузки: $loads<br />\n";
        echo "</div>\n";
echo "</div>\n";
echo"<div class='menu'>\n";
echo"<div class='foot'>\n";
echo"Всего\n";
echo "</div>\n";
$hit=mysql_result(mysql_query("SELECT SUM(`hit`) FROM `visit_everyday`"),0) + mysql_result(mysql_query("SELECT COUNT(*) FROM `visit_today`"),0);
$host=mysql_result(mysql_query("SELECT SUM(`host`) FROM `visit_everyday`"),0) + mysql_result(mysql_query("SELECT COUNT(DISTINCT `ip`) FROM `visit_today`"),0);
$user_reg=mysql_result(mysql_query("SELECT COUNT(*) FROM `user`"),0);
$forum_them=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_t`"),0);
$forum_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_p`"),0);
$news=mysql_result(mysql_query("SELECT COUNT(*) FROM `news`"),0);
$chat=mysql_result(mysql_query("SELECT COUNT(*) FROM `chat_post`"),0);
$guest=mysql_result(mysql_query("SELECT COUNT(*) FROM `guest`"),0);
$gallery=mysql_result(mysql_query("SELECT COUNT(*) FROM `gallery`"),0);
$loads=mysql_result(mysql_query("SELECT COUNT(*) FROM `loads_list`"),0);
	echo"Хосты: $host<br />";
	echo"Хиты: $hit<br />";
	echo"Регистраций: $user_reg<br />";
	echo"Тем в форуме: $forum_them<br />";
	echo"Сообщений в форум: $forum_post<br />";
	echo"Новостей: $news<br />";
	echo"Сообщений в чате: $chat<br />";
	echo"Надписей на стене: $guest<br />";
	echo"Фотоальбомы: $gallery<br />";
	echo"Загрузки: $loads<br />";
        echo "</div>\n";
echo "</div>\n";

echo"<div class='menu'>\n";
echo"<div class='foot'>\n";
echo"Инфо о загрузках\n";
echo "</div>\n";
$all_size = mysql_fetch_row(mysql_query('SELECT SUM(`size`) FROM `loads_list` WHERE `size` > 0'));

if($all_size[0] < 1048576){
$all_size[0] = round($all_size[0]/1024, 2).'Kb';
}
else{
$all_size[0] = round($all_size[0]/1024/1024, 2).'Mb';
}


$all_files = mysql_fetch_row(mysql_query('SELECT COUNT(*) FROM `loads_list` WHERE `size` > 0'));
$all_loads = mysql_fetch_row(mysql_query('SELECT SUM(`loads`) FROM `loads_list` WHERE `size` > 0'));


echo'
Всего файлов: '.(int)$all_files[0].'<br>
Всего скачиваний: '.(int)$all_loads[0].'<br>
Общий объем: '.$all_size[0].'<br>
';
echo "</div>\n";
echo "</div>\n";
include_once 'sys/inc/tfoot.php';


?>