| 144 | | $sql = "SELECT option_value.*, user.*, |
| 145 | | GROUP_CONCAT(groupID SEPARATOR ',') AS groupIDs |
| 146 | | FROM wcf".WCF_N."_user user |
| 147 | | LEFT JOIN wcf".WCF_N."_user_option_value option_value |
| 148 | | ON (option_value.userID = user.userID) |
| 149 | | LEFT JOIN wcf".WCF_N."_user_to_groups groups |
| 150 | | ON (groups.userID = user.userID) |
| 151 | | WHERE user.userID IN (".implode(',', $userIDs).") |
| 152 | | GROUP BY user.userID |
| 153 | | ORDER BY user.".$this->sortField." ".$this->sortOrder; |
| 154 | | $result = WCF::getDB()->sendQuery($sql); |
| 155 | | while ($row = WCF::getDB()->fetchArray($result)) { |
| 156 | | $accessible = Group::isAccessibleGroup(explode(',', $row['groupIDs'])); |
| 157 | | $row['accessible'] = $accessible; |
| 158 | | $row['deletable'] = ($accessible && WCF::getUser()->getPermission('admin.user.canDeleteUser') && $row['userID'] != WCF::getUser()->userID) ? 1 : 0; |
| 159 | | $row['editable'] = ($accessible && WCF::getUser()->getPermission('admin.user.canEditUser')) ? 1 : 0; |
| 160 | | $row['isMarked'] = intval(in_array($row['userID'], $this->markedUsers)); |
| | 144 | if ($userIDs != 0){ |
| | 145 | $sql = "SELECT option_value.*, user.*, |
| | 146 | GROUP_CONCAT(groupID SEPARATOR ',') AS groupIDs |
| | 147 | FROM wcf".WCF_N."_user user |
| | 148 | LEFT JOIN wcf".WCF_N."_user_option_value option_value |
| | 149 | ON (option_value.userID = user.userID) |
| | 150 | LEFT JOIN wcf".WCF_N."_user_to_groups groups |
| | 151 | ON (groups.userID = user.userID) |
| | 152 | WHERE user.userID IN (".implode(',', $userIDs).") |
| | 153 | GROUP BY user.userID |
| | 154 | ORDER BY user.".$this->sortField." ".$this->sortOrder; |
| | 155 | $result = WCF::getDB()->sendQuery($sql); |
| | 156 | while ($row = WCF::getDB()->fetchArray($result)) { |
| | 157 | $accessible = Group::isAccessibleGroup(explode(',', $row['groupIDs'])); |
| | 158 | $row['accessible'] = $accessible; |
| | 159 | $row['deletable'] = ($accessible && WCF::getUser()->getPermission('admin.user.canDeleteUser') && $row['userID'] != WCF::getUser()->userID) ? 1 : 0; |
| | 160 | $row['editable'] = ($accessible && WCF::getUser()->getPermission('admin.user.canEditUser')) ? 1 : 0; |
| | 161 | $row['isMarked'] = intval(in_array($row['userID'], $this->markedUsers)); |
