From db1dcf5a9bcd6efa4744c60cfca37a3ee0e4173e Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Sat, 21 May 2022 12:38:16 +0200
Subject: [remoteaccess] Mark locations that have access restrictions in place

---
 modules-available/rebootcontrol/inc/scheduler.inc.php | 10 ++++++----
 1 file changed, 6 insertions(+), 4 deletions(-)

(limited to 'modules-available/rebootcontrol')

diff --git a/modules-available/rebootcontrol/inc/scheduler.inc.php b/modules-available/rebootcontrol/inc/scheduler.inc.php
index 9e91df25..de6251d2 100644
--- a/modules-available/rebootcontrol/inc/scheduler.inc.php
+++ b/modules-available/rebootcontrol/inc/scheduler.inc.php
@@ -204,10 +204,12 @@ class Scheduler
 	 */
 	public static function getLocationOptions(int $id): array
 	{
-		$res = Database::queryFirst("SELECT options FROM `reboot_scheduler`
-				WHERE locationid = :id", ['id' => $id]);
-		if ($res !== false) {
-			return (json_decode($res['options'], true) ?? []) + self::SCHEDULE_OPTIONS_DEFAULT;
+		static $optionList = false;
+		if ($optionList === false) {
+			$optionList = Database::queryKeyValueList("SELECT locationid, `options` FROM `reboot_scheduler`");
+		}
+		if (isset($optionList[$id])) {
+			return (json_decode($optionList[$id]['options'], true) ?? []) + self::SCHEDULE_OPTIONS_DEFAULT;
 		}
 		return self::SCHEDULE_OPTIONS_DEFAULT;
 	}
-- 
cgit v1.2.3-55-g7522