Set a limit on the query

Signed-off-by: Joas Schilling <coding@schilljs.com>

1 files changed, 5 insertions, 5 deletions

diff --git a/lib/MatterbridgeManager.php b/lib/MatterbridgeManager.php
index 7d1dda0a2..c560e1c0c 100644
--- a/lib/MatterbridgeManager.php
+++ b/lib/MatterbridgeManager.php
@@ -760,14 +760,14 @@ class MatterbridgeManager {
 			->from('talk_bridges', 'b')
 			->where(
 				$qb->expr()->eq('room_id', $qb->createNamedParameter($roomId, IQueryBuilder::PARAM_INT))
-			);
-		$req = $qb->execute();
+			)
+			->setMaxResults(1);
+		$result = $qb->execute();
 		$jsonValues = '{"enabled":false,"pid":0,"parts":[]}';
-		while ($row = $req->fetch()) {
+		if ($row = $result->fetch()) {
 			$jsonValues = $row['json_values'];
-			break;
 		}
-		$req->closeCursor();
+		$result->closeCursor();
 
 		return json_decode($jsonValues, true);
 	}