From 90b527352397d36495e4d5720f3c4ff018b4ab00 Mon Sep 17 00:00:00 2001 From: Marcel Werk Date: Wed, 12 Jun 2013 16:15:28 +0200 Subject: [PATCH] Small optimization --- .../files/lib/system/option/UseroptionsOptionType.class.php | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/wcfsetup/install/files/lib/system/option/UseroptionsOptionType.class.php b/wcfsetup/install/files/lib/system/option/UseroptionsOptionType.class.php index 00416274be..0b6be51580 100644 --- a/wcfsetup/install/files/lib/system/option/UseroptionsOptionType.class.php +++ b/wcfsetup/install/files/lib/system/option/UseroptionsOptionType.class.php @@ -66,7 +66,11 @@ class UseroptionsOptionType extends AbstractOptionType { self::$userOptions = array(); $sql = "SELECT optionName FROM wcf".WCF_N."_user_option - WHERE categoryName LIKE 'profile%' + WHERE categoryName IN ( + SELECT categoryName + FROM wcf".WCF_N."_user_option_category + WHERE parentCategoryName = 'profile' + ) AND optionType <> 'boolean'"; $statement = WCF::getDB()->prepareStatement($sql); $statement->execute(); -- 2.20.1