XF 1.4 Change members to Bounced with SQL query

Andy.N

Well-known member
#1
Suppose I have a large list of bounced email addresses from my newsletter provider, and those are registered members on my forum.
I'd like to use that CSV file and run a SQL query on the XF data to mass change every member to Bounced state.

The CSV file will contain a couple of thousand email addresses.

What would be the most efficient way to do this?
Tks
 

Brogan

XenForo moderator
Staff member
#2
You could create a small script which would loop through the array of email addresses, setting the state to 'bounced'.
 

Andy.N

Well-known member
#4
You could create a small script which would loop through the array of email addresses, setting the state to 'bounced'.
If I want to change one account with a specific email address, which field and table in database I need to change?
Many thanks
 
Top