{
require_once $class_name . '.php';
}
$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");
* 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';
}
#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 />";
$user = new User();
$page = new Webpage("Delete Event", $user);
$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 {
$endDate = date_create($conTimes[$conday]['end']);
}
}
//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 "!";
}
*
* 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("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'])) {
* 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';
}
#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?
* GNU General Public License for more details.
*
* 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.");
