Reversing post order to oldest first?

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Anti-Spam Guide
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Leandre
Registered User
Posts: 7
Joined: Fri Feb 05, 2010 2:54 pm

Reversing post order to oldest first?

Post by Leandre »

Is there a place to switch all postings to show up oldest-first? I could have sworn i saw the option somewhere but cannot find it again for the life of me.

Thanks,
Leandre
Pit$Bull
Former Team Member
Posts: 23099
Joined: Sat Dec 02, 2006 4:08 pm
Name: Can't Remember

Re: Reversing post order to oldest first?

Post by Pit$Bull »

User control panel->board preferences->edit display options.
Leandre
Registered User
Posts: 7
Joined: Fri Feb 05, 2010 2:54 pm

Re: Reversing post order to oldest first?

Post by Leandre »

But that is a user-by-user option, correct? As the Board Admin, I was hoping to set the default to older-first.
Pit$Bull
Former Team Member
Posts: 23099
Joined: Sat Dec 02, 2006 4:08 pm
Name: Can't Remember

Re: Reversing post order to oldest first?

Post by Pit$Bull »

User avatar
HGN
Former Team Member
Posts: 4706
Joined: Wed Dec 03, 2008 1:53 pm
Location: The Netherlands
Name: Alfred

Re: Reversing post order to oldest first?

Post by HGN »

First of all you have to set the Board preferences for "Display post order direction" of the Anonymous user to "Descending". In the Administration Control panel, select Manage users and tickmark to select Anonymous user. For the Anonymous user select the Form "Preferences" and modify "Display post order direction:" to "Descending".

Second is you have to set the default value for the database field "user_post_sortby_dir" in table "phpbb_users" to "d" by running the following SQL query:

Code: Select all

ALTER TABLE phpbb_users CHANGE user_post_sortby_dir user_post_sortby_dir VARCHAR(1) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'd'
And third, in case you want to modify the sorting order of all of your users to descending you will have to run the following query:

Code: Select all

UPDATE phpbb_users SET user_post_sortby_dir = 'd' WHERE 1 ;
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52789
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve

Re: Reversing post order to oldest first?

Post by stevemaury »

Why do you care how your users like to order their posts?
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
Leandre
Registered User
Posts: 7
Joined: Fri Feb 05, 2010 2:54 pm

Re: Reversing post order to oldest first?

Post by Leandre »

Because for this specific forum, it is important that the people who posted first about a subject show up on top; it is a first-come/first-serve type of thing. I am fine with the user changing it to read the way they want, but we want the default to be older first.
User avatar
paulnicholson
Registered User
Posts: 230
Joined: Thu Jun 04, 2009 9:04 pm
Location: Australia

Re: Reversing post order to oldest first?

Post by paulnicholson »

Of course this should be selectable on a per forum basis in the ACP. It's really important. Less than 1% of visitors are going to read all the settings and learn how a website works. It has to be intuitive. I need to set the order as well. It's so obvious I'm surprised the developers have overlooked it. I'd rather flick a switch than waste time manipulating the database. Takes forever, and I've got hundreds of MODs to do. Furthermore, all MODs that have been confirmed to work should be included upon installation of this software. It'd be easy for the developers to incorporate, I'll bet. Just a page of 500 MOD options. They're already made. Just incorporate them.
Last edited by paulnicholson on Tue Mar 16, 2010 11:35 pm, edited 1 time in total.
User avatar
ric323
Former Team Member
Posts: 22910
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric

Re: Reversing post order to oldest first?

Post by ric323 »

paulnicholson wrote:I've got hundreds of MODs to do.
"Hundreds" ? Don't, you will regret it.
Furthermore, all MODs that have been confirmed to work should be included upon installation of this software.
No they shouldn't. Almost every MOD you install adds a bit more workload to your web server. I wouldn't want most of the MODs available anyway.
It'd be easy for the developers to incorporate, I'll bet.
No it wouldn't.
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions
User avatar
paulnicholson
Registered User
Posts: 230
Joined: Thu Jun 04, 2009 9:04 pm
Location: Australia

Re: Reversing post order to oldest first?

Post by paulnicholson »

HGN wrote:First of all you have to set the Board preferences for "Display post order direction" of the Anonymous user to "Descending". In the Administration Control panel, select Manage users and tickmark to select Anonymous user. For the Anonymous user select the Form "Preferences" and modify "Display post order direction:" to "Descending".

Second is you have to set the default value for the database field "user_post_sortby_dir" in table "phpbb_users" to "d" by running the following SQL query:

Code: Select all

ALTER TABLE phpbb_users CHANGE user_post_sortby_dir user_post_sortby_dir VARCHAR(1) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'd'
And third, in case you want to modify the sorting order of all of your users to descending you will have to run the following query:

Code: Select all

UPDATE phpbb_users SET user_post_sortby_dir = 'd' WHERE 1 ;
Thanks. This worked. How do I UNDO this please?

Also, how do I specify forums to be reordered?
User avatar
ric323
Former Team Member
Posts: 22910
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric

Re: Reversing post order to oldest first?

Post by ric323 »

paulnicholson wrote:Thanks. This worked. How do I UNDO this please?
Undo what?
If you mean changing all your users preferences back to how they were, you can't. You have over-written what they had with the new value.
Also, how do I specify forums to be reordered?
The order forums are listed in is totally manual. Use the forum management tab in the ACP to move them up or down.
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions
User avatar
paulnicholson
Registered User
Posts: 230
Joined: Thu Jun 04, 2009 9:04 pm
Location: Australia

Re: Reversing post order to oldest first?

Post by paulnicholson »

ric323 wrote: paulnicholson wrote:Thanks. This worked. How do I UNDO this please?


Undo what?
If you mean changing all your users preferences back to how they were, you can't. You have over-written what they had with the new value.
Undo the changes described in this thread. It seems obvious that it could. I could probably alter the settings below somehow, using an 'a' instead of a 'd'.
HGN wrote: Code: Select all
ALTER TABLE phpbb_users CHANGE user_post_sortby_dir user_post_sortby_dir VARCHAR(1) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'd'



And third, in case you want to modify the sorting order of all of your users to descending you will have to run the following query:

Code: Select all
UPDATE phpbb_users SET user_post_sortby_dir = 'd' WHERE 1 ;
ric323 wrote: Also, how do I specify forums to be reordered?


The order forums are listed in is totally manual. Use the forum management tab in the ACP to move them up or down.
No, not reordered on the forum display page. I mean reordered as specific to the topic we are discussing. How do I specifically reorder the post displays within each topic, forum by forum. Some forums would be oldest to newest, some would be newest to oldest, some would be in alphabetical order.
User avatar
HGN
Former Team Member
Posts: 4706
Joined: Wed Dec 03, 2008 1:53 pm
Location: The Netherlands
Name: Alfred

Re: Reversing post order to oldest first?

Post by HGN »

paulnicholson wrote:Undo the changes described in this thread. It seems obvious that it could. I could probably alter the settings below somehow, using an 'a' instead of a 'd'.
That's not an "undo", since you don't know per user if they had an 'a' or 'd' before you forced them all to 'd'. What you name "undo the changes" is just forcing them to another setting.
User avatar
paulnicholson
Registered User
Posts: 230
Joined: Thu Jun 04, 2009 9:04 pm
Location: Australia

Re: Reversing post order to oldest first?

Post by paulnicholson »

I can almost guarantee that 100% of my users would not have changed their settings. Only nerds do that. My members are just regular people.

Return to “[3.0.x] Support Forum”