Mass moving users to another usergroup sql query?
 

Hello guys, I'd like to ask about sql query to massive move all users from a usergroup (ex Group A) to another usergroup (Group B). :confused:

Thank you all.

You could change the primary user group with this query:

(you need to add your table prefix to 'user' if you have one).

But changing the group might result in a change in user title or rank (which I think you can do by running "update user titles and ranks" in the "update counters" section of the Maintenance menu).


Another option might be to add a promotion from group A to group B and set the conditions so everyone qualifies (such as strategy "Posts" and 0 Posts), then run the "User Promotions" scheduled task (run it manually by pressing "Run Now" - if you wait for it to run itself it will only promote users who have been active recently).

you can use Vbulletin Prune/Move Users to move user.

or

SQL QUERY

In place of GroupB_ID -> enter groupb usergroupid.
In place of GroupA_ID -> enter groupa usergroupid.


oops - i m late..

But I didn't realize you could do it with "Prune/Move Users" - that sounds like the right way to go.

Thank you guys :) Both of posts are helpful for me.