Difference Report - 8/28/2008, 10:09 AM ================================================================================ File 1: "A:\htdocs\moodle\admin\health.php" Last modified on 8/28/2008, 7:20 AM File 2: "A:\htdocs\moodle\admin\health_new.php" Last modified on 8/28/2008, 10:06 AM ================================================================================ Lines added at 649 ================================================================================ + $CFG->healthquestionsnocontext = false; ================================================================================ Lines added at 655 ================================================================================ + $CFG->healthquestionsnocontext = $cat->numquestions > 0 || $CFG->healthquestionsnocontext ? true : false; ================================================================================ Lines modified at 666 ================================================================================ - return '
You can delete the empty categories by executing the following SQL:
+ if($CFG->healthquestionsnocontext) - DELETE FROM ' . $CFG->prefix . 'question_categories + { - WHERE + return ''; + } + else + { + return 'You can delete the empty categories and orphaned questions by executing the following SQL in order:
- NOT EXIST (SELECT * FROM ' . $CFG->prefix . 'question q WHERE q.category = qc.id) + DELETE FROM ' . $CFG->prefix . 'question WHERE category IN (SELECT id FROM ' . $CFG->prefix . 'question_categories qc - AND NOT EXIST (SELECT * FROM ' . $CFG->prefix . 'context context WHERE qc.contextid = con.id) + WHERE NOT EXISTS (SELECT * FROM ' . $CFG->prefix . 'context con WHERE qc.contextid = con.id)) -Any remaining categories that contain questions will require more thought. ' . + - 'People in the Quiz forum may be able to help.
'; + DELETE FROM ' . $CFG->prefix . 'question_categories qc ================================================================================ Lines added at 673 ================================================================================ + WHERE + qc.contextid NOT IN (SELECT con.id FROM ' . $CFG->prefix . 'context con)
You can delete the empty categories by executing the following SQL:
+ DELETE FROM ' . $CFG->prefix . 'question_categories qc + WHERE + qc.contextid NOT IN (SELECT con.id FROM ' . $CFG->prefix . 'context con)'; + } +