Originally posted by ComandoSupremo
What Mod did you use to show your most recent posts on your index page? That is what I am looking for and can't seem to find one.
A freidne of mine gave it to me and i modified it for invisionbaord. since you have phpbb here is the origonal code he gave me which wa made for phpbb:
<?php
$database = "database";
$user = "user";
$pass = "pass";
$host = "localhost";
$dblink = mysql_connect($host, $user, $pass);
mysql_select_db($database);
$sql = "SELECT topic_title,topic_last_post_id FROM `phpbb_topics` ORDER BY
`topic_time` DESC LIMIT 0, 10";
$query = mysql_db_query($database, $sql);
while ($row=mysql_fetch_array($query)) {
echo "<li> <a
href=\"http://yoursite.com/forums/viewtopic.php?p=$row[topic_last_post_id]#$row[topic_last_post_id]\">$row[topic_title]</a><br
/>\n";
}
?>
for some reason when i post a space is added between viewtopic.php? and p=$row. you need to remove this space.
btw nice site.