Show Thread Enhancements - [AJAX] Post Thank You Hack

vB 4.0 version of this hack here: https://vborg.vbsupport.ru/showthread.php?t=231666

Post Thank You Hack 7.7

About this hack:
One of the biggest problems on forums as you may know is 'posts boosting'. There are users who LOVE to say 'thanks' when ever they can. How can it hurt? Their post count goes up, they have nothing to loose.

There are also users who really like to express their thanks to post but don't like posting a post that looks like they're post boosting.

Then comes the moderators who have to delete people's thanks yous so a thread can look readable with out the thanks yous thrown around.

Finally comes the posters of these useful posts. They have no idea how many people really likes their posts if only some people say 'thanks'.

What this hack does is fix ALL these problems - except those users who like post boosting. This places a button called 'thanks.' When a user clicks on it, it places his username in a box right under the post saying that so-and-so says 'thanks' for the post. Every-one who clicks is placed in one box.

By giving your users the extra feature, you forum will look allot nice and organized. It is a guaranteed liking by ALL the members of your forum.

Features:

• Uses vBulletin easy Product installer/updater/uninstaller
• Uses AJAX technology so your users don't have to refresh when they thank.
• Places an easy to use button next to the edit button
• Separate looks for postbit and postbit_legacy
• Places all Thanks into one small box
• Uses only ONE query every time you view a showthread page!
• Users can't thank twice
• Option to not allow users to thank their own post
• Guests don't see 'thanks' button
• Counts how many thanks a user gives
• Counts how many thanks a post gets
• Shows how many thanks a user gave in every post of his
• Shows how many thanks a user gave in profile
• Shows how many thanks a user got
• Shows how many posts or a user are thanked
• Shows info in profile
• Search for a users thanked posts
• Search for all thanked posts
• Administrator can remove all Thanks from a single post
• Users can remove their own Thanks
• Turn on and off hack totally
• Turn on and off hack for only some forums
• Option to turn off hack for all but the first post of a thread
• Option to turn off hack for all but the first post of a thread in specific forums
• Option to turn off hack view of date for specific or all forums
• Option to add to post count when someone clicks 'thanks'.
• Option to give a user who receives thanks reputation points.
• Ban Usergroups
• Ban Users
• Uses Phrases
• Cache Templates
• Guaranteed to be liked by ALL users on your forum!

Installation information on hack: (If installed on vb 3.7)

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

Updates:

Version 7.0 (12/20/07):

• Release of this hack for vBulletin version 3.7
• This version works on all vBulletin versions from 3.6.0 and up

Version 7.1 (12/24/07):

• Fixed up the vb3.7 profile block code including fixing showing your info and not the member you are looking at.

Version 7.2 (01/24/08):

• Updated files: post_thanks.php, functions_post_thanks.php
• Updated templates: post_thanks_memberinfo_block, post_thanks_member_info
• New option: Remove User's Thanks Count When Deleting Post
• New phrase: post_thanks_search_user_gave
• FIX User reputation level now updates. (Thanks to liwo for this one.)
• NEW Added option to view all posts a user has thanked.
• FIX Fixed Special Action - Delete All of a Users Thanks
• FIX Should have fixed some 'foreach()' errors.

Version 7.3 (03/15/08):

• Updated file: functions_post_thanks.php
• Updated template: post_thanks_memberinfo_block
• Deleted template: post_thanks_memberinfo_css
• New option: Choice to use Markup Usernames or not. (Thanks to Namaless)
• New option: Ban User from Getting Thanks
• New option: Max Thanks a User can Give Per Day
• FIX Fixed repeating bug on vb 3.6.7 forums.
• CHANGE Changed where the post thanks info shows on the Profile Page. Moved to same box as statistics. (This will require a template edit if you are running vb3.7 beta 2-4)

Version 7.4 (03/21/08):

• FIX: Fixed Profile Stats for vb3.7.0 RC1 users.

