View file ä󿪫¬/modules/groups/group.php

<?php

foreach (array('start', 'compress', 'sess', 'settings', 'db_connect', 'ipua', 'fnc', 'user') as $inc) {
    require_once "../../sys/inc/$inc.php";
}

only_reg('/reg.php');



$soo = $pdo->query("SELECT * FROM `soo` WHERE `id` = '". intval($_GET['id']) ."' LIMIT 1")->fetch(PDO::FETCH_ASSOC);



if (!isset($soo['id']))
{
	header('Location: index.php');
	exit;
}


  $set['title']=$soo['name']; // заголовок страницы
include_once '../../sys/inc/thead.php';

$soo = $pdo->query("SELECT * FROM `soo` WHERE `id` = '". intval($_GET['id']) ."' LIMIT 1")->fetch(PDO::FETCH_ASSOC);

if(isset($user) && $pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' LIMIT 1"),0)->fetchColumn() && $user['id']!=$soo['admid'])
{
}else{    
    
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '". intval($_GET['id']) ."' LIMIT 1"),0)->fetch(PDO::FETCH_ASSOC);

if($pdo->query(("SELECT COUNT(*) FROM `soo_bl` WHERE `id_soo` = '". intval($_GET['id']) ."' AND `id_user` = '$user[id]' LIMIT 1"),0)->fetchColumn())
{
if(isset($_GET['enter']))
{    
echo '<div class="err">Вы находитесь в черном списке данной группы и не можете в нее вступить</div>';
}
    
}
else
{
    
    
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '". intval($_GET['id']) ."' LIMIT 1"),0)->fetch(PDO::FETCH_ASSOC);
    
if(isset($_GET['enter']) && $soo['konf_soo']==0 || isset($_GET['enter']) && $soo['konf_soo']==1)
{
$pdo->query("INSERT INTO `soo_users` (`id_soo`, `id_user`, `time`) values ('$soo[id]', '$user[id]', '$time')");
$pdo->query("UPDATE `soo` SET `users` = '".($soo['users']+1)."' WHERE `id` = '$soo[id]' LIMIT 1");

$dlist = $pdo->query("SELECT * FROM `dlist` WHERE `id_user` = '".$user['id']."' LIMIT 1")->fetch(PDO::FETCH_ASSOC);

if (isset($user) && $pdo->query(("SELECT COUNT(*) FROM `dlist` WHERE `id_user` = '$user[id]' AND `soo` = '3'"), 0)->fetchColumn()==0)
{
$pdo->query("UPDATE `dlist` SET `soo` = '" . ($dlist['soo'] + 1) . "' WHERE `id_user` = '".intval($user['id'])."' LIMIT 1");
} 

if (isset($user) && $pdo->query(("SELECT COUNT(*) FROM `dlist` WHERE `id_user` = '$user[id]' AND `soo` = '3' AND `soo_ok` = '0'"), 0)->fetchColumn())
{
$pdo->query("UPDATE `user` SET `activity` = '" . ($user['activity'] + $dlist['soo_v']) . "' WHERE `id` = '".$user['id']."' LIMIT 1");
$pdo->query("UPDATE `dlist` SET `soo_ok` = '1' WHERE `id_user` = '".intval($user['id'])."' LIMIT 1");
$pdo->query("INSERT INTO `jurnal_balls` (`time`, `msg`, `id_user`, `balls`, `id_post`, `type`, `type_post`) values('$time', 'Выполнение достижения', '".intval($user['id'])."', '".intval($dlist['soo_v'])."', '".intval($id_file)."', 'plus', 'games')");
}


$_SESSION['message'] = 'Вы успешно вступили в группу';
header('location: ?id='.$soo['id'].'');
}

$soo = $pdo->query("SELECT * FROM `soo` WHERE `id` = '". intval($_GET['id']) ."' LIMIT 1")->fetch(PDO::FETCH_ASSOC);

if(isset($_GET['enter']) && $soo['konf_soo']==2)
{
if($user['activity']>=$soo['plata'])
{
$pdo->query("INSERT INTO `soo_users` (`id_soo`, `id_user`, `time`) values ('$soo[id]', '$user[id]', '$time')");
$pdo->query("UPDATE `soo` SET `users` = '".($soo['users']+1)."' WHERE `id` = '$soo[id]' LIMIT 1");

$admid=get_user($soo['admid']);
$pdo->query("INSERT INTO `mail` (`id_user`, `id_kont`, `msg`, `time`) values('2', '$soo[admid]', 'На Ваш счет зачислено [b][blue]$soo[plata][/blue] баллов[/b] за вступление пользователя $user[nick] в Вашу группу [url=/modules/groups/group.php?id=$soo[id]]$soo[name80][/url]', '$time')");

$pdo->query("UPDATE `user` SET `activity` = '".($admid['activity']+$soo['plata'])."' WHERE `id` = '$soo[admid]' LIMIT 1");
$pdo->query("UPDATE `user` SET `activity` = '".($user['activity']-$soo['plata'])."' WHERE `id` = '$user[id]' LIMIT 1");
msg('Вы успешно вступили в группу');
}
else
{
$err[]='У вас не хватает баллов для вступления в группу';
}
}

$soo = $pdo->query("SELECT * FROM `soo` WHERE `id` = '". intval($_GET['id']) ."' LIMIT 1")->fetch(PDO::FETCH_ASSOC);


if(isset($_GET['enter']) && $soo['konf_soo']==3)
{
$pdo->query("INSERT INTO `soo_users` (`id_soo`, `id_user`, `activate`, `time`) values ('$soo[id]', '$user[id]', '1', '$time')");
$pdo->query("INSERT INTO `mail` (`id_user`, `id_kont`, `msg`, `time`) values('2', '$soo[admid]', '$user[nick] хочет вступить в Вашу группу [url=/modules/groups/admin.php?id=$soo[id]&users]$soo[name80][/url]', '$time')");

msg('Заявка на вступление отправлена создателю группы');
}    
    
    
    
    
    
    
}
}

$soo = $pdo->query("SELECT * FROM `soo` WHERE `id` = '". intval($_GET['id']) ."' LIMIT 1")->fetch(PDO::FETCH_ASSOC);


if(isset($user) && $pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' AND `invit`='1' LIMIT 1"),0)->fetchColumn()==1)
{
if(isset($_GET['yes']))
{
$pdo->query("UPDATE `soo_users` SET `invit`='0', `time`='$time' WHERE `id_user`='$user[id]' AND `id_soo`='$soo[id]' LIMIT 1");
$pdo->query("UPDATE `soo` SET `users` = '".($soo['users']+1)."' WHERE `id` = '$soo[id]' LIMIT 1");
msg('Приглашение принято');
}
elseif(isset($_GET['no']))
{
$pdo->query("DELETE FROM `soo_users` WHERE `id_user`='$user[id]' AND `id_soo`='$soo[id]' LIMIT 1");
msg('Приглашение отклонено');
}
}

$soo = $pdo->query("SELECT * FROM `soo` WHERE `id` = '". intval($_GET['id']) ."' LIMIT 1")->fetch(PDO::FETCH_ASSOC);


if(isset($user) && isset($_GET['exit']) && $pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' AND `invit`='0' AND `activate`='0' LIMIT 1"),0)->fetchColumn()==1)
{
$pdo->query("DELETE FROM `soo_users` WHERE `id_user` = '$user[id]' AND `id_soo`='$soo[id]' LIMIT 1");
$pdo->query("UPDATE `soo` SET `users` = '".($soo['users']-1)."' WHERE `id` = '$soo[id]' LIMIT 1");
msg('Вы успешно покинули группу');
    
}


err();




$soo = $pdo->query("SELECT * FROM `soo` WHERE `id` = '". intval($_GET['id']) ."' LIMIT 1")->fetch(PDO::FETCH_ASSOC);
$count_chat = $pdo->query(("SELECT COUNT(*) FROM `soo_chat` WHERE `id_soo` = '$soo[id]'"),0)->fetchColumn();
$conf = $pdo->query(("SELECT COUNT(*) FROM `soo_obmen_files` WHERE `time` > '".(time()-86400)."' AND `id_soo` = '$soo[id]'"), 0)->fetchColumn();
$count_votes_open = $pdo->query(("SELECT COUNT(*) FROM `soo_votes` WHERE `id_soo` = '$soo[id]' AND `time_close`>'$time'"),0)->fetchColumn();
$count_votes_all = $pdo->query(("SELECT COUNT(*) FROM `soo_votes` WHERE `id_soo` = '$soo[id]'"),0)->fetchColumn();
$count_users = $soo['users']+1;
$count_banned = $pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `activate`='0' AND `invit`='0' AND `ban`>'$time'"),0)->fetchColumn();
$count_forum_t = $pdo->query(("SELECT COUNT(*) FROM `soo_forum_thems` WHERE `id_soo` = '$soo[id]'"),0)->fetchColumn();
$count_file = $pdo->query(("SELECT COUNT(*) FROM `soo_files` WHERE `id_soo` = '$soo[id]'"),0)->fetchColumn();














$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='tooltip' data-placement='right' title='" . lang('На главную') . "'><i class='fa fa-home fa-lg'></i></a> <i class='fa fa-angle-right fa-fw'></i> <a href='/modules/groups/'>";
echo lang('Группы');
echo "</a> <i class='fa fa-angle-right fa-fw'></i> ".$soo['name80']."</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='/modules/groups/group.php?id=".$soo['id']."'><font color=#587C94><b>МЕНЮ</b></font></a></td>
<td class='fn-righti'><a style='display: block;padding: 10px;' href='inform.php?id=".$soo['id']."'><b><font color=#587C94>ИНФОРМАЦИЯ</font></b></a></td></tr></table>";



?>
<link rel="stylesheet" type="text/css" href="/ajax/profileCover/styleMobile.css">

<style>

.st_1	{ 	
margin-left: 20px;
margin-bottom:0;
border-style:solid;
border-color:transparent  transparent #C5D8E6  transparent ;
border-width:0px 0px 10px 10px;	
height: 0px; 
width:0px;
	} 
	

.list-fn {
background-color: #F3F3F3;  
padding: 5px;
border-top: 1px #E4E4E4 solid;
}


.fn-left {
display: inline-block;
border: 1px solid #BFCBD5; 
background: #FFF; 
padding: 0px; 
text-align: center;
border-radius: 10px 0px 0px 10px;
width: 33%;
}
.fn-left:hover {
background: #BFCBD5; 
} 

.fn-center {
display: inline-block;    
width: 33%;    
border-top: 1px solid #BFCBD5;
border-bottom: 1px solid #BFCBD5;
background: #FFF; 
padding: 0px; 
text-align: center;
}
.fn-center:hover {
background: #BFCBD5; 
}

.fn-right {
display: inline-block;    
width: 33%;    
border: 1px solid #BFCBD5;
background: #FFF; 
padding: 0px; 
text-align: center;
border-radius: 0px 10px 10px 0px;
}
.fn-right:hover {
background: #BFCBD5; 
}

.fn-menus {
border-radius: 4px;
padding: 5px;
text-align: center;
border: 1px solid green;
margin: 3px;
}

.menu-f {
background: #FAFBFC;
padding: 8px;
margin-top: 9px;
text-align: center;
border: 1px solid #B7C1C5;
}
.menu-fi {
background: #FAFBFC;
padding: 8px;
text-align: center;
border-bottom: 1px solid #B7C1C5;
border-left: 1px solid #B7C1C5;
border-right: 1px solid #B7C1C5;
}
.menu-fi:hover{
background: #D5DFE4;
}
.menu-f:hover{
background: #D5DFE4;
}
	
.profileCoverWrapper {
	width: 100%;
	height: 255px;
	overflow: hidden;
	position: relative;
} 	
	

</style>

<?

echo '<div class="profileCoverWrapper">';



if (is_file(H."/modules/groups/fon/".$soo['id'].".jpg")){
echo '<img style="width: 100%; height: 250px;" src="fon/'.$soo['id'].'.jpg" alt="" class="profileCoverImage" />';
}else{
echo '<img style="width: 100%; height: 250px;" src="fon/soo.jpg" alt="" class="profileCoverImage" />';
}








echo '<span style="position: relative; top: 25px; left: 25px;">';
if (is_file(H."/modules/groups/logo/$soo[id].gif"))
echo '<img src="logo/'.$soo['id'].'.gif" style="display: inline-block;width: 80px;height: 80px;text-align: center;border-radius: 100%;background-color: #fff; margin-bottom: 0px; border: 2px white solid;" alt=""/>';
elseif (is_file(H."/modules/groups/logo/$soo[id].jpg"))
echo '<img src="logo/'.$soo['id'].'.jpg" style="display: inline-block;width: 80px;height: 80px;text-align: center;border-radius: 100%;background-color: #fff; margin-bottom: 0px; border: 2px white solid;" alt=""/>';
elseif (is_file(H."/modules/groups/logo/$soo[id].png"))
echo '<img src="logo/'.$soo['id'].'.png" style="display: inline-block;width: 80px;height: 80px;text-align: center;border-radius: 100%;background-color: #fff; margin-bottom: 0px; border: 2px white solid;" alt=""/>';
else
echo '<img src="/modules/groups/logo/no.png" style="display: inline-block;width: 80px;height: 80px;text-align: center;border-radius: 100%;background-color: #fff; margin-bottom: 0px; border: 2px white solid;"  alt=""/>';
echo "</span>";


?>
<style>
.info_user_b {
color: white;    
background: rgba(0,0,0,0.5);
padding: 28px;

}
</style><?

echo '<div class="info_user_b" style="position: relative; top: 45px;">';
echo '<span style="position: relative; bottom: 5px;">';
echo '<font size=+1><b>'.$soo['name80'].'</b></font></span><br>';
echo "<span style='position: relative; top: 5px;'><i class='fa fa-user'></i> $count_users";
echo "</span></div>";
echo "</div>";





echo '<div class="st_1"></div>';

echo '<div style="border: 1px #C5D8E6 solid; border-radius: 3px; background-color: #E1EDF5; padding: 10px;">';
echo ''.output_text($soo['desc']).'';
echo "</div>";
echo "</div>";

if($user['id']==$soo['admid']){
echo "<a style='color: #64849E;' href='admin.php?id=".$soo['id']."'><div style='background: #DAE2E9; padding: 10px;'><center><i class='fa fa-gear'></i> <b>УПРАВЛЕНИЕ</b> </center></div></a>";
}


if ($pdo->query("SELECT COUNT(*) FROM `soo_users` WHERE `id_user` = '$user[id]' AND `id_soo`='$soo[id]' AND `invit`='1' LIMIT 1")->fetchColumn()){
echo "<div style='background: white; padding: 4px;'><table style='width: 100%; text-align: center;'><tr>";  

echo "<b>У Вас имеется приглашение</b>";

echo "<td class='fn-left' style='width: 48%;'><a href='?id=".$soo['id']."&yes' style='display: block; padding: 10px;'><b>ПРИНЯТЬ</b></a></td>";
echo "<td class='fn-right' style='width: 48%;'><a style='display: block; padding: 10px;' href='?id=".$soo['id']."&no'><b><font color='red'>ОТКЛОНИТЬ</font></b></a></td>";
echo "</tr></table></div>";
}else{

echo "<div style='background: white; padding: 4px;'><table style='width: 100%; text-align: center;'><tr>";  

if($soo['konf_soo']==2 && $user['activity']>=$soo['plata'])
{
if($pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' AND `invit`='0' AND `activate`='0' LIMIT 1"),0)->fetchColumn()==1 || $user['id']==$soo['admid'])
{    
if(isset($user) && ($user['id']==$soo['admid'] || $pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' AND `mod`='1' LIMIT 1"),0)->fetchColumn()==1))
{
echo "<td class='fn-left' style='width: 48%;'><a class='collapsed' data-toggle='collapse' data-parent='#accordion' style='display: block; padding: 10px;' href='#err'><b><font color=green>ПОКИНУТЬ</font></b></a></td>";

?><div id="err" class="panel-collapse collapse" role="tabpanel" aria-labelledby="err"><br><div class="err">Вы не можете покинуть группу, так как являетесь членом администрации</div><br></div>
<?    
}else{
    
echo "<td class='fn-left' style='width: 48%;'><a style='display: block; padding: 10px;' href='group.php?id=".$soo['id']."&exit'><b><font color=green>ПОКИНУТЬ</font></b></a></td>";
    
} 
}else{
    
echo "<td class='fn-left' style='width: 48%;'><a class='collapsed' data-toggle='collapse' data-parent='#accordion' style='display: block; padding: 10px;' href='#balls'><b>ВСТУПИТЬ</b></a></td>";

?><div id="balls" class="panel-collapse collapse" role="tabpanel" aria-labelledby="balls"><br><div class="mess">Создатель группы требует с Вас 

<?echo "<b><font color=blue>$soo[plata]</font> баллов</b> за вступление. Вы принимаете условия?<br><br>";

echo "<a class='btn btn-primary btn-sm' href='group.php?id=".$soo['id']."&enter'>Да, принимаю</a> "; 
echo "<a class='btn btn-secondary btn-sm collapsed' data-toggle='collapse' data-parent='#accordion' href='#balls'>Отмена</a>";?>

</div><br></div>
<?  
    
    
}

    
    
    
    
    
    
    
    
    
    
    
}else{
if($pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' AND `invit`='0' AND `activate`='0' LIMIT 1"),0)->fetchColumn()==1 || $user['id']==$soo['admid'])
{

if(isset($user) && ($user['id']==$soo['admid'] || $pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' AND `mod`='1' LIMIT 1"),0)->fetchColumn()==1))
{
echo "<td class='fn-left' style='width: 48%;'><a class='collapsed' data-toggle='collapse' data-parent='#accordion' style='display: block; padding: 10px;' href='#err'><b><font color=green>ПОКИНУТЬ</font></b></a></td>";

?><div id="err" class="panel-collapse collapse" role="tabpanel" aria-labelledby="err"><br><div class="err">Вы не можете покинуть группу, так как являетесь членом администрации</div><br></div>
<?    
}else{
echo "<td class='fn-left' style='width: 48%;'><a style='display: block; padding: 10px;' href='group.php?id=".$soo['id']."&exit'><b><font color=green>ПОКИНУТЬ</font></b></a></td>";
}
    
}else{   
echo "<td class='fn-left' style='width: 48%;'><a style='display: block; padding: 10px;' href='group.php?id=".$soo['id']."&enter'><b>ВСТУПИТЬ</b></a></td>";
}}   

if($soo['konf_soo']==0 || $soo['konf_soo']==1 || $soo['konf_soo']==3)
{   
echo "<td class='fn-right' style='width: 48%;'><a style='display: block; padding: 10px;' href='users.php?id=".$soo['id']."&invite'><b>ПРИГЛАСИТЬ</b></a></td>";
}else{
echo "<td class='fn-right' style='width: 48%;'><a style='display: block; padding: 10px;' href='users.php?id=".$soo['id']."&invite'><b>ПРИГЛАСИТЬ</b></a></td>";
}









echo '</tr></table></div>';

}
?>
<style>
.count_p {
background-color: #849BAD;
padding: 1px 3px 1px 3px;
border-radius: 3px;
}

.link_p {
background-color: #B8D1E6;
padding: 13px;
border-top: 1px #B7CCDD solid;
border-left: 1px #B7CCDD solid;
border-right: 1px #B7CCDD solid;
}

.link_p:hover{
background: #A4C1D8;
}


.icons_s {
width: 17px;
}

.menu_user {
background-color: white;  
padding: 11px;
border-top: 1px #DCE3E9 solid;

}

.menu_user:hover {
background-color: #EEF4F8;  
}


.menu_user_file {
background-color: #F6FBFF;  
padding: 11px;
border-top: 1px #D9E1E7 solid;
}
.menu_user_file:hover {
    background-color: #DDEDFA;     
}


.menu_user_info {
background-color: #F4F5F5;  
padding: 11px;

}
    
.menu_user_info2 {
background-color: #F4F5F5;  
padding: 11px;
border-top: 1px #D9E1E7 solid;
} 

.menu_user_info2:hover {
    background-color: #E2E4E6;     
}

.menu_user_info:hover {
    background-color: #E2E4E6;     
    }

    
</style>
<? 
if($pdo->query(("SELECT COUNT(*) FROM `soo_bl` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' LIMIT 1"),0)->fetchColumn()!=0)
{
}else{  
////////////Новости/////////////
include 'news/include.php';
}
$count_news = $pdo->query(("SELECT COUNT(*) FROM `soo_news` WHERE `id_soo` = '$soo[id]'"),0)->fetchColumn();

echo "<a style='color: #64849E;' href='news/news.php?id=".$soo['id']."'><div class='menu_user'><span class='icons_s'><font color=white><i class='fa fa-book'></i></font></span> Блог <span class='badge' style='float:right;'>$count_news</span></div></a>";
echo "<a style='color: #64849E;' href='file/index.php?id=".$soo['id']."'><div class='menu_user'><span class='icons_s'><font color=white><i class='fa fa-file'></i></font></span> Файлы <span class='badge' style='float:right;'>$count_file</span></div></a>";
echo "<a style='color: #64849E;' href='forum/index.php?id=".$soo['id']."'><div class='menu_user'><span class='icons_s'><font color=white><i class='fa fa-comments'></i></font></span> Форум <span class='badge' style='float:right;'>$count_forum_t</span></div></a>";
echo "<a style='color: #64849E;' href='/modules/groups/chat/index.php?id=".$soo['id']."'><div class='menu_user' style='border-bottom: 1px #D9E1E7 solid;'><span class='icons_s'><font color=white><i class='fa fa-comment'></i></font></span> Чат <span class='badge' style='float:right;'>$count_chat</span></div></a>";

if($pdo->query(("SELECT COUNT(*) FROM `soo_bl` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' LIMIT 1"),0)->fetchColumn()!=0)
{
}else{

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)
{

}else{  
  

echo "<div style='padding:7px; background-color: #FAFDFF;'>
<a href='/modules/groups/forum/index.php?id=".$soo['id']."'><div class='link_p'>
<font color=#6E8394><b>ТЕМЫ ФОРУМА <span class='count_p' style=' color: #D0DFEB;'>
$count_forum_t</span> <span style='float: right;'><i class='fa fa-comments fa-lg'></i></span></font></b></div></a>";
 

$k_post=$pdo->query(("SELECT COUNT(*) FROM `soo_forum_thems` WHERE `id_soo`='$soo[id]'"),0)->fetchColumn();
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];

$q = $pdo->query("SELECT * FROM `soo_forum_thems` WHERE `id_soo`='$soo[id]' ORDER BY `time` DESC LIMIT 3");
if ($q->fetchColumn()==0) {

$doc->NoResult();
}

while ($them = $q->fetch(PDO::FETCH_ASSOC))
{


$forum=$pdo->query(("SELECT * FROM `soo_forums` WHERE `id` = '$them[id_forum]' AND `id_soo`='". intval($_GET['id']) ."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$ank=$pdo->query(("SELECT * FROM `user` WHERE `id` = $them[id_user] LIMIT 1"))->fetch(PDO::FETCH_ASSOC);


 
  
$post1=$pdo->query(("SELECT * FROM `soo_forum_mess` WHERE `id_them` = '$them[id]' AND `id_forum` = '$forum[id]' AND `id_soo`='". intval($_GET['id']) ."' ORDER BY `time` ASC LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$ank=$pdo->query(("SELECT * FROM `user` WHERE `id` = '$post1[id_user]' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);


echo '<div class="list-group-item">';


echo "<font color=black><i class='fa fa-comments fa-fw'></i></font> <a href='/modules/groups/forum/index.php?id=". intval($_GET['id']) ."&id_forum=$forum[id]&id_them=$them[id]'><b>$them[name]</b></a> <span style='float:right;'><small><font color=gray>(".date::timek($them['time_create']).")</small></font></span><br>\n";  
  
  
echo "  </div>\n";

}
echo "</div>\n";
}
} 
echo "<a style='color: #64849E;' href='users.php?id=".$soo['id']."'><div class='menu_user'><span class='icons_s'><font color=white><i class='fa fa-users'></i></font></span> Участники <span class='badge' style='float:right;'>$count_users</span></div></a>";
echo "<a style='color: #64849E;' href='banned.php?id=".$soo['id']."'><div class='menu_user'><span class='icons_s'><font color=white><i class='fa fa-ban'></i></font></span> Нарушители <span class='badge' style='float:right;'>$count_banned</span></div></a>";
 

  

include_once '../../sys/inc/tfoot.php';

?>