Friend Module BuG searched&destroyed :)

Register an Account
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old 09-08-2007, 02:22 PM
AnAlienHolakres3's Avatar
Pligg Donor/Coder
 
Join Date: Jul 2007
Location: Prague
Posts: 116
Send a message via ICQ to 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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Upload Module (File and Image Attachment) Yankidank Free Modules 268 02-03-2012 12:19 PM
Fixes to Profile Extra Fields Module v0.2 and Extended Profile Module v0.1 redwine Questions and Comments 11 12-20-2010 04:18 PM
Friend List or Banners Module ArthurCro Questions and Comments 1 05-07-2009 01:28 AM
Lightbox module is hanging when sending a msg to a friend elquiosco Questions and Comments 2 03-24-2007 07:50 PM


Pligg Modules and Pligg Templates from Pligg Pro Find support on the Pligg CMS Forum - 24 hours a day! Make a donation to support Pligg CMS development