MySQL Query to set everyone's skin to a skin with id 23

Vincent

Well-known member
Hello all,

I've seen before that with a MySQL query you could update everyone's Style to someone with e.g. ID 23.

What exactly is this query? :)
TIA
 
You can force a skin by setting it to default:

Admin CP -> Appearance -> Styles

Screen shot 2011-05-27 at 10.02.21 AM.webp

Then disable the other styles:

Admin CP -> Appearance -> Styles -> [click a style]

Screen shot 2011-05-27 at 10.02.11 AM.webp

Or here is the query:

Code:
UPDATE xf_user
SET style_id = 23

edit - epic ninja :o
 
Top Bottom