View All Committee Members';
if (!isset($_GET['rid']) || !ctype_digit($_GET['rid'])) {
err('Reviewer ID is invalid');
}
require_once OCC_FORM_INC_FILE;
require_once OCC_COMMITTEE_INC_FILE;
$extra = '';
// Get reviewer
$q = "SELECT * FROM `" . OCC_TABLE_REVIEWER . "` WHERE `reviewerid`='" . safeSQLstr($_GET['rid']) . "'";
$r = ocsql_query($q) or err("Unable to get information ".mysql_errno());
$l = mysql_fetch_array($r);
// Get topics
$qt = "SELECT `topicid` FROM `" . OCC_TABLE_REVIEWERTOPIC . "` WHERE `reviewerid`=" . safeSQLstr($_GET['rid']) . "";
$rt = ocsql_query($qt) or err("Unable to get topics ");
$l['topics'] = array();
while ($t = mysql_fetch_array($rt)) {
$l['topics'][] = $t['topicid'];
}
$advocating = '';
if ($OC_configAR['OC_paperAdvocates']) {
$aq = "SELECT `" . OCC_TABLE_PAPERADVOCATE . "`.`paperid`, `" . OCC_TABLE_PAPER . "`.`title` FROM `" . OCC_TABLE_PAPERADVOCATE . "`, `" . OCC_TABLE_PAPER . "` WHERE `" . OCC_TABLE_PAPERADVOCATE . "`.`advocateid`='" . safeSQLstr($_GET['rid']) . "' AND `" . OCC_TABLE_PAPERADVOCATE . "`.`paperid`=`" . OCC_TABLE_PAPER . "`.`paperid`";
$ar = ocsql_query($aq) or err("Unable to get advocating info " . mysql_errno());
if (mysql_num_rows($ar) > 0) {
$advocating .= '| Advocating: | ';
while ($al = mysql_fetch_array($ar)) {
$advocating .= '' . $al['paperid'] . '. ' . safeHTMLstr($al['title']) . '
';
}
$advocating .= ' |
|---|
';
}
}
$reviewing = '';
$rq = "SELECT `" . OCC_TABLE_PAPERREVIEWER . "`.`paperid`, `" . OCC_TABLE_PAPER . "`.`title` FROM `" . OCC_TABLE_PAPERREVIEWER . "`, `" . OCC_TABLE_PAPER . "` WHERE `" . OCC_TABLE_PAPERREVIEWER . "`.`reviewerid`='" . safeSQLstr($_GET['rid']) . "' AND `" . OCC_TABLE_PAPERREVIEWER . "`.`paperid`=`" . OCC_TABLE_PAPER . "`.`paperid`";
$rr = ocsql_query($rq) or err("Unable to get reviewing info " . mysql_errno());
if (mysql_num_rows($rr) > 0) {
$reviewing .= '| Reviewing: | ';
while ($rl = mysql_fetch_array($rr)) {
$reviewing .= '' . $rl['paperid'] . '. ' . safeHTMLstr($rl['title']) . '
';
}
$reviewing .= ' |
|---|
';
}
print '
| Member ID: | ' . safeHTMLstr($_GET['rid']) . ' |
|---|
| Username: | ' . safeHTMLstr($l['username']) . ' |
|---|
';
if ($OC_configAR['OC_paperAdvocates']) {
print '| Advocate/PC: | ' . (($l['onprogramcommittee'] == 'T') ? 'Yes' : 'No') . ' |
|---|
';
}
oc_showFieldSet($OC_reviewerFieldSetAR, $OC_reviewerFieldAR, $l);
$extra = '';
if (oc_hookSet('chair-show_reviewer')) {
foreach ($GLOBALS['OC_hooksAR']['chair-show_reviewer'] as $hook) {
require_once $hook;
}
}
print $extra . $advocating . $reviewing;
print '
';
printFooter();
?>