PHPBB3 recent comments/posts in the sidebar

i have no idea too, but i’m guessing it would be quite hard to do. You may want t look at phpbb3 portal, if this doesn’t work.

Hi, I am looking for this as well, the last 10 topics or replies of a phpbb3 forum, any help is really apreciated.

Thanks.

Any news on this?

There’s a no longer supported plugin by Brandon Alexander that I did some modifications to so that it works in phphBB3.

Create a folder named wp-phpbb-files in your plugins and put this in a file named wp-phpbb.php:

<?php
/*
Plugin Name: WP-phpBB
Plugin URI: https://yoda.gatewayy.net/
Description: This plugin gives you the recent posts in your phpBB
Version: .9
Author: Brandon Alexander
Author URI: https://yoda.gatewayy.net/
*/

function show_posts($limit = 5)
{
global $wpdb;
//Put your phpBB and wordpress database info here:
$WPDB = ""; //WP db name
$PHPBBDB = ""; //phpBB db name
$USERS_TABLE = "phpbb_users"; //phpbb user table
$TOPICS_TABLE = "phpbb_topics"; //phpbb topics table
$POSTS_TABLE = "phpbb_posts"; //phpbb posts table
$SITEURL = ""; //Forum URL with trailing /
	//Do not edit beyond this point
	$lastfpost = 0;
	$top5=array(-1,-1,-1,-1,-1,-1,-1,-1,-1,-1);
	$wpdb->select($PHPBBDB);
	$test = 0;
	$results = $wpdb->get_results("SELECT * FROM $POSTS_TABLE ORDER BY post_time DESC");

	if ($results)
	{
		foreach ($results as $post)
		{
			$user = $wpdb->get_row("SELECT * FROM $USERS_TABLE WHERE user_id = $post->poster_id");
			$forum = $wpdb->get_row("SELECT * FROM $TOPICS_TABLE WHERE forum_id = $post->forum_id");
			$topic = $wpdb->get_row("SELECT * FROM $TOPICS_TABLE WHERE topic_id = $post->topic_id");
			$test = 0;
			for($i=0;$i<=$limit;$i++){
			if($topic->topic_id==$top5[$i]){ $test=1; }
			}
			if($user && $topic && $test==0)
			{
				$top5[$lastfpost]=$topic->topic_id;
				$lastfpost += 1;
				echo "<li><a href='" . $SITEURL . "/viewtopic.php?f=$post->forum_id&t=$post->topic_id'>";
				$nposts=$topic->topic_replies+1;
				echo "$topic->topic_title\n";
				echo "</a>\n";
				echo " at " . date("F j, Y - H:i", $post->post_time) . " \n";
				echo "($nposts)</li>\n";
				if($lastfpost == $limit){ break; }
			}
		}
	}

	$wpdb->select($WPDB);
}

?>

Don’t forget to edit in your correct db info and url.

Activate the plugin and then put this where you want it to show:

<?php show_posts("5"); ?>

Change the number here and in the plugin to control the number of posts.

You can see it live here: https://www.sporeev.com/

If anyone would feel like further enhancing this plugin I’d be thrilled. It would be cool to be able to exclude certain forums for example.

Is this working ?
I have created a wp-phpbb-files folder,
wp-phpbb.txt file in it where I entered the above code and
edited the phpbb DB and wp DB plus the URL (edited below lines)

$WPDB = “xxxxx”; //WP db name
$PHPBBDB = “xxxxx”; //phpBB db name
$SITEURL = “xxxxx”; //Forum URL with trailing /

changed then to .php,
uploaded to plugin folder to my wp server,
activated,
dded the <?php show_posts(“5”); ?> to a post and

nothing happens.

Just tried it. This works out of the box – thanks to cogo

No prob.

hellows, are you sure you have added the code snippet into an actual template file (header.php, sidebar.php or any of your choice) instead of just inserting it into a post?

how do you activate the plug-in? i have added <?php show_posts(“5”); ?> to index.php but then index.php doesnt work, can you help?

Just follow the instructions I posted. I don’t know what else to say since I’m not that clever with PHP. Sorry. Are you sure you have added all the necessary db settings?

Wonderful, this is exactly what I have been looking for. Tried two or three other possibilities and Plugins, but only this one works perfect !