' . oc_('All Threads') . ' » '; printHeader($hdr, $access); // Display paper info print '

'; if (!empty($paperLink)) { print '' . safeHTMLstr($_REQUEST['thread']) . '. ' . safeHTMLstr($paper['title']) . '' . (empty($paper['type']) ? '' : '
(' . safeHTMLstr($paper['type']) . ')'); } else { print safeHTMLstr($_REQUEST['thread']) . '. ' . safeHTMLstr($paper['title']) . (empty($paper['type']) ? '' : '
(' . safeHTMLstr($paper['type']) . ')'); } print '

'; // Submit? if (isset($_POST['submit']) && ($uid == 0) && ($_POST['submit'] == 'Delete Checked Posts')) { if (isset($_POST['posts']) && is_array($_POST['posts']) && !empty($_POST['posts'])) { foreach ($_POST['posts'] as $p) { if (ctype_digit($p)) { issueSQL("DELETE FROM `" . OCC_TABLE_MODULE_OC_DISCUSSION_POST . "` WHERE `postid`='" . safeSQLstr($p) . "'"); } } } } // Get posts $q = "SELECT `" . OCC_TABLE_MODULE_OC_DISCUSSION_POST . "`.*, CONCAT_WS(' ',`" . OCC_TABLE_REVIEWER . "`.`name_first`, `" . OCC_TABLE_REVIEWER . "`.`name_last`) AS `name`, `" . OCC_TABLE_REVIEWER . "`.`email` FROM `" . OCC_TABLE_MODULE_OC_DISCUSSION_POST . "` LEFT JOIN (`" . OCC_TABLE_REVIEWER . "`) ON (`" . OCC_TABLE_MODULE_OC_DISCUSSION_POST . "`.`accountid`=`" . OCC_TABLE_REVIEWER . "`.`reviewerid`) WHERE `" . OCC_TABLE_MODULE_OC_DISCUSSION_POST . "`.`paperid`='" . safeSQLstr($_REQUEST['thread']) . "' ORDER BY `" . OCC_TABLE_MODULE_OC_DISCUSSION_POST . "`.`time` ASC"; $r = ocsql_query($q) or err('Unable to retrieve posts'); if (ocsql_num_rows($r) == 0) { print '

' . oc_('No comments have been posted yet.') . '

'; } else { print '

'; // Display posts $lastpost = 0; // track last post while ($l = ocsql_fetch_assoc($r)) { $lastpost = $l['postid']; print '
' . oc_strftime('%c',$l['time']); // show delete checkboxes if chair if ($uid == 0) { print '   '; } print '
' . safeHTMLstr($name) . '
' . nl2br(safeHTMLstr($l['content'])) . '
'; } if ($uid == 0) { print '
'; } print '
'; // Update lastread - Yes, INSERT ON DUPLICATE KEY UPDATE would have been nice $q = "DELETE FROM `" . OCC_TABLE_MODULE_OC_DISCUSSION_READ . "` WHERE `accountid`='" . safeSQLstr($uid) . "' AND `paperid`='" . safeSQLstr($_REQUEST['thread']) . "'"; $r = ocsql_query($q) or err('Unable to update last read post'); $q = "INSERT INTO `" . OCC_TABLE_MODULE_OC_DISCUSSION_READ . "` SET `lastread`='" . safeSQLstr($lastpost) . "', `accountid`='" . safeSQLstr($uid) . "', `paperid`='" . safeSQLstr($_REQUEST['thread']) . "'"; $r = ocsql_query($q) or err('Unable to update last read post (2)'); } // Display post entry box print '
' . oc_('Add a Comment') . '
   
' . sprintf(oc_('All times are UTC %1$s. The time now is %2$s'), safeHTMLstr(date('O')), safeHTMLstr(oc_strftime('%X'))) . '
'; // Display reviews if ($OC_configAR['OC_DISCUSSION_displayReviews']) { $q = "SELECT `" . OCC_TABLE_PAPERREVIEWER . "`.*, CONCAT_WS(' ',`" . OCC_TABLE_REVIEWER . "`.`name_first`,`" . OCC_TABLE_REVIEWER . "`.`name_last`) as `name` FROM `" . OCC_TABLE_PAPERREVIEWER . "`, `" . OCC_TABLE_REVIEWER . "` WHERE `" . OCC_TABLE_PAPERREVIEWER . "`.`paperid`='" . safeSQLstr($_REQUEST['thread']) . "' AND `" . OCC_TABLE_PAPERREVIEWER . "`.`reviewerid`=`" . OCC_TABLE_REVIEWER . "`.`reviewerid`"; $r = ocsql_query($q) or err("Unable to get information ".ocsql_errno()); if (ocsql_num_rows($r) == 0) { warn(oc_('No reviews found')); } require_once OCC_REVIEW_INC_FILE; displayReviews($_REQUEST['thread'], $r, $paper['type']); } printFooter();