Example #1
0
<?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);
Example #2
0
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");
}