pequeno Posted December 8, 2018 Share Posted December 8, 2018 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. Link to comment Share on other sites More sharing options...
Bluto Posted December 9, 2018 Share Posted December 9, 2018 There is a plugin called Outdate Emails which will do what you're asking - besides the 6 months thingy. Plugin works well. Link to comment Share on other sites More sharing options...
bfarber Posted December 10, 2018 Share Posted December 10, 2018 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 Link to comment Share on other sites More sharing options...
Faqole Posted December 10, 2018 Share Posted December 10, 2018 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. Link to comment Share on other sites More sharing options...
pequeno Posted December 10, 2018 Author Share Posted December 10, 2018 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. Link to comment Share on other sites More sharing options...
pequeno Posted December 11, 2018 Author Share Posted December 11, 2018 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. Link to comment Share on other sites More sharing options...
pequeno Posted December 14, 2018 Author Share Posted December 14, 2018 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.