diff options
author | Brion Vibber <brion@pobox.com> | 2010-02-26 09:35:28 -0800 |
---|---|---|
committer | Brion Vibber <brion@pobox.com> | 2010-02-26 09:35:28 -0800 |
commit | 8dfc8f1635940b096e7f4025e3aef0ca4f909eb2 (patch) | |
tree | 9fce4aa765d56496031698f219da2f0f82b33e80 /actions/groups.php | |
parent | 8914b69d5055c1bc7d0604ee338ffdaf6b0a8606 (diff) | |
parent | b331e971b055386a126aaec27d661f26ba3b813c (diff) |
Merge branch 'testing' into 0.9.x
Diffstat (limited to 'actions/groups.php')
-rw-r--r-- | actions/groups.php | 18 |
1 files changed, 11 insertions, 7 deletions
diff --git a/actions/groups.php b/actions/groups.php index 10a1d5964..8aacff8b0 100644 --- a/actions/groups.php +++ b/actions/groups.php @@ -109,17 +109,21 @@ class GroupsAction extends Action } $offset = ($this->page-1) * GROUPS_PER_PAGE; - $limit = GROUPS_PER_PAGE + 1; + $limit = GROUPS_PER_PAGE + 1; + + $qry = 'SELECT user_group.* '. + 'from user_group join local_group on user_group.id = local_group.group_id '. + 'order by user_group.created desc '. + 'limit ' . $limit . ' offset ' . $offset; $groups = new User_group(); - $groups->orderBy('created DESC'); - $groups->limit($offset, $limit); $cnt = 0; - if ($groups->find()) { - $gl = new GroupList($groups, null, $this); - $cnt = $gl->show(); - } + + $groups->query($qry); + + $gl = new GroupList($groups, null, $this); + $cnt = $gl->show(); $this->pagination($this->page > 1, $cnt > GROUPS_PER_PAGE, $this->page, 'groups'); |