As most know, Mandrill is changing and I'm no longer want to use it.
The problem: there was an option to automatically unsubscribe from getting emails. This blacklist is on Mandrillapp, not at Xenforo.
So if I turn now to another provider (or just default Xenforo system), those users who asked for subscription will get emails from me again.
I was able to export the blacklist. So now I have around 14k emails of registered users who don't want to get emails from me (this include invalid emails and unsubscribed accounts).
So I looked for a way to remove these emails from getting emails from Xenforo.
a) Turn all these users to 0 at receive_admin_email; email_on_conversation; default_watch_state at xf_user_option table
b) Turn all these users to 0 at email_subscribe at xf_thread_watch table.
c) Turn all these users to 0 at send_email at xf_forum_watch table.
d) Don't know if any other columns should be changed or if just with one of them is enough.
I found some queries by @Jake Bunce (here and here):
UPDATE xf_user_option SET default_watch_state = 'watch_no_email' WHERE default_watch_state = ''
UPDATE xf_thread_watch SET email_subscribe = 0;
UPDATE xf_forum_watch SET send_email = 0;
I know that an option like "WHERE user_id IN (123,456,789)" can be used. But I hope there's a smarter way to unsubscribe them. An automatic way to get user ID based on email account?
I also checked a plugin like this: https://xenforo.com/community/resources/e-mail-address-restrictions.5001/
But probably most of these users just want to avoid getting new emails but still want to participate in the forum.
Thanks for your help!
PS: hope I explained myself correctly... just don't want to send emails to these people who asked for getting no emails.