I just updated this plugin today, but it appears to not work with vS-Hide Hack Resurrection (Expanded Edition) any more. Per the instructions:
Open plugin "cyb" at "forumhome_complete" hook, and find:
Code:
$get_stats_thanks = $db->query_read("
SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts, post_thanks_thanked_times
FROM " . TABLE_PREFIX . "user
ORDER BY post_thanks_thanked_times DESC LIMIT 0, $resultsnr");
Replace with:
Code:
$get_stats_thanks = $db->query_read("
SELECT user.userid, user.username, user.usergroupid, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, user.posts,
count(thanks.postid) as post_thanks_thanked_times
FROM " . TABLE_PREFIX . "thanks as thanks
LEFT JOIN " . TABLE_PREFIX ."post as post ON (post.postid = thanks.postid)
LEFT JOIN " . TABLE_PREFIX ."user as user ON (post.userid = user.userid)
GROUP BY user.userid
ORDER BY post_thanks_thanked_times DESC LIMIT " . $resultsnr . "
");
I don't see "cyb" at "forumhome_complete" hook anymore? Any suggestions?