3 * this function named [module_name]_delete is called whenever a course content is deleted
\r
4 * which includes when restoring a backup with override set, or when deleting an entire course.
\r
5 * the function must delete all module-specific material associated with this course.
\r
6 * $course is the ID of the course to delete.
\r
9 function cerify_delete($course) {
\r
13 // delete hello_world course table entries
\r
14 $sql = "DELETE FROM ".TABLE_PREFIX."certify, ".TABLE_PREFIX."certify_members, ".TABLE_PREFIX."certify_tests ";
\r
15 $sql .= "USING ".TABLE_PREFIX."certify INNER JOIN ".TABLE_PREFIX."certify_members INNER JOIN ".TABLE_PREFIX."certify_tests ";
\r
16 $sql .= "WHERE ".TABLE_PREFIX."certify.course = $course ";
\r
17 $sql .= "AND ".TABLE_PREFIX."certify.certify_id = ".TABLE_PREFIX."certify_members.certify_id ";
\r
18 $sql .= "AND ".TABLE_PREFIX."certify.certify_id = ".TABLE_PREFIX."certify_tests.certify_id";
\r
19 mysql_query($sql, $db);
\r
22 // $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
23 // mysql_query($sql, $db);
\r
24 $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
25 mysql_query($sql, $db);
\r
26 $sql = 'DELETE FROM '.TABLE_PREFIX.'certify AS certify WHERE certify.course='.$course;
\r
27 mysql_query($sql, $db);
\r