thorsten /
phpMyFAQ
| @@ 952-981 (lines=30) @@ | ||
| 949 | * |
|
| 950 | * @return array |
|
| 951 | */ |
|
| 952 | public function getAllUsers($withoutAnonymous = true, $allowBlockedUsers = true) |
|
| 953 | { |
|
| 954 | $select = sprintf(' |
|
| 955 | SELECT |
|
| 956 | user_id |
|
| 957 | FROM |
|
| 958 | %sfaquser |
|
| 959 | WHERE |
|
| 960 | 1 = 1 |
|
| 961 | %s |
|
| 962 | %s |
|
| 963 | ORDER BY |
|
| 964 | user_id ASC', |
|
| 965 | Db::getTablePrefix(), |
|
| 966 | ($withoutAnonymous ? 'AND user_id <> -1' : ''), |
|
| 967 | ($allowBlockedUsers ? '' : "AND account_status != 'blocked'") |
|
| 968 | ); |
|
| 969 | ||
| 970 | $res = $this->config->getDb()->query($select); |
|
| 971 | if (!$res) { |
|
| 972 | return []; |
|
| 973 | } |
|
| 974 | ||
| 975 | $result = []; |
|
| 976 | while ($row = $this->config->getDb()->fetchArray($res)) { |
|
| 977 | $result[] = $row['user_id']; |
|
| 978 | } |
|
| 979 | ||
| 980 | return $result; |
|
| 981 | } |
|
| 982 | ||
| 983 | /** |
|
| 984 | * Returns an array of all users found in the database. By default, the |
|
| @@ 993-1017 (lines=25) @@ | ||
| 990 | * |
|
| 991 | * @return array |
|
| 992 | */ |
|
| 993 | public function getAllUserData($withoutAnonymous = true) |
|
| 994 | { |
|
| 995 | $select = sprintf(' |
|
| 996 | SELECT |
|
| 997 | user_id, login, account_status, auth_source, member_since |
|
| 998 | FROM |
|
| 999 | %sfaquser |
|
| 1000 | %s |
|
| 1001 | ORDER BY |
|
| 1002 | login ASC', |
|
| 1003 | Db::getTablePrefix(), |
|
| 1004 | ($withoutAnonymous ? 'WHERE user_id <> -1' : '')); |
|
| 1005 | ||
| 1006 | $res = $this->config->getDb()->query($select); |
|
| 1007 | if (!$res) { |
|
| 1008 | return []; |
|
| 1009 | } |
|
| 1010 | ||
| 1011 | $result = []; |
|
| 1012 | while ($row = $this->config->getDb()->fetchArray($res)) { |
|
| 1013 | $result[$row['user_id']] = $row; |
|
| 1014 | } |
|
| 1015 | ||
| 1016 | return $result; |
|
| 1017 | } |
|
| 1018 | ||
| 1019 | /** |
|
| 1020 | * Get all users in <option> tags. |
|
