<?php
require_once 'functions.php';
if (isset($_POST['eventNo'])) {
$eventNo = $_POST['eventNo'];
//get the event type
$sql = "select * from event where eventNo='{$eventNo}'";
$event = mysql_fetch_array(mysql_query($sql));
$typeNumber = $event['type'];
//determine whether the user said they were attending or not attending
$attending = $_POST['attending'];
if ($typeNumber != "volunteer" && $attending != 1) {
die("You can only confirm not attending for volunteer events.");
}
$sql = "SELECT `callTime` FROM `event` WHERE `eventNo` = {$eventNo}";
$results = mysql_fetch_array(mysql_query($sql));
if (strtotime($results['callTime']) < time() + 86400 && $attending != 1) {
// Prevent changing to not attending less than 24 hours before call
echo '<span class="label label-important">Deadline is past</span>' . buttonArea($eventNo, $typeNumber);
return;
}
//update the attends relationship
$sql = "update `attends` set shouldAttend='{$attending}', confirmed='1' where memberID='{$USER}' and eventNo='{$eventNo}'";
mysql_query($sql);
//then echo the new buttons based on the new attends relationship
echo buttonArea($eventNo, $typeNumber);
} else {
echo "Something went wrong. Let a developer know.";
}
if ($tCount > 0) {
$t .= " or ";
}
$t .= "type='{$type}'";
$tCount++;
}
$sCount = 0;
$s = "";
foreach ($semesters as $semester) {
if ($sCount > 0) {
$s .= " or ";
}
$s .= "semester='{$semester}'";
$sCount++;
}
$sql = "select * from event where ({$t}) AND ({$s}) order by callTime desc";
$events = mysql_query($sql);
$html = '<div class="block span5" id="events"><table class="table" id="eventsTable">';
while ($row = mysql_fetch_array($events, MYSQL_ASSOC)) {
$eventDetails = getEventDetails($row['eventNo']);
$html = $html . '
<tr class="event" id="' . $eventDetails['eventNo'] . '">
<td>' . labelArea($eventDetails['type']) . '</td>
<td>' . $eventDetails['name'] . '</td>
<td>' . date("l, F d, Y", strtotime($eventDetails["callTime"])) . '</td>
<td>' . (strtotime($eventDetails['callTime']) > time() ? buttonArea($row['eventNo'], $eventDetails['type']) : '<span class="label label-inverse">This event is over</span>') . '</td>
</tr>
';
}
echo $html . '</table></div>';
eventExtras();
