From 0fbe10808875d7fa1c17c28413b34fdde2e0bc53 Mon Sep 17 00:00:00 2001
From: sparc <sparc@208e9e7b-5314-0410-a742-e7e81cd9613c>
Date: Thu, 20 Oct 2005 16:58:34 +0000
Subject: added DB LIMIT abstraction

git-svn-id: https://svn.roundcube.net/trunk@47 208e9e7b-5314-0410-a742-e7e81cd9613c
---
 roundcubemail/program/include/rcube_db.inc | 11 ++++++++---
 1 file changed, 8 insertions(+), 3 deletions(-)

(limited to 'roundcubemail/program/include/rcube_db.inc')

diff --git a/roundcubemail/program/include/rcube_db.inc b/roundcubemail/program/include/rcube_db.inc
index 2b0c01af9..f732da298 100755
--- a/roundcubemail/program/include/rcube_db.inc
+++ b/roundcubemail/program/include/rcube_db.inc
@@ -103,7 +103,7 @@ class rcube_db
 
     // Query database (read operations)
     
-    function query($query)
+    function query($query, $offset=0, $numrows=0)
     {
         // Read or write ?
         if (strtolower(trim(substr($query,0,6)))=='select')
@@ -115,8 +115,13 @@ class rcube_db
 
         if ($this->db_provider == 'sqlite')
             $query = $this->_sqlite_prepare_query($query);
-            
-        $result = $this->db_handle->query($query);
+        
+        if ($numrows || $offset)
+			{
+			$result = $this->db_handle->limitQuery($query,$offset,$numrows);
+			}
+        else    
+			$result = $this->db_handle->query($query);
         
         if (DB::isError($result))
             raise_error(array('code' => 500,
-- 
cgit v1.2.3