[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);
?>