Download & Extend

why in the sql is used access <>0

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

Category:task» support request
Status:active» fixed

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

Status:fixed» closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.