Forum Delete Bulk Accounts by E-mail
 

Hi, in the link is a post showing someone what the code is that does the query. I've figured out how to get the email list but I don't know where to implement it.

____________
https://www.vbulletin.com/forum/show...=1#post1703882

"Taking your problem specifically: to handle a large number of bouncing emails, assuming you have a nice clean list of email addresses in a text file, a simple (though potentially slow and load-inducing) query would be:

Note: This is an incomplete query to demonstrate the method.
Adjust and try it at your own risk, and only once you actually understanding what it does __________________________ UPDATE prefix_user SET usergroupid=newgroupid WHERE usergroupid = 2 AND email IN ( '[email protected]', '[email protected]', ... email list ..."