View file xmyx.ru/user/us_frend.php

<?
include_once '../sys/inc/start.php';
include_once '../sys/inc/compress.php';
include_once '../sys/inc/sess.php';
include_once '../sys/inc/home.php';
include_once '../sys/inc/settings.php';
include_once '../sys/inc/db_connect.php';
include_once '../sys/inc/ipua.php';
include_once '../sys/inc/fnc.php';
include_once '../sys/inc/user.php';

if (isset($_GET['id']))$sid = intval($_GET['id']);
else $sid = $user['id'];
$ank = get_user($sid);

if (!$ank || $ank['id'] == 0)
          header('Location: /?');
          
$ank['nick'] = u_nick($ank['id']);


if (isset($user) && isset($_GET['act']) && $_GET['act'] == 'notify')
{

if (isset($_GET['accept'])){
	
	$add = intval($_GET['accept']);
	$anks = get_user($add);  
	$anks['nick'] = u_nick($anks['id']); 

if (mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `id` = '$add' LIMIT 1"),0)==0){
	$_SESSION['err'] = "Ошибка доступа! Попробуйте еще раз!";  
	header("Location: /");
	exit;
}  

$a = mysql_result(mysql_query("SELECT COUNT(*) FROM `frends_new` WHERE `user` = '$add' AND `to` = '$user[id]'"),0);  
$as = mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '".$add."' LIMIT 1"));  
	
if ($a == 0)  {  
		die("Ошибка! Попробуйте еще раз!");  
}  
else{	      
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `frends_new` WHERE (`user` = '$user[id]' AND `to` = '$add') OR (`user` = '$add' AND `to` = '$user[id]')"),0)==1){  

// Уведомления о друзьях
mysql_query("INSERT INTO `notifi` (`avtor`, `id_user`, `id_object`, `type`, `time`) VALUES ('$user[id]', '$add', '$user[id]', 'friend_ok', '$time')");


mysql_query("INSERT INTO `frends` (`user`, `frend`, `time`, `i`) values('$user[id]', '$add', '$time', '1')");  
mysql_query("INSERT INTO `frends` (`user`, `frend`, `time`, `i`) values('$add', '$user[id]', '$time', '1')");  
mysql_query("DELETE FROM `frends_new` WHERE `user` = '$add' AND `to` = '$user[id]' LIMIT 1");  
mysql_query("DELETE FROM `frends_new` WHERE `user` = '$user[id]' AND `to` = '$add' LIMIT 1");  
mysql_query("OPTIMIZE TABLE `frends`");  
mysql_query("OPTIMIZE TABLE `frends_new`");  
}		  

	$_SESSION['message'] = "".$anks['nick']." добавлен".($anks['pol'] == 1 ? '' : 'а')." в друзья.";  
	header("Location: ?".SID);  
	exit;  
}  

}  

if (isset($_GET['hide_possible'])){
  
	$cancel = intval($_GET['hide_possible']);
	$anks = get_user($cancel);  
	$anks['nick'] = u_nick($anks['id']);
	
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `id` = '$cancel' LIMIT 1"),0)==0){
	header("Location: ?");
	exit;
}  
	
mysql_query("DELETE FROM `frends` WHERE `user` = '$user[id]' AND `frend` = '$cancel' LIMIT 1");  
mysql_query("DELETE FROM `frends` WHERE `user` = '$cancel' AND `frend` = '$user[id]' LIMIT 1");  
mysql_query("DELETE FROM `frends_new` WHERE `user` = '$cancel' AND `to` = '$user[id]' LIMIT 1");  
mysql_query("DELETE FROM `frends_new` WHERE `user` = '$user[id]' AND `to` = '$cancel' LIMIT 1");  
mysql_query("OPTIMIZE TABLE `frends`");  
mysql_query("OPTIMIZE TABLE `frends_new`");  
	  	  
	$_SESSION['message'] = "Предложение дружбы от ".$anks['nick']." было отклонено.";  
	header("Location: ?".SID);    
	exit;  
}

$set['title'] = 'Заявки в друзья';;
include_once H.'sys/inc/thead.php';

shapka_VK(true, '/notifi/', 'Заявки в друзья');

?>
<div class="basisDefault">
<div class="basisDefault__row">
<div class="friendRequestList Pad">
<div class="Pad__content">
<?

