WordPress Phpbb Last Topics Plugin

15 Aug 06

I created a plugin to display the most recent topics of your phpBB forum.
You can set the number of topics to display, wrap long words or exclude a category of the forum.

Just download the plugin, unpack it into your wordpress plugins-folder and activate it, then edit it to set:

$host = “http://www.yourblog.com/phpbb”;
$forum_path = “phpbb”;

Then activate it and insert this short code where you want to show the last topics.

<?php if (function_exists('wpphpbb_topics')): ?>
<? wpphpbb_topics(); ?>
<?php endif; ?>

See it in action in my homepage’s sidebar.

Download Last Version (1.1) .rar

Download Last Version (1.1) .zip

  • Upnews
  • Digg
  • del.icio.us
  • Google Bookmarks
  • PDF
Scritto da Peppe

[...] 插件页面: 点击进入 [...]

[...] I’ve found a solution for including the recent posts to the forum on the site, the website for the plugin is http://www.4mj.it/wordpress-phpbb-last-topics-plugin/ [...]

20 Aug 06 , 1:23 pm

jzn:

I get this:

Warning: Cannot modify header information – headers already sent by (output started at /apache/www.psycholoog.net/www/wordpress/wp-content/plugins/wp-phpbb.php:48) in /apache/www.psycholoog.net/www/wordpress/wp-includes/pluggable-functions.php on line 272

Does anyone know a solution???

Thanks

20 Aug 06 , 2:15 pm

Peppe:

Link me your site, http://www.psychogoloog.net/ is wrong.
Have you edit the plugin settings?
For example my site settings are
$forum_path = “forum”;
$host = “http://www.4mj.it/forum”;
$prefix = “phpbb_”;

22 Aug 06 , 7:16 pm

Kratoss:

When I insert in sidebar.php I see correctly the last messages of my phpbb forum, but I receive this error in Categories:

Warning: Invalid argument supplied for foreach() in C:\AppServ\www\wordpress\wp-includes\template-functions-category.php on line 321
No hay categorías.

If I comment , this error disappear.

What can I do?

22 Aug 06 , 7:47 pm

Peppe:

Link me your site.

23 Aug 06 , 7:21 pm

Kratoss:

It’s in localhost.

23 Aug 06 , 7:40 pm

Peppe:

Do you have any categories?
Do you have any posts?
The problem isn’t the plugin.

23 Aug 06 , 8:08 pm

Kratoss:

I have 3 categories in wordpress and 10 or 11 posts in phpbb.

Any idea?

23 Aug 06 , 8:38 pm

Kratoss:

I know that the problem isn’t the plugin, I’ll try to fix it.

Thx ;)

24 Aug 06 , 2:51 am

max:

Great work!

29 Aug 06 , 6:07 pm

Meredith:

Hi. Love the plugin.
Im wondering how it would be possible to show my latest forum posts in a list, like you have done on your site? Right now, there are no breaks between each link and it all runs together.

Thanks for any advice.

29 Aug 06 , 6:39 pm

Meredith:

Found a solution to my question…..

added li tags around this last bit of code —>
a href=\”$host”.”/viewtopic.php?t=$resultsow[topic_id]\”>$topics_title…

thanks for the plugin! works great!

6 Oct 06 , 2:37 pm

Andrew:

I have a problem with your plugin. Others have mentioned that after the plugin is installed that the sidebar lists don’t appear (Blogroll, categories, and other links), and I have noticed the same thing AFTER activating your plugin through the WP admin control panel.

It also has the effect of not redirecting to forms after submitting them in the ACP. As soon as I disable the plugin everything goes back to normal.

6 Nov 06 , 1:49 pm

alex:

the plugin is very pretty easy to install and works fine …but i need to expand it ! can you give me a solution to show the usernames to ??? like

lastpost(link)
by: username
lastpost(link)
by: username
lastpost(link)
by: username

thanx !!!

6 Nov 06 , 2:42 pm

Peppe:

ok ,now i work to it!

[...] 插件页面: 点击进入 [...]

13 Nov 06 , 7:25 pm

Gorka:

Come posso escludere alcune categorie del forum?

13 Nov 06 , 7:27 pm

Peppe:

Apri con un editor il plugin, dentro

16 Nov 06 , 6:45 pm

tjodalf:

There is a bug in the plug-in. It closes the connection to the database in the last string of code. So if you put the plug-in in the page source before posts, you’ll get a error message telling you that wordpress can’t get the posts from the database. Because the connection is closed by the plug-in.

