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
|