No papers to display.

'; } else { print '

Functions:
Click on Score links to see individual reviewer scores and accept/reject submission
Click on Submission ID. Title links to see submission information

Definitions:
score = average score (if no score, ignored)

'; // Get topic names author listed their paper under $topicAR = array(); $q2 = "SELECT `" . OCC_TABLE_PAPERTOPIC . "`.`paperid`, `topicname`, `short` FROM `" . OCC_TABLE_PAPERTOPIC . "`, `" . OCC_TABLE_TOPIC . "` WHERE `" . OCC_TABLE_PAPERTOPIC . "`.`topicid`=`" . OCC_TABLE_TOPIC . "`.`topicid` ORDER BY `" . OCC_TABLE_PAPERTOPIC . "`.`paperid`"; $r2 = ocsql_query($q2) or err("Unable to get submission topics"); while ($l2 = ocsql_fetch_array($r2)) { if (array_key_exists($l2['paperid'],$topicAR)) { $topicAR[$l2['paperid']] .= "
  • " . useTopic($l2['short'],$l2['topicname']) . "\n"; } else { $topicAR[$l2['paperid']] = "
  • " . useTopic($l2['short'],$l2['topicname']) . "\n"; } } // Get topic (sesion) names reviewers listed papers as belonging to $sessionAR = array(); $q3 = "SELECT `" . OCC_TABLE_PAPERSESSION . "`.`paperid`, `topicname`, `short` FROM `" . OCC_TABLE_PAPERREVIEWER . "`, `" . OCC_TABLE_PAPERSESSION . "`, `" . OCC_TABLE_TOPIC . "` WHERE `" . OCC_TABLE_PAPERREVIEWER . "`.`score` IS NOT NULL AND `" . OCC_TABLE_PAPERREVIEWER . "`.`paperid`=`" . OCC_TABLE_PAPERSESSION . "`.`paperid` AND `" . OCC_TABLE_TOPIC . "`.`topicid`=`" . OCC_TABLE_PAPERSESSION . "`.`topicid` GROUP BY `" . OCC_TABLE_PAPERSESSION . "`.`paperid`, `topicname` ORDER BY `" . OCC_TABLE_PAPERSESSION . "`.`paperid`"; $r3 = ocsql_query($q3) or err("Unable to get reviewer sessions"); while ($l3 = ocsql_fetch_array($r3)) { if (array_key_exists($l3['paperid'],$sessionAR)) { $sessionAR[$l3['paperid']] .= "
  • " . useTopic($l3['short'],$l3['topicname']) . "\n"; } else { $sessionAR[$l3['paperid']] = "
  • " . useTopic($l3['short'],$l3['topicname']) . "\n"; } } while ($l = ocsql_fetch_array($r)) { if (!empty($l['avgrec'])) { $usescore = number_format($l['avgrec'], 2); } else { $usescore = '–'; } print '
    ' . $l['paperid'] . ". " . safeHTMLstr($l['title']) . '

    Score: ' . $usescore . "

    \nKeywords: " . safeHTMLstr($l['keywords']) . "

    \n" . OCC_WORD_AUTHOR . " Topics:

    \n"; print "Reviewer Sessions:

    \n"; } } printFooter(); ?>