function file_storage_delete($course)
{
global $db;
require AT_INCLUDE_PATH . '../mods/_standard/file_storage/file_storage.inc.php';
// delete course files:
fs_delete_workspace(WORKSPACE_COURSE, $course);
}
function file_storage_delete_group($group_id)
{
$sql = "DELETE FROM %sfile_storage_groups WHERE group_id=%d";
$result = queryDB($sql, array(TABLE_PREFIX, $group_id));
require_once AT_INCLUDE_PATH . '../mods/_standard/file_storage/file_storage.inc.php';
fs_delete_workspace(WORKSPACE_GROUP, $group_id);
}
function file_storage_delete_group($group_id)
{
global $db;
$sql = "DELETE FROM " . TABLE_PREFIX . "file_storage_groups WHERE group_id={$group_id}";
$result = mysql_query($sql, $db);
require_once AT_INCLUDE_PATH . '../mods/_standard/file_storage/file_storage.inc.php';
fs_delete_workspace(WORKSPACE_GROUP, $group_id);
}
function assignments_delete($course)
{
global $db;
require_once AT_INCLUDE_PATH . '../mods/_standard/file_storage/file_storage.inc.php';
$sql = "SELECT assignment_id FROM " . TABLE_PREFIX . "assignments WHERE course_id={$course}";
$result = mysql_query($sql, $db);
while ($row = mysql_fetch_assoc($result)) {
fs_delete_workspace(WORKSPACE_ASSIGNMENT, $row['assignment_id']);
}
// delete assignment folders/files from file storage
$sql = "DELETE FROM " . TABLE_PREFIX . "assignments WHERE course_id={$course}";
mysql_query($sql, $db);
}
function assignments_delete($course)
{
global $db;
require_once AT_INCLUDE_PATH . '../mods/_standard/file_storage/file_storage.inc.php';
$sql = "SELECT assignment_id FROM %sassignments WHERE course_id=%d";
$rows_assignments = queryDB($sql, array(TABLE_PREFIX, $course));
/////
// NOT SURE WHY THIS IS HERE
foreach ($rows_assignments as $row) {
fs_delete_workspace(WORKSPACE_ASSIGNMENT, $row['assignment_id']);
}
// delete assignment folders/files from file storage
$sql = "DELETE FROM %sassignments WHERE course_id=%d";
queryDB($sql, array(TABLE_PREFIX, $course));
}
function file_storage_delete($course)
{
global $db;
require AT_INCLUDE_PATH . '../mods/_standard/file_storage/file_storage.inc.php';
// delete course files:
fs_delete_workspace(WORKSPACE_COURSE, $course);
/**
Commented by Cindy Li on Dec 3, 2008. The private student files might be used in other courses.
These files are only deleted when the student is deleted.
*/
// delete private student files:
// $sql = "SELECT member_id FROM ".TABLE_PREFIX."course_enrollment WHERE course_id=$course";
// $result = mysql_query($sql, $db);
// while ($student_row = mysql_fetch_assoc($result)) {
// fs_delete_workspace(WORKSPACE_PERSONAL, $student_row['member_id']);
// }
}
function delete_user($id)
{
global $db, $msg;
//make sure not instructor of a course
$sql = "SELECT course_id FROM " . TABLE_PREFIX . "courses WHERE member_id={$id}";
$result = mysql_query($sql, $db);
if ($row = mysql_fetch_assoc($result)) {
/*$msg->addError('NODELETE_USER');
header('Location: '.AT_BASE_HREF.'users.php');
exit;*/
return;
}
$sql = "DELETE FROM " . TABLE_PREFIX . "course_enrollment WHERE member_id={$id}";
mysql_query($sql, $db);
write_to_log(AT_ADMIN_LOG_DELETE, 'course_enrollment', mysql_affected_rows($db), $sql);
$sql = "DELETE FROM " . TABLE_PREFIX . "forums_accessed WHERE member_id={$id}";
mysql_query($sql, $db);
write_to_log(AT_ADMIN_LOG_DELETE, 'forums_accessed', mysql_affected_rows($db), $sql);
$sql = "DELETE FROM " . TABLE_PREFIX . "forums_subscriptions WHERE member_id={$id}";
mysql_query($sql, $db);
write_to_log(AT_ADMIN_LOG_DELETE, 'forums_subscriptions', mysql_affected_rows($db), $sql);
/****/
/* delete forum threads block: */
/* delete the thread replies: */
$sql = "SELECT COUNT(*) AS cnt, parent_id, forum_id FROM " . TABLE_PREFIX . "forums_threads WHERE member_id={$id} AND parent_id<>0 GROUP BY parent_id";
$result = mysql_query($sql, $db);
while ($row = mysql_fetch_assoc($result)) {
/* update the forum posts counter */
$sql = "UPDATE " . TABLE_PREFIX . "forums SET num_posts=num_posts - {$row['cnt']}, last_post=last_post WHERE forum_id={$row['forum_id']}";
mysql_query($sql, $db);
write_to_log(AT_ADMIN_LOG_UPDATE, 'forums', mysql_affected_rows($db), $sql);
/* update the topics reply counter */
$sql = "UPDATE " . TABLE_PREFIX . "forums_threads SET num_comments=num_comments-{$row['cnt']}, last_comment=last_comment, date=date WHERE post_id={$row['parent_id']}";
mysql_query($sql, $db);
write_to_log(AT_ADMIN_LOG_UPDATE, 'forums_threads', mysql_affected_rows($db), $sql);
}
/* delete threads this member started: */
$sql = "SELECT post_id, forum_id, num_comments FROM " . TABLE_PREFIX . "forums_threads WHERE member_id={$id} AND parent_id=0";
$result = mysql_query($sql, $db);
while ($row = mysql_fetch_assoc($result)) {
/* update the forum posts and topics counters */
$num_posts = $row['num_comments'] + 1;
$sql = "UPDATE " . TABLE_PREFIX . "forums SET num_topics=num_topics-1, num_posts=num_posts - {$num_posts}, last_post=last_post WHERE forum_id={$row['forum_id']}";
mysql_query($sql, $db);
write_to_log(AT_ADMIN_LOG_UPDATE, 'forums', mysql_affected_rows($db), $sql);
/* delete the replies */
$sql = "DELETE FROM " . TABLE_PREFIX . "forums_threads WHERE parent_id={$row['post_id']}";
mysql_query($sql, $db);
write_to_log(AT_ADMIN_LOG_DELETE, 'forums_threads', mysql_affected_rows($db), $sql);
}
/* delete the actual threads */
$sql = "DELETE FROM " . TABLE_PREFIX . "forums_threads WHERE member_id={$id}";
mysql_query($sql, $db);
write_to_log(AT_ADMIN_LOG_DELETE, 'forums_threads', mysql_affected_rows($db), $sql);
/* end delete forum threads block. */
/****/
$sql = "DELETE FROM " . TABLE_PREFIX . "instructor_approvals WHERE member_id={$id}";
mysql_query($sql, $db);
write_to_log(AT_ADMIN_LOG_DELETE, 'instructor_approvals', mysql_affected_rows($db), $sql);
$sql = "DELETE FROM " . TABLE_PREFIX . "messages WHERE from_member_id={$id} OR to_member_id={$id}";
mysql_query($sql, $db);
write_to_log(AT_ADMIN_LOG_DELETE, 'messages', mysql_affected_rows($db), $sql);
$sql = "DELETE FROM " . TABLE_PREFIX . "polls_members WHERE member_id={$id}";
mysql_query($sql, $db);
write_to_log(AT_ADMIN_LOG_DELETE, 'polls_members', mysql_affected_rows($db), $sql);
$sql = "DELETE FROM " . TABLE_PREFIX . "tests_answers WHERE member_id={$id}";
mysql_query($sql, $db);
write_to_log(AT_ADMIN_LOG_DELETE, 'tests_answers', mysql_affected_rows($db), $sql);
$sql = "DELETE FROM " . TABLE_PREFIX . "tests_results WHERE member_id='{$id}'";
mysql_query($sql, $db);
write_to_log(AT_ADMIN_LOG_DELETE, 'tests_results', mysql_affected_rows($db), $sql);
$sql = "DELETE FROM " . TABLE_PREFIX . "users_online WHERE member_id={$id}";
mysql_query($sql, $db);
write_to_log(AT_ADMIN_LOG_DELETE, 'users_online', mysql_affected_rows($db), $sql);
$sql = "DELETE FROM " . TABLE_PREFIX . "members WHERE member_id={$id}";
mysql_query($sql, $db);
write_to_log(AT_ADMIN_LOG_DELETE, 'members', mysql_affected_rows($db), $sql);
$sql = "DELETE FROM " . TABLE_PREFIX . "member_track WHERE member_id={$id}";
mysql_query($sql, $db);
write_to_log(AT_ADMIN_LOG_DELETE, 'member_track', mysql_affected_rows($db), $sql);
// delete personal files from file storage
fs_delete_workspace(WORKSPACE_PERSONAL, $id);
return;
}
function delete_user($id)
{
global $db, $msg;
//make sure not instructor of a course
$sql = "SELECT course_id FROM %scourses WHERE member_id=%d";
$row_instructor = queryDB($sql, array(TABLE_PREFIX, $id), TRUE);
// WHAT'S THE PURPOSE OF THIS CONDITION?
if (count($row_instructor) > 0) {
/*$msg->addError('NODELETE_USER');
header('Location: '.AT_BASE_HREF.'users.php');
exit;*/
return;
}
$sql = "DELETE FROM %scourse_enrollment WHERE member_id=%d";
$result = queryDB($sql, array(TABLE_PREFIX, $id));
global $sqlout;
write_to_log(AT_ADMIN_LOG_DELETE, 'course_enrollment', $result, $sqlout);
$sql = "DELETE FROM %sforums_accessed WHERE member_id=%d";
$result = queryDB($sql, array(TABLE_PREFIX, $id));
global $sqlout;
write_to_log(AT_ADMIN_LOG_DELETE, 'forums_accessed', $result, $sqlout);
$sql = "DELETE FROM %sforums_subscriptions WHERE member_id=%d";
$result = queryDB($sql, array(TABLE_PREFIX, $id));
global $sqlout;
write_to_log(AT_ADMIN_LOG_DELETE, 'forums_subscriptions', $result, $sqlout);
/****/
/* delete forum threads block: */
/* delete the thread replies: */
$sql = "SELECT COUNT(*) AS cnt, parent_id, forum_id FROM %sforums_threads WHERE member_id=%d AND parent_id<>0 GROUP BY parent_id";
$rows_threads = queryDB($sql, array(TABLE_PREFIX, $id));
foreach ($rows_threads as $row) {
/* update the forum posts counter */
$sql = "UPDATE %sforums SET num_posts=num_posts - %d, last_post=last_post WHERE forum_id=%d";
$result = queryDB($sql, array(TABLE_PREFIX, $row['cnt'], $row['forum_id']));
global $sqlout;
write_to_log(AT_ADMIN_LOG_UPDATE, 'forums', $result, $sqlout);
/* update the topics reply counter */
$sql = "UPDATE %sforums_threads SET num_comments=num_comments-%d, last_comment=last_comment, date=date WHERE post_id=%d";
$result = queryDB($sql, array(TABLE_PREFIX, $row['cnt'], $row['parent_id']));
global $sqlout;
write_to_log(AT_ADMIN_LOG_UPDATE, 'forums_threads', $result, $sqlout);
}
/* delete threads this member started: */
$sql = "SELECT post_id, forum_id, num_comments FROM %sforums_threads WHERE member_id=%d AND parent_id=0";
$rows_posts = queryDB($sql, array(TABLE_PREFIX, $id));
foreach ($rows_posts as $row) {
/* update the forum posts and topics counters */
$num_posts = $row['num_comments'] + 1;
$sql = "UPDATE %sforums SET num_topics=num_topics-1, num_posts=num_posts - %d, last_post=last_post WHERE forum_id=%d";
$result = queryDB($sql, array(TABLE_PREFIX, $num_posts, $row['forum_id']));
global $sqlout;
write_to_log(AT_ADMIN_LOG_UPDATE, 'forums', $result, $sqlout);
/* delete the replies */
$sql = "DELETE FROM %sforums_threads WHERE parent_id=%d";
$result = queryDB($sql, array(TABLE_PREFIX, $row['post_id']));
global $sqlout;
write_to_log(AT_ADMIN_LOG_DELETE, 'forums_threads', $result, $sqlout);
}
/* delete the actual threads */
$sql = "DELETE FROM %sforums_threads WHERE member_id=%d";
$result = queryDB($sql, array(TABLE_PREFIX, $id));
global $sqlout;
write_to_log(AT_ADMIN_LOG_DELETE, 'forums_threads', $result, $sqlout);
/* end delete forum threads block. */
/****/
$sql = "DELETE FROM %sinstructor_approvals WHERE member_id=%d";
$result = queryDB($sql, array(TABLE_PREFIX, $id));
global $sqlout;
write_to_log(AT_ADMIN_LOG_DELETE, 'instructor_approvals', $result, $sqlout);
$sql = "DELETE FROM %smessages WHERE from_member_id=%d OR to_member_id=%d";
$result = queryDB($sql, array(TABLE_PREFIX, $id, $id));
global $sqlout;
write_to_log(AT_ADMIN_LOG_DELETE, 'messages', $result, $sqlout);
$sql = "DELETE FROM %spolls_members WHERE member_id=%d";
$result = queryDB($sql, array(TABLE_PREFIX, $id));
global $sqlout;
write_to_log(AT_ADMIN_LOG_DELETE, 'polls_members', $result, $sqlout);
$sql = "DELETE FROM %stests_answers WHERE member_id=%d";
$result = queryDB($sql, array(TABLE_PREFIX, $id));
global $sqlout;
write_to_log(AT_ADMIN_LOG_DELETE, 'tests_answers', $result, $sqlout);
$sql = "DELETE FROM %stests_results WHERE member_id=%d";
$result = queryDB($sql, array(TABLE_PREFIX, $id));
global $sqlout;
write_to_log(AT_ADMIN_LOG_DELETE, 'tests_results', $result, $sqlout);
$sql = "DELETE FROM %susers_online WHERE member_id=%d";
$result = queryDB($sql, array(TABLE_PREFIX, $id));
global $sqlout;
write_to_log(AT_ADMIN_LOG_DELETE, 'users_online', $result, $sqlout);
$sql = "DELETE FROM %smembers WHERE member_id=%d";
$result = queryDB($sql, array(TABLE_PREFIX, $id));
global $sqlout;
write_to_log(AT_ADMIN_LOG_DELETE, 'members', $result, $sqlout);
$sql = "DELETE FROM %smember_track WHERE member_id=%d";
$result = queryDB($sql, array(TABLE_PREFIX, $id));
global $sqlout;
write_to_log(AT_ADMIN_LOG_DELETE, 'member_track', $result, $sqlout);
// delete personal files from file storage
fs_delete_workspace(WORKSPACE_PERSONAL, $id);
return;
}
define('AT_INCLUDE_PATH', '../../../include/');
require AT_INCLUDE_PATH . 'vitals.inc.php';
authenticate(AT_PRIV_ASSIGNMENTS);
if (isset($_POST['submit_no'])) {
$msg->addFeedback('CANCELLED');
Header('Location: index_instructor.php');
exit;
} else {
if (isset($_POST['submit_yes'])) {
$_POST['assignment_id'] = intval($_POST['assignment_id']);
// delete the assignment from the table
$sql = "DELETE FROM " . TABLE_PREFIX . "assignments WHERE course_id={$_SESSION['course_id']} AND assignment_id={$_POST['assignment_id']}";
$result = mysql_query($sql, $db);
// delete all the files for this assignment
require AT_INCLUDE_PATH . '../mods/_standard/file_storage/file_storage.inc.php';
fs_delete_workspace(WORKSPACE_ASSIGNMENT, $_POST['assignment_id']);
$msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY');
header('Location: index_instructor.php');
exit;
}
}
require AT_INCLUDE_PATH . 'header.inc.php';
$_GET['id'] = intval($_GET['id']);
$sql = "SELECT title FROM " . TABLE_PREFIX . "assignments WHERE course_id={$_SESSION['course_id']} AND assignment_id={$_GET['id']}";
$result = mysql_query($sql, $db);
if ($row = mysql_fetch_assoc($result)) {
$hidden_vars['assignment_id'] = $_GET['id'];
$confirm = array('DELETE_ASSIGNMENT', AT_print($row['title'], 'assignment.title'));
$msg->addConfirm($confirm, $hidden_vars);
$msg->printConfirm();
} else {
