From 590a837a34ad41e773d7d8625846117baa7ba2b8 Mon Sep 17 00:00:00 2001
From: jerome <jerome>
Date: Wed, 11 Jun 2008 05:51:43 +0000
Subject: [PATCH] MDL-15112 lesson dml conversion

---
 mod/lesson/view.php | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

diff --git a/mod/lesson/view.php b/mod/lesson/view.php
index 8776787db1..77daed50ce 100644
--- a/mod/lesson/view.php
+++ b/mod/lesson/view.php
@@ -790,8 +790,10 @@
                     }
                 } elseif ($lesson->nextpagedefault == LESSON_UNANSWEREDPAGE) {
                     foreach ($allpages as $thispage) {
-                        if (!$DB->count_records_select("lesson_attempts", array('pageid'=>$thispage->id,
-                                    'userid'=>$USER->id, 'correct'=>1, 'retry'=>$nretakes))) {
+                        $params = array('pageid'=>$thispage->id,
+                                    'userid'=>$USER->id, 'correct'=>1, 'retry'=>$nretakes);
+                        if (!count_records_select("lesson_attempts", "pageid = :pageid AND
+                                     userid = :userid AND correct = 1 AND retry = :retry", $params)) {
                             $found = true;
                             break;
                         }
-- 
2.39.5