[Add-on] Display posts anywhere 1.2.0 RC5

[lance1]

is this mod opend to the public yet?

[stitch626]

is this mod opend to the public yet?

Currently this mod is only available to STG supporters. There will be a download link when the mod is ready for public release.

[lance1]

is this mod opend to the public yet?

Currently this mod is only available to STG supporters. There will be a download link when the mod is ready for public release.

awwwwwwwwwww mannnn...

how do you become a STG supporter?

[Handyman]

Are there any updates on this mod?
We've been looking high and low for this.
Is there a list of specifications and compatibility somewhere? We are waiting on this or a very similar mod before we update from e107 to phpbb3. The e107 recent forums mod we have right now is just what we need. It is really important for us to have viewable posts in the mod be visibible on a permission basis.
THanks for the hard work!

mopho
[spam]

[Handyman]

Are there any updates on this mod?
We've been looking high and low for this.
Is there a list of specifications and compatibility somewhere? We are waiting on this or a very similar mod before we update from e107 to phpbb3. The e107 recent forums mod we have right now is just what we need. It is really important for us to have viewable posts in the mod be visibible on a permission basis.
THanks for the hard work!

mopho
[spam]

it's currently at Beta 3 and I'll have a Beta 4 out later this month.
It's currently only available for private testing, to the site supporters here.
It will be available to everybody once it's finished.

[globetrotting]

End of last month?
(Just wanted to indicate that I'm also waiting and that I appreciate very much your quality work on these several Mods. Thx mate )

It basically gives you the ability to display a post anywhere on a website that has phpBB3 installed on it...

So it's not possible for foreign html-sites to display posts?
Last topic titles of my phpBB2 board are currently displayed on several foreign websites, as this was easy to accomplish with the topics_anywhere Mod for phpBB2. Doesn't this make more sense, than to keep it all on your own website anyway? Giving other webmasters the opportunity to build their code fitting to their needs instead of hiding code generation in ACP?
Does anybody know of a MOD (in DEV) to realise this? I have been searching for such a MOD long time already.

Nevertheless I would donate to download the next Beta version.


[Edit: question added]

[Handyman]

no update yet? progress report: sessions are now started even when called on a non-phpBB page.
This ensures that the users only sees forums and topics you set permission for them to view.

@globetrotting, sorry I didn't see your question before.
What I just did above will probably be able to do that? I haven't tested it yet to find out, but would be interesting to see.
The zip is not yet updated with the change, just wanted to give a progress report.

[nicholasalipaz]

I get this error:

Spoiler:

Code: Select all

General Error
SQL ERROR [ mysqli ]

Unknown column 'post_time' in 'order clause' [1054]

SQL

SELECT topic_first_post_id FROM phpbb_topics WHERE forum_id = 36 ORDER BY post_time DESC LIMIT 1

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()

FILE: includes/db/mysqli.php
LINE: 185
CALL: dbal_mysqli->sql_query()

FILE: includes/db/dbal.php
LINE: 159
CALL: dbal_mysqli->_sql_query_limit()

FILE: includes/posts_anywhere.php
LINE: 146
CALL: dbal->sql_query_limit()

FILE: includes/functions.php
LINE: 3811
CALL: posts_anywhere->display_instance()

FILE: bdatabase.php
LINE: 34
CALL: posts_anywhere()

I assume it is because I am using the Forum Sort Order mod, is there a way around this?

[nicholasalipaz]

Maybe my assumption is wrong.

Here is the phpbb_topics table header row:

Code: Select all

topic_id    forum_id    icon_id    topic_attachment    topic_approved    topic_reported    topic_title    topic_poster    topic_time    topic_time_limit    topic_views    topic_replies    topic_replies_real    topic_status    topic_type    topic_first_post_id    topic_first_poster_name    topic_first_poster_colour    topic_last_post_id    topic_last_poster_id    topic_last_poster_name    topic_last_poster_colour    topic_last_post_subject    topic_last_post_time    topic_last_view_time    topic_moved_id    topic_bumped    topic_bumper    poll_title    poll_start    poll_length    poll_max_options    poll_last_vote    poll_vote_change

no column for post_time, just like the error says. Why is that?

[Handyman]

I get this error:

Spoiler:

Code: Select all

General Error
SQL ERROR [ mysqli ]

Unknown column 'post_time' in 'order clause' [1054]

SQL

SELECT topic_first_post_id FROM phpbb_topics WHERE forum_id = 36 ORDER BY post_time DESC LIMIT 1

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()

FILE: includes/db/mysqli.php
LINE: 185
CALL: dbal_mysqli->sql_query()

FILE: includes/db/dbal.php
LINE: 159
CALL: dbal_mysqli->_sql_query_limit()

FILE: includes/posts_anywhere.php
LINE: 146
CALL: dbal->sql_query_limit()

FILE: includes/functions.php
LINE: 3811
CALL: posts_anywhere->display_instance()

FILE: bdatabase.php
LINE: 34
CALL: posts_anywhere()

I assume it is because I am using the Forum Sort Order mod, is there a way around this?

it appears that should be "topic_time"
so open up includes/posts_anywhere.php

find

Code: Select all

ORDER BY post_time DESC; 

replace it with

Code: Select all

ORDER BY topic_time DESC; 

I think I have that fixed in the latest SVN, but that should fix the problem till I have the next Beta out.