MyBB Community Forums

Full Version: DB Query help - Mass Move Users
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi there! Can anyone help me find some queries so I can do the following?
  1. Move anyone with 15 posts or more in group ID 4 to group ID 44. Primary group only and display. - Promotions doesn't move past 5120 people. 
  2. Remove group 4 from anyone's additional/secondary group
  3. Recount User Statistics in Member Groups, as we seem to have a ghost "40,000" members if at all possible. 
1 UPDATE xxx_users SET usergroup = 44, displaygroup = 0 WHERE postnum > 14

2 UPDATE xxx_users SET additionalgroups = '' WHERE additionalgroups = '4'
but it will not work for thous who have more than 1 additional group. It is trickier. I'd do it with simple php script.

3 If it is cached, it should recount every time you add/remove user