[just.b.jealous]

Originally Posted by kh99

You could do this:

PHP Code:

$numposts='10';


$thrdqry = $vbulletin->db->query_read("
    SELECT thread.title, username, post.dateline, post.pagetext FROM " . TABLE_PREFIX . "thread AS thread
            LEFT JOIN " . TABLE_PREFIX . "post AS post ON thread.lastpostid = post.postid
            WHERE thread.forumid IN (1, 2, 3) AND thread.visible = '1'
    ORDER BY lastpost DESC
    LIMIT 0, $numposts ");

while ($thrds = $vbulletin->db->fetch_array($thrdqry))    
{
    $postdate = vbdate($vbulletin->options['dateformat'], $thrds['dateline'], true);
    $posttime = vbdate($vbulletin->options['timeformat'], $thrds['dateline']);

    $homepage_recentpost .=<<<EOD
$thrds[title] $thrds[username] $postdate $posttime
<BR>
$thrds[pagetext]
<BR><BR>
EOD;
            
} 


This doesn't check permissions of course, but maybe you're not worried about that.
A bigger problem is that this doesn't handle bbcode in the text.

Thanks for helping me out, I'm not too good with plugins yet, template stuff is easy. 1 more question for ya, or anyone else who knows, I'm sure it would be pretty easy- any chance of making this just pick up the last thread posted/user/date/contents, instead of the last poster in a thread?

Thanks in advance,.