Bulk update only certain users

[Gregg Lengling]

I have a forum with over 25k members but now have a dedicated section for those that are paying for support. At this time I need to update 2400 members for access to those limited forums. Is there way to run a script pulling the registration email address associated with their registration to add the flag to the additional User Group I created for them???

[kh99]

I'm not quite sure what you're asking: is it that you have a list of email addresses, and you want to move those users to a different group? Is it a new main user group or an additional group?

[Gregg Lengling]

Yes I have set up an additional group that has privs for the new area, and I have a spread sheet that I can pull either user names or email addresses from . I want to find a way to enable that additional group for all these users without having to do them 1 at a time.

[kh99]

Well, I don't know of any way to do it with vbulletin. But if you imported your data into a table in the same database as vbulletin, then I'm pretty sure it could be done with sql. The membergroupid field in the user table is a comma separated list of ids, so it would take a bit of work there (I guess you'd need to add a comma or not depending on whether the user already has any additional member groups). Also if adding the group would affect the user's display group or ranks, then there's other updating that needs to be done to have everything consistent (if not, then I think just setting the field should be OK).