Some of my users are on "Account not Activated"
How can i change there usergroup all at once to "Registered User"?
are you really need this?
beware for "fake" email on registration.
for many subscribers thread, it will make trouble in the future mail (hosting)
Users are placed in this group until their email address has been verified or an admin has activated them.
You can go ACP > Configuration > User Registration and Profile Options and set Registration Method to instant activation if you don't want users to have to verify their email or be administrator activated.
I will be deleting the fake accounts manually...
and I also know how to do it manually... but i want change the usergroup of all users all at once...
UPDATE `mybb_users` SET `usergroup` = '2' WHERE `usergroup` = '5';
TRUNCATE `mybb_awaitingactivation`;