2 define('AT_INCLUDE_PATH', '../../include/');
\r
3 require (AT_INCLUDE_PATH.'vitals.inc.php');
\r
4 admin_authenticate(AT_ADMIN_PRIV_HELLO_WORLD);
\r
5 require_once(AT_INCLUDE_PATH.'lib/file_storage.inc.php');
\r
7 $files_to_del = array();
\r
9 // find all the files that need to be deleted
\r
10 // 1. personal files
\r
11 $sql = "SELECT owner_type, owner_id, file_name FROM ".TABLE_PREFIX."files
\r
12 WHERE owner_type=".WORKSPACE_PERSONAL."
\r
13 AND owner_id NOT IN (SELECT member_id FROM ".TABLE_PREFIX."members)";
\r
14 $result = mysql_query($sql, $db);
\r
16 while ($row = mysql_fetch_assoc($result))
\r
18 if (isset($_POST['submit_yes']))
\r
19 fs_delete_workspace(WORKSPACE_PERSONAL, $row['owner_id']);
\r
21 array_push($files_to_del, $row['file_name']);
\r
24 // 2. course group files
\r
25 $sql = "SELECT owner_type, owner_id, file_name FROM ".TABLE_PREFIX."files
\r
26 WHERE owner_type=".WORKSPACE_ASSIGNMENT."
\r
27 AND owner_id NOT IN (SELECT assignment_id FROM ".TABLE_PREFIX."assignments)";
\r
28 $result = mysql_query($sql, $db);
\r
30 while ($row = mysql_fetch_assoc($result))
\r
32 if (isset($_POST['submit_yes']))
\r
33 fs_delete_workspace(WORKSPACE_ASSIGNMENT, $row['owner_id']);
\r
35 array_push($files_to_del, $row['file_name']);
\r
38 if (isset($_POST['submit_no']))
\r
40 $msg->addFeedback('CANCELLED');
\r
41 Header('Location: ../../admin/index.php');
\r
44 else if (isset($_POST['submit_yes']))
\r
46 $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY');
\r
47 Header('Location: ../../admin/index.php');
\r
51 require (AT_INCLUDE_PATH.'header.inc.php');
\r
53 if (count($files_to_del) > 0)
\r
55 $msg_files = '<ul>';
\r
57 foreach (array_unique($files_to_del) as $file)
\r
58 $msg_files .= '<li>'.$file.'</li>';
\r
60 $msg_files .= '</ul>';
\r
62 $confirm = array('DELETE_FILES', $msg_files);
\r
63 $msg->addConfirm($confirm);
\r
64 $msg->printConfirm();
\r
68 $msg->addInfo('NO_FILES');
\r
74 <?php require (AT_INCLUDE_PATH.'footer.inc.php'); ?>