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?

Use this code instead:

<?php
// Set this to the max number of threads to display
$maxthreads = 5;

require("config.php");
$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);
$query = "SELECT * FROM thread ORDER BY lastpost DESC LIMIT $maxthreads";
$resultlatest = mysql_query($query,$db);
while ($latest_array = mysql_fetch_array($resultlatest)) {
echo "<FONT SIZE=\"2\" FACE=\"Verdana, Arial, Helvetica, sans-serif\">&nbsp;°
<A HREF=\"http://www.YourDomain.com/showthread.php?threadid=$latest_array[threadid]\">$latest_array[title]</A></FONT><BR>";
}
 
?>

thanx......but is there a way to display replies with this also?

i can get views to display...but not replies

<?php include("http://athlonoc.com/vbulletin/pop.php"); ?>

that didn't work Where I'm trying to put this is in the footer template. http://www.athlonoc.com/vbulletin/index.php it's on the right side. I'd like to include some things in the forum's template but I can't figure it out!

Did you make it so your footer will work with php?

$footer = include("http://athlonoc.com/vbulletin/pop.php");

and enable PHP adfooter in the control panel!


Correct if I am wrong.

Instead of listing the last 5/10 posts, I wanted to list the most popular threads for the month. Your subject says "popular", so in case you're interested in that too, here's the code I used to list the 5 most popular topics of the month on a different page. It is sorted by reply count and skips the private forums.

require("../bb/admin/config.php");

$num_active = 5;
$db=mysql_connect($servername,$dbusername,$dbpassw ord);
mysql_select_db($dbname);

$myselect = "SELECT * from thread where MONTH(FROM_UNIXTIME(lastpost))=MONTH(NOW()) AND YEAR(FROM_UNIXTIME(lastpost))=YEAR(NOW()) AND (forumid < 8 OR forumid > 10) order by replycount desc limit $num_active";
echo "<A NAME='#popular'>";
echo "<H3>This month's most popular board topics</H3>";

$result = mysql_query($myselect);

if ($row = mysql_fetch_array($result)) {
$counter=0;
do {
$counter=++$counter;
echo ("$counter. <a href=\"http://www.yourdomain.com/bb/showthread.php?threadid= $row[threadid]\">$row[title]</a> - $row[views] views - $row[replycount] replies<BR>");
} while ($row = mysql_fetch_array($result));
}