ArrowChat

Open up your includes/functions_receive.php file in a text editor.

Find:

Code: Select all

function getFriendsList($userid,$time)

Replace everything after the FROM in the $sql variable with:

Code: Select all

      FROM ".TABLE_PREFIX.DB_USERTABLE." 
      JOIN arrowchat_status 
         ON ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." = arrowchat_status.userid 
      WHERE ('".time()."'-arrowchat_status.session_time - 60 < '".$online_timeout."') 
         AND ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." <> '".$userid."' 
      ORDER BY ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_NAME." ASC");

For example if you had:

Code: Select all

   $sql = ("SELECT DISTINCT ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." userid, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_NAME." username, arrowchat_status.session_time lastactivity, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_AVATAR." avatar, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." link, arrowchat_status.message, arrowchat_status.status 
      FROM ".TABLE_PREFIX.DB_FRIENDSTABLE." 
      JOIN ".TABLE_PREFIX.DB_USERTABLE." 
         ON  ".TABLE_PREFIX.DB_FRIENDSTABLE.".".DB_FRIENDSTABLE_FRIENDID." = ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." 
      LEFT JOIN arrowchat_status 
         ON ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." = arrowchat_status.userid 
      WHERE ".TABLE_PREFIX.DB_FRIENDSTABLE.".".DB_FRIENDSTABLE_USERID." = '".mysql_real_escape_string($userid)."' 
         AND ".TABLE_PREFIX.DB_FRIENDSTABLE.".".DB_FRIENDSTABLE_FRIENDS." = 1 
         AND (arrowchat_status.session_time + 60 + ".$online_timeout.") > ".time()." 
      ORDER BY ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_NAME." ASC");

Your new variable would be:

Code: Select all

   $sql = ("SELECT DISTINCT ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." userid, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_NAME." username, arrowchat_status.session_time lastactivity, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_AVATAR." avatar, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." link, arrowchat_status.message, arrowchat_status.status 
      FROM ".TABLE_PREFIX.DB_USERTABLE." 
      JOIN arrowchat_status 
         ON ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." = arrowchat_status.userid 
      WHERE ('".time()."'-arrowchat_status.session_time - 60 < '".$online_timeout."') 
         AND ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." <> '".$userid."' 
      ORDER BY ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_NAME." ASC");

This is just a temporary solution until the feature is fully integrated via the admin panel.

thank you worked great

why delete my post ?

MMoazzeni wrote:why delete my post ?

Your are bumping a highly irrelevant thread from over a year ago. This feature has been implemented for some time.