What's the best way to switch all members from Style A to Style B?

[alkatraz]

My members are all using the default style, lets call it Style A.

I've been developing a new facelift for the forums as a seperate style/template/replacement set, lets call it Style B

Whats the best way to switch everyone over from Style A to Style B?

Thanks!

[Dean C]

Switch the templates and replacement sets round on the styles

[SiXXGuNNZ]

Originally posted by Mist
run this query:

[sql]
UPDATE user SET styleid=x
[/sql]

where "x" is the styleid of the style your want to be assigned to all the users...

__________

*waits for the you need to go here to be a fully licensed member thingy from a mod lol*

- miSt

[alkatraz]

thx for the help!

With that SQL query, can I do that from the main page of MyPHPAdmin or do I need to be in a certain table?

[alkatraz]

That worked great! I changed all my users to style 4, except you still see style 1 when you aren't logged in. How do I set visitors to style 4? I looked all over the place!!

[Dean C]

I still think the easiest thing to do is swap your templates and replacements around and then run that query to set everyone's style to defaul (with the new template and replacement set)

[SiXXGuNNZ]

default is the logged out style

[alkatraz]

doh Okay thx

So if I were to download the style and then re-upload it (via the Style DL/UL) and overwrite Default that will work, or do I have to manualy go in and copy and paste the contents of all my templates?

Thx so much for your help guys!

[Dean C]

That would work yes...

d/l'ng the style and overwriting default...

- miSt

[Herman]

Yea that would work good, though, then you'd have to run the query so that it's style ID 1