<?php
###############################################
#  by MaZaFaKa                                #
#  ICQ: 449-559                               #
#  E-mail: Dimonnet@inbox.ru                  #
#  Потраченное время: Около 2х недель         #
###############################################

$id = (int) $_GET['id'];
$item = (isset($_GET['item'])) ? ($_GET['item']) : "index";

$sql = mysql_query("SELECT `status` FROM `".USERS."` WHERE `id` = ".$id.";");

	if(mysql_num_rows($sql) < 1)
	{
	echo("Пользователь с ID = ".$id." не найден в базе данных.\n");
	$item = "default";
	}
	elseif(mysql_result($sql, 0) == "locked")
	{
	echo("Пользователь с ID = ".$id." заблокирован.\n");
	$item = "default";
	}

//ONLINE
$sql = mysql_query("SELECT COUNT(*) FROM `".ONLINE."` WHERE `user_id` = ".$id.";");
$is_online = mysql_result($sql, 0);

$sql = mysql_query("SELECT * FROM `".USERS."` WHERE `id` = ".$id.";");
$user = mysql_fetch_assoc($sql);

$user['url']=str_replace("http://","",$user['url']);


if(empty($_GET['item']))
{
$td_on = '<td style="color: #3366cc">&#149;</td><td><b>';
$b_off = '</b><td>';
}
else
{
$td_on = '<td>&nbsp;</td><td>';
}
//////
if($_GET['item']=='days')
{
$td_on2 = '<td style="color: #3366cc">&#149;</td><td><b>';
$b_off2 = '</b>';
}
else
{
$td_on2 = '<td>&nbsp;</td><td>';
}
//////
if($_GET['item']=='hours')
{
$td_on3 = '<td style="color: #3366cc">&#149;</td><td><b>';
$b_off3 = '</b>';
}
else
{
$td_on3 = '<td>&nbsp;</td><td>';
}
//////
if($_GET['item']=='online')
{
$td_on4 = '<td style="color: #3366cc">&#149;</td><td><b>';
$b_off4 = '</b>';
}
else
{
$td_on4 = '<td>&nbsp;</td><td>';
}
//////
if($_GET['item']=='operators')
{
$td_on5 = '<td style="color: #3366cc">&#149;</td><td><b>';
$b_off5 = '</b>';
}
else
{
$td_on5 = '<td>&nbsp;</td><td>';
}
//////
if($_GET['item']=='country')
{
$td_on6 = '<td style="color: #3366cc">&#149;</td><td><b>';
$b_off6 = '</b>';
}
else
{
$td_on6 = '<td>&nbsp;</td><td>';
}
//////
if($_GET['item']=='ip')
{
$td_on7 = '<td style="color: #3366cc">&#149;</td><td><b>';
$b_off7 = '</b>';
}
else
{
$td_on7 = '<td>&nbsp;</td><td>';
}
//////
if($_GET['item']=='brands')
{
$td_on8 = '<td style="color: #3366cc">&#149;</td><td><b>';
$b_off8 = '</b>';
}
else
{
$td_on8 = '<td>&nbsp;</td><td>';
}
//////
if($_GET['item']=='useragent')
{
$td_on9 = '<td style="color: #3366cc">&#149;</td><td><b>';
$b_off9 = '</b>';
}
else
{
$td_on9 = '<td>&nbsp;</td><td>';
}

