XF 1.4 User State / Bounced Emails

[PrettyPixels]

Hello,

I have a large list of email addresses for users that I'd like to mark as "bounced" within xenForo.

Will it work to run a MySQL query to change the user_state to email_bounce within the xf_user table for those users? Or are there other areas of the site/database where this needs to be changed as well?

I appreciate any information you can offer.

 

[Paul B]

I haven't checked but that should work.

 

[PrettyPixels]

Great! Thank you, Brogan.

 

[foiovitor]

Hello,

I have a large list of email addresses for users that I'd like to mark as "bounced" within xenForo.

Will it work to run a MySQL query to change the user_state to email_bounce within the xf_user table for those users? Or are there other areas of the site/database where this needs to be changed as well?

I appreciate any information you can offer.

Can you share that MySQL query? Because I have a list like yours but I'm not an expert in SQL querys... my list are in .csv format but with notepad++ I can play with it.

 

[Andy.N]

Can you share that MySQL query? Because I have a list like yours but I'm not an expert in SQL querys... my list are in .csv format but with notepad++ I can play with it.

https://xenforo.com/community/threads/change-members-to-bounced-with-sql-query.89816/#post-887864