WordPress.org

Ready to get started?Download WordPress

Forums

PHPBB3 recent comments/posts in the sidebar (11 posts)

  1. adrisilversun
    Member
    Posted 7 years ago #

    Hello all.

    I need some help with my blog and my forum. I want to show the last 5 commented posts of my phpbb3 forum in my wordpress sidebar.

    I have no idea about coding or php. How can I do it?

    Thanks!

  2. Pete
    Member
    Posted 7 years ago #

    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.

  3. polle001
    Member
    Posted 7 years ago #

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

    Thanks.

  4. Mattias Tengblad
    Member
    Posted 6 years ago #

    Any news on this?

  5. cogo
    Member
    Posted 6 years ago #

    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: http://yoda.gatewayy.net/
    Description: This plugin gives you the recent posts in your phpBB
    Version: .9
    Author: Brandon Alexander
    Author URI: http://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: http://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.

  6. hellows
    Member
    Posted 6 years ago #

    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.

  7. tbrams
    Member
    Posted 6 years ago #

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

  8. cogo
    Member
    Posted 6 years ago #

    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?

  9. mattsbi
    Member
    Posted 6 years ago #

    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?

  10. cogo
    Member
    Posted 6 years ago #

    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?

  11. MysteryDad
    Member
    Posted 6 years ago #

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

Topic Closed

This topic has been closed to new replies.

About this Topic