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

XF 1.4 SQL query to change user state based on bounced emails ?

Brogan

XenForo moderator
Staff member
#2
There is no way of identifying records in the user table with 'bad' email addresses so it would require a script to loop through the list.

However, the system will automatically set the accounts to 'Email invalid (bounced)'.
 

king8084

Active member
#3
There is no way of identifying records in the user table with 'bad' email addresses so it would require a script to loop through the list.

However, the system will automatically set the accounts to 'Email invalid (bounced)'.
i already know the 2000 emails...i have a record of them...i want a way to say "set user X with email Y to bounced"
 

Brogan

XenForo moderator
Staff member
#4
The basic query syntax is:
Code:
UPDATE xf_user SET user_state = 'email_bounce' WHERE email = 'example@example.com';
You would have to run that query for each email address.

Take a backup first before doing any direct changes to the database.