Changing forum-style for all users, but not by 'override'...

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Suggested Hosts
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
BigBlockMopar
Registered User
Posts: 90
Joined: Tue Mar 08, 2005 3:15 pm

Changing forum-style for all users, but not by 'override'...

Post by BigBlockMopar »

I'm running a forum with 2 active styles, subSilver2 and ProGlass.

At first I only had the subSilver2-style, so all the 400+ users have this style as default.
I've now got ProGlass-installed aswell and want to change everybody over to this style, BUT... I still would like them to be able to switch back to subSilver2 if they want soo. So using the "override user style"-setting can not be used for this.

How can I make this happen?
Changing the user-settings in the database directly with phpMyAdmin perhaps?
Which SQL-codeline could I use for this?
Signatures are overrated...
BigBlockMopar
Registered User
Posts: 90
Joined: Tue Mar 08, 2005 3:15 pm

Re: Changing forum-style for all users, but not by 'override'...

Post by BigBlockMopar »

:?
Signatures are overrated...
poultrygarden
Registered User
Posts: 122
Joined: Tue Jul 25, 2006 10:10 pm

Re: Changing forum-style for all users, but not by 'override'...

Post by poultrygarden »

Once the default has been changed to your preference for the board, individual users can alter their own default in their own user control panels, under 'board preferences' tab.

I have Prosilver and Subsilver2 installed, as well as Green2 (which is the default) and all users can alter their own.
User avatar
Brf
Support Team Member
Support Team Member
Posts: 52227
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Changing forum-style for all users, but not by 'override'...

Post by Brf »

Changing the board default only changes it for guests or new users. BigBlockMopar wants to change it for existing users too, without forcing them to keep that style.
User avatar
david63
Registered User
Posts: 18841
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Contact:

Re: Changing forum-style for all users, but not by 'override'...

Post by david63 »

Try running this in phpMyAdmin (after you have made a backup of the users table)

Code: Select all

UPDATE `phpbb_users` SET `user_style` = '9';
replace the 9 with the value for the style that you want.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored
BigBlockMopar
Registered User
Posts: 90
Joined: Tue Mar 08, 2005 3:15 pm

Re: Changing forum-style for all users, but not by 'override'...

Post by BigBlockMopar »

Thanks David, I will try that.
Signatures are overrated...
Locked

Return to “[3.0.x] Support Forum”