mods/clean_file_storage/index_admin.php

   1 <?php\r
   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
   6 \r
   7 $files_to_del = array();\r
   8 \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
  15 \r
  16 while ($row = mysql_fetch_assoc($result))\r
  17 {\r
  18         if (isset($_POST['submit_yes']))\r
  19                 fs_delete_workspace(WORKSPACE_PERSONAL, $row['owner_id']);\r
  20         else\r
  21                 array_push($files_to_del, $row['file_name']);\r
  22 }\r
  23 \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
  29 \r
  30 while ($row = mysql_fetch_assoc($result))\r
  31 {\r
  32         if (isset($_POST['submit_yes']))\r
  33                 fs_delete_workspace(WORKSPACE_ASSIGNMENT, $row['owner_id']);\r
  34         else\r
  35                 array_push($files_to_del, $row['file_name']);\r
  36 }\r
  37 \r
  38 if (isset($_POST['submit_no'])) \r
  39 {\r
  40         $msg->addFeedback('CANCELLED');\r
  41         Header('Location: ../../admin/index.php');\r
  42         exit;\r
  43 } \r
  44 else if (isset($_POST['submit_yes']))\r
  45 {\r
  46         $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY');\r
  47         Header('Location: ../../admin/index.php');\r
  48         exit;\r
  49 }\r
  50 \r
  51 require (AT_INCLUDE_PATH.'header.inc.php');\r
  52 \r
  53 if (count($files_to_del) > 0)\r
  54 {\r
  55         $msg_files = '<ul>';\r
  56         \r
  57         foreach (array_unique($files_to_del) as $file)\r
  58                 $msg_files .= '<li>'.$file.'</li>';\r
  59         \r
  60         $msg_files .= '</ul>';\r
  61 \r
  62         $confirm = array('DELETE_FILES', $msg_files);\r
  63         $msg->addConfirm($confirm);\r
  64         $msg->printConfirm();\r
  65 }\r
  66 else\r
  67 {\r
  68         $msg->addInfo('NO_FILES');\r
  69         $msg->printInfos();\r
  70 }\r
  71 ?>\r
  72 \r
  73 \r
  74 <?php require (AT_INCLUDE_PATH.'footer.inc.php'); ?>