/**
* @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)";
}