From a609804d82dcd457b41d71948a07f1d586ae185c Mon Sep 17 00:00:00 2001
From: Steffen Ritter
Date: Mon, 18 May 2020 10:46:47 +0200
Subject: [remoteaccess] Fix DB query to add rooms to groups

---
 modules-available/remoteaccess/page.inc.php | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/modules-available/remoteaccess/page.inc.php b/modules-available/remoteaccess/page.inc.php
index edbe0ff8..2877fc9d 100644
--- a/modules-available/remoteaccess/page.inc.php
+++ b/modules-available/remoteaccess/page.inc.php
@@ -41,7 +41,8 @@ class Page_RemoteAccess extends Page
 			Message::addSuccess('settings-saved');
 		} elseif ($action === 'set-locations') {
 			$groupid = Request::post('groupid', Request::REQUIRED, 'int');
-			$group = Database::queryFirst("SELECT groupname FROM remoteaccess_group WHERE groupid = :groupid");
+			$group = Database::queryFirst("SELECT groupname FROM remoteaccess_group WHERE groupid = :id",
+				['id' => $groupid]);
 			if ($group === false) {
 				Message::addError('group-not-found', $groupid);
 				Util::redirect('?do=remoteaccess');
-- 
cgit v1.2.3-55-g7522