[OzzModz] Thanks Statistics Sideblock

[ozzy47]

Another mod brought to you by,
https://vborg.vbsupport.ru/external/2015/01/1.png

Someone asked for this so here it is.

What does this do?
This mod will add a thanks statistics block to your forum sideblocks, showing the total thanks given throughout your whole forum.

What does this hack require?
This hack requires the [AJAX] Post Thank You Hack (https://vborg.vbsupport.ru/showthread.php?t=92410) by Abe1 (https://vborg.vbsupport.ru/member.php?u=49809).

-------------------------------------------------------------------------------------------

If you like this mod please hit the https://vborg.vbsupport.ru/external/2015/08/1.png button to the right ---->

Please remember to click the, https://vborg.vbsupport.ru/external/2015/08/2.png button to the right if you installed the mod ---->

What does 'Marking As Installed' do ?

* It helps you to stay on top of updates - members who have installed modifications will be notified whenever new updates are available.

* For security issues - vbulletin.org will contact all members who have installed a modification whenever a security issue is brought to their attention.

* Marking a modification as installed also helps me know how many people are using my work, giving me extra incentive to provide more features and new modifications.

I appreciate the support!
-------------------------------------------------------------------------------------------

Go to ACP / Forums & Moderators / Forum Blocks Manager and click on Add New Block, and in the next screen choose Custom HTML/PHP then click Continue.

Set it up the following way.

Title: Thanks Statistics (or what ever you want)

Description: Leave blank or fill it in if you wish.

Cache Time (in minutes): I set mine to 2 but you can set it to what ever you want.

Display Order:Any order you want to get the proper order.

Content Type: Choose the PHP one.

In the field Content add this code:

$thanks = $this->registry->db->query_first("
SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "post_thanks
");

$thanksstats='
<table width="100%" align="center">
<tr>
<td class="" align="left">
<div class="smallfont"> <b>Total Thanks On Posts: </b> '.vb_number_format($thanks['count']) . '
</div>
</td>
</tr>
</table>';
//SideBar = End forum Status
//echo $stats;

return $thanksstats;

Template to Use: leave it set to block_html

[mikesafl]

Thank you soo much for this

[ozzy47]

Not a problem, you asked so I had a bit of free time and got it going.

[kapii]

Nice, this will help fill some space on my sideblocks, thanks for sharing.

[ozzy47]

Glad it will help you out.

[Disco_Dave]

Nice :D

Thanks.

[ozzy47]

Your welcome, enjoy.

[root2012]

can be something in What's Going on
so what I'm looking for

[ozzy47]

I'll look into it when I get some free time.

[root2012]

and you have done any yet?

[ozzy47]

No not yet, maybe soon, just a bit busy lately.

[Black Snow]

I've tried to get the top 5 thanks given with this but it doesn't seem to work. Can you see anything wrong with it?


$top5 = $this->registry->db->query_first("SELECT * FROM " . TABLE_PREFIX . " user ORDER BY post_thanks_user_amount DESC LIMIT 5");