$set['p_str'] = '20';
$k_post=mysql_result(mysql_query("SELECT COUNT(id) FROM `frends_new` WHERE `to` = '$ank[id]' LIMIT 1"), 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 `frends_new` WHERE `to` = '$user[id]' ORDER BY time DESC"); 

if ($k_post == 0){
?>
<div class="service_msg_box" style="border-bottom: 0;"><div class="service_msg service_msg_null">У Вас нет входящих заявок в друзья.</div></div>
<?
}
else{

while ($frend = mysql_fetch_assoc($q))
{
    $frend = get_user($frend['user']);  
    $frend['nick'] = u_nick($frend['id']);
$ob_fr = mysql_query("SELECT * FROM `frends` WHERE `frend` IN (SELECT `user` FROM `frends` WHERE `frend` = '{$user['id']}') AND `user` = '{$frend['id']}'");
$obsh_fr = 0;
while($c_f = mysql_fetch_array($ob_fr)){
$obsh_fr++;
}
$cases = array('общий друг', 'общих друга', 'общих друзей');
?>
<div class="friendRequest Row Row_style_withBorder">
<div class="friendRequest__photo">    <?= avka100($frend['id'], 'Avatar Avatar_1 Avatar_size_xxl')?></div>
<div class="friendRequest__body">
<div class="friendRequest__row friendRequest__row_name_name"><?= $frend['nick']?> 
<?
if($frend['ofical'] == 1){
?>
<b class="verified"></b>
<?
}
?>
</div>
<?
if($obsh_fr > 0){
?> 
<div class="friendRequest__row friendRequest__row_name_mutual">
<div class="UserStack UserStack_withText">
<div class="UserStack__photos">
<?
$ob_fr123 = mysql_query("SELECT * FROM `frends` WHERE `frend` IN (SELECT `user` FROM `frends` WHERE `frend` = '{$user['id']}') AND `user` = '{$frend['id']}'");
while ($post_frrr = mysql_fetch_array($ob_fr123))
{
$post_ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = '".$post_frrr['frend']."' LIMIT 1"));
?>
<div class="UserStack__photo" style="z-index: 1">    
<?= avka50($post_ank['id'], 'Avatar Avatar_1 Avatar_size_xs')?>
</div>
<?
}
?>
</div>
   
<div class="UserStack__text"><?= des2num($obsh_fr, $cases)?></div>  

</div></div>
<?
}
?> 
<div class="friendRequest__row friendRequest__row_name_buttons">
<div class="BtnStack">
<a class="BtnStack__btn Btn Btn_theme_regular" href="/friends?act=notify&accept=<?= $frend['id']?>" role="button">Добавить</a>
<a class="BtnStack__btn Btn Btn_theme_secondary" href="/friends?act=notify&hide_possible=<?= $frend['id']?>" role="button">Отклонить</a>
</div>
</div>

</div>
<a class="friendRequest__fillLink" href="/id<?= $frend['id']?>?from=friends_notify"></a>
</div>
<?

}

}
?>
</div></div></div>
<?
if ($k_page > 1)str_vk("?section=requests&",$k_page,$page);
?>
</div>
<?
}
else{

$act = isset ($_GET['section']) ? stripcslashes(htmlspecialchars($_GET['section'])) : '';


switch ($act) {

default:

$set['title'] = 'Друзья  ' . $ank['nick'];
include_once H.'sys/inc/thead.php';

if($user['id'] == $ank['id']){
	shapka_VK(false, '', 'Друзья');
}
else{
	shapka_VK(true, '/id'.$ank['id'].'', 'Друзья '.$ank['nick'].'');
}

$vse_fr =  mysql_result(mysql_query("SELECT COUNT(*) FROM `frends` WHERE `user` = '$ank[id]' AND `i` = '1'"), 0);
$on_fr = mysql_result(mysql_query("SELECT COUNT(*) FROM `frends` INNER JOIN `user` ON `frends`.`frend`=`user`.`id` WHERE `frends`.`user` = '$ank[id]' AND `frends`.`i` = '1' AND `user`.`date_last`>'".(time()-600)."'"), 0);
$ob_fr = mysql_query("SELECT * FROM `frends` WHERE `frend` IN (SELECT `user` FROM `frends` WHERE `frend` = '{$user['id']}') AND `user` = '{$ank['id']}'");
$zay_fr = mysql_result(mysql_query("SELECT COUNT(id) FROM `frends_new` WHERE `to` = '$ank[id]' LIMIT 1"), 0);
$obsh_fr = 0;
while($c_f = mysql_fetch_array($ob_fr)){
	$obsh_fr++;
}

$config = array(
	'q' => array(
		'type' => array(
			'У Вас нет друзей',
			'Ни одного друга не найдено'
			),
		'text' => (isset($_GET['q']) ? implode(' ', explode('+', text($_GET['q']))) : false)
	),
);

if($user['id'] == $ank['id']){
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: ?');
}
}
else{
if($_SERVER['REQUEST_METHOD'] == 'POST')
{
	if(!empty($_POST['q']) && !preg_match("#(^\ )#ui", $_POST['q']))
	{
		$_POST['q'] = implode('+', explode(' ', my_esc($_POST['q'])));
		header('Location: ?id='.$ank['id'].'&q='.$_POST['q'].'');
	}
	else
		header('Location: ?id='.$ank['id'].'');
}
}

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



?>
<div class="pcont">
<?
uvedom();
?>
<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="/friends?<?= ($user['id'] == $ank['id'] ? '' : 'id='.$ank['id'].'&')?>section=all">Все <em class="tab_counter"><?= $vse_fr?></em></a>
</li>    
<li>
<a class="tab_item al_tab" href="/friends?<?= ($user['id'] == $ank['id'] ? '' : 'id='.$ank['id'].'&')?>section=online">Онлайн<?= ($on_fr > 0 ? ' <em class="tab_counter">'.$on_fr.'</em>' : '')?></a>
</li>    
<?
if(isset($user) && $user['id'] == $ank['id']){
?>
<li>
<a class="tab_item _thide al_tab" href="/friends?section=requests">Заявки<?= ($zay_fr > 0 ? ' <em class="tab_counter">'.$zay_fr.'</em>' : '')?></a>
</li>
<?
}
else{
if($obsh_fr > 0){
?>
<li>
<a class="tab_item al_tab" href="/friends?id=<?= $ank['id']?>&section=common">Общие <em class="tab_counter"><?= $obsh_fr?></em></a>
</li>
<?
}
}
?>
</ul>
</div>
    
<div class="hp_block _hide">
<form action="/friends<?= ($user['id'] == $ank['id'] ? '' : '?id='.$ank['id'].'')?>" method="POST" class="qsearch" onsubmit="return cur.fr_search.go(event);">
<input name="id" value="<?= $ank['id']?>" type="hidden">
<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="fr_search_field" placeholder="Введите имя друга.." type="text">
</div>
</div>
</td>
<td class="row_table_last_column">
<input class="button qs_button al_tab" value="Искать" id="fr_search_btn" onclick="return cur.fr_search.go(event);" type="submit">
</td>
</tr></tbody></table>
</form>
</div>
</div>
<?



$set['p_str'] = '20';
$k_post=mysql_result(mysql_query("SELECT COUNT(frend) FROM `frends` INNER JOIN `user` ON `frends`.`frend`=`user`.`id` WHERE $sql`frends`.`user` = '$ank[id]' AND `frends`.`i` = '1'"), 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 frend FROM `frends` INNER JOIN `user` ON `frends`.`frend`=`user`.`id` WHERE $sql`frends`.`user` = '$ank[id]' AND `frends`.`i` = '1' ORDER BY `user`.`date_last` DESC LIMIT $start, $set[p_str]");

if ($k_post == 0){
?>
<div class="upanel">
    <div id="fr_search_items" class="items bl_cont"><div class="service_msg_box"><div class="service_msg service_msg_null">Ни одного друга не найдено</div></div></div>
  </div>
<?
}
else{

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

while ($frend = mysql_fetch_assoc($q))
{
	$frend = get_user($frend['frend']);
	$frend['nick'] = u_nick($frend['id']);
	if($config['q']['text'] !== false) {
		$frend['nick'] = preg_replace('/' . $config['q']['text'] . '/i', '<em class="found">$0</em>', $frend['nick']);
	}
?>
<div class="simple_fit_item">
<div class="si_iwrap">
<a class="al_u<?= $frend['id']?>" href="/id<?= $frend['id']?>"><?= avka50($frend['id'], 'si_img')?></a>
</div>
<div class="si_body">
<a class="si_owner al_u<?= $frend['id']?> _u<?= $frend['id']?>" href="/id<?= $frend['id']?>"><?= $frend['nick']?></a> <?= on_($frend['id'])?>
<?
if($frend['ofical'] == 1){
?>
<b class="verified"></b>
<?
}

if($frend['ank_n_tel'] != NULL){
?>
<div class="si_row si_row_first"><span class="si_phone"><?= text($frend['ank_n_tel'])?></span></div>
<?
}
if(isset($user) && $user['id'] != $frend['id']){
?> 
<div class="si_links"><a href="/mail/?act=show&peer=<?= $frend['id']?>">Написать</a></div>
<?
}
?>
</div>
</div>
<?

}

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

}

?>
</div>
<?
if($user['id'] == $ank['id']){
if ($k_page > 1)str_vk("?",$k_page,$page);
}
else{
if ($k_page > 1)str_vk("?id=".$ank['id']."&",$k_page,$page);
}
break;

case 'online':

$set['title'] = 'Онлайн друзья';
include_once H.'sys/inc/thead.php';

if($user['id'] == $ank['id']){
	shapka_VK(false, '', 'Друзья');
}
else{
	shapka_VK(true, '/id'.$ank['id'].'', 'Друзья '.$ank['nick'].'');
}


$vse_fr =  mysql_result(mysql_query("SELECT COUNT(*) FROM `frends` WHERE `user` = '$ank[id]' AND `i` = '1'"), 0);
$on_fr = mysql_result(mysql_query("SELECT COUNT(*) FROM `frends` INNER JOIN `user` ON `frends`.`frend`=`user`.`id` WHERE `frends`.`user` = '$ank[id]' AND `frends`.`i` = '1' AND `user`.`date_last`>'".(time()-600)."'"), 0);
$ob_fr = mysql_query("SELECT * FROM `frends` WHERE `frend` IN (SELECT `user` FROM `frends` WHERE `frend` = '{$user['id']}') AND `user` = '{$ank['id']}'");
$zay_fr = mysql_result(mysql_query("SELECT COUNT(id) FROM `frends_new` WHERE `to` = '$ank[id]' LIMIT 1"), 0);
$obsh_fr = 0;
while($c_f = mysql_fetch_array($ob_fr)){
$obsh_fr++;
}

$config = array(
	'q' => array(
		'type' => array(
			'У Вас нет друзей',
			'Ни одного друга не найдено'
			),
		'text' => (isset($_GET['q']) ? implode(' ', explode('+', text($_GET['q']))) : false)
	),
);

if($user['id'] == $ank['id']){
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: ?section=online&q='.$_POST['q'].'');
	}
	else
		header('Location: ?section=online');
}
}
else{
if($_SERVER['REQUEST_METHOD'] == 'POST')
{
	if(!empty($_POST['q']) && !preg_match("#(^\ )#ui", $_POST['q']))
	{
		$_POST['q'] = implode('+', explode(' ', my_esc($_POST['q'])));
		header('Location: ?id='.$ank['id'].'&section=online&q='.$_POST['q'].'');
	}
	else
		header('Location: ?id='.$ank['id'].'&section=online');
}
}

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



