I'm looking to re-invent the wheel to some extent and am inquiring how best to go about it.
I'd like to replicate the read/unread functionality of forum software (Not EE but IPB). Thats to say lets say we have 5 entries and I've only read/landed on entry#1, the other 4 would somehow be marked as "unread".
Using entries/comments instead of forums because I want the entire site in my control.
My thinking would be soon as an entry is posted, its ID is recorded in every members "profile" (or a new table mapped to members ID). If a comment is posted, it to is recorded to all members profile (or new table mapped to members ID) not the comment ID but the entry_id it belongs to.
So entry 4-5 could be recorded like a JSON/array [entry_id2], [entry_id3], [entry_id4], [entry_id5] - don't need comment ID as the comments live on the same page as the entry.
Soon as a member lands on a page with an entry_id listed in their profile (or table) it would delete the corresponding ID - making it 'read'.
On a "view latest entries" summary page, we could then mark item#1 as read (because its not in the users list of unread ID's) and we could then mark the remaining 4 as unread (because it is in their list of unread ID's).
If you made it this far - great. Now, can I source an approach on what I'll need to know to accomplish this. I know I'll need to do create something module/accessory or plugin but NFI on just how.
As a note, there will be about 30-50 members, with about 5-20 posts per day - so not huge but could be – so query/server load will be a factor.