将论坛帖子标记为已读？

Question

I'm working on a custom forum and was wondering what people would consider as the best approach to marking a thread as read.

I want to display a post icon for the threads and if the thread hasn't been read it has an unread icon and the topic title is bold. If its been read then the topic title is normal font weight and the post icon changes to the read icon.

Would the best way be to store in the users session which threads they have viewed and set it up to mark all threads older than 48 hours or so as read?

Thanks!

Answer 1

Create a second table such as:

thread_member: thread_id, member_id, read_flag, posted_flag, bookmarked_flag

Basically anything specific to that member and a thread could go in there. When pulling the list of threads, LEFT JOIN against that table. If read_flag is 0 or NULL, then it's new.

SELECT * FROM thread t
LEFT JOIN thread_member tm ON t.id=tm.thread_id AND tm.member_id=$member_id
WHERE t.id=$thread_id

Anytime somebody posts a message in the thread, just run this query:

UPDATE thread_member SET read_flag=0 WHERE thread_id=$thread_Id

posted_flag could be used to determine if the person wrote a message in the thread.

bookmarked_flag could be used to determine if the person bookmarked the thread.

To keep the table trim, you could truncate all old records that didn't have any important flags set. In this example, you could delete all records older than X days/weeks/months that don't have bookmark_flag set.