Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- L. 154
- function getFriendsList($userid,$time) {
- global $hideOffline;
- $offlinecondition = '';
- $sql = ("select DISTINCT ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." userid, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_NAME." username, ".DB_LINKFIELD." link, ".DB_AVATARFIELD." avatar, cometchat_status.lastactivity lastactivity, cometchat_status.lastseen lastseen, cometchat_status.lastseensetting lastseensetting, cometchat_status.status, cometchat_status.message message, cometchat_status.isdevice from ".TABLE_PREFIX.DB_USERTABLE." left join cometchat_status on ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." = cometchat_status.userid where ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." NOT IN (select ".TABLE_PREFIX."user_blocked.block_user_id from ".TABLE_PREFIX."user_blocked where user_id = '".mysqli_real_escape_string($GLOBALS['dbh'],$userid)."' UNION select ".TABLE_PREFIX."user_blocked.user_id from ".TABLE_PREFIX."user_blocked where block_user_id = '".mysqli_real_escape_string($GLOBALS['dbh'],$userid)."') AND ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." IN (select ".TABLE_PREFIX."friend.friend_user_id from ".TABLE_PREFIX."friend where ".TABLE_PREFIX."friend.user_id = '".mysqli_real_escape_string($GLOBALS['dbh'],$userid)."' AND ".TABLE_PREFIX."friend.is_page = '0') AND ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." IN (select ".TABLE_PREFIX."friend.user_id from ".TABLE_PREFIX."friend where ".TABLE_PREFIX."friend.friend_user_id = '".mysqli_real_escape_string($GLOBALS['dbh'],$userid)."') ".DB_AVATARTABLE." order by username asc");
- In particolare aggiungere
- AND ".TABLE_PREFIX."friend.is_page = '0')
- dopo "friend.user_id=" e il resto del comando SQL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement