File size: 5.43Kb
<?
/*
* Author - Tw1nGo
* VK - https://vk.com/tw1ngo93
*/
if (isset($_GET['id'])){
$group = mysql_fetch_assoc(mysql_query("SELECT * FROM `groups` WHERE `id` = '".abs(intval($_GET['id']))."' LIMIT 1"));
$us_group1 = mysql_fetch_assoc(mysql_query("SELECT * FROM `groups_users` WHERE `id_group` = '".$group['id']."' AND `st` = '0' LIMIT 1"));
$us_ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = '".$us_group1['id_user']."' LIMIT 1"));
$count['friends'] = mysql_result(mysql_query("SELECT COUNT(*)
FROM frends AS f
LEFT JOIN groups_users AS u ON f.frend = u.id_user
WHERE f.user = '$user[id]' AND f.i = '1' AND u.id_group = '$group[id]' AND u.st = '0'"), 0);
}
if (!isset($_GET['id']) || !isset($group) || $group['id'] <= 0){
header("Location: /groups");
exit;
}
if ($group['typic'] == 0){
$text_privat = 'Группа';
}else if ($group['typic'] == 1){
$text_privat = 'Закрытая группа';
}else if ($group['typic'] == 2){
$text_privat = 'Частная группа';
}
$set['title'] = 'Участники группы '.text($group['title']).'';
include_once H.'sys/inc/thead.php';
// Конфигурационный файл
require 'config.php';
shapka_VK(true, '/group'.$group['id'].'', ''.$text_privat.'');
$cases = array('участник', 'участника', 'участников');
$cases_fr = array('друг', 'друга', 'друзей');
$set['p_str'] = '20';
# Друзья в группе
if (isset($user) && isset($_GET['tab']) && $_GET['tab'] == 'friends'){
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM frends AS f
LEFT JOIN groups_users AS u ON f.frend = u.id_user
WHERE f.user = '$user[id]' AND f.i = '1' AND u.id_group = '$group[id]' AND u.st = '0'"), 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 u.*, ru.nick, ru.date_last FROM frends AS f
LEFT JOIN groups_users AS u ON f.frend = u.id_user
JOIN user AS ru ON ru.id = u.id_user
WHERE f.user = '$user[id]' AND f.i = '1' AND u.id_group = '$group[id]' AND u.st = '0'
ORDER BY u.id DESC
LIMIT $start, $set[p_str]");
?>
<div class="pcont">
<div class="head_panel"><div class="hp_block tabs_block">
<ul class="tabs_list">
<li><a class="tab_item _thide al_tab" href="?act=members">Участники</a></li>
<li><a class="tab_item tab_item_cur _thide al_tab" href="?act=members&tab=friends">Друзья <em class="tab_counter"><?= $count['friends']?></em></a></li>
</ul>
</div></div>
<div class="upanel bl_cont">
<?
if ($k_post == 0){
?>
<div class="service_msg_box">
<div class="service_msg service_msg_null">Друзей в группе пока нет.</div>
</div>
<?
}
else{
?>
<h4 class="slim_header"><?= des2num($k_post, $cases_fr)?></h4>
<?
while ($post = mysql_fetch_assoc($q)){
$post['nick'] = u_nick($post['id_user']);
?>
<a href="/id<?= $post['id_user']?>" class="inline_item al_u<?= $post_ank['id']?>">
<div class="ii_body">
<?= avka50($post['id_user'], 'ii_img')?><span class="ii_owner _u<?= $post['id_user']?>"><?= $post['nick']?></span> <?= on_($post['id_user'])?>
</div>
</a>
<?
}
if ($k_post && $k_page > 1)
str_vk("?act=members&tab=friends&",$k_page,$page);
}
?>
</div>
</div>
<?
}
else{
// Просто юзеры группы
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `groups_users` WHERE `id_group` = '".$group['id']."' AND `st` = '0'"), 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 `groups_users` WHERE `id_group` = '".$group['id']."' AND `st` = '0' ORDER BY `time` DESC LIMIT $start, $set[p_str]");
?>
<div class="pcont">
<div class="head_panel"><div class="hp_block tabs_block">
<ul class="tabs_list">
<li><a class="tab_item tab_item_cur _thide al_tab" href="?act=members">Участники</a></li>
<?
if($count['friends'] > 0){
?>
<li><a class="tab_item _thide al_tab" href="?act=members&tab=friends">Друзья <em class="tab_counter"><?= $count['friends']?></em></a></li>
<?
}
?>
</ul>
</div></div>
<div class="upanel bl_cont">
<?
if ($k_post == 0){
?>
<div class="service_msg_box">
<div class="service_msg service_msg_null">Участников в группе пока нет.</div>
</div>
<?
}
else{
if (isset($user) && ($user['id'] == $group['id_user'] || $user['level'] >= 4)){
?>
<a class="link_header" href="?act=users">
<h4 class="slim_header clearfix"><span class="slim_header_label"><?= des2num($k_post, $cases)?></span><span class="slim_header_rl">ред.</span></h4>
</a>
<?
}
else{
?>
<h4 class="slim_header"><?= des2num($k_post, $cases)?></h4>
<?
}
while ($post = mysql_fetch_array($q)){
$post_ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = '".$post['id_user']."' LIMIT 1"));
$post_ank['nick'] = u_nick($post_ank['id']);
?>
<a href="/id<?= $post_ank['id']?>" class="inline_item al_u<?= $post_ank['id']?>">
<div class="ii_body">
<?= avka50($post_ank['id'], 'ii_img')?><span class="ii_owner _u<?= $post_ank['id']?>"><?= $post_ank['nick']?></span> <?= on_($post_ank['id'])?>
</div>
</a>
<?
}
if ($k_post && $k_page > 1)
str_vk("?act=members&",$k_page,$page);
}
?>
</div>
</div>
<?
}
?>