phpbb_recent_topics version 0.4.1
UPDATE: This Plugin has been updated, please download the update from http://wordpress.org/extend/plugins/phpbb-recent-topics/, and please comment on the new post, thanks.
This is a small update, it incorporates the patch submitted by toni to fix the widget, thanks toni 
The old information still applies…
 |
| Admin GUI |
If you’re happy with v0.4 and have it running fine then don’t bother, in fact edit phpbb_recent_topics.php so that WordPress stops complaining about finding a newer version.
Download phpBB_Recent_Topics_0.4.1 from wordpress.org
What’s New?
- The widget patch mentioned above!
What’s Old?
- Most importantly I have tested this plugin with phpBB3 and WP2.5 so I’ve updated the readme.txt to reflect this.
- I finally quashed the install bug where by phpbb-recent-topics was confused with phpbb_recent_topics.
- Sidebar Widget, yus for all you non-php people you have a widget to play with.
- Edit the Time & Date layout – leave blank to remove it completely
The Installation
- Unzip phpbb_recent_topics.tgz in your `/wp-content/plugins/` directory. (You’ll have a new directory, with this plugin in /wp-content/plugins/phpbb_recent_topics)
- Activate the plugin through the ‘Plugins’ menu in WordPress
- Configure the plugin, you need to tell wordpress about phpbb, this is done in the wordpress menu ‘Settings’ -> ‘phpBB Recent Topics’
The following Settings are required:- * The name of your phpBB database (e.g phpbb)
- * The name of the table where topics are held (the default is phpbb_topics )
- * The full url of your forum for links (e.g. http://www.mydomain.com/forum)
- * The number of topics to show. (If left blank you get 5)
- * The Date Formatting, i.e. “d/M/y – g:i a” similar to the WordPress “General Settings”
- Hit ‘Update Options”
- To output the list of topics in a page or post…
- * create a new page/post, type {phpbb_recent_topics} , hit ‘Publish’ or ‘Create new page’
To output the list of topics in your theme sidebar using the widget…
- * click “design” in the dashboard
- * click “widgets”
- * next to phpBB Recent Topics click “add”
- * click “save changes”
To output the list of topics in your theme sidebar using a template tag…
- * edit sidebar.php and inside <div id=”sidebar”> type…
<?php if (function_exists('phpbb_topics')) { phpbb_topics(); } ?>
A bit about Database configuration.
If wordpress & phpBB share a DB already then set $PHPBBDB to DB_NAME and everything will be fine, else you’re going to need to GRANT the wordpress user read access to phpBB.
How to GRANT wordpress read only access to phpBB ?
If you don’t know it already you need to find your wordpress mysql user id, it’ll be in wp-config.php
define('DB_USER', 'wp_user'); // Your MySQL username
and you should have already found your phpbb database & table for the above.
You need to type the following syntax into your mysql database
GRANT SELECT ON phpbb_database.phpbb_topics TO wp_user@localhost;
this can be achieved by logging into phpmyadmin as your phpbb user, selecting SQL and pasting the correct GRANT into the text box.
Frequently Asked Questions
- Is phpbb3 supported?
- yes.
- Can I output 10 Topics in my Page, and 3 Topics in my Sidebar ?
- Yes ! In the Wordpress menu ‘Options’ -> ‘phpBB Recent Topics’, set ‘The number of topics to show’ to 10, and then in your sidebar include…<?php
if (function_exists(‘phpbb_topics’)) {
phpbb_topics(3);
}
?>
- Yes ! In the Wordpress menu ‘Options’ -> ‘phpBB Recent Topics’, set ‘The number of topics to show’ to 10, and then in your sidebar include…<?php
- Can I exclude a certain forum from the list ?
- In this version, the only way to do that is to hack /wp-content/plugins/phpbb_recent_topics/display/display.php, change
$results = $wpdb->get_results("SELECT * FROM $TOPIC_TABLE ORDER BY topic_time DESC LIMIT $LIMIT");to
$results = $wpdb->get_results("SELECT * FROM $TOPIC_TABLE WHERE forum_id != 1 ORDER BY topic_time DESC LIMIT $LIMIT");to exclude forum 1 from the list. I plan to setup a proper solution to this in the next version.
- In this version, the only way to do that is to hack /wp-content/plugins/phpbb_recent_topics/display/display.php, change
- Why is the date config under settings not in the widget configuration?
- The date settings effect both the template tag and the widget
- The date settings effect both the template tag and the widget
Support
I’ve always been honest about support, there isn’t any. Basically I write this for my own needs and then publish it for you to use for free. You’re more than welcome to post comments here and if you tag wordpress forum posts with “phpbb-recent-topics” I’ll reply to you there, but we all have busy lives and I make no promises on how quickly I’ll reply to you.
Link for posting in the correct phpbb-recent-topics forum
Finally Subversion
You also might be interested to know that I’ve been getting to grips with the wordpress plug-ins svn, so you can get work directly from here; and when wordpress.org re-crawls my readme the latest version will also be available on wordpress.org/extend/plugins/ 
hi. Thanks for plugin
perfect.
Regards
Hi,
Is this plugin converst iso to utf-8?
Thanks.
[...] phpbb_recent_topics [...]
I upgrade my plugin and now the widget displays this error:
WordPress database error: [Unknown column 'topic_time' in 'order clause']
SELECT * FROM phpbb_posts ORDER BY topic_time DESC LIMIT 10
That’s odd Brad, I’ll double check my install; if you want to roll back you can get older versions from http://wordpress.org/extend/plugins/phpbb-recent-topics/download/
I’ve just completed a fresh install of wordpres 2.6.5 and phpBB 3.03 and the plugin and widget are working as they should
Thanks for looking in to that. I’m doing this upgrade for a friend of mine and I think they might have a hacked version of phpBB. I’m just going to have to change the query around on your widget a bit to work. Thanks again!
[...] phpbb_recent_topics [...]
Thanks!
Thanks for the plugin! I’ve installed on wordpress 2.7 and it works well.
But I’m confused about setting exclude forum. If I have more than 1 forum to exclude how can I do it?
Hi Seasonkore,
I had some spare time this afternoon and have developed version 0.5 of this plug-in and it includes “forum exclude” functionality.
I don’t have time to test it fully for general release. If you’d like to test it for me, please download the development version from http://wordpress.org/extend/plugins/phpbb-recent-topics/download/
I’d love to know how you get on
EDIT: Version 0.5 requires extra access, an SQL statement something like this will be required
GRANT SELECT ON phpbb_database.phpbb_forums TO wp_user@localhost;replace phpbb_database and wp_user as appropriate.Hi guys, great job with this plug-in.
But I have a problem. My phpBB forum is in http://www.mysite.it/forum and my neoblog is in http://www.mysite/blog.
I have installed the plug-in, but the result is:
01/Jan/70 – 1:00 am
stop
The “grant select on” procedure in phpMyAdmin fails with an SQL error… The DB are two, one for phpBB and one for WP.
What’s wrong?
g
This plugin is great. Thanks a lot!
It displays latest created topics and I was wondering if it was possible to display latest updated topics.
Thanks by advance.
Hi,
i cant seem to get the plugin to work. i can’t get the
GRANT SELECT ON phpbb_database.phpbb_forums TO wp_user@localhost;
to execute in my MySQL. i get an error in phpMyAdmin
SQL query: Documentation
GRANT SELECT ON phpbb_topics
TO wp_user@localhost
MySQL said: Documentation
#1044 – Access denied for user ‘db24836′@’%’ to database ‘db24836_myoforum’
can anyone help ?
nice 0.5 version
works perfect ! why don’t you release it ?
It’s on the todo list
… as soon as I get some time, I need to check that 0.5 doesn’t break stuff for users who are upgrading; I’m worried that the new DB access requirements will “crash” sites… especially since plug-in auto upgrade functionality is now soooooo easy in WordPress.
I get an error in WP 2.7.1 so I presume it is not compatible with that version or?
This is the error i get:
Fatal error: Cannot access empty property in /home/2/f/friesport/www/wp-includes/user.php on line 538
Any idea why? (I am not a sql or php shark
)
Hi,
TBH I’ve had no other complaints, my dev box has 2.7.1 on it and it’s working alright; any useful errors in your apache error_log ?
I dont have root access to my server, only the /www root, unless you tell me where I else can see it? As I said before I am not a guru in these things
Hi,
I have the same problem. Anybody solve it ?
Hi,
Do you have the same problem as Friesport?
Can you get any error logs to help diagnose the problem?
I have Wordpress On Server “X”(.COM)
And I have phpbb3 On Server “Y”(.e90.biz)
I have Full Access To Both Of them…
But I can’t Find way How to make your Plugin Work when wordpress and phpbb3 are on difrend Hosting Services ;/
Do you know Ho I could do it ?
Hi hikikomori,
The current version of plug-in can’t do that as we don’t make a new database connection.
It’s something I’ve considered changing as the “allowing mysql db access” is the biggest issue users face; the problem is it would mean storing your phpbb mysql credentials in the WP database and this isn’t a secure thing to do
I posted this here too ( http://wordpress.org/support/topic/271380?replies=1 ) but I thought I would try here as well:
Hi there, I’ve been using this plug-in for months. Currently, I have one forum excluded from being displayed, via the script in the FAQ:
$results = $wpdb->get_results(“SELECT * FROM $TOPIC_TABLE WHERE forum_id != 1 ORDER BY topic_time DESC LIMIT $LIMIT”);
Where 1 is the number of that forum. My question is, Let’s say I want to exclude Forum Numbers 2 and 3 as well. What would I change the code to?
Hopefully this will help?
Cheers,
Nick
This plugin doesn’t take care of unapproved posts in phpbb appearing on the widget in wordpress. I hope it is added into the next version. Change display.php to have following statement.
SELECT * FROM $TOPIC_TABLE WHERE TOPIC_APPROVED = 1 ORDER BY topic_time DESC LIMIT $LIMIT
and unapproved comments (SPAMS) to appear on blog.
This plugin is the best “Recent phpBB plugin” for wordpress. I’ve tried two more.
I couldn’t get this to work, when i activated it, my blog displayed on critical (Catchable) error in classes.php file and none of the sidebar widgets would appear (categories, posts. etc.)
N33D has that problem (http://wordpress.org/support/topic/276738) but he/she seems to have disappeared.
GF, perhaps you can help me troubleshoot?
My Questions:
Can you get the plugin to work with the default theme and all other plugins disabled?
what version of PHP are you running?
is you error message the same as n33d’s?
do you have any other errors that might help?
Cheers
I too received the catchable error, was not able to install… I can assist with the troubleshooting effort if needed.
Specifically:
Catchable fatal error: Object of class WP_Error could not be converted to string in /XXXX/wp-includes/classes.php on line 1315
Hi
I’mtrying for quite some time to resolve this:
I’d like to use phpBB forum (with its powerful engine-users to be able to send PM, upload attachments, etc) for comments within ONE single topic , on one WP page (without whole forum structure)?!
I’ve found a way to embed phpbb within a WP page (WP-United) but… how to achieve to have only 1 topic on on Board index without Categories and Forums – or at least with. having Categories on phpBB???
You played around making this Plugin, maybe you know?
Great plugin! But i can’t edit the optionspage since 2.8.2
wp-admin/options-general.php?page=phpbb-recent-topics/display/admin-options.php
error: you don’t have the right level to edit.
What’s the problem?
Cheers!
Can’t enter the options page anymore since 2.8.2 becouse i don’t have enough rights / wrong user level
Hi Margje, you are correct there is a compatibility issue with 2.8.2, I have a fix just not the time to implement it.
In the mean time de-active the plugi;, I’m hoping to get an update working in the next week or so, you can then update using the auto-update-feature in WordPress.
Cheers,
Nick
i am trying to set this up in my word press, when i go to edit the settings i get this msg
You do not have sufficient permissions to access this page
Any news on the update, sorry to pressure just wondering 2.8.3 is now out.
Version 0.4.2 is finally out, this should fix the issue caused by upgrading to WP 2.8.x.
Sorry for the delay life is busy!
Please auto-update or download from WP: http://wordpress.org/extend/plugins/phpbb-recent-topics/
Comments Closed, new post here: http://www.linickx.com/archives/1775/phpbb_recent_topics-fixed-for-2-8-3