File size: 12.37Kb
<?
foreach (array('start', 'compress', 'sess', 'settings', 'db_connect', 'ipua', 'fnc', 'user') as $inc) {
require_once "../../../sys/inc/$inc.php";
}
only_reg('/reg.php');
$num=1;
if (isset($_GET['id']) && $pdo->query(("SELECT COUNT(*) FROM `soo` WHERE `id` = '".intval($_GET['id'])."'"),0)->fetchColumn()==1
&& isset($_GET['id_forum']) && $pdo->query(("SELECT COUNT(*) FROM `soo_forums` WHERE `id` = '".intval($_GET['id_forum'])."' AND `id_soo` = '".intval($_GET['id'])."'"),0)->fetchColumn()==1
&& isset($_GET['id_them']) && $pdo->query(("SELECT COUNT(*) FROM `soo_forum_thems` WHERE `id` = '".intval($_GET['id_them'])."' AND `id_forum` = '".intval($_GET['id_forum'])."' AND `id_soo` = '".intval($_GET['id'])."'"),0)->fetchColumn()==1
&& isset($_GET['id_post']) && $pdo->query(("SELECT COUNT(*) FROM `soo_forum_mess` WHERE `id` = '".intval($_GET['id_post'])."' AND `id_them` = '".intval($_GET['id_them'])."' AND `id_forum` = '".intval($_GET['id_forum'])."' AND `id_soo` = '".intval($_GET['id'])."'"),0)->fetchColumn()==1
)
{
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$forum = $pdo->query(("SELECT * FROM `soo_forums` WHERE `id` = '".intval($_GET['id_forum'])."' AND `id_soo` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$them = $pdo->query(("SELECT * FROM `soo_forum_thems` WHERE `id` = '".intval($_GET['id_them'])."' AND `id_forum` = '".intval($_GET['id_forum'])."' AND `id_soo` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$post = $pdo->query(("SELECT * FROM `soo_forum_mess` WHERE `id_them` = '".intval($_GET['id_them'])."' AND `id_forum` = '".intval($_GET['id_forum'])."' AND `id_soo` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$post2 = $pdo->query(("SELECT * FROM `soo_forum_mess` WHERE `id_them` = '".intval($_GET['id_them'])."' AND `id_forum` = '".intval($_GET['id_forum'])."' AND `id_soo` = '".intval($_GET['id'])."' ORDER BY `id` DESC LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$ank=get_user($post['id_user']);
}
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
if($pdo->query(("SELECT COUNT(*) FROM `soo_bl` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' LIMIT 1"),0)->fetchColumn()!=0)
{
$set['title']='Новая запись'; // заголовок страницы
include_once '../../../sys/inc/thead.php';
echo '<div class="list-group-item">';
echo '<div class="err">Вы добавлены в черный список группы и не можете просмотреть данный объект</div>';
echo '</div>';
}else{
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
include_once '../../../modules/groups/inc/ban.php';
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
if($soo['private_forum']==0){
$newsadd = null;
}elseif($soo['private_forum']==1){
$newsadd = $pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' LIMIT 1"),0)->fetchColumn()==0 && $user['id']!=$soo['admid'];
}
if($soo['private_forum']==$soo['private_forum'] && $newsadd)
{
$set['title']='Ошибка'; // заголовок страницы
include_once '../../../sys/inc/thead.php';
echo '<div class="list-group-item"><div class="err">Форум доступен только для участников группы</div></div>';
}else{
if (isset($_GET['id']) && $pdo->query(("SELECT COUNT(*) FROM `soo` WHERE `id` = '".intval($_GET['id'])."'"),0)->fetchColumn()==1
&& isset($_GET['id_forum']) && $pdo->query(("SELECT COUNT(*) FROM `soo_forums` WHERE `id` = '".intval($_GET['id_forum'])."' AND `id_soo` = '".intval($_GET['id'])."'"),0)->fetchColumn()==1
&& isset($_GET['id_them']) && $pdo->query(("SELECT COUNT(*) FROM `soo_forum_thems` WHERE `id` = '".intval($_GET['id_them'])."' AND `id_forum` = '".intval($_GET['id_forum'])."' AND `id_soo` = '".intval($_GET['id'])."'"),0)->fetchColumn()==1 )
{
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$forum = $pdo->query(("SELECT * FROM `soo_forums` WHERE `id` = '".intval($_GET['id_forum'])."' AND `id_soo` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$them = $pdo->query(("SELECT * FROM `soo_forum_thems` WHERE `id` = '".intval($_GET['id_them'])."' AND `id_forum` = '".intval($_GET['id_forum'])."' AND `id_soo` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$set['title']='Форум - '.$them['name']; // заголовок страницы
include_once '../../../sys/inc/thead.php';
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$forum = $pdo->query(("SELECT * FROM `soo_forums` WHERE `id` = '".intval($_GET['id_forum'])."' AND `id_soo` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$them = $pdo->query(("SELECT * FROM `soo_forum_thems` WHERE `id` = '".intval($_GET['id_them'])."' AND `id_forum` = '".intval($_GET['id_forum'])."' AND `id_soo` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
#Навигация
echo "<div class='card-header'>";
echo "<a href='/' data-toggle='tooltipecho' data-placement='right' title='" . lang('На главную') . "'><i class='fa fa-home fa-lg'></i></a> <i class='fa fa-angle-right fa-fw'></i> ";
echo "<a href='/modules/groups/group.php?id=$soo[id]'>$soo[name]</a> <i class='fa fa-angle-right fa-fw'></i> <a href='/modules/groups/forum/index.php?id=$soo[id]'>Форум</a> <i class='fa fa-angle-right fa-fw'></i> <a href='/modules/groups/forum/index.php?id=$soo[id]&id_forum=$forum[id]'>$forum[name]</a> <i class='fa fa-angle-right fa-fw'></i> тема";
echo "</div>";
$ank2=get_user($them['id_user']);
include 'set_them_act.php';
include 'them.php';
include_once '../../../sys/inc/tfoot.php';
exit();
}
if (isset($_GET['id']) && $pdo->query(("SELECT COUNT(*) FROM `soo` WHERE `id` = '".intval($_GET['id'])."'"),0)->fetchColumn()==1
&& isset($_GET['id_forum']) && $pdo->query(("SELECT COUNT(*) FROM `soo_forums` WHERE `id` = '".intval($_GET['id_forum'])."' AND `id_soo` = '".intval($_GET['id'])."'"),0)->fetchColumn()==1)
{
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$forum = $pdo->query(("SELECT * FROM `soo_forums` WHERE `id` = '".intval($_GET['id_forum'])."' AND `id_soo` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$set['title']='Форум - '.$forum['name']; // заголовок страницы
include_once '../../../sys/inc/thead.php';
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
#Навигация
echo "<div class='card-header'>";
echo "<a href='/' data-toggle='tooltipecho' data-placement='right' title='" . lang('На главную') . "'><i class='fa fa-home fa-lg'></i></a> <i class='fa fa-angle-right fa-fw'></i> ";
echo "<a href='/modules/groups/group.php?id=$soo[id]'>$soo[name]</a> <i class='fa fa-angle-right fa-fw'></i> <a href='/modules/groups/forum/index.php?id=$soo[id]'>Форум</a> <i class='fa fa-angle-right fa-fw'></i> $forum[name]";
echo "</div>";
if($soo['private_forumadd']==0){
$newsadd = $pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' LIMIT 1"),0)->fetchColumn()==0 && $user['id']!=$soo['admid'];
}elseif($soo['private_forumadd']==1){
$newsadd = $pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' AND `mod` = '1' LIMIT 1"),0)->fetchColumn()==0 && $user['id']!=$soo['admid'];
}elseif($soo['private_forumadd']==2){
$newsadd = $pdo->query(("SELECT COUNT(*) FROM `soo` WHERE `id` = '$soo[id]' AND `admid` = '$user[id]' LIMIT 1"),0)->fetchColumn()==0 && $user['id']!=$soo['admid'];
}
if($soo['private_forumadd']==$soo['private_forumadd'] && $newsadd)
{
}else{
include 'set_razdel_act.php';
echo "<div class='list-group-item'>";
echo "<a class='btn btn-primary btn-sm' href=\"add_them.php?id=$soo[id]&id_forum=$forum[id]\"><i class='fa fa-plus fa-fw'></i> Создать тему</a>";
$mod = $pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' AND `mod` = '1' LIMIT 1"),0)->fetchColumn();
if(isset($user) && $user['id']==$soo['admid'] || $mod)
{
echo " <a class='btn btn-secondary btn-sm' href='?id=$soo[id]&id_forum=$forum[id]&act=del'><i class='fa fa-trash fa-fw'></i> Удалить раздел</a>\n";
echo " <a class='btn btn-secondary btn-sm' href='?id=$soo[id]&id_forum=$forum[id]&act=set'><i class='fa fa-gear fa-fw'></i> Параметры</a>\n";
}
echo "</div>";
include 'set_razdel_form.php';}
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
if($soo['private_forum']==0){
$newsadd = null;
}elseif($soo['private_forum']==1){
$newsadd = $pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' LIMIT 1"),0)->fetchColumn()==0 && $user['id']!=$soo['admid'] && $mod;
}
if($soo['private_forum']==$soo['private_forum'] && $newsadd)
{}else{
include 'razdel.php';
}
include_once '../../../sys/inc/tfoot.php';
}
else
{
//////////////////////////////////////////////////////
if (isset($_GET['id']) && $pdo->query(("SELECT COUNT(*) FROM `soo` WHERE `id` = '".intval($_GET['id'])."'"),0)->fetchColumn()==1)
{
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$set['title']='Форум группы'; // заголовок страницы
include_once '../../../sys/inc/thead.php';
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
err();
#Навигация
echo "<div class='card-header'>";
echo "<a href='/' data-toggle='tooltipecho' data-placement='right' title='" . lang('На главную') . "'><i class='fa fa-home fa-lg'></i></a> <i class='fa fa-angle-right fa-fw'></i> ";
echo "<a href='/modules/groups/group.php?id=$soo[id]'>$soo[name]</a> <i class='fa fa-angle-right fa-fw'></i> Форум";
echo "</div>";
echo "<div style='padding: 4px; background-color: white;'>";
echo "<table style='width: 100%; text-align: center;'><tr>
<td class='fn-lefti-o'><a style='display: block;padding: 10px;' href='index.php?id=$soo[id]'><font color=#587C94><b>ВСЕ</b></font></a></td>
<td class='fn-righti'><a style='display: block;padding: 10px;' href='new_t.php?id=$soo[id]'><b><font color=#587C94>НОВЫЕ ТЕМЫ</font></b></a></td>
</tr></table></div>";
$mod = $pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' AND `mod` = '1' LIMIT 1"),0)->fetchColumn();
if(isset($user) && $user['id']==$soo['admid'] || $mod)
{
echo "<div class='list-group-item'>";
echo "<a class='btn btn-primary btn-sm' href=\"add_dir.php?id=$soo[id]\"><i class='fa fa-plus fa-fw'></i> Создать раздел</a>";
echo "</div>";
}
$k_post=$pdo->query(("SELECT COUNT(*) FROM `soo_forums` WHERE `id_soo`='$soo[id]'"),0)->fetchColumn();
if ($k_post==0){
$doc->NoResult();
}
$q = $pdo->query("SELECT * FROM `soo_forums` WHERE `id_soo`='$soo[id]' ORDER BY `id` ASC");
while ($forum = $q->fetch(PDO::FETCH_ASSOC))
{
echo "<div class='list-group-item'>";
$forumt = $pdo->query(("SELECT COUNT(*) FROM `soo_forum_thems` WHERE `id_forum` = '$forum[id]' AND `id_soo`='$soo[id]'"),0)->fetchColumn();
echo "<a href='?id=$soo[id]&id_forum=$forum[id]'><i class='fa fa-comments fa-fw'></i> $forum[name] <span class='badge'>$forumt</span></a>\n";
if ($forum['desc']!=NULL){
echo "<br/><font color='gray'>";
echo output_text($forum['desc'])."</font><br />\n";
}
echo " </div>\n";
}
}
elseif(!isset($_GET['id']) || isset($_GET['id']) && $pdo->query(("SELECT COUNT(*) FROM `soo` WHERE `id` = '".intval($_GET['id'])."'"),0)->fetchColumn()==0)
{
$set['title']='Ошибка 404'; // заголовок страницы
include_once '../../../sys/inc/thead.php';
err404();
}
}
}
}
include_once '../../../sys/inc/tfoot.php';
?>