File size: 2.38Kb
<?php
include "init/config.php";
include "init/system.php";
include "init/navigator.php";
include "head.php";
$id = abs((int)$_SERVER['QUERY_STRING']);
if(!empty($id)){
$act = true;
}else{
$act = false;
}
switch($act){
default:
echo "<div class='title'>Категории</div>";
$sql = mysql_query("SELECT * FROM `cat_category` ORDER BY `position`");
$i = 1;
while($row = mysql_fetch_assoc($sql)){
$int = $i/ 2;
if(is_integer($int)){
$div = '<div class="cat">';
}else{
$div = '<div class="cat2">';
}
echo $div;
$sqlq = mysql_query("SELECT `category` FROM `cat_users` WHERE `category` = '".$row['id']."' AND `status` != 'mod' AND `in` > 0");
$users = mysql_num_rows($sqlq);
echo "<img src='images/site.gif' alt='loading...'><a href='index.php?".$row['id']."'>".$row['name']."</a>[".$users."]<br/>";
echo "»<span class='site'>".$row['about']."</span><br/>";
$i++;
echo "</div>";
}
break;
case 'list':
$q=mysql_query(" SELECT count(*) FROM `cat_users`");
$all=mysql_result($q,0,0);
$pnumber=10;
$n=new Navigator($all,$pnumber);
$q=mysql_query("SELECT * FROM `cat_users` LIMIT {$n->start()},$pnumber ");
$sql = mysql_query("SELECT * FROM `cat_users` WHERE `category` = '".$id."' AND `in` > 0 AND `status` != 'mod' ORDER BY `in` DESC");
$kat = mysql_query("SELECT * FROM `cat_category` WHERE `id` = '".$id."'");
$katr = mysql_fetch_assoc($kat);
echo "<div class='title'>Категория - ".$katr['name']."</div>";
if(mysql_num_rows($sql) > 0){
$i = 1;
while($row = mysql_fetch_assoc($sql)){
$int = $i/ 2;
if(is_integer($int)){
$div = '<div class="cat">';
}else{
$div = '<div class="cat2">';
}
echo $div;
echo $i.".<a href='out.php?".$row['id']."'>".$row['name']."</a> <a href='stat.php?".$row['id']."'>[?]</a><br/>";
echo "<div class='dote'>На сайт:".$row['out']."<br/>";
echo "В каталог:".$row['in']."</div>";
echo "»<span class='site'>".$row['about']."</span><br/>";
if($sys_komsites != 1){
$komsites = mysql_query("SELECT * FROM `cat_komsites` WHERE `id_site` = '".$row['id']."'");
$komsites = mysql_num_rows($komsites);
echo "»<a href = 'kom_sites.php?".$row['id']."'>Комментарии</a>[".$komsites."]<br/>";
}
echo "</div>";
$i++;
}
}else{
echo "Сайтов в этой категории нет<br/>";
}
echo $n->navi();
break;
}
include "foot.php";
?>