Просмотр файла catalogdeep/index.php

<?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 "&#187;<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 "&#187;<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 "&#187;<a href = 'kom_sites.php?".$row['id']."'>Комментарии</a>[".$komsites."]<br/>";
			}
			echo "</div>";
			$i++;
			
			}
		}else{
			echo "Сайтов в этой категории нет<br/>";
		}
     
    
    echo $n->navi(); 
 
	
	break;
}
 
 
 
 
 
 
include "foot.php";
 
?>