diff options
| author | Andreas Fischer <bantu@phpbb.com> | 2012-05-09 12:55:58 +0200 |
|---|---|---|
| committer | Andreas Fischer <bantu@phpbb.com> | 2012-05-09 12:55:58 +0200 |
| commit | 1a9b30b87118333f0d58eaec3762fc1a579d7b8a (patch) | |
| tree | 58ec13e0f9bdf0acdbf0a82220b4e6257506a0b2 /phpBB/includes/db/dbal.php | |
| parent | 30579ecb09e2160c450e5d740c36ab052d2ec93d (diff) | |
| parent | 12dbcc7f1e13f71b96a5aa31ece4632fb1eb4139 (diff) | |
| download | forums-1a9b30b87118333f0d58eaec3762fc1a579d7b8a.tar forums-1a9b30b87118333f0d58eaec3762fc1a579d7b8a.tar.gz forums-1a9b30b87118333f0d58eaec3762fc1a579d7b8a.tar.bz2 forums-1a9b30b87118333f0d58eaec3762fc1a579d7b8a.tar.xz forums-1a9b30b87118333f0d58eaec3762fc1a579d7b8a.zip | |
Merge branch 'develop-olympus' into develop
* develop-olympus:
[ticket/10858] Move generic row seeking to DBAL
[ticket/10858] Tests for row seeking with fetchfield()
[ticket/10858] Fix MSSQL Native's row seeking behavior
Conflicts:
tests/dbal/select_test.php
Diffstat (limited to 'phpBB/includes/db/dbal.php')
| -rw-r--r-- | phpBB/includes/db/dbal.php | 43 |
1 files changed, 43 insertions, 0 deletions
diff --git a/phpBB/includes/db/dbal.php b/phpBB/includes/db/dbal.php index 6da854b6e2..db469ed969 100644 --- a/phpBB/includes/db/dbal.php +++ b/phpBB/includes/db/dbal.php @@ -194,6 +194,49 @@ class dbal } /** + * Seek to given row number + * rownum is zero-based + */ + function sql_rowseek($rownum, &$query_id) + { + global $cache; + + if ($query_id === false) + { + $query_id = $this->query_result; + } + + if (isset($cache->sql_rowset[$query_id])) + { + return $cache->sql_rowseek($rownum, $query_id); + } + + if ($query_id === false) + { + return false; + } + + $this->sql_freeresult($query_id); + $query_id = $this->sql_query($this->last_query_text); + + if ($query_id === false) + { + return false; + } + + // We do not fetch the row for rownum == 0 because then the next resultset would be the second row + for ($i = 0; $i < $rownum; $i++) + { + if (!$this->sql_fetchrow($query_id)) + { + return false; + } + } + + return true; + } + + /** * Fetch field * if rownum is false, the current row is used, else it is pointing to the row (zero-based) */ |