Файл: m/cat.php
Строк: 51
<?php
define('NTOP', 1);
$title = 'Категории';
require_once ('../system/connect.php');
require_once ('../system/core.php');
require_once ('../system/function.php');
require_once ('head.php');
switch($act)
{
default:
echo '<div class="title2"><a href="http://'.$set['home'].'/?">TOP-100</a> | <strong>Категории</strong><br/></div>';
$cats = mysql_query("SELECT * FROM `".$prefix."cat` ORDER BY `position`");
while($cat = mysql_fetch_array($cats))
{
$count_sites = mysql_num_rows(mysql_query("SELECT * FROM `".$prefix."sait` WHERE `category` = '".$cat['id']."' AND `status` = '1' AND `hosts` > '0'"));
echo '<div class = "main">';
echo '<a href = "http://'.$set['home'].'/m/category/view/'.$cat['id'].'">'.$cat['name'].'</a> ('.$count_sites.')</div>';
}
break;
case 'view':
$isset = mysql_query("SELECT * FROM `".$prefix."cat` WHERE `id` = '".$id."'");
if(mysql_num_rows($isset) > 0)
{
$catt = mysql_fetch_array($isset);
echo '<div class="title2"><a href="http://'.$set['home'].'/m/category">Категории</a> | <strong>'.$catt['name'].'</strong></div>';
$count = mysql_num_rows(mysql_query("SELECT * FROM `".$prefix."sait` WHERE `category` = '".$id."' AND `status` = '1' AND `ban` = '0' AND `hosts` > '0'"));
if($count > 0)
{
$total=intval(($count-1)/$page_sait)+1;
$page=abs(intval($_GET['page']));
if(empty($page) OR $page < 0)
{
$page = 1;
}
if($page > $total)
{
$page = $total;
}
$past=intval($count/$page_sait);
$start=$page*$page_sait-$page_sait;
$saits = mysql_query("SELECT * FROM `".$prefix."sait` WHERE `category` = '".$id."' AND `status` = '1' AND `ban` = '0' AND `hosts` > '0' ORDER BY `hosts` DESC LIMIT ".$start.",".$page_sait."");
while($row = mysql_fetch_array($saits))
{
$start++;
echo '<div class="title">'.$start.'.<a href="http://'.$set['home'].'/out/'.$row['id'].'"><strong>'.$row['name'].'</strong></a> (<strong>'.$row['hosts'].'/'.$row['hits'].'</strong>) <a href="http://'.$set['home'].'/stats/'.$row['id'].'"><strong>(i)</strong></a><br/></div>';
echo '<div class="main">';
if(mb_strlen($row['about']) > 50)
{
$text = substr($row['about'],0,50);
echo ''.$text.'...<br/>';
}
else
{
echo ''.$row['about'].'<br/>';
}
echo 'В Топ: <strong>'.$row['in'].'</strong> | Из Топа: <strong>'.$row['out'].'</strong><br/>';
echo '</div>';
}
navigation($count,$page_sait,$page,'http://'.$set['home'].'/m/category/view/'.$id.'/',$total);
}
else
{
echo '<div class="main">';
echo 'Сайтов в данной категории нет!<br/>';
echo '<a href="http://'.$set['home'].'/m/category">К списку категорий</a><br/>';
echo '</div>';
}
}
else
{
echo '<div class="error">';
echo 'Ошибка!Данной категории не существует!<br/>';
echo '<a href="http://'.$set['home'].'/m/category">К списку категорий</a><br/>';
echo '</div>';
}
break;
}
require_once ('foot.php');
?>