q('KEYTABLE SELECT langid AS ARRAYKEY, name, extensions
FROM language WHERE allow_submit = 1');
echo "\n";
// Put overview of team submissions (like scoreboard)
putTeamRow($cdata, array($teamid));
echo "
\n";
echo "
Submissions
\n\n";
if ( $fdata['cstarted'] ) {
if ( $submitted ) {
echo "
\n\n\n";
}
}
// call putSubmissions function from common.php for this team.
$restrictions = array( 'teamid' => $teamid );
putSubmissions(array($cdata['cid'] => $cdata), $restrictions, null, $submitted);
echo "
\n\n";
echo "
\n";
$requests = $DB->q('SELECT c.*, cp.shortname, t.name AS toname, f.name AS fromname
FROM clarification c
LEFT JOIN problem p USING(probid)
LEFT JOIN contestproblem cp USING (probid, cid)
LEFT JOIN team t ON (t.teamid = c.recipient)
LEFT JOIN team f ON (f.teamid = c.sender)
WHERE c.cid = %i AND c.sender = %i
ORDER BY submittime DESC, clarid DESC', $cid, $teamid);
$clarifications = $DB->q('SELECT c.*, cp.shortname, t.name AS toname, f.name AS fromname,
u.mesgid AS unread
FROM clarification c
LEFT JOIN problem p USING (probid)
LEFT JOIN contestproblem cp USING (probid, cid)
LEFT JOIN team t ON (t.teamid = c.recipient)
LEFT JOIN team f ON (f.teamid = c.sender)
LEFT JOIN team_unread u ON (c.clarid=u.mesgid AND u.teamid = %i)
WHERE c.cid = %i AND c.sender IS NULL
AND ( c.recipient IS NULL OR c.recipient = %i )
ORDER BY c.submittime DESC, c.clarid DESC',
$teamid, $cid, $teamid);
echo "
Clarifications
\n";
# FIXME: column width and wrapping/shortening of clarification text
if ( $clarifications->count() == 0 ) {
echo "