MyBB Community Forums

I have 41,181 members in a group I'd like to move to another group. Is there a quick way to do this?

a sql query should do...

Try...

UPDATE mybb_users SET usergroup=newgid WHERE usergroup=oldgid

where "newgid" is the gid of the group to which they have to be moved and "oldgid" is the gid of their current group... that will move the entire group into the new group..

Thanks! That worked amazingly!

However interestingly I now have one usergroup that has double the amount of members that's registered on my site. It's interesting.

Thanks that script did exactly what I wanted