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
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?
- 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);
}
?>
- 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.
- Why is the date config under settings not in the widget configuration?
- 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/