phpBB.com

Posted: **Mon Jul 30, 2007 1:29 pm**

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?

Posted: **Mon Jul 30, 2007 7:16 pm**

Posted: **Mon Jul 30, 2007 7:32 pm**

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.

Posted: **Mon Jul 30, 2007 7:55 pm**

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.

Posted: **Mon Jul 30, 2007 8:08 pm**

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.

Posted: **Tue Jul 31, 2007 9:58 am**

Thanks David, I will try that.

phpBB.com

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

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

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

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

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

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

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