Last Messages of Phpbb3 Forum, on WP Site

Looking for an Extension? Have an Extension request? Post your request here for help. (Note: This forum is community supported; while there is an Extensions Development Team, said team does not dedicate itself to handling requests in this forum)
Ideas Centre
Post Reply
aknctn
Registered User
Posts: 12
Joined: Fri May 03, 2019 2:10 pm

Last Messages of Phpbb3 Forum, on WP Site

Post by aknctn » Fri May 03, 2019 2:23 pm

Hello, I don't know English very well. I'm sorry for this.

I have a Phpbb3 forum and I have a Wordpress website. I want to view my messages of Phpbb3 forum on my Wordpress website. Can you help me for this?

I found this but I couldn't make it.
https://wordpress.org/plugins/wp-w3all- ... escription

User avatar
Mick
Support Team Member
Support Team Member
Posts: 21593
Joined: Fri Aug 29, 2008 9:49 am
Location: Caerdydd

Re: Last Messages of Phpbb3 Forum, on WP Site

Post by Mick » Fri May 03, 2019 3:03 pm

I don’t think there’s anything to do that in the extensions database but I’ll move this over to extension requests somebody may have an idea.

There are many people using the bridge you posted a link to so if you can’t get that to work you need to speak to them about it.
"The more connected we get the more alone we become" - Kyle Broflovski

aknctn
Registered User
Posts: 12
Joined: Fri May 03, 2019 2:10 pm

Re: Last Messages of Phpbb3 Forum, on WP Site

Post by aknctn » Fri May 03, 2019 3:10 pm

Mick wrote:
Fri May 03, 2019 3:03 pm
I don’t think there’s anything to do that in the extensions database but I’ll move this over to extension requests somebody may have an idea.

There are many people using the bridge you posted a link to so if you can’t get that to work you need to speak to them about it.
Thank you for back. I searched but I couldn't find a contact. There is a phpbb support forum in my country and own language but they couldn't help me. Now, I'm here.. :|

User avatar
Tastenplayer
Registered User
Posts: 330
Joined: Thu Jul 03, 2014 9:20 pm
Location: Switzerland
Name: Jutta Koliofotis
Contact:

Re: Last Messages of Phpbb3 Forum, on WP Site

Post by Tastenplayer » Fri May 03, 2019 4:43 pm

It works with a script. But what you have to do, that it is responsive I don't know. My portal unfortunately has scrollbars since some time. :cry: https://www.portal.my-tastenworld.ch/

newpost.php

Code: Select all

<?php
    // How Many Topics you want to display?
    $topicnumber = 12;
    // Change this to your phpBB path
    $urlPath = "https://your forum link";
 
    // Database Configuration (Where your phpBB config.php file is located)
    include 'https://www.your forumlink/config.php';
 
    $table_topics = $table_prefix. "topics";
    $table_forums = $table_prefix. "forums";
    $table_posts = $table_prefix. "posts";
    $table_users = $table_prefix. "users";
    $link = mysqli_connect("$dbhost", "$dbuser", "$dbpasswd") or die("Could not connect");
    mysqli_select_db("$dbname") or die("Could not select database");
 
    $query = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username
    FROM $table_topics t, $table_forums f, $table_posts p, $table_users u
    WHERE t.topic_id = p.topic_id AND
    f.forum_id = t.forum_id AND
    t.forum_id != 4 AND
    t.topic_status <> 2 AND
    p.post_id = t.topic_last_post_id AND
    p.poster_id = u.user_id
    ORDER BY p.post_id DESC LIMIT $topicnumber";
    $result = mysqli_query($query) or die("Query failed");									
 
    print "<table cellpadding='3' cellSpacing='2' width='780'>";
    while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
 
    echo  utf8_encode("<tr valign='top'><td><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><font color=\"#283857\"><style=\"text-decoration:none\"><b><a href=\"$urlPath/viewtopic.php?f=$row[forum_id]&t=$row[topic_id]&p=$row[post_id]#p$row[post_id]\" TARGET=\"_blank\">" .
    $row["topic_title"] .
    "</a></td></font></b><td><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><font color=\"#283857\"> User: <a href=\"$urlPath/memberlist.php?mode=viewprofile&u=$row[user_id]\" TARGET=\"_blank\">" .
    $row["username"] .
    "</td><td><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><font color=\"#283857\">" .
    date('d.m.Y, H:i', $row["post_time"]) .
    "</td></tr></font>");
    }
    print "</table>";
    mysqli_free_result($result);
    mysqli_close($link);
    ?>
