why in the sql is used access <>0
alb - December 31, 2008 - 02:38
| Project: | User List |
| Version: | 5.x-1.x-dev |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
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));

#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.