Файл: razd/anekdots/kat.php
Строк: 64
<?
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';
if(isset($_GET['dir']) && mysql_result(mysql_query("SELECT COUNT(*) FROM `anek_dir` WHERE `id` = '".intval($_GET['dir'])."'"),0))
{
$dir=mysql_fetch_array(mysql_query("select * from `anek_dir` where `id`='".intval($_GET['dir'])."';"));
$set['title']="Анекдоты/$dir[name]"; // заголовок страницы
include_once '../../sys/inc/thead.php';
title();
err();
echo "<table class='post'>n";
if (user_access('adm_mysql'))echo "<td class='p_t'><a href='upload.php?dir=$dir[id]'>Добавить анекдот</a></td>n";
$set['p_str']=15;
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `anek_list` WHERE `id_dir` = '$dir[id]'"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
if($k_post==0)
{
echo " <tr>n";
echo " <td class='p_t'>n";
echo "Пусто :(<br />";
echo " </td>n";
echo " </tr>n";
}
$res = mysql_query("select * from `anek_list` WHERE `id_dir` = '$dir[id]' ORDER by `id` DESC LIMIT $start, $set[p_str];");
while ($post = mysql_fetch_array($res)){
echo " <tr>n";
echo "<td class='p_m' colspan='2'>n";
echo output_text($post['msg'])."<br />n";
echo "<a href='komm.php?id=$post[id]'>Комментарии</a> (".mysql_result(mysql_query("SELECT COUNT(*) FROM `anek_komm` WHERE `id_anek` = '$post[id]'"),0).")";
if (user_access('adm_mysql'))echo "<span style='float : right;'>[<a href='admin.php?act=dels&id=$post[id]'>Дел</a>]</span>";
echo " </td>n";
echo " </tr>n";
}
echo"</table>";
if ($k_page>1)str("?dir=$dir[id]&",$k_page,$page);
echo "<div class='foot'><a href='/razd/anekdots/'>Анекдоты</a>/$dir[name]</div>";
}
include_once '../../sys/inc/tfoot.php';
?>