FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

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
Switch to threaded view of this topic Create a new topic Submit Reply
"Rate Topic" results [message #164172] Fri, 07 January 2011 12:48 Go to next message
tw_nick   United States
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!
Re: "Rate Topic" results [message #164176 is a reply to message #164172] Fri, 07 January 2011 17:10 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
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.
  Switch to threaded view of this topic Create a new topic Submit Reply
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) ] [ RSS ]

Current Time: Thu Oct 31 23:05:58 GMT 2024

Total time taken to generate the page: 0.01914 seconds