From 78a0635ccd548fc93d85629c5f10226b7d566d2d Mon Sep 17 00:00:00 2001
From: skodak <skodak>
Date: Wed, 26 Nov 2008 08:51:08 +0000
Subject: [PATCH] MDL-17408 DML: new sql_modulo() method used in course sorting

---
 lib/datalib.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/lib/datalib.php b/lib/datalib.php
index 7f722197fd..03f2676684 100644
--- a/lib/datalib.php
+++ b/lib/datalib.php
@@ -1341,7 +1341,7 @@ function fix_course_sortorder() {
         //fix the course sortorder ranges
         foreach ($fixcategories as $cat) {
             $sql = "UPDATE {course}
-                       SET sortorder = (sortorder % ".MAX_COURSES_IN_CATEGORY.") + ?
+                       SET sortorder = ".$DB->sql_modulo('sortorder', MAX_COURSES_IN_CATEGORY)." + ?
                      WHERE category = ?";
             $DB->execute($sql, array($cat->sortorder, $cat->id));
         }
-- 
2.39.5