thorsten /
phpMyFAQ
| @@ 865-889 (lines=25) @@ | ||
| 862 | * @param boolean $withoutAnonymous Without anonymous? |
|
| 863 | * @return array |
|
| 864 | */ |
|
| 865 | public function getAllUsers($withoutAnonymous = true) |
|
| 866 | { |
|
| 867 | $select = sprintf(" |
|
| 868 | SELECT |
|
| 869 | user_id |
|
| 870 | FROM |
|
| 871 | %sfaquser |
|
| 872 | %s |
|
| 873 | ORDER BY user_id ASC", |
|
| 874 | PMF_Db::getTablePrefix(), |
|
| 875 | ($withoutAnonymous ? 'WHERE user_id <> -1' : '') |
|
| 876 | ); |
|
| 877 | ||
| 878 | $res = $this->config->getDb()->query($select); |
|
| 879 | if (!$res) { |
|
| 880 | return []; |
|
| 881 | } |
|
| 882 | ||
| 883 | $result = []; |
|
| 884 | while ($row = $this->config->getDb()->fetchArray($res)) { |
|
| 885 | $result[] = $row['user_id']; |
|
| 886 | } |
|
| 887 | ||
| 888 | return $result; |
|
| 889 | } |
|
| 890 | ||
| 891 | /** |
|
| 892 | * Returns an array of all users found in the database. By default, the |
|
| @@ 900-924 (lines=25) @@ | ||
| 897 | * @param boolean $withoutAnonymous Without anonymous? |
|
| 898 | * @return array |
|
| 899 | */ |
|
| 900 | public function getAllUserData($withoutAnonymous = true) |
|
| 901 | { |
|
| 902 | $select = sprintf(" |
|
| 903 | SELECT |
|
| 904 | user_id, login, account_status, auth_source, member_since |
|
| 905 | FROM |
|
| 906 | %sfaquser |
|
| 907 | %s |
|
| 908 | ORDER BY |
|
| 909 | login ASC", |
|
| 910 | PMF_Db::getTablePrefix(), |
|
| 911 | ($withoutAnonymous ? 'WHERE user_id <> -1' : '')); |
|
| 912 | ||
| 913 | $res = $this->config->getDb()->query($select); |
|
| 914 | if (!$res) { |
|
| 915 | return []; |
|
| 916 | } |
|
| 917 | ||
| 918 | $result = []; |
|
| 919 | while ($row = $this->config->getDb()->fetchArray($res)) { |
|
| 920 | $result[$row['user_id']] = $row; |
|
| 921 | } |
|
| 922 | ||
| 923 | return $result; |
|
| 924 | } |
|
| 925 | ||
| 926 | /** |
|
| 927 | * Get all users in <option> tags |
|
