List Popular Threads on Another Page...

I was just wondering if there was a way to get vB to supply the 5 or 10 (or whatever) last posted to forum topics to another page (say the site index page).

I am curious because the only part of my site that uses PHP is vB, and the rest runs on Cold Fusion and HTML.

Can anyone help explain this?

<?

      require("admin/config.php");


       $num_active = 10;

       $db=mysql_connect($servername,$dbusername,$dbpassword);
       mysql_select_db($dbname);

        $twentyfourhours= 24*60*60;
       $date1 = time() - $twentyfourhours * 1;


        $myselect = "select * from thread where lastpost > $date1 order by views desc limit 10";


        $result = mysql_query($myselect);

        if ($row = mysql_fetch_array($result)) {

do {
        printf("<li><a href=\"http://www.gandmasti.com/forum/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));
}
?>

What do I modify to make it list by replies instead? I dont want it to list views at all...

This will be for http://www.athlonoc.com

that works for pages not on your vbulletin

how would i add something like that to my vBulletin

like in my forumhome template

Vbulletin is NOT wanting me to SSI the pop topics in

http://www.athlonoc.com/vbulletin/index.php

check it out! it's actually putting in the <!--inlcude stuff...

Originally posted by krohn
Vbulletin is NOT wanting me to SSI the pop topics in

http://www.athlonoc.com/vbulletin/index.php

check it out! it's actually putting in the <!--inlcude stuff...

PHP != SHTML. Plain and simple.

so uhh... what do I do?

use

<?php include("http://website.com"); ?>

instead

Originally posted by krohn
What do I modify to make it list by replies instead?

this would make it alot more efficient...

any ideas on how to list it by replies?