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.