Page 1 of 1

Last Messages of Phpbb3 Forum, on WP Site

Posted: Fri May 03, 2019 2:23 pm
by aknctn
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

Re: Last Messages of Phpbb3 Forum, on WP Site

Posted: Fri May 03, 2019 3:03 pm
by Mick
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.

Re: Last Messages of Phpbb3 Forum, on WP Site

Posted: Fri May 03, 2019 3:10 pm
by aknctn
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.. :|

Re: Last Messages of Phpbb3 Forum, on WP Site

Posted: Fri May 03, 2019 4:43 pm
by Tastenplayer
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);
    ?>

Re: Last Messages of Phpbb3 Forum, on WP Site

Posted: Fri May 03, 2019 5:10 pm
by aknctn
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?

Re: Last Messages of Phpbb3 Forum, on WP Site

Posted: Fri May 03, 2019 5:21 pm
by aknctn
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.

Re: Last Messages of Phpbb3 Forum, on WP Site

Posted: Fri May 03, 2019 5:26 pm
by Tastenplayer
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.

Re: Last Messages of Phpbb3 Forum, on WP Site

Posted: Fri May 03, 2019 6:37 pm
by aknctn
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/

Re: Last Messages of Phpbb3 Forum, on WP Site

Posted: Wed May 08, 2019 1:21 pm
by MarkDHamill
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/