View file xmyx.ru/club/act/index.php

<?

/*
 * Author - Tw1nGo
 * VK - https://vk.com/tw1ngo93
*/

if (isset($_GET['id']))
{
    $ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = '".abs(intval($_GET['id']))."' LIMIT 1"));
    $ank['nick'] = u_nick($ank['id']);
}
if (!isset($_GET['id']) || !isset($ank) || $ank['id'] <= 0)
{
    if (isset($user)){
        $ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = '".$user['id']."' LIMIT 1"));
    } 
    else {
        header("Location: /groups");
        exit;
    }
}

if (isset($_GET['id'])){

$set['title'] = 'Группы '.$ank['nick'].'';
include_once H.'sys/inc/thead.php';

// Конфигурационный файл
require 'config.php';

shapka_VK(true, '/id'.$ank['id'].'', 'Группы '.$ank['nick'].'');

?>
<div class="pcont">
<div class="upanel">
<div id="gr_search_items" class="items bl_cont">
<?

$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `groups_users` WHERE `id_user` = '".$ank['id']."'"), 0);
$k_page = k_page($k_post,$set['p_str']);
$page = page($k_page);
$start = $set['p_str']*$page-$set['p_str'];

if ($k_post == 0){
?>
<div class="service_msg_box"><div class="service_msg service_msg_null">Не найдено ни одной группы.</div></div>
<?
} 
else{


$q = mysql_query("SELECT * FROM `groups_users` WHERE `id_user` = '".$ank['id']."' ORDER BY `time` DESC LIMIT $start, $set[p_str]");

while ($post = mysql_fetch_array($q))
{
        $post = mysql_fetch_assoc(mysql_query("SELECT * FROM `groups` WHERE `id` = '".$post['id_group']."' LIMIT 1"));
        $us_c = mysql_result(mysql_query("SELECT COUNT(*) FROM `groups_users` WHERE `id_group` = '".$post['id']."' AND `st` = '0'"), 0);
        $cases = array('участник', 'участника', 'участников');

	$post_title = text($post['title']);
	
?>
<a href="/group<?= $post['id']?>" class="simple_fit_item search_item al_g<?= $post['id']?>">
<img src="<?= Tw1nGo::Ava($post['id'])?>" class="si_img _g<?= $post['id']?>">
<div class="si_body">
<span class="si_owner _g<?= $post['id']?>" style="padding-right: 0;"><?= $post_title?></span>
<?
if ($post['ofical'] == 1){
?>
<b class="verified"></b>
<?
}
if ($post['typic'] == 0){
?>
<div class="si_slabel">Открытая группа</div>
<?
}else if ($post['typic'] == 1){
?>
<div class="si_slabel">Закрытая группа</div>
<?
}else if ($post['typic'] == 2){
?>
<div class="si_slabel">Частная группа</div>
<?
}
?>
<div class="si_slabel"><?= des2num($us_c, $cases)?></div>
</div>
</a>
<?
}


  

}
?>
</div></div>
<?
if ($k_page > 1)str_vk("?id=".$ank['id']."",$k_page,$page);
?>
</div>
<?
}
else{
$set['title'] = 'Группы';
include_once H.'sys/inc/thead.php';

// Конфигурационный файл
require 'config.php';

shapka_VK(false, '', 'Группы');

$priglashenie = mysql_result(mysql_query("SELECT COUNT(*) FROM `groups_users` WHERE `id_user` = '".$user['id']."' AND `st` = '2'"), 0);


?>
<div class="pcont">
<?

if(!isset($_GET['tab'])){

if (isset($user)){
?>
<div class="head_panel">
<div class="hp_block tabs_block">
<ul class="tabs_list">    
<li><a class="tab_item tab_item_cur al_tab" href="/groups">Группы</a></li> 
<?
if($priglashenie > 0){
?>
<li><a class="tab_item al_tab" href="?tab=inv">Приглашения <em class="tab_counter"><?= $priglashenie?></em></a></li>
<?
}
?>   
<li><a class="tab_item al_tab" href="?tab=admin">Управление</a></li>
</ul>
</div>
<?
}

$config = array(
	'q' => array(
		'type' => array(
			'Не найдено ни одной группы.',
			'Не найдено ни одной группы.'
			),
		'text' => (isset($_GET['q']) ? implode(' ', explode('+', text($_GET['q']))) : false)
	),
);
if($_SERVER['REQUEST_METHOD'] == 'POST')
{
	if(!empty($_POST['q']) && !preg_match("#(^\ )#ui", $_POST['q']) && !preg_match("#(^\')#ui", $_POST['q']))
	{
		$_POST['q'] = implode('+', explode(' ', my_esc($_POST['q'])));
		header('Location: ?q='.$_POST['q'].'');
	}
	else
		header('Location: /groups');
}

$sql = '';
if($config['q']['text'])
	$sql = " WHERE `title` like '%".$config['q']['text']."%'";

?>
<div class="hp_block">
<form action="/groups" class="qsearch" method="POST" onsubmit="return cur.gr_search.go(event);">
  <table class="row_table"><tbody><tr>
    <td class="row_table_main_column">
      <div class="qs_field_wrap">  
        <div class="iwrap"><input class="textfield qs_textfield" name="q" value="<?= $config['q']['text'] ?>" autocomplete="off" id="gr_search_field" placeholder="Введите название группы.." type="text"></div>
      </div>
    </td>
    <td class="row_table_last_column"><input class="button qs_button al_tab" value="Искать" id="gr_search_btn" onclick="return cur.gr_search.go(event);" type="submit"></td>
  </tr></tbody></table>
</form></div>
</div>
<div class="upanel">
<div id="gr_search_items" class="items bl_cont">
<?


$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `groups`$sql"), 0);

if ($k_post == 0){
?>
<div class="service_msg_box"><div class="service_msg service_msg_null">Не найдено ни одной группы.</div></div>
<?
} 
else{

$set['p_str'] = '10';    
$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`$sql ORDER BY `count` DESC LIMIT $start, $set[p_str]");

while ($post = mysql_fetch_array($q))
{
        $us_c = mysql_result(mysql_query("SELECT COUNT(*) FROM `groups_users` WHERE `id_group` = '".$post['id']."' AND `st` = '0'"), 0);
        $cases = array('участник', 'участника', 'участников');
	if($config['q']['text'] !== false) {
		$post_title = preg_replace('/' . $config['q']['text'] . '/i', '<em class="found">$0</em>', text($post['title']));
	}
	else
	$post_title = text($post['title']);
	
?>
<a href="/group<?= $post['id']?>" class="simple_fit_item search_item al_g<?= $post['id']?>">
<img src="<?= Tw1nGo::Ava($post['id'])?>" class="si_img _g<?= $post['id']?>">
<div class="si_body">
<span class="si_owner _g<?= $post['id']?>" style="padding-right: 0;"><?= $post_title?></span>
<?
if ($post['ofical'] == 1){
?>
<b class="verified"></b>
<?
}
if ($post['typic'] == 0){
?>
<div class="si_slabel">Открытая группа</div>
<?
}else if ($post['typic'] == 1){
?>
<div class="si_slabel">Закрытая группа</div>
<?
}else if ($post['typic'] == 2){
?>
<div class="si_slabel">Частная группа</div>
<?
}
?>
<div class="si_slabel"><?= des2num($us_c, $cases)?></div>
</div>
</a>
<?
}

if ($k_page > 1)str_vk("?",$k_page,$page);
    
}

}
elseif (isset($_GET['tab']) && $_GET['tab'] == 'admin'){

if (isset($user)){
?>
<div class="head_panel">
<div class="hp_block tabs_block">
<ul class="tabs_list">    
<li><a class="tab_item al_tab" href="/groups">Группы</a></li>   
<?
if($priglashenie > 0){
?>
<li><a class="tab_item al_tab" href="?tab=inv">Приглашения <em class="tab_counter"><?= $priglashenie?></em></a></li>
<?
}
?> 
<li><a class="tab_item tab_item_cur al_tab" href="?tab=admin">Управление</a></li>
</ul>
</div>
<?
}

$config = array(
	'q' => array(
		'type' => array(
			'Не найдено ни одной группы.',
			'Не найдено ни одной группы.'
			),
		'text' => (isset($_GET['q']) ? implode(' ', explode('+', text($_GET['q']))) : false)
	),
);
if($_SERVER['REQUEST_METHOD'] == 'POST')
{
	if(!empty($_POST['q']) && !preg_match("#(^\ )#ui", $_POST['q']) && !preg_match("#(^\')#ui", $_POST['q']))
	{
		$_POST['q'] = implode('+', explode(' ', my_esc($_POST['q'])));
		header('Location: ?tab=admin&q='.$_POST['q'].'');
	}
	else
		header('Location: ?tab=admin');
}

$sql = '';
if($config['q']['text'])
	$sql = "`title` like '%".$config['q']['text']."%' AND ";

?>
<div class="hp_block">
<form action="?tab=admin" class="qsearch" method="POST" onsubmit="return cur.gr_search.go(event);">
  <table class="row_table"><tbody><tr>
    <td class="row_table_main_column">
      <div class="qs_field_wrap">  
        <div class="iwrap"><input class="textfield qs_textfield" name="q" value="<?= $config['q']['text'] ?>" autocomplete="off" id="gr_search_field" placeholder="Введите название группы.." type="text"></div>
      </div>
    </td>
    <td class="row_table_last_column"><input class="button qs_button al_tab" value="Искать" id="gr_search_btn" onclick="return cur.gr_search.go(event);" type="submit"></td>
  </tr></tbody></table>
</form></div>
</div>
<div class="upanel">
<div id="gr_search_items" class="items bl_cont">
<?

$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `groups` WHERE $sql`id_user` = '".$user['id']."'"), 0);

if ($k_post == 0){
?>
<div class="service_msg_box"><div class="service_msg service_msg_null">Не найдено ни одной группы.</div></div>
<?
} 
else{

$set['p_str'] = '10';    
$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` WHERE $sql`id_user` = '".$user['id']."' ORDER BY `time` DESC LIMIT $start, $set[p_str]");

while ($post = mysql_fetch_array($q))
{
        $us_c = mysql_result(mysql_query("SELECT COUNT(*) FROM `groups_users` WHERE `id_group` = '".$post['id']."' AND `st` = '0'"), 0);
        $cases = array('участник', 'участника', 'участников');
	if($config['q']['text'] !== false) {
		$post_title = preg_replace('/' . $config['q']['text'] . '/i', '<em class="found">$0</em>', text($post['title']));
	}
	else
	$post_title = text($post['title']);
	
?>
<a href="/group<?= $post['id']?>" class="simple_fit_item search_item al_g<?= $post['id']?>">
<img src="<?= Tw1nGo::Ava($post['id'])?>" class="si_img _g<?= $post['id']?>">
<div class="si_body">
<span class="si_owner _g<?= $post['id']?>" style="padding-right: 0;"><?= $post_title?></span>
<?
if ($post['ofical'] == 1){
?>
<b class="verified"></b>
<?
}
if ($post['typic'] == 0){
?>
<div class="si_slabel">Открытая группа</div>
<?
}else if ($post['typic'] == 1){
?>
<div class="si_slabel">Закрытая группа</div>
<?
}else if ($post['typic'] == 2){
?>
<div class="si_slabel">Частная группа</div>
<?
}
?>
<div class="si_slabel"><?= des2num($us_c, $cases)?></div>
</div>
</a>
<?
}

if ($k_page > 1)str_vk("?tab=admin&amp;",$k_page,$page);
    
}
?>
<a class="inline_item inline_item_blank" href="/groups?act=new">
  <div class="ii_body">
    <div class="ii_owner">Создать группу</div>
  </div>
</a>
<?
}
elseif (isset($_GET['tab']) && $_GET['tab'] == 'inv'){


if (isset($user)){
?>
<div class="head_panel">
<div class="hp_block tabs_block">
<ul class="tabs_list">    
<li><a class="tab_item al_tab" href="/groups">Группы</a></li>   
<li><a class="tab_item tab_item_cur al_tab" href="?tab=inv">Приглашения <em class="tab_counter"><?= $priglashenie?></em></a></li> 
<li><a class="tab_item al_tab" href="?tab=admin">Управление</a></li>
</ul>
</div>
</div>
<?
}

?>
<div class="upanel">
<div id="gr_search_items" class="items bl_cont">
<?

$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `groups_users` WHERE `id_user` = '".$user['id']."' AND `st` = '2'"), 0);

if ($k_post == 0){
?>
<div class="service_msg_box"><div class="service_msg service_msg_null">Не найдено ни одного приглашения.</div></div>
<?
} 
else{


if (isset($_GET['enter']) && $_GET['enter'] != NULL && is_numeric($_GET['enter']) && $_GET['enter'] > 0 && mysql_result(mysql_query("SELECT COUNT(*) FROM `groups_users` WHERE `id_group` = '".abs(intval($_GET['enter']))."' AND `id_user` = '".$user['id']."' AND `st` = '2'"), 0) > 0)
{
	mysql_query("UPDATE `groups_users` SET `st` = '0' WHERE `id_group` = '".abs(intval($_GET['enter']))."' AND `id_user` = '".$user['id']."' AND `st` = '2' LIMIT 1");
        header("Location: ?tab=inv");
        exit;
}
elseif (isset($_GET['leave']) && $_GET['leave'] != NULL && is_numeric($_GET['leave']) && $_GET['leave'] > 0 && mysql_result(mysql_query("SELECT COUNT(*) FROM `groups_users` WHERE `id_group` = '".abs(intval($_GET['leave']))."' AND `id_user` = '".$user['id']."' AND `st` = '2'"), 0) > 0)
{
	mysql_query("DELETE FROM `groups_users` WHERE `id_group` = '".abs(intval($_GET['leave']))."' AND `id_user` = '".$user['id']."' LIMIT 1");
        header("Location: ?tab=inv");
        exit;
}

$set['p_str'] = '10';    
$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_user` = '".$user['id']."' AND `st` = '2' ORDER BY `time` DESC LIMIT $start, $set[p_str]");

while ($post = mysql_fetch_array($q))
{
        $post = mysql_fetch_assoc(mysql_query("SELECT * FROM `groups` WHERE `id` = '".$post['id_group']."' LIMIT 1"));
        $who = mysql_fetch_assoc(mysql_query("SELECT `id_user` FROM `groups_invite` WHERE `id_group` = '".$post['id']."' LIMIT 1"));
	$who = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = '".$who['id_user']."' LIMIT 1"));
        $us_c = mysql_result(mysql_query("SELECT COUNT(*) FROM `groups_users` WHERE `id_group` = '".$post['id']."' AND `st` = '0'"), 0);
        $cases = array('участник', 'участника', 'участников');
	$who['nick'] = u_nick($who['id']);
	
?>
<div class="simple_fit_item">
  <a class="al_g<?= $post['id']?>" href="/group<?= $post['id']?>">
  <img src="<?= Tw1nGo::Ava($post['id'])?>" class="si_img _g<?= $post['id']?>"></a>
  <div class="si_body">
    <a class="si_owner al_g<?= $post['id']?> _g<?= $post['id']?>" href="/group<?= $post['id']?>">
    <?= text($post['title'])?>
    <?
if ($post['ofical'] == 1){
?>
<b class="verified"></b>
<?
}    
    ?>
    </a>
    
    <div class="si_slabel"><?= des2num($us_c, $cases)?></div>
    <div class="si_label">Вас приглашает <a class="user al_u<?= $who['id']?> _u<?= $who['id']?>" href="/id<?= $who['id']?>"><?= $who['nick']?></a>.</div>
    <div class="si_links">
      <a class="si_link" href="?tab=inv&enter=<?= $post['id']?>">Вступить в группу</a> - 
      <a class="si_link" href="?tab=inv&leave=<?= $post['id']?>">Отклонить приглашение</a>
    </div>
  </div>
</div>
<?
}

if ($k_page > 1)str_vk("?tab=inv&amp;",$k_page,$page);
    
}

}



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