/** * @see \wcf\data\DatabaseObjectList::__construct() */ public function __construct() { parent::__construct(); $this->sqlSelects .= "user_table.username, user_table.email, user_table.disableAvatar, user_table.enableGravatar, user_table.gravatarFileExtension"; $this->sqlSelects .= ", user_avatar.*"; $this->sqlJoins .= " LEFT JOIN wcf" . WCF_N . "_user user_table ON (user_table.userID = user_follow.userID)"; $this->sqlJoins .= " LEFT JOIN wcf" . WCF_N . "_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID)"; }
/** * @see \wcf\data\DatabaseObjectList::__construct() */ public function __construct() { UserFollowList::__construct(); $this->sqlSelects .= "user_avatar.*, user_follow.followID, user_option_value.*"; $this->sqlJoins .= " LEFT JOIN wcf" . WCF_N . "_user user_table ON (user_table.userID = user_follow.followUserID)"; $this->sqlJoins .= " LEFT JOIN wcf" . WCF_N . "_user_option_value user_option_value ON (user_option_value.userID = user_table.userID)"; $this->sqlJoins .= " LEFT JOIN wcf" . WCF_N . "_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID)"; if (MODULE_USER_RANK) { $this->sqlSelects .= ",user_rank.*"; $this->sqlJoins .= " LEFT JOIN wcf" . WCF_N . "_user_rank user_rank ON (user_rank.rankID = user_table.rankID)"; } $this->sqlSelects .= ", user_table.*"; }