Renada Active member Feb 25, 2011 #1 Hi all, Is there a way I can reset all users message counts to zero? I've imported my user groups and users but that's all I want to keep - I'm starting in a new direction with the forum. Is there a query I can run to do this? Regards, Renada
Hi all, Is there a way I can reset all users message counts to zero? I've imported my user groups and users but that's all I want to keep - I'm starting in a new direction with the forum. Is there a query I can run to do this? Regards, Renada
Paul B XenForo moderator Staff member Feb 25, 2011 #2 UPDATE xf_user SET message_count = 0 Take a backup first though, just in case. Upvote 0 Downvote
Renada Active member Feb 25, 2011 #3 Brogan said: UPDATE xf_user SET message_count = 0 Take a backup first though, just in case. Click to expand... Worked like a charm Brogan, thank you p.s. and thank you for the lightning speed reply Upvote 0 Downvote
Brogan said: UPDATE xf_user SET message_count = 0 Take a backup first though, just in case. Click to expand... Worked like a charm Brogan, thank you p.s. and thank you for the lightning speed reply
Paul B XenForo moderator Staff member Feb 25, 2011 #4 For reference, you can actually adjust message count, likes and trophy points in the ACP for each user. I presumed you wouldn't want to do each one individually though Upvote 0 Downvote
For reference, you can actually adjust message count, likes and trophy points in the ACP for each user. I presumed you wouldn't want to do each one individually though
Renada Active member Feb 25, 2011 #5 Brogan said: For reference, you can actually adjust message count, likes and trophy points in the ACP for each user. I presumed you wouldn't want to do each one individually though Click to expand... Thanks for that Brogan. This time I wanted to wipe everything as I'm starting my users off from scratch but that's useful to know. What about Avatars? Can I batch upload a complete set for people to choose from? I didn't see that option anywhere. Regards, Renada Upvote 0 Downvote
Brogan said: For reference, you can actually adjust message count, likes and trophy points in the ACP for each user. I presumed you wouldn't want to do each one individually though Click to expand... Thanks for that Brogan. This time I wanted to wipe everything as I'm starting my users off from scratch but that's useful to know. What about Avatars? Can I batch upload a complete set for people to choose from? I didn't see that option anywhere. Regards, Renada
Paul B XenForo moderator Staff member Feb 25, 2011 #6 There is no option for an avatar gallery. Upvote 0 Downvote
Renada Active member Feb 25, 2011 #7 Brogan said: There is no option for an avatar gallery. Click to expand... Oh Upvote 0 Downvote