<?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);
 
?>

Commenting Options