function clear() { global $course_id; admin_page_head("Deleting course data"); BoltEnrollment::delete_aux("course_id = {$course_id}"); BoltView::delete_aux("course_id = {$course_id}"); BoltResult::delete_aux("course_id = {$course_id}"); BoltXsetResult::delete_aux("course_id = {$course_id}"); BoltSelectFinished::delete_aux("course_id = {$course_id}"); BoltRefreshRec::delete_aux("course_id = {$course_id}"); BoltQuestion::delete_aux("course_id = {$course_id}"); echo "\n\t\tCourse data deleted.\n\t"; admin_page_tail(); } $user = get_logged_in_user(); $db = BoltDb::get(); if (!$db) { error_page("Can't connect to database server"); } if (!$db->table_exists('bolt_course')) { page_head("Create Bolt database"); $db_name = $db->db_name; echo "\n\t\tThe database tables for Bolt don't seem to exist.\n\t\tTo create them, go to ~/boinc/db and type\n\t\t<pre>\nmysql {$db_name} < bolt_schema.sql\n</pre>\n\tThen <a href=bolt_admin.php>reload this page</a>.\n\t"; page_tail(); exit; } BoltUser::lookup($user); $course_id = get_int('course_id', true); if ($course_id) { $course = BoltCourse::lookup_id($course_id); }
function clear() { global $course; $db = BoltDb::get(); $db->do_query("delete from DBNAME.bolt_view where course_id={$course->id}"); $db->do_query("delete from DBNAME.bolt_result where course_id={$course->id}"); $db->do_query("delete from DBNAME.bolt_xset_result where course_id={$course->id}"); $db->do_query("delete from DBNAME.bolt_select_finished where course_id={$course->id}"); }