mods/_core/content/module_delete.php

   1 <?php\r
   2 \r
   3 function content_delete($course) {\r
   4         require(AT_INCLUDE_PATH.'../mods/_core/imsafa/classes/A4a.class.php');\r
   5 \r
   6         global $db;\r
   7 \r
   8         // related_content + content:\r
   9         $sql    = "SELECT content_id FROM ".TABLE_PREFIX."content WHERE course_id=$course";\r
  10 \r
  11         $result = mysql_query($sql, $db);\r
  12         while ($row = mysql_fetch_array($result)) {\r
  13                 $sql    = "DELETE FROM ".TABLE_PREFIX."related_content WHERE content_id=$row[0]";\r
  14                 $result2 = mysql_query($sql, $db);\r
  15 \r
  16                 $sql3    = "DELETE FROM ".TABLE_PREFIX."member_track WHERE content_id=$row[0]";\r
  17                 $result3 = mysql_query($sql3, $db);\r
  18 \r
  19                 $sql = "DELETE FROM ".TABLE_PREFIX."content_tests_assoc WHERE content_id=$row[0]";\r
  20                 $result4 = mysql_query($sql, $db);\r
  21 \r
  22                 // Delete all AccessForAll contents \r
  23                 $a4a = new A4a($row[0]);\r
  24                 $a4a->deleteA4a();\r
  25         }\r
  26 \r
  27         $sql = "DELETE FROM ".TABLE_PREFIX."content WHERE course_id=$course";\r
  28         $result = mysql_query($sql,$db);\r
  29 \r
  30         $sql = "OPTIMIZE TABLE ".TABLE_PREFIX."content";\r
  31         $result = @mysql_query($sql, $db);\r
  32 \r
  33 }\r
  34 \r
  35 ?>