Mini Mods - Recent Thanks for [AJAX] Post Thank You Hack

vB4 version of this hack here: https://vborg.vbsupport.ru/showthread.php?t=280109

Info:

• This mod works with the hack "[AJAX] Post Thank You Hack" as an addon and a) provides a page with the latest X (default: 25) "Thank You" the user has received b) notify the user via vbulletin notification menu (on navbar)
• Very useful for users who want to keep up with the "Thank You" votes on their posts.

System Requirements:

• [AJAX] Post Thank You Hack - for vB3
• vBulletin 3.8.x

Installation information on hack:

• Files edited: 0
• Templates edited: 0
• Files to upload: 1
• Time to install: 1 minute max

How to install:

1. Upload the file "recent_thanks.php" to your forum directory.
2. Import XML file (as product): AdminCP > Plugin System > Manage Products > [Add/Import Product]
3. (Optional if you enable the notifications) Add the link "http://www.yourforum.com/recent_thanks.php" where you want (for example to navbar).

How to upgrade:

1. Upload the new file recent_thanks.php
2. Import XML file (as product): AdminCP > Plugin System > Manage Products > [Add/Import Product] with set of "Allow Overwrite" to YES

Notice (not a bug): The system doesn't decrease the notifications' count for new "Thank you" when the admin push the "Remove all" of a post (rare but ok). So the user will notified but he will not see the removed votes on the page.

Changelog:

• v1.0 - first release
• v1.1 - updated file, new: AdminCP environment/options, new: phrases
• v1.2 - updated file, new: notification system
• v2.0 - updated file, 2 bug fixes, add usercp option to allow users to turn off the notifications
• v2.2 - updated file, improved appearance of the page, 1 bug fix
• v2.3 - updated file, linkable usernames, admincp phrase changed, 1 bug fix

Tested on: vBulletin 3.8.7 - Post Thank You Hack 7.7

-> Don't forget to click INSTALL!

[mangmel]

please include thanked removal by admin. next update

[Pisadam]

I getting an error, can you help me pls.

UPDATE user
SET recent_thankcnt = 0
WHERE userid = 1;

MySQL Error : Unknown column 'recent_thankcnt' in 'field list'
Error Number : 1054
Request Date : Sunday, January 11th 2015 @ 11:21:17 PM
Error Date : Sunday, January 11th 2015 @ 11:21:17 PM
Script : http://www.xxxxx.com/recent_thanks.php
Referrer :
IP Address : 88.234.234.20
Username : xxxxx
Classname : vB_Database
MySQL Version : 5.5.40-cll

[Scandal]

Originally Posted by Pisadam

I getting an error, can you help me pls.

Try to re-install it. Don't forget to import the *xml product!

[VBFguy]

Just installed this on a 3.8.4 board.

When I go to UserCP > Options, this warning appears at the top of the options page:

Warning: mysql_num_rows() expects parameter 1 to be resource, object given in [path]/profile.php(1906) : eval()'d code on line 105

I know it's this hack causing it, as disabling this product eliminates it.

Any suggestions? TIA

Also noticed something else...Unlike what's mentioned above, The "Receive Notifications" userCP checkbox is unchecked by default. If I check it, save options....When I revisit the options page again, that box is not checked, like the setting wasn't saved. I don't know if it's really on or not?

[Triky]

Same issue here like above. Let us know, @Scandal!

[Triky]

Ok, solution that seems to work: plugin -> Recent Thanks - UserCP Field Part2:

change:

PHP Code:

    $isthere = mysql_num_rows($db->query_read("SELECT recent_thankact FROM " . TABLE_PREFIX . "user WHERE userid = ".$vbulletin->userinfo['userid']." AND recent_thankact=1")); 


to:

PHP Code:

    $isthere = mysqli_num_rows($db->query_read("SELECT recent_thankact FROM " . TABLE_PREFIX . "user WHERE userid = ".$vbulletin->userinfo['userid']." AND recent_thankact=1")); 


Problem: mysql_num_rows - Solution: mysqli_num_rows

[OnlyTouch]

Everything is great, thanks, installed!

[DCD.RB]

On the recent thanks page, the time is the server clock, is it possible to change it so it follows in everyone's time zone?