From ee9ecd4db51299ff1f28488ee77d0eded4ae700d Mon Sep 17 00:00:00 2001 From: Simon Rettberg Date: Thu, 4 Jul 2019 13:49:38 +0200 Subject: [exams] Fix isExamMode() for global exams --- modules-available/exams/inc/exams.inc.php | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) diff --git a/modules-available/exams/inc/exams.inc.php b/modules-available/exams/inc/exams.inc.php index dfc38273..da4dec85 100644 --- a/modules-available/exams/inc/exams.inc.php +++ b/modules-available/exams/inc/exams.inc.php @@ -12,10 +12,14 @@ class Exams if (!is_array($locationIds)) { $locationIds = array($locationIds); } - $l = str_repeat(',?', count($locationIds)); + if (empty($locationIds)) { + $locationIds[] = 0; + } $res = Database::queryFirst("SELECT lectureid, autologin FROM exams" . " INNER JOIN exams_x_location USING (examid)" - . " WHERE UNIX_TIMESTAMP() BETWEEN starttime AND endtime AND locationid IN (0$l) LIMIT 1", $locationIds); + . " WHERE UNIX_TIMESTAMP() BETWEEN starttime AND endtime AND (locationid IN (:lids) OR locationid IS NULL) LIMIT 1", [ + 'lids' => array_values($locationIds), + ]); if ($res !== false) { $lectureId = $res['lectureid']; $autoLogin = $res['autologin']; -- cgit v1.2.3-55-g7522