After importing from vBulletin I want to move a large number of members from user group 9 to user group 2. What query would I run to do this? Thanks
UPDATE xf_user SET user_group_id = 2 WHERE user_group_id = 9
You really shouldn't be moving anyone out of the default primary usergroup which is Registered.I hate to bump this thread being it's old, but would mass moving primary usergroups affect secondary usergroups?
http://xenforo.com/help/user-groups/There is no distinction between primary and secondary user groups.
It is recommended however that all users have the Registered user group set as their primary user group and any additional groups they are members of are set as secondary groups. This makes it easy to manage permissions due to the cumulative nature in which they are applied.
I really want to wait for 1.1Well you can install the add-on from Darkimmortal, or you can wait for 1.1 which has user group promotion.
Even then, all you need to do is change the settings for the registered group to be moderated, and have the promoted secondary group as the one which allows posting.