linickx

<p>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 !</p>
<h3>A bit about Database configuration.</h3>
<p>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.)</p>
<h3>How to GRANT wordpress read only access to phpBB ?</h3>
<p>If you don.t know it already you need to find your wordpress mysql user id, it.ll be in wp-config.php</p>
<pre><code>define('DB_USER', 'wp_user');     // Your MySQL username
</code></pre>
<p>and you should have already found your phpbb database & table for the above.<br />
You need to type the following syntax into your mysql database</p>
<pre><code>GRANT SELECT ON phpbb_database.phpbb_topics TO wp_user@localhost;
</code></pre>
<p>AND</p>
<pre><code>GRANT SELECT ON phpbb_database.phpbb_forums TO wp_user@localhost;
</code></pre>
<p>AND</p>
<pre><code>GRANT SELECT ON phpbb_database.phpbb_posts TO wp_user@localhost;
</code></pre>
<p>this can be achieved by logging into phpmyadmin as your phpbb user, selecting SQL and pasting the correct GRANT into the text box.</p>
<h3>How to use the Insecure Database Connectivity Method</h3>
<p>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</p>
<pre><code>$dbuser = phpbb MySQL Database UserName
$dbpasswd = phpbb MySQL Database Password
$dbhost = phpbb MySQL Server
</code></pre>
<p>Click update, and you should be connected!</p>
<h3>The Callback function</h3>
<p>To allow users to customize what is / can be displayed a callback function <code>phpbb_topics_callback</code> has been implemented.</p>
<p>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</p>
<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 "<br /><small>" . $forum->forum_name . " </small>";

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


phpbb_recent_topics

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

kikipress

<p>New Posts from phpBB is a widget plugin that grabs your recent phpBB forum posts for you to display on your WordPress site</p>
<h4>Features</h4>
<ul>
<li>Connects WordPress with your phpBB forum database </li>
<li>Allows you to select the number of recent forum posts to be displayed on your WordPress site</li>
<li>Works with the official Classic Widgets plugin, and also with the block-based widget editor</li>
<li>Available in English (default) and German. You can add your own translation if you want</li>
</ul>


New Posts from phpBB

New Posts from phpBB is a widget plugin that grabs your recent phpBB forum posts for you to display on your WordPress site

phpbb_recent_topics vs New Posts from phpBB