Файл: vsime.com/comm/inc/act_forum.php
Строк: 79
<?
if (mysqli_num_rows(mysqli_query($dbi, "SELECT * FROM `comm` WHERE `id` = '".intval($_GET['id'])."'"))!=0) {
$comm=mysqli_query($dbi, "SELECT * FROM `comm` WHERE `id` = '".intval($_GET['id'])."'");
$comm=mysqli_fetch_array($comm);
$cat=mysqli_query($dbi, "SELECT * FROM `comm_cat` WHERE `id` = '$comm[id_cat]'");
$cat=mysqli_fetch_array($cat);
if (mysqli_num_rows(mysqli_query($dbi, "SELECT * FROM `comm_users` WHERE `id_comm` = '$comm[id]' AND `activate` = '1' AND `invite` = '0'"))==0)$comm['id_user']=0;
$ank=profile($comm['id_user']); // sozdak
if ($ank['id']==$user['id'] && isset($user) || $uinc['access']=='adm')$skp = NULL; else $skp = " `sk` = '0' AND";
if (mysqli_num_rows(mysqli_query($dbi, "SELECT * FROM `comm_blist` WHERE `id_comm` = '$comm[id]' AND `id_user` = '$user[id]'"))!=0) {
$navigation = "<a href='?act=comm&id=$comm[id]'>".hsc($comm['name'])."</a> > <a href='?act=forum&id=$comm[id]'>Форум</a>";
$title .= ' - '.hsc($comm['name']).' - Форум'; // Заголовок страницы
ex_head();
show_errors("Вы находитесь в Черном списке сообщества");
echo "<div class='foot'>n";
echo image_back()." <a href='?act=comm&id=$comm[id]'>В сообщество</a>n";
echo "</div>n";
ex_foot();
}
if ($comm['forum']==0) {
$navigation = "<a href='?act=comm&id=$comm[id]'>".hsc($comm['name'])."</a> > <a href='?act=forum&id=$comm[id]'>Форум</a>";
$title .= ' - '.hsc($comm['name']).' - Форум'; // Заголовок страницы
ex_head();
echo "<div class='main'>n";
echo "Форум сообщества <b>".hsc($comm['name'])."</b> закрытn";
echo "</div>n";
echo "<div class='foot'>n";
echo image_back()." <a href='?act=comm&id=$comm[id]'>В сообщество</a>n";
echo "</div>n";
ex_foot();
}
if ($comm['read_rule']==2 && !in_comm($user['id'])) {
$navigation = "<a href='?act=comm&id=$comm[id]'>".hsc($comm['name'])."</a> > <a href='?act=forum&id=$comm[id]'>Форум</a>";
$title .= ' - '.hsc($comm['name']).' - Форум'; // Заголовок страницы
ex_head();
echo "<div class='main'>n";
echo "Это форум сообщества <b>".hsc($comm['name']).".</b><br />n";
echo "Форум доступен только участникам данного сообщества.<br />n";
echo "<a href='/comm/?act=comm&id=$comm[id]&in&mdp=$mdp'>Вступить в сообщество</a>n";
echo "</div>n";
echo "<div class='foot'>n";
echo image_back()." <a href='?act=comm&id=$comm[id]'>В сообщество</a>n";
echo "</div>n";
ex_foot();
}
if (isset($_GET['topic_show']))
{
if (mysqli_num_rows(mysqli_query($dbi, "SELECT * FROM `forum` WHERE `id` = '".intval($_GET['topic_show'])."' AND `type` = 'topic' AND `id_comm` = '$comm[id]'"))!=0)
{
$topic = mysqli_query($dbi, "SELECT * FROM `forum` WHERE `id` = '".intval($_GET['topic_show'])."' AND `type` = 'topic' AND `id_comm` = '$comm[id]'");
$topic = mysqli_fetch_array($topic);
$fcat = mysqli_query($dbi, "SELECT * FROM `forum` WHERE `id` = '$topic[id_cat]' AND `type` = 'cat' AND `id_comm` = '$comm[id]'");
$fcat = mysqli_fetch_array($fcat);
$creator=profile($topic['id_user']);
$count_komm=mysqli_num_rows(mysqli_query($dbi, "SELECT * FROM `forum_komm` WHERE$skp `id_comm` = '$comm[id]' AND `id_topic` = '$topic[id]'"));
if ($count_komm > 0)
{
$last_komm = mysqli_fetch_array(mysqli_query($dbi, "SELECT * FROM `forum_komm` WHERE$skp `id_comm` = '$comm[id]' AND `id_topic` = '$topic[id]' ORDER BY `time` DESC LIMIT 1"));
$creator_last_komm = profile($last_komm['id_user']);
}
$navigation = "<a href='?act=comm&id=$comm[id]'>".hsc($comm['name'])."</a> > <a href='?act=forum&id=$comm[id]'>Форум</a> > <a href='?act=forum&id=$comm[id]&cat_show=$fcat[id]'>".hsc($fcat['name'])."</a>";
$title .= ' - '.hsc($comm['name']).' - Форум'; // Заголовок страницы
ex_head();
include('inc_forum/include_topic.php');
}
}
if (isset($_GET['cat_show']))
{
if(mysqli_num_rows(mysqli_query($dbi, "SELECT * FROM `forum` WHERE `id` = '".intval($_GET['cat_show'])."' AND `type` = 'cat' AND `id_comm` = '$comm[id]'"))!=0)
{
$fcat=mysqli_query($dbi, "SELECT * FROM `forum` WHERE `id` = '".intval($_GET['cat_show'])."' AND `type` = 'cat' AND `id_comm` = '$comm[id]'");
$fcat=mysqli_fetch_array($fcat);
$navigation = "<a href='?act=comm&id=$comm[id]'>".hsc($comm['name'])."</a> > <a href='?act=forum&id=$comm[id]'>Форум</a> > <a href='?act=forum&id=$comm[id]&cat_show=$fcat[id]'>".hsc($fcat['name'])."</a>";
$title .= ' - '.hsc($comm['name']).' - Форум'; // Заголовок страницы
ex_head();
include('inc_forum/include_cat.php');
}
}
$navigation = "<a href='?act=comm&id=$comm[id]'>".hsc($comm['name'])."</a> > <a href='?act=forum&id=$comm[id]'>Форум</a>";
$title .= ' - '.hsc($comm['name']).' - Форум'; // Заголовок страницы
ex_head();
include('inc_forum/include_index.php');
}
else{locon("/comm");exit;}
?>