Jump to content

Forum Design


Recommended Posts

Does anyone know where I might find some information on designing forum code?

Specifically, the problem I'm having is in keeping track of read and unread threads.

If I make a log table, that notes every thread a person goes to, then the number of rows required in that log that would be needed to have every thread marked for every user would blow up exponentially as time went on. I've tried to come up with some sort of compromise where I log things based on a date. If the forum is marked read, update the date in the users table. But then, if someone posts a post, and another person posts a post in a different thread. You can't just update that date in the users table when they've read one of the posts.

So I'm thinking a combination of a date in the users table as a sort of a marker of how far back to go for "unread" threads, and then a log for threads read after that marker is set.

I still haven't gotten it working though. If someone knows of something somewhere that I can read and learn about this, it'd be greatly appreciated. Or if you've done this sort of thing, and are kind enough to give me some pointers, that'd be great as well.

Link to comment
Share on other sites

Guest Anonymous

Re: Forum Design

I used a simple one ....


Now, insert into that a CSV list of the last topics in each forum read by the player:


Adding a forum - adds to the end of the list

Deleting a forum is a little more complex but can be done

Use the FIND_IN_SET function in MySQL... If you need, I have the ADD_TO_SET, and REMOVE_FROM_SET functions that MySQL "forgot".

It works... kinda... might need some thinking about

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...