Файл: group_forum/new_t.php
Строк: 93
<?
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($user)){
$set['title']='Внимание!';
include_once '../sys/inc/thead.php';
title();
echo'<div class="func">Извините, эта функция доступна только зарегистрированным пользователям. <a href="/registration/">Регистрация</a> быстрая и бесплатная.</div><br />';
include_once '../sys/inc/tfoot.php';
exit();
}
$group=mysql_fetch_assoc(mysql_query("SELECT * FROM `group` where `id` = '".intval($_GET['id'])."' LIMIT 1"));
if(mysql_result(mysql_query("SELECT COUNT(`id`) FROM `group` WHERE `id` = '$group[id]'"), 0)==NULL){
include_once '../sys/inc/thead.php';
msg('Такой Группы нет');
include_once '../sys/inc/tfoot.php';
exit;
}
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `group` WHERE `id` = '$group[id]' AND `read` = '0'"), 0)==0 && mysql_result(mysql_query("SELECT COUNT(*) FROM `group_user` WHERE `id_group` = '$group[id]' AND `id_user` = '$user[id]' AND`act` = '1'"), 0)==0 && mysql_result(mysql_query("SELECT COUNT(*) FROM `group` WHERE `id` = '$group[id]' AND `admin` = ''"), 0)==0){
include_once '../sys/inc/thead.php';
echo "
<div class='alert alert-error' align='center'>
Читать могут только участники!
<br/>
<a href='/group/group?id=".$group['id']."&in' class='btn btn-danger'>Вступить</a>
<a href='".htmlspecialchars($_SERVER['HTTP_REFERER'])."' class='btn'>Назад</a>
</div>
";
include_once '../sys/inc/tfoot.php';
exit;
}
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `group_ban` WHERE `id_group` = '$group[id]' AND `id_user` = '$user[id]' AND `time` > '".time()."'"), 0)==1){
include_once '../sys/inc/thead.php';
$ban=mysql_fetch_assoc(mysql_query("SELECT * FROM `group_ban` where `id_user` = '".$user['id']."' LIMIT 1"));
echo 'Вы забанены до '.vremja($ban['time']).' <br />Причина '.output_text($ban['opis']).'<br />';
include_once '../sys/inc/tfoot.php';
exit;
}
$set['title']='Форум - новые темы';
include_once '../sys/inc/thead.php';
title();
echo "<div class="headering">$urlik / <a href="/group">Группы</a> / <a href="/group/group?id=".$group[id]."">".output_text($group['name'])."</a> / <a href="/group_forum/$group[id]/">Форум</a> / Новые темы </div>";
aut(); // форма авторизации
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `group_forum_t` WHERE `id_group`='$group[id]'"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
$q=mysql_query("SELECT * FROM `group_forum_t` WHERE `id_group`='$group[id]' ORDER BY `time_create` DESC LIMIT $start, $set[p_str]");
if (mysql_num_rows($q)==0) {
echo "<div class="line">n";
echo "Нет темn";
echo "</div>n";
}
while ($them = mysql_fetch_assoc($q))
{
$razdel=mysql_fetch_assoc(mysql_query("SELECT * FROM `group_forum_r` WHERE `id` = '$them[id_razdel]' LIMIT 1"));
$ank=mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = $them[id_user] LIMIT 1"));
echo "<div class="line">n";
echo "<img src='/forum/i/them_$them[up]$them[close].png' alt='' />";
echo " <a href='/group_forum/$group[id]/$razdel[id]/$them[id]/'>".output_text($them['name'])."</a> <a href='/group_forum/$group[id]/$razdel[id]/$them[id]/?page=end'>(".mysql_result(mysql_query("SELECT COUNT(*) FROM `group_forum_p` WHERE `id_group` = '$group[id]' AND `id_them` = '$them[id]'"),0).")</a>n";
echo "</div>n";
}
if ($k_page>1)str("/group_forum/$group[id]/?",$k_page,$page); // Вывод страниц
include_once '../sys/inc/tfoot.php';
?>