// echo $cid;
// echo "<br>";
// echo $sql;
// echo "<br>";
$result = mysql_query($sql);
$cnt = 0;
echo "<table width=60%><tr class=toprow><td width=5><td width=34%><b>Problem ID</b><td width=65%><b>Title</b></tr>";
while ($row = mysql_fetch_object($result)) {
if ($cnt & 1) {
echo "<tr class=oddrow>";
} else {
echo "<tr class=evenrow>";
}
echo "<td>";
if (isset($_SESSION['user_id'])) {
echo check_ac($cid, $cnt);
}
echo "<td>{$row->pid} Problem {$PID[$cnt]}\n\t\t\t<td><a href='problem.php?cid={$cid}&pid={$cnt}'>{$row->title}</a>\n\t\t\t</tr>";
$cnt++;
}
echo "</table><br>";
mysql_free_result($result);
echo "[<a href='status.php?cid={$cid}'>Status</a>]";
echo "[<a href='contestrank.php?cid={$cid}'>Standing</a>]";
echo "[<a href='conteststatistics.php?cid={$cid}'>Statistics</a>]";
echo "</center>";
} else {
require_once "oj-header.php";
?>
<title>Contest List</title>
<?php
exit(0);
}
}
if (!$contest_ok) {
$view_errors = "{$MSG_PRIVATE_WARNING} <a href=contestrank.php?cid={$cid}>{$MSG_WATCH_RANK}</a>";
require "template/" . $OJ_TEMPLATE . "/error.php";
exit(0);
}
$sql = "select * from (SELECT `problem`.`title` as `title`,`problem`.`problem_id` as `pid`,source as source, `contest_problem`.`num` as pnum\n FROM `contest_problem`,`problem`\n WHERE `contest_problem`.`problem_id`=`problem`.`problem_id` AND `problem`.`defunct`='N'\n AND `contest_problem`.`contest_id`={$cid}\n ) problem\n left join (select problem_id pid1,count(1) accepted from solution where result=4 and contest_id={$cid} group by pid1) p1 on problem.pid=p1.pid1\n left join (select problem_id pid2,count(1) submit from solution where contest_id={$cid} group by pid2) p2 on problem.pid=p2.pid2\n order by pnum\n ";
$result = mysql_query($sql);
$view_problemset = array();
$cnt = 0;
while ($row = mysql_fetch_object($result)) {
$view_problemset[$cnt][0] = "";
if (isset($_SESSION['user_id'])) {
$view_problemset[$cnt][0] = check_ac($cid, $cnt);
}
$view_problemset[$cnt][1] = chr($cnt + ord('A'));
$view_problemset[$cnt][2] = "<a href='problem.php?cid={$cid}&pid={$cnt}'>{$row->title}</a>";
$view_problemset[$cnt][3] = $row->accepted;
$view_problemset[$cnt][4] = $row->submit;
$cnt++;
}
mysql_free_result($result);
} else {
$sql = "SELECT * FROM `contest` WHERE `defunct`='N' ORDER BY `contest_id` DESC limit 100";
$result = mysql_query($sql);
$view_contest = array();
$i = 0;
while ($row = mysql_fetch_object($result)) {
$view_contest[$i][0] = $row->contest_id;
