Файл: wcat/index.php
Строк: 62
<?php
include_once '../sys/inc/start.php';
include_once '../sys/inc/compress.php';
include_once '../sys/inc/sess.php';
include_once '../sys/inc/home.php';
include_once '../sys/inc/settings.php';
include_once '../sys/inc/db_connect.php';
include_once '../sys/inc/ipua.php';
include_once '../sys/inc/fnc.php';
include_once '../sys/inc/user.php';
$set['title']='Белый каталог сайтов';
include_once '../sys/inc/thead.php';
title();
err();
aut();
$on_page = 10;
if(isset($_GET['kat'])and !empty($_GET['kat']) and preg_match('/[0-9]/i',$_GET['kat']))
{
$kat=intval($_GET['kat']);
if(!empty($_GET['page'])) {$page = intval($_GET['page']);}
else {$page = 1;}
if(mysql_num_rows(mysql_query("SELECT id_kat FROM `kat` WHERE `id_kat` LIKE '$kat'")) == 0)
{
echo 'Такой категории нет<div class="foot"><a href="/wcat/">Назад</a></div>';
}
else
{
$p = $on_page*$page-$on_page;
$sites = mysql_num_rows(mysql_query("SELECT id_site FROM `sites` WHERE id_kat = '$kat' ORDER BY `id_site` DESC"));
$str = ceil($sites/$on_page);
$r = mysql_query("SELECT name,id_site FROM `sites` WHERE id_kat = '$kat' ORDER BY `id_site` DESC LIMIT $p,$on_page");
while($myrow = mysql_fetch_array($r))
{
echo '<div class="foot"><img src="/wcat/site.png" alt="»"></img> <a href="site.php?id='.$myrow['id_site'].'">'.$myrow['name'].'</a></div>';
}
if($sites==0) echo '<div class="foot">Сайтов пока нет</div><div class="foot"><a href="/wcat/"> Назад</a></div>';
}
if($page>1)echo '»<a href="index.php?kat='.$kat.'&page='.($page-1).'">Назад</a><br />';
if($page<$str)echo '»<a href="index.php?kat='.$kat.'&page='.($page+1).'">Вперед</a><br />';
if($page>1)echo '';
}
else
{
$res = mysql_query('SELECT * FROM `kat` ');
echo '';
while($myrow = mysql_fetch_array($res))
{
$count = mysql_num_rows(mysql_query("SELECT id_site FROM `sites` WHERE id_kat LIKE '$myrow[id_kat]' "));
echo '<div class="foot">
<img src="/wcat/dir.png" alt="»"></img> <a href="index.php?kat='.$myrow['id_kat'].'">'.$myrow['name'].'</a> ('.$count.')
</div>';
}
$all_sites = mysql_result(mysql_query('SELECT COUNT(*) FROM `sites` '),0);
echo '<div class="foot"><b>Всего на нашем движке </b> '.$all_sites.' сайтов</div>';
if($all_sites>0) {
$last_site = mysql_fetch_array(mysql_query('SELECT id_site,name FROM `sites` ORDER BY `id_site` DESC LIMIT 0,1 '));
echo '<div class="foot">Последний сайт :<br /> <a href="site.php?id='.$last_site['id_site'].'">'.$last_site['name'].'</a></div>';
}
echo '<div class="foot"><img src="/style/img/plus.gif" alt="»"> <a href="reg.php">Добавить сайт</a></div>';
}
include_once '../sys/inc/tfoot.php';
?>