• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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

Vincent

Well-known member
#1
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
 

Jake Bunce

XenForo moderator
Staff member
#5
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:

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