• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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