Please go back and select at least one submission and one reviewer

'; } else { foreach ($_POST['reviewers'] as $i) { if (!preg_match("/^\d+$/", $i)) { err('Reviewer ID invalid'); } foreach ($_POST['papers'] as $j) { if (!preg_match("/^\d+$/", $j)) { err('Submission ID invalid'); } $q = "INSERT INTO `" . OCC_TABLE_CONFLICT . "` (`paperid`, `reviewerid`) VALUES ($j,$i)"; ocsql_query($q); if (($merr = ocsql_errno()) != 0) { if ($merr == 1062) { // Duplicate entry print "

! Submission $j and reviewer $i already registered as a conflict.

\n"; } else { print "

! Error registering submission $j and reviewer $i as a conflict (" . safeHTMLstr(ocsql_error()) . ")

\n"; } } else { print "

Submission $j and reviewer $i registered as a conflict.\n"; } } } print '

Set additional conflicts

'; } } else { $pq = "SELECT `" . OCC_TABLE_PAPER . "`.`paperid`, `" . OCC_TABLE_PAPER . "`.`title` FROM `" . OCC_TABLE_PAPER . "` ORDER BY `" . OCC_TABLE_PAPER . "`.`paperid`"; $pr = ocsql_query($pq) or err("Unable to get submissions"); // Get pad size for paper id's - yes, we really need the max id, but this should do:) $rows = ocsql_num_rows($pr); $psize = oc_strlen((string) $rows); if ($rows == 0) { print 'No submissions have been made yet

'; } else { if (!isset($_GET['s']) || ($_GET['s'] == "id")) { $idsortstr = 'ID'; $nsortstr = 'Name'; $legend = "[ Reviewer ID - $nsortstr ]"; $sortby = "`" . OCC_TABLE_REVIEWER . "`.`reviewerid`"; } else { $idsortstr = 'ID'; $nsortstr = 'Name'; $legend = "[ Reviewer Name - $idsortstr ]"; $sortby = "`" . OCC_TABLE_REVIEWER . "`.`name_last`, `" . OCC_TABLE_REVIEWER . "`.`name_first`"; } $rq = "SELECT `" . OCC_TABLE_REVIEWER . "`.`reviewerid`, `onprogramcommittee`, CONCAT_WS(' ', `" . OCC_TABLE_REVIEWER . "`.`name_first`, `" . OCC_TABLE_REVIEWER . "`.`name_last`) AS `name` FROM `" . OCC_TABLE_REVIEWER . "` ORDER BY $sortby"; $rr = ocsql_query($rq) or err("Unable to get reviewers"); // Get pad size for reviewer id's - yes, we really need the max id, but this should do:) $rsize = oc_strlen((string) ocsql_num_rows($rr)); if (ocsql_num_rows($rr) == 0) { print 'No reviewers have signed up yet

'; } else { print '

Select Submission(s):: [ Submission ID - Title ]
Select Reviewer(s):: Tip: Click on ID or Name on the line below to re-sort this list (page will reload); ' . $legend . '

'; } } } printFooter(); ?>