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

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: