Subscribe to this thread - How do I do this

[liam1412]

Whats the bes DB structure etc for having this sort of function in my forum.

 

Thanks

[Archadian]

what sort of function?

[magnetica]

All Subcribe to this thread means is that you will recieve an email when a new post is posted on that thread

[liam1412]

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.

[nloding]

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.

[Jessica]

As long as you have proper index set up on that table, it doesn't seem that bad.