File size: 6.75Kb
<?php
//=============================
#Version WapuS_ToP_final
#Script By: Black1992
#Email: skyangel15@inbox.lv
#Icq: 414454754
#Url: http://WaPuS.pp.Ru
//=============================
include("config.php");
include("inc/config.inc.php");
include("inc/functions.inc.php");
ini_set ('session.use_cookies', 0);
ini_set ('session.use_trans_sid', 1);
session_name('sid');
connect_to_db();
$title=DEFAUL_PAGE_TITLE;
include_once 'head.php';
$week_day = date("w");
$today = date("Ymd");
$downtoday = mktime(0, 0, 0, date("Y") , date("m"), date("d")-1);
// за сегодня
$result = mysql_query("SELECT `host` FROM `weeks` WHERE `date`=$today LIMIT 1;");
$row = mysql_fetch_array($result);
$host_today = $row['host'];
// ------------------------ онлайн------------------------
// подсчитываем онлайн посетителей
$result = mysql_query("SELECT count(ip) FROM online_ip");
$row=mysql_fetch_row($result);
$online=(int)$row[0];
// за сегодня
$result=mysql_query("SELECT `count`,`host` FROM `weeks` WHERE `date`=$today");
$row = mysql_fetch_array($result);
$count_today = $row['count'];
$host_today = $row['host'];
// за сегодня общая
$result=mysql_query("SELECT `count`,`host` FROM `weeks` WHERE `date`=$today");
$row = mysql_fetch_array($result);
$count_all = $row['count'];
$host_all = $row['host'];
//----------------------- Место в топе---------------------------
//$result=mysql_query("SELECT * FROM `weeks` WHERE `host` >= $host_today AND `date`=$today ORDER BY `host` DESC;");
//$top_place = mysql_num_rows($result);
// ---------------------------- посещения за месяц --------------------
$months = array("Январь","Февраль","Март","Апрель","Май","Р?СЋРЅСЊ","Р?юль","РђРІРіСѓСЃС‚","Сентябрь","Октябрь","РќРѕСЏР±СЂСЊ","Декабрь");
$today = date("Ym");
$index_month = date("m")-1;
// данные за текущий месяц
$result = mysql_query("SELECT count,host FROM months WHERE date=$today");
$row=mysql_fetch_row($result);
// поверка наличия записи в базе
if (empty($row[0]))
{
$this_month_count = 0;
$this_month_host = 0;
}else{
$this_month_count = (int)$row[0];
$this_month_host = (int)$row[1];
}
//-------------------------- недельная статистика----------------
$week_day = date("w");
$today = date("Ymd");
// посещений за неделю
$result = mysql_query("SELECT sum(count),sum(host) FROM weeks");
$row=mysql_fetch_row($result);
$total_week_count = (int)$row[0];
$total_week_host = (int)$row[1];
// ------------------------ онлайн------------------------
// подсчитываем онлайн посетителей
$result = mysql_query("SELECT count(ip) FROM online_ip");
$row=mysql_fetch_row($result);
$online=(int)$row[0];
// -----------------------Всего---------------------------
$result = mysql_query("SELECT sum(count),sum(host) FROM months");
$row=mysql_fetch_row($result);
$all_hits = (int)$row[0];
$all_hosts = (int)$row[1];
// -----------------------Пришло \ Ушло---------------------------
$week_day = date("w");
$today = date("Ymd");
$counts_in_out = mysql_query("SELECT `in`,`out` FROM `weeks` WHERE `date`=$today AND `day_week`=$week_day");
$count_row=mysql_fetch_array($counts_in_out);
$in_count = (int)$count_row['in'];
$out_count = (int)$count_row['out'];
/*
-----------------------------------------------------------------
$top_place - место в топе
$count_today - хитов сегодня
$host_today - хостов сегодня
$count_24 - хитов за 24 часа
$host_24 - хостов за 24 часа
$hour_count - хитов за этот час
$hour_host - хостов за этот час
$this_month_count - хитов за этот месяц
$this_month_host - хостов за этот месяц
$total_week_count - хитов за эту неделю
$total_week_host - хостов за эту неделю
$online - онлайн посетителей
$all_hits - всего хитов
$all_hosts - всего хостов
$in_count - пришло в топ
$out_count - ушло из топа
-----------------------------------------------------------------
*/
//$page = ceil($top_place/$count_top);
echo "<div class=\"rek3\"><font color='blue'>all.sites</font> - Statistics</div>";
$allreg=mysql_result(mysql_query("select count(*) from `users`"),0);
$allban=mysql_result(mysql_query("select count(*) from `ban_user`"),0);
//ТОП всех участников
$today = date("Ymd");
//получаем кол во участников
$result = mysql_query("SELECT count(`uid`) FROM `weeks` WHERE `host` > 0 and `date`=$today");
$cntData = mysql_fetch_row($result);
$count_users = $cntData[0];
//Общая посещаемость
$month_count = mysql_query("SELECT sum(count),sum(host) FROM months WHERE uid");
$month_count_mass=mysql_fetch_row($month_count);
$month_hits_result = (int)$month_count_mass[0];
$month_hosts_result = (int)$month_count_mass[1];
//Суточная посещаемость
$count_24 = mysql_query("SELECT sum(count),sum(host) FROM count_24 WHERE uid");
$count_24_mass=mysql_fetch_row($count_24);
$count_24_hits_result = (int)$count_24_mass[0];
$count_24_hosts_result = (int)$count_24_mass[1];
echo "<div class=\"main\"><b>Statistics:</b><br/></div>
<div class=\"rek3\"Sites in database: $allreg<br/>
Banned: $allban<br/>
Active sites: $count_users </div>";
echo "<div class=\"main\"><b>24 hoursЏ:</b><br/></div>
<div class=\"rek3\">24 hours hosts $count_24_hosts_result <br/>
24 hours hits $count_24_hits_result </div>";
echo "<div class=\"main\"><b>Weekly statsЏ:</b><br/></div>
<div class=\"rek3\">week hosts $total_week_host <br/>
week hits $total_week_count </div>";
echo "<div class=\"main\"><b>Month stats:</b><br/></div>
<div class=\"rek3\">month hosts $all_hosts<br/>
month hits $all_hits </div>";
echo "<div class=\"main\"><b>Total stats:</b><br/></div>
<div class=\"rek3\">Total $month_hosts_result<br/>
total $month_hits_result</div>";
echo "
<div class=\"news\">
<a href=\"" .$rating_url . "index.php\">$rating_name</a>
<img src=\"/img/gt.gif\" alt=\">\" /> Home
</div>
";
include "foot_code.php";
?>