Change forum ID "Where" location in PHP!

[MarkFoster]

Originally Posted by Dismounted

Did you add all the other code?

PHP Code:

<?php
unset($latestnewsbits);

$threads = $vbulletin->db->query_read("
    SELECT thread.threadid, thread.title, thread.iconid, thread.dateline, thread.postusername, thread.postuserid,
        post.pagetext
    FROM " . TABLE_PREFIX . "thread AS thread
    INNER JOIN " . TABLE_PREFIX . "post AS post ON (post.postid = thread.firstpostid)
    WHERE thread.forumid = PUTFORUMIDHERE
    ORDER BY thread.dateline DESC
    LIMIT 5
");

while ($thread = $vbulletin->db->fetch_array($threads))
{
    $dateposted = vbdate("jS F Y \\- g:iA", $thread['dateline']);
    $message = fetch_trimmed_title(strip_bbcode($thread['pagetext'], true, true), 200);

    eval('$latestnewsbits .= "' . fetch_template('rwc_latestnews_bit') . '";');
}

$can_moderate_rwc = can_moderate(intval($vbulletin->options['rwc_newsforum']));

eval('$home["$mods[modid]"][\'content\'] = "' . fetch_template('rwc_latestnews') . '";');

?>

Thanks a lot! It works great now!