Title: [Plugin: phpbb_recent_topics] phpbb MySQL Server
Last modified: August 20, 2016

---

# [Plugin: phpbb_recent_topics] phpbb MySQL Server

 *  Resolved [mistermobile](https://wordpress.org/support/users/mistermobile/)
 * (@mistermobile)
 * [14 years, 6 months ago](https://wordpress.org/support/topic/plugin-phpbb_recent_topics-phpbb-mysql-server/)
 * Please provide where we can find **phpbb MySQL Server**?
 * On my forum config it says,
 * **phpbb MySQL Server** = localhost
 * Is that corrrect? Beacuse when I put **localhost** on **phpbb MySQL Server**,
   my website have become super slow.
 * [http://wordpress.org/extend/plugins/phpbb-recent-topics/](http://wordpress.org/extend/plugins/phpbb-recent-topics/)

Viewing 8 replies - 1 through 8 (of 8 total)

 *  Plugin Author [linickx](https://wordpress.org/support/users/linickx/)
 * (@linickx)
 * [14 years, 6 months ago](https://wordpress.org/support/topic/plugin-phpbb_recent_topics-phpbb-mysql-server/#post-2407847)
 * Hello,
 * > On my forum config it says,
   > phpbb MySQL Server = localhost
   > Is that corrrect?
 * Yes.
 * > my website have become super slow.
 * Do you have some kind of WP caching (_memcache / wp-super-cache / etc_) ?
    Have
   you exceeded the mem / cpu limits of your host?
 * rgds,
    Nick
 *  Thread Starter [mistermobile](https://wordpress.org/support/users/mistermobile/)
 * (@mistermobile)
 * [14 years, 6 months ago](https://wordpress.org/support/topic/plugin-phpbb_recent_topics-phpbb-mysql-server/#post-2407878)
 * I am using **W3 Total Cache** and **cloudflare**.
 * I didn’t exceeded my memory and cpu limits, the values are in normal condition.
 *  Plugin Author [linickx](https://wordpress.org/support/users/linickx/)
 * (@linickx)
 * [14 years, 6 months ago](https://wordpress.org/support/topic/plugin-phpbb_recent_topics-phpbb-mysql-server/#post-2407892)
 * PRT will add about 4 queries each time it is called.
 * I don’t use W3, from reading their features page I can guess that for W3 to have
   any benefit with PRT you would need _page caching_ enabled and to have PRT setup
   in _secure_ mode (to use their DB object cache within the WP DB Object).
 * I’ve not had any other reports of significant slow down; if you are on a VPS/
   AWS style host I assume you are monitoring your %steal or have used something
   like mysqltuner.
 * If you have a patch to speed up the plugin, I’d be happy to implement it.
 * rgds,
    Nick
 *  Thread Starter [mistermobile](https://wordpress.org/support/users/mistermobile/)
 * (@mistermobile)
 * [14 years, 6 months ago](https://wordpress.org/support/topic/plugin-phpbb_recent_topics-phpbb-mysql-server/#post-2407959)
 * I have been searching on the net the whole day and i found this code,
 *     ```
       <?php
       $dbms = 'mysql';
       $dbhost = '122.122.122.122';
       $dbport = '';
       $dbname = 'emanuele';
       $dbuser = 'triqui';
       $dbpasswd = 'banana';
   
       $table_prefix = 'phpbb_';
       $acm_type = 'file';
       $load_extensions = '';
   
       @define('PHPBB_INSTALLED', true);
       // @define('DEBUG', true);
       // @define('DEBUG_EXTRA', true);
       ?>
       ```
   
 * **$dbhost** is a database address, do have an idea where can I see the database
   address of my site?
 *  Plugin Author [linickx](https://wordpress.org/support/users/linickx/)
 * (@linickx)
 * [14 years, 6 months ago](https://wordpress.org/support/topic/plugin-phpbb_recent_topics-phpbb-mysql-server/#post-2407966)
 * ^^ that file is …../public_html/phpBB3/config.php
 *  Thread Starter [mistermobile](https://wordpress.org/support/users/mistermobile/)
 * (@mistermobile)
 * [14 years, 6 months ago](https://wordpress.org/support/topic/plugin-phpbb_recent_topics-phpbb-mysql-server/#post-2407970)
 * Sorry, wrong code, here is the correct one,
 *     ```
       <?php
       $connection = mysql_connect(localhost,"your_login","your password") or die("Service temporairly unavailable");
       $db = mysql_select_db("your_db_name",$connection) or die("Service temporairly unavailable");
       $sql = "select * from phpbb_topics order by topic_last_post_time desc limit 0,10";
       $result = mysql_query($sql) or die("Service temporairly unavailable");
       for($x=1;$x<=10;$x++){
       	$row = mysql_fetch_array($result);
       	echo "<a href = \"http://www.yourforumdomain.com/viewtopic.php?f=$row[forum_id]&t=$row[topic_id]\" target = \"_blank\">$row[topic_title]</a><br>";
       }
       ?>
       ```
   
 * I found it on this site,
 * [http://www.emanueleferonato.com/2008/02/08/how-to-show-latest-phpbb3-posts-in-your-wordpress-sidebar/](http://www.emanueleferonato.com/2008/02/08/how-to-show-latest-phpbb3-posts-in-your-wordpress-sidebar/)
 *  Thread Starter [mistermobile](https://wordpress.org/support/users/mistermobile/)
 * (@mistermobile)
 * [14 years, 6 months ago](https://wordpress.org/support/topic/plugin-phpbb_recent_topics-phpbb-mysql-server/#post-2408002)
 * Already fixed. I disabled W3TC before I install/configure phpbb_recent_topics.
 * Thanks.
 *  Plugin Author [linickx](https://wordpress.org/support/users/linickx/)
 * (@linickx)
 * [14 years, 6 months ago](https://wordpress.org/support/topic/plugin-phpbb_recent_topics-phpbb-mysql-server/#post-2408012)
 * Thanks.
 * I’ve tagged this with w3-total-cache so that others can find your solution.
 * rgds,
    Nick

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘[Plugin: phpbb_recent_topics] phpbb MySQL Server’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/phpbb-recent-topics_867975.svg)
 * [phpbb_recent_topics](https://wordpress.org/plugins/phpbb-recent-topics/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/phpbb-recent-topics/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/phpbb-recent-topics/)
 * [Active Topics](https://wordpress.org/support/plugin/phpbb-recent-topics/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/phpbb-recent-topics/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/phpbb-recent-topics/reviews/)

 * 8 replies
 * 2 participants
 * Last reply from: [linickx](https://wordpress.org/support/users/linickx/)
 * Last activity: [14 years, 6 months ago](https://wordpress.org/support/topic/plugin-phpbb_recent_topics-phpbb-mysql-server/#post-2408012)
 * Status: resolved