Switch which default style, retain member choice?

[TutorialForums]

Hi -

I'm trying to change one of my secondary styles to become my Default style.... well doing that alone of course is very simple... but I want to have it so that members will retain their style selection (i.e. those who were using the "original" default style will still use it, those who were using the secondary-now-default style will still use that). When I change the style as is, now all those who used the original are using the new, and all those who were using the new are using the original.

Actually I ran into another problem as well while messing with this - now if I upload either of the styles, trying to return things to how they were before, it changes BOTH to the same style, no matter what.

Anyhow - hoping someone can help. Worst case I guess I can reset everyone to use the new Default, and let them re-select the style of their choice....

Thanks!

[g-force2k2]

first find out what style id the defualt and the new one both are... and remember them!

in this instance XX will represent the default style id and YY will repesent the new style id

then run this query: (changes to an non existance so the switch can be preformed)

UPDATE user SET styleid=0 WHERE styleid=XX AND userid != 0

then run this: (update the YY users style to XX users style)

UPDATE user SET styleid=XX WHERE styleid=YY AND userid !=0

finally run this query: (updates the XX users style to YY users styl)

UPDATE user SET styleid=YY WHERE styleid=0 AND userid != 0

hope that helps... regards...

g-force2k2

[Katman]

I did this and it worked, problem is it made EVERYONE's default style the new style. But I suppose they can change it back if they want.

But at the same time visitors still see the old style, it did not change the default style for guests/visitors to the new style.

Any ideas on how to do that?