How can i take latest forum topics and show them on my new Site Layout

[hypnoticpimp]

Hey , Can someone please tell me how i can take like my latest 5 or 10 topics from a specifc section, of my forum, and show them on a section on my new site layout, not forum?, and does my site have to be .html or .php?

[Mark.B]

Hey , Can someone please tell me how i can take like my latest 5 or 10 topics from a specifc section, of my forum, and show them on a section on my new site layout, not forum?, and does my site have to be .html or .php?

There's something over on www.vbulletin.org that will do this I think.

[hypnoticpimp]

where cause i checked and kind find it?

[deatheyes]

Topx Stats
Download it here
http://www.vbulletin.org/forum/attac...chmentid=15372

[hypnoticpimp]

no, i mean like , i take a section on my forum called graphics, and i want to take like 4 of the latest posts from there and and it on to a section on my index.html site template, not the forum index.php

[elixeus]

<?
$forumid = 2; // enter the forum id here
$itemstolist = 4; // enter the total number of items to list
$forumroot = "forums"; // enter the root. Let's say it's: http://wwww.disney.com/forums/, you'd enter forums. Assuming the index.php is located: http://www.disney.com/index.php

### Shouldn't have to edit below this line ###
require_once("{$forumroot}/includes/config.php");
mysql_connect($config['MasterServer']['servername'],$config['MasterServer']['username'],$config['MasterServer']['password']) or die("Cannot connect to MySQL Server");
mysql_select_db($config['Database']['dbname']) or die("Cannot find the MySQL Database");
unset($config);
$fetchrecent = mysql_query("SELECT * FROM thread WHERE forumid='{$forumid}' ORDER BY lastpost DESC LIMIT 0,{$itemstolist}");
while($fetchitem = mysql_fetch_array($fetchrecent)){
echo("<a href='{$forumroot}/showthread.php?p={$fetchitem[threadid]}'>{$fetchitem[title]}</a>");
}
?>

I just wrote this up in 5 minutes, this stuff is easy to me. If you need anything else, let me know! BTW the file cannot be index.html it must have the extension .php, furthermore you'll need to configure the variables at top. So long as you don't use php on any other part of your index.html you can simply paste this code where you want it to display.

Also please post back if this helped you, I want to know how it went.

[hypnoticpimp]

elite my forum is www.NittoLive.info/forums

so do i have to change anything you posted!?

[hypnoticpimp]

does my site, have to be in the same host as my vb forum?

[hypnoticpimp]

Hey i did what you said and it said, Cannot Find the Mysql database!

[Colin F]

Then your config details probably aren't correct.

[hypnoticpimp]

no everythings correct! if u give u access can u do it for me

[Zachery]

If it can;t find the database then its not .

[hypnoticpimp]

why cant it find the database! my mysql is good, and i checked my config.php page and everything is good there. i mean if my config.php wasnt correct, then my forum wouldnt have worked! correct?

Please can someone do this for me

herees where i uploaded the code
http://www.nittolive.info/latesttopics1.php

see for yourself, look at what it says
link to my forums is www.NittoLive.info/forums