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();
}
require_once "../inc/bolt_db.inc";
require_once "../inc/util.inc";
require_once "../inc/bolt_util.inc";
page_head("Courses");
$user = get_logged_in_user(false);
if ($user) {
BoltUser::lookup($user);
}
$courses = BoltCourse::enum();
start_table();
table_header("Course", "Status");
foreach ($courses as $course) {
if ($course->hidden && !($user->bolt->flags & BOLT_FLAG_SHOW_ALL)) {
continue;
}
$e = $user ? BoltEnrollment::lookup($user->id, $course->id) : null;
if ($e) {
$start = date_str($e->create_time);
$view = BoltView::lookup_id($e->last_view_id);
$ago = time_diff(time() - $view->start_time);
$pct = number_format($view->fraction_done * 100, 0);
$status = "Started {$start}\n <br>Last visit: {$ago} ago\n <br>{$pct}% done\n ";
if ($view->fraction_done < 1) {
$status .= "<br><a href=bolt_sched.php?course_id={$course->id}&action=resume>Resume</a>\n ";
}
$status .= "<br><a href=bolt_sched.php?course_id={$course->id}&action=start>Restart</a>\n | <a href=bolt_course.php?course_id={$course->id}>History</a>\n ";
} else {
$status = "\n <a href=bolt_sched.php?course_id={$course->id}&action=start>Start</a>\n ";
}
row2_init("<b>{$course->name}</b>\n <br><span class=note>{$course->description}</span>", $status);
show_refreshes();
function show_next($iter, $view)
{
global $refresh, $user, $course;
$iter->next();
if ($refresh) {
$iter->at();
if (!$iter->xset) {
// if we're doing a refresh and are no longer in an xset,
// we must have finished the refresh
//
show_refresh_finished();
$refresh->update('count=count+1');
break;
}
}
if ($iter->item) {
$state = $iter->encode_state();
$mode = default_mode($iter->item);
$view_id = create_view($iter, $mode, $view->id);
show_item($iter, $view_id, $view->id, $mode);
} else {
// course finished
$iter->frac_done = 1;
$fin_view_id = create_view($iter, BOLT_MODE_FINISHED, $view->id);
$e = new BoltEnrollment();
$e->user_id = $user->id;
$e->course_id = $course->id;
$e->update("last_view_id={$fin_view_id}");
show_finished_page($fin_view_id, $view->id);
}
}