?>
<div class="pcont">
<?
uvedom();
?>
<div class="head_panel">    
<div class="hp_block tabs_block">
<ul class="tabs_list">    
<li>
<a class="tab_item al_tab" href="/friends?<?= ($user['id'] == $ank['id'] ? '' : 'id='.$ank['id'].'&')?>section=all">Все <em class="tab_counter"><?= $vse_fr?></em></a>
</li>    
<li>
<a class="tab_item tab_item_cur al_tab" href="/friends?<?= ($user['id'] == $ank['id'] ? '' : 'id='.$ank['id'].'&')?>section=online">Онлайн<?= ($on_fr > 0 ? ' <em class="tab_counter">'.$on_fr.'</em>' : '')?></a>
</li>    
<?
if(isset($user) && $user['id'] == $ank['id']){
?>
<li>
<a class="tab_item _thide al_tab" href="/friends?section=requests">Заявки<?= ($zay_fr > 0 ? ' <em class="tab_counter">'.$zay_fr.'</em>' : '')?></a>
</li>
<?
}
else{
if($obsh_fr > 0){
?>
<li>
<a class="tab_item al_tab" href="/friends?id=<?= $ank['id']?>&section=common">Общие <em class="tab_counter"><?= $obsh_fr?></em></a>
</li>
<?
}
}
?>
</ul>
</div>
    
