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);