Not a big problem. And the plug-in works GREAT! You can see it in action in the sidebar of my blog:
http://www.tjodalf.no

18 Nov 06 , 12:00 pm

Andrew:

How do you get around the database connection closure??

18 Nov 06 , 6:35 pm

tjodalf:

You just remove the last string of the plug-in. You should right away be able to see what string that has to be removed. It is not difficult at all. Just use the “try and error” method.

17 Dec 06 , 11:07 pm

fokus:

Hi! Enbody know how to get some other-languages special characers like polish? I’ve got wp and phpbb in polish, but names of post are not correct? In special-characters places this plugin display me some “?”

25 Dec 06 , 1:48 am

JonesLA:

Looking for some doorway scripts but dont know what is good. I came across TrafficboosterPro and TrafficHurricane.
Has anyone tried these programs or could tell me about any better ones?

25 Dec 06 , 12:52 pm

Mitos Kalandiel:

Nice plugin, but had to later it a little bit :

LINE35 : original# $phpbbq = “SELECT * FROM “.$prefix.”topics WHERE forum_id !=’1′ ORDER BY topic_last_post_id DESC LIMIT 0,10″;
LINE35 : new# $phpbbq = “SELECT * FROM “.$prefix.”topics WHERE forum_id !=’7′ ORDER BY topic_last_post_id DESC LIMIT 0,5″;

by default, you exclude forum_id 1 and you tell in your manual to add “AND forum_id !=’2′” , that would exclude two forum_id’s ;)

LINE 46 : original# mysql_close($connection);
LINE 46 : new# //mysql_close($connection);

Wordpress 2.0.5 doesn’t like closed connections b4 all database queries are handled, so i commented the line out

and last thing (but that’s more for formatting reasons)

LINE44 : original# $topics_title…“;
LINE44 : new# $topics_title…“;

that’s just simply to fit better into the Sidebar layout from wordpress ;)

and a little workaround, if for some reason, the plugin gets deactivated :

sidebar.php
original#
new#
… some formatting …

… more formatting …

25 Dec 06 , 1:01 pm

Mitos Kalandiel:

ah crap, my formatting has been killed :(
again the last two suggestions :

—————————–
and last thing (but that’s more for formatting reasons)

LINE44 : original# <a href=\”$host”.”/viewtopic.php?t=$resultsow[topic_id]\”>$topics_title…</a>”;

LINE44 : new# <li><a href=\”$host”.”/viewtopic.php?t=$resultsow[topic_id]\”>$topics_title…</a></li>”;

that’s just simply to fit better into the Sidebar layout from wordpress ;)

and a little workaround, if for some reason, the plugin gets deactivated :

sidebar.php
original# <?php wpphpbb_topics(); ?>
new#

… some formatting …
<?php wpphpbb_topics(); ?>
… more formatting …
<?php endif; ?>

————-
hope it works this time

25 Dec 06 , 1:03 pm

Mitos Kalandiel:

sidebar.php again *narf*

# add before “… some formatting …” #
<?php if (function_exists(‘wpphpbb_topics’)) : ?>

that’s all, merry christmas to you all :D

5 Jan 07 , 10:49 am

Podchef:

Help! What have I done wrong? I keep getting errors in my side bar? Have I not configured the addresses in the code right?

Thanks

6 Jan 07 , 1:28 am

Peppe:

You have the forum on a subdomain, try to copy your config.php(of the forum) where u have the wp, and set $forum_path with the path of the config.php.

6 Jan 07 , 3:03 am

Podchef:

Peppe, thanks for the answer, but it didn’t work. WP is on a subdomain as well. I did like you said and pointed everything to the correct path, but I am still recieving mysql errors for trying to connect.

I think it is my blasted server. I’ve had trouble with phpfetchall in the past too. Any other ideas?

Thanks

6 Jan 07 , 3:24 am

Peppe:

Ok try this, copy from your config.php of the forum:
**********************************
$table_prefix = ‘phpbb_’;
$dbhost = ‘*****’;
$dbname = ‘*****’;
$dbuser = ‘*****’;
$dbpasswd = ‘*****’;

