Suche ein Skript, das mir die neusten zB 10 Beiträge meines PHPbb-Forums anzeigt ...
wisst ihr wo ich so etwas herbekomme ?
schonmal Vielen Dank
<html>
<head>
<title>apachefriends.org - 10 newest phpBB forum articles</title>
</head>
<body bgcolor=#acacc9>
<?
$db_host="localhost";
$db_password="xxxx";
$db_user="xxxx";
$db_database="xxxx";
setlocale(LC_TIME, "de_DE");
mysql_connect($db_host,$db_user,$db_password) or die('Unable to connect database (1001)');
mysql_select_db($db_database);
$results = mysql_query("SELECT * FROM phpbb_posts,phpbb_posts_text,phpbb_users WHERE phpbb_posts.post_id=phpbb_posts_text.post_id AND phpbb_posts.poster_id=phpbb_users.user_id ORDER BY post_time DESC LIMIT 10");
while ($row = mysql_fetch_array ($results))
{
$date=strftime("%e. %B %Y",$row['post_time']);
echo "<h2>$date, {$row['username']}: {$row['post_subject']}</h2>";
$text=ereg_replace("\n","<br>",$row['post_text']);
echo $text;
echo "<p>";
}
?>
</body>
</html>
Users browsing this forum: No registered users and 15 guests