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

deekayen - January 5, 2009 - 17:30
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

System Message - January 19, 2009 - 17:30
Status:fixed» closed

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

 
 

Drupal is a registered trademark of Dries Buytaert.