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 :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
"Rate Topic" results [message #164172] Fri, 07 January 2011 07:48 Go to next message
tw_nick   United States
Messages: 57
Registered: October 2010
Location: Dallas, TX
Karma: 0
add to buddy list
ignore all messages by this user

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!

Re: "Rate Topic" results [message #164176 is a reply to message #164172] Fri, 07 January 2011 12:10 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3687
Registered: December 2004
Karma: 19
Senior Member
Core Developer
add to buddy list
ignore all messages by this user
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

You may also want to write a "Like" plugin for FUDforum.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Sat Dec 15 00:31:23 EST 2018

Total time taken to generate the page: 0.00557 seconds