+++ /dev/null
-<?php\r
-/*******\r
- * this function named [module_name]_delete is called whenever a course content is deleted\r
- * which includes when restoring a backup with override set, or when deleting an entire course.\r
- * the function must delete all module-specific material associated with this course.\r
- * $course is the ID of the course to delete.\r
- */\r
-\r
-function cerify_delete($course) {\r
- global $db;\r
-\r
-/*\r
- // delete hello_world course table entries\r
- $sql = "DELETE FROM ".TABLE_PREFIX."certify, ".TABLE_PREFIX."certify_members, ".TABLE_PREFIX."certify_tests ";\r
- $sql .= "USING ".TABLE_PREFIX."certify INNER JOIN ".TABLE_PREFIX."certify_members INNER JOIN ".TABLE_PREFIX."certify_tests ";\r
- $sql .= "WHERE ".TABLE_PREFIX."certify.course = $course ";\r
- $sql .= "AND ".TABLE_PREFIX."certify.certify_id = ".TABLE_PREFIX."certify_members.certify_id ";\r
- $sql .= "AND ".TABLE_PREFIX."certify.certify_id = ".TABLE_PREFIX."certify_tests.certify_id";\r
- mysql_query($sql, $db);\r
-*/\r
-\r
-// $sql = 'DELETE members FROM '.TABLE_PREFIX.'certify AS certify INNER JOIN '.TABLE_PREFIX.'certify_members AS members WHERE certify.course='.$course.' AND certify.certify_id=members.certify_id';\r
-// mysql_query($sql, $db);\r
- $sql = 'DELETE tests FROM '.TABLE_PREFIX.'certify AS certify INNER JOIN '.TABLE_PREFIX.'certify_tests AS tests WHERE certify.course='.$course.' AND certify.certify_id=tests.certify_id';\r
- mysql_query($sql, $db);\r
- $sql = 'DELETE FROM '.TABLE_PREFIX.'certify AS certify WHERE certify.course='.$course;\r
- mysql_query($sql, $db);\r
-\r
-\r
-}\r
-\r
-?>
\ No newline at end of file