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.

onigoetz

<p>This plugin allows to use the password from a working phpBB installation to log into a WordPress blog. or on the other side to log into phpBB with the WordPress user.</p>
<p>The username for the administration must be the same on the two installations.<br />
Otherwise you will end having admins that have no privileges on the other part.</p>
<h4>How it works</h4>
<p>There is no actual “sync” of the users.</p>
<p>When the app is configured correctly. the app checks that the user who tries to log in is at least registered in one of the systems, if yes, and the password is correct : he’s logged on both systems and his account is created if missing.<br />
On password change it should also set the password on both platforms.</p>
<h4>WP2BB</h4>
<p>With WP2BB, you can now define that your posts are published in a forum, so that your community can add comments directly on them.</p>
<p>You can add the method “wp2bb()” on your template so that you have links to your forum to add comments and a replies count</p>
<p>There is also a widget to list the last replies in the forums</p>
<p>P.S. : WP2BB was created by Alfredo de Hoces (http://www.alfredodehoces.com/)</p>
<h3>Uninstall</h3>
<p>To uninstall, you have a few steps to make</p>
<p>Go the the Plugin options, revert the “auth mode” to “DB” and not “wpbb”<br />
If it doesn’t work go to the ACP in General -> Client communication -> Authentication</p>
<p>Then go to the wordpress control panel and disable the plugin.</p>
<p>The last step is then to go with FTP in the PHPBB folder and rename the file “common.php” to “common.wp.php” and the file “common-orig.php” to “common.php”.</p>
<p>Your configurations should be separated again</p>


PHPBB Single Sign On

Authenticate in Wordpress and phpBB at the same time

phpbb_recent_topics vs PHPBB Single Sign On