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());
}
function unenrollstu($cid, $tounenroll, $delforum = false, $deloffline = false, $withwithdraw = false, $delwikirev = false, $usereplaceby = false)
{
$forums = array();
$threads = array();
$query = "SELECT id FROM imas_forums WHERE courseid='{$cid}'";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while ($row = mysql_fetch_row($result)) {
$forums[] = $row[0];
$q2 = "SELECT threadid FROM imas_forum_posts WHERE forumid='{$row[0]}'";
$r2 = mysql_query($q2) or die("Query failed : " . mysql_error());
while ($rw2 = mysql_fetch_row($r2)) {
$threads[] = $rw2[0];
}
}
$threadlist = implode(',', $threads);
$forumlist = implode(',', $forums);
$assesses = array();
$query = "SELECT id FROM imas_assessments WHERE courseid='{$cid}'";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while ($row = mysql_fetch_row($result)) {
$assesses[] = $row[0];
}
$aidlist = implode(',', $assesses);
$wikis = array();
$grpwikis = array();
$query = "SELECT id,groupsetid FROM imas_wikis WHERE courseid='{$cid}'";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while ($row = mysql_fetch_row($result)) {
$wikis[] = $row[0];
if ($row[1] > 0) {
$grpwikis[] = $row[0];
}
}
$wikilist = implode(',', $wikis);
$grpwikilist = implode(',', $grpwikis);
$drills = array();
$query = "SELECT id FROM imas_drillassess WHERE courseid='{$cid}'";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while ($row = mysql_fetch_row($result)) {
$drills[] = $row[0];
}
$drilllist = implode(',', $drills);
$exttools = array();
$query = "SELECT id FROM imas_linkedtext WHERE courseid='{$cid}' AND points>0";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while ($row = mysql_fetch_row($result)) {
$exttools[] = $row[0];
}
$exttoolslist = implode(',', $exttools);
$stugroups = array();
$query = "SELECT imas_stugroups.id FROM imas_stugroups JOIN imas_stugroupset ON imas_stugroups.groupsetid=imas_stugroupset.id WHERE imas_stugroupset.courseid='{$cid}'";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while ($row = mysql_fetch_row($result)) {
$stugroups[] = $row[0];
}
$curdir = rtrim(dirname(__FILE__), '/\\');
require_once "{$curdir}/filehandler.php";
if ($withwithdrawn == 'remove' || $usereplaceby) {
require_once "{$curdir}/updateassess.php";
}
if (count($tounenroll) > 0) {
$gbitems = array();
$query = "SELECT id FROM imas_gbitems WHERE courseid='{$cid}'";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while ($row = mysql_fetch_row($result)) {
$gbitems[] = $row[0];
}
$gblist = implode(',', $gbitems);
//new
$stulist = "'" . implode("','", $tounenroll) . "'";
if (count($assesses) > 0) {
deleteasidfilesbyquery2('userid', $tounenroll, $assesses);
//deleteasidfilesbyquery(array('assessmentid'=>$assesses, 'userid'=>$tounenroll));
$query = "DELETE FROM imas_assessment_sessions WHERE assessmentid IN ({$aidlist}) AND userid IN ({$stulist})";
mysql_query($query) or die("Query failed : {$query}" . mysql_error());
$query = "DELETE FROM imas_exceptions WHERE assessmentid IN ({$aidlist}) AND userid IN ({$stulist})";
mysql_query($query) or die("Query failed : {$query}" . mysql_error());
}
if (count($drills) > 0) {
$query = "DELETE FROM imas_drillassess_sessions WHERE drillassessid IN ({$drilllist}) AND userid IN ({$stulist})";
mysql_query($query) or die("Query failed : {$query}" . mysql_error());
}
if (count($exttools) > 0) {
$query = "DELETE FROM imas_grades WHERE gradetype='exttool' AND gradetypeid IN ({$exttoolslist}) AND userid IN ({$stulist})";
mysql_query($query) or die("Query failed : {$query}" . mysql_error());
}
if (count($gbitems) > 0) {
$query = "DELETE FROM imas_grades WHERE gradetype='offline' AND gradetypeid IN ({$gblist}) AND userid IN ({$stulist})";
mysql_query($query) or die("Query failed : {$query}" . mysql_error());
}
if (count($threads) > 0) {
$query = "DELETE FROM imas_forum_views WHERE threadid IN ({$threadlist}) AND userid IN ({$stulist})";
mysql_query($query) or die("Query failed : {$query}" . mysql_error());
}
if (count($wikis) > 0) {
$query = "DELETE FROM imas_wiki_views WHERE wikiid IN ({$wikilist}) AND userid IN ({$stulist})";
mysql_query($query) or die("Query failed : {$query}" . mysql_error());
}
if (count($stugroups) > 0) {
$stugrouplist = implode(',', $stugroups);
$query = "DELETE FROM imas_stugroupmembers WHERE userid IN ({$stulist}) AND stugroupid IN ({$stugrouplist})";
mysql_query($query) or die("Query failed : {$query}" . mysql_error());
}
}
if ($delforum && count($forums) > 0) {
$query = "DELETE imas_forum_threads FROM imas_forum_posts JOIN imas_forum_threads ON imas_forum_posts.threadid=imas_forum_threads.id AND imas_forum_posts.posttype=0 WHERE imas_forum_threads.forumid IN ({$forumlist})";
mysql_query($query) or die("Query failed : " . mysql_error());
$query = "SELECT id FROM imas_forum_posts WHERE forumid IN ({$forumlist}) AND files<>''";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while ($row = mysql_fetch_row($result)) {
deleteallpostfiles($row[0]);
}
$query = "DELETE FROM imas_forum_posts WHERE forumid IN ({$forumlist}) AND posttype=0";
mysql_query($query) or die("Query failed : " . mysql_error());
if (count($tounenroll) > 0) {
$query = "DELETE FROM imas_grades WHERE gradetype='forum' AND gradetypeid IN ({$forumlist}) AND userid IN ({$stulist})";
mysql_query($query) or die("Query failed : " . mysql_error());
}
/* //old
foreach ($forums as $fid) {
$query = "DELETE imas_forum_threads FROM imas_forum_posts JOIN imas_forum_threads ON imas_forum_posts.threadid=imas_forum_threads.id AND imas_forum_posts.posttype=0 WHERE imas_forum_threads.forumid='$fid'";
mysql_query($query) or die("Query failed : " . mysql_error());
$query = "DELETE FROM imas_forum_posts WHERE forumid='$fid' AND posttype=0";
mysql_query($query) or die("Query failed : " . mysql_error());
}*/
}
if ($delwikirev === 1 && count($wikis) > 0) {
$query = "DELETE FROM imas_wiki_revisions WHERE wikiid IN ({$wikilist})";
mysql_query($query) or die("Query failed : " . mysql_error());
} else {
if ($delwikirev === 2 && count($grpwikis) > 0) {
$query = "DELETE FROM imas_wiki_revisions WHERE wikiid IN ({$grpwikilist})";
mysql_query($query) or die("Query failed : " . mysql_error());
}
}
if ($deloffline) {
$query = "DELETE FROM imas_gbitems WHERE courseid='{$cid}'";
mysql_query($query) or die("Query failed : " . mysql_error());
}
if ($withwithdraw == 'unwithdraw' && count($assesses) > 0) {
$query = "UPDATE imas_questions SET withdrawn=0 WHERE assessmentid IN ({$aidlist})";
mysql_query($query) or die("Query failed : " . mysql_error());
/*foreach ($assesses as $aid) {
$query = "UPDATE imas_questions SET withdrawn=0 WHERE assessmentid='$aid'";
mysql_query($query) or die("Query failed : " . mysql_error());
}*/
}
if ($withwithdrawn == 'remove' || $usereplaceby) {
$msg = updateassess($cid, $withwithdraw == 'remove', $usereplaceby);
}
if (count($tounenroll) > 0) {
$query = "DELETE FROM imas_students WHERE userid IN ({$stulist}) AND courseid='{$cid}'";
mysql_query($query) or die("Query failed : {$query}" . mysql_error());
$query = "DELETE FROM imas_login_log WHERE userid IN ({$stulist}) AND courseid='{$cid}'";
mysql_query($query) or die("Query failed : {$query}" . mysql_error());
$query = "DELETE FROM imas_content_track WHERE userid IN ({$stulist}) AND courseid='{$cid}'";
mysql_query($query) or die("Query failed : {$query}" . mysql_error());
}
}
}
$query = "DELETE FROM imas_forum_posts WHERE threadid='{$_GET['remove']}'";
mysql_query($query) or die("Query failed : {$query} " . mysql_error());
$query = "DELETE FROM imas_forum_threads WHERE id='{$_GET['remove']}'";
mysql_query($query) or die("Query failed : {$query} " . mysql_error());
$query = "DELETE FROM imas_forum_views WHERE threadid='{$_GET['remove']}'";
mysql_query($query) or die("Query failed : {$query} " . mysql_error());
$lastpost = true;
} else {
$query = "DELETE FROM imas_forum_posts WHERE id='{$_GET['remove']}'";
mysql_query($query) or die("Query failed : {$query} " . mysql_error());
$query = "UPDATE imas_forum_posts SET parent='{$parent}' WHERE parent='{$_GET['remove']}'";
mysql_query($query) or die("Query failed : {$query} " . mysql_error());
$lastpost = false;
if ($files != '') {
deleteallpostfiles($_GET['remove']);
}
}
$query = "DELETE FROM imas_grades WHERE gradetype='forum' AND refid='{$_GET['remove']}'";
mysql_query($query) or die("Query failed : {$query} " . mysql_error());
}
if ($caller == "posts" && $lastpost) {
header('Location: ' . $urlmode . $_SERVER['HTTP_HOST'] . rtrim(dirname($_SERVER['PHP_SELF']), '/\\') . "/thread.php?page={$page}&cid={$cid}&forum={$forumid}");
} else {
header('Location: ' . $urlmode . $_SERVER['HTTP_HOST'] . rtrim(dirname($_SERVER['PHP_SELF']), '/\\') . "/{$returnurl}");
}
exit;
} else {
$pagetitle = "Remove Post";
$query = "SELECT parent FROM imas_forum_posts WHERE id='{$_GET['remove']}'";
$result = mysql_query($query) or die("Query failed : {$query} " . mysql_error());
for ($i = 1; $i < count($blocktree); $i++) {
$sub =& $sub[$blocktree[$i] - 1]['items'];
//-1 to adjust for 1-indexing
}
$key = array_search($itemid, $sub);
array_splice($sub, $key, 1);
$itemorder = addslashes(serialize($items));
$query = "UPDATE imas_courses SET itemorder='{$itemorder}' WHERE id='{$cid}'";
mysql_query($query) or die("Query failed : " . mysql_error());
$query = "DELETE FROM imas_forum_subscriptions WHERE forumid='{$forumid}'";
mysql_query($query) or die("Query failed : " . mysql_error());
require_once "../includes/filehandler.php";
$query = "SELECT id FROM imas_forum_posts WHERE forumid='{$forumid}' 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_views WHERE threadid IN (SELECT id FROM imas_forum_threads WHERE forumid='{$forumid}')";
mysql_query($query) or die("Query failed : {$query} " . mysql_error());
$query = "DELETE FROM imas_forum_posts WHERE forumid='{$forumid}'";
mysql_query($query) or die("Query failed : {$query} " . mysql_error());
$query = "DELETE FROM imas_forum_threads WHERE forumid='{$forumid}'";
mysql_query($query) or die("Query failed : {$query} " . mysql_error());
header('Location: ' . $urlmode . $_SERVER['HTTP_HOST'] . rtrim(dirname($_SERVER['PHP_SELF']), '/\\') . "/course.php?cid={$_GET['cid']}");
exit;
} else {
$query = "SELECT name FROM imas_forums WHERE id='{$_GET['id']}'";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$itemname = mysql_result($result, 0, 0);
}
}
