XF 2.1 list bounced email change user status sql

Biarritz64

Active member
Hi
i have a list of bounced email, i want to change this user's status to email_invalid_bounced

is it possible to do it via sql like
if user email = emailfromlist then change status to email_invalid_bounced

Thank you for your help
 
i test it and it return this error
Unknown column 'email_invalid_bounced'
even when i change email_invalid_bounced by email_confirm_edit
it return Unknown column 'email_confirm_edit'
 
this will set user with invalid email with the status "email_confirm_edit". they will have to re comfirm and probably change email.

email, email1, and email2 is an example, just add your list of bounced email.

I imported my list from mailgun bouced tab.

i just change 1500 usesr and it workes perfectly
 
Top Bottom