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

[BirdOPrey5]

If you look at the date Darkness gave the Thank You's they were the exact same second. It's either a browser issue or a user issue- maybe they are double-clicking or something. I don't think there is anything you can do about it short of rewriting the mod code to prevent duplicates.

[Scandal]

Every vote has its own security token, I don't understand why it happens.

I hope that it's possible for someone to write a php script or a cron to fix the database data (remove the duplicates or remove all the double votes).


-petros

[Scandal]

Well, I made an inquiry and I find that users with Internet Explorer 9 gives double thanks (with same date/time but different thanks ID). I believe that someone should give us a solution/update!

[djbaxter]

Originally Posted by philos2

Well, I made an inquiry and I find that users with Internet Explorer 9 gives double thanks (with same date/time but different thanks ID). I believe that someone should give us a solution/update!

Then you have so9me sort of conflict with another add-on or possibly with a custom style. I have several members using IE9 and that's not happening on my forums (installed on two 4.1.7 forums and one 3.8x forum).

[Scandal]

Originally Posted by djbaxter

Then you have so9me sort of conflict with another add-on or possibly with a custom style. I have several members using IE9 and that's not happening on my forums (installed on two 4.1.7 forums and one 3.8x forum).

You are right!

The problem was a javascript tooltip I had installed on my site for the viewing of "thanks" votes. I replace it with a simple css tooltip and now all is ok. I don't understand why it appears problems only on IE9 but anyway...
Sorry for the confusion

Now, I must find a solution to fix my database from the duplicate entries.

[jl255]

Originally Posted by BirdOPrey5

Are you on shared hosting? Maybe talk to your host to see if you can extend the timeout period.

Another option would be to shut off your forum and try during a time of day when the server has the least traffic, might work.

Final option might be to add the fields via phpmyadmin directly (or at last check to see if they were correctly made).

would you be able to give me the exact mysql statements to run to add in the fields via phpmyadmin? tks.

[BirdOPrey5]

If you open the product XML file, near the top of the file are the MySQL Statements:

PHP Code:

$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS`". TABLE_PREFIX ."post_thanks` (
    `id` INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `userid` INT(10) NOT NULL,
    `username` VARCHAR(50) NOT NULL,
    `date` INT(10) NOT NULL,
    `postid` INT(10) NOT NULL)
    ");
$vbulletin->db->query_write("ALTER TABLE `". TABLE_PREFIX ."post_thanks` ADD INDEX ( `postid` )");

$vbulletin->db->query_write("ALTER TABLE `". TABLE_PREFIX ."user` ADD `post_thanks_user_amount` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL");
$vbulletin->db->query_write("ALTER TABLE `". TABLE_PREFIX ."post` ADD `post_thanks_amount` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL");
$vbulletin->db->query_write("ALTER TABLE `". TABLE_PREFIX ."user` ADD `post_thanks_thanked_posts` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL");
$vbulletin->db->query_write("ALTER TABLE `". TABLE_PREFIX ."user` ADD `post_thanks_thanked_times` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL");

$db->show_errors();]]></installcode> 


As you can see there are quite a few... You will need to remove the `". TABLE_PREFIX ." from each one and replace it with your actual table prefix, if any.

They need to be run in the order they are shown.

The queries are the code between the quotes, you would ignore everything in red in this example:

$vbulletin->db->query_write("ALTER TABLE `". TABLE_PREFIX ."post_thanks` ADD INDEX ( `postid` )");

And of course it goes without saying- be ABSOLUTELY SURE you have a recent and verified backup of the database before attempting manual edits.

[pfdc]

is this hack available for 4.1.7??

[Simon Lloyd]

Originally Posted by pfdc

is this hack available for 4.1.7??

Considering you have posted here you must have read the mod description.......did you spot the link?

[Mark_Zuckerberg]

first time bad experience with vb mod i also installed db tech like mod and dint worked and now this one also installed showing settings in admin panel but not working in threads and also made the board so slow :down: