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 "<h3 class=\"teamoverview\">Clarifications</h3>\n"; # FIXME: column width and wrapping/shortening of clarification text if ($clarifications->count() == 0) { echo "<p class=\"nodata\">No clarifications.</p>\n\n"; } else { putClarificationList($clarifications, $teamid); } echo "<h3 class=\"teamoverview\">Clarification Requests</h3>\n"; if ($requests->count() == 0) { echo "<p class=\"nodata\">No clarification requests.</p>\n\n"; } else { putClarificationList($requests, $teamid); } echo addForm('clarification.php', 'get') . "<p>" . addSubmit('request clarification') . "</p>" . addEndForm(); echo "</div>\n"; require LIBWWWDIR . '/footer.php';
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 contest co USING (cid) WHERE c.cid IN (%Ai) '; $newrequests = $DB->q($sqlbody . 'AND c.sender IS NOT NULL AND c.answered = 0 ORDER BY submittime DESC, clarid DESC', $contestids); $oldrequests = $DB->q($sqlbody . 'AND c.sender IS NOT NULL AND c.answered != 0 ORDER BY submittime DESC, clarid DESC', $contestids); $clarifications = $DB->q($sqlbody . 'AND c.sender IS NULL AND ( c.respid IS NULL OR c.recipient IS NULL ) ORDER BY submittime DESC, clarid DESC', $contestids); echo '<h3 id="newrequests">' . "New Requests:</h3>\n"; if ($newrequests->count() == 0) { echo "<p class=\"nodata\">No new clarification requests.</p>\n\n"; } else { putClarificationList($newrequests, NULL); } echo '<h3 id="oldrequests">' . "Old Requests:</h3>\n"; if ($oldrequests->count() == 0) { echo "<p class=\"nodata\">No old clarification requests.</p>\n\n"; } else { putClarificationList($oldrequests, NULL); } echo '<h3 id="clarifications">' . "General Clarifications:</h3>\n"; if ($clarifications->count() == 0) { echo "<p class=\"nodata\">No general clarifications.</p>\n\n"; } else { putClarificationList($clarifications, NULL); } require LIBWWWDIR . '/footer.php';