<div class="hp_block _hide">
<form action="/friends<?= ($user['id'] == $ank['id'] ? '?section=online' : '?id='.$ank['id'].'&section=online')?>" method="POST" class="qsearch" onsubmit="return cur.fr_search.go(event);">
<input name="id" value="<?= $ank['id']?>" type="hidden">
<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="fr_search_field" placeholder="Введите имя друга.." type="text">
</div>
</div>
</td>
<td class="row_table_last_column">
<input class="button qs_button al_tab" value="Искать" id="fr_search_btn" onclick="return cur.fr_search.go(event);" type="submit">
</td>
</tr></tbody></table>
</form>
</div>
</div>
<?


$set['p_str'] = '10';
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `frends` INNER JOIN `user` ON `frends`.`frend`=`user`.`id` WHERE $sql`frends`.`user` = '$ank[id]' AND `frends`.`i` = '1' AND `user`.`date_last`>'".(time()-600)."'"), 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 `frends` INNER JOIN `user` ON `frends`.`frend`=`user`.`id` WHERE $sql`frends`.`user` = '$ank[id]' AND `frends`.`i` = '1' AND `user`.`date_last`>'".(time()-600)."' ORDER BY `user`.`date_last` DESC LIMIT $start, $set[p_str]");

if ($k_post == 0){
?>
<div class="upanel">
    <div id="fr_search_items" class="items bl_cont"><div class="service_msg_box"><div class="service_msg service_msg_null">Ни одного друга не найдено</div></div></div>
  </div>
<?
}
else{

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

while ($frend = mysql_fetch_assoc($q))
{
    $frend = get_user($frend['frend']);
    $frend['nick'] = u_nick($frend['id']);
	if($config['q']['text'] !== false) {
		$frend['nick'] = preg_replace('/' . $config['q']['text'] . '/i', '<em class="found">$0</em>', $frend['nick']);
	}
?>
<div class="simple_fit_item">
<div class="si_iwrap">
<a class="al_u<?= $frend['id']?>" href="/id<?= $frend['id']?>"><?= avka50($frend['id'], 'si_img')?></a>
</div>
<div class="si_body">
<a class="si_owner al_u<?= $frend['id']?> _u<?= $frend['id']?>" href="/id<?= $frend['id']?>"><?= $frend['nick']?></a> <?= on_($frend['id'])?>
<?

if($frend['ofical'] == 1){
?>
<b class="verified"></b>
<?
}
if($frend['ank_n_tel'] != NULL){
?>
<div class="si_row si_row_first"><span class="si_phone"><?= text($frend['ank_n_tel'])?></span></div>
<?
}
if(isset($user) && $user['id'] != $frend['id']){
?> 
<div class="si_links"><a href="/mail/?act=show&peer=<?= $frend['id']?>">Написать</a></div>
<?
}
?>
</div>
</div>
<?

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

?>
</div>
<?

if($user['id'] == $ank['id']){
if ($k_page > 1)str_vk("?section=online&",$k_page,$page);
}
else{
if ($k_page > 1)str_vk("?id=".$ank['id']."&section=online&",$k_page,$page);
}


break;


case 'common':

if($user['id'] == $ank['id']){
	$_SESSION['err'] = "Ошибка доступа! Попробуйте еще раз!";  
	header("location:  ?id=".$user['id']."");   
	exit; 
}

$set['title'] = 'Общие друзья';
include_once H.'sys/inc/thead.php';

if($user['id'] == $ank['id']){
	shapka_VK(false, '', 'Друзья');
}
else{
	shapka_VK(true, '/id'.$ank['id'].'', 'Друзья '.$ank['nick'].'');
}

$vse_fr =  mysql_result(mysql_query("SELECT COUNT(*) FROM `frends` WHERE `user` = '$ank[id]' AND `i` = '1'"), 0);
$on_fr = mysql_result(mysql_query("SELECT COUNT(*) FROM `frends` INNER JOIN `user` ON `frends`.`frend`=`user`.`id` WHERE `frends`.`user` = '$ank[id]' AND `frends`.`i` = '1' AND `user`.`date_last`>'".(time()-600)."'"), 0);
$ob_fr = mysql_query("SELECT * FROM `frends` WHERE `frend` IN (SELECT `user` FROM `frends` WHERE `frend` = '".$user['id']."') AND `user` = '".$ank['id']."'");
$zay_fr = mysql_result(mysql_query("SELECT COUNT(id) FROM `frends_new` WHERE `to` = '$ank[id]' LIMIT 1"), 0);
$obsh_fr = 0;
while($c_f = mysql_fetch_array($ob_fr)){
$obsh_fr++;
}

?>
<div class="pcont">
<?
uvedom();
?>
<div class="head_panel">    
<div class="hp_block tabs_block">
<ul class="tabs_list">    
<li>
<a class="tab_item al_tab" href="/friends?<?= ($user['id'] == $ank['id'] ? '' : 'id='.$ank['id'].'&')?>section=all">Все <em class="tab_counter"><?= $vse_fr?></em></a>
</li>    
<li>
<a class="tab_item al_tab" href="/friends?<?= ($user['id'] == $ank['id'] ? '' : 'id='.$ank['id'].'&')?>section=online">Онлайн<?= ($on_fr > 0 ? ' <em class="tab_counter">'.$on_fr.'</em>' : '')?></a>
</li>    
<?
if(isset($user) && $user['id'] == $ank['id']){
?>
<li>
<a class="tab_item _thide al_tab" href="/friends?section=requests">Заявки<?= ($zay_fr > 0 ? ' <em class="tab_counter">'.$zay_fr.'</em>' : '')?></a>
</li>
<?
}
else{
if($obsh_fr > 0){
?>
<li>
<a class="tab_item tab_item_cur al_tab" href="/friends?id=<?= $ank['id']?>&section=common">Общие <em class="tab_counter"><?= $obsh_fr?></em></a>
</li>
<?
}
}
?>
</ul>
</div>
    
</div>
<?

$set['p_str'] = '20';

$query = mysql_query("SELECT * FROM `frends` WHERE `frend` IN (SELECT `user` FROM `frends` WHERE `frend` = '".$user['id']."') AND `user` = '".$ank['id']."'");
$k_post = 0;
while($c_f = mysql_fetch_array($query)){
$k_post++;
}
$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 `frends` WHERE `frend` IN (SELECT `user` FROM `frends` WHERE `frend` = '".$user['id']."') AND `user` = '".$ank['id']."'");

if ($k_post == 0){
?>
<div class="upanel">
    <div id="fr_search_items" class="items bl_cont"><div class="service_msg_box"><div class="service_msg service_msg_null">Ни одного друга не найдено</div></div></div>
</div>
<?
}
else{

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

while ($frend = mysql_fetch_assoc($q))
{
    $frend = get_user($frend['frend']);
    $frend['nick'] = u_nick($frend['id']);

?>
<div class="simple_fit_item">
<div class="si_iwrap">
<a class="al_u<?= $frend['id']?>" href="/id<?= $frend['id']?>"><?= avka50($frend['id'], 'si_img')?></a>
</div>
<div class="si_body">
<a class="si_owner al_u<?= $frend['id']?> _u<?= $frend['id']?>" href="/id<?= $frend['id']?>"><?= $frend['nick']?></a> <?= on_($frend['id'])?>
<?
if($frend['ofical'] == 1){
?>
<b class="verified"></b>
<?
}
if($frend['ank_n_tel'] != NULL){
?>
<div class="si_row si_row_first"><span class="si_phone"><?= text($frend['ank_n_tel'])?></span></div>
<?
}
if(isset($user) && $user['id'] != $frend['id']){
?> 
<div class="si_links"><a href="/mail/?act=show&peer=<?= $frend['id']?>">Написать</a></div>
<?
}
?>
</div>
</div>
<?

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

?>
</div>
<?


if ($k_page > 1)str_vk("?id=".$ank['id']."&section=common&",$k_page,$page);

break;


case 'requests':

if($user['id'] != $ank['id']){
	$_SESSION['err'] = "Ошибка доступа! Попробуйте еще раз!";  
	header("location:  ?id=".$user['id']."");   
	exit; 
}

if (isset($_GET['accept'])){
	
	$add = intval($_GET['accept']);
	$anks = get_user($add);  
	$anks['nick'] = u_nick($anks['id']); 

if (mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `id` = '$add' LIMIT 1"),0)==0){
	$_SESSION['err'] = "Ошибка доступа! Попробуйте еще раз!";  
	header("Location: /");
	exit;
}  

$a = mysql_result(mysql_query("SELECT COUNT(*) FROM `frends_new` WHERE `user` = '$add' AND `to` = '$user[id]'"),0);  
$as = mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '".$add."' LIMIT 1"));  
	
if ($a == 0)  {  
		die("Ошибка! Попробуйте еще раз!");  
}  
else{	      
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `frends_new` WHERE (`user` = '$user[id]' AND `to` = '$add') OR (`user` = '$add' AND `to` = '$user[id]')"),0)==1){  

// Уведомления о друзьях
mysql_query("INSERT INTO `notifi` (`avtor`, `id_user`, `id_object`, `type`, `time`) VALUES ('$user[id]', '$add', '$user[id]', 'friend_ok', '$time')");


mysql_query("INSERT INTO `frends` (`user`, `frend`, `time`, `i`) values('$user[id]', '$add', '$time', '1')");  
mysql_query("INSERT INTO `frends` (`user`, `frend`, `time`, `i`) values('$add', '$user[id]', '$time', '1')");  
mysql_query("DELETE FROM `frends_new` WHERE `user` = '$add' AND `to` = '$user[id]' LIMIT 1");  
mysql_query("DELETE FROM `frends_new` WHERE `user` = '$user[id]' AND `to` = '$add' LIMIT 1");  
mysql_query("OPTIMIZE TABLE `frends`");  
mysql_query("OPTIMIZE TABLE `frends_new`");  
}		  

	$_SESSION['message'] = "".$anks['nick']." добавлен".($anks['pol'] == 1 ? '' : 'а')." в друзья.";  
	header("Location: ?".SID);  
	exit;  
}  

}  

if (isset($_GET['hide_possible'])){
  
	$cancel = intval($_GET['hide_possible']);
	$anks = get_user($cancel);  
	$anks['nick'] = u_nick($anks['id']);
	
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `id` = '$cancel' LIMIT 1"),0)==0){
	header("Location: ?");
	exit;
}  
	
mysql_query("DELETE FROM `frends` WHERE `user` = '$user[id]' AND `frend` = '$cancel' LIMIT 1");  
mysql_query("DELETE FROM `frends` WHERE `user` = '$cancel' AND `frend` = '$user[id]' LIMIT 1");  
mysql_query("DELETE FROM `frends_new` WHERE `user` = '$cancel' AND `to` = '$user[id]' LIMIT 1");  
mysql_query("DELETE FROM `frends_new` WHERE `user` = '$user[id]' AND `to` = '$cancel' LIMIT 1");  
mysql_query("OPTIMIZE TABLE `frends`");  
mysql_query("OPTIMIZE TABLE `frends_new`");  
	  	  
	$_SESSION['message'] = "Предложение дружбы от ".$anks['nick']." было отклонено.";  
	header("Location: ?".SID);    
	exit;  
}

$set['title'] = 'Друзья  ' . $ank['nick'];
include_once H.'sys/inc/thead.php';

if($user['id'] == $ank['id']){
	shapka_VK(false, '', 'Друзья');
}
else{
	shapka_VK(true, '/id'.$ank['id'].'', 'Друзья '.$ank['nick'].'');
}

$vse_fr =  mysql_result(mysql_query("SELECT COUNT(*) FROM `frends` WHERE `user` = '$ank[id]' AND `i` = '1'"), 0);
$on_fr = mysql_result(mysql_query("SELECT COUNT(*) FROM `frends` INNER JOIN `user` ON `frends`.`frend`=`user`.`id` WHERE `frends`.`user` = '$ank[id]' AND `frends`.`i` = '1' AND `user`.`date_last`>'".(time()-600)."'"), 0);
$ob_fr = mysql_query("SELECT * FROM `frends` WHERE `frend` IN (SELECT `user` FROM `frends` WHERE `frend` = '{$user['id']}') AND `user` = '{$ank['id']}'");
$zay_fr = mysql_result(mysql_query("SELECT COUNT(id) FROM `frends_new` WHERE `to` = '$ank[id]' LIMIT 1"), 0);
$obsh_fr = 0;
while($c_f = mysql_fetch_array($ob_fr)){
$obsh_fr++;
}
$ishod_zay = mysql_result(mysql_query("SELECT COUNT(*) FROM `frends_new` WHERE `user` = '$user[id]' "), 0);

?>
<div class="pcont">
<?
uvedom();
?>
<div class="head_panel">    
<div class="hp_block tabs_block">
<ul class="tabs_list">    
<li>
<a class="tab_item al_tab" href="/friends?<?= ($user['id'] == $ank['id'] ? '' : 'id='.$ank['id'].'&')?>section=all">Все <em class="tab_counter"><?= $vse_fr?></em></a>
</li>    
<li>
<a class="tab_item al_tab" href="/friends?<?= ($user['id'] == $ank['id'] ? '' : 'id='.$ank['id'].'&')?>section=online">Онлайн<?= ($on_fr > 0 ? ' <em class="tab_counter">'.$on_fr.'</em>' : '')?></a>
</li>    
<li>
<a class="tab_item tab_item_cur _thide al_tab" href="/friends?section=requests">Заявки<?= ($zay_fr > 0 ? ' <em class="tab_counter">'.$zay_fr.'</em>' : '')?></a>
</li>
</ul>
</div> 
</div>
<div class="upanel">
<div id="fr_search_items" class="items bl_cont">
<?

$set['p_str'] = '20';
$k_post=mysql_result(mysql_query("SELECT COUNT(id) FROM `frends_new` WHERE `to` = '$ank[id]' LIMIT 1"), 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 `frends_new` WHERE `to` = '$user[id]' ORDER BY time DESC"); 

if ($k_post == 0){
?>
<div class="service_msg_box"><div class="service_msg service_msg_null">У Вас нет входящих заявок в друзья.</div></div>
<?
}
else{

while ($frend = mysql_fetch_assoc($q))
{
    $frend = get_user($frend['user']);  
    $frend['nick'] = u_nick($frend['id']);
$ob_fr = mysql_query("SELECT * FROM `frends` WHERE `frend` IN (SELECT `user` FROM `frends` WHERE `frend` = '{$user['id']}') AND `user` = '{$frend['id']}'");
$obsh_fr = 0;
while($c_f = mysql_fetch_array($ob_fr)){
$obsh_fr++;
}
$cases = array('общий друг', 'общих друга', 'общих друзей');
?>
<div class="simple_fit_item">
  <a class="al_u<?= $frend['id']?>" href="/id<?= $frend['id']?>"><?= avka50($frend['id'], 'si_img')?></a>
  <div class="si_body">
    <a class="si_owner al_u<?= $frend['id']?> _u<?= $frend['id']?>" href="/id<?= $frend['id']?>"><?= $frend['nick']?></a> <?= on_($frend['id'])?>
<?
if($frend['ofical'] == 1){
?>
<b class="verified"></b>
<?
}
if($obsh_fr > 0){
?>    
<div class="si_row"><a class="si_row_a" href="/friends?id=<?= $frend['id']?>&amp;section=common"><?= des2num($obsh_fr, $cases)?></a></div>    
<?
}
?>        
    <div class="si_links">
      <a class="def" href="/friends?section=requests&accept=<?= $frend['id']?>">Добавить в друзья</a> - 
      <a href="/friends?section=requests&hide_possible=<?= $frend['id']?>">Отклонить</a>
    </div>
  </div>
</div>
<?

}

}

?>
<a class="inline_item inline_item_blank" href="/friends?section=out_requests"><div class="ii_body"><div class="ii_bold">Исходящие заявки 
<?
if($ishod_zay > 0){
?>
<em class="ii_counter"><?= $ishod_zay?></em>
<?
}
?>    
</div></div></a>
<?

if ($k_page > 1)str_vk("?section=requests&",$k_page,$page);


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




break;


case 'out_requests':

if($user['id'] != $ank['id']){
	$_SESSION['err'] = "Ошибка доступа! Попробуйте еще раз!";  
	header("location:  ?id=".$user['id']."");   
	exit; 
}


$set['title'] = 'Друзья  ' . $ank['nick'];
include_once H.'sys/inc/thead.php';

shapka_VK(true, '/friends?section=requests', 'Исходящие заявки');

?>
<div class="pcont">
<?
uvedom();
?>
<div class="upanel"><div id="fr_search_items" class="items bl_cont">
<?

$set['p_str'] = '20';
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `frends_new` WHERE `user` = '$user[id]' "), 0);
$k_page = k_page($k_post,$set['p_str']);
$page = page($k_page);
$start = $set['p_str'] * $page - $set['p_str'];

$collichestvo = array('человека', 'человека', 'человек');

$q = mysql_query("SELECT * FROM `frends_new` WHERE `user` = '$user[id]' ORDER BY id DESC LIMIT $start, $set[p_str]");

if ($k_post == 0){
?>
<div class="service_msg_box"><div class="service_msg service_msg_null">У Вас нет исходящих заявок в друзья.</div></div>
<?
}
else{
?>
<h4 class="slim_header"><b>Вы</b> подали заявку и подписались на  <b style="color:green"><?= des2num($k_post, $collichestvo)?></b></h4>
<?
}

while ($frend = mysql_fetch_assoc($q))
{
$frend = get_user($frend['to']);
$frend['nick'] = u_nick($frend['id']);
$ob_fr = mysql_query("SELECT * FROM `frends` WHERE `frend` IN (SELECT `user` FROM `frends` WHERE `frend` = '{$user['id']}') AND `user` = '{$frend['id']}'");
$obsh_fr = 0;
while($c_f = mysql_fetch_array($ob_fr)){
$obsh_fr++;
}
$cases = array('общий друг', 'общих друга', 'общих друзей');
?>
<div class="simple_fit_item">
  <a class="al_u<?= $frend['id']?>" href="/id<?= $frend['id']?>"><?= avka50($frend['id'], 'si_img')?></a>
  <div class="si_body">
    <a class="si_owner al_u<?= $frend['id']?> _u<?= $frend['id']?>" href="/id<?= $frend['id']?>"><?= $frend['nick']?></a> <?= on_($frend['id'])?>
<?
if($frend['ofical'] == 1){
?>
<b class="verified"></b>
<?
}
if($obsh_fr > 0){
?>    
<div class="si_row"><a class="si_row_a" href="/friends?id=<?= $frend['id']?>&amp;section=common"><?= des2num($obsh_fr, $cases)?></a></div>    
<?
}
?>   
    <div class="si_links">
      <a href="/id<?= $frend['id']?>?cancel=<?= $frend['id']?>">Отменить заявку и отписаться</a>
    </div>
  </div>
</div>
<?


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

if ($k_page > 1)str_vk("?section=out_requests&",$k_page,$page);

break;


case 'suggestions':

if($user['id'] != $ank['id']){
	$_SESSION['err'] = "Ошибка доступа! Попробуйте еще раз!";  
	header("location:  ?id=".$user['id']."");   
	exit; 
}

# Кидаем заявку в друзья
if (isset($_GET['accept'])){
	
	$ank['id'] = intval($_GET['accept']);  
	$anks = get_user($ank['id']);
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `id` = '$ank[id]' LIMIT 1"),0)==0){
	header("Location: /".SID);
	exit;
}  
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `frends` WHERE (`user` = '$user[id]' AND `frend` = '$ank[id]') OR (`user` = '$ank[id]' AND `frend` = '$user[id]') LIMIT 1"),0)==1){
	header("Location: /".SID);
	exit;
}  
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `frends_new` WHERE (`user` = '$user[id]' AND `to` = '$ank[id]') OR (`user` = '$ank[id]' AND `to` = '$user[id]') LIMIT 1"),0)==1){
	header("Location: /".SID);
	exit;
}  
if ($ank['id'] == $user['id']){
	header("Location: /".SID);
	exit;
}  
 
mysql_query("INSERT INTO `frends_new` (`user`, `to`, `time`) values('$user[id]', '$ank[id]', '$time')");  
mysql_query("OPTIMIZE TABLE `frends_new`");  

header("location:  " . htmlspecialchars($_SERVER['HTTP_REFERER']) . "");  
exit;  
} 
# Отменяем заявку
if (isset($_GET['cancel']))  
{  
  $no = intval($_GET['cancel']);  
  $anks = get_user($no);
  if (mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `id` = '$no' LIMIT 1"),0)==0){
  header("Location: /");
  exit;
  }  
  if (mysql_result(mysql_query("SELECT COUNT(*) FROM `frends_new` WHERE (`user` = '$user[id]' AND `to` = '$no') OR (`user` = '$no' AND `to` = '$user[id]') LIMIT 1"),0)>0)  
  {  

  mysql_query("DELETE FROM `frends` WHERE `user` = '$user[id]' AND `frend` = '$no' LIMIT 1");  
  mysql_query("DELETE FROM `frends` WHERE `user` = '$no' AND `frend` = '$user[id]' LIMIT 1");  
  mysql_query("DELETE FROM `frends_new` WHERE `user` = '$no' AND `to` = '$user[id]' LIMIT 1");  
  mysql_query("DELETE FROM `frends_new` WHERE `user` = '$user[id]' AND `to` = '$no' LIMIT 1");  
  mysql_query("OPTIMIZE TABLE `frends`");  
  mysql_query("OPTIMIZE TABLE `frends_new`"); 
 
	header("location:  " . htmlspecialchars($_SERVER['HTTP_REFERER']) . "");  
	}  
exit;  
}

$set['title'] = 'Друзья  ' . $ank['nick'];
include_once H.'sys/inc/thead.php';

shapka_VK(false, '', 'Друзья');


$vse_fr =  mysql_result(mysql_query("SELECT COUNT(*) FROM `frends` WHERE `user` = '$ank[id]' AND `i` = '1'"), 0);
$on_fr = mysql_result(mysql_query("SELECT COUNT(*) FROM `frends` INNER JOIN `user` ON `frends`.`frend`=`user`.`id` WHERE `frends`.`user` = '$ank[id]' AND `frends`.`i` = '1' AND `user`.`date_last`>'".(time()-600)."'"), 0);
$ob_fr = mysql_query("SELECT * FROM `frends` WHERE `frend` IN (SELECT `user` FROM `frends` WHERE `frend` = '{$user['id']}') AND `user` = '{$ank['id']}'");
$zay_fr = mysql_result(mysql_query("SELECT COUNT(id) FROM `frends_new` WHERE `to` = '$ank[id]' LIMIT 1"), 0);
$obsh_fr = 0;
while($c_f = mysql_fetch_array($ob_fr)){
$obsh_fr++;
}
$ishod_zay = mysql_result(mysql_query("SELECT COUNT(*) FROM `frends_new` WHERE `user` = '$user[id]' "), 0);

?>
<div class="pcont">
<?
uvedom();
?>
<div class="head_panel">    
<div class="hp_block tabs_block">
<ul class="tabs_list">    
<li>
<a class="tab_item al_tab" href="/friends?<?= ($user['id'] == $ank['id'] ? '' : 'id='.$ank['id'].'&')?>section=all">Все <em class="tab_counter"><?= $vse_fr?></em></a>
</li>    
<li>
<a class="tab_item al_tab" href="/friends?<?= ($user['id'] == $ank['id'] ? '' : 'id='.$ank['id'].'&')?>section=online">Онлайн<?= ($on_fr > 0 ? ' <em class="tab_counter">'.$on_fr.'</em>' : '')?></a>
</li>     
<li>
<a class="tab_item tab_item_cur _thide al_tab" href="/friends?section=suggestions">Возможные</a>
</li>
</ul>
</div></div>
<div class="upanel">
<div id="fr_search_items" class="items bl_cont">
<?

$set['p_str'] = '20';

$query = mysql_query("SELECT * FROM `frends` WHERE `frend` IN (SELECT `user` FROM `frends` WHERE `frend` = '".$user['id']."') AND `user` != '".$user['id']."'");
$k_post = 0;
while($c_f = mysql_fetch_array($query)){
$k_post++;
}
$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 `frends` WHERE `frend` IN (SELECT `user` FROM `frends` WHERE `frend` = '".$user['id']."') AND `user` != '".$user['id']."' ORDER BY RAND() DESC LIMIT 6");

if ($k_post == 0){
?>
<div class="upanel">
    <div id="fr_search_items" class="items bl_cont"><div class="service_msg_box"><div class="service_msg service_msg_null">Ни одного возможного друга не найдено</div></div></div>
</div>
<?
}
else{

while ($frend = mysql_fetch_assoc($q))
{
$frend = get_user($frend['user']);
$frend['nick'] = u_nick($frend['id']);
$frend2 = mysql_result(mysql_query("SELECT COUNT(*) FROM `frends` WHERE `user` = '$user[id]' AND `frend` = '$frend[id]' LIMIT 1"),0);
$frend_new = mysql_result(mysql_query("SELECT COUNT(*) FROM `frends_new` WHERE `user` = '$user[id]' AND `to` = '$frend[id]' LIMIT 1"),0);

$ob_fr = mysql_query("SELECT * FROM `frends` WHERE `frend` IN (SELECT `user` FROM `frends` WHERE `frend` = '{$user['id']}') AND `user` = '{$frend['id']}'");
$obsh_fr = 0;
while($c_f = mysql_fetch_array($ob_fr)){
$obsh_fr++;
}
$cases = array('общий друг', 'общих друга', 'общих друзей');
?>
<div class="simple_fit_item">
  <a class="al_u<?= $frend['id']?>" href="/id<?= $frend['id']?>"><?= avka50($frend['id'], 'si_img')?></a>
  <div class="si_body">
    <a class="si_owner al_u<?= $frend['id']?> _u<?= $frend['id']?>" href="/id<?= $frend['id']?>"><?= $frend['nick']?></a> <?= on_($frend['id'])?>
<?
if($frend['ofical'] == 1){
?>
<b class="verified"></b>
<?
}
if($obsh_fr > 0){
?>    
<div class="si_row"><a class="si_row_a" href="/friends?id=<?= $frend['id']?>&amp;section=common"><?= des2num($obsh_fr, $cases)?></a></div>    
<?
}

if ($frend_new == 0 && $frend2 == 0){
?>
<div class="si_links">
<a href="?section=suggestions&accept=<?= $frend['id']?>" data-uid="<?= $frend['id']?>">Добавить в друзья</a>
</div>
<?
}
elseif ($frend_new == 1){
?>  
<div class="si_links">
<a href="?section=suggestions&cancel=<?= $frend['id']?>" data-uid="<?= $frend['id']?>">Отменить заявку и отписаться</a>
</div>
<?
}
?>
  </div>
</div>
<?

}
}

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


if ($k_page > 1)str_vk("?section=suggestions&",$k_page,$page);



break;
}

}

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

?>