$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!"; } echo "</div><br>"; $page->addURL("index.php", "Back to event schedule."); echo "</center>"; if ($user->is_Admin() == TRUE && $user->is_User()) { echo "<br/ ><hr><hr><br/ >"; $page->printAdminEdit($event, $eventID, $connection); } else { if ($user->get_Username() == $event->getPanelist() && $user->is_User()) { //this is the panelist for this panel so give them access to the desc editing echo "<br><hr><hr><br>"; $page->printPanelistEdit($event, $eventID); } }
public function deleteBox($barcode) { $this->connection->query("begin;"); $query = "\n\t\tSELECT COUNT(a_barcode)\n\t\tFROM assets\n\t\tWHERE a_box = {$barcode};"; $this->connection->query($query); $row = $this->connection->fetch_row(); if ($row[0] != 0) { echo "Cannot delete an Assest Type that is currently being used by assets<br><br>"; } else { $query = "DELETE FROM boxes WHERE b_barcode = {$barcode};"; $this->connection->query($query); //log away $user = new User(); $logEntry = new LogEntry($this->connection); $logEntry->setBarcode($barcode); $logEntry->setPerson($user->get_Username()); $logEntry->setType("Box Deleted"); $logEntry->insert(); } $this->connection->query("commit;"); }
$endDate = date_create($row['e_dateEnd']); echo "<tr align='center'>"; echo "<td>"; echo $row['e_eventName']; echo "</td><td>"; echo $startDate->format("H:i"); echo "</td><td>"; echo $endDate->format("H:i"); echo "</td>"; echo "</tr>"; } echo "</table>"; echo "<br />"; $page->addURL("view.php?event={$eventID}", "Try again."); echo "<br /><br />"; $page->addURL("index.php", "Return to event schedule."); exit(0); } // no conflicts found. Put the event in the schedule! $query = "\n\t\tUPDATE \n\t\t\tevents\n\t\tSET \n\t\t\te_eventName = '{$name}',\n\t\t\te_roomID = {$roomID}, \n\t\t\te_dateStart = '" . $start->format("Y-m-d H:i:s") . "', \n\t\t\te_dateEnd = '" . $end->format("Y-m-d H:i:s") . "',\n\t\t\te_eventDesc = '{$desc}',\n\t\t\te_panelist = '{$panelist}', \n\t\t\te_color = '{$color}'\n\t\tWHERE \n\t\t\te_eventID = {$eventID}\n\t;"; $connection->query($query); $page->printError("Event update successful! =^.^="); echo "<center>"; $page->addURL("index.php", "Return to main schedule"); echo "</center>"; } else { if ($user->get_Username() == $panelist && $action == "panelist") { $query = "\n\t\tUPDATE events \n\t\tSET e_eventName = '{$name}', e_eventDesc = '{$desc}' \n\t\tWHERE e_eventID = {$eventID};"; $connection->query($query); } }
public function deleteAsset($barcode) { $this->connection->query("begin;"); //log this sad event $user = new User(); $logEntry = new LogEntry($this->connection); $logEntry->setBarcode($barcode); $logEntry->setPerson($user->get_Username()); $logEntry->setType("Asset Deleted"); $logEntry->insert(); $query = "DELETE FROM assets WHERE a_barcode = '{$barcode}'"; $this->connection->query($query); $this->connection->query("commit;"); }
$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); } for ($i = 0; $i < $C->result_size(); $i++) { $row = $C->fetch_assoc(); $userEvents[$i] = new Event($row['e_eventID'], $row['e_eventName'], $row['r_roomName'], $row['e_dateStart'], $row['e_dateEnd'], $row['e_eventDesc'], $row['e_panelist'], $row['e_color']); } // print out the table $page->printError("Custom schedule for " . $user->get_Username() . "."); echo '<center>'; echo '<table class="userSchedule" cellpadding=0 cellspacing=0>'; echo '<thead><tr><td class="eventName">'; echo 'Event Name';