Latest post on your homepage ( phpbb )

This is a php code it show the latest forum post with phpBB3 on the homepage of your website. It work with your config.php in your PHPBB directory. If you wish to show more then the latest 5 posts you can change the $topicnumber to whatever you wish to display.

Comments

Thanks for the code, which works perfectly with phpbb3, but I have an issue to display the German umlaut in my website.
If applying the code I just see a � instead of the umlaut Ä, Ü or Ö.
Can sombody support what I have to put in the code to have displayed the umlaut correctly? (both database and website are in UTF-8)
Thanks in advance.

All I can get to display is Could Not Connect. From what I can tell that's displayed if login fails? I am still trying to re-teach myself some of this stuff after a lengthy break in web dev. My URL path I put in the URL not referencing the folder relative to where the file is. Am I supposed to put my login and password in the code or let it call it from the config.php file?

Hi there, Great script! However I see one problem for anyone that moderates comments before they are put live. The unapproved comments show up on the pages running this script. Is there a way to ensure they cannot be seen until approved? Thanks.

I have a BB that will eventually have many Categories & Forums - is there a way to automatically include forums into the latest post snippet without having to add each forum or forum number into the code?

also is there a way I can remove the username & date from the snippet - so just the post's topic appears

and also, how can i make it display on my home page (in a content box that i create), since i've only changed the config.php for the forum, i think i'd need an additional step to call it up in my homepage?

I have a BB that will eventually have many Categories & Forums - is there a way to automatically include forums into the latest post snippet without having to add each form or forum number into the code?

also is there a way I can remove the username & date from the snippet - so just the post's topic appears

Note the line "t.forum_id <> X AND". Change X to the number of the forum. This number can be found by looking at the URL of the forum. It is f=X in the URL. For example http://www.yourwebsite.com/viewforum.php?f=5. In this case it is 5. You can repeat the line t.forum_id <> X AND for each for you want excluded.

What must I change to show only new posts from a part of the forum? My forum has different boards about HiFi/Homecinema, Games, Fischertechnik and Hiking. So I only want to show new posts in the Hiking part.