diff options
| author | Gábor Hojtsy <gabor@hojtsy.hu> | 2007-11-10 10:15:21 +0000 |
|---|---|---|
| committer | Gábor Hojtsy <gabor@hojtsy.hu> | 2007-11-10 10:15:21 +0000 |
| commit | ecf6c8de03e303e4da1bad39450483528ca136fd (patch) | |
| tree | 04431514c3c6550f9ddb76d97a8099b7d00a7e89 /modules | |
| parent | a42a9d3efd6b705ad4d53f347348779114666332 (diff) | |
| download | brdo-ecf6c8de03e303e4da1bad39450483528ca136fd.tar.gz brdo-ecf6c8de03e303e4da1bad39450483528ca136fd.tar.bz2 | |
#165924 by odious and drumm: add count query for pager in user_admin_account()
Diffstat (limited to 'modules')
| -rw-r--r-- | modules/user/user.admin.inc | 3 |
1 files changed, 2 insertions, 1 deletions
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', |