Marcus wrote:
Otis wrote:
I'm not sure how to implement it however
. The comments are in a different format as it seems. Threads on this forum are also not 'start post + comments' but just 'thread + postings'. However that can be worked around.
Frans correct me if I'm wrong here, but isn't this a case of the first message in the thread is the "Start Post" and subsequent messages are "Comments".
No
Well, some might model it that way, I chose a different route. I have: sections, forums, threads and messages. Forum has a sectionID FK, threads have a forum FK and messages have a thread FK.
If I had modeled it differently, I would have had to split it up I think, treat the messages differently: some are startposts, others are replies.
You must have the order of the messages in the db since you are displaying them in the correct order on the message board... therefore it seems intuitive that you could (while you are rendering the RSS feed) just check whether or not the message you are currently formatting is the first in its thread? Add a little caching and it should work a treat... I think!
No the order isn't stored
I store the posting date+time and order ASC on that. This has the big advantage that if I delete a posting in the thread I don't have to renumber the order numbers which can go wrong if at the same time someone is posting a message. This simple ordering also works always, no matter if some people post at exactly the same time.
Of course I can find out what the startpost is and what replies are (that is not that big of a problem). I don't recall any comment tag in RSS 2.0 however, just an url where comments are derived from, however how that has to work is not yet clear to me (haven't looked that far for it though).