MDL-34109 quiz cron: change whitespace before applying the fix.
authorTim Hunt <T.J.Hunt@open.ac.uk>
Fri, 29 Jun 2012 10:02:30 +0000 (11:02 +0100)
committerDan Poltawski <dan@moodle.com>
Mon, 2 Jul 2012 08:44:29 +0000 (16:44 +0800)
This commit just changes the white-space, but does not change any of the
actual code. This is so that the commit I am about to make, which will
change the code, will be easier to understand.

mod/quiz/cronlib.php

index eab7b0f..b6a1eb0 100644 (file)
@@ -125,10 +125,19 @@ class mod_quiz_overdue_attempt_updater {
         ) group_by_results
            JOIN {quiz_attempts} quiza ON quiza.id = group_by_results.attemptid
 
         ) group_by_results
            JOIN {quiz_attempts} quiza ON quiza.id = group_by_results.attemptid
 
-          WHERE (state = 'inprogress' AND (:timenow1 > usertimeclose OR
-                                           :timenow2 > quiza.timestart + usertimelimit))
-             OR (state = 'overdue'    AND (:timenow3 > graceperiod + usertimeclose OR
-                                           :timenow4 > graceperiod + quiza.timestart + usertimelimit))
+          WHERE (
+                state = 'inprogress' AND (
+                    :timenow1 > usertimeclose OR
+                    :timenow2 > quiza.timestart + usertimelimit
+                )
+            )
+          OR
+            (
+                state = 'overdue' AND (
+                    :timenow3 > graceperiod + usertimeclose OR
+                    :timenow4 > graceperiod + quiza.timestart + usertimelimit
+                )
+            )
 
        ORDER BY course, quiz",
 
 
        ORDER BY course, quiz",