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

BigBlockMopar · Post by **BigBlockMopar** » 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?

BigBlockMopar · Post by **BigBlockMopar** » Mon Jul 30, 2007 7:16 pm

poultrygarden · Post by **poultrygarden** » 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.

Post by **Brf** » 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.

david63 · Post by **david63** » 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.

BigBlockMopar · Post by **BigBlockMopar** » Tue Jul 31, 2007 9:58 am

Thanks David, I will try that.

advertisements