[Plugin: Gurken Subscribe to Comments] Trying to reduce emails being sent

Hello,

Thank you for your email. I think I have to disappoint you. I looked at the code and I don’t think that there is a possibility to separate the comments subscribed by the original version and my fork. I kept the changes to a minimum.

But it shouldn’t be a problem to do a bulk unsubscribe. But you have to do it with a (simple) sql query.

With the following query you will see a list of all subscribed comments:
select * from wp_comments where comment_subscribe = ‘Y’

Comments for the last 3 days:
select * from wp_comments where comment_subscribe = ‘Y’ and DATE_SUB(CURDATE(), INTERVAL 3 DAY) <= comment_date_gmt

Comments for the last 3 months:
select * from wp_comments where comment_subscribe = ‘Y’ and DATE_SUB(CURDATE(), INTERVAL 3 MONTH) <= comment_date_gmt

Bulk unsubscribe:
Update wp_comments set comment_subscribe = ‘N’ where comment_subscribe = ‘Y’ and DATE_SUB(CURDATE(), INTERVAL 3 DAY) <= comment_date_gmt

And be careful: I haven’t tested the queries, as usual do a backup first!

Sorry if I underestimated your sql skills, but maybe this is useful for others.

Greetings,
Martin

Hey there, you may want to try this new version at

https://www.ads-software.com/extend/plugins/subscribe-to-comments-reloaded/

where you can easily manage subscriptions and suspend/delete subscribers as you like!

Camu

Before installing camu’s plugin as a replacement for Gurken Subscribe to Comments, you might want to read carefully this Subscribe to Comments Reloaded discussion.

I’ve been using this plugin for three months now, and I have had zero problems. It didn’t work with my template at first, I must admit it, but Camu was very responsive and his support is excellent! Gurken and Mark haven’t replied to their requests in months ??

Carmen

Camu, frankly carmela79 above (and Beatrice54 here and dieglo here) look like sock puppets with zero user history before making their quick comments.

If you think there has been any impropriety in voting I suggest you have www.ads-software.com check the logs for voting on your plugin.

At Foliovision, we have neither the time nor the inclination to tamper with plugin voting. You should be more careful before making wild accusations like this.

Alec Kinnear
Creative Director
Foliovision.com

Hi Alec,

Beatrice already explained what happened, please don’t call us puppets, that’s not nice ??

https://www.ads-software.com/support/topic/plugin-gurken-subscribe-to-comments-migrate-from-mark-jaquiths-plugin?replies=11#post-2086483

Dylan.

Great, sock puppets. Thanks for signing up just to post the WP community the words camu put in your mouth.