WPIntell

Source evidence

[Plugin: phpbb_recent_topics] phpbb MySQL Server

phpbb_recent_topics · support · 2011-11-20T04:09:00+00:00

mixedsentiment
mediumseverity
0.85relevance
8replies
Evidence linked to opportunitycommercial context

Proof Health

Open evidence

Commercial opportunities need traceable source links before they are treated as build-worthy.

3 / 32 rows with source links

9.4% of this page's analysis has direct source links.

0 build-decision rows missing links

0 rows here require auditable proof before promotion.

29 rows with no attached evidence

0 rows have source counts but still need direct links.

Conversation

support
mistermobile resolved
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/ 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 = \"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/ 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

Comments

8 shown
linickx 2011-11-20T08:39:00+00:00

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

mistermobile 2011-11-20T10:26:00+00:00

I am using W3 Total Cache and cloudflare . I didn’t exceeded my memory and cpu limits, the values are in normal condition.

linickx 2011-11-20T11:41:00+00:00

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

mistermobile 2011-11-20T19:51:00+00:00

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?

linickx 2011-11-20T20:21:00+00:00

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

mistermobile 2011-11-20T20:55:00+00:00

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/

mistermobile 2011-11-21T06:36:00+00:00

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

linickx 2011-11-21T09:04:00+00:00

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