if ($_POST['replyby'] == "Never") {
$replyby = 0;
} else {
$replyby = parsedatetime($_POST['replybydate'], $_POST['replybytime']);
}
}
$sets[] = "replyby='{$replyby}'";
}
if (isset($_POST['chgreplyby'])) {
if ($_POST['postby'] == "Always") {
$postby = 2000000000;
} else {
if ($_POST['postby'] == "Never") {
$postby = 0;
} else {
$postby = parsedatetime($_POST['postbydate'], $_POST['postbytime']);
}
}
$sets[] = "postby='{$postby}'";
}
if (isset($_POST['chgcaltag'])) {
$sets[] = "caltag='" . $_POST['caltagpost'] . '--' . $_POST['caltagreply'] . "'";
}
$sops = array();
if (isset($_POST['chgallowanon'])) {
if (isset($_POST['allowanon']) && $_POST['allowanon'] == 1) {
//turn on 1's bit
$sops[] = " | 1";
} else {
//turn off 1's bit
$sops[] = " & ~1";
/*
if ($_POST['edatetype'.$i]=='0') {
$enddate = 2000000000;
} else {
$enddate = parsedatetime($_POST['edate'.$i],$_POST['etime'.$i]);
}
*/
if ($data[2] != 'NA') {
if ($data[2] == 'A') {
$reviewdate = 2000000000;
} else {
if ($data[2] == 'N') {
$reviewdate = 0;
} else {
$pts = explode('~', $data[2]);
$reviewdate = parsedatetime($pts[0], $pts[1]);
}
}
}
/*
if (isset($_POST['rdatetype'.$i])) {
if ($_POST['rdatetype'.$i]=='0') {
$reviewdate = $_POST['rdatean'.$i];
} else {
$reviewdate = parsedatetime($_POST['rdate'.$i],$_POST['rtime'.$i]);
}
}
*/
$type = $data[3];
// $_POST['type'.$i];
$id = $data[4];
}
$curBreadcrumb .= "<a href=\"gb-viewasid.php?cid={$cid}&asid={$asid}&uid={$uid}\">Assessment Detail</a> > Make Exception\n";
if (!isset($teacherid)) {
// loaded by a NON-teacher
$overwriteBody = 1;
$body = "You need to log in as a teacher to access this page";
} elseif (!isset($_GET['cid'])) {
$overwriteBody = 1;
$body = "You need to access this page from the course page menu";
} else {
// PERMISSIONS ARE OK, PROCEED WITH PROCESSING
$cid = $_GET['cid'];
$waivereqscore = isset($_POST['waivereqscore']) ? 1 : 0;
if (isset($_POST['sdate'])) {
$startdate = parsedatetime($_POST['sdate'], $_POST['stime']);
$enddate = parsedatetime($_POST['edate'], $_POST['etime']);
//check if exception already exists
$query = "SELECT id FROM imas_exceptions WHERE userid='{$_GET['uid']}' AND assessmentid='{$_GET['aid']}'";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$row = mysql_fetch_row($result);
if ($row != null) {
$query = "UPDATE imas_exceptions SET startdate={$startdate},enddate={$enddate},islatepass=0,waivereqscore={$waivereqscore} WHERE id='{$row[0]}'";
mysql_query($query) or die("Query failed :{$query} " . mysql_error());
} else {
$query = "INSERT INTO imas_exceptions (userid,assessmentid,startdate,enddate,waivereqscore) VALUES ";
$query .= "('{$_GET['uid']}','{$_GET['aid']}',{$startdate},{$enddate},{$waivereqscore})";
$result = mysql_query($query) or die("Query failed :{$query} " . mysql_error());
}
if (isset($_POST['eatlatepass'])) {
$n = intval($_POST['latepassn']);
$query = "UPDATE imas_students SET latepass = CASE WHEN latepass>{$n} THEN latepass-{$n} ELSE 0 END WHERE userid='{$_GET['uid']}' AND courseid='{$cid}'";
if ($_POST['edatetype'] == '2000000000') {
$enddate = 2000000000;
} else {
$enddate = parsedatetime($_POST['edate'], $_POST['etime']);
}
} else {
$startdate = 0;
$enddate = 2000000000;
}
if ($_POST['rdatetype'] == 'Always') {
$revisedate = 2000000000;
} else {
if ($_POST['rdatetype'] == 'Never') {
$revisedate = 0;
} else {
$revisedate = parsedatetime($_POST['rdate'], $_POST['rtime']);
}
}
$settings = intval($_POST['settings']);
$_POST['name'] = addslashes(htmlentities(stripslashes($_POST['name'])));
require_once "../includes/htmLawed.php";
$htmlawedconfig = array('elements' => '*-script');
if ($_POST['description'] == '<p>Enter Wiki description here</p>') {
$_POST['description'] = '';
} else {
$_POST['description'] = addslashes(htmLawed(stripslashes($_POST['description']), $htmlawedconfig));
}
if (isset($_GET['id'])) {
//already have id - update
$query = "UPDATE imas_wikis SET name='{$_POST['name']}',description='{$_POST['description']}',startdate={$startdate},enddate={$enddate},";
$query .= "editbydate={$revisedate},avail='{$_POST['avail']}',groupsetid='{$_POST['groupsetid']}',settings={$settings} ";
}
echo '<p><p><input type="submit" value="Yes, Delete"/>';
echo '<input type=button value="Nevermind" class="secondarybtn" onClick="window.location=\'gradebook.php?cid=' . $cid . '\'"></p>';
echo '</form>';
require "../footer.php";
exit;
}
} else {
require_once "../includes/parsedatetime.php";
$checkedlist = "'" . implode("','", $checked) . "'";
$sets = array();
if (isset($_POST['chgshowafter'])) {
if ($_POST['sdatetype'] == '0') {
$showdate = 0;
} else {
$showdate = parsedatetime($_POST['sdate'], $_POST['stime']);
}
$sets[] = "showdate='{$showdate}'";
}
if (isset($_POST['chgcount'])) {
$sets[] = "cntingb='{$_POST['cntingb']}'";
}
if (isset($_POST['chgtutoredit'])) {
$sets[] = "tutoredit='{$_POST['tutoredit']}'";
}
if (isset($_POST['chggbcat'])) {
$sets[] = "gbcategory='{$_POST['gbcat']}'";
}
if (count($sets) > 0) {
$setslist = implode(',', $sets);
$query = "UPDATE imas_gbitems SET {$setslist} WHERE id IN ({$checkedlist})";
$startdate = parsedatetime($_POST['sdate'], $_POST['stime']);
}
}
if ($_POST['edatetype'] == '2000000000') {
$enddate = 2000000000;
} else {
$enddate = parsedatetime($_POST['edate'], $_POST['etime']);
}
$oncal = $_POST['oncal'];
} else {
if ($_POST['avail'] == 2) {
if ($_POST['altoncal'] == 0) {
$startdate = 0;
$oncal = 0;
} else {
$startdate = parsedatetime($_POST['cdate'], "12:00 pm");
$oncal = 1;
$caltag = $_POST['altcaltag'];
}
$enddate = 2000000000;
} else {
$startdate = 0;
$enddate = 2000000000;
$oncal = 0;
}
}
$processingerror = false;
if ($_POST['linktype'] == 'text') {
require_once "../includes/htmLawed.php";
$htmlawedconfig = array('elements' => '*-script');
$_POST['text'] = addslashes(htmLawed(stripslashes($_POST['text']), $htmlawedconfig));
} else {
$isanon = 0;
}
if ($isteacher) {
$type = $_POST['type'];
if (!isset($_POST['replyby']) || $_POST['replyby'] == "null") {
$replyby = "NULL";
} else {
if ($_POST['replyby'] == "Always") {
$replyby = 2000000000;
} else {
if ($_POST['replyby'] == "Never") {
$replyby = 0;
} else {
require_once "../includes/parsedatetime.php";
$replyby = parsedatetime($_POST['replybydate'], $_POST['replybytime']);
}
}
}
} else {
$type = 0;
$replyby = "NULL";
}
if (isset($_POST['tag'])) {
$tag = $_POST['tag'];
} else {
$tag = '';
}
$_POST['subject'] = addslashes(htmlentities(stripslashes($_POST['subject'])));
require_once "../includes/htmLawed.php";
$htmlawedconfig = array('elements' => '*-script-form');
}
$curBreadcrumb = "{$breadcrumbbase} <a href=\"course.php?cid={$cid}\"> {$coursename}</a> ";
$curBreadcrumb .= "> <a href=\"listusers.php?cid={$cid}\">Roster</a> > Login Grid";
$overwriteBody = 0;
$body = "";
if (!isset($teacherid)) {
// loaded by a NON-teacher
$overwriteBody = 1;
$body = "You need to log in as a teacher to access this page";
} else {
// PERMISSIONS ARE OK, PROCEED WITH PROCESSING
$now = time();
if (isset($_POST['daterange'])) {
require "../includes/parsedatetime.php";
$start = parsedatetime($_POST['sdate'], '12:00am');
$end = parsedatetime($_POST['edate'], '11:59pm');
if (($end - $start) / 86400 > 365) {
$start = $end - 365 * 24 * 60 * 60;
}
} else {
if (isset($_GET['start']) && $_GET['start'] + 7 * 24 * 60 * 60 <= $now) {
$start = intval($_GET['start']);
$end = $start + 7 * 24 * 60 * 60;
} else {
$end = $now;
$start = 86400 * ceil(($now - $tzoffset * 60) / 86400) + $tzoffset * 60 - 7 * 24 * 60 * 60;
}
}
$starttime = tzdate("M j, Y, g:i a", $start);
$endtime = tzdate("M j, Y, g:i a", $end);
$sdate = tzdate("m/d/Y", $start);