**********************************
so the plugin will
**********************************
function wpphpbb_topics() {
// set forum path, forum host and phpbb table prefix
$prefix = “phpbb_”;
$dbhost = ‘*****’;
$dbname = ‘*****’;
$dbuser = ‘*****’;
$dbpasswd = ‘*****’;
$connection = mysql_connect($dbhost, $dbuser, $dbpasswd);
$s_db = mysql_select_db($dbname, $connection);
**********************************

6 Jan 07 , 4:36 am

Podchef:

Thanks for that. I was close to doing that myself, but wasn’t sure it would work. It Did!

I did make one change though–I kept the $host in because it’s called later in the script.

Now I just need to impliment some code to clean up the output for my sidebar and I’m there.

Thanks so much!

6 Jan 07 , 5:10 am

Peppe:

I updated the plugin to 1.1!

8 Jan 07 , 11:49 am |► Phpbb in Wordpress

[...] Io uso questo e funziona (

26 Jan 07 , 12:07 am

Daniel Cáceres:

Don’t work for me :-(

I have WP 2.1 & phpBB 2.0.22

29 Jan 07 , 12:25 pm

pico:

ciao peppe
mi pare di aver capito che per installare il tuo plugin devo configurare il file wp-phpbb.php come segue:

$host = “http://www.miosito.it/forum;
$forum_path = forum;

poi dopo aver attivato il plugin devo inserire il seguente codice ad esempio nella side bar

29 Jan 07 , 2:06 pm

Peppe:

Ciao, si funziona anche con wp 2.1, lo puoi vedere in funzione in home.

29 Jan 07 , 5:38 pm

pico:

al momento non sono ancora riuscito a farlo funzionare.
ho provato anche ad usare:

function wpphpbb_topics() {
// set forum path, forum host and phpbb table prefix
$prefix = “phpbb_”;
$dbhost = ‘69.69.69.69’;
$dbname = ‘Sql123456_1’;
$dbuser = ‘Sql123456’;
$dbpasswd = ‘123456’;
$connection = mysql_connect($dbhost, $dbuser, $dbpasswd);
$s_db = mysql_select_db($dbname, $connection);

invece di:

function wpphpbb_topics() {
//set forum path, forum host
$forum_path = “forum”;
$host = “http://www.miosito.it/forum”;
include(“”.$forum_path.”/config.php”);
$connection = mysql_connect($dbhost, $dbuser, $dbpasswd);
$s_db = mysql_select_db($dbname, $connection);

ma nulla da fare!! poi nel file “sidebar.php” del tema utilizzato ho inserito il link nel seguente modo:

Ultime dal forum

invece degli ultimi topics viene solo visualizzata una stringa di codice come indicato nel link qui sotto
http://www.topico.it/varie/wp_phpbb.png
probabilmente sbaglio qualcosa ma non so dove :-(

29 Jan 07 , 5:41 pm

Peppe:

Quel codice va inserito nel file sidebar.php, non come testo.

29 Jan 07 , 6:46 pm

pico:

cos

29 Jan 07 , 6:53 pm

Peppe:

Devo presumere che ora funzioni! Ciao

17 Feb 07 , 10:52 pm

DZGB:

hi.. i have problems using this plugin. what to do if my forum is on this type of url: forum.my-site.com?
How should the code look like then?

Because I get only this text in sidebar:

18 Feb 07 , 2:55 pm

DZGB:

anyone?

24 Feb 07 , 10:32 am

waipot:

It’s great. Thank you.

19 Mar 07 , 2:08 am

flashmotus:

ciao peppe, come vedi sono spesso dalle tue parti.
Sono alla prima esperienza di installazione forum per il mio blog. Vista la tua esperienza phpbb ritieni sia integrabile con wordpress?? Ovviamente anche grazie al tuo plugin. Insomma me lo consigli??
grazie
paolo

19 Mar 07 , 10:16 am

Peppe:

Ciao, giusto ieri http://www.phpbb.com/ ha aggiornato il propio sito con la nuova versione del forum ed una nuova vesta grafica, fossi in te aspetterei qualche giorno il rilascio della versione 3 stabile di phpbb, ora in beta5.
Ciao

9 Apr 07 , 10:13 am

KenMarshall:

Thanks for helping

18 Apr 07 , 6:28 am

xBalanaRx:

Hello,

I’m loking for a song lyrics website. I was using: http://www.lyricshunt.com but I think they brought it down for updates – I can’t access it anymore.
Sorry for posting in the “this” category.

Regards,
Balanar

[...] Visit [...]

24 Jun 07 , 10:22 am

MariaTereza:

Hello i’m new here
Let me in!

1 2 » Mostra tutto

58 commentiLascia un commento
Articoli Correlati
4MJ – Internet News © 2002 - 2010 è basato su piattaforma WordPress
Progetto e Design sono esclusiva proprietà di Giuseppe Argento.
Mappa Sito, Articoli (RSS) e Commenti (RSS) | Contatti