Unsubscribe a group of users.

[pequeno]

Hello, I want to unsubscribe* users who have not accessed in the last 6 months. I suppose that through a query in the database it can be done. Somebody could help me?

* Stop receiving any automatic email from the forum.

why? to stop receiving “bounces” of the emails sent, because the recipient no longer exists.

Many thanks.

[Bluto]

There is a plugin called Outdate Emails which will do what you're asking - besides the 6 months thingy.  Plugin works well.

 

[bfarber]

Yes of course it could be done with a query...but we do not recommend running manual database queries on your database unless you absolutely know what you are doing.

The relevant information would be contained in core_members:

• allow_admin_mails: general "send me news and updates" flag
• last_activity: timestamp of the user's last recorded activity

[Faqole]

On 12/8/2018 at 10:56 PM, pequeno said:

Hello, I want to unsubscribe* users who have not accessed in the last 6 months. I suppose that through a query in the database it can be done. Somebody could help me?

* Stop receiving any automatic email from the forum.

why? to stop receiving “bounces” of the emails sent, because the recipient no longer exists.

Many thanks.

This will be best handled as a custom plugin imo rather than running a sql query.

 

[pequeno]

Thank you for your help.

What measures do you take with the bounced mails? I use Amazon SES mail service, and they are very restrictive with the bounced mails.

The first thing I do when I receive a bounced mail notification is to unsubscribe the user to the forum emails.

 

[pequeno]

This is a good plugin for bounced mails

But doesn´t work with Amazon SES 

I think that this functionality it should be integrated into forum system.

[pequeno]

Hello, actually I ban members that not update your email.

One question. Banned users receive emails from forum subscriptions, or I need to edit their profile?

Thanks.