Thanks Robert... Your idea was kind of whereI was leaning. As for the RSS feed... the forums already have that, but very few people actually use them. It seesm they would rather check a box then deal with readers.
_____ From: Robert Shubert [mailto:[email protected]] Sent: Tuesday, June 30, 2009 10:28 AM To: [email protected] Subject: RE: Witango-Talk: OT... sort of - Topic Notification for Forum You need a subscriptions table of sorts: which contains just the member_id and the master_thread_id You can add rows when people signup to get a thread emailed and remove them when they opt-out. Additional columns that come to mind are: Primary key ID (not completely necessary for this type of table, but always helpful) Active/Inactive flag so that you can turn subscriptions on and off (as opposed to deleting the row) Number of emails sent: a counter for how many emails this subscription created, which would be interesting statistically Then when a new post comes in for thread #483, you simply look up all the people that have subscribed to thread #483 and send them an email. Also (and a little off-topic) you many want to consider adding RSS capabilities. It solves basically the same thing, but with less traffic. Robert _____ From: WebDude [mailto:[email protected]] Sent: Tuesday, June 30, 2009 8:58 AM To: [email protected] Subject: Witango-Talk: OT... sort of - Topic Notification for Forum Hey all, I was wondering if some of you bright bulbs may be able to help me. I have a forum I built that is 100% Witango. It has close to 8,000 members and is fairly busy. I have several tables set up for the forum which include usertable (login, email, password, etc.), forummastertable (table of topics, threadnum, startdate, views, etc.) and threadtable (individual posts, masterthreadnum, postdate, user, etc). This forum is rock solid and has been operating for over 5 years. I have built many bells and whistles into it and decided it would be nice to add an opt in email notification. I've seen this on other forums (a checkbox where you can get an email notification if someone replies to a particular thread), but I am having trouble trying to figure out just where to start and how to do this. I don't mean the programming specifically, but more the theory on how to set this up. I have been looking at other forums but cannot find any particular clue as to how this is done. Would I set up a table with the masterthreadnum and email address and when a topic is reponded to, query that table and send an email? This does not seem like a very efficient way to do this. Any ideas would be appreciated. Thanks! WebDude <http://myfishingpals.com/> MyFishingPals.com ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
<<image001.gif>>
