Auto Subscribe users to New Content & new comments to their own Posts.

Notify module is a powerful way to subscribe users to periodic emails which include all new or revised content and/or comments much like the daily news letters sent by some websites. Even if this feature is not configured for normal site users, it can be a useful feature for an administrator of a site to monitor new content submissions and comment posts.

Problem
Users have to enable this from the "my account" page and many novoice users dont know how to do this or are not aware of this feature, which reduces the return visits to site.

There is a need to auto enable the notification to users when a new user registers. Users can disable this option later.

Solution
On your Admin->Settings->notify set the frequency of the updates, like weekly, bi-weekly, monthly etc. Emails will be sent out only if your cron is working.

1. This solution will work only for MySQL 5 users. Add a Trigger on your drupal database


CREATE TRIGGER `trg1` AFTER INSERT ON users
FOR EACH
ROW
update notify set status= where uid=new.id

2. For Non-MySQL 5 users, the solution has to be setup using Drupal's contributed "Action" module. Basically the above update statement has to be added upon the "Event" user Registration.
I am not sure of how to implement this. Users of this site are welcome to post solution if they know.

How-To: