require "./navigation.php"; if (!isset($_GET['cid'])) { ?> <form action="<?php echo $_SERVER['PHP_SELF']; ?> " method="get"> cid:<input name="cid" type="text" /> </form> <?php die; } $cid = $_GET['cid']; global $conn; $rs = new RecordSet($conn); $rs->Query("SELECT status.sid, status.uid, cpid, run_memory, codelength, username, nickname FROM contest_status left join status on contest_status.sid = status.sid left join user on status.uid = user.uid WHERE status.status = 'Accepted' and contest_status.cid = {$cid} order by cpid asc, run_memory asc, codelength asc"); $submits = array(); while ($rs->MoveNext()) { $submits[] = $rs->Fields; } echo "<table class='tblContainer ui-widget-content ui-corner-all'><tr class='ui-widget-header'><td>cpid</td><td>sid1</td><td>username1</td><td>sid2</td><td>username2</td></tr>"; $count = 0; for ($i = 0; $i < count($submits); ++$i) { for ($j = $i + 1; $j < count($submits) && is_similar($submits[$i], $submits[$j]); ++$j) { if (is_same($submits[$i], $submits[$j])) { output($submits[$i], $submits[$j]); ++$count; } } } echo "</table>";
function QueryStatus(&$arg) { $sid = intval(safefetch($arg, 'sid', "Fail")); global $conn; $rs = new RecordSet($conn); $rs->Query("SELECT sid, uid, status, run_time, run_memory, failcase FROM status WHERE sid = {$sid}"); if (!$rs->MoveNext()) { Fail("Invalid run id"); } Output("status", $rs->Fields["status"]); Output("run_time", $rs->Fields["run_time"]); Output("run_memory", $rs->Fields["run_memory"]); Output("case_num", $rs->Fields["failcase"]); Output("uid", $rs->Fields["uid"]); Output("sid", $rs->Fields["sid"]); $rs->Query("select count(*) from queue"); $rs->MoveNext(); Output("queue_size", intval($rs->Fields[0]) + 1); $rs->free_result(); }
include_once "../inc/global.inc.php"; include_once "auth.inc.php"; global $conn; $id = $_GET["id"]; if ($id == "") { error("Invalid user ID!", "ranklist.php"); } $user = new UserTbl(); if (!$user->Get($id)) { error("Invalid user ID!", "ranklist.php"); } $solved = $user->detail['solved']; $submissions = $user->detail['submissions']; $rs = new RecordSet($conn); $rs->Query("SELECT count(*) FROM user WHERE solved > '{$solved}' OR (solved = '{$solved}' AND submissions < '{$submissions}') OR (solved = '{$solved}' AND submissions = '{$submissions}' AND uid < '{$id}')"); $rank = $rs->Fields[0] + 1; /* @mysql_connect($host, $user, $password) or die("Unable to connect database!"); mysql_select_db($database); $table = "user"; $query = "SELECT * FROM $table WHERE id = '$id'"; $result = mysql_query($query); if (mysql_num_rows($result) == 0) error("Invalid user ID!", "ranklist.php"); $row = mysql_fetch_array($result); $id = $row["id"]; $username = $row["username"]; $email = $row["email"]; $address = $row["address"]; $solved = $row["solved"]; $submissions = $row["submissions"];
function KickoutUser(&$arg) { $uid = mysql_real_escape_string(safefetch($arg, 'uid')); $course_id = mysql_real_escape_string(safefetch($arg, 'course_id')); global $conn; $rs = new RecordSet($conn); $rs->Query("DELETE FROM course_reg WHERE uid = {$uid} AND course_id = {$course_id}"); $rs->affected_rows(); MsgAndBack(); }
<td width="10%">Edit</td> <td width="10%">Copy</td> </tr> <?php if ($rs->MoveNext()) { $i = 0; do { $i++; printf("<tr bgcolor=\"#%s\">\n", $i % 2 ? "EEEEEE" : "FCFCFC"); $pid = $rs->Fields['pid']; ?> <td height=25 align="center"> <?php if ($cid) { $rs1 = new RecordSet($conn); $rs1->Query("SELECT accepted FROM ranklist WHERE cid='{$cid}' AND uid='{$login_uid}' AND pid='{$pid}'"); if ($rs1->MoveNext()) { if ($rs1->Fields['accepted'] == 1) { echo "<img src=\"images/yes.gif\" width=\"20\" height=\"20\">"; } else { echo "<img src=\"images/no.gif\" width=\"20\" height=\"20\">"; } } } // if ($rs->Fields['list'][$rs->Fields['pid'] - 1000] == 1) echo "<img src=\"images/no.gif\" width=\"20\" height=\"20\">"; // if ($rs->Fields['list'][$rs->Fields['pid'] - 1000] == 2) echo "<img src=\"images/yes.gif\" width=\"20\" height=\"20\">"; ?> </td> <td align="center"><?php echo $pid; ?>
<?php require "./navigation.php"; include_once "./FCKeditor/fckeditor.php"; $course_id = tryget('course_id', ''); $courseTbl = new CourseTbl($course_id); if ($course_id && !$courseTbl->Get()) { error("Course not found"); } $course = $courseTbl->detail; $rs = new RecordSet($conn); $rs->Query("SELECT max(cid) FROM contests"); $rs->MoveNext(); $cid = $rs->Fields[0]; $rs->Query("SELECT * FROM contests"); ?> <script type="text/javascript"> function pad0(num) { if (num < 10) return "0" + num; return num; } function calc_during() { if ($("#starttime").val().length == 0) { alert("Please set start time first!!"); return; } var during = Date.parse($("#endtime").val()) - Date.parse($("#starttime").val()); during = during / 1000; var s = during % 60;
if (!is_contest_modifiable($cid)) { error("No permission"); } $contest = new ContestsTbl($cid); $contest->Get() or error("no such contest"); $during = sscanf($contest->detail['during'], "%d:%d:%d", $h, $m, $s); $endtime = strtotime($contest->detail['starttime']) + $h * 3600 + $m * 60 + $s; $endtime = date('Y-m-d H:i:s', $endtime); $course_id = $contest->detail['course_id']; $courseTbl = new CourseTbl($course_id); if ($course_id && !$courseTbl->Get()) { error("Course not found"); } $course = $courseTbl->detail; $rs = new RecordSet($conn); $rs->Query("SELECT * FROM contests"); ?> <script type="text/javascript"> function pad0(num) { if (num < 10) return "0" + num; return num; } function calc_during() { if ($("#starttime").val().length == 0) { alert("Please set start time first!!"); return; } var during = Date.parse($("#endtime").val()) - Date.parse($("#starttime").val()); during = during / 1000;
/** * Generate new cpid for contest * @global type $conn * @param type $cid * @return type new unused cpid */ function gen_new_cpid($cid) { global $conn; $rs = new RecordSet($conn); $rs->Query("SELECT * FROM contest_problems WHERE cid='{$cid}'"); $problems_n = $rs->num_rows() + 1000; return $problems_n; }
MsgAndRedirect("contest_password.php?cid={$cid}"); } else { if (!is_contest_started($cid)) { error(_("This contest is not started yet.")); } else { error(_("You can't access to the contest")); } } } $problem = new ContestProblem($cid); if (!$problem->GetByFields(array())) { error("No problem found"); } global $conn; $rs = new RecordSet($conn); $rs->Query("SELECT cpid, COUNT(*) AS num FROM contest_status left join status on contest_status.sid = status.sid " . "WHERE cid = {$cid} and status = 'Accepted' GROUP BY cpid ORDER BY cpid"); $ac_num = array(); while ($rs->MoveNext()) { $ac_num[$rs->Fields['cpid']] = intval($rs->Fields['num']); } $rs->Query("SELECT cpid, COUNT(*) AS num FROM contest_status " . "WHERE cid = {$cid} GROUP BY cpid ORDER BY cpid"); $sm_num = array(); while ($rs->MoveNext()) { $sm_num[$rs->Fields['cpid']] = intval($rs->Fields['num']); } $rs->free_result(); ?> <script type="text/javascript" src="js/cproblem_list.js"> </script> <script type="text/javascript" src="js/jquery.dataTables.min.js" > </script> <link type="text/css" rel="stylesheet" href="css/data_table.css"/>