<?php
require_once './functions.php';
if (isset($_POST['eventNo'])) {
$eventNo = $_POST['eventNo'];
$memberID = $_POST['email'];
$didAttend = $_POST['didAttend'];
//get the current attends info
$sql = "select didAttend from attends where memberID='{$memberID}' and eventNo='{$eventNo}'";
$attendses = mysql_query($sql);
//make a new attends relationship, if it doesn't already exist
if (mysql_num_rows($attendses) == 0) {
$sql = "INSERT INTO attends (memberID, shouldAttend, didAttend, eventNo, minutesLate, confirmed) VALUES ('{$memberID}', '0', '{$didAttend}', '{$eventNo}', '0', '1')";
mysql_query($sql);
} else {
$sql = "update attends set confirmed='1', didAttend='{$didAttend}' where memberID='{$memberID}' and eventNo='{$eventNo}'";
mysql_query($sql);
}
//get the user's first and last name
$sql = "select * from member where email='{$memberID}'";
$member = mysql_fetch_array(mysql_query($sql));
$firstName = $member['firstName'];
$lastName = $member['lastName'];
//get the updated attendance info and th recalculated grade
echo getEventAttendanceRows($eventNo);
} else {
echo "Something went wrong :/";
}
border-top: 1pt solid black;
border-bottom: 1pt solid black;
border-left: 1pt solid black;
border-right: 1pt solid black;
}
.data {
border-top: 1px dotted #000000;
border-bottom: 1px dotted #000000;
}
</style>
<script type="text/javascript" src="./js/drewJS.js"></script>
</head>
<?php
if (isset($_COOKIE['email'])) {
require_once './functions.php';
$userEmail = $_COOKIE['email'];
}
if (isset($_POST['eventNo'])) {
$eventNo = $_POST['eventNo'];
$sql = "select name from event where eventNo='{$eventNo}'";
$event = mysql_fetch_array(mysql_query($sql));
$name = $event['name'];
$html = "<html>\n\t\t<p style='text-align: center; font-weight: bold;'>{$name} Attendance</p> \n\t\t<p id='attendanceList'>\n\t\t\t<table id='{$eventNo}" . "_table'>\n\t\t\t\t" . getEventAttendanceRows($eventNo) . "\n\t\t\t</table>\n\t\t</p>\n\t\t</html>";
} else {
$html = "<(><)> Something went wrong <(><)>";
}
echo $html;
?>
<?php
require_once './functions.php';
$eventNo = mysql_real_escape_string($_POST['eventNo']);
if (!attendancePermission($USER, $eventNo)) {
die("Access denied");
}
if (!isset($eventNo)) {
die("Missing event number");
}
$sql = "select `name`, `section` from `event` where `eventNo` = '{$eventNo}'";
$event = mysql_fetch_array(mysql_query($sql));
$name = $event['name'];
$html = "<div class='pull-right'><button class='btn' onclick='excuseall({$eventNo})'>Excuse Unconfirmed</button></div>\n<p style='text-align: center; font-weight: bold;'>{$name} Attendance</p> \n<p id='attendanceList'><table id='{$eventNo}" . "_table'>" . getEventAttendanceRows($eventNo) . "</table></p>";
echo $html;
