From 0f0a9f31132ea420a63cf492dba5cd1db7e56c40 Mon Sep 17 00:00:00 2001 From: Carlos Joa Date: Thu, 19 Oct 2017 11:37:31 -0400 Subject: Add new option to download contest results in S4RiS JSON format Fix user institution in webcast report Add flag for Puerto Rico --- src/admin/report/webcast.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'src/admin/report/webcast.php') diff --git a/src/admin/report/webcast.php b/src/admin/report/webcast.php index 5a595fc..0f85317 100644 --- a/src/admin/report/webcast.php +++ b/src/admin/report/webcast.php @@ -46,7 +46,7 @@ $r = DBExec($c, ' AND problemnumber > 0'); $numProblems = DBnlines($r); $r = DBExec($c, - 'SELECT username, userfullname FROM usertable' . + 'SELECT * FROM usertable' . ' WHERE contestnumber = ' . $contest . ' AND userenabled = \'t\' AND usersitenumber = ' . $site . ' AND usertype = \'team\''); @@ -57,7 +57,7 @@ $contestfile = $contestfile . $numProblems . "\n"; for ($i = 0; $i < $numTeams; $i++) { - $a = DBRow($r, $i); + $a = cleanuserdesc(DBRow($r, $i)); $teamID = $a['username']; if(isset($a['usershortname'])) $teamName = $a['usershortname']; -- cgit v1.2.3