From 27ff879f511117587c7633b109974b6ff205eaa0 Mon Sep 17 00:00:00 2001 From: Philip Häusler Date: Sun, 5 Jan 2014 19:35:01 +0100 Subject: cookie-0007-API-getRoom-show-real-rooms.patch --- includes/model/Room_model.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'includes/model/Room_model.php') diff --git a/includes/model/Room_model.php b/includes/model/Room_model.php index fea241a6..5b9c7a2a 100644 --- a/includes/model/Room_model.php +++ b/includes/model/Room_model.php @@ -4,7 +4,7 @@ * Returns room id array */ function mRoomList() { - $room_source = sql_select("SELECT `RID` FROM `Room`"); + $room_source = sql_select("SELECT `RID` FROM `Room` WHERE `show` = 'Y'"); if ($room_source === false) return false; if (count($room_source) > 0) @@ -19,7 +19,7 @@ function mRoomList() { * @param $id RID */ function mRoom($id) { - $room_source = sql_select("SELECT * FROM `Room` WHERE `RID`=" . sql_escape($id) . " LIMIT 1"); + $room_source = sql_select("SELECT * FROM `Room` WHERE `RID`=" . sql_escape($id) . " AND `show` = 'Y' LIMIT 1"); if ($room_source === false) return false; if (count($room_source) > 0) -- cgit v1.2.3-70-g09d2