<?php require "./navigation.php"; $course_id = safeget("course_id"); $courseTbl = new CourseTbl($course_id); if (!$courseTbl->Get()) { error("Course not found"); } $course = $courseTbl->detail; if (!is_course_modifiable($course_id)) { error("No permission"); } $p = tryget("p", 1); $rs = new RecordSet($conn); $query_str = "SELECT cid, title, information FROM contests WHERE avail = 1 AND course_id = {$course_id} "; $count_str = "SELECT count(*) FROM contests WHERE avail = 1 AND course_id = {$course_id} "; $reglist = array(); $regTbl = new CourseRegTbl($course_id); if ($regTbl->Get()) { do { $uid = intval($regTbl->detail['uid']); $user = new UserTbl($regTbl->detail['uid']); $user->Get(); $reglist[] = $user->detail; } while ($regTbl->MoreRows()); } $rs->nPageSize = 20; $rs->PageCount($count_str); $rs->SetPage($p); $query_str .= "ORDER BY cid DESC"; $rs->dpQuery($query_str);
function DeleteCourse(&$arg) { $course = new CourseTbl($arg['course_id']); if (!$course->Get()) { error("No such course."); } if (!is_course_modifiable($arg['course_id'])) { error("No permission"); } $course->update['avail'] = 0; $course->Update(); MsgAndRedirect("courses.php"); }