<?php
include 'inc/config.inc.php';
include 'inc/wap_tags.inc.php';
include 'inc/functions.inc.php';
ob_start('make_page');
//---------------------------------------------------------------
ini_set ('session.use_cookies', 0);
ini_set ('session.use_trans_sid', 1);
session_name('sid');
session_start();
connect_to_db();
//---------------------------------------------------------------
if (define_wap ())
{
send_wap_header($_SESSION['wap_version']);
$PAGE_TITLE = "".DEFAUL_PAGE_TITLE."";
include "config.php";
// ------------------------------ вывод статистики пользователя ---------------------
//проверка ввода id
if (empty($_GET['uid'])) exit;
$uid=dig((int)$_GET['uid']);
// проверка существования учетной записи
$result = mysql_query("SELECT site_name,link,admin,info FROM users WHERE uid=$uid");
$row=mysql_fetch_array($result);
if (empty($row)) exit;
//проверка ввода action
if (empty($_GET['act'])) $act = "";
else $act = $_GET['act'];
$site_name = htmlspecialchars($row['site_name']);
$link = $row['link'];
$admin = htmlspecialchars($row['admin']);
$info = htmlspecialchars($row['info']);
// прелог
echo '[meta]';
echo '[body]';
$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 `uid`=$uid AND `date`=$today LIMIT 1;");
$row = mysql_fetch_array($result);
$host_today = $row['host'];
// ------------------------ онлайн------------------------
// подсчитываем онлайн посетителей
$result = mysql_query("SELECT count(ip) FROM online_ip WHERE uid=$uid");
$row=mysql_fetch_row($result);
$online=(int)$row[0];
// за вчера
// $result = mysql_query("SELECT `host` FROM `weeks` WHERE `uid`=$uid AND `date`=$downtoday LIMIT 1;");
// $row = mysql_fetch_array($result);
// $host_downtoday = $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);
$page = ceil($top_place/$count_top);
$act = latin($act);
switch ($act)
{
case 'country':
// вывод инфы
$link = str_replace("http://", "", $link);
echo "<a href=\"outtop.php?uid=$uid\">$link</a> - Статистика\n";
$result = mysql_query("
SELECT `top_operators`.`country`, `top_operators_stat`.`count`
FROM `top_operators_stat`
LEFT JOIN `top_operators`
ON `top_operators`.`id` = `top_operators_stat`.`id_operator`
WHERE `date` = '$today' AND `day_week` = $week_day AND `uid` = $uid
ORDER BY `top_operators_stat`.`count` DESC
");
$oper_array = array();
$summ = 0;
if (mysql_num_rows($result))
{
while ($row = mysql_fetch_assoc($result))
{
$oper_array[] = $row;
$summ += $row['count'];
//echo ((empty($row['name']))? 'Прочие' : $row['name']).': '.$row['count'].'<br/>';
}
}
echo "<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"2\">";
echo "<tr bgcolor=\"#cccccc\" align=\"center\">";
echo "<td><b><center>Страна</center></b></td><td><b><center>Доля, %</center></b></td></tr>\n";
echo '<tr bgcolor="#eeeeee">';
echo "<td>";
foreach ($oper_array AS $position => $row)
{
echo ((empty($row['country']))? 'Другие' : $row['country']).'</td><td>'.(round($row['count']/$summ*10000)/100).'%</td></tr>';
}
echo "</table>";
// навигация
echo "Статистика: <a href='stat.php?uid=$uid'>общая</a>\n";
echo "<a href='stat.php?act=day&uid=$uid'> по дням</a></a>\n";
echo "<a href='stat.php?act=hour&uid=$uid'> по часам</a>\n";
echo "<a href='stat.php?act=operators&uid=$uid'> операторы</a>\n";
echo " страны\n";
echo "<a href='stat.php?act=telinfo&uid=$uid'> модели</a></a>\n";
echo "<a href='online_tel.php?uid=$uid'> онлайн $online</a>\n";
break;
case 'operators':
// вывод инфы
$link = str_replace("http://", "", $link);
echo "<a href=\"outtop.php?uid=$uid\">$link</a> - Статистика\n";
$result = mysql_query("
SELECT `top_operators`.`name`, `top_operators`.`label`, `top_operators_stat`.`count`
FROM `top_operators_stat`
LEFT JOIN `top_operators`
ON `top_operators`.`id` = `top_operators_stat`.`id_operator`
WHERE `date` = $today AND `day_week` = $week_day AND `uid` = $uid
ORDER BY `top_operators_stat`.`count` DESC
");
$oper_array = array();
$summ = 0;
if (mysql_num_rows($result))
{
while ($row = mysql_fetch_assoc($result))
{
$oper_array[] = $row;
$summ += $row['count'];
//echo ((empty($row['name']))? 'Прочие' : $row['name']).': '.$row['count'].'<br/>';
}
}
echo "<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"2\">";
echo "<tr bgcolor=\"#cccccc\" align=\"center\">";
echo "<td><b><center>Оператор</center></b></td><td><b><center>Доля, %</center></b></td></tr>\n";
echo '<tr bgcolor="#eeeeee">';
echo "<td>";
foreach ($oper_array AS $position => $row)
{
echo ((empty($row['name']))? 'Другие' : $row['name']).'</td><td>'.(round($row['count']/$summ*10000)/100).'%</td></tr>';
}
echo "</table>";
// навигация
echo "Статистика: <a href='stat.php?uid=$uid'>общая</a>\n";
echo "<a href='stat.php?act=day&uid=$uid'> по дням</a></a>\n";
echo "<a href='stat.php?act=hour&uid=$uid'> по часам</a>\n";
echo " операторы\n";
echo "<a href='stat.php?act=country&uid=$uid'> страны</a>\n";
echo "<a href='stat.php?act=telinfo&uid=$uid'> модели</a></a>\n";
echo "<a href='online_tel.php?uid=$uid'> онлайн $online</a>\n";
break;
case "telinfo":
$tel = array(
"Siemens",
"Nokia",
"Samsung",
"Motorola",
"LG",
"Sagem",
"SonyEricsson",
"Alcatel",
"Sharp",
"Pantech",
"Panasonic",
"Другие"
);
// подсчет когда браузер не отределен
$result = mysql_query("SELECT `Siemens`,`Nokia`,`Samsung`,`Motorola`,`LG`,`Sagem`,`SonyEricsson`,`Alcatel`,`Sharp`,`Pantech`,`Panasonic`,`Other` FROM `weeks` WHERE `date`=$today AND `day_week`=$week_day AND `uid`=$uid LIMIT 1");
$tel_data = mysql_fetch_row($result);
if (empty($tel_data)) $tel_data = array (0,0,0,0,0,0,0,0,0,0,0,0);
$allhitos=array_sum($tel_data);
$hour = date("H");
// вывод инфы
$link = str_replace("http://", "", $link);
echo "<a href=\"outtop.php?uid=$uid\">$link</a> - Статистика\n";
echo '<table width="98%" border="1" cellspacing="1" cellpadding="2">';
echo "<tr bgcolor=\"#cccccc\" align=\"center\">";
echo "<td><b><center>Производитель</center></b></td><td><b><center>Доля %</center></b></td>\n";
echo '</tr>';
echo '<tr bgcolor="whitesmoke">';
foreach ($tel_data as $index => $value)
{
echo '<td>';
echo $tel[$index].":</td> <td><center>[span]$value(".round($value*100/$allhitos,2)."%)[/span]</center></td></tr>\n";
}
echo '</table>';
echo "Статистика: <a href='stat.php?uid=$uid'>общая</a>\n";
echo "<a href='stat.php?act=day&uid=$uid'> по дням</a></a>\n";
echo "<a href='stat.php?act=hour&uid=$uid'> по часам</a>\n";
echo "<a href='stat.php?act=operators&uid=$uid'> операторы</a>\n";
echo "<a href='stat.php?act=country&uid=$uid'> страны</a>\n";
echo " модели</a>\n";
echo "<a href='online_tel.php?uid=$uid'> онлайн $online</a>\n";
break;
//
//По дням
//
case "day":
// вывод инфы
$link = str_replace("http://", "", $link);
echo "<a href=\"outtop.php?uid=$uid\">$link</a> - Статистика\n";
echo "<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"2\">";
echo "<tr bgcolor=\"#cccccc\" align=\"center\">";
echo "<td style=\"color:#666666\"><b>Дата</b></td><td style=\"color:#666666\"><b>Хосты</b></td><td style=\"color:#666666\"><b>Хиты</b></td>";
echo '</tr>';
$zend=30;
$query = "SELECT * FROM `months` where `uid`=$uid ORDER BY id DESC LIMIT 30;";
$result = mysql_query($query)
or die("Query failed");
for ($i=0; $i <= mysql_num_rows($result) - 1; $i++) {
if (!mysql_data_seek($result, $i)) {
echo "Cannot seek to row $i\n";
continue;
}
if(!($row = mysql_fetch_object($result)))
continue;
$zend--;
if($zend==0) break;
$host = $row->host;
$allhosts+=$host;
$count = $row->count;
$allhits+=$count;
$date = date("Y.m.d");
echo '<tr bgcolor="#eeeeee">';
$txt="<td> $date </td><td> $host </td><td> $count</tb> ";
echo "[span]$txt [/span]<br/>\n";
}
echo '</tr>';
echo "<tr bgcolor=\"#cccccc\">";
echo "<td style=\"color:#666666\"><b>В среднем за сутки:</b></td><td style=\"color:#666666\"><b>[span]".floor($allhosts/mysql_num_rows($result))." [/span]</b></td><td style=\"color:#666666\"><b>[span]".floor($allhits/mysql_num_rows($result))." [/span]</b></td>";
echo '</table>';
echo "Статистика: <a href='stat.php?uid=$uid'>общая</a>\n";
echo " по дням</a>\n";
echo "<a href='stat.php?act=hour&uid=$uid'> по часам</a>\n";
echo "<a href='stat.php?act=operators&uid=$uid'> операторы</a>\n";
echo "<a href='stat.php?act=country&uid=$uid'> страны</a>\n";
echo "<a href='stat.php?act=telinfo&uid=$uid'> модели</a>\n";
echo "<a href='online_tel.php?uid=$uid'> онлайн $online</a>\n";
break;
//
//По часам
//
case "hour":
// вывод инфы
$link = str_replace("http://", "", $link);
echo "<a href=\"outtop.php?uid=$uid\">$link</a> - Статистика\n";
echo "<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"2\">";
echo "<tr bgcolor=\"#cccccc\" align=\"center\">";
echo "<td style=\"color:#666666\"><b>Часы</b></td><td style=\"color:#666666\"><b>Хосты</b></td><td style=\"color:#666666\"><b>Хиты</b></td>";
echo '</tr>';
$zend=24;
$query = "SELECT * FROM count_24 where `uid`=$uid and `date`=$today ORDER BY hour LIMIT 24;";
$result = mysql_query($query)
or die("Query failed");
for ($i=0; $i <= mysql_num_rows($result) - 1; $i++) {
if (!mysql_data_seek($result, $i)) {
echo "Cannot seek to row $i\n";
continue;
}
if(!($row = mysql_fetch_object($result)))
continue;
$zend--;
if($zend==0) break;
$host = $row->host;
$allh+=$host;
$count = $row->count;
$allhi+=$count;
$hour = $row->hour;
$hour = $hour.":00 - ".($hour+1).":00";
echo '<tr bgcolor="#eeeeee">';
$txt="<td> $hour </td><td> $host </td><td> $count</tb> ";
echo "[span]$txt [/span]<br/>\n";
}
echo '</tr>';
echo "<tr bgcolor=\"#cccccc\">";
echo "<td style=\"color:#666666\"><b>В среднем за час:</b></td><td style=\"color:#666666\"><b>[span]".floor($allh/mysql_num_rows($result))." [/span]</b></td><td style=\"color:#666666\"><b>[span]".floor($allhi/mysql_num_rows($result))." [/span]</b></td>";
echo '</table>';
echo "Статистика: <a href='stat.php?uid=$uid'>общая</a>\n";
echo "<a href='stat.php?act=day&uid=$uid'> по дням</a>\n";
echo " по часам\n";
echo "<a href='stat.php?act=operators&uid=$uid'> операторы</a>\n";
echo "<a href='stat.php?act=country&uid=$uid'> страны</a>\n";
echo "<a href='stat.php?act=telinfo&uid=$uid'> модели</a>\n";
echo "<a href='online_tel.php?uid=$uid'> онлайн $online</a>\n";
break;
default: // ======================== Статистика участника ======================
$hour = date("H");
$downtoday = date("Ymd",time()-86400);
// за сегодня
$result=mysql_query("SELECT `count`,`host` FROM `weeks` WHERE `uid`=$uid AND `date`=$today LIMIT 1;");
$row = mysql_fetch_array($result);
$count_today = $row['count'];
$host_today = $row['host'];
// за сегодня общая
$result=mysql_query("SELECT `count`,`host` FROM `weeks` AND `date`=$today LIMIT 1;");
$row = mysql_fetch_array($result);
$count_all = $row['count'];
$host_all = $row['host'];
// за вчера
$result=mysql_query("SELECT `count`,`host` FROM `weeks` WHERE `uid`=$uid AND `date`=$downtoday LIMIT 1;");
$row = mysql_fetch_array($result);
$count_downtoday = $row['count'];
$host_downtoday = $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);
// за 24 часа
$result = mysql_query("SELECT sum(`count`),sum(`host`) FROM `count_24` WHERE ((`date`=$today-1 AND `hour`>$hour) OR (`date`=$today AND `hour`<=$hour)) AND `uid`=$uid");
$row = mysql_fetch_row($result);
$count_24 = (int)$row[0];
$host_24 = (int)$row[1];
// данные за текущий час
$result = mysql_query("SELECT `count`,`host` FROM `count_24` WHERE `hour`=$hour AND `date`=$today AND `uid`=$uid");
$row=mysql_fetch_row($result);
// поверка наличия записи в базе
if (empty($row))
{
$hour_count = 0;
$hour_host = 0;
}else{
$hour_count = (int)$row[0];
$hour_host = (int)$row[1];
}
// ---------------------------- посещения за месяц --------------------
$months = array("Январь","Февраль","Март","Апрель","Май","Июнь","Июль","Август","Сентябрь","Октябрь","Ноябрь","Декабрь");
$today = date("Ym");
$index_month = date("m")-1;
// данные за текущий месяц
$result = mysql_query("SELECT count,host FROM months WHERE date=$today AND uid=$uid");
$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 WHERE uid=$uid");
$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 WHERE uid=$uid");
$row=mysql_fetch_row($result);
$online=(int)$row[0];
// -----------------------Всего---------------------------
$result = mysql_query("SELECT sum(count),sum(host) FROM months WHERE uid=$uid");
$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 AND `uid`=$uid LIMIT 1");
$count_row=mysql_fetch_array($counts_in_out);
$in_count = (int)$count_row['in'];
$out_count = (int)$count_row['out'];
// -----------------------Пришло \ Ушло Вчера---------------------------
$week_day = date("w");
$today = date("Ymd");
$counts_in_out = mysql_query("SELECT `in`,`out` FROM `weeks` WHERE `date`=$downtoday AND `day_week`=$week_day AND `uid`=$uid LIMIT 1");
$count_row=mysql_fetch_array($counts_in_out);
$in_count_downtoday = (int)$count_row['in'];
$out_count_downtoday = (int)$count_row['out'];
// -----------------------Пришло \ Ушло Неделя---------------------------
$week_day = date("w");
$today = date("Ymd");
$counts_in_out = mysql_query("SELECT sum(in),sum(out) FROM weeks WHERE uid=$uid");
$count_row=mysql_fetch_array($counts_in_out);
$in_count_week = (int)$count_row['in'];
$out_count_week = (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);
// вывод инфы
$link = str_replace("http://", "", $link);
echo "<a href=\"outtop.php?uid=$uid\">$link</a> - Статистика\n";
/*echo "<b>Описание:</b> <br/>\n";
echo "[span]$info [/span] <br/>\n";
echo "<b>Админ:</b> <br/>\n";
echo "[span]$admin [/span] <br/>\n";
echo "<b>Статистика телефонов:</b> <br/>\n";
echo "<a href='stat.php?act=telinfo&uid=$uid'>Смотреть</a> <br/>\n";
echo "<b>Статистика операторов:</b> <br/>\n";
echo "<a href='stat.php?act=operators&uid=$uid'>Смотреть</a> <br/>\n";
echo "<b>Место в ТОП:</b> \n";
echo "[span]$top_place [/span] <br/>\n";
echo "<b>Онлайн:</b> \n";
echo "<a href=\"online_tel.php?uid=$uid\">$online</a> <br/>\n";*/
echo "<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"2\">";
echo "<tr bgcolor=\"#cccccc\">";
echo "<td colspan=\"2\">Сегодня</td> </tr>\n";
echo "<tr><td>Хосты</td> <td>[span]$host_today [/span]</td></tr>\n";
echo "<tr bgcolor=\"#eeeeee\">";
echo "<td>Хиты</td> <td>[span]$count_today [/span]</td></tr>\n";
echo "<tr><td>В топ / из топа</td> <td>$in_count / $out_count </td></tr>\n";
echo "<tr bgcolor=\"#cccccc\">";
echo "<td colspan=\"2\">Вчера:</td> </tr>\n";
echo "<tr><td>Хосты</td> <td>[span]$host_downtoday [/span]</td></tr>\n";
echo "<tr bgcolor=\"#eeeeee\">";
echo "<td>Хиты</td> <td>[span]$count_downtoday [/span]</td>\n";
echo "<tr><td>В топ / из топа</td> <td>$in_count_downtoday / $out_count_downtoday </td></tr>\n";
/*echo "<b>За 24 часа:</b><br/>\n";
echo "-хитов: [span]$count_24 [/span]<br/>\n";
echo "-хостов: [span]$host_24 [/span]<br/>\n";
echo "<b>За этот час:</b><br/>\n";
echo "-хитов: [span]$hour_count [/span]<br/>\n";
echo "-хостов: [span]$hour_host [/span]<br/>\n";*/
echo "<tr bgcolor=\"#cccccc\">";
echo "<td colspan=\"2\">За 7 дней</td> </tr>\n";
echo "<tr><td>Хосты</td> <td>[span]$total_week_host [/span]</td></tr>\n";
echo "<tr bgcolor=\"#eeeeee\">";
echo "<td>Хиты</td> <td>[span]$total_week_count [/span]</td></tr>\n";
echo "<tr><td>В топ / из топа</td> <td>$in_count_week / $out_count_week </td></tr>\n";
echo "<tr bgcolor=\"#cccccc\">";
echo "<td colspan=\"2\">За 30 дней</td> </tr>\n";
echo "<tr><td>Хосты</td> <td>[span]$all_hosts [/span]</td></tr>\n";
echo "<tr bgcolor=\"#eeeeee\">";
echo "<td>Хиты</td> <td>[span]$all_hits [/span]</td></tr>\n";
echo "</table>";
/*echo "<b>Всего</b><br/>\n";
echo "-хитов: [span]$all_hits [/span]<br/>\n";
echo "-хостов: [span]$all_hosts [/span]<br/>\n";*/
/*echo "<b>График за неделю</b><br/>";
echo "<img src=\"graphic_7.php?uid=$uid\" alt=\"неделя\" /> <br/>\n";
echo "<b>График за 24 часа</b><br/>";
echo "<img src=\"graphic_24.php?uid=$uid\" alt=\"24 часа\" /> <br/>\n";*/
// навигация
echo "Статистика: общая\n";
echo "<a href='stat.php?act=day&uid=$uid'> по дням</a>\n";
echo "<a href='stat.php?act=hour&uid=$uid'> по часам</a>\n";
echo "<a href='stat.php?act=operators&uid=$uid'> операторы</a>\n";
echo "<a href='stat.php?act=telinfo&uid=$uid'> модели</a>\n";
echo "<a href='online_tel.php?uid=$uid'> онлайн $online</a>\n";
}
// общая навигация
echo "<div class=\"rh\"><a href=\"admin.php\">Вход</a> | <a href=\"reg.php\">Регистрация</a><br/></div>";
include "foot_code.php";
echo '[/body]';
}
//---------------------------------------------------------------
// вывод буфера
ob_end_flush();
?>