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