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

[king8084]

i have a list of almost 2000 bad emails, what query can i run to change them all to bounced ?

 

[Paul B]

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]

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"

 

[Paul B]

The basic query syntax is:

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.

 

[rosal]

And a query to run to old provider email.

example "@tjol.com"

I need a query to put all the users have that email provider "@tjol.com" to "email invalid bounced" is possible?

*Sorry is to xenforo 2.2

 

[dougdirac]

The basic query syntax is:

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.

Is this query still valid on XF 2.2?

 

[dougdirac]

And a query to run to old provider email.

example "@tjol.com"

I need a query to put all the users have that email provider "@tjol.com" to "email invalid bounced" is possible?

*Sorry is to xenforo 2.2

Assuming the previous query is still valid, you should be able to do

UPDATE xf_user SET user_state = 'email_bounce' WHERE email LIKE '%@tjol.com';

I'd test it on a backup first.