docs/mods/_standard/assignments/module_delete.php

   1 <?php\r
   2 \r
   3 function assignments_delete($course) {\r
   4         global $db;\r
   5         \r
   6         require_once(AT_INCLUDE_PATH.'../mods/_standard/file_storage/file_storage.inc.php');\r
   7 \r
   8         $sql    = "SELECT assignment_id FROM ".TABLE_PREFIX."assignments WHERE course_id=$course";\r
   9         $result = mysql_query($sql, $db);\r
  10         while ($row = mysql_fetch_assoc($result)) \r
  11         {\r
  12                 fs_delete_workspace(WORKSPACE_ASSIGNMENT, $row['assignment_id']);\r
  13         }\r
  14 \r
  15         // delete assignment folders/files from file storage\r
  16         $sql = "DELETE FROM ".TABLE_PREFIX."assignments WHERE course_id=$course";\r
  17         mysql_query($sql, $db);\r
  18 }\r
  19 \r
  20 ?>