/** * @see wcf\data\DatabaseObjectList::__construct() */ public function __construct() { parent::__construct(); if (!empty($this->sqlSelects)) $this->sqlSelects .= ','; $this->sqlSelects .= "user_option_value.*"; $this->sqlJoins .= " LEFT JOIN wcf".WCF_N."_user_option_value user_option_value ON (user_option_value.userID = user_table.userID)"; }
/** * Creates a new TemplateList object. */ public function __construct() { parent::__construct(); $this->sqlSelects = 'package.package, template_group.templateGroupFolderName'; $this->sqlJoins = " LEFT JOIN wcf" . WCF_N . "_package package ON (package.packageID = template.packageID)"; $this->sqlJoins .= " LEFT JOIN wcf" . WCF_N . "_template_group template_group ON (template_group.templateGroupID = template.templateGroupID)"; }
/** * @see \wcf\data\DatabaseObjectList::__construct() */ public function __construct($useSqlOr = false) { parent::__construct(); if ($useSqlOr) { $this->conditionBuilder = new PreparedStatementConditionBuilder(true, 'OR'); } }
/** * @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_profile_visitor.userID)"; $this->sqlJoins .= " LEFT JOIN wcf" . WCF_N . "_user_avatar user_avatar ON (user_avatar.avatarID = user_table.avatarID)"; }