MyBB Community Forums

Full Version: How do I set mass primary user group?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Can someone assist me in a sql command that will allow me to set all users to there primary usergroup display? I hope this makes sense. I have some people i9n a user group called "very Important Person" and there titles show otherwise. I want to set them all at once to use and display there primary user group which is as noted above.
To clarify, I need to know how to set the display group to the primary group for all members of a group. A sql command I Could run.
Any assistance would be greatly appreciated. Smile
UPDATE mybb_users SET displaygroup=0
HI Dennis, What I need is to set a specific group to show as a display group. That would make all one display group from what I am reading?
Sorry I misunderstood your request Toungue

If you want to change the display group for a group of users to their primary usergroup, you would use:
UPDATE mybb_users SET displaygroup=0 WHERE usergroup=X
X is their usergroup ID (you can find this in mybb_usergroups)
Thank you very much Dennis.