[REQUEST] Add Rating to post/thread?

Is it possible to add a Rating system to each post or thread? So that users can rate the usability of each post on the forum. A total rating to the thread (accumulated by related post in the same thread) will be shown in the forumdisplay page.

Also, current counter of each post/thread did the way a page view do. I think it would be better to show how many unique user have had read the post but not only page views.

How do you guys think about that?

Aggh.. not through cookies far to easy to cheat. Much better to do it through mySQL,

arr. one thing. Are we rating threads or are we rating posts. I thought posts as rating posts..

so... each post has another column in the table for "average rating", and "rated_users". The average rating speeks for itself and the rated users is a list of the users that have already rated that post so they can't again.

The user bit, ie popular user would be harder i guess because some how info would have to go in the member table as well but perhaps a column for number of "excellent ratings" for example could go there and then you can just sort the memberlist by the number of "excellent" post ratings.

More thoughts ...

"I also like Chris' idea of making the ratings all positive, wouldn't hurt feelings."

Thank you, i like giving out ideas just wish i could make them, will slowly learn - only been here 3 weeks

You don't need a comments section in a Discussion Board. They could just reply. Also you could integrate the ratings into the reply form. Could be a very neat feature.

Yap, you're right.

Originally posted by chrispadfield


Just some ramblings. What do people think?

Actually this is what I think originally and did not mentioned. Thanks for point this out. I like this idea.

Originally posted by chrispadfield
Aggh.. not through cookies far to easy to cheat. Much better to do it through mySQL,

I think this should be resolved by using a session ID.
After the user rated, a flag is recorded in the session ID and updated to MySQL after the user logged out ?

arr. one thing. Are we rating threads or are we rating posts. I thought posts as rating posts..

I think it should be for post. Since a thread contains many people's thought. But there might have a accumulated ratings for a thread which sum up rating credits for posts in the same thread. How do you think?

Sounds good....

Although thinking about it more a rating for the whole thread is a nice idea for really big forums. It would give a different meaning to "popular topics" but i am not sure if it will be that useful or not.

Well, if you wanted a thread rating, it would be the summation of all post ratings contained in it... so if you rate post 1: 4, and post 2: 20, your thread rating is 24...

And yes, you'd definately want to use mySQL for it -- that's what it is there for!

Although I disagree with keeping a column in the post table for the usernames of the people who voted. The whole point of a relational DB is to create "relations" that you can tie stuff together to. It ruins the whole point if you keep stuffing text fields with data -- that's one of my beefs with VB is that the DB design is... well, lacking a bit and I bet if it was optimized to really take advantage of the SQL language (JOINS, better tables, indicies, etc.) it would improve performance a ton.

Originally posted by mrogish
Well, if you wanted a thread rating, it would be the summation of all post ratings contained in it... so if you rate post 1: 4, and post 2: 20, your thread rating is 24...

I think it should be an average of rating, that is, summation divided by the number of posts in the thread.

That sounds fine too. Althought I'm interested in your methodology with that... why average? Seems to be more indicitive of the user's rating? More fair that way?
Something I'm missing?

my views ona cool way to rate :

Replies are only ratable within 48 hours after posting. You can rate a post between -2 and +4. After each hour, the significance of your rate will become less (so the rating will become more 'stable' after a while). The avarage of all the ratings will be the actual rating.

That if for thread rating?

One way of doing that would be say:

Rating after 1 day, multiply by 5
Rating after 2 day, multiply by 4
Rating after 3 day etc...

Sounds like too much work though. I am still not quite sure what the use of a thread rating is going to be or where you are even going to put the information? I think generally the number of replies/views show how useful a thread is dosen't it.

I also think the usefullness of a rating of a post is in two parts, firstly a highly rated posts (say if i gets 10 5 stars) then it gets highlighed somehow. Secondly, that usres who consistantly get high ratings of their posts get a little icon on their left of post profile saying something to that extent.