/**
* @see UserSession::__construct()
*/
public function __construct($userID = null, $row = null, $username = null)
{
$this->sqlSelects .= "\twbb_user.*, avatar.*, wbb_user.userID AS wbbUserID,\n\t\t\t\t\tGROUP_CONCAT(DISTINCT whitelist.whiteUserID ORDER BY whitelist.whiteUserID ASC SEPARATOR ',') AS buddies,\n\t\t\t\t\tGROUP_CONCAT(DISTINCT blacklist.blackUserID ORDER BY blacklist.blackUserID ASC SEPARATOR ',') AS ignoredUser,\n\t\t\t\t\t(SELECT COUNT(*) FROM wcf" . WCF_N . "_user_whitelist WHERE whiteUserID = user.userID AND confirmed = 0 AND notified = 0) AS numberOfInvitations,";
$this->sqlJoins .= " \tLEFT JOIN wbb" . WBB_N . "_user wbb_user ON (wbb_user.userID = user.userID)\n\t\t\t\t\tLEFT JOIN wcf" . WCF_N . "_user_whitelist whitelist ON (whitelist.userID = user.userID AND whitelist.confirmed = 1)\n\t\t\t\t\tLEFT JOIN wcf" . WCF_N . "_user_blacklist blacklist ON (blacklist.userID = user.userID)\n\t\t\t\t\tLEFT JOIN wcf" . WCF_N . "_avatar avatar ON (avatar.avatarID = user.avatarID) ";
parent::__construct($userID, $row, $username);
}
