Closed (fixed)
Project:
User List
Version:
5.x-1.x-dev
Component:
Miscellaneous
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
31 Dec 2008 at 02:38 UTC
Updated:
19 Jan 2009 at 17:30 UTC
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
Comment #1
deekayen commentedstatus = 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.