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'];
$block = $_GET['block'];
if (isset($_GET['clearattempts'])) {
//FORM POSTED WITH CLEAR ATTEMPTS FLAG
if ($_GET['clearattempts'] == "confirmed") {
require_once '../includes/filehandler.php';
deleteallaidfiles($_GET['id']);
$query = "DELETE FROM imas_assessment_sessions WHERE assessmentid='{$_GET['id']}'";
mysql_query($query) or die("Query failed : " . mysql_error());
$query = "UPDATE imas_questions SET withdrawn=0 WHERE assessmentid='{$_GET['id']}'";
mysql_query($query) or die("Query failed : " . mysql_error());
header('Location: ' . $urlmode . $_SERVER['HTTP_HOST'] . rtrim(dirname($_SERVER['PHP_SELF']), '/\\') . "/addassessment.php?cid={$_GET['cid']}&id={$_GET['id']}");
exit;
} else {
$overwriteBody = 1;
$query = "SELECT name FROM imas_assessments WHERE id={$_GET['id']}";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$assessmentname = mysql_result($result, 0, 0);
$body = "<div class=breadcrumb>{$breadcrumbbase} <a href=\"course.php?cid={$_GET['cid']}\">{$coursename}</a> ";
$body .= "> <a href=\"addassessment.php?cid={$_GET['cid']}&id={$_GET['id']}\">Modify Assessment</a> > Clear Attempts</div>\n";
$body .= "<h3>{$assessmentname}</h3>";
$body .= "<p>Are you SURE you want to delete all attempts (grades) for this assessment?</p>";
if (isset($_GET['modqs'])) {
if (!isset($_POST['checked']) && !isset($_POST['qids'])) {
$overwriteBody = 1;
$body = "No questions selected. <a href=\"addquestions.php?cid={$cid}&aid={$aid}\">Go back</a>\n";
} else {
include "modquestiongrid.php";
if (isset($_GET['process'])) {
header('Location: ' . $urlmode . $_SERVER['HTTP_HOST'] . rtrim(dirname($_SERVER['PHP_SELF']), '/\\') . "/addquestions.php?cid={$cid}&aid={$aid}");
exit;
}
}
}
if (isset($_GET['clearattempts'])) {
if ($_GET['clearattempts'] == "confirmed") {
require_once '../includes/filehandler.php';
deleteallaidfiles($aid);
$query = "DELETE FROM imas_assessment_sessions WHERE assessmentid='{$aid}'";
mysql_query($query) or die("Query failed : " . mysql_error());
$query = "UPDATE imas_questions SET withdrawn=0 WHERE assessmentid='{$aid}'";
mysql_query($query) or die("Query failed : " . mysql_error());
header('Location: ' . $urlmode . $_SERVER['HTTP_HOST'] . rtrim(dirname($_SERVER['PHP_SELF']), '/\\') . "/addquestions.php?cid={$cid}&aid={$aid}");
exit;
} else {
$overwriteBody = 1;
$query = "SELECT name FROM imas_assessments WHERE id={$_GET['aid']}";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$assessmentname = mysql_result($result, 0, 0);
$body = "<div class=breadcrumb>{$curBreadcrumb}</div>\n";
$body .= "<h3>{$assessmentname}</h3>";
$body .= "<p>Are you SURE you want to delete all attempts (grades) for this assessment?</p>";
$body .= "<p><input type=button value=\"Yes, Clear\" onClick=\"window.location='addquestions.php?cid={$cid}&aid={$aid}&clearattempts=confirmed'\">\n";
function delitembyid($itemid)
{
$query = "SELECT itemtype,typeid FROM imas_items WHERE id='{$itemid}'";
$result = mysql_query($query) or die("Query failed :{$query} " . mysql_error());
list($itemtype, $typeid) = mysql_fetch_row($result);
if ($itemtype == "InlineText") {
$query = "DELETE FROM imas_inlinetext WHERE id='{$typeid}'";
mysql_query($query) or die("Query failed : " . mysql_error());
$query = "SELECT filename FROM imas_instr_files WHERE itemid='{$typeid}'";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
//$uploaddir = rtrim(dirname(__FILE__), '/\\') .'/files/';
while ($row = mysql_fetch_row($result)) {
$safefn = addslashes($row[0]);
$query = "SELECT id FROM imas_instr_files WHERE filename='{$safefn}'";
$r2 = mysql_query($query) or die("Query failed : " . mysql_error());
if (mysql_num_rows($r2) == 1) {
//unlink($uploaddir . $row[0]);
deletecoursefile($row[0]);
}
}
$query = "DELETE FROM imas_instr_files WHERE itemid='{$typeid}'";
mysql_query($query) or die("Query failed : " . mysql_error());
} else {
if ($itemtype == "LinkedText") {
$query = "SELECT text FROM imas_linkedtext WHERE id='{$typeid}'";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$text = mysql_result($result, 0, 0);
if (substr($text, 0, 5) == 'file:') {
//delete file if not used
$safetext = addslashes($text);
$query = "SELECT id FROM imas_linkedtext WHERE text='{$safetext}'";
//any others using file?
$result = mysql_query($query) or die("Query failed : " . mysql_error());
if (mysql_num_rows($result) == 1) {
//$uploaddir = rtrim(dirname(__FILE__), '/\\') .'/files/';
$filename = substr($text, 5);
//unlink($uploaddir . $filename);
deletecoursefile($filename);
}
}
$query = "DELETE FROM imas_linkedtext WHERE id='{$typeid}'";
mysql_query($query) or die("Query failed : " . mysql_error());
} else {
if ($itemtype == "Forum") {
$query = "DELETE FROM imas_forums WHERE id='{$typeid}'";
mysql_query($query) or die("Query failed : " . mysql_error());
$query = "SELECT id FROM imas_forum_posts WHERE forumid='{$typeid}' AND files<>''";
$result = mysql_query($query) or die("Query failed : {$query} " . mysql_error());
while ($row = mysql_fetch_row($result)) {
deleteallpostfiles($row[0]);
}
$query = "DELETE FROM imas_forum_subscriptions WHERE forumid='{$typeid}'";
mysql_query($query) or die("Query failed : " . mysql_error());
$query = "DELETE FROM imas_forum_views WHERE threadid IN (SELECT id FROM imas_forum_threads WHERE forumid='{$typeid}')";
mysql_query($query) or die("Query failed : {$query} " . mysql_error());
$query = "DELETE FROM imas_forum_posts WHERE forumid='{$typeid}'";
mysql_query($query) or die("Query failed : {$query} " . mysql_error());
$query = "DELETE FROM imas_forum_threads WHERE forumid='{$typeid}'";
mysql_query($query) or die("Query failed : {$query} " . mysql_error());
} else {
if ($itemtype == "Assessment") {
deleteallaidfiles($typeid);
$query = "DELETE FROM imas_assessment_sessions WHERE assessmentid='{$typeid}'";
mysql_query($query) or die("Query failed : " . mysql_error());
$query = "DELETE FROM imas_questions WHERE assessmentid='{$typeid}'";
mysql_query($query) or die("Query failed : " . mysql_error());
$query = "DELETE FROM imas_assessments WHERE id='{$typeid}'";
mysql_query($query) or die("Query failed : " . mysql_error());
} else {
if ($itemtype == "Drill") {
$query = "DELETE FROM imas_drillassess_sessions WHERE drillassessid='{$typeid}'";
mysql_query($query) or die("Query failed : " . mysql_error());
$query = "DELETE FROM imas_drillassess WHERE id='{$typeid}'";
mysql_query($query) or die("Query failed : " . mysql_error());
} else {
if ($itemtype == 'Wiki') {
$query = "DELETE FROM imas_wikis WHERE id='{$typeid}'";
mysql_query($query) or die("Query failed : " . mysql_error());
$query = "DELETE FROM imas_wiki_revisions WHERE wikiid='{$typeid}'";
mysql_query($query) or die("Query failed : " . mysql_error());
$query = "DELETE FROM imas_wiki_views WHERE wikiid='{$typeid}'";
mysql_query($query) or die("Query failed : {$query} " . mysql_error());
}
}
}
}
}
}
$query = "DELETE FROM imas_items WHERE id='{$itemid}'";
mysql_query($query) or die("Query failed : " . mysql_error());
}
$result = mysql_query($query) or die("Query failed : " . mysql_error());
if (mysql_num_rows($result) > 0) {
$query = "DELETE FROM imas_courses WHERE id='{$_GET['id']}'";
} else {
break;
}
}
mysql_query($query) or die("Query failed : " . mysql_error());
if (mysql_affected_rows() == 0) {
break;
}
$query = "SELECT id FROM imas_assessments WHERE courseid='{$_GET['id']}'";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
require_once "../includes/filehandler.php";
while ($line = mysql_fetch_row($result)) {
deleteallaidfiles($line[0]);
$query = "DELETE FROM imas_questions WHERE assessmentid='{$line[0]}'";
mysql_query($query) or die("Query failed : " . mysql_error());
$query = "DELETE FROM imas_assessment_sessions WHERE assessmentid='{$line[0]}'";
mysql_query($query) or die("Query failed : " . mysql_error());
$query = "DELETE FROM imas_exceptions WHERE assessmentid='{$line[0]}'";
mysql_query($query) or die("Query failed : " . mysql_error());
}
$query = "DELETE FROM imas_assessments WHERE courseid='{$_GET['id']}'";
mysql_query($query) or die("Query failed : " . mysql_error());
$query = "SELECT id FROM imas_drillassess WHERE courseid='{$_GET['id']}'";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while ($line = mysql_fetch_row($result)) {
$query = "DELETE FROM imas_drillassess_sessions WHERE drillassessid='{$line[0]}'";
mysql_query($query) or die("Query failed : " . mysql_error());
}
