Showing the active posts on non-vb page

I would like to show let's say the 5 latest active posts of the moment (so if somebody posts/replies, it becomes an active posts) on a page , but not a vb page. I see it on a lot of sites, but does there exist a free hack for it ? Cuse I'm not good at php at all, so if one exist or the code to do it, could you help me out ?

Thanks !

[Admin]

<a href="http://www.vbulletin.com/forum/showthread.php?s=&threadid=12324" target="_blank">http://www.vbulletin.com/forum/showt...threadid=12324</a>
I think that's what you are looking for

[Kyle_TX]

Maybe someone can clean this up, this is what we use on our site.

PHP Code:

<?php
//########################################################################################################
//Variables to Modify                                                                                
$server     = "localhost";                              //  usually localhost
$user       = "";                                       //  your username for the mySQL server
$password   = "";                                       //  your password for your database
$db         = "";                                       //  your vBulletin database name
$numposts   = "15";                              //  Number of posts to display
$maxchars   = "20";                              //  Max characters of thread title to show
$website    = "http://www.domain.com/vb";                 //  Path to your VB
//########################################################################################################


$num_rows = ($num_rows-1);
$link = mysql_connect($server, $user, $password);
if (! $link ) die ("Couldn't connect to DB\n");
mysql_select_db($db)
    or die ("couldn't open $db: ".mysql_query() );
$result = mysql_query("SELECT * FROM post ORDER BY postid DESC LIMIT $numposts");
$num_rows = mysql_num_rows($result);

while ( $a_row = mysql_fetch_array($result))
        {
        $postid[]          = $a_row[postid];
    $pagetext[]       = $a_row[pagetext];
    $threadid[]       = $a_row[threadid];
        }

$x = 0;
echo "<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0>\n";
while ( $x < $num_rows )
    {
    $result2 = mysql_query("SELECT * FROM thread where threadid=$threadid[$x]");
    while ( $a_row = mysql_fetch_array($result2))
        {
        $title[]        = $a_row[title];
        }
    print "<TR><TD><li><a 
href=\"$website/showthread.php?s=&threadid=$threadid[$x]\">".substr($title[$x], 0, $maxchars)."...</a></TD></TR>\n";
    $x++;
    }
echo "</TABLE>\n";
mysql_close($link);
?>