Show Thread Enhancements - [AJAX] Post Thank You Hack

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

Post Thank You Hack 7.4

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.

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

[Hornstar]

Originally Posted by Abe1

Anyway to figure out why on that page only?

im sure the answer you are looking for would be on that page somewhere. because it has the error at the top of the page, and you can see what exactly is displayed on that page. So maybe it doesnt like when certain things occur on a page?


also here is another problem im having, which is the reason i upgraded ^^

BUG

The delete all of a users thanks feature in the admincp is not working. it says it deletes them, but when i refresh the page where that user had thanked everyone, their thanks are still there.

is this occurring for anyone else? because it is not doing anything on mine.

here is a screen shot to show that it is processing it, but then when i check to see if the thanks are gone, they're still there.

[bjhuang]

it seems like this hack adds one query to each "post". in my showthread.php, there are 15 posts per page. 12 queries without this hack, and 27 queries with this hack enabled.

Originally Posted by Abe1

One query to each showthread and showpost page.

[Abe1]

Originally Posted by bjhuang

it seems like this hack adds one query to each "post". in my showthread.php, there are 15 posts per page. 12 queries without this hack, and 27 queries with this hack enabled.

It should only be one. Any way I can have a look around? Do you have the latest version?

[bjhuang]

i've found some hints.

if there're more than one thanks in the "page", it adds only one query. but if there is no thanks at all for the posts of the page, it adds one query per post.

the problem is that you forgot to set $act to be ture after the db query in fetch_thanks()

Originally Posted by Abe1

It should only be one. Any way I can have a look around? Do you have the latest version?

[Abe1]

Originally Posted by bjhuang

i've found some hints.

if there're more than one thanks in the "page", it adds only one query. but if there is no thanks at all for the posts of the page, it adds one query per post.

the problem is that you forgot to set $act to be ture after the db query in fetch_thanks()

I thought I did do something to prevent it. I will look into it.

[fn9mm]

After migrating to another server, i got this error on ALL my tables including VB_post_thanks table

Database error in vBulletin 3.6.5:

Invalid SQL:

INSERT INTO vb_post_thanks
(userid, username, date, postid)
VALUES
('1', 'fn9mm', 1177527910, 15285);

MySQL Error  : Duplicate entry '0' for key 1
Error Number : 1062
...

I was able to fix these duplicate entry errors by running the query mentioned by VBulletin.com here : http://www.vbulletin.com/docs/html/mysql_duplicatekey

However, if I apply the same query for the vb_post_thanks table, it doesn't change a thing,
EDIT, this is the query I ran

ALTER TABLE `vb_post_thanks` CHANGE `id` `id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;

i keep getting those erros everytime I push the 'thank you' button.

I'm sure it's data corruption due to server migration, I allready tried to delete the table and import from backup from previous server, but this doesn't help either

what am I missing here ...?

[Abe1]

Originally Posted by fn9mm

After migrating to another server, i got this error on ALL my tables including VB_post_thanks table

Database error in vBulletin 3.6.5:

Invalid SQL:

INSERT INTO vb_post_thanks
(userid, username, date, postid)
VALUES
('1', 'fn9mm', 1177527910, 15285);

MySQL Error  : Duplicate entry '0' for key 1
Error Number : 1062
...

I was able to fix these duplicate entry errors by running the query mentioned by VBulletin.com here : http://www.vbulletin.com/docs/html/mysql_duplicatekey

However, if I apply the same query for the vb_post_thanks table, it doesn't change a thing,
EDIT, this is the query I ran

ALTER TABLE `vb_post_thanks` CHANGE `id` `id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;

i keep getting those erros everytime I push the 'thank you' button.

I'm sure it's data corruption due to server migration, I allready tried to delete the table and import from backup from previous server, but this doesn't help either

what am I missing here ...?

May have to do with AUTO_INCREMENT

[blue6995]

having carried out the instructions to upgrade/install over the previous verios I am getting the following error messages:

Warning: can_thank_this_post(/homepages/18/d121175559/htdocs/vBulletin/includes/functions_post_groan.php) [function.can-thank-this-post]: failed to open stream: No such file or directory in /includes/functions_post_thanks.php on line 73

Fatal error: can_thank_this_post() [function.require]: Failed opening required '/homepages/18/d121175559/htdocs/vBulletin/includes/functions_post_groan.php' (include_path='.:/usr/local/lib/php') in /homepages/18/d121175559/htdocs/vBulletin/includes/functions_post_thanks.php on line 73


Any idea on how I can resolve this? The file vBulletin/includes/functions_post_groan.php' is definately in the right place.

Thanks

[vspro]

Hi abe1,

You can write an add-con fo this mod, This function of add-on is thank in attad file, Menber which have X THANKS can download attad file, I want this add-on to agains spam member is this one is necessary, My English quite bad, hope you understand my write, thank alot

[Abe1]

Originally Posted by vspro

Hi abe1,

You can write an add-con fo this mod, This function of add-on is thank in attad file, Menber which have X THANKS can download attad file, I want this add-on to agains spam member is this one is necessary, My English quite bad, hope you understand my write, thank alot

No clue what you are saying.