From ecf6c8de03e303e4da1bad39450483528ca136fd Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?G=C3=A1bor=20Hojtsy?= Date: Sat, 10 Nov 2007 10:15:21 +0000 Subject: #165924 by odious and drumm: add count query for pager in user_admin_account() --- modules/user/user.admin.inc | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'modules') diff --git a/modules/user/user.admin.inc b/modules/user/user.admin.inc index 2076e7a41..8fb427c24 100644 --- a/modules/user/user.admin.inc +++ b/modules/user/user.admin.inc @@ -141,7 +141,8 @@ function user_admin_account() { $sql = 'SELECT DISTINCT u.uid, u.name, u.status, u.created, u.access FROM {users} u LEFT JOIN {users_roles} ur ON u.uid = ur.uid '. $filter['join'] .' WHERE u.uid != 0 '. $filter['where']; $sql .= tablesort_sql($header); - $result = pager_query($sql, 50, 0, NULL, $filter['args']); + $query_count = 'SELECT COUNT(DISTINCT u.uid) FROM users u LEFT JOIN users_roles ur ON u.uid = ur.uid '. $filter['join'] .' WHERE u.uid != 0 '. $filter['where']; + $result = pager_query($sql, 50, 0, $query_count, $filter['args']); $form['options'] = array( '#type' => 'fieldset', -- cgit v1.2.3