diff options
| author | James Atkinson <thefinn@users.sourceforge.net> | 2001-03-16 08:35:56 +0000 |
|---|---|---|
| committer | James Atkinson <thefinn@users.sourceforge.net> | 2001-03-16 08:35:56 +0000 |
| commit | 3fe77c8d090bb0ebf2ad2ed53f08810f531aac83 (patch) | |
| tree | 4bbfa4da6e375f33c824490e5a47d88da81bd5db /phpBB/db/oracle.php | |
| parent | 1283c46dcb6296421f3c9dde47ac45f5a123ee77 (diff) | |
| download | forums-3fe77c8d090bb0ebf2ad2ed53f08810f531aac83.tar forums-3fe77c8d090bb0ebf2ad2ed53f08810f531aac83.tar.gz forums-3fe77c8d090bb0ebf2ad2ed53f08810f531aac83.tar.bz2 forums-3fe77c8d090bb0ebf2ad2ed53f08810f531aac83.tar.xz forums-3fe77c8d090bb0ebf2ad2ed53f08810f531aac83.zip | |
Start of LIMIT functionality...got to tired to finish it
git-svn-id: file:///svn/phpbb/trunk@103 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db/oracle.php')
| -rw-r--r-- | phpBB/db/oracle.php | 22 |
1 files changed, 20 insertions, 2 deletions
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) { |