Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved Mass move groups 42,181 members
#1
Not Solved
I have 41,181 members in a group I'd like to move to another group. Is there a quick way to do this?
Reply
#2
Not Solved
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..
We can't help everyone, but everyone can help someone - Ronald Reagan
Did you know? Your question has already been answered. But you haven't seen it yet.
Don’t  Forget to “Mark as Solved” after the fix
Reply
#3
Not Solved
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 Smile
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)