<?php

require_once 'connection.php';
$session = new Session();
$user = User::select($db, $session->getUsername());
//print_r($_POST);
if (!$session->getLoggedin() || !$session->haveAccess(1, 1, 1, 0) || $session->getUsertype() == Session::USER_MANAGER && $user->getEventcode() != $_GET['eventcode']) {
    die("People of India posses a great deal of wisdom for changing what is not their.");
}
$out = [];
if (isset($_POST['eventcode'])) {
    $eventcode = $db->escape($_POST['eventcode']);
    $eventname = $db->escape(str_replace("'", "&#39;", $_POST['ename']));
    $shortdesc = $db->escape(str_replace("'", "&#39;", $_POST['shortdesc']));
    $tags = $db->escape($_POST['tags']);
    $contacts = $db->escape($_POST['contacts']);
    $prizes = $db->escape($_POST['prizes']);
    $longdesc = $db->escape($_POST['longdesc']);
    //single quotes - replaced with javascript .. (really???)
    $prtpnt = $db->escape($_POST['prtpnt']);
    $timings = $db->escape($_POST['timings']);
    $loc = $db->escape($_POST['venue']);
    $query = "UPDATE events SET " . Event::EVENT_NAME . " ='{$eventname}'," . Event::EVENT_SHORTDESC . "='{$shortdesc}'," . Event::EVENT_LONGDESC . "='{$longdesc}'," . Event::EVENT_TAGS . "='{$tags}'," . Event::EVENT_CONTACTS . "='{$contacts}'," . Event::EVENT_PRIZE . "='{$prizes}'," . Event::EVENT_PRTPNT . "='{$prtpnt}'," . Event::EVENT_TIMINGS . "='{$timings}'," . Event::EVENT_LOCATIONID . "='{$loc}' WHERE " . Event::EVENT_CODE . "='{$eventcode}'";
    $db->query($query);
    $status = "Success Fully Updated!!";
} else {
    $status = "Success Fully Failed :P ---> This shouldnt be happening!! Contact Incharge.";
}
require './includes/metadetails.php';
?>
<body>
<?php

require_once 'connection.php';
$session = new Session();
if (!$session->getLoggedin()) {
    header("Location: login.php");
}
$user = User::select($db, $session->getUsername());
if (!isset($_GET['eventcode']) && $session->getUsertype() == Session::USER_REGULAR || $session->getUsertype() == Session::USER_MANAGER && $user->getEventcode() != $_GET['eventcode']) {
    die("error!! No Access!!");
}
$eventcode = $_GET['eventcode'];
$event = Event::select($db, $eventcode);
$eventname = $event->getName();
$shortdesc = $event->getShort_desc();
$longdesc = $event->getLong_desc();
$tags = $event->getTags();
$contacts = $event->getContacts();
$prize = $event->getPrize();
$prtpnt = $event->getPrtpnt();
$timings = $event->getTimings();
$venue = $event->getLocation_id();
$venue = Location::select($db, $venue);
require './includes/metadetails.php';
?>
<body>
    <script type="text/javascript" src="js/markitup/jquery.markitup.js"></script>
    <script type="text/javascript" src="js/markitup/settings.js"></script>

    <?php 
require './includes/header.php';
<?php

require_once 'connection.php';
$session = new Session();
if (!$session->getLoggedin() || $session->getUsertype() != Session::USER_ADMIN) {
    header("Location: login.php");
}
$olddb = new Database(DB_SERVER, DB_USER, DB_PASS, "nitcfest_tathva14");
$oldevents = Event::selectAllShort($olddb);
$oldoptions = "";
foreach ($oldevents as $event) {
    $oldoptions .= "<option value='{$event['code']}'>{$event['name']}</option>";
}
$events = Event::selectAllShort($db);
$options = "";
foreach ($events as $event) {
    $options .= "<option value='{$event['code']}'>{$event['name']}</option>";
}
require './includes/metadetails.php';
?>

<body>
<?php 
require './includes/header.php';
?>

    <div class="container-fluid">

<?php 
echo $session->getUsertype();
?>
<?php

require_once 'connection.php';
$session = new Session();
if (!$session->getLoggedin() || $session->getUsertype() != Session::USER_REGULAR) {
    header("Location: login.php");
}
$olddb = new Database(DB_SERVER, DB_USER, DB_PASS, "nitcfest_tathva14");
$oldevents = Event::selectAllShort($olddb);
$oldoptions = "";
foreach ($oldevents as $event) {
    $oldoptions .= "<option value='{$event['code']}'>{$event['name']}</option>";
}
$events = Event::selectAllShort($db);
$options = "";
foreach ($events as $event) {
    $options .= "<option value='{$event['code']}'>{$event['name']}</option>";
}
require './includes/metadetails.php';
?>

<body>
<?php 
require './includes/header.php';
?>

    <div class="container-fluid">

        <ul class="nav nav-tabs" role="tablist">
            <li role="presentation" class="active"><a href="#reglist" aria-controls="reglist" role="tab" data-toggle="tab">T14 Reglist</a></li>
            <li role="presentation"><a href="#reglist15" aria-controls="reglist15" role="tab" data-toggle="tab">T15 Reglist</a></li>
<?php

require_once 'connection.php';
$session = new Session();
if (!$session->getLoggedin() || $session->getUsertype() != Session::USER_MANAGER) {
    header("Location: login.php");
}
$olddb = new Database(DB_SERVER, DB_USER, DB_PASS, "nitcfest_tathva14");
$oldevents = Event::selectAllShort($olddb);
$oldoptions = "";
foreach ($oldevents as $event) {
    $oldoptions .= "<option value='{$event['code']}'>{$event['name']}</option>";
}
$events = Event::selectAllShort($db);
$options = "";
foreach ($events as $event) {
    $options .= "<option value='{$event['code']}'>{$event['name']}</option>";
}
$user = $session->getUsername();
$user = User::select($db, $user);
$eventcode = $user->getEventcode();
$event = Event::select($db, $eventcode);
require './includes/metadetails.php';
?>

<body>
<?php 
require './includes/header.php';
?>

    <div class="container-fluid">
<?php

require_once 'connection.php';
$session = new Session();
if (!$session->getLoggedin() || $session->getUsertype() != Session::USER_PROOFREADER) {
    header("Location: login.php");
}
$olddb = new Database(DB_SERVER, DB_USER, DB_PASS, "nitcfest_tathva14");
$oldevents = Event::selectAllShort($olddb);
$oldoptions = "";
foreach ($oldevents as $event) {
    $oldoptions .= "<option value='{$event['code']}'>{$event['name']}</option>";
}
$events = Event::selectAllShort($db);
$options = "";
foreach ($events as $event) {
    $options .= "<option value='{$event['code']}'>{$event['name']}</option>";
}
require './includes/metadetails.php';
?>

<body>
<?php 
require './includes/header.php';
?>

    <div class="container-fluid">

        <ul class="nav nav-tabs" role="tablist">
            <li role="presentation" class="active"><a href="#reglist" aria-controls="reglist" role="tab" data-toggle="tab">T14 Reglist</a></li>
            <li role="presentation"><a href="#reglist15" aria-controls="reglist15" role="tab" data-toggle="tab">T15 Reglist</a></li>