From a611408dca7658ab72c18f65b7687322a08e4bd8 Mon Sep 17 00:00:00 2001
From: Evan Prodromou <evan@controlyourself.ca>
Date: Sat, 24 Jan 2009 11:05:38 +0100
Subject: [PATCH] Revert "try to fix groups with a new qry"

This reverts commit 8f19855cd0742e3ca9cb97d2287fbfbe48507d51.
---
 actions/groups.php | 15 ++++-----------
 1 file changed, 4 insertions(+), 11 deletions(-)

diff --git a/actions/groups.php b/actions/groups.php
index 72adbbde8c..39dc2232bc 100644
--- a/actions/groups.php
+++ b/actions/groups.php
@@ -106,19 +106,12 @@ class GroupsAction extends Action
                        _('Create a new group'));
         $this->elementEnd('p');
 
-        $limit = GROUPS_PER_PAGE + 1;
         $offset = ($this->page-1) * GROUPS_PER_PAGE;
-
-        $qry = 'SELECT * from User_group ' .
-          'ORDER by created DESC ';
-        if (common_config('db','type') == 'pgsql') {
-            $qry .= ' LIMIT ' . $limit . ' OFFSET ' . $offset;
-        } else {
-            $qry .= ' LIMIT ' . $offset . ', ' . $limit;
-        }
+        $limit =  GROUPS_PER_PAGE + 1;
 
         $groups = new User_group();
-        $groups->query($qry);
+        $groups->orderBy('created DESC');
+        $groups->limit($offset, $limit);
 
         if ($groups->find()) {
             $gl = new GroupList($groups, null, $this);
@@ -126,7 +119,7 @@ class GroupsAction extends Action
         }
 
         $this->pagination($this->page > 1, $cnt > GROUPS_PER_PAGE,
-                          $this->page, 'groups', array());
+                          $this->page, 'groups');
     }
 
     function showSections()
-- 
2.39.5