diff options
| -rw-r--r-- | modules/profile/profile.module | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/modules/profile/profile.module b/modules/profile/profile.module index a96b4629e..2e2e48b0b 100644 --- a/modules/profile/profile.module +++ b/modules/profile/profile.module @@ -466,7 +466,7 @@ function profile_browse() { } // Extract the affected users: - $result = pager_query("SELECT u.uid, u.access FROM {users} u INNER JOIN {profile_values} v ON u.uid = v.uid WHERE v.fid = %d AND $query ORDER BY u.access DESC", 20, 0, NULL, $arguments); + $result = pager_query('SELECT u.uid, u.access FROM {users} u INNER JOIN {profile_values} v ON u.uid = v.uid WHERE v.fid = %d AND $query AND u.access != 0 AND u.status != 0 ORDER BY u.access DESC', 20, 0, NULL, $arguments); $output = '<div id="profile">'; while ($account = db_fetch_object($result)) { @@ -499,7 +499,7 @@ function profile_browse() { } // Extract the affected users: - $result = pager_query("SELECT uid, access FROM {users} WHERE uid > 0 AND status != 0 ORDER BY access DESC", 20, 0, NULL); + $result = pager_query('SELECT uid, access FROM {users} WHERE uid > 0 AND status != 0 AND access != 0 ORDER BY access DESC', 20, 0, NULL); $output = '<div id="profile">'; while ($account = db_fetch_object($result)) { |