print
('
<span style="color:#666666"><b>'.$user['url'].':</b></span><br/>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr><td colspan="2" height="5px"></td></tr>
<tr bgcolor="#cccccc"><td>&nbsp;</td><td style="color: #666666; bgcolor">Посещаемость</td></tr>
<tr>'.$td_on.'<a href="'.PATH.'/'.VERSION.'/info/'.$id.'">Сводная статистика</a>'.$b_off.'</td></tr>
<tr>'.$td_on2.'<a href="'.PATH.'/'.VERSION.'/info/'.$id.'?item=days">Посещаемость по дням</a>'.$b_off2.'</td></tr>
<tr>'.$td_on3.'<a href="'.PATH.'/'.VERSION.'/info/'.$id.'?item=hours">Посещаемость по часам</a>'.$b_off3.'</td></tr>
<tr>'.$td_on4.'<a href="'.PATH.'/'.VERSION.'/info/'.$id.'?item=online">Онлайн пользователи</a>'.$b_off4.'</td></tr>
<tr><td colspan="2" height="5px"></td></tr>
<tr bgcolor="#cccccc"><td>&nbsp;</td><td style="color: #666666; bgcolor">Операторы</td></tr>
<tr>'.$td_on5.'<a href="'.PATH.'/'.VERSION.'/info/'.$id.'?item=operators">Мобильные операторы</a>'.$b_off5.'</td></tr>
<tr>'.$td_on6.'<a href="'.PATH.'/'.VERSION.'/info/'.$id.'?item=country">Операторы по странам</a>'.$b_off6.'</td></tr>
<tr>'.$td_on7.'<a href="'.PATH.'/'.VERSION.'/info/'.$id.'?item=ip">По IP операторов</a>'.$b_off7.'</td></tr>
<tr><td colspan="2" height="5px"></td></tr>
<tr bgcolor="#cccccc"><td>&nbsp;</td><td style="color: #666666; bgcolor">Телефоны</td></tr>
<tr>'.$td_on8.'<a href="'.PATH.'/'.VERSION.'/info/'.$id.'?item=brands">Модели телефонов</a>'.$b_off8.'</td></tr>
<tr>'.$td_on9.'<a href="'.PATH.'/'.VERSION.'/info/'.$id.'?item=useragent">По браузерам</a>'.$b_off9.'</td></tr>
</table>
</td>
<td rowspan="2">&nbsp;</td>
<td rowspan="2" width="100%">
');

switch($item)
{
default:

print
('
<table width="555px" border="0" cellspacing="0" cellpadding="2">
<tr><td style="color: #666666">График посещаемости, '.date("d-m-Y", time()).'</td></tr>
</table>
');

print
('
<img src="/graph/info.php?id='.$id.'&amp;v=h" alt="">
');
print
('
<img src="/graph/info.php?id='.$id.'&amp;v=o" alt="">
');

print
('
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td style="color: #666666">
Сводная таблица для &laquo;<a href="'.PATH.'/'.VERSION.'/out/'.$id.'">'.$user['url'].'</a>&raquo<br />
</td>
</tr>
</table>
');

print
('
<table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td bgcolor="#ff6600">
<table width="100%" border="0" cellspacing="1" cellpadding="0"><tr><td bgcolor="#ffffff">
<table width="100%" border="0" cellspacing="1" cellpadding="4">
<tr bgcolor="#cccccc">
<td width="40%">Показатель</td>
<td width="15%">Сегодня</td>
<td width="15%">Вчера</td>
<td width="15%">за 30 дней</td>
<td width="15%">Всего</td>
</tr>
<tr>
<td>Хосты*</td>
<td>'.$user['hosts'].'</td>
<td>'.$user['yday_hosts'].'</td>
<td>'.$user['month_hosts'].'</td>
<td>'.$user['all_hosts'].'</td>
</tr>
<tr bgcolor="#eeeeee">
<td>Хиты</td>
<td>'.$user['hits'].'</td>
<td>'.$user['yday_hits'].'</td>
<td>'.$user['month_hits'].'</td>
<td>'.$user['all_hits'].'</td>
</tr>
<tr>
<td>Переходов из рейтинга на сайт</td>
<td>'.$user['out'].'</td>
<td>-</td>
<td>-</td>
<td>'.$user['all_out'].'</td>
</tr>
<tr bgcolor="#eeeeee">
<td>Переходов с сайта на рейтинг</td>
<td>'.$user['in'].'</td>
<td>-</td>
<td>-</td>
<td>'.$user['all_in'].'</td>
</tr>
</table>
</td></tr></table>
</td></tr></table>
<span style="color: #666666">* суммарное количество уникальных хостов по всем площадкам сайта.</span><br/><br/>
</td>
</tr>
<tr>
');



break;
///////////////////////////////////////////////////////////////////////////////////////////
case 'online':
$sql = mysql_query("SELECT COUNT(*) FROM `".ONLINE."` WHERE `user_id` = ".$id.";");
$count = mysql_result($sql, 0);

$page = (isset($_GET['page'])) ? intval($_GET['page']) : "0";
if($page < 0 || $page > $count) $page = 0;




print
('
<table width="555px" border="0" cellspacing="0" cellpadding="2">
<tr>
<td style="color: #666666">Таблица онлайн пользователей</td>
<td align="right" style="color: #666666">Всего: '.$count.'</td>
</tr>
</table>
');

print
('
<table width="555px" border="0" cellspacing="0" cellpadding="0"><tr><td bgcolor="#ff6600">
<table width="100%" border="0" cellspacing="1" cellpadding="0"><tr><td bgcolor="#ffffff">
<table width="100%" border="0" cellspacing="1" cellpadding="4">
<tr bgcolor="#cccccc" align="center">
<td width="5%" style="color:#666666" nowrap><b>#</b></td>
<td width="25%" style="color:#666666" nowrap><b>Браузер</b></td>
<td width="25%" style="color:#666666" nowrap><b>Ip</b></td>
</tr>
');


//SELECT
$sql = mysql_query("SELECT `user-agent`, INET_NTOA(`ip`) as `ip` FROM `".ONLINE."` WHERE `user_id` = ".$id." ORDER BY `date` DESC LIMIT ".$page.", ".BIGPAGE.";");

	if(mysql_num_rows($sql) > 0)
	{
	$c = 1;

		while($online = mysql_fetch_assoc($sql))
		{
		        $d = $c / 2;
                $d1 = ceil($d);
                $d2 = $d1 - $d;
                $d3 = ceil($d2);
                if ($d3 == 0)
                {
	            $trs = ("<tr align=\"center\"  bgcolor=\"#dddddd\">");
                }
                else
                {
	            $trs = ("<tr align=\"center\" bgcolor=\"#eeeeee\">");
                }


		echo("".$trs."<td>".$c."</td> <td>".$online['user-agent']."</td> <td>".$online['ip']."</td></tr>\n");
		$c++;
		}

	if(($count > ($page + BIGPAGE)) || ($page > 0)) echo("---<br />\n");
	if($count > ($page + BIGPAGE)) echo("<a href='".PATH."/".VERSION."/info/".$id."/?item=online&amp;page=".($page + BIGPAGE)."'>Далее</a><br />\n");
	if($page > 0) echo("<a href='".PATH."/".VERSION."/info/".$id."/?item=online&amp;page=".($page - BIGPAGE)."'>Назад</a><br />\n");
	}
	else
	{
	echo("<tr align=\"center\"  bgcolor=\"#dddddd\"><td>No</td> <td>Онлайн пуст</td> <td>System</td></tr>\n");
	}
print
('
</tr></table>
</td></tr></table>
</td></tr></table>
<table width="555px" border="0" cellspacing="2" cellpadding="0">
<tr>
<td align="right" nowrap><span style="color: #666666">за последние 2 минуты</span></td>
</tr>
</table>
</td>
</tr>
');

break;
///////////////////////////////////////////////////////////////////////////////////////////
case 'hours':

print
('
<table width="555px" border="0" cellspacing="0" cellpadding="2">
<tr><td style="color: #666666">График посещаемости по часам, '.date("d-m-Y", time()).'</td></tr>
</table>
');

print
('
<img src="/graph/hours.php?id='.$id.'" alt="">
');

print
('
<table width="555px" border="0" cellspacing="0" cellpadding="2">
<tr><td style="color: #666666">Таблица посещаемости по часам, '.date("d-m-Y", time()).'</td></tr>
</table>
<table width="555px" border="0" cellspacing="0" cellpadding="0"><tr><td bgcolor="#ff6600">
<table width="100%" border="0" cellspacing="1" cellpadding="0"><tr><td bgcolor="#ffffff">
<table width="100%" border="0" cellspacing="1" cellpadding="4">
<tr bgcolor="#cccccc" align="center">
<td rowspan="1" width="25%" style="color:#666666" nowrap><b>Часы</b></td>
<td colspan="2" width="100%" style="color:#666666" nowrap><b>хиты</b></td>
</tr>
');

for($i = 0; $i < 24; $i++)
{
$sql = mysql_query("SELECT SUM(`count`) as `count` FROM `".SHOWS."` WHERE `date` BETWEEN ".mktime($i, 0, 0, date("m"), date("d"), date("Y"))." AND ".mktime(($i + 1), 0, 0, date("m"), date("d"), date("Y"))." AND `user_id` = ".$id.";");

if(strlen($i) == 1) $i = "0".$i;
if(strlen($i + 1) == 1) $j = "0".($i + 1);
else $j = $i + 1;

echo("<tr bgcolor=\"#eeeeee\"><td>С ".$i.":00 по ".($j).":00</td><td><center>".intval(mysql_result($sql, 0))."</center></td></tr>\n");
}

print
('
</table>
</table>
</table>
<span style="color: #666666;">* в графе &laquo;С начала дня&raquo; отображается нарастающее количество хостов и хитов.</span><br/>
</td>
');


break;
/////////////////////////////////////////////////////////////////////////////////////////////
case 'days':
//ARRAY
$array_month = array("1" => "Январь", "2" => "Февраль", "3" => "Март", "4" => "Апрель", "5" => "Май", "6" => "Июнь", "7" => "Июль", "8" => "Август", "9" => "Сентябрь", "10" => "Октябрь", "11" => "Ноябрь", "12" => "Декабрь");
$array_year = array("2007" => "2007", "2008" => "2008");
//MONTH
$month = (int) $_POST['month'];
if(empty($month) || $month < 1 || $month > 12) $month = date("m");
//YEAR
$year = (int) $_POST['year'];
if(empty($year) || $year < 2007 || $year > 2008) $year = 2008;
print
('
<table width="555px" border="0" cellspacing="0" cellpadding="0"><tr><td bgcolor="#ff6600">
<table width="100%" border="0" cellspacing="1" cellpadding="0"><tr><td bgcolor="#ffffff">
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr bgcolor="#cccccc"><td align="center">&nbsp;<span style="color:#333366">Период показа статистики</span></td><tr>
');
echo
(
"<tr><td><center><form action='".PATH."/".VERSION."/info/".$id."/?item=days&amp;".SESSION."' method='post'>\n".
"<select name='month'>\n");

	foreach($array_month as $key => $value)
	{
	if($key == $month) echo("<option value='".$key."' selected='selected'>".$value."</option>\n");
	else echo("<option value='".$key."'>".$value."</option>\n");
	}

echo
(
"</select>\n".
"<select name='year'>\n");

	foreach($array_year as $key => $value)
	{
	if($key == $year) echo("<option value='".$key."' selected='selected'>".$value."</option>\n");
	else echo("<option value='".$key."'>".$value."</option>\n");
	}

echo
(
"</select>\n".
"<input type='submit' value='Посмотреть' />\n".
"</form>\n".
"</table>\n".
"</td></tr></table>\n".
"</td></tr></table></center>\n");

print
('
<table width="555px" border="0" cellspacing="0" cellpadding="2">
<tr><td style="color: #666666">Посещаемость по дням,  '.$_POST['month'].'-'.$_POST['year'].'</td></tr>
</table>

<table width="555px" border="0" cellspacing="0" cellpadding="0"><tr><td bgcolor="#ff6600">
<table width="100%" border="0" cellspacing="1" cellpadding="0"><tr><td bgcolor="#ffffff">
<table width="100%" border="0" cellspacing="1" cellpadding="4">
<tr bgcolor="#cccccc" align="center">
<td rowspan="2" width="50%" style="color:#666666"><b>Дата</b></td>
<td colspan="2" style="color:#666666"><b>Посещаемость</b></td>
</tr>
<tr bgcolor="#cccccc" align="center">
<td width="25%" style="color:#666666"><b>Хосты</b></td>
<td width="25%" style="color:#666666"><b>Хиты</b></td>
</tr>
');


if($year == 2007) $sql = mysql_query("SELECT `hosts`, `hits`, `date` FROM `".STATS_DAY."` WHERE `date` BETWEEN '2007-".$month."-1' AND '2007-".$month."-31' AND `id` = ".$id." ORDER BY `date`;");
else $sql = mysql_query("SELECT `hosts`, `hits`, `date` FROM `".STATS_DAY_2008."` WHERE `date` BETWEEN '2008-".$month."-1' AND '2008-".$month."-31' AND `id` = ".$id." ORDER BY `date`;");

	if(mysql_num_rows($sql) > 0)
	{
		while($st = mysql_fetch_assoc($sql))
		{
		$date = explode("-", $st['date']);
		$date = $date[2].".".$date[1];

         	    $d = $date[1] / 2;
                $d1 = ceil($d);
                $d2 = $d1 - $d;
                $d3 = ceil($d2);
                if ($d3 == 0)
                {
	            $trs = ("<tr bgcolor=\"#dddddd\">");
                }
                else
                {
	            $trs = ("<tr bgcolor=\"#eeeeee\">");
                }


		echo("".$trs."<td>".$date."</td><td>".$st['hosts']."</td><td>".$st['hits']."</td></tr>\n");
		}
	}
	else
	{
	echo("".$trs."<td>Статистики ещё нету</td><td>-</td><td>-</td></tr>\n");
	}

print
('
</table>
</td></tr></table>
</td></tr></table>
</td>
</tr>
');

break;
//////////////////////////////////////////////////////////////////////////////////////////////
case 'ip':

print
('
<table width="555px" border="0" cellspacing="0" cellpadding="2">
<td width="100%" style="color: #666666">IP мобильной связи, '.date("d-m-Y", time()).'</span></td>
</table>
');

print
('
<table width="555px" border="0" cellspacing="0" cellpadding="0"><tr><td bgcolor="#ff6600">
<table width="100%" border="0" cellspacing="1" cellpadding="0"><tr><td bgcolor="#ffffff">
<table width="100%" border="0" cellspacing="1" cellpadding="4">
<tr bgcolor="#cccccc" align="center">
<td rowspan="1" style="color: #666666"> <b>IP адрес</b> </td>
<td colspan="1" style="color: #666666"> <b>Доля, %</b> </td>
<td rowspan="1" style="color: #666666"> <b>Хиты</b> </td>
');

$sql = mysql_query("SELECT SUM(`count`) FROM `".SHOWS."` WHERE `user_id` = ".$id.";");
$all = mysql_result($sql, 0);

$sql = mysql_query("SELECT COUNT(DISTINCT `ip`) FROM `".SHOWS."` WHERE `user_id` = ".$id.";");
$count = mysql_result($sql, 0);

$page = (isset($_GET['page'])) ? intval($_GET['page']) : "0";
if($page < 0 || $page > $count) $page = 0;

$sql = mysql_query("SELECT DISTINCT INET_NTOA(`ip`) as `ip`, SUM(`count`) AS `count` FROM `".SHOWS."` WHERE `user_id` = ".$id." GROUP BY `ip` ORDER BY 2 DESC LIMIT ".$page.", 30;");

	if(mysql_num_rows($sql) > 0)
	{
		while($stat = mysql_fetch_assoc($sql))
		{
		         		$sk = ($stat['count'] / $all) * 100;

		        $d = $c / 2;
                $d1 = ceil($d);
                $d2 = $d1 - $d;
                $d3 = ceil($d2);
                if ($d3 == 0)
                {
	            $trs = ("<tr align=\"center\"  bgcolor=\"#dddddd\">");
                }
                else
                {
	            $trs = ("<tr align=\"center\" bgcolor=\"#eeeeee\">");
                }


		echo("".$trs."<td>&nbsp ".$stat['ip']."</td><td>".round($sk, 2)."%</td><td>".$stat['count']."</td></tr>\n");
         $c++;
		}




	if($page > 0) echo("<td><a class=\"scr\" href='".PATH."/".VERSION."/info/".$id."/?item=ip&amp;page=".($page - BIGPAGE)."'>Назад</a></td>\n");
	if($count > ($page + BIGPAGE)) echo("<td><a class=\"scr\" href='".PATH."/".VERSION."/info/".$id."/?item=ip&amp;page=".($page + BIGPAGE)."'>Далее</a></td>\n");
	}
	else
	{
	echo("<tr align=\"center\"  bgcolor=\"#dddddd\"><td>&nbsp IP не обнаруженно</td><td>Not</td><td>Not</td></tr>\n");
	}


print
('
</table>
</td></tr></table>
</td></tr></table>
</td>
</tr>
');

break;
///////////////////////////////////////////////////////////////////////////////////////////////////////////
case 'brands':
print
('
<table width="555px" border="0" cellspacing="0" cellpadding="2">
<td width="100%" style="color: #666666">Производители телефонов, '.date("d-m-Y", time()).'</span></td>
</table>
');

print
('
<table width="555px" border="0" cellspacing="0" cellpadding="0"><tr><td bgcolor="#ff6600">
<table width="100%" border="0" cellspacing="1" cellpadding="0"><tr><td bgcolor="#ffffff">
<table width="100%" border="0" cellspacing="1" cellpadding="4">
<tr bgcolor="#cccccc" align="center">
<td style="color: #666666"> <b>Производитель<br/></b> </td>
<td style="color: #666666"> <b>Доля, %</b> </td>
<td style="color: #666666"> <b>Хиты</b> </td>
</tr>
');

$array_ua = array
(
2 => "SonyEricsson",
3 => "Nokia",
4 => "Samsung",
5 => "Siemens",
6 => "Motorola",
7 => "Lg",
8 => "Sagem",
9 => "Opera",
10 => "Panasonic",
11 => "Fly",
12 => "Sharp",
13 => "Philips",
14 => "Alcatel",
15 => "Компьютеры",
1 => "Другие"
);

$sql = mysql_query("SELECT SUM(`count`) FROM `".SHOWS."` WHERE `user_id` = ".$id.";");
$all = mysql_result($sql, 0);

$sql = mysql_query("SELECT DISTINCT `brand`, SUM(`count`) AS `count` FROM `".SHOWS."` WHERE `user_id` = ".$id." GROUP BY `brand` ORDER BY 2 DESC;");

	if(mysql_num_rows($sql) > 0)
	{
		while($stat = mysql_fetch_assoc($sql))
		{


		 		$d = $c / 2;
                $d1 = ceil($d);
                $d2 = $d1 - $d;
                $d3 = ceil($d2);
                if ($d3 == 0)
                {
	            $trs = ("<tr align=\"center\"  bgcolor=\"#dddddd\">");
                }
                else
                {
	            $trs = ("<tr align=\"center\" bgcolor=\"#eeeeee\">");
                }


		$sk = ($stat['count'] / $all) * 100;
		echo("".$trs."<td>".$array_ua[$stat['brand']]."</td><td>".round($sk, 2)."%</td><td>".$stat['count']." </td></tr>\n");
         $c++;

		}
	}
	else
	{
	echo("<tr align=\"center\"  bgcolor=\"#dddddd\"><td>&nbsp Моделей телефонов не обнаруженно</td><td>Not</td><td>Not</td></tr>\n");
	}
print
('
</table>
</td></tr></table>
</td></tr></table>
</td>
</tr>
');

break;
////////////////////////////////////////////////////////////////////////////////////////////////////////////
case 'useragent':

print
('
<table width="555px" border="0" cellspacing="0" cellpadding="2">
<td width="100%" style="color: #666666">Производители телефонов, '.date("d-m-Y", time()).'</span></td>
</table>
');

print
('
<table width="555px" border="0" cellspacing="0" cellpadding="0"><tr><td bgcolor="#ff6600">
<table width="100%" border="0" cellspacing="1" cellpadding="0"><tr><td bgcolor="#ffffff">
<table width="100%" border="0" cellspacing="1" cellpadding="4">
<tr bgcolor="#cccccc" align="center">
<td style="color: #666666"> <b>User-agent<br/></b> </td>
<td style="color: #666666"> <b>Доля, %</b> </td>
<td style="color: #666666"> <b>Хиты</b> </td>
</tr>
');

$sql = mysql_query("SELECT SUM(`count`) FROM `".SHOWS."` WHERE `user_id` = ".$id.";");
$all = mysql_result($sql, 0);

$sql = mysql_query("SELECT COUNT(DISTINCT `user-agent`) FROM `".SHOWS."` WHERE `user_id` = ".$id.";");
$count = mysql_result($sql, 0);

$page = (isset($_GET['page'])) ? intval($_GET['page']) : "0";
if($page < 0 || $page > $count) $page = 0;

$sql = mysql_query("SELECT DISTINCT `user-agent`, SUM(`count`) AS `count` FROM `".SHOWS."` WHERE `user_id` = ".$id." GROUP BY `user-agent` ORDER BY 2 DESC LIMIT ".$page.", 30;");

	if(mysql_num_rows($sql) > 0)
	{
		while($stat = mysql_fetch_assoc($sql))
		{

		 		$d = $c / 2;
                $d1 = ceil($d);
                $d2 = $d1 - $d;
                $d3 = ceil($d2);
                if ($d3 == 0)
                {
	            $trs = ("<tr align=\"center\"  bgcolor=\"#dddddd\">");
                }
                else
                {
	            $trs = ("<tr align=\"center\" bgcolor=\"#eeeeee\">");
                }


		$sk = ($stat['count'] / $all) * 100;
		echo("".$trs."<td>".$stat['user-agent']."</td><td>".round($sk, 2)."%</td><td>".$stat['count']." </td></tr>\n");
         $c++;




		}

	if($page > 0) echo("<td><a class=\"scr\" href='".PATH."/".VERSION."/info/".$id."/?item=useragent&amp;page=".($page - BIGPAGE)."'>Назад</a></td>\n");
	if($count > ($page + BIGPAGE)) echo("<td><a class=\"scr\" href='".PATH."/".VERSION."/info/".$id."/?item=useragent&amp;page=".($page + BIGPAGE)."'>Далее</a></td>\n");
	}
	else
	{
	echo("<tr align=\"center\"  bgcolor=\"#dddddd\"><td>&nbsp Статистика по User-agent не обнаруженна</td><td>Not</td><td>Not</td></tr>\n");
	}

print
('
</table>
</td></tr></table>
</td></tr></table>
</td>
</tr>
');

break;
//////////////////////////////////////////////////////////////////////////////////////////////////
case 'operators':

print
('
<table width="555px" border="0" cellspacing="0" cellpadding="2">
<td width="100%" style="color: #666666">Операторы мобильной связи, '.date("d-m-Y", time()).'</span></td>
<td nowrap align="right">операторы | <a href="'.PATH.'/'.VERSION.'/info/'.$id.'?item=country">страны</a></td>
</table>
');

print
('
<table width="555px" border="0" cellspacing="0" cellpadding="0"><tr><td bgcolor="#ff6600">
<table width="100%" border="0" cellspacing="1" cellpadding="0"><tr><td bgcolor="#ffffff">
<table width="100%" border="0" cellspacing="1" cellpadding="4">
<tr bgcolor="#cccccc" align="center">
<td rowspan="1" style="color: #666666"> <b>Оператор / Страна</b> </td>
<td colspan="1" style="color: #666666"> <b>Доля, %</b> </td>
<td rowspan="1" style="color: #666666"> <b>Хиты</b> </td>
');

$sql = mysql_query("SELECT SUM(`count`) FROM `".SHOWS."` WHERE `user_id` = ".$id.";");
$all = mysql_result($sql, 0);

$sql = mysql_query("SELECT DISTINCT `".SHOWS."`.`operator`, SUM(`".SHOWS."`.`count`) AS `count`, `".IP_NAME."`.`name` as `name` FROM `".SHOWS."`, `".IP_NAME."` WHERE `".SHOWS."`.`user_id` = ".$id." AND `".SHOWS."`.`operator` = `".IP_NAME."`.`id` GROUP BY `".SHOWS."`.`operator` ORDER BY 2 DESC;");

	if(mysql_num_rows($sql) > 0)
	{

		while($stat = mysql_fetch_assoc($sql))
		{

          		$sk = ($stat['count'] / $all) * 100;

		        $d = $c / 2;
                $d1 = ceil($d);
                $d2 = $d1 - $d;
                $d3 = ceil($d2);
                if ($d3 == 0)
                {
	            $trs = ("<tr align=\"center\"  bgcolor=\"#dddddd\">");
                }
                else
                {
	            $trs = ("<tr align=\"center\" bgcolor=\"#eeeeee\">");
                }


		echo("".$trs."<td>&nbsp ".$stat['name']."</td><td>".round($sk, 2)."%</td><td>".$stat['count']."</td></tr>\n");

          $c++;


		}


	}
	else
	{
	echo("<tr align=\"center\"  bgcolor=\"#dddddd\"><td>&nbsp Операторов не обнаруженно</td><td>Not</td><td>Not</td></tr>\n");
	}

print
('
</table>
</td></tr></table>
</td></tr></table>
</td>
</tr>
');

break;

case 'country':
print
('
<table width="555px" border="0" cellspacing="0" cellpadding="2">
<td width="100%" style="color: #666666">Операторы по странам, '.date("d-m-Y", time()).'</span></td>
<td nowrap align="right"><a href="'.PATH.'/'.VERSION.'/info/'.$id.'?item=operators">операторы</a> | страны</td>
</tr>
</table>
');

print
('
<table width="555px" border="0" cellspacing="0" cellpadding="0"><tr><td bgcolor="#ff6600">
<table width="100%" border="0" cellspacing="1" cellpadding="0"><tr><td bgcolor="#ffffff">
<table width="100%" border="0" cellspacing="1" cellpadding="4">
<tr bgcolor="#cccccc" align="center">
<td style="color: #666666"> <b>Страна</b> </td>
<td style="color: #666666"> <b>Доля хитов, %</b> </td>
<td style="color: #666666"> <b>Хиты</b> </td>
</tr>
');

$sql = mysql_query("SELECT SUM(`count`) FROM `".SHOWS."` WHERE `user_id` = ".$id.";");
$all = mysql_result($sql, 0);

$sql = mysql_query("SELECT DISTINCT `".IP_COUNTRY."`.`id`, SUM(`".SHOWS."`.`count`) AS `count`, `".IP_COUNTRY."`.`name` as `name` FROM `".SHOWS."`, `".IP_COUNTRY."`, `".IP_NAME."` WHERE `".SHOWS."`.`user_id` = ".$id." AND `".SHOWS."`.`operator` = `".IP_NAME."`.`id` AND `".IP_COUNTRY."`.`id` = `".IP_NAME."`.`country` GROUP BY `".IP_COUNTRY."`.`id` ORDER BY 2 DESC;") or print(mysql_error());

	if(mysql_num_rows($sql) > 0)
	{
		while($stat = mysql_fetch_assoc($sql))
		{


          		$sk = ($stat['count'] / $all) * 100;

		        $d = $c / 2;
                $d1 = ceil($d);
                $d2 = $d1 - $d;
                $d3 = ceil($d2);
                if ($d3 == 0)
                {
	            $trs = ("<tr align=\"center\"  bgcolor=\"#dddddd\">");
                }
                else
                {
	            $trs = ("<tr align=\"center\" bgcolor=\"#eeeeee\">");
                }


		echo("".$trs."<td>&nbsp ".$stat['name']."</td><td>".round($sk, 2)."%</td><td>".$stat['count']."</td></tr>\n");

          $c++;


		}
	}
	else
	{
	echo("<tr align=\"center\"  bgcolor=\"#dddddd\"><td>&nbsp Статистика не обнаруженна</td><td>Not</td><td>Not</td></tr>\n");
	}

print
('
</table>
</td></tr></table>
</td></tr></table>
</td>
</tr>
');

break;

case 'default':
//LOCKED OR NOT FOUND
break;
}
?>