Version 7.5 (05/12/08):

• Updated files: post_thanks.js, post_thanks.php, functions_post_thanks.php
• Updated template: post_thanks_button
• Added securty token check for all thanks added. This will prevent a user from giving out a link or somehow making an image that will get him a lot of thanks.
• Should have fixed some 'foreach()' errors.
• Fixed Delete All of a Users Thanks bug
• vBulletin 3.7.x compatible only

Version 7.6 (06/02/08):

• FIX: Fixed Security Check for vb 3.7.1
• Updated files: functions_post_thanks.php

Version 7.7 (07/28/08):

• FIX: Fixed problem with giving thanks using Blazer (palmOS browser).
• Updated file: post_thanks.js
• Updated templates: post_thanks_button, post_thanks_postbit, post_thanks_postbit_legacy
• New option: Show Stats in Postbit?
• New option: Show Stats in Profile?

Please post your comments or suggestions for this hack. I read ALL posts.

MAKE SURE YOU CLICK INSTALL!
You will get an email when a new version is released.

Pictures:

1. Showing the 'thanks' button and stats in Postbit
2. Showing post after 'thanks' (user view)
3. Showing post after 'thanks' with legacy posts (admin view)
4. Stats in members profile and link
5. Link in Search drop down menu
6. Hacks settings

[Manipulation]

Bump, does anybody have a solution to the page freezing when I upload the plug in?

[Manipulation]

Can I get some assistance with this? Anybody?

[Don Z.]

I'll bump this since I'm having the exact same problem. After upgrading to vB 3.8.11 pages just freeze when Post Thank You Hack 7.7 is enabled.

Does anyone know how to get this working again? I have thousands of "Thanks" I don't want to lose.

[vbem2]

Originally Posted by blind-eddie

Would have a better idea if you were to post your database error in [CODE] brackets.

Also just upgraded to 3.8.11 and am getting errors on showthread.php when the Thanks plugin is enabled.

Seems to be related to an array variable that doesn't exist after the upgrade.

Database error in vBulletin 3.8.11:

Invalid SQL:
SELECT * FROM post_thanks AS post_thanks INNER JOIN user AS user USING (userid) WHERE post_thanks.postid IN (0Array) ORDER BY post_thanks.username ASC;

MySQL Error   : Unknown column '0Array' in 'where clause'
Error Number  : 1054
Request Date  : Tuesday, May 23rd 2017 @ 03:57:59 PM
Error Date    : Tuesday, May 23rd 2017 @ 03:57:59 PM
Script        : ....../forum/showthread.php?t=33292
Classname     : vB_Database_MySQLi
MySQL Version : 5.5.54-0+deb8u1

[treki]

Same problem. After upgrading to 3.8.11:

Invalid SQL:
SELECT * FROM vb_post_thanks AS post_thanks INNER JOIN vb_user AS user USING (userid) WHERE post_thanks.postid IN (0Array) ORDER BY post_thanks.username ASC;

MySQL Error   : Unknown column '0Array' in 'where clause'
Error Number  : 1054

Any ideas/solutions?

[cassedy]

same error here after upgrade to 3.8.11.

any idea?

[vbem2]

Making the following changes caused the Post Thanks hack to start working again on my 3.8.11 installation. Note: I haven't tested extensively beyond seeing that I could give thanks and delete it from one other member's post.

GIANT DISCLAIMER: I am not an expert coder. I occasionally muck around in PHP and sometimes understand what I'm doing.

Apply this fix AT YOUR OWN RISK. I can't help if it doesn't work for you.

The changes below refer to Post Thank You Hack version 7.6 only.

1) Back up a copy of your original 7.6 file in /forum/includes/functions_post_thanks.php in case this gets all screwed up.

2) Open the file in your favourite editor.

3) Starting at line 178, replace this...

		if ($postids)
		{
			$post_ids = "0$postids";
		}
		else
		{
			$post_ids = $postid;
		}

