Top Thanked Members

[Logikos]

Jeez, you people would be better off just not replying to his thread at all then to come in and reply with an automated message like a robot. It's no wonder why this site has been slipping for many years. It's obvious that this is a separate request for an add on of another product, and nine times out of ten the author or supporting members will not fulfill his request due to the number of replies in the hack thread.

Brent, from what I can tell the thanks are stored in the users table. The field name is "post_thanks_user_amount". So a query like this should do the trick.

PHP Code:

$thanks = $vbulletin->db->query_read("
    SELECT userid, username, post_thanks_user_amount
    FROM " . TABLE_PREFIX . "user 
    WHERE post_thanks_user_amount != ''
    ORDER BY post_thanks_user_amount DESC
    LIMIT 10    
");

while ($user = $vbulletin->db->fetch_array($thanks))
{
    echo $user['username'] . "<br />\n";
} 


If you want you can send me a PM with which site you want this on and I can write up a quick mod for you and customize it to your style.