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); $now = time(); ?>
/** * Check whether the course is registerd * @global type $logged * @global type $login_uid * @param type $course_id * @return type */ function is_course_registered($course_id) { $course = new CourseTbl($course_id); $course->Get() or error("Course not found"); global $logged; global $login_uid; if (!$logged) { error("Please login first"); } $couresReg = new CourseRegTbl(); $courseReg = new CourseRegTbl(); $arr = array("course_id" => $course_id, "uid" => $login_uid); return $courseReg->GetByFields($arr); }