From 991c7b8dc1eb343b5aef1b217e69dc84ab36787e Mon Sep 17 00:00:00 2001 From: Matthias Schmidt Date: Wed, 4 Jan 2012 10:10:13 +0100 Subject: [PATCH] Fixes wrong table alias in UserListPage --- wcfsetup/install/files/lib/acp/page/UserListPage.class.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/wcfsetup/install/files/lib/acp/page/UserListPage.class.php b/wcfsetup/install/files/lib/acp/page/UserListPage.class.php index 5610ac666e..8b18a66d24 100755 --- a/wcfsetup/install/files/lib/acp/page/UserListPage.class.php +++ b/wcfsetup/install/files/lib/acp/page/UserListPage.class.php @@ -171,7 +171,7 @@ class UserListPage extends SortablePage { $userIDs = array(); $sql = "SELECT user_table.userID FROM wcf".WCF_N."_user user_table - ".(isset($this->options[$this->sortField]) ? "LEFT JOIN wcf".WCF_N."_user_option_value user_option_value ON (user_option_value.userID = user.userID)" : '')." + ".(isset($this->options[$this->sortField]) ? "LEFT JOIN wcf".WCF_N."_user_option_value user_option_value ON (user_option_value.userID = user_table.userID)" : '')." ".$this->conditions." ORDER BY ".(($this->sortField != 'email' && isset($this->options[$this->sortField])) ? 'user_option_value.userOption'.$this->options[$this->sortField]['optionID'] : $this->sortField)." ".$this->sortOrder; $statement = WCF::getDB()->prepareStatement($sql, $this->itemsPerPage, ($this->pageNo - 1) * $this->itemsPerPage); -- 2.20.1