XF 1.4 Change members to Bounced with SQL query

[Andy.N]

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

 

[Paul B]

You could create a small script which would loop through the array of email addresses, setting the state to 'bounced'.

 

[Andy.N]

You could create a small script which would loop through the array of email addresses, setting the state to 'bounced'.

Is there a simple sql query where I can try to apply this to a couple of email address at once?
Tks

 

[Andy.N]

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

 

[Andy.N]

The answer was here before
https://xenforo.com/community/threads/user-state-bounced-emails.85729/

 

[Andy.N]

update `xf_user`
set user_state = 'email_bounce'
where email IN ('email1@domain.com', 'email2@domain.com')

 

[foiovitor]

update `xf_user`
set user_state = 'email_bounce'
where email IN ('email1@domain.com', 'email2@domain.com')

Perfect, thanks!