'; if (!is_numeric($_GET['pid'])) { err("Unable to find submission with id " . $_GET['pid']); } $q = "SELECT * FROM " . OCC_TABLE_PAPER . " WHERE paperid='".$_GET['pid']."'"; $r = ocsql_query($q) or err("Unable to get submissions ".mysql_errno()); if (mysql_num_rows($r)!=1) { err("There does not appear to be a submission with that id (or there is more than one)"); } $l = mysql_fetch_array($r); print ' '; if ($OC_configAR['OC_trackStudent'] == 1) { print '\n"; } print ' '; if (oc_hookSet('chair-show_paper')) { foreach ($GLOBALS['OC_hooksAR']['chair-show_paper'] as $hook) { require_once $hook; } } print ''; if ($OC_configAR['OC_paperAdvocates']) { $q = "SELECT " . OCC_TABLE_PAPERADVOCATE . ".advocateid, CONCAT_WS(' '," . OCC_TABLE_REVIEWER . ".name_first," . OCC_TABLE_REVIEWER . ".name_last) AS name, " . OCC_TABLE_REVIEWER . ".organization FROM " . OCC_TABLE_PAPERADVOCATE . ", " . OCC_TABLE_REVIEWER . " WHERE " . OCC_TABLE_PAPERADVOCATE . ".paperid='" . $_GET['pid'] . "' AND " . OCC_TABLE_PAPERADVOCATE . ".advocateid=" . OCC_TABLE_REVIEWER . ".reviewerid"; $r = ocsql_query($q) or err("Unable to get advocate info " . mysql_errno()); if (mysql_num_rows($r) == 1) { $l = mysql_fetch_array($r); print ''; } } $q = "SELECT " . OCC_TABLE_PAPERREVIEWER . ".reviewerid, CONCAT_WS(' '," . OCC_TABLE_REVIEWER . ".name_first," . OCC_TABLE_REVIEWER . ".name_last) AS name, " . OCC_TABLE_REVIEWER . ".organization FROM " . OCC_TABLE_PAPERREVIEWER . ", " . OCC_TABLE_REVIEWER . " WHERE " . OCC_TABLE_PAPERREVIEWER . ".paperid='" . $_GET['pid'] . "' AND " . OCC_TABLE_PAPERREVIEWER . ".reviewerid=" . OCC_TABLE_REVIEWER . ".reviewerid"; $r = ocsql_query($q) or err("Unable to get reviewers info " . mysql_errno()); if (mysql_num_rows($r) > 0) { print ''; } print '

ID	' . $_GET['pid'] . '
Submitted	'.$l['submissiondate'].'
Last Update	'.$l['lastupdate'].'
Title	' . safeHTMLstr($l['title']) . '
Student	'; if ($l['student'] == "F") { print "No"; } else { print "Yes"; } print "
Author(s)	'; $q = "SELECT * FROM " . OCC_TABLE_AUTHOR . " WHERE paperid='".$_GET['pid']."'"; $r = ocsql_query($q) or err("Unable to get authors ".mysql_errno()); while ($a = mysql_fetch_array($r)) { print 'Author #'.$a['position'].' Name: ' . safeHTMLstr($a['name_first']) . ' ' . safeHTMLstr($a['name_last']) . ' Org: ' . safeHTMLstr($a['organization']) . ' Country: ' . safeHTMLstr($a['country']) . ' Email: '; if (!empty($a['email'])) { print '' . $a['email'] . ''; } print ' '; } print '
Other Author(s)	' . safeHTMLstr($l['otherauthors']) . '
Contact Author	Author #'.$l['contactid'].' Alt Email: '; if (!empty($l['contactemail'])) { print '' . $l['contactemail'] . ''; } print ' Telephone: ' . safeHTMLstr($l['contactphone']) . '
Keywords	' . safeHTMLstr($l['keywords']) . '
Abstract	'.preg_replace("/\n/"," \n",safeHTMLstr($l['abstract'])).'
Topics	'; $q = "SELECT topicname, short FROM " . OCC_TABLE_PAPERTOPIC . ", " . OCC_TABLE_TOPIC . " WHERE paperid='".$_GET['pid']."' AND " . OCC_TABLE_PAPERTOPIC . ".topicid=" . OCC_TABLE_TOPIC . ".topicid"; $r = ocsql_query($q) or err("Unable to get topics ".mysql_errno()); while ($t = mysql_fetch_array($r)) { print "• " . useTopic($t['short'],$t['topicname']) . " \n"; } print '
Comments	' . safeHTMLstr($l['comments']) . '
Submission	'; if ($l['format'] && is_file($pfile = $OC_configAR['OC_paperDir'] . $_GET['pid'] . "." . $l['format'])) { print "" . $_GET['pid'] . ".".$l['format']." (" . round((filesize($pfile)/1024)) . "KB)"; } else { print "not uploaded"; } print '

Advocate	' . safeHTMLstr($l['name']) . ', ' . $l['organization'] . '
Reviewers	'; while ($l = mysql_fetch_array($r)) { print '• ' . safeHTMLstr($l['name']) . ', ' . $l['organization'] . ' '; } print '

'; printFooter(); ?>