Пример #1
0
	/**
	 * @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)";
	}
Пример #2
0
 /**
  * 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)";
 }
Пример #3
0
 /**
  * @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)";
 }