query to move 20,000 members to temp usergroup based upon userid

[Antivirus]

Is the following manual query safe to run to move a large amount of users to a different primary usergroup based upon their userid?


UPDATE user
SET usergroupid = 34
WHERE userid < 24509


Just want to make sure nothing is missed (settings / data in other tables) when doing such thing through CP
Thanks!

[Cars2007]

Back up your forums first.

I did something like this the other week and it worked just fine.

[Antivirus]

already backed up[, just want to make sure the usergroupid doesn't need to be handled elsewhere. for instance, such as displaygroupid, user title, etc...

[Dismounted]

If you're using the default user title ladder, the usertitle field should be fine.

[Marco van Herwaarden]

:eek:
I hope that you know what you are doing, as the example you provided would move ALL users with a userid smaller then 24509 (including an admin with id = 1 for example???) to this new usergroup.

[Paul M]

You should update the displaygroupid as well (if it's not '0' and is equal to their existing primary group).

[Antivirus]

:eek:
I hope that you know what you are doing, as the example you provided would move ALL users with a userid smaller then 24509 (including an admin with id = 1 for example???) to this new usergroup.

Naturally, actually the query would be as follows:

UPDATE user
SET usergroupid = 34
WHERE userid < 24509
AND usergroupid = 2


You should update the displaygroupid as well (if it's not '0' and is equal to their existing primary group).
Ok, thanks that's what i was wondering, if there were any other values that should be updated in tandem.

Thanks to both of you :)