'; $q = "SELECT * FROM " . OCC_TABLE_REVIEWER . " WHERE reviewerid='".$_GET['rid']."'"; $r = ocsql_query($q) or err("Unable to get information ".mysql_errno()); $l = mysql_fetch_array($r); print ' '; print ''; $q = "SELECT " . OCC_TABLE_PAPERADVOCATE . ".paperid, " . OCC_TABLE_PAPER . ".title FROM " . OCC_TABLE_PAPERADVOCATE . ", " . OCC_TABLE_PAPER . " WHERE " . OCC_TABLE_PAPERADVOCATE . ".advocateid='" . $_GET['rid'] . "' AND " . OCC_TABLE_PAPERADVOCATE . ".paperid=" . OCC_TABLE_PAPER . ".paperid"; $r = ocsql_query($q) or err("Unable to get advocating info " . mysql_errno()); if (mysql_num_rows($r) > 0) { print ''; } $q = "SELECT " . OCC_TABLE_PAPERREVIEWER . ".paperid, " . OCC_TABLE_PAPER . ".title FROM " . OCC_TABLE_PAPERREVIEWER . ", " . OCC_TABLE_PAPER . " WHERE " . OCC_TABLE_PAPERREVIEWER . ".reviewerid='" . $_GET['rid'] . "' AND " . OCC_TABLE_PAPERREVIEWER . ".paperid=" . OCC_TABLE_PAPER . ".paperid"; $r = ocsql_query($q) or err("Unable to get reviewing info " . mysql_errno()); if (mysql_num_rows($r) > 0) { print ''; } print '

ID:	'.$_GET['rid'].'
Program Committee:	'; if ($l['onprogramcommittee'] == 'T') { print "Yes"; } else { print "No"; } print '
Username:	'.$l['username'].'
Name:	' . safeHTMLstr($l['name_first']) . ' ' . safeHTMLstr($l['name_last']) . '
Email:	'.$l['email'].'
URL:	' . safeHTMLstr($l['url']) . '
Organization:	' . safeHTMLstr($l['organization']) . '
Country:	' . safeHTMLstr($l['country']) . '
Telephone:	' . safeHTMLstr($l['telephone']) . '
Topics:	'; $tq = "SELECT topicname, short FROM " . OCC_TABLE_REVIEWERTOPIC . ", " . OCC_TABLE_TOPIC . " WHERE reviewerid='".$_GET['rid']."' AND " . OCC_TABLE_REVIEWERTOPIC . ".topicid=" . OCC_TABLE_TOPIC . ".topicid"; $tr = ocsql_query($tq) or err("Unable to get topics ".mysql_errno()); while ($tl = mysql_fetch_array($tr)) { print "• " . useTopic($tl['short'],$tl['topicname']) . " \n"; } print '
Other Expertise:	' . safeHTMLstr($l['otherexpertise']) . '
Comments:	' . safeHTMLstr($l['comments']) . '
Advocating:	'; while ($l = mysql_fetch_array($r)) { print '• ' . $l['paperid'] . '. ' . safeHTMLstr($l['title']) . ' '; } print '
Reviewing:	'; while ($l = mysql_fetch_array($r)) { print '• ' . $l['paperid'] . '. ' . safeHTMLstr($l['title']) . ' '; } print '

'; printFooter(); ?>