Moving users from a custom style to default?

[TutorialForums]

Hi -

I have overwritten my "original" default style with one that before was a custom style.... now I'd like to migrate all the users of the custom style over to the default one (and then delete the empty custom one) but I'm not quite sure how.

If I delete the custom style, will that revert all those members to the default? Or do I need to run a database query to switch them? Here's the query I was thinking of (I'm pretty new at this kind of thing though)...

UPDATE user SET styleid=1 WHERE styleid=6

Is that right? If so how to I actually execute it on the server? (I have a dedicated server).

Thanks, your help is appreciated

[Mntsnow]

bump^^

UPDATE user SET styleid=1 WHERE styleid=6

This would be correct correct? because I'm wanting to change it to be

UPDATE user SET styleid=16 WHERE styleid=1

Thanks in advance for confirming if this is correct

[Mntsnow]

UPDATE user SET styleid=16 WHERE styleid=1

is correct.

as it was confirmed for me in this thread. http://www.vbulletin.com/forum/showt...?postid=397262