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

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

Fri, 07 January 2011 17:10

naudefj

Messages: 3771
Registered: December 2004

Karma:

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

[Message index]

		"Rate Topic" results By: tw_nick on Fri, 07 January 2011 12:48
		Re: "Rate Topic" results By: naudefj on Fri, 07 January 2011 17:10

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: Fri Nov 01 06:21:18 GMT 2024

Total time taken to generate the page: 0.03564 seconds