What about storing the subscription info in the comment_info table. You could store a boolean "subscribed" attribute.
Then whenever a new comment is posted on a post, parse through all the commenters on that post, then email all those who have the "subscribed" attribute turned on. I've been thinking about writing a plugin like this for a while, but I want to get the Email stuff nailed down so it is standardized. On Jan 11, 2009, at 11:55 PM, Steve Love wrote: > > Hi, everyone. I started using Habari about a week ago (loving it) and > saw the need for a "Subscribe to Comments" plugin, so I'm giving it a > shot. (If one already exists I'd love to know!) > > I've got an alpha release that seems to work well and would love to > have some adventurous souls test it out (or just look over the code). > Just to be on the safe side, you may not want to use this on a > production environment. You can download it here: > http://stevelove.org/projects/plugins/subscribe-to-comments/ > > There's a readme file included that talks about usage. > > Here's what I particularly would like help with: > 1. I'm currently using inline SQL where I know I should be using > something like Posts::get(array('info' => array('blah')). I just can't > seem to get it to work, perhaps because of the next item. > > 2. I originally wanted to add a new column to the comments table > during activation. Couldn't get that to work, so I changed gears and > now I'm adding entries to the postinfo table, but I'm not really happy > about the way this is done. Since the name column is unique, I use it > to store the subscriber's email address and set the value column to > "SUBSCRIBE". Is that why I can't grab subscribers with > Posts::get(array > ('info' => array('value' => 'SUBSCRIBE', 'post_id' => $comment- >> post_id))) ? > > 3. There is no way to unsubscribe. Anyone have suggestions for > implementing this? > > 4. Any other comments or pointers would be helpful. :) > > Thanks in advance, > Steve > > > --~--~---------~--~----~------------~-------~--~----~ To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/habari-dev -~----------~----~----~----~------~----~------~--~---
