I have installed Hide Hack Resurrection (by Psonic).
How to modify your query to run in the statistics of thanks?
Code:
if ($cybtopstats_enable_thx AND $vbulletin->options['post_thanks_on_off'])
{
if ($vbulletin->options['cybtopstats_timecut']>0)
{
$get_stats_thanks = $vbulletin->db->query_read("
SELECT SUM(post.post_thanks_amount) AS post_thanks_thanked_times, post.userid, user.usergroupid, user.displaygroupid, user.username, user.posts
FROM " . TABLE_PREFIX . "post AS post
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (post.userid = user.userid)
WHERE post_thanks_amount > '0' $cybexclgroups $cybtopstats_timecut_thx
GROUP BY post.userid
ORDER BY post_thanks_thanked_times DESC
LIMIT 0, $resultsnr
");
}
else
{
$get_stats_thanks = $vbulletin->db->query_read("
SELECT userid, usergroupid, displaygroupid, username, posts, post_thanks_thanked_times
FROM " . TABLE_PREFIX . "user AS user
WHERE post_thanks_thanked_times > '0' $cybexclgroups
ORDER BY post_thanks_thanked_times DESC
LIMIT 0, $resultsnr
");
}
while ($getstats_thx = $db->fetch_array($get_stats_thanks))
{
$getstats_thx[fullusername] = strip_tags($getstats_thx[username]);
if ($trimusername > 0)
{
$getstats_thx[username] = fetch_trimmed_title($getstats_thx[fullusername], $trimusername);
}
else
{
$getstats_thx[username] = $getstats_thx[fullusername];
}
$getstats_thx[musername] = fetch_musername($getstats_thx);
if ($vbulletin->options['cybtopstats_bold_remove'])
{
$getstats_thx[musername] = str_replace($cyb_afs_bpar, "", $getstats_thx[musername]);
}
eval('$cybtopstats_thanks .= "' . $vbulletin->templatecache['cyb_topstats_thanks'] . '";');
}
}