<?php require "navigation.php"; $p = tryget("p", 1); $rs = new RecordSet($conn); $query_str = "SELECT course_id, name, teacher, description FROM courses WHERE avail = 1 "; $count_str = "SELECT count(*) FROM courses WHERE avail = 1"; $rs->nPageSize = 20; $rs->PageCount($count_str); $rs->SetPage($p); $query_str .= "ORDER BY course_id DESC"; $rs->dpQuery($query_str); $now = time(); ?> <h1><?php echo _("Current Courses"); ?> </h1> <table class="ui-widget tblcontainer ui-widget-content ui-corner-all" width="100%"> <thead > <tr class="ui-widget-header"> <th width="100"><?php echo _("ID"); ?> </th> <th width="300"><?php echo _("Name"); ?> </th> <th width="300"><?php echo _("Teacher");
<?php require "../inc/global.inc.php"; require "./auth.inc.php"; $p = $_GET['p']; if ($p == "") { $p = 1; } $rs = new RecordSet($conn); $rs->nPageSize = 16; $rs->PageCount("SELECT count(*) FROM user"); $rs->SetPage($p); $rs->dpQuery("SELECT uid, username, solved, submissions FROM user WHERE perm LIKE '%user%' ORDER BY solved DESC, submissions, uid"); ?> <html> <head> <title>Ranklist</title> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <link rel="stylesheet" href="style.css"> </head> <body color="#FFFFFF" bgcolor="#005DA9" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="770"> <?php require "./navigation.php"; ?> </td> <td background="images/navigation_bg.gif"> </td> </tr> <tr align="center" valign="top">
<?php include_once "../inc/global.inc.php"; include_once "auth.inc.php"; $p = $_GET["p"]; $cid = $_GET["cid"]; $pid = $_GET["pid"]; if ($p == "") { $p = 1; } $rs = new RecordSet($conn); $rs->nPageSize = 16; if ($cid) { $rs->PageCount("SELECT count(*) FROM contest_status"); $rs->SetPage($p); if ($pid) { $rs->dpQuery("SELECT sid, contest_status.uid, username, pid, language, status, run_time, run_memory, time FROM contest_status,user WHERE contest_status.uid=user.uid AND cid='{$cid}' AND pid='{$pid}' ORDER BY time DESC"); } else { $rs->dpQuery("SELECT sid, contest_status.uid, username, pid, language, status, run_time, run_memory, time FROM contest_status,user WHERE contest_status.uid=user.uid AND cid='{$cid}' ORDER BY time DESC"); } $contest = new ContestsTbl(); $contest->Get($cid); } else { $rs->PageCount("SELECT count(*) FROM status"); $rs->SetPage($p); $rs->dpQuery("SELECT sid, status.uid, username, pid, language, status, run_time, run_memory, time FROM status,user WHERE status.uid=user.uid ORDER BY sid DESC"); } ?> <html> <head> <title>Status</title>
$list = $user->detail['list']; } $rs = new RecordSet($conn); $rs->nPageSize = 20; if ($cid) { $contest = new ContestsTbl(); if ($contest->Get($cid) < 0) { error("No such contest ID"); } if (!is_admins()) { $now = time(); if ($now < strtotime($contest->detail['starttime'])) { error("The contest is not started"); } } $rs->PageCount("SELECT count(*) FROM contest_problems"); $rs->SetPage($p); $rs->dpQuery("SELECT pid, title, accepted, submissions, avail FROM contest_problems WHERE cid='{$cid}'"); } else { $rs->PageCount("SELECT count(*) FROM problems"); $rs->SetPage($p); $rs->dpQuery("SELECT pid, title, accepted, submissions, avail FROM problems"); } ?> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="770"> </td> <td background="images/navigation_bg.gif"> </td> </tr>