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


switch($item)
{
default:
$sql = mysql_query("SELECT * FROM `".USERS."` WHERE `status` = 'vip' AND `hits` > 0;");
$count = mysql_result($sql, 0);

echo("<a href='".PATH."/".VERSION."/'>ТОП-100</a> | Категории<br /><br />\n");
echo("<a href='".PATH."/".VERSION."/category/?item=vip'>Избранное</a> (".intval($count).")<br />\n");
$sql = mysql_query("SELECT `id`, `description` FROM `".CATEGORY."` ORDER BY `position`;");

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

	while($cat = mysql_fetch_assoc($sql))
	{
		$q = mysql_query("SELECT COUNT(*) FROM `".USERS."` WHERE `status` != 'locked' AND `hits` > 0 AND `category` = ".$cat['id'].";");
		$count = mysql_result($q, 0);

		echo($c.". <a href='".PATH."/".VERSION."/category/".$cat['id']."/'>".$cat['description']."</a> (".$count.")<br />\n");
		$c++;
	}
}
else
{
	echo("Не найдено категорий сайтов в рейтинге.<br />\n");
}

echo(
"---<br />\n".
"<a href='".PATH."/".VERSION."/about/?".SESSION."'>Информация</a><br />\n".
"<a href='".PATH."/".VERSION."/rules/?new=1'>Регистрация</a><br />\n".
"WML | <a href='".PATH."/xhtml/category/?".SESSION."'>xHTML</a><br />\n");
break;

case 'rating':
$sql = mysql_query("SELECT COUNT(*) FROM `".USERS."` WHERE `status` != 'locked' AND `hits` > 0 AND `category` = ".$id.";");
$all = mysql_result($sql, 0);

if($all > 0)
{
	$max_page = ceil($all / 10);

	$page = (int) $_REQUEST['page'];
	if(empty($page) || $page < 1 || $page > $max_page) $page = 1;

	if($page > 1) $from = ($page - 1) * 10;
	else $from = 0;

	$sql = mysql_query("SELECT * FROM `".USERS."` WHERE `status` != 'locked' AND `hits` > 0 AND `category` = ".$id." ORDER BY `hosts` DESC, `hits` DESC LIMIT ".$from.", 10;");

	$c = $from + 1;

	while($top = mysql_fetch_assoc($sql))
	{
	$q = mysql_query("SELECT COUNT(*) FROM `".ONLINE."` WHERE `user_id` = ".$top['id'].";");
	$is_online = mysql_result($q, 0);

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

	echo($c.". <a href='".PATH."/".VERSION."/out/".$top['id']."/'>".$top['url']."</a> (".$top['hosts']."/".$top['hits'].") <a href='".PATH."/".VERSION."/info/".$top['id']."/'>(?)</a><br />\n");
	echo($top['about']."<br />\n");

	$c++;
	}

//NAVIGATION
echo(pages($page, $max_page, PATH."/".VERSION."/category/".$id, VERSION));
}
else
{
echo("Активных сайтов, учавствующих в рейтинге, не найдено.<br />---<br />\n");
}

echo("<a href='".PATH."/".VERSION."/category/'>Категории</a><br />\n");
break;

case 'vip':
$sql = mysql_query("SELECT COUNT(*) FROM `".USERS."` WHERE `status` = 'vip' AND `hits` > 0;");
$all = mysql_result($sql, 0);

if($all > 0)
{
	$max_page = ceil($all / 10);

	$page = (int) $_REQUEST['page'];
	if(empty($page) || $page < 1 || $page > $max_page) $page = 1;

	if($page > 1) $from = ($page - 1) * 10;
	else $from = 0;

	$sql = mysql_query("SELECT * FROM `".USERS."` WHERE `status` = 'vip' AND `hits` > 0 ORDER BY `hosts` DESC, `hits` DESC LIMIT ".$from.", 10;");

	$c = $from + 1;

	while($top = mysql_fetch_assoc($sql))
	{
	$q = mysql_query("SELECT COUNT(*) FROM `".ONLINE."` WHERE `user_id` = ".$top['id'].";");
	$is_online = mysql_result($q, 0);

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

	echo($c.". <a href='".PATH."/".VERSION."/out/".$top['id']."/'>".$top['url']."</a> (".$top['hosts']."/".$top['hits'].") <a href='".PATH."/".VERSION."/info/".$top['id']."/'>(?)</a><br />\n");
	echo($top['about']."<br />\n");

	$c++;
	}

//NAVIGATION
echo(pages($page, $max_page, PATH."/".VERSION."/category/".$id, VERSION));
}
else
{
echo("Активных сайтов, учавствующих в рейтинге, не найдено.<br />---<br />\n");
}

echo("<a href='".PATH."/".VERSION."/category/'>Категории</a><br />\n");
break;

}

?>