liam1412 Posted February 26, 2007 Share Posted February 26, 2007 Whats the bes DB structure etc for having this sort of function in my forum. Thanks Link to comment https://forums.phpfreaks.com/topic/40151-subscribe-to-this-thread-how-do-i-do-this/ Share on other sites More sharing options...
Archadian Posted February 26, 2007 Share Posted February 26, 2007 what sort of function? Link to comment https://forums.phpfreaks.com/topic/40151-subscribe-to-this-thread-how-do-i-do-this/#findComment-194250 Share on other sites More sharing options...
magnetica Posted February 26, 2007 Share Posted February 26, 2007 All Subcribe to this thread means is that you will recieve an email when a new post is posted on that thread Link to comment https://forums.phpfreaks.com/topic/40151-subscribe-to-this-thread-how-do-i-do-this/#findComment-194256 Share on other sites More sharing options...
liam1412 Posted February 26, 2007 Author Share Posted February 26, 2007 I know thats what it means but how go about storing the info of what threads people have subscribed to without having a massive table. Link to comment https://forums.phpfreaks.com/topic/40151-subscribe-to-this-thread-how-do-i-do-this/#findComment-194352 Share on other sites More sharing options...
nloding Posted February 26, 2007 Share Posted February 26, 2007 I've been looking into this myself and can't find a definite answer, so I'm studying the SMF code and my buddy bought vBulletin, so I'm looking at their code too. Only been searching for < 5 minutes, so I don't know how they have it set up ... if I find out, I'll post. My guess is that it's a separate table with two columns -- User ID and Topic ID. When "Post" or "Submit" or whatever is hit, I'm guessing the server pulls all user ID's from that table matching the topic ID, generates an email, and sends it to them all. I can't think of a nicer way to set that up ... I would like to know if there is a better way though. You're gonna have a massive table if you're forum is large enough, so that shouldn't be the concern ... the concern should be optimizing/normalizing the table as much as you can to get peak performance. Link to comment https://forums.phpfreaks.com/topic/40151-subscribe-to-this-thread-how-do-i-do-this/#findComment-194357 Share on other sites More sharing options...
Jessica Posted February 26, 2007 Share Posted February 26, 2007 As long as you have proper index set up on that table, it doesn't seem that bad. Link to comment https://forums.phpfreaks.com/topic/40151-subscribe-to-this-thread-how-do-i-do-this/#findComment-194359 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.