MyBB Community Forums

Full Version: Display Group
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Is there any SQL query to set all users display groups to Use Primary Group?
update mybb_users set displaygroup =concat(usergroup);

(2011-07-21, 11:21 AM)Malcolm. Wrote: [ -> ]
update mybb_users set displaygroup =concat(usergroup);

This set the group to what they are in. I want the Display Group to be Use Primary Group.

EDIT: adapted that to this:

Quote:update users set displaygroup = 0;
(2011-07-21, 11:28 AM)bubka3 Wrote: [ -> ]This set the group to what they are in. I want the Display Group to be Use Primary Group.

Oops, sorry about that. Misread the thread. Blush