Eduardo Leoni

Shortcode to show the topics with more replies

bbPress Popular Topics

Shortcode to show the topics with more replies

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.

bbPress Popular Topics vs phpbb_recent_topics