From 592443f4e1f36ebc602d73b1750a914a956fa6f9 Mon Sep 17 00:00:00 2001 From: Tim Hunt Date: Fri, 29 Jun 2012 11:02:30 +0100 Subject: [PATCH] MDL-34109 quiz cron: change whitespace before applying the fix. 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 | 17 +++++++++++++---- 1 file changed, 13 insertions(+), 4 deletions(-) diff --git a/mod/quiz/cronlib.php b/mod/quiz/cronlib.php index eab7b0fb290..b6a1eb03113 100644 --- a/mod/quiz/cronlib.php +++ b/mod/quiz/cronlib.php @@ -125,10 +125,19 @@ class mod_quiz_overdue_attempt_updater { ) 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", -- 2.43.0