3 function content_delete($course) {
\r
4 require(AT_INCLUDE_PATH.'../mods/_core/imsafa/classes/A4a.class.php');
\r
8 // related_content + content:
\r
9 $sql = "SELECT content_id FROM ".TABLE_PREFIX."content WHERE course_id=$course";
\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
16 $sql3 = "DELETE FROM ".TABLE_PREFIX."member_track WHERE content_id=$row[0]";
\r
17 $result3 = mysql_query($sql3, $db);
\r
19 $sql = "DELETE FROM ".TABLE_PREFIX."content_tests_assoc WHERE content_id=$row[0]";
\r
20 $result4 = mysql_query($sql, $db);
\r
22 // Delete all AccessForAll contents
\r
23 $a4a = new A4a($row[0]);
\r
27 $sql = "DELETE FROM ".TABLE_PREFIX."content WHERE course_id=$course";
\r
28 $result = mysql_query($sql,$db);
\r
30 $sql = "OPTIMIZE TABLE ".TABLE_PREFIX."content";
\r
31 $result = @mysql_query($sql, $db);
\r