From 088a4df8fcf84e271655426c7b55ca7c8a2a37b1 Mon Sep 17 00:00:00 2001
From: skodak <skodak>
Date: Sat, 29 Nov 2008 13:32:56 +0000
Subject: [PATCH] MDL-14679 improved limit handling

---
 lib/dml/mysqli_native_moodle_database.php | 8 ++++----
 lib/dml/pgsql_native_moodle_database.php  | 8 ++++----
 2 files changed, 8 insertions(+), 8 deletions(-)

diff --git a/lib/dml/mysqli_native_moodle_database.php b/lib/dml/mysqli_native_moodle_database.php
index b32f45db38..ecda3256e9 100644
--- a/lib/dml/mysqli_native_moodle_database.php
+++ b/lib/dml/mysqli_native_moodle_database.php
@@ -445,9 +445,9 @@ class mysqli_native_moodle_database extends moodle_database {
      * @throws dml_exception if error
      */
     public function get_recordset_sql($sql, array $params=null, $limitfrom=0, $limitnum=0) {
+        $limitfrom = (int)$limitfrom;
+        $limitnum  = (int)$limitnum;
         if ($limitfrom or $limitnum) {
-            $limitfrom = (int)$limitfrom;
-            $limitnum  = (int)$limitnum;
             if ($limitnum < 1) {
                 $limitnum = "18446744073709551615";
             }
@@ -484,9 +484,9 @@ class mysqli_native_moodle_database extends moodle_database {
      * @throws dml_exception if error
      */
     public function get_records_sql($sql, array $params=null, $limitfrom=0, $limitnum=0) {
+        $limitfrom = (int)$limitfrom;
+        $limitnum  = (int)$limitnum;
         if ($limitfrom or $limitnum) {
-            $limitfrom = (int)$limitfrom;
-            $limitnum  = (int)$limitnum;
             if ($limitnum < 1) {
                 $limitnum = "18446744073709551615";
             }
diff --git a/lib/dml/pgsql_native_moodle_database.php b/lib/dml/pgsql_native_moodle_database.php
index b903599148..9d370ebf7b 100644
--- a/lib/dml/pgsql_native_moodle_database.php
+++ b/lib/dml/pgsql_native_moodle_database.php
@@ -540,9 +540,9 @@ class pgsql_native_moodle_database extends moodle_database {
      * @throws dml_exception if error
      */
     public function get_recordset_sql($sql, array $params=null, $limitfrom=0, $limitnum=0) {
+        $limitfrom = (int)$limitfrom;
+        $limitnum  = (int)$limitnum;
         if ($limitfrom or $limitnum) {
-            $limitfrom = (int)$limitfrom;
-            $limitnum  = (int)$limitnum;
             if ($limitnum < 1) {
                 $limitnum = "18446744073709551615";
             }
@@ -577,9 +577,9 @@ class pgsql_native_moodle_database extends moodle_database {
      * @throws dml_exception if error
      */
     public function get_records_sql($sql, array $params=null, $limitfrom=0, $limitnum=0) {
+        $limitfrom = (int)$limitfrom;
+        $limitnum  = (int)$limitnum;
         if ($limitfrom or $limitnum) {
-            $limitfrom = (int)$limitfrom;
-            $limitnum  = (int)$limitnum;
             if ($limitnum < 1) {
                 $limitnum = "18446744073709551615";
             }
-- 
2.39.5