Вход Регистрация
Файл: system/modules/friends.php
Строк: 558
<?php
/* 
    Appointment: Друзья пользователя
    File: friends.php 
 
*/
if(!defined('MOZG'))
    die(
'Hacking attempt!');

//Если страница вызвана через AJAX то включаем защиту, чтоб не могли обращаться напрямую к странице
if($ajax == 'yes')
    
NoAjaxQuery();

if(
$logged){
    
$act $_GET['act'];
    
$metatags['title'] = $lang['friends'];

    if(
$_GET['page'] > 0$page intval($_GET['page']); else $page 1;
    
$gcount 20;
    
$limit_page = ($page-1)*$gcount;
                
    switch(
$act){
        
        
//################### Отправка заявки в друзья ###################//
        
case "send_demand":
            
NoAjaxQuery();
            
            
$for_user_id intval($_GET['for_user_id']);
            
$from_user_id $user_info['user_id'];
            
            
//Проверяем на факт сушествования заявки для пользователя, если она уже есть, то даёт ответ "yes_demand"
            
$check $db->super_query("SELECT for_user_id FROM `".PREFIX."_friends_demands` WHERE for_user_id = '{$for_user_id}' AND from_user_id = '{$from_user_id}'");

            if(
$for_user_id AND !$check AND $for_user_id != $from_user_id){
                
                
//Проверяем существования заявки у себя в заявках
                
$check_demands $db->super_query("SELECT for_user_id FROM `".PREFIX."_friends_demands` WHERE for_user_id = '{$from_user_id}' AND from_user_id = '{$for_user_id}'");
                if(!
$check_demands){
                    
                    
//Проверяем нетли этого юзера уже в списке друзей
                    
$check_friendlist $db->super_query("SELECT user_id FROM `".PREFIX."_friends` WHERE friend_id = '{$for_user_id}' AND user_id = '{$from_user_id}' AND subscriptions = 0");
                    if(!
$check_friendlist){
                        
$db->query("INSERT INTO `".PREFIX."_friends_demands` (for_user_id, from_user_id, demand_date) VALUES ('{$for_user_id}', '{$from_user_id}', NOW())");
                        
$db->query("UPDATE `".PREFIX."_users` SET user_friends_demands = user_friends_demands+1 WHERE user_id = '{$for_user_id}'");
                        echo 
'ok';
    
//Вставляем событие в моментальные оповещания
                        
$row_owner $db->super_query("SELECT user_last_visit FROM `".PREFIX."_users` WHERE user_id = '{$for_user_id}'");
                        
$update_time $server_time 70;
                        
                        if(
$row_owner['user_last_visit'] >= $update_time){
                            
                            
$action_update_text 'хочет добавить Вас в друзья.';
                            
                            
$db->query("INSERT INTO `".PREFIX."_updates` SET for_user_id = '{$for_user_id}', from_user_id = '{$user_info['user_id']}', type = '11', date = '{$server_time}', text = '{$action_update_text}', user_photo = '{$user_info['user_photo']}', user_search_pref = '{$user_info['user_search_pref']}', lnk = '/friends/requests'");
                        
                            
mozg_create_cache("user_{$for_user_id}/updates"1);
                        
                        }

                        
                        
//Отправка уведомления на E-mail
                        
if($config['news_mail_1'] == 'yes'){
                            
$rowUserEmail $db->super_query("SELECT user_name, user_email FROM `".PREFIX."_users` WHERE user_id = '".$for_user_id."'");
                            if(
$rowUserEmail['user_email']){
                                include_once 
ENGINE_DIR.'/classes/mail.php';
                                
$mail = new dle_mail($config);
                                
$rowMyInfo $db->super_query("SELECT user_search_pref FROM `".PREFIX."_users` WHERE user_id = '".$user_id."'");
                                
$rowEmailTpl $db->super_query("SELECT text FROM `".PREFIX."_mail_tpl` WHERE id = '1'");
                                
$rowEmailTpl['text'] = str_replace('{%user%}'$rowUserEmail['user_name'], $rowEmailTpl['text']);
                                
$rowEmailTpl['text'] = str_replace('{%user-friend%}'$rowMyInfo['user_search_pref'], $rowEmailTpl['text']);
                                
$mail->send($rowUserEmail['user_email'], 'Новая заявка в друзья'$rowEmailTpl['text']);
                            }
                        }
                    } else
                        echo 
'yes_friend';
                } else
                    echo 
'yes_demand2';
            } else 
                echo 
'yes_demand';
            
            die();
        break;
        
        
//################### Принятие заявки на дружбу ###################//
        
case "take":
            
NoAjaxQuery();
            
$take_user_id intval($_GET['take_user_id']);
            
$user_id $user_info['user_id'];
            
            
//Проверяем на существования юзера в таблице заявок в друзья
            
$check $db->super_query("SELECT for_user_id FROM `".PREFIX."_friends_demands` WHERE for_user_id = '{$user_id}' AND from_user_id = '{$take_user_id}'");
            
            if(
$check){
                
                
//Добавляем юзера который кинул заявку в список друзей
                
$db->query("INSERT INTO `".PREFIX."_friends` SET user_id = '{$user_id}', friend_id = '{$take_user_id}', friends_date = NOW()");
                
                
//Тому кто предлогал дружбу, добавляем ему в друзья себя
                
$db->query("INSERT INTO `".PREFIX."_friends` SET user_id = '{$take_user_id}', friend_id = '{$user_id}', friends_date = NOW()");
                
                
//Обновляем кол-во заявок и кол-друзей у юзера
                
$db->query("UPDATE `".PREFIX."_users` SET user_friends_demands = user_friends_demands-1, user_friends_num = user_friends_num+1 WHERE user_id = '{$user_id}'");
                
                
//Тому кто предлогал дружбу, обновляем кол-друзей
                
$db->query("UPDATE `".PREFIX."_users` SET user_friends_num = user_friends_num+1 WHERE user_id = '{$take_user_id}'");
                
                
//Удаляем заявку из таблицы заявок
                
$db->query("DELETE FROM `".PREFIX."_friends_demands` WHERE for_user_id = '{$user_id}' AND from_user_id = '{$take_user_id}'");

                
$generateLastTime $server_time-10800;
                
                
//Добавляем действия в ленту новостей кто подавал заявку
                
$rowX $db->super_query("SELECT ac_id, action_text FROM `".PREFIX."_news` WHERE action_time > '{$generateLastTime}' AND action_type = 4 AND ac_user_id = '{$take_user_id}'");
                if(
$rowX['ac_id'])
                    if(!
preg_match("/{$rowX['action_text']}/i"$user_id))
                        
$db->query("UPDATE `".PREFIX."_news` SET action_text = '{$rowX['action_text']}||{$user_id}', action_time = '{$server_time}' WHERE ac_id = '{$rowX['ac_id']}'");
                    else
                        echo 
'';
                else
                    
$db->query("INSERT INTO `".PREFIX."_news` SET ac_user_id = '{$take_user_id}', action_type = 4, action_text = '{$user_id}', action_time = '{$server_time}'");
    


//Вставляем событие в моментальные оповещания
                
$row_owner $db->super_query("SELECT user_last_visit FROM `".PREFIX."_users` WHERE user_id = '{$take_user_id}'");
                
$update_time $server_time 70;
                        
                if(
$row_owner['user_last_visit'] >= $update_time){
                            
                    
$myRow $db->super_query("SELECT user_sex FROM `".PREFIX."_users` WHERE user_id = '{$user_info['user_id']}'");
                    if(
$myRow['user_sex'] == 2$action_update_text 'подтвердила Вашу заявку на дружбу.';
                    else 
$action_update_text 'подтвердил Вашу заявку на дружбу.';
                            
                    
$db->query("INSERT INTO `".PREFIX."_updates` SET for_user_id = '{$take_user_id}', from_user_id = '{$user_info['user_id']}', type = '12', date = '{$server_time}', text = '{$action_update_text}', user_photo = '{$user_info['user_photo']}', user_search_pref = '{$user_info['user_search_pref']}', lnk = '/u{$take_user_id}'");
                        
                    
mozg_create_cache("user_{$take_user_id}/updates"1);
                        
                }







                
//Добавляем действия в ленту новостей себе
                
$row $db->super_query("SELECT ac_id, action_text FROM `".PREFIX."_news` WHERE action_time > '{$generateLastTime}' AND action_type = 4 AND ac_user_id = '{$user_id}'");
                if(
$row)
                    if(!
preg_match("/{$row['action_text']}/i"$take_user_id))
                        
$db->query("UPDATE `".PREFIX."_news` SET action_text = '{$row['action_text']}||{$take_user_id}', action_time = '{$server_time}' WHERE ac_id = '{$row['ac_id']}'");
                    else
                        echo 
'';
                else
                    
$db->query("INSERT INTO `".PREFIX."_news` SET ac_user_id = '{$user_id}', action_type = 4, action_text = '{$take_user_id}', action_time = '{$server_time}'");

                
//Чистим кеш владельцу стр и тому кого добавляем в др.
                
mozg_clear_cache_file('user_'.$user_id.'/profile_'.$user_id);
                
mozg_clear_cache_file('user_'.$take_user_id.'/profile_'.$take_user_id);

                
//Записываем пользователя в кеш файл друзей
                
$openMyList mozg_cache("user_{$user_id}/friends");
                
mozg_create_cache("user_{$user_id}/friends"$openMyList."u{$take_user_id}|");
                
                
$openTakeList mozg_cache("user_{$take_user_id}/friends");
                
mozg_create_cache("user_{$take_user_id}/friends"$openTakeList."u{$user_id}|");
            } else
                echo 
'no_request';
            
            die();
        break;
        
        
//################### Отклонение заявки на дружбу ###################//
        
case "reject":
            
NoAjaxQuery();
            
$reject_user_id $db->safesql(intval($_GET['reject_user_id']));
            
$user_id $user_info['user_id'];
            
            
//Проверяем на существования юзера в таблице заявок в друзья
            
$check $db->super_query("SELECT for_user_id FROM `".PREFIX."_friends_demands` WHERE for_user_id = '{$user_id}' AND from_user_id = '{$reject_user_id}'");
            if(
$check){
                
//Обновляем кол-во заявок у юзера
                
$db->query("UPDATE `".PREFIX."_users` SET user_friends_demands = user_friends_demands-1 WHERE user_id = '{$user_id}'");
                
                
//Удаляем заявку из таблицы заявок
                
$db->query("DELETE FROM `".PREFIX."_friends_demands` WHERE for_user_id = '{$user_id}' AND from_user_id = '{$reject_user_id}'");
                
            } else
                echo 
'no_request';
            
            die();
        break;
        
        
//################### Удаления друга из списка друзей ###################//
        
case "delete":
            
NoAjaxQuery();
            
$delet_user_id $db->safesql(intval($_POST['delet_user_id']));
            
$user_id $user_info['user_id'];
            
            
//Проверяем на существования юзера в списке друзей
            
$check $db->super_query("SELECT user_id FROM `".PREFIX."_friends` WHERE user_id = '{$user_id}' AND friend_id = '{$delet_user_id}' AND subscriptions = 0");
            if(
$check){
                
//Удаляем друга из таблицы друзей
                
$db->query("DELETE FROM `".PREFIX."_friends` WHERE user_id = '{$user_id}' AND friend_id = '{$delet_user_id}' AND subscriptions = 0");
                
                
//Удаляем у друга из таблицы
                
$db->query("DELETE FROM `".PREFIX."_friends` WHERE user_id = '{$delet_user_id}' AND friend_id = '{$user_id}' AND subscriptions = 0");
                
                
//Обновляем кол-друзей у юзера
                
$db->query("UPDATE `".PREFIX."_users` SET user_friends_num = user_friends_num-1 WHERE user_id = '{$user_id}'");
                
                
//Обновляем у друга которого удаляем кол-во друзей
                
$db->query("UPDATE `".PREFIX."_users` SET user_friends_num = user_friends_num-1 WHERE user_id = '{$delet_user_id}'");
                
                
//Чистим кеш владельцу стр и тому кого удаляем из др.
                
mozg_clear_cache_file('user_'.$user_id.'/profile_'.$user_id);
                
mozg_clear_cache_file('user_'.$delet_user_id.'/profile_'.$delet_user_id);
                
                
//Удаляем пользователя из кеш файл друзей
                
$openMyList mozg_cache("user_{$user_id}/friends");
                
mozg_create_cache("user_{$user_id}/friends"str_replace("u{$delet_user_id}|"""$openMyList));
                
                
$openTakeList mozg_cache("user_{$delet_user_id}/friends");
                
mozg_create_cache("user_{$delet_user_id}/friends"str_replace("u{$user_id}|"""$openTakeList));
            } else
                echo 
'no_friend';
            
            die();
        break;
        
        
//################### Страница заявок в друзья ###################//
        
case "requests":
            
$user_id $user_info['user_id'];

            if(
$user_info['user_friends_demands'])
                
$user_speedbar $user_info['user_friends_demands'].' '.gram_record($user_info['user_friends_demands'], 'friends_demands');
            else
                
$user_speedbar $lang['no_requests'];
            
            
//Верх
            
$tpl->load_template('friends/head.tpl');
            
$tpl->set('{user-id}'$user_id);
            if(
$user_info['user_friends_demands'])
                
$tpl->set('{demands}''('.$user_info['user_friends_demands'].')');
            else
                
$tpl->set('{demands}''');
            
$tpl->set('[request-friends]''');
            
$tpl->set('[/request-friends]''');
            
$tpl->set_block("'\[all-friends\](.*?)\[/all-friends\]'si","");
            
$tpl->set_block("'\[online-friends\](.*?)\[/online-friends\]'si","");
            
$tpl->compile('info');
            
            
//Выводим заявки в друзья если они есть
            
if($user_info['user_friends_demands']){
                
$sql_ $db->super_query("SELECT SQL_CALC_FOUND_ROWS tb1.from_user_id, demand_date, tb2.user_photo, user_search_pref, user_country_city_name, user_birthday FROM `".PREFIX."_friends_demands` tb1, `".PREFIX."_users` tb2 WHERE tb1.for_user_id = '{$user_id}' AND tb1.from_user_id = tb2.user_id ORDER by `demand_date` DESC LIMIT {$limit_page}{$gcount}"1);
                
$tpl->load_template('friends/request.tpl');
                foreach(
$sql_ as $row){
                    
$user_country_city_name explode('|'$row['user_country_city_name']);
                    
$tpl->set('{country}'$user_country_city_name[0]);
                    
$tpl->set('{city}'', '.$user_country_city_name[1]);
                    
$tpl->set('{user-id}'$row['from_user_id']);
                    
$tpl->set('{name}'$row['user_search_pref']);
                    
                    if(
$row['user_photo'])
                        
$tpl->set('{ava}'$config['home_url'].'uploads/users/'.$row['from_user_id'].'/100_'.$row['user_photo']);
                    else
                        
$tpl->set('{ava}''{theme}/images/100_no_ava.png');
                    
                    
//Возраст юзера
                    
$user_birthday explode('-'$row['user_birthday']);
                    
$tpl->set('{age}'user_age($user_birthday[0], $user_birthday[1], $user_birthday[2]));
                    
                    
$tpl->compile('content');
                }
                
navigation($gcount$user_info['user_friends_demands'], $config['home_url'].'friends/requests/page/');
                
            } else
                
msgbox(''$lang['no_requests'], 'info_2');

        break;
        
        
//################### Просмотр всех онлайн друзей ###################//
        
case "online":
            
$get_user_id intval($_GET['user_id']);
            if(!
$get_user_id)
                
$get_user_id $user_info['user_id'];
            
            
//ЧС
            
$CheckBlackList CheckBlackList($get_user_id);
            if(!
$CheckBlackList){

                if(
$get_user_id == $user_info['user_id'])
                    
$sql_order "ORDER by `views`";
                else
                    
$sql_order "ORDER by `friends_date`";
                            
                
$sql_ $db->super_query("SELECT SQL_CALC_FOUND_ROWS tb1.user_id, user_country_city_name, user_search_pref, user_birthday, user_photo FROM `".PREFIX."_users` tb1, `".PREFIX."_friends` tb2 WHERE tb1.user_id = tb2.friend_id AND tb2.user_id = '{$get_user_id}' AND tb1.user_last_visit >= '{$online_time}' AND tb2.subscriptions = 0 {$sql_order} DESC LIMIT {$limit_page}{$gcount}"1);
                
                
//Выводим имя юзера
                
$friends_sql $db->super_query("SELECT user_name, user_friends_num FROM `".PREFIX."_users` WHERE user_id = '{$get_user_id}'");
                if(
$user_info['user_id'] != $get_user_id)
                    
$gram_name gramatikName($friends_sql['user_name']);
                else
                    
$gram_name 'Вас';
            
                if(
$sql_)
                    
//Кол-во друзей в онлайне
                    
$online_friends $db->super_query("SELECT COUNT(*) AS cnt FROM `".PREFIX."_users` tb1, `".PREFIX."_friends` tb2 WHERE tb1.user_id = tb2.friend_id AND tb2.user_id = '{$get_user_id}' AND tb1.user_last_visit >= '{$online_time}' AND tb2.subscriptions = 0");

                if(
$online_friends['cnt'])
                    
$user_speedbar 'У '.$gram_name.' '.$online_friends['cnt'].' '.gram_record($online_friends['cnt'], 'friends_online');
                else
                    
$user_speedbar $lang['no_requests_online'];
                    
                
//Верх
                
$tpl->load_template('friends/head.tpl');
                if(
$user_info['user_id'] != $get_user_id)
                    
$tpl->set('{name}'$gram_name);
                else
                    
$tpl->set('{name}''');
                    
                
$tpl->set('{user-id}'$get_user_id);
                if(
$get_user_id == $user_info['user_id']){
                    
$tpl->set('[owner]''');
                    
$tpl->set('[/owner]''');
                    
$tpl->set_block("'\[not-owner\](.*?)\[/not-owner\]'si","");
                    if(
$user_info['user_friends_demands'])
                        
$tpl->set('{demands}''('.$user_info['user_friends_demands'].')');
                    else
                        
$tpl->set('{demands}''');
                } else {
                    
$tpl->set('[not-owner]''');
                    
$tpl->set('[/not-owner]''');
                    
$tpl->set_block("'\[owner\](.*?)\[/owner\]'si","");
                }
                
$tpl->set('[online-friends]''');
                
$tpl->set('[/online-friends]''');
                
$tpl->set_block("'\[request-friends\](.*?)\[/request-friends\]'si","");
                
$tpl->set_block("'\[all-friends\](.*?)\[/all-friends\]'si","");
                
$tpl->compile('info');
                    
                if(
$sql_){
                    
$tpl->load_template('friends/friend.tpl');
                    foreach(
$sql_ as $row){
                        
$user_country_city_name explode('|'$row['user_country_city_name']);
                        
$tpl->set('{country}'$user_country_city_name[0]);
                        if(
$user_country_city_name[1])
                            
$tpl->set('{city}'', '.$user_country_city_name[1]);
                        else
                            
$tpl->set('{city}''');
                        
$tpl->set('{user-id}'$row['user_id']);
                        
$tpl->set('{name}'$row['user_search_pref']);
                        
                        if(
$row['user_photo'])
                            
$tpl->set('{ava}'$config['home_url'].'uploads/users/'.$row['user_id'].'/100_'.$row['user_photo']);
                        else
                            
$tpl->set('{ava}''{theme}/images/100_no_ava.png');
                        
                        
$tpl->set('{online}'$lang['online']);

                        
//Возраст юзера
                        
$user_birthday explode('-'$row['user_birthday']);
                        
$tpl->set('{age}'user_age($user_birthday[0], $user_birthday[1], $user_birthday[2]));

                        if(
$get_user_id == $user_info['user_id']){
                            
$tpl->set('[owner]''');
                            
$tpl->set('[/owner]''');
                        } else
                            
$tpl->set_block("'\[owner\](.*?)\[/owner\]'si","");
                            
                        if(
$row['user_id'] == $user_info['user_id'])
                            
$tpl->set_block("'\[viewer\](.*?)\[/viewer\]'si","");
                        else {
                            
$tpl->set('[viewer]''');
                            
$tpl->set('[/viewer]''');
                        }
        
                        
$tpl->compile('content');
                    }
                    
navigation($gcount$online_friends['cnt'], $config['home_url'].'friends/online/'.$get_user_id.'/page/');
                } else
                    
msgbox(''$lang['no_requests_online'], 'info_2');
            } else {
                
$user_speedbar $lang['error'];
                
msgbox(''$lang['no_notes'], 'info');
            }
        break;
        
        
//################### Загрузка друзей в окне для выбора СП ###################//
        
case "box":
            
NoAjaxQuery();

            
$user_id $user_info['user_id'];

            if(
$_POST['page'] > 0$page intval($_POST['page']); else $page 1;
            
$gcount 18;
            
$limit_page = ($page-1)*$gcount;

            if(
$_POST['user_sex'] == 1)
                
$sql_usSex 2;
            elseif(
$_POST['user_sex'] == 2)
                
$sql_usSex 1;
            else
                
$sql_usSex false;

            
//Все друзья
            
if($sql_usSex){
                
$count $db->super_query("SELECT COUNT(*) AS cnt FROM `".PREFIX."_friends` tb1, `".PREFIX."_users` tb2 WHERE tb1.user_id = '{$user_id}' AND tb1.friend_id = tb2.user_id AND tb1.subscriptions = 0 AND tb2.user_sex = '{$sql_usSex}'");
                
                if(
$count['cnt']){
                    
$sql_ $db->super_query("SELECT SQL_CALC_FOUND_ROWS tb1.friend_id, tb2.user_photo, user_search_pref FROM `".PREFIX."_friends` tb1, `".PREFIX."_users` tb2 WHERE tb1.user_id = '{$user_id}' AND tb1.friend_id = tb2.user_id AND tb1.subscriptions = 0 AND tb2.user_sex = '{$sql_usSex}' ORDER by `views` DESC LIMIT {$limit_page}{$gcount}"1);
                    
$tpl->load_template('friends/box_friend.tpl');
                    foreach(
$sql_ as $row){
                        
$tpl->set('{user-id}'$row['friend_id']);
                        
$tpl->set('{name}'$row['user_search_pref']);

                        if(
$row['user_photo'])
                            
$tpl->set('{ava}'$config['home_url'].'uploads/users/'.$row['friend_id'].'/50_'.$row['user_photo']);
                        else
                            
$tpl->set('{ava}''{theme}/images/100_no_ava.png');

                        
$tpl->compile('content');
                    }
                    
box_navigation($gcount$count['cnt'], "''"'sp.openfriends''');
                } else
                    
msgbox('''<div class="clear" style="margin-top:140px"></div>'.$lang['no_requests'], 'info_2');
            } else
                
msgbox('''<div class="clear" style="margin-top:140px"></div>'.$lang['no_requests'], 'info_2');

            
AjaxTpl();
            
            die();
        break;
        
            default:
                
                
//################### Просмотр всех друзей ###################//
                
$get_user_id intval($_GET['user_id']);
                if(!
$get_user_id)
                    
$get_user_id $user_info['user_id'];
                    
                
//ЧС
                
$CheckBlackList CheckBlackList($get_user_id);
                if(!
$CheckBlackList){
                    
//Выводим кол-во друзей из таблицы юзеров
                    
$friends_sql $db->super_query("SELECT user_name, user_friends_num FROM `".PREFIX."_users` WHERE user_id = '{$get_user_id}'");
                    
                    if(
$user_info['user_id'] != $get_user_id)
                        
$gram_name gramatikName($friends_sql['user_name']);
                    else
                        
$gram_name 'Вас';
                    
                    if(
$friends_sql['user_friends_num'])
                        
$user_speedbar 'У '.$gram_name.' <span id="friend_num">'.$friends_sql['user_friends_num'].'</span> '.gram_record($friends_sql['user_friends_num'], 'friends');
                    else
                        
$user_speedbar $lang['no_requests'];
                        
                    
//Верх
                    
$tpl->load_template('friends/head.tpl');
                    if(
$user_info['user_id'] != $get_user_id)
                        
$tpl->set('{name}'$gram_name);
                    else
                        
$tpl->set('{name}''');
                    
                    
$tpl->set('{user-id}'$get_user_id);
                    if(
$get_user_id == $user_info['user_id']){
                        
$tpl->set('[owner]''');
                        
$tpl->set('[/owner]''');
                        
$tpl->set_block("'\[not-owner\](.*?)\[/not-owner\]'si","");
                        if(
$user_info['user_friends_demands'])
                            
$tpl->set('{demands}''('.$user_info['user_friends_demands'].')');
                        else
                            
$tpl->set('{demands}''');
                    } else {
                        
$tpl->set('[not-owner]''');
                        
$tpl->set('[/not-owner]''');
                        
$tpl->set_block("'\[owner\](.*?)\[/owner\]'si","");
                    }
                        
                    
$tpl->set('[all-friends]''');
                    
$tpl->set('[/all-friends]''');
                    
$tpl->set_block("'\[request-friends\](.*?)\[/request-friends\]'si","");
                    
$tpl->set_block("'\[online-friends\](.*?)\[/online-friends\]'si","");
                    
$tpl->compile('info');
                        
                    
//Все друзья
                    
if($friends_sql['user_friends_num']){
                    
                        if(
$get_user_id == $user_info['user_id'])
                            
$sql_order "ORDER by `views`";
                        else
                            
$sql_order "ORDER by `friends_date`";
                        
                        
$sql_ $db->super_query("SELECT SQL_CALC_FOUND_ROWS tb1.friend_id, tb2.user_birthday, user_photo, user_search_pref, user_country_city_name, user_last_visit FROM `".PREFIX."_friends` tb1, `".PREFIX."_users` tb2 WHERE tb1.user_id = '{$get_user_id}' AND tb1.friend_id = tb2.user_id AND tb1.subscriptions = 0 {$sql_order} DESC LIMIT {$limit_page}{$gcount}"1);
                        if(
$sql_){
                            
$tpl->load_template('friends/friend.tpl');
                            foreach(
$sql_ as $row){
                                
$user_country_city_name explode('|'$row['user_country_city_name']);
                                
$tpl->set('{country}'$user_country_city_name[0]);
                                    
                                if(
$user_country_city_name[1])
                                    
$tpl->set('{city}'', '.$user_country_city_name[1]);
                                else
                                    
$tpl->set('{city}''');
                                        
                                
$tpl->set('{user-id}'$row['friend_id']);
                                
$tpl->set('{name}'$row['user_search_pref']);
                                    
                                if(
$row['user_photo'])
                                    
$tpl->set('{ava}'$config['home_url'].'uploads/users/'.$row['friend_id'].'/100_'.$row['user_photo']);
                                else
                                    
$tpl->set('{ava}''{theme}/images/100_no_ava.png');
                                
                                if(
$row['user_last_visit'] >= $online_time)
                                    
$tpl->set('{online}'$lang['online']);
                                else
                                    
$tpl->set('{online}''');
                                
                                
//Возраст юзера
                                
$user_birthday explode('-'$row['user_birthday']);
                                
$tpl->set('{age}'user_age($user_birthday[0], $user_birthday[1], $user_birthday[2]));

                                if(
$get_user_id == $user_info['user_id']){
                                    
$tpl->set('[owner]''');
                                    
$tpl->set('[/owner]''');
                                } else
                                    
$tpl->set_block("'\[owner\](.*?)\[/owner\]'si","");
                                    
                                if(
$row['friend_id'] == $user_info['user_id'])
                                    
$tpl->set_block("'\[viewer\](.*?)\[/viewer\]'si","");
                                else {
                                    
$tpl->set('[viewer]''');
                                    
$tpl->set('[/viewer]''');
                                }

                                
$tpl->compile('content');
                            }
                            
navigation($gcount$friends_sql['user_friends_num'], $config['home_url'].'friends/'.$get_user_id.'/page/');
                        } else
                            
msgbox(''$lang['no_requests'], 'info_2');
                    } else
                        
msgbox(''$lang['no_requests'], 'info_2');
                } else {
                    
$user_speedbar $lang['error'];
                    
msgbox(''$lang['no_notes'], 'info');
                }
    }
    
$db->free();
    
$tpl->clear();
} else {
    
$user_speedbar 'Информация';
    
msgbox(''$lang['not_logged'], 'info');
}
?>
Онлайн: 1
Реклама