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.
 
Top