... with this:

		if (empty($postids))
		{
			$postids[] = $postid;
		}

4) A few lines below that (originally at line 189, but moved down due to the changes above), replace the this line ...

			$thanks = $vbulletin->db->query_read("SELECT * FROM " .TABLE_PREFIX. "post_thanks AS post_thanks INNER JOIN " .TABLE_PREFIX. "user AS user USING (userid) WHERE post_thanks.postid IN (" . $post_ids . ") ORDER BY post_thanks.username ASC");

... with this:

			$thanks = $vbulletin->db->query_read("SELECT * FROM " .TABLE_PREFIX. "post_thanks AS post_thanks INNER JOIN " .TABLE_PREFIX. "user AS user USING (userid) WHERE post_thanks.postid IN (" . implode(',', $postids) . ") ORDER BY post_thanks.username ASC");

5) A few lines below that (originally at line 193, but since moved further down due to the changes above), replace the this line ...

			$thanks = $vbulletin->db->query_read("SELECT * FROM " .TABLE_PREFIX. "post_thanks WHERE postid IN (" . $post_ids . ") ORDER BY username ASC");

... with this:

			$thanks = $vbulletin->db->query_read("SELECT * FROM " .TABLE_PREFIX. "post_thanks WHERE postid IN (" . implode(',', $postids) . ") ORDER BY username ASC");

6) Save & upload the file to /forum/includes.

Maybe it'll work for you too. Good luck!

[cassedy]

Originally Posted by vbem2

Making the following changes caused the Post Thanks hack to start working again on my 3.8.11 installation. Note: I haven't tested extensively beyond seeing that I could give thanks and delete it from one other member's post.

GIANT DISCLAIMER: I am not an expert coder. I occasionally muck around in PHP and sometimes understand what I'm doing.

Apply this fix AT YOUR OWN RISK. I can't help if it doesn't work for you.

The changes below refer to Post Thank You Hack version 7.6 only.

1) Back up a copy of your original 7.6 file in /forum/includes/functions_post_thanks.php in case this gets all screwed up.

2) Open the file in your favourite editor.

3) Starting at line 178, replace this...

		if ($postids)
		{
			$post_ids = "0$postids";
		}
		else
		{
			$post_ids = $postid;
		}

... with this:

		if (empty($postids))
		{
			$postids[] = $postid;
		}

4) A few lines below that (originally at line 189, but moved down due to the changes above), replace the this line ...

			$thanks = $vbulletin->db->query_read("SELECT * FROM " .TABLE_PREFIX. "post_thanks AS post_thanks INNER JOIN " .TABLE_PREFIX. "user AS user USING (userid) WHERE post_thanks.postid IN (" . $post_ids . ") ORDER BY post_thanks.username ASC");

... with this:

			$thanks = $vbulletin->db->query_read("SELECT * FROM " .TABLE_PREFIX. "post_thanks AS post_thanks INNER JOIN " .TABLE_PREFIX. "user AS user USING (userid) WHERE post_thanks.postid IN (" . implode(',', $postids) . ") ORDER BY post_thanks.username ASC");

5) A few lines below that (originally at line 193, but since moved further down due to the changes above), replace the this line ...

			$thanks = $vbulletin->db->query_read("SELECT * FROM " .TABLE_PREFIX. "post_thanks WHERE postid IN (" . $post_ids . ") ORDER BY username ASC");

... with this:

			$thanks = $vbulletin->db->query_read("SELECT * FROM " .TABLE_PREFIX. "post_thanks WHERE postid IN (" . implode(',', $postids) . ") ORDER BY username ASC");

6) Save & upload the file to /forum/includes.

Maybe it'll work for you too. Good luck!

genius! it works.. thanks a lot..

[treki]

YEEEES!!!! Genius. 7.7 work fine under vB3.8.11

[Silvio]

@vbem2 thank you! It fixed to me too! great work.