Advertisement
Guest User

Untitled

a guest
Apr 30th, 2017
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.68 KB | None | 0 0
  1. L. 154
  2.  
  3. function getFriendsList($userid,$time) {
  4. global $hideOffline;
  5. $offlinecondition = '';
  6. $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");
  7.  
  8. In particolare aggiungere
  9. AND ".TABLE_PREFIX."friend.is_page = '0')
  10. dopo "friend.user_id=" e il resto del comando SQL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement