Code: Selecteer alles
<?
$url = "/forum"; // If url is - http://www.yourforums.com/forums , then enter in "/forums"
if(empty($count))
$count = "5"; // How many topics to link to
$db = @mysql_connect("", "", "") or die("geen connecte");
@mysql_select_db("") or die("verkeerde tabel");
$query="SELECT * FROM phpbb_topics ORDER BY `topic_id` DESC LIMIT 0, $count";
$result=mysql_query($query);
while($row = mysql_fetch_array($result)) {
$topicid = "$row[topic_id]";
$title = "$row[topic_title]";
$forumid = "$row[forum_id]";
$replies = "$row[topic_replies]";
echo "- <a title=\"$title\" href=\"$url/viewtopic.php?t=$topicid&sid=$forumid\">$title</a> (<i>$replies</i>)<br>";
}
?>