Posted by alb on December 31, 2008 at 2:38am
Jump to:
| Project: | User List |
| Version: | 5.x-1.x-dev |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
In the query for to create th users list the sql is filtered also by the u.access <> 0;
but when an user have the access = 0?
and status=0 is when the user is blocked?
code example:
$result = pager_query("SELECT u.uid, u.name FROM {users} u WHERE u.status <> 0 AND u.access <> 0 AND LOWER(u.name) LIKE '%s%%' ORDER BY u.name ASC", $number, $element_override, NULL, drupal_strtolower($op));
Comments
#1
status = 0 is a blocked user
access = 0 is a user that never logged in
That example will not show users who are blocked or who have never logged in.
#2
Automatically closed -- issue fixed for two weeks with no activity.