Friend Module BuG searched&destroyed :)

[AnAlienHolakres3]

Hello folks, i´ve discovered that "show me users who added you as a friend" button does not work correctly, beceause when you deleted user who selected you as a friend, this user was not in list of "show me users who added you as a friend" anymore.

I did some check and there is a solution: Open your friend.php in your libs folder and replace function get_friend_list2 with this:

PHP Code:

function get_friend_list_2()
    {
        // returns an array of people who have added you as a friend
        global $db, $current_user;
        $friends = $db->get_results("SELECT " . table_users . ".user_login, " . table_users . ".user_avatar_source, " . table_users . ".user_email, " . table_users . ".user_id , " .table_users . ".user_lastactivity , " . table_users . ".user_logged_in FROM " . table_friends . " INNER JOIN " . table_users . " ON " . table_friends . ".friend_from = " . table_users . ".user_id WHERE ((" . table_friends . ".friend_to)= " . $current_user->user_id . ")");
        return $friends;
    } 


There was an error with JOIN.
Hope it helps someone