• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Forum system - how to track already read vs new messages, per user

#20
[eluser]jedd[/eluser]
Fuzzy - yup, the CI forums.

xwero - the clean methods there still allow for a huge amount of useless information to be retained. I'm pondering different approaches still. Sub-forums - as in the category of forums - I'm happy to leave entirely alone, as I don't need that second level of indirection. So for me, 'forum home' will be a list of forums. Within each forum will be a list of threads/topics. Within each thread will be a list of messages. So at the moment my table is easy:
id
user_id
thread_id
message_id

I was just doodling on some paper, trying to work out the next step - doing notifications (if the user wants them - which is a flag kept in the user table of course) for posts in a given thread. Given each row of this table identifies user & thread (because there'll only ever be one message_id per user/thread combo, as you pointed out) I'm thinking a fifth column in here - a boolean - for notify. I can't see any benefit from putting that information into its own table .. yet.


Messages In This Thread
Forum system - how to track already read vs new messages, per user - by El Forum - 04-01-2009, 12:44 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.