Remove unused local variables

[GitHub/WoltLab/WCF.git] / wcfsetup / install / files / lib / acp / page / UserListPage.class.php

diff --git a/wcfsetup/install/files/lib/acp/page/UserListPage.class.php b/wcfsetup/install/files/lib/acp/page/UserListPage.class.php
index cd83e43e86f0a59acc63d26baa159cdac4f032ad..2fef97bcabcf0a7b6f08ad7e888007c466dd23f0 100755 (executable)
--- a/wcfsetup/install/files/lib/acp/page/UserListPage.class.php
+++ b/wcfsetup/install/files/lib/acp/page/UserListPage.class.php
@@ -260,7 +260,10 @@ class UserListPage extends SortablePage
         // get user ids
         $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_table.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(
@@ -287,9 +290,9 @@ class UserListPage extends SortablePage
             $sql = "SELECT      user_avatar.*, option_value.*, user_table.*
                     FROM        wcf" . WCF_N . "_user user_table
                     LEFT JOIN   wcf" . WCF_N . "_user_option_value option_value
-                    ON          (option_value.userID = user_table.userID)
+                    ON          option_value.userID = user_table.userID
                     LEFT JOIN   wcf" . WCF_N . "_user_avatar user_avatar
-                    ON          (user_avatar.avatarID = user_table.avatarID)
+                    ON          user_avatar.avatarID = user_table.avatarID
                     " . $conditions . "
                     ORDER BY    " . (($this->sortField != 'email' && isset($this->options[$this->sortField])) ? 'option_value.userOption' . $this->options[$this->sortField]->optionID : 'user_table.' . $this->sortField) . " " . $this->sortOrder;
             $statement = WCF::getDB()->prepareStatement($sql);
@@ -310,7 +313,7 @@ class UserListPage extends SortablePage
             }
 
             // get special columns
-            foreach ($this->users as $key => $user) {
+            foreach ($this->users as $user) {
                 foreach ($this->columns as $column) {
                     switch ($column) {
                         case 'email':