From 3fe77c8d090bb0ebf2ad2ed53f08810f531aac83 Mon Sep 17 00:00:00 2001
From: James Atkinson <thefinn@users.sourceforge.net>
Date: Fri, 16 Mar 2001 08:35:56 +0000
Subject: Start of LIMIT functionality...got to tired to finish it
git-svn-id: file:///svn/phpbb/trunk@103 89ea8834-ac86-4346-8a33-228a782c2dd0
---
phpBB/db/oracle.php | 22 ++++++++++++++++++++--
1 file changed, 20 insertions(+), 2 deletions(-)
(limited to 'phpBB')
diff --git a/phpBB/db/oracle.php b/phpBB/db/oracle.php
index aa7f5a5059..24e409fced 100644
--- a/phpBB/db/oracle.php
+++ b/phpBB/db/oracle.php
@@ -95,8 +95,26 @@ class sql_db
unset($this->query_result);
if($query != "")
{
- $this->query_result = OCIParse($this->db_connect_id, $query);
- OCIExecute($this->query_result);
+ if(eregi("LIMIT", $query))
+ {
+ eregi("^([[:alnum:][:cntrl:] \*\,\'\"\+\.\(\)_=]+)LIMIT ([0-9]+)[, ]*([0-9]+)*", $query, $limits);
+
+ $query = $limits[1];
+ if($limits[3])
+ {
+ $row_offset = $limits[2];
+ $num_rows = $limits[3];
+ }
+ else
+ {
+ $row_offset = 0;
+ $num_rows = $limits[2];
+ }
+
+
+ $this->query_result = OCIParse($this->db_connect_id, $query);
+ OCIExecute($this->query_result);
+ }
}
if($this->query_result)
{
--
cgit v1.2.1