Jump to content

Storing "unseen" data of a forum

- - - - -

This topic has been archived. This means that you cannot reply to this topic.
22 replies to this topic

#1
Orjan

Orjan

    Writes binary right handed and hex left handed

  • Moderators
  • 3,299 posts
Hello everyone again. this time it's me creating a small simple forum part for my web application, everything seemed clear to me how to do this, when I realized I want/need to let users see unread postings

how is the best way to handle this?

I have categories with topics, and in each topic, I'll have threads and those will have posts, just like any other forum I know of.

just make a huge table of unseen posts like:
user postid
and for each post created, create a post in this table for every user? it's a small systems with up to abt 200 users, so it's not that huge size data, but it seems a little big anyway?

I've tried to look at the database structure of phpbb v2 with no sucess?

or do I just base info on last login? that is not nice if ppl wanna read stuff later and remember what's actually unseen...

hope for some good suggestions or arguments of different methods...

/Örjan

#2
morefood2001

morefood2001

    Speaks fluent binary

  • Members
  • PipPipPipPipPipPipPipPip
  • 1,720 posts
PHPBB v2 is going to be much more complex than what you are going for.

I googled and found: making a simple forum. This should be more help to you than PHPBB would.

If I were you, I'd add the time of the post and cookies to show recent posts. I like the mark all as read function that forums provide.

I hope this helps somewhat.

#3
Orjan

Orjan

    Writes binary right handed and hex left handed

  • Moderators
  • 3,299 posts
thanks for the tip, but this one was a little too simple for me, and unfortunately, it had nothing about just this function of unread messages

Of course I'll have to have a "mark all read" button.

so my problem is still around, how to do it in a smart way?

#4
Orjan

Orjan

    Writes binary right handed and hex left handed

  • Moderators
  • 3,299 posts
anyone got any good ideas on how to do this?

my forum works fine, but it's lacking the unseen/unread information for the users, so if someone have some suggestions?

#5
ArtoStiloz

ArtoStiloz

    Programmer

  • Members
  • PipPipPipPip
  • 175 posts
The easiest would probably be just to collect a PHPBB forum, or what they now called.
I myself would not start, even to program a forum from scratch, if I were to use, the CMS forums exist, they are overwhelming good and safe.

#6
Orjan

Orjan

    Writes binary right handed and hex left handed

  • Moderators
  • 3,299 posts
well, I can't use such a forum, as it needs to be so extremely tightly integrated into the web application I'm creating. the forum is made now aswell, so it's just this unseen-thing that's left...

#7
ArtoStiloz

ArtoStiloz

    Programmer

  • Members
  • PipPipPipPip
  • 175 posts
Well, that is your choice, not mine. Could you possibly deepen the problem?
[SIGPIC][/SIGPIC]
Http://www.ArtoStiloz.Dk

#8
Orjan

Orjan

    Writes binary right handed and hex left handed

  • Moderators
  • 3,299 posts
what's to deepen? I need a smart way to handle and set up unseen threads in the forum. smartest way to store the data etc

ps why be so rude in your comment? ds

#9
ups

ups

    Newbie

  • Members
  • Pip
  • 3 posts
I would definitely dig in phpbb code again. Having a table for unread posts seem a lot of overkill... especially if the forum starts to get big!

#10
ArtoStiloz

ArtoStiloz

    Programmer

  • Members
  • PipPipPipPip
  • 175 posts
I just do not quite understand what you mean by unseen wires in your forum.

Do you think I'm rude when?
It is not the intention, I apologize :)
[SIGPIC][/SIGPIC]
Http://www.ArtoStiloz.Dk

#11
Orjan

Orjan

    Writes binary right handed and hex left handed

  • Moderators
  • 3,299 posts
unseen, or unread threads.
it's so the user can see which threads has changed since last visit etc.. what makes the headlines bold in this forum for you by example...

I felt it was rather rude to say that it's mine problem, not yours, of course it's mine problem, otherwise I wouldn't have made a thread about it here to seek help...
I haven't forced the problem onto you at all.

#12
ArtoStiloz

ArtoStiloz

    Programmer

  • Members
  • PipPipPipPip
  • 175 posts
Oh, now I understand. It is simply to make a small INSERT into your database, UPDATE, DELETE or which way you personally would prefer. :)

Cookies would also be an easy solution.

Edited by ArtoStiloz, 24 September 2008 - 03:08 AM.
Cookies would also be an easy solution.

[SIGPIC][/SIGPIC]
Http://www.ArtoStiloz.Dk