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.

axew3

<p>WP w3all phpBB provides free user login and registration integration between a phpBB bulletin board and WordPress CMS.</p>
<h4>Wp w3all phpBB integration</h4>
<p>Integration cookie based between WordPress and phpBB installed on same and subdomains.</p>
<p>After the setup and initialization of the plugin, WP users will automatically be added into phpBB when they register into WordPress (or in the case of old existent users, when they will login into WordPress), while without using the phpBB extension installed into phpBB, if users are allowed to register in phpBB, they will be added into WordPress when they will visit the WordPress side as logged in or at their first login in WordPress (or install the phpBB extension to add users at same time into WordPress when they register in phpBB). But you could use the plugin just only to transfer users between phpBB and WordPress by activating the plugin as not linked (read the help install page), or to show phpBB posts into a WordPress hosted into another domain</p>
<h4>Widgets</h4>
<ul>
<li>Login/logout widget (anyway users can login/logout/register on any WordPress or phpBB login form)</li>
<li>Last Topic Posts widget(Links, Links and Text, With or Without Avatars), Read/Unread Topics/Posts</li>
</ul>
<h4>Auto Embed phpBB into WordPress Template</h4>
<p>WP w3all phpBB is capable of running in iframe mode and automatically embedding phpBB into WordPress template. Setup for the iframe responsive embedded procedure is quick and quite easy!</p>
<h4>WP to phpBB and phpBB to WP users</h4>
<p>Transfer WP users into your phpBB forums and vice versa</p>
<h4>phpBB avatars into WordPress options</h4>
<p>Option to use phpBB avatars to replace WP Gravatars</p>
<h4>WordPress MUMS ready</h4>
<p>It is possible to integrate a WP Multisite network, but linking the same phpBB forum into each subsite</p>
<h4>Shortcodes and more options</h4>
<ul>
<li><a href="https://www.axew3.com/w3/2017/07/wordpress-shortcode-phpbb-posts-into-wp-post/" rel="nofollow ugc">Shortcode to display phpBB posts on WordPress posts/pages as formatted bbcode or plain text</a></li>
<li><a href="https://www.axew3.com/w3/2017/09/wordpress-shortcode-last-phpbb-topics-posts-into-wp-post/" rel="nofollow ugc">Shortcode to display recent phpBB Topics/Posts on WordPress posts/pages</a></li>
<li><a href="https://www.axew3.com/w3/wordpress-phpbb-integration-install/" rel="nofollow ugc">Check the list of others available Shortcodes on the Common How To section of the install help page</a></li>
<li>Users Transfer options</li>
<li>Check more options and features in the WP admin Settings -> WP_w3all (config page). More documentation can be found at the <a href="https://www.axew3.com/w3/wordpress-phpbb-integration-install/" rel="nofollow ugc">WP w3all phpBB help page</a> and into inline plugin admin page hints</li>
</ul>
<h4>WordPress phpBB integration without linking users</h4>
<ul>
<li><a href="https://www.axew3.com/w3/2018/01/wordpress-phpbb-integration-without-linking-users/" rel="nofollow ugc">Display phpBB posts and Last Topics Widgets into WordPress posts/pages, also cross domain, without linking users</a></li>
</ul>
<h4>Help pages</h4>
<p>WP w3all phpBB help page with common questions, setup and usage guides, and answers to frequently asked questions to be up and running in minutes are available here:<br />
<a href="https://www.axew3.com/w3/wordpress-phpbb-integration-install/" rel="nofollow ugc">WP w3all phpBB help page</a></p>


WP w3all phpBB

w3all WP phpBB integration - easy, light.

phpbb_recent_topics vs WP w3all phpBB