MyBB Community Forums

MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 General Support > Need a query to move some user to another group
Full Version: Need a query to move some user to another group
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

CivilEA

2012-02-27, 05:00 PM
Hi;

I need to generate a query to run it in PHPMyadmin and move all user inside group 10 and have less than 3 post to group 11.

can anyone help me?

Huh
is it true?
UPDATE `mybb_users` SET `usergroup`=11 where `usergroup`=10 and `postnum`<3

Alan S.

2012-02-27, 07:40 PM
UPDATE `mybb_users` SET `usergroup` = '11' WHERE `usergroup` = '10' AND `postnum` < '3';
MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 General Support > Need a query to move some user to another group