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}");
}
