phpBB2 Last 5 Topics
Platform: PHP
Published Dec 05, 2008
Updated Dec 05, 2008
Basically, this is
http://www.hawkee.com/snippet/5344/ but written for phpBB2 :)
Hopefully everyone can use this.
<?php
echo "<b>5 Latest Posts on the Discussion Forums.</b><br />";
// How Many Topics you want to display?
$topicnumber = 5;
// Change this to your phpBB path
$urlPath = "/phpbb";
// Database Configuration (Where your phpBB config.php file is located)
include $urlPath.'/config.php';
$link = mysql_connect($dbhost, $dbuser, $dbpasswd) or die("Could not connect");
mysql_select_db($dbname) or die("Could not select database");
// Get 5 Latest Posts.
$qry = mysql_query("SELECT * FROM `posts` ORDER BY `post_id` DESC LIMIT 5");
while($row=mysql_fetch_array($qry)) {
// Get Author Name.
$author1 = mysql_query("SELECT * FROM `users` WHERE `user_id` = '".$row['poster_id']."'");
$author2 = mysql_fetch_array($author1);
$author = $author2['username'];
// Get the Forum Name
$forum1 = mysql_query("SELECT * FROM `forums` WHERE `forum_id` = '".$row['forum_id']."'");
$forum2 = mysql_fetch_array($forum1);
$forum = $forum2['forum_name'];
// Get the Topic Name.
$topic1 = mysql_query("SELECT * FROM `topics` WHERE `topic_id` = '".$row['topic_id']."'");
$topic2 = mysql_fetch_array($topic1);
$topic = $topic2['topic_title'];
printf("<b><a href=\"".$urlPath."/viewforum.php?f=%s\" target=\"_BLANK\">%s</a></b> -> <b><a href=\"".$urlPath."/viewtopic.php?f=%s&t=%s&p=%s#%s\" target=\"_BLANK\">%s</a></b> by <a href=\"".$urlPath."/profile.php?mode=viewprofile&u=%s\" TARGET=\"_blank\">%s</a><br />", $row['forum_id'], $forum, $row['forum_id'], $row['topic_id'], $row['post_id'], $row['post_id'], $topic, $row['poster_id'], $author);
}
mysql_free_result($row);
mysql_close($link);
?>
