Page 5 of 6

Re: [RC6] Last News and Messages

Posted: Thu Dec 20, 2007 7:33 pm
by orynider
I don't know is this is a bug since the mod is to display last message and you have a option to go to the last message from last page. I didn't added any paggination features to this mod and it's based on egosearch, I don't know if should pagination be added ...

Re: [RC6] Last News and Messages

Posted: Fri Dec 21, 2007 12:29 pm
by koalaii
ah ok.

I think I will mod your mod then :D I will also change the page information (instead of having previous/next x topics I will use the regular page 1 2 3 4 ...). The idea is to transform it into a viewforum format.

Thx

koa

Re: [RC6] Last News and Messages

Posted: Sat Dec 22, 2007 12:27 am
by koalaii
I've been struggling for the whole day to make a full feature viewforum of your mod, with all the topics from different forums in one page. Finally I am asking for help : http://www.phpbb.com/community/viewtopi ... 2&t=641325

Re: [RC7] Last News and Messages

Posted: Sat Dec 22, 2007 6:09 am
by orynider
Oh, if is so important for you I can add pagination, I think that two lines of code will fix it, plus template update :P

Edit:

Oky, now I added the new PAGINATION Constant to the two arrays and upgraded the prosilver template.

Other changes or features that will require more time will have to whait longer.

The file has been upgraded in File Manager! ;)

Re: [RC6] Last News and Messages

Posted: Sun Dec 23, 2007 1:23 am
by koalaii
That's very cool thanks a lot. It's a good viewforum replacement that way :)
It saves a lot of SQL queries too compared to viewforum.

Is the Icon on the left of the message is acting like in viewforum ?

koa

Re: [RC6] Last News and Messages

Posted: Wed Dec 26, 2007 12:37 am
by orynider
koalaii wrote:
Is the Icon on the left of the message is acting like in viewforum ?
I designed this based on "At a glance mod" for phpBB2 and had only a simbol like [*], one for normal and one for anoucements, bot with hot option that was then a color, now this are replaced with Olympus icons but I didn't added all Olympus features to it yet couse when I started this project I tryed to keep compatibility with phpBB2 backend of mxBB3. This was generated @ phpbb.ro in to a new "At a Glance" mod completly rewriten with all Olympus standards that are working with phpBB 2.0.22, and this version "Last News and Messages" here @ phpbb.com , plus the mxBB 2.8.1 version that will be released with the portal as official module probably, since is the first mxBB module that is using Olympus standard to build the queryes and can be used as reference for module developers there. ;)

Re: [RC6] Last News and Messages

Posted: Fri Jan 04, 2008 10:25 am
by terexwizard
Problem Latest Site News is not show in phpBB version 3.0.0 if edit code in file recent_message.php inline 128
$sql = $db->sql_build_query('SELECT', array(
'SELECT' => 'f.forum_id, f.forum_name' . $sql_title . ', t.*, p.post_time, p.poster_id, u.username as last_username, u.username as author_username',

'FROM' => array(
FORUMS_TABLE => 'f',
POSTS_TABLE => 'p',
TOPICS_TABLE => 't',
USERS_TABLE => 'u',
),

'WHERE' => 'f.forum_id IN (' . $recent_news_forum_id . ')
AND t.topic_status <> 2
AND t.forum_id = f.forum_id
AND p.post_id = t.topic_first_post_id
AND t.topic_moved_id = 0
AND p.poster_id = u.user_id
AND t.topic_poster = u.user_id',

'ORDER_BY' => 't.topic_last_post_id DESC',

));

to

$sql = $db->sql_build_query('SELECT', array(
'SELECT' => 'f.forum_id, f.forum_name' . $sql_title . ', t.*, p.post_time, p.poster_id, u.username as last_username, u.username as author_username',

'FROM' => array(
FORUMS_TABLE => 'f',
POSTS_TABLE => 'p',
TOPICS_TABLE => 't',
USERS_TABLE => 'u',
),

'WHERE' => 'f.forum_id IN (' . $recent_news_forum_id . ')
AND t.topic_status <> 2',

'ORDER_BY' => 't.topic_last_post_id DESC',

));

Latest Site News Show because show data repeated :cry:

Re: [RC6] Last News and Messages

Posted: Fri Jan 04, 2008 11:48 am
by terexwizard
mod Last News and Messages is work. i add number in last_config
// NEWS FORUM ID
$recent_news_forum_id = ''3,4,5,6,7,9'; // SEPERATE NEWS FORUMS WITH , eg '1,2,3' - SET TO '0' IF YOU DO NOT HAVE A NEWS FORUM

:D :D :D :D :D :D :D

Re: [RC6] Last News and Messages

Posted: Sat Jan 05, 2008 6:52 pm
by orynider
lol :o

Re: [RC6] Last News and Messages

Posted: Sun Dec 14, 2008 1:07 am
by orynider
You can not use mixed quotation.

$recent_news_forum_id = ''3,4,5,6,7,9'; //This is bad

$recent_news_forum_id = ''3,4,5,6,7,9"; //This should work

$recent_news_forum_id = \'3,4,5,6,7,9\'; //This should work

:o

Re: [RC6] Last News and Messages

Posted: Mon Apr 27, 2009 6:56 am
by thecrewstyle
is this mod working on phpbb 3.0.4 ?

Re: [RC6] Last News and Messages

Posted: Wed May 27, 2009 11:34 am
by JohanLM
tagged and hiya mr Ory. :)

[EDIT THE DAY AFTER]
I must ask from you who uses it (or you Ory. if you are around). Does this one show the posts from the "hidden" sections to? This is an issue atleast two other simillar MODs has, that they show all post subjects for everyone, even those that don't have access/look rights for some areas?

Is this an issue for this one to?

Re: [RC6] Last News and Messages

Posted: Tue Jun 02, 2009 1:52 pm
by orynider
Hi Johan,

Yes, all settings of the mx addon version should work and can be edited in the last_config.php settings file.

Make sure that $recent_auth_read = true; is set and only one time couse I added this line twice.

To ignore some forums you do not have here the block pannel check box only the old fashioned methosd:

$recent_forums_ignore = ' ';

Re: [RC6] Last News and Messages

Posted: Wed Jun 03, 2009 9:05 am
by JohanLM
Great, :D
And good to see you still around keeping an eye on things Ory. :)

Re: [RC6] Last News and Messages

Posted: Sun Aug 21, 2011 4:15 am
by robra
Hi, orynider.

It's great MOD. Congratulation !!!

Well, I need your help.
I created a left sidebar in Forum by overall_footer.html and put the last news and messages in a block with scroll effect, but because the line include($phpbb_root_path . 'recent_messages.'.$phpEx); is in index.php then, the last news and messages are only visible in the block when I access the principal page of the Forum, or the index page.
When I access the Topic page, the PM page and the others pages of the Forum I can see the left side bar in all pages but the block showing the last news and messages only in the index page.
How can I charge the block in the left side bar on all pages of the Forum once without put the line in each php files like viewtopic.php, viewforum.php, memberlist.php,... ?

Thank you.