[Plugin: phpbb_recent_topics] phpbb MySQL Server

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

I am using W3 Total Cache and cloudflare.

I didn’t exceeded my memory and cpu limits, the values are in normal condition.

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

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?

^^ that file is …../public_html/phpBB3/config.php

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 = \"https://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,

https://www.emanueleferonato.com/2008/02/08/how-to-show-latest-phpbb3-posts-in-your-wordpress-sidebar/

Already fixed. I disabled W3TC before I install/configure phpbb_recent_topics.

Thanks.

Thanks.

I’ve tagged this with w3-total-cache so that others can find your solution.

rgds,
Nick