FUDforum: How To » "Rate Topic" results

Home » FUDforum » How To » "Rate Topic" results (How is the data compiled and what can the admins do with it?)

Show: Today's Messages :: Polls :: Message Navigator

"Rate Topic" results [message #164172]

Fri, 07 January 2011 12:48

tw_nick

Messages: 57
Registered: October 2010
Location: Dallas, TX

Karma: 0

Member

I like the idea of the "rate topic" feature, but I'm wondering what the overall value of it is or how we could improve the value of it. My users have asked if there is/could be an equivalent feature to Facebook's "like" button on the site, and my only answer at this point has been to use the rating function. But what does that really do for me (or them)? I see it keeps a running average, as well as a tally of the ratings, but is more data actually being captured by the database, such as who rated it and when? And could a query be written to find out things like which messages carry the top ratings? While FB's "like" function (or the much-requested but never delivered "dislike" button) would be FANTASTIC, I'd happily take a functional (and useful) rating feature...

Comments? Guidance? Explanations? Directions of a general "downward" nature? (i.e., "go to hell") Smile

Let them rip!

Thanks!

Report message to a moderator

Re: "Rate Topic" results [message #164176 is a reply to message #164172]

Fri, 07 January 2011 17:10

naudefj

Messages: 3775
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Info about ratings is stored in fud30_thread_rate_track and fud30_thread.

You can query the data from the SQL Manager. For example:

SELECT subject, rating, n_rating 
FROM fud_thread t
INNER JOIN fud_msg m ON t.root_msg_id = m.id
WHERE n_rating > 0
ORDER BY rating DESC, n_rating DESC
LIMIT 10

You may also want to write a "Like" plugin for FUDforum.

Report message to a moderator

Previous Topic:	Removing line of text which says: Show: Today's Messages etc.
Next Topic:	Reorder page title separators

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 29 20:12:20 GMT 2025

Total time taken to generate the page: 0.01978 seconds