Last edited by Tastenplayer on Fri May 03, 2019 5:22 pm, edited 4 times in total.
My phpBB Style Board & More[DEV] Prosilver_color-blinds 3.2.8FlowerPower 3.2.8 Screenshots & Download
Be the best version of yourself rather than a bad copy of someone else!
Excuse me for my English, but I learned the language by speaking to people and not at school.

aknctn
Registered User
Posts: 12
Joined: Fri May 03, 2019 2:10 pm

Re: Last Messages of Phpbb3 Forum, on WP Site

Post by aknctn » Fri May 03, 2019 5:10 pm

Scorpy wrote:
Fri May 03, 2019 4:57 pm
You can display an RSS feed in WordPress.

To do this, follow the steps below:

1. Log in to your WordPress admin area and go to Widgets in the Appearance section.
2. Click the Add button next to the RSS widget.
3. In the Current Widgets section on the right click Edit for the RSS widget.
4. Type the RSS feed URL, its title (optional) and check what item details to display (optional).
5. Click Done and then Save Changes to publish the RSS feed on your blog.
Sorry, Can I view phpbb forum messages with RSS on WP site?

aknctn
Registered User
Posts: 12
Joined: Fri May 03, 2019 2:10 pm

Re: Last Messages of Phpbb3 Forum, on WP Site

Post by aknctn » Fri May 03, 2019 5:21 pm

Tastenplayer wrote:
Fri May 03, 2019 4:43 pm
It works with a script. But what you have to do, that it is responsive I don't know. My portal unfortunately has a scrollbar at the bottom since some time. :cry: https://www.portal.my-tastenworld.ch/
Yours good but just it is viewing titles.

User avatar
Tastenplayer
Registered User
Posts: 330
Joined: Thu Jul 03, 2014 9:20 pm
Location: Switzerland
Name: Jutta Koliofotis
Contact:

Re: Last Messages of Phpbb3 Forum, on WP Site

Post by Tastenplayer » Fri May 03, 2019 5:26 pm

But even if you see an interesting title and click on it you will end up in the post in the forum. I found it good and sufficient. :) And no feeds need to be activated in the forum.
But unfortunately the end of Sript seems to have come, thanks to the latest browser and the responsiveness.
My phpBB Style Board & More[DEV] Prosilver_color-blinds 3.2.8FlowerPower 3.2.8 Screenshots & Download
Be the best version of yourself rather than a bad copy of someone else!
Excuse me for my English, but I learned the language by speaking to people and not at school.

aknctn
Registered User
Posts: 12
Joined: Fri May 03, 2019 2:10 pm

Re: Last Messages of Phpbb3 Forum, on WP Site

Post by aknctn » Fri May 03, 2019 6:37 pm

Scorpy wrote:
Fri May 03, 2019 5:18 pm
aknctn wrote:
Fri May 03, 2019 5:10 pm
Sorry, Can I view phpbb forum messages with RSS on WP site?
Yes, you can. Check this: https://igre.trkeljanje.com/ - it is a WordPress site with an RSS feed from phpBB forum.
Thank you very much. I tried and it is working now very good. Thank you again, thank you all of you.

http://www.teknofenomen.com/

User avatar
MarkDHamill
Registered User
Posts: 3929
Joined: Fri Aug 02, 2002 12:36 am
Location: Florence, MA USA
Contact:

Re: Last Messages of Phpbb3 Forum, on WP Site

Post by MarkDHamill » Wed May 08, 2019 1:21 pm

You might want to use my Smartfeed extension for more control over the topic title.

I noted a bug in the version of SimplePie bundled with Wordpress and the Atom feed. So you may prefer Smartfeed for its RSS feed to get around it. Wrote about it on my blog:

https://www.phpbbservices.com/2019/01/3 ... y-webpage/
Get the latest versions of my Digests and Smartfeed extensions.
Need phpBB services or a phpBB consultant? I offer most phpBB services.

Post Reply

Return to “Extension Requests”