// License: GPL 2.0
// --------------------------------------------------------------
define('BB_LOCATION', 'topics');
include '../../mainfile.php';
$rmCodes->add('quote', 'bXFunctions::quote_code');
$myts =& MyTextSanitizer::getInstance();
$id = rmc_server_var($_GET, 'id', '');
$pid = rmc_server_var($_GET, 'pid', 0);
$op = rmc_server_var($_GET, 'op', '');
if ($id == '' && $pid <= 0) {
redirect_header('./', 2, __('Specified topic does not exists!', 'bxpress'));
die;
}
$db = XoopsDatabaseFactory::getDatabaseConnection();
if ($pid) {
$id = bXFunctions::pageFromPID($pid);
} elseif ($op == 'new' && $xoopsUser) {
$result = $db->query('SELECT MIN(id_post) FROM ' . $db->prefix('mod_bxpress_posts') . " WHERE id_topic='{$id}' AND post_time>" . $xoopsUser->getVar('last_login'));
list($newid) = $db->fetchRow($result);
if ($newid) {
header('Location: topic.php?pid=' . $newid . '#p' . $newid);
} else {
// If there is no new post, we go to the last post
header('Location: topic.php?id=' . $id . '&op=last');
}
die;
} elseif ($op == 'last') {
$result = $db->query('SELECT MAX(id_post) FROM ' . $db->prefix('mod_bxpress_posts') . " WHERE id_topic='{$id}'");
list($lastid) = $db->fetchRow($result);
if ($lastid) {
header('Location: topic.php?pid=' . $lastid . '#p' . $lastid);
