$page = new Webpage("Test View Event", $user); $event = $page->_GET_checkEventID($_GET['event'], $connection); if ($event == NULL) { exit(0); } $page->printEvent($event); echo "<center>"; echo "<div id=\"addBox\">"; if ($user->is_User()) { // figure out if the event is already in the user's schedule $eventID = $event->getEventID(); $userID = $user->get_UserID(); $query = "\n\t\tSELECT us_eventID \n\t\tFROM userSchedule \n\t\tWHERE us_eventID = {$eventID}\n\t\t\tAND us_userID = {$userID};"; $connection->query($query); if ($connection->result_size() == 0) { $page->addURL("addUserEvent.php?event={$eventID}", "Add this event to your schedule."); echo "<br><br>"; $page->addURL("userSchedule.php", "View your schedule."); } else { echo "This event is in "; $page->addURL("userSchedule.php", "your schedule."); echo "<br>"; echo '<span style="font-size: small;">['; $page->addURL("deleteUserEvent.php?event={$eventID}", "Remove"); echo "]</span>"; } } else { echo "Register or Sign In on the "; $page->addURL("http://www.mewcon.com/forum/index.php", "forums"); echo " to add this event to your own custom schedule!"; }
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, * MA 02110-1301, USA. */ function __autoload($class_name) { require_once $class_name . '.php'; } #first login info $user = new User(); $page = new Webpage("Add Event", $user); $connection = new Connection(); #only admins can add events if (!$user->is_Admin()) { $page->printError("Only Admins can create new events."); echo "<center>"; $page->addURL("index.php", "Return to event schedule."); echo "</center>"; exit(0); } if (isset($_GET['action']) && count($_POST) == 15) { //ok we'll add the entry here. $name = $connection->validate_string($_POST['name']); $name = trim($name); if (str_word_count($name) == 0) { $page->printError("Name cannot be blank."); echo "<center>"; echo "Please go back and supply one.<br /><br />"; $page->addURL("add.php", "Try again."); echo "<br /><br />"; $page->addURL("index.php", "Return to event schedule."); echo "</center>";
$connection = new Connection(); $eventID = $page->_GET_checkEventID($_GET['event'], $connection, FALSE); if (!isset($eventID)) { exit(0); } if ($user->is_Admin()) { if (isset($_GET['confirm'])) { // they want to delete it so lets delete it $query = "DELETE FROM events WHERE e_eventID = {$eventID};"; $connection->query($query); //also remove the event from user schedules $query = "DELETE FROM userSchedule WHERE us_eventID = {$eventID};"; $connection->query($query); $page->printError("Event successfully deleted."); echo "<center>"; $page->addURL("index.php", "Return to event schedule."); echo "</center>"; exit(0); } else { $query = "SELECT e_eventName FROM events WHERE e_eventID = {$eventID}"; $connection->query($query); $row = $connection->fetch_row(); $eventName = $row[0]; echo "<center>Do you really want to delete the event \"<strong>{$eventName}</strong>?\"<br />"; $page->addURL("delete.php?event={$eventID}&confirm='Yes'", "Yes"); echo " "; $page->addURL("view.php?event={$eventID}", "No"); } } else { $page->printError("You cannot delete events."); echo "<center>";
} $user = new User(); $page = new Webpage("Remove User Event", $user); $C = new Connection(); $eID = $page->_GET_checkEventID($_GET['event'], $C, FALSE); if (!isset($eID)) { exit(0); } $uID = $user->get_UserID(); if (isset($_GET['confirm'])) { // they have confirmed they wish to delete the event $q = "DELETE FROM userSchedule WHERE us_userID = {$uID} AND us_eventID = {$eID};"; $C->query($q); $page->printError("Event removed successfully."); echo "<center>"; $page->addURL("userSchedule.php", "Return to your custom schedule."); echo "<br /><br />"; $page->addURL("index.php", "Return to event schedule."); echo "</center>"; } else { $q = "SELECT e_eventName FROM events WHERE e_eventID = {$eID}"; $C->query($q); $row = $C->fetch_row(); $eventName = $row[0]; echo "<center>"; echo "<h3>Do you really want to remove \"{$eventName}\" from your schedule?</h3>"; $page->addURL("deleteUserEvent.php?event={$eID}&confirm=1", "Yes"); echo " "; $page->addURL("view.php?event={$eID}", "No"); echo "</center>"; }
} //fill in the start and end times with conTimes if not specified via url params if (!isset($startDate) && !isset($endDate)) { $startDate = date_create($conTimes[0]['start']); $endDate = date_create($conTimes[$conDayCount - 1]['end']); } $schedule = NULL; // events query $q = "\nSELECT \n\te_eventID, e_eventName, r_roomName, e_dateStart, \n\te_dateEnd, e_eventName, e_eventDesc, e_color, e_panelist\nFROM \n\tevents, rooms\nWHERE \n\te_roomID = r_roomID\n\tAND\n\te_dateStart \n\t\tBETWEEN \n\t\t'" . $startDate->format("Y-m-d H:i:s") . "'\n\t\tAND\n\t\t'" . $endDate->format("Y-m-d H:i:s") . "'\nORDER BY\n\tr_roomID ASC\n;"; $C->query($q); $eventCount = $C->result_size(); if ($eventCount < 1) { if (isset($_GET['date'])) { $page->printError("No events scheduled for " . $startDate->format("F d, Y")); echo "<center>"; $page->addURL("index.php", "Return to non-filtered event schedule."); echo "</center>"; exit(0); } else { $page->printError("No events scheduled."); } echo "<center>"; if (!$user->is_Admin()) { echo "Please check back later. We'll be posting events soon =^.^="; } else { echo "Oi, you: "; $page->addURL("add.php", "add an event"); echo "!"; } echo "</center>"; exit(0);
* along with this program; if not, write to the Free Software * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, * MA 02110-1301, USA. */ function __autoload($class_name) { require_once $class_name . '.php'; } $C = new Connection(); $user = new User(); $page = new Webpage("Add User Event", $user); // make sure the visitor is a forum user if (!$user->is_User()) { $page->printError("You must be a forum user to create your own schedule."); echo "<center>"; $page->addURL("http://www.mewcon.com/forum/index.php", "Go to the forums to Register or Sign In."); echo "<br /><br />"; $page->addURL("index.php", "Return to the event schedule."); echo "</center>"; exit(0); } $reqEvent = $page->_GET_checkEventID($_GET['event'], $C); if (!isset($reqEvent)) { exit(0); } $uID = $user->get_UserID(); $eID = $reqEvent->getEventID(); // check if we're processing from the conflict resolution form if (isset($_POST['submit'])) { $keepReq = $C->validate_string($_POST['keepReq']); $cc = $C->validate_string($_POST['conflictCount']);
* MA 02110-1301, USA. */ function __autoload($class_name) { require_once $class_name . '.php'; } #first login info $user = new User(); $page = new Webpage("Edit Event", $user); $connection = new Connection(); // if the visitor isn't even a forum user, they shouldn't be using this page. if (!$user->is_User()) { $page->printError("Hey, I don't know you! =O.O="); echo "<center>"; echo "Please register or sign in to the "; $page->addURL("http://www.mewcon.com/forum/index.php", "forums"); echo " if you fancy doing fun things with panels.<br />"; $page->addURL("index.php", "Return to the event schedule."); echo "<br />"; echo "</center>"; exit(0); } $event = $page->_GET_checkEventID($_GET['event'], $connection); if (!isset($event)) { exit(0); } $eventID = $event->getEventID(); // if there's no _POST data, why do anything? if (count($_POST) == 0) { $page->printError("Something funky happened with the edit form =T.T="); echo "<center>";
$location->update(); } } } else { if ($_GET['action'] == 'edit') { $location->loadEntry($_GET['index']); } $location->printForm($_GET['action']); } } } } catch (Exception $e) { echo "ERROR: " . $e->getMessage(); } echo "\n<center>\n<br><br>"; $webpage->addURL("index.php?action=add&type=asset", "Add a new asset"); echo "<br>"; $webpage->addURL("index.php?action=find&type=asset", "Search for an Assest by barcode"); echo "<br>"; $webpage->addURL("index.php?action=add&type=assettype", "Create new asset type"); echo "<br>"; $webpage->addURL("index.php?action=list&type=assettype", "List avalible asset types"); echo "<br>"; $webpage->addURL("index.php?action=add&type=box", "Create new box entry"); echo "<br>"; $webpage->addURL("index.php?action=list&type=box", "List Boxes"); echo "<br>"; $webpage->addURL("index.php?action=find&type=box", "Search for a box by barcode"); echo "<br>"; $webpage->addURL("index.php?action=add&type=location", "Add a new location"); echo "<br>";
* You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, * MA 02110-1301, USA. */ function __autoload($class_name) { require_once $class_name . '.php'; } $C = new Connection(); $user = new User(); $page = new Webpage("User Schedule", $user); if (!$user->is_User()) { $page->printError("You must be a forum user to create your own schedule."); echo "<center>"; $page->addURL("http://www.mewcon.com/forum/index.php", "Go to the forums to Register or Sign In."); echo "<br><br>"; $page->addURL("index.php", "Return to the event schedule."); echo "</center>"; exit(0); } // get the user's current event schedule $uID = $user->get_UserID(); $q = "\nSELECT\n\te_eventID, e_eventName, r_roomName, e_dateStart, \n\te_dateEnd, e_eventDesc, e_panelist, e_color\nFROM\n\tevents, rooms, userSchedule\nWHERE\n\tus_userID = {$uID}\n\tAND\n\tus_eventID = e_eventID\n\tAND\n\te_roomID = r_roomID\nORDER BY\n\te_dateStart\n\tASC\n;"; $C->query($q); if ($C->result_size() < 1) { $page->printError("Silly " . $user->get_Username() . ", you have no events scheduled. =^.^="); echo "<center>"; $page->addURL("index.php", "Return to event schedule."); echo "</center>"; exit(0);