function get_next_posting_id_in_thread(&$_posting)
{
$thread_id = $_posting->get_thread_id();
$path = $_posting->_get_path();
$sql = "SELECT id FROM {t_posting}";
$sql .= " WHERE thread_id={thread_id}";
$sql .= " AND status={status}";
$sql .= " AND NOT is_parent";
if ($path) {
$sql .= " AND STRCMP(CONCAT('0x', HEX(path)), '{path}')=1";
}
$sql .= " ORDER BY path";
$query = new FreechSqlQuery($sql);
$query->set_int('thread_id', $thread_id);
$query->set_hex('path', $path);
$query->set_int('status', POSTING_STATUS_ACTIVE);
$res = $this->db->SelectLimit($query->sql(), 1) or die('ForumDB::get_next_posting_id_in_thread()');
return $res->fields['id'];
}
