Vincent Well-known member May 27, 2011 #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
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
Paul B XenForo moderator Staff member May 27, 2011 #2 Do you mean update all users to use style with an ID of 23? UPDATE xf_user SET style_id = 23 Upvote 0 Downvote
DSF Well-known member May 27, 2011 #3 Use as follow ... Code: UPDATE xf_user SET style_id = '23' Upvote 0 Downvote
Vincent Well-known member May 27, 2011 #4 Brogan said: Do you mean update all users to use style with an ID of 23? UPDATE xf_user SET style_id = 23 Click to expand... Thanks Brogan, you're the best Upvote 0 Downvote
Brogan said: Do you mean update all users to use style with an ID of 23? UPDATE xf_user SET style_id = 23 Click to expand... Thanks Brogan, you're the best
Jake Bunce Well-known member May 27, 2011 #5 You can force a skin by setting it to default: Admin CP -> Appearance -> Styles Then disable the other styles: Admin CP -> Appearance -> Styles -> [click a style] Or here is the query: Code: UPDATE xf_user SET style_id = 23 edit - epic ninja Upvote 0 Downvote
You can force a skin by setting it to default: Admin CP -> Appearance -> Styles Then disable the other styles: Admin CP -> Appearance -> Styles -> [click a style] Or here is the query: Code: UPDATE xf_user SET style_id = 23 edit - epic ninja
Vincent Well-known member May 27, 2011 #6 DSF said: Use as follow ... Code: UPDATE xf_user SET style_id = '23' Click to expand... You're the best too but later Upvote 0 Downvote
DSF said: Use as follow ... Code: UPDATE xf_user SET style_id = '23' Click to expand... You're the best too but later
Vincent Well-known member May 27, 2011 #7 Jake Bunce said: You can force a skin by setting it to default: Admin CP -> Appearance -> Styles View attachment 15454 Then disable the other styles: Admin CP -> Appearance -> Styles -> [click a style] View attachment 15455 Or here is the query: Code: UPDATE xf_user SET style_id = 23 edit - epic ninja Click to expand... I know, but I just wanted to be sure Upvote 0 Downvote
Jake Bunce said: You can force a skin by setting it to default: Admin CP -> Appearance -> Styles View attachment 15454 Then disable the other styles: Admin CP -> Appearance -> Styles -> [click a style] View attachment 15455 Or here is the query: Code: UPDATE xf_user SET style_id = 23 edit - epic ninja Click to expand... I know, but I just wanted to be sure