Просмотр файла includes/friends_foes.php

<?php
/***************************************************************************
 *                                mides.ru
 *                            -------------------
 ***************************************************************************/
@$site = @$_GET['site'];
if ( !defined('IN_PHPBB') )
{
        die("Hacking attempt");
        exit;
}
   include('page_header.'.$phpEx);
        $template->set_filenames(array(
                'body' => 'friends_foes.tpl')
        );
 
        if($_GET['view'] == 'friends') {
        $sql = 'SELECT u.username, u.user_nic_color, u.user_posts, f.friend_id FROM '.FRIENDS_TABLE.' f, '.USERS_TABLE.' u
        WHERE f.user_id = '.$_GET['u'].'
        AND u.user_id = f.friend_id';
 
        if (!$result = $db->sql_query($sql))
        {
                message_die(GENERAL_ERROR, 'Could not obtain friends information', '', __LINE__, __FILE__, $sql);
        }
 
        $n = 0;
        $friends_list = '';
        $result = $db->sql_query($sql);
        $type = $lang['Friends'];
        while( $friends = $db->sql_fetchrow($result) )
        {
	            $on_sql = "SELECT session_logged_in FROM ".SESSIONS_TABLE." WHERE session_user_id = ".$friends['friend_id'];
				$on_result = $db->sql_query($on_sql);
				$on = $db->sql_fetchrow($on_result);
                if($on['session_logged_in'] == 1) $stat = '<span style="color: #0fff0f">(On)</span>';
                else $stat = '<span style="color: #b40000">(Off)</span>';				
                if ( $userdata['user_id'] == $_GET['u'] )$del_friend = '<a href=profile.'.$phpEx.'?mode=delet&friend='.$friends['friend_id'].'>'.$lang['del_from_friends'].'</a>';
                $list .= "<tr><td class=row1><a href=profile.$phpEx?mode=viewprofile&u=$friends[friend_id]>
				<span style=color:$friends[user_nic_color]>$friends[username]</span></a>[$friends[user_posts]]$stat $del_friend</td></tr>";
         $i++;
        }}
        
        if($_GET['view'] == 'foes') {
  $sql2 = 'SELECT u.username, u.user_nic_color, u.user_posts, f.foe_id FROM '.FOES_TABLE.' f, '.USERS_TABLE.' u
        WHERE f.user_id = '.$_GET['u'].'
        AND u.user_id = f.foe_id';
		
        if (!$result = $db->sql_query($sql))
        {
                message_die(GENERAL_ERROR, 'Could not obtain foes information', '', __LINE__, __FILE__, $sql);
        }
        $result = $db->sql_query($sql2);
        $foes_list = '';
        $type = $lang['Foes'];
 
        while( $foes = $db->sql_fetchrow($result) )
        {	
		        $on_sql = "SELECT session_logged_in FROM ".SESSIONS_TABLE." WHERE session_user_id = ".$foes['foe_id'];
				$on_result = $db->sql_query($on_sql);
				$on = $db->sql_fetchrow($on_result);
                if($on['session_logged_in'] == 1) $stat = '<span style="color: #0fff0f">(On)</span>';
                else $stat = '<span style="color: #b40000">(Off)</span>';
                if ( $userdata['user_id'] == $_GET['u'] )$del_foe = '<a href=profile.'.$phpEx.'?mode=delet&foe='.$foes['foe_id'].'>'.$lang['del_from_foes'].'</a>';
				$list .= "<tr><td class=row1><a href=profile.$phpEx?mode=viewprofile&u=$foes[foe_id]>
				<span style=color:$foes[user_nic_color]>$foes[username]</span></a>[$foes[user_posts]]$stat $del_foe</td></tr>";
                $i++;
        }}
       if($i == null) {
               if($_GET['view'] == 'foes') { $i=0 ; $list = '<tr><td class=row1>'.$lang['No_foes'].'</td></tr>'; }
               if($_GET['view'] == 'friends') { $i=0; $list = '<tr><td class=row1>'.$lang['No_friends'].'</td></tr>'; }
       }
        $template->assign_vars(array(
                'LIST' => $list,
                'TOTAL' => $i,
                'L_TYPE' => $type)
        );
 
        $template->pparse('body');
        include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>