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


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? :)


XenForo moderator
Staff member
Do you mean update all users to use style with an ID of 23?

UPDATE xf_user SET style_id = 23

Jake Bunce

XenForo moderator
Staff member
You can force a skin by setting it to default:

Admin CP -> Appearance -> Styles

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

Then disable the other styles:

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

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

Or here is the query:

UPDATE xf_user
SET style_id = 23
edit - epic ninja :eek: