Jeremy O'Connell

This plugin will check your phpBB board and grab vital statistics such as total members, total threads, total posts, newest member, and last post and display that information on your WordPress site. phpBB can even be on another site, server, and datacenter. You have total control over which statistics are displayed. The theme is totally customizable and its easy to modify to match your design concept.
You are able to pull statistics from up to three (3) boards and display them on your WordPress powered site. Each board may have its own refresh setting. So if you have a busy board you may update its information more frequently than one that isn’t so heavily traveled.
Why a refresh interval? When loading statistics from your phpBB install a web query is required to grab the information. This makes sense, right? Well this action is taxing because another system must be contacted and possibly another datacenter too. So the data collected from your board(s) is stored in your local WordPress database. Thus between refresh periods the phpBB statistics are loaded from your site’s database, which makes this process more optimized for performance. However there are two other important optimization features.
First when the refresh period has lapsed and its time for new information only when the next page load occurs will this plugin contact phpBB. So if you have a 15 minute refresh period and your site gets no visitors for 32 minutes then at that time the plugin will grab the updated information and start a new 15 minute count down. After all why grab the information when no one is visiting the site. Yes, if you are wondering, spiders and bots count as visitors and thus new information will be pulled if they are the visitor.
Second when it comes time to update the board information this plugin will not wait long for phpBB to respond. In fact it only waits up to two seconds. If the board can’t be contacted in that time due to a network issue, slow server, or server is down the last saved statistics are displayed. Cleverwise phpBB Statistics will then automatically keep trying with every page load to update the information. So as you can see this plugin is designed to reduce the amount of resources required to accomplish the goal at hand.
It should be noted that there are two required parts to this setup. First is, obviously, this very plugin. The second involves some important files that allow this plugin to communicate with your phpBB install(s) called the wpapi. You see this system talks to the wpapi, that is uploaded to your phpBB styles directory, and that is what gathers the actual information from your phpBB(s). Now there are two important settings in the wpapi.
First is a secret key, that you create/make up, which keeps unauthorized sources from grabbing your data. Second is an optional setting that allows you to direct the wpapi system to omit specific forum(s) when looking for the latest post. Why this feature? Well if you have a hidden forum on your phpBB board you probably don’t want any topics from it displayed in the last post to your board do you? Nope.
Now you are wondering where do you get this wpapi? The download link is posted in the “Help Guide” in this plugin. So once you have installed this plugin simply download those key files and follow the instructions in the “Help Guide”.
Language Support: Should work for all languages that use the A-Z alphabet. The default language to display the statistics is in English but is easily changeable into any language.
Live Site Preview: Want to see this plugin in action on a real live site? <a href="http://www.armadafleetcommand.com/" rel="nofollow ugc">ArmadaFleetCommand.com</a> and look in the right sidebar.
Shameless Promotion: See other <a href="https://wordpress.org/plugins/search.php?q=cleverwise" rel="ugc">Cleverwise WordPress Directory Plugins</a>
Thanks for looking at the Cleverwise Plugin Series! To help out the community reviews and comments are highly encouraged. If you can’t leave a good review I would greatly appreciate opening a support thread before hand to see if I can address your concern(s). Enjoy!

Cleverwise phpBB Statistics

Displays key phpBB statistics from up to three boards on your Wordpress site with total control over layout and what is displayed.

linickx

Do you have a phpBB forum, do you want to drag your blog readers into your forum ? Then this plugin might just help, you can include somewhere in wordpress a list of recent phpbb threads (topics) in a page, a post, and even in your theme – so your sidebar for example !
<h3>A bit about Database configuration.</h3>
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. (If you really need to, you can store the phpbb databse credential in the plugin using the “Insecure” connectivity method.)
<h3>How to GRANT wordpress read only access to phpBB ?</h3>
If you don.t know it already you need to find your wordpress mysql user id, it.ll be in wp-config.php
<pre><code>define('DB_USER', 'wp_user'); // Your MySQL username
</code></pre>
and you should have already found your phpbb database & table for the above. 
You need to type the following syntax into your mysql database
<pre><code>GRANT SELECT ON phpbb_database.phpbb_topics TO wp_user@localhost;
</code></pre>
AND
<pre><code>GRANT SELECT ON phpbb_database.phpbb_forums TO wp_user@localhost;
</code></pre>
AND
<pre><code>GRANT SELECT ON phpbb_database.phpbb_posts TO wp_user@localhost;
</code></pre>
this can be achieved by logging into phpmyadmin as your phpbb user, selecting SQL and pasting the correct GRANT into the text box.
<h3>How to use the Insecure Database Connectivity Method</h3>
From the phpbb_recent_topics admin / settings page, tick the .Enable Insecure Database Connection. box, and submit, when the page re-freshes you.ll have some more boxes to populate, from your phpbb config.php fill in
<pre><code>$dbuser = phpbb MySQL Database UserName
$dbpasswd = phpbb MySQL Database Password
$dbhost = phpbb MySQL Server
</code></pre>
Click update, and you should be connected!
<h3>The Callback function</h3>
To allow users to customize what is / can be displayed a callback function <code>phpbb_topics_callback</code> has been implemented.
In ticket 1216 (https://plugins.trac.wordpress.org/ticket/1216) phil suggested that the forum name should be displayed within the topic list; the following code is an example use of the new callback function and should be added to your themes functions.php
<pre><code>function phpbb_topics_callback($phpbbdb, $wpdb, $lnx_PRT_options, $topic) {

 // GET FORUM WHICH POST IS IN - Phil Ewels, 26/09/2010
 $sql_query = "SELECT * FROM $lnx_PRT_options[prt_phpbb_ft] WHERE forum_id=" . $topic->forum_id. " LIMIT 1";

 # Run Query
 if ($lnx_PRT_options['prt_phpbb_dbinsecureon'] == "1") {
 $forum = $phpbbdb->get_row($sql_query);
 } else {
 $forum = $wpdb->get_row($sql_query);
 }

 echo " " . $forum->forum_name . " ";

}
</code></pre>
The following variables can be used within your callback function: 
* $wpdb 
** If using Secure Connectivity this is a connection to your PHPBB Database 
** If using Insecure Connectivity this is the standard WordPress Database 
* $phpbbdb 
** If using Secure Connectivity this will be NULL 
** If using Insecure Connectivity this is a connection to your PHPBB Database 
* $lnx_PRT_options 
** An array of the phpbb-recent-topics settings 
* $topic 
** The current topic, with associated attributes.

phpbb_recent_topics

This plugin grabs your recent phpBB forum topics for you to display in wordpress.

Cleverwise phpBB Statistics vs phpbb_recent_topics