Example #1
0
    $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);
    }
}
Example #2
0
 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;");
 }
Example #3
0
            $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);
    }
}
Example #4
0
 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;");
 }
Example #5
0
$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';