Hi there,
Right now I have a private message system. Private messages are THREADED (as in, there’s not just one database table). There’s a “pm_threads” table (containing the subject and the starter’s user ID, timestamp, etc) and each pm_threads has many pm_posts…
What would be the best way to manage “private message markers?” In other words, what would be the most efficient way to track who the thread is “unread” for (since there’s only one thread)? In the pm_threads table, would it be easiest just to have two columns, unread_for_starter and unread_for_recipient?
Never done unread markers before… I am also developing a custom made forum system too. So I’d port over this concept there as well…
Thanks for the ideas in advanced.