0xLeon

WCF User Profile Query

Dec 14th, 2012
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.09 KB | None | 0 0
  1. $sql = "SELECT      session.requestURI,
  2.             session.requestMethod,
  3.             session.ipAddress,
  4.             session.userAgent,
  5.             rank.*,
  6.             avatar.*,
  7.             GROUP_CONCAT(DISTINCT groups.groupID ORDER BY groups.groupID ASC SEPARATOR ',') AS groupIDs,
  8.             GROUP_CONCAT(DISTINCT languages.languageID ORDER BY languages.languageID ASC SEPARATOR ',') AS languageIDs,
  9.             user_option.*,
  10.             user.*
  11.     FROM        wcf".WCF_N."_user user
  12.     LEFT JOIN   wcf".WCF_N."_avatar avatar
  13.     ON      (avatar.avatarID = user.avatarID)
  14.     LEFT JOIN   wcf".WCF_N."_session session
  15.     ON      (session.userID = user.userID
  16.             AND session.packageID = ".PACKAGE_ID."
  17.             AND session.lastActivityTime > ".(TIME_NOW - USER_ONLINE_TIMEOUT).")
  18.     LEFT JOIN   wcf".WCF_N."_user_rank rank
  19.     ON      (rank.rankID = user.rankID)
  20.     LEFT JOIN   wcf".WCF_N."_user_to_groups groups
  21.     ON      (groups.userID = user.userID)
  22.     LEFT JOIN   wcf".WCF_N."_user_to_languages languages
  23.     ON      (languages.userID = user.userID)
  24.     LEFT JOIN   wcf".WCF_N."_user_option_value user_option
  25.     ON      (user_option.userID = user.userID)
  26.     WHERE       user.userID IN (0,".implode(',', $this->getOwnerIDs()).")
  27.     GROUP BY    user.userID";
Advertisement
Add Comment
Please, Sign In to add comment