1. 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

Discussion in 'XenForo Questions and Support' started by Vincent, May 27, 2011.

  1. Vincent

    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? :)
  2. Brogan

    Brogan 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
  3. DSF

    DSF Well-Known Member

    Use as follow ...
    UPDATE xf_user SET style_id = '23'
  4. Vincent

    Vincent Well-Known Member

    Thanks Brogan, you're the best :)
  5. Jake Bunce

    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:
  6. Vincent

    Vincent Well-Known Member

    You're the best too but later ;)
  7. Vincent

    Vincent Well-Known Member

    I know, but I just wanted to be sure ;)

Share This Page