Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $sql = "SELECT session.requestURI,
- session.requestMethod,
- session.ipAddress,
- session.userAgent,
- rank.*,
- avatar.*,
- GROUP_CONCAT(DISTINCT groups.groupID ORDER BY groups.groupID ASC SEPARATOR ',') AS groupIDs,
- GROUP_CONCAT(DISTINCT languages.languageID ORDER BY languages.languageID ASC SEPARATOR ',') AS languageIDs,
- user_option.*,
- user.*
- FROM wcf".WCF_N."_user user
- LEFT JOIN wcf".WCF_N."_avatar avatar
- ON (avatar.avatarID = user.avatarID)
- LEFT JOIN wcf".WCF_N."_session session
- ON (session.userID = user.userID
- AND session.packageID = ".PACKAGE_ID."
- AND session.lastActivityTime > ".(TIME_NOW - USER_ONLINE_TIMEOUT).")
- LEFT JOIN wcf".WCF_N."_user_rank rank
- ON (rank.rankID = user.rankID)
- LEFT JOIN wcf".WCF_N."_user_to_groups groups
- ON (groups.userID = user.userID)
- LEFT JOIN wcf".WCF_N."_user_to_languages languages
- ON (languages.userID = user.userID)
- LEFT JOIN wcf".WCF_N."_user_option_value user_option
- ON (user_option.userID = user.userID)
- WHERE user.userID IN (0,".implode(',', $this->getOwnerIDs()).")
- GROUP BY user.userID";
Advertisement
Add Comment
Please, Sign In to add comment