Search options

$nieuwsid = $_GET['nieuwsid'];

$result = $db->query('
    SELECT 
    * FROM '.$db->prefix.'posts 
    WHERE topic_id = '.$nieuwsid.'
    ORDER BY id DESC LIMIT 1
    ') or error('Unable to fetch posts', __FILE__, __LINE__, $db->error());



if ($db->num_rows($result)) {
    $cur_post = $db->fetch_assoc($result);
    $cur_post['message'] = parse_message($cur_post['message'], $cur_post['hide_smilies']);

    $result = $db->query("SELECT * FROM ".$db->prefix."topics WHERE id = ".$nieuwsid."")  or error('Unable to fetch topics', __FILE__, __LINE__, $db->error());
    $cur_topic = $db->fetch_assoc($result);

    $tpl->newBlock( "NIEUWS" );
    
    $tpl->assign( "NIEUWS_TITLE", pun_htmlspecialchars($cur_topic['subject']) );
    $tpl->assign( "NIEUWS_VIEWS", $cur_topic['num_views'] );
    $tpl->assign( "NIEUWS_DATUM", format_time($cur_post['posted']) );
    $tpl->assign( "BERICHT", $cur_post['message'] );
    
    $tpl->gotoBlock( "_ROOT" );
} else {
    $tpl->newBlock( "ERROR" );
    $tpl->assign("ERROR", "Er is geen nieuwsitem gevonden.");
    $tpl->gotoBlock( "_ROOT" );
}