Latest 10 posts !

Anyone knows how to something so that I could check out the latest 10 posts in the Vbulletin forum and have a link to them automatically updated on the index page of my domain ?

Any generic ones ?

<?
require("admin/config.php");
$num_active = 10;
$db=mysql_connect($servername,$dbusername,$dbpassw ord);
mysql_select_db($dbname);
$twentyfourhours= 24*60*60;
$date1 = time() - $twentyfourhours * 1;
$myselect = "select * FROM thread ORDER BY lastpost DESC LIMIT 10";
$result = mysql_query($myselect);
if ($row = mysql_fetch_array($result)) {
do {
printf("<li><a href=\"http://64.177.89.7/boards/showthread.php?threadid=%d\">%s</a><br>%d views - %d replies</li>", $row[threadid], $row[title], $row[views], $row[replycount]);
} while ($row = mysql_fetch_array($result));
}
?>

that's it...
change this number if you want to change the number of topics displayed

$num_active = 10;

peace...

Thanks a lot !

you might have to change this when you install version 2.0

When is version 2.0 going to be released ?

Sometime in January would be my guess

Any improvements or new features ?

I would think so...

And btw, how do I exlcude private forum posts from being searched for the latest 10 posts ?

How can I download Poll Hack v1.0.1 software?