MyBB Community Forums

Hello

I'd like to find a solution to move/copy all members of a group to place in the registered users group (in the past I do the error to remove the members of this group because I thought that there was duplication)

Via a sql query can be? (If yes which?)

Thank you

UPDATE PREFIX_users SET `usergroup` = 'NEW_USERGROUP' WHERE `OLD_USERGROUP` = 'OLD_USERGROUP_NUMBER'

so for my forum it would be

UPDATE `mybb`.`mybb_users` SET `usergroup` = '2' WHERE `mybb_users`.`usergroup` = 1;

thank you very much

No problem.