function selectRoom($SchedID) { //----------------------------------------------------------------------------- // Retrieve a list of all avaliable rooms //----------------------------------------------------------------------------- $roomList = getRoomList(); global $ScheduleTable; global $EventID; //----------------------------------------------------------------------------- // Check to see if scheduled event has room assigned //----------------------------------------------------------------------------- $roomKey = substr($SchedID, 0, 3) . '%'; $result = $db->query("select RoomID\n from {$ScheduleTable}\n where SchedID like '{$roomKey}'\n and EventID = {$EventID}\n ") or die("Unable to get room ID: " . sqlError()); $row = $result->fetch(PDO::FETCH_ASSOC); if (!empty($row)) { $roomIDList = explode(',', $row['RoomID']); } else { $roomIDList = array(0); } //----------------------------------------------------------------------------- // Set Row background Color //----------------------------------------------------------------------------- $hour = substr($SchedID, 1, 2); if ($hour % 2 == 0) { $bgcolor = "#6699FF"; } else { $bgcolor = "#D9D9FF"; } //----------------------------------------------------------------------------- // Print the selection Drop-Down //----------------------------------------------------------------------------- $fieldName = 'Room_' . substr($SchedID, 0, 3) . '[]'; print "<td bgcolor=\"{$bgcolor}\" align=\"center\">"; print "<select multiple size=\"4\" name=\"{$fieldName}\">"; foreach ($roomList as $roomNum => $roomName) { if (in_array($roomNum, $roomIDList)) { print "<option selected value=\"{$roomNum}\">{$roomName}</option>"; } } foreach ($roomList as $roomNum => $roomName) { if (!in_array($roomNum, $roomIDList)) { print "<option value=\"{$roomNum}\">{$roomName}</option>"; } } print "</select>"; print "</td>"; }
function selectRoom($RoomID = '') { //----------------------------------------------------------------------------- // Retrieve a list of all avaliable rooms //----------------------------------------------------------------------------- $roomList = getRoomList('fullnames'); //----------------------------------------------------------------------------- // Print the selection Drop-Down //----------------------------------------------------------------------------- print "\n<select size=\"1\" name=\"RoomID\">\n"; print " <option value=\"\">-Select-</option>\n"; foreach ($roomList as $roomNum => $roomName) { if (intval($RoomID) == intval($roomNum)) { print " <option value=\"{$roomNum}\" selected>{$roomName}</option>\n"; } else { print " <option value=\"{$roomNum}\">{$roomName}</option>\n"; } } print "</select>\n"; }
// This software is licensed under the MIT license. Use as you wish but give // and take credit where due. // // Author: Paul Lemmons //---------------------------------------------------------------------------- include 'include/RegFunctions.php'; if (isset($_REQUEST['Admin']) and $Admin == 'Y') { $AdminReport = 1; } else { $AdminReport = 0; } $byTime = isset($_REQUEST['byTime']); //----------------------------------------------------------------------------- // Retrieve a list of all avaliable rooms //----------------------------------------------------------------------------- $roomList = getRoomList(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html lang="en"> <head> <meta http-equiv="Content-Language" content="en-us"> <title> Scheduled Events Roster </title> </head> <body bgcolor="White"> <h1 align="center">Schedule Roster</h1> <hr> <?php
</div> <div class="sidebar_right"> <div class="block"> <div class="blocktitle">Menu</div> <div class="blockcontent"> <a href="index.php">Home</a><br /> </div> </div> <?php if ($_SETTINGS['RTS_Enabled']) { ?> <div class="block"> <div class="blocktitle">Rooms</div> <div class="blockcontent"> <?php $rooms = getRoomList(); if ($rooms === false) { echo "<h3 style=\"margin:0px;color:#a00;\">Server Offline!</h3>"; } else { echo "<h3 style=\"margin:0px;color:#0a0;\">Server Online!</h3>"; foreach ($rooms as $room) { echo "<p><b><a href=\"index.php?page=room&rid=" . $room['ID'] . "\">" . $room['Name'] . "</a></b> (" . $room['Players'] . ")<br />" . $room['Description'] . "</p>"; } } ?> </div> </div> <?php } ?> <div class="block">