$sql = GetSQL();
$result = $sql->safequery('SELECT state FROM Topics WHERE id=' . $page);
$row = $result->fetch_row();
$state = 0;
if ($row === NULL) {
exit('error');
} else {
$state = $row[0];
if ($state != TopicStates::Live && $state != TopicStates::Old) {
exit('error');
}
if ($state == TopicStates::Live) {
if ($g_account->page != $page) {
exit('wrongpage');
}
$expired = CheckTopicExpired($g_account->page);
if ($expired == 1) {
exit('deleted');
} else {
if ($expired == 2) {
if (!$old) {
exit('expired');
}
} else {
if ($old) {
exit('error');
}
}
}
} else {
if ($state == TopicStates::Old) {
require_once "config.php";
require_once "util.php";
//-----------------------------------------------------------------------------
try {
if (!isset($_POST['page'])) {
exit('error');
}
$voteval = GetVoteValue($_POST['vote']);
if ($voteval === FALSE) {
exit('error');
}
$g_account = LogIn();
if ($g_account->page != $_POST['page']) {
exit('wrongpage');
}
if (CheckTopicExpired($g_account->page)) {
exit('expired');
// topic has expired.
}
$sql = GetSQL();
$sql->safequery('LOCK TABLES Topics WRITE, TopicVotes WRITE');
$result = $sql->safequery('SELECT state FROM Topics WHERE id=' . $g_account->page);
if ($result->num_rows == 0) {
$sql->safequery('UNLOCK TABLES');
exit('error');
// topic is invalid.
}
$row = $result->fetch_row();
if ($row[0] == TopicStates::Old) {
$sql->safequery('UNLOCK TABLES');
exit('expired');
