[just.b.jealous]

I'd like to be able to display the (postdate/time, username, thread title, and post content) for the latest 5/10 threads from a specific forum/s?

Is there anyway to make a plug-in so I could put a variable where it's needed.

Similiar to this here (which only displays 10 latest post - showing only the thread title and username):

$numposts='10';


    $thrdqry = $vbulletin->db->query_read("
        SELECT forumid,threadid, title, dateline, lastpost, visible, open, lastposter      
        FROM " . TABLE_PREFIX . "thread
                WHERE forumid IN (1, 2, 3) AND visible = '1' 
        ORDER BY lastpost DESC
          LIMIT 0, $numposts ");

        while ($thrds = mysql_fetch_array($thrdqry))    
    {

    $ttid = $thrds[threadid]; 
        $pstqry = $vbulletin->db->query_read("
        SELECT postid      
        FROM " . TABLE_PREFIX . "post                        
                WHERE threadid= $ttid 
                ORDER BY postid DESC");

        $psts = mysql_fetch_array($pstqry);
        $pstid = $psts[postid];
            

$homepage_recentpost .=<<<EOD
$thrds[title]
$thrds[lastposter]
EOD;
            
    }
        $db->free_result($thrds);
                $db->free_result($psts);

the I just post $homepage_recentpost into a template and vB does the rest, some help would be greatly appreciated,..