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'
Code: Select all
UPDATE phpbb_users SET user_post_sortby_dir = 'd' WHERE 1 ;
"Hundreds" ? Don't, you will regret it.paulnicholson wrote:I've got hundreds of MODs to do.
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.Furthermore, all MODs that have been confirmed to work should be included upon installation of this software.
No it wouldn't.It'd be easy for the developers to incorporate, I'll bet.
Thanks. This worked. How do I UNDO this please?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:
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
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'
Code: Select all
UPDATE phpbb_users SET user_post_sortby_dir = 'd' WHERE 1 ;
Undo what?paulnicholson wrote:Thanks. This worked. How do I UNDO this please?
The order forums are listed in is totally manual. Use the forum management tab in the ACP to move them up or down.Also, how do I specify forums to be reordered?
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'.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.
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 ;
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.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.
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.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'.