[AJAX] Post Thank You Hack

Post Thank You Hack 4.5

Click here for the vb3.6 version of this hack.

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 granted 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:

• Files edited: 0
• Templates edited: 4
• Files to upload: 1
• Time to install: 5 minutes max

Updates:

Version 2.0 GOLD (10/02/05):

• GOLD Release of this hack for vBulletin version 3.5

Version 2.1 (10/23/05):

• [BUG FIX] When merging/splitting threads
• [BUG FIX] When a user deletes his thanks (now removes post/rep count if option(s) on)
• [ADD PHRASE] post_thanks_user_says
• [ADD PHRASE] post_thanks_time_post
• [ADD PHRASE] post_thanks_times_post
• [ADD PHRASE] post_thanks_times_posts
• [DELETED PHRASE] post_thanks_thanks_amount

Version 2.2 (10/23/05):

• [ADDED] Re-counters. Found under Maintenance->Update Counters in your ACP.

Version 2.3 (11/05/05):

• [ADDED] Cache Templates

Version 2.4 (11/07/05):

• [ADDED] Setting to disallow users from deleting their own thanks.

Version 2.5 (11/09/05):

• [FIXED] All number outputs run through your vb setting of number format. (e.g. 1234 will now show as 1,234)

Version 2.6 (12/04/05):

• [FIXED] Number outputs for numbers between 1,000 and 1,999
• [FIXED] Showing of the thanks button on deleted threads pages.

Version 2.7 (12/18/05):

• [ADDED] Made the Thanks button a template
• [ADDED] Made a template group for this hacks templates
• [FIXED] One template edit. Find correction in zip file.
• [CHANGED] Made a pop-up now when you click Thanks instead of refreshing the page.
• [FIXED] Made the line when you give reputation points for thanks, a phrase.
• [ADDED] Paypal link so you can make a donation for this hack.

Version 2.8 (2/5/06):

• [FIXED] Removed one query thanks to AnhTuanCool (Abe clicks 'thanks')
• [ADDED] Option to allow users to thank their own post
• [ADDED] Option to allow a pop=up or refresh after a user clicks thanks

Version 2.9 (2/8/06):

• [FIXED] Fixed allot of things in regard to deleting thanks using the "remove all thanks" and "Remove your thanks".

Version 3.0 (2/10/06):

• [FIXED] Fixed one more thing in regard to "remove all thanks".
• [FIXED] Re-wrote the thanks actions so it they useless queried when you give or remove thanks.

Version 3.1 (2/11/06):

• [FIXED] Fixed bug with reputation.

Version 3.2 (2/13/06):

• [FIXED] Fixed another bug with reputation.
• [FIXED] Sped up the one query used to retrieve the thanks.

Version 3.3 (2/14/06):

• [FIXED] Fixed bug with removing own thanks.

Version 3.4 (3/17/06):

• [FIXED] Fixed a few bugs.

Version 4.0 (4/17/06):

• [ADDED] AJAX technology so your users don't have to refresh the page they are viewing!

Version 4.1 (4/18/06):

• [FIXED] Crashing of 'quick reply' when using Firefox.

Version 4.2 (4/23/06):

• [FIXED] If you have vboption 'Add Template Name in HTML Comments' set to 'Yes', button was not showing.
• [FIXED] Uncached template when viewing a PM
• [FIXED] Getting sent to index page when clicking thanks on some forums.
• [FIXED] Link to member's profile from the thank box.
• [FIXED] The post thank count not updating. (Recommend you recount thanks. (ACP->Maintenance->Update Counters)

Version 4.3 (5/4/06):

• [FIXED] Optimized a lot of the templates.
• [ADDED] Easy integration with my Post Groan Hack.

Version 4.4 (5/7/06):

• [FIXED] Bug with AJAX if you had the date showing.

Version 4.5 (6/19/06):

• [FIXED] Bug with AJAX if you had hacks that added things to your output.

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' (admin view)
4. Showing post after 'thanks' with legacy posts (admin view)
5. Stats in members profile and link
6. Link in Search drop down menu
7. Hacks settings

This hack is created for your use free of charge. No payment is requested. However, if you would like to donate money for the work I put in to this hack, a donation would show your appreciation.

[AnhTuanCool]

Add the patch in my #485 post BEFORE:

$act = 1;

and that should be it!

[dai-kun]

i did that

global $post_thanks_cash, $post_thanks_done, $db;

if (empty($post_thanks_done))
{
$post_thanks_querys = $db->query("SELECT postid FROM ". TABLE_PREFIX ."post WHERE threadid = '$post[threadid]'");
    $post_thanks_postids = 0;
    
    while ($post_thanks_query = $db->fetch_array($post_thanks_querys))
    {
      $post_thanks_postids .= ",$post_thanks_query[postid]";
    }

    $post_thanks_cashe = $db->query("SELECT * FROM " .TABLE_PREFIX. "post_thanks WHERE postid IN ($post_thanks_postids) ORDER BY username ASC");

    $act = 1;

and when i go to thank, i get this error

Database error in vBulletin 3.5.1:

Invalid SQL:

		    UPDATE vb3_user
		    SET post_thanks_thanked_times = 1 + post_thanks_thanked_times, post_thanks_thanked_posts = 1 + post_thanks_thanked_posts, reputation = $vboptions[post_thanks_reputation] + reputation
		    WHERE userid = 741;

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[post_thanks_reputation] + reputation
		    WHERE userid = 741' at line 2

[C_P]

Originally Posted by NeutralizeR

Can't remove thanks.

Ditto! I get same error:

Database error in vBulletin 3.5.2:
Invalid SQL:
DELETE FROM reputation WHERE postid = 12795 AND AND whoadded = 1 reason = 'Thanked Post';
MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND whoadded = 1 reason = 'Thanked Post'' at line 1
Error Number : 1064
Date : Monday, February 13th 2006 @ 06:08:34 AM
Script : http://www.cpfools.com/forum/showthr...e_user&p=12795
Referrer : http://www.cpfools.com/forum/showthr...2795#post12795
IP Address : xxxxxx
Username : CP
Classname : xxxxxxxxxx

Also at top of my page it shows this:

 Warning: Invalid argument supplied for foreach() in /includes/class_postbit.php(251) : eval()'d code on line 131

Warning: Invalid argument supplied for foreach() in /includes/class_postbit.php(251) : eval()'d code on line 141
/*+--------------------------------------------------------------------------|   Cascading Style Sheet for MKportal "Forum" Portal Template|   ========================================|   by Meo aka Luponero [Amedeo de longis]|      visiblesoul [Don K. Colburn]|   (c) 2004-2005 mkportal.it|   http://www.mkportal.it|   Email: luponero@mclink.it+--------------------------------------------------------------------------|   > MKPortal|   > Written By Amedeo de longis|   > Date started: 9.2.2004+--------------------------------------------------------------------------*//*=============================MK  global stylesP=============================*//* IMPORT body */body,body{	background: #FFFFFF;	color: #000000;	font: 10pt verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;		padding: 0px;}body {	font-size: 10px;	margin:0px; 	padding:0px; /* Opera 0 margin */		text-align: center; /* center in IE */ }/* IMPORT body background (used for SMF) */.importbgbody {	font-size: 10px;}/* portal wrapper */#mkwrapper {	text-align:left; /* left-align text in IE */		margin: 0px auto 0px auto;}/* IMPORT logostrip */#mklogostrip,.page{	background: #FFFFFF;	color: #000000;}/* logostrip */#mklogostrip {	text-align: left;}/* IMPORT global font formatting */table,tr,td,.tdglobal,td, th, p, li{	font: 10pt 'trebuchet ms', verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;}/* global font formatting */table,tr,td,.tdglobal {	font-size: 10px;	}/* IMPORT main portal table bg (if different than body bg) */.tabmain,.page{	background: #FFFFFF;	color: #000000;}/* main portal table */.tabmain {	margin:0px;	padding:0px;	}/* image link border */img { 			border: 0px;}/*=============================MK IMPORT LIGHT BACKGROUNDP=============================*/.modulecell,.urlo2,.tabnews,.trattini,.trattini3,.tablemenu,.taburlo,.alt1, .alt1Active{	background: #DFE6EE;	color: #000000;}/*=============================MK IMPORT MEDIUM BACKGROUNDP=============================*/.navigatore,.tdblock,.moduleborder,.modulex,.mkpagecurrent,.alt2, .alt2Active{	background: #DFE6EE;	color: #000000;}/*=============================MK IMPORT DARK BACKGROUNDP=============================*/.urlo,.sottotitolo,.tcat{	background: #397DD0 url(../forum/images_pb/gradients/gradient_tcat.gif) repeat-x top left;	color: #FFFFFF;	font: bold 10pt verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;}/*=============================MK  border and divider stylesP=============================*//* vertical spacer image used in portal skin *//* .vspacer {	background-image: url(../forum/../mkportal/templates/CPstyle/images/punto_vert.gif);	background-repeat: repeat-y;	background-color: transparent;	} *//* IMPORT border-color */.tabmain,.tablemenu, /* block wrapper, chat button strip */.taburlo,.urlo2,.tabnews,.trattini,.trattini2,.trattini3,.mkpagelink,.mkpagelinklast,.mkpagecurrent,.titadmin,.tborder{		color: #000000;	border: 1px solid #072A68;}	.trattini {	border-width: 1px 0 0 0;	border-style: dashed;}/* blocks admin */.trattini2 {	border-width: 0 1px 0 0;	border-style: dashed;}/* Quotes, Shoutbox */.trattini3 {	border-width: 0 0 1px 0;	border-style: dashed;}/*=============================MK  hyperlink stylesP=============================*//* IMPORT global links */a:link,a:active,a.uno:link,a:link{	color: #000000;}a:visited,a.uno:visited,a:visited{	color: #000000;}a:hover,a.uno:hover,a:hover, a:active{	color: #465584;}/* a:active {	font-family: Verdana, Arial, Helvetica, sans-serif;	color: #496c9f;		text-decoration: none; 	} *//* bold navbar, block, module links */a.uno:link {	font-size: 10px;	font-weight: bold;	text-decoration: none}a.uno:visited {		font-size: 10px; 	font-weight: bold;	text-decoration: none}a.uno:hover {	font-size: 10px;	font-weight: bold;	text-decoration: underline;}/* block text links *//* .tablemenu a:link, a:visited {	font-family: Verdana, Arial, Helvetica, sans-serif;	color: #496c9f;		text-decoration: none;	}.tablemenu a:hover {	text-decoration: underline;}.tablemenu a:active { 	text-decoration: none; 	} *//* global contrasting text and hyperlink color */.mktxtcontr,a.mktxtcontr:link, a.mktxtcontr:visited {		color: #ff0000;	font-weight: bold;	text-decoration: none;}a.mktxtcontr:hover {	font-weight: bold;	text-decoration: underline;}/* contrasting text and hyperlink color 2 (admin) */.mktxtcontr2,a.mktxtcontr2:link, a.mktxtcontr2:visited {	color: #0000ff;	font-weight: bold;	text-decoration: none;}a.mktxtcontr2:hover {	font-weight: bold;	text-decoration: underline;}/*=============================MK  form stylesP=============================*//* IMPORT form styles */input,textarea,select,.bgselect, /* input fields */.mkbutton, /* global submit buttons */.mkblkinput, /* block input */.mkradio, .bginput{	background: #FFFFFF;	color: #000000;	font: 10pt verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;}/* set form padding and margin *//*.mkbutton,*/ /* global submit buttons *//* textarea,*/input,select,.bgselect, /* input fields */.mkblkinput /* block input */{	margin: 0px;	padding: 0px;	font-size: 9px;	font-weight: normal; /* needed for Mozilla */	}/* radio/checkbox buttons - remove background color and border in IE */ /* .mkradio {	background-color: transparent;	border-width: 0px;} *//* configure blog textarea */textarea.mkwrap1 {	overflow: auto;	/* width: 230px; */	width: 100%;}/* edit blog textarea */textarea.mkwrap2 {	overflow: auto;	width: 500px ;}/*=============================MK  navstrip stylesP=============================*//* top navstrip */.navigatore {		vertical-align: bottom;	text-align: center;	font-family: Verdana, Arial, Helvetica, sans-serif;	font-weight: 300;	font-size: 9px;	border: 0;}/*=============================MK  block stylesP=============================*//* used in functions.php (function main_page) */.blocks {	padding: 0px;}/* block td cell */.tdblock {	font-family: Verdana, Arial, Helvetica, sans-serif;	font-size: 10px;	font-weight: bold;	border: 0;	margin: 2px;	}/* block title bar */.sottotitolo {	vertical-align: bottom;		text-align: left;	font-size: 11px;	font-weight: bold;	 }/* horizontal spacer between blocks */.tdspacer {	line-height: 3px;}/*=============================MK  module global stylesP=============================*//* IMPORT module table headings */th.modulex,.thead{	background: #BCCFEA url(../forum/images_pb/gradients/gradient_thead.gif) repeat-x top left;	color: #3A4F6D;	font: bold 11px tahoma, verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;}.modulex {		border-width: 0 0 0 0;	white-space: nowrap;	/* font-weight: normal;*/}/* Reviews description text */.modulelite {	font-size: 8pt;	/* color:#a6bbcd;*/}/* block padding (news, admin) */.contents {	padding: 10px;	}/* module pagination links */.mkpagelink {	padding:1px 3px 1px 3px;	font-weight: normal;}.mkpagelinklast {	padding:1px 3px 1px 3px;	font-weight:normal;}.mkpagecurrent {	padding:1px 3px 1px 3px;	font-weight:normal;}/*=============================MK  shoutbox module stylesP=============================*/td.taburlo{		margin:5px;	padding:5px;	border: 0;	}	/* shouter and date cell */.urlo {	line-height: 18px;	vertical-align: bottom;	text-align: left;		font-size: 11px;	font-weight: bold;	padding: 4px;		 }/* shout cell */.urlo2 {	padding: 4px;	border-width: 0 0 1px 0;	border-style: solid;	text-align: left;	font-size: 11px;	font-weight: bold;}/* white shouter text *//* .urlocontrast {		color: #ffffff;} *//*=============================MK  news module stylesP=============================*//* news table with border */.tabnews {	border-width: 1px;	border-style: dashed;	margin:0px; 	padding:0px;	font-size: 10px;	}/*=============================MK  admin cp stylesP=============================*//* admin cp titles with top border */.titadmin {	margin: 0px;	font-size: 11px;	font-weight: bold;	border-width: 1px 0 0 0;	border-style: dashed;}/*=============================MK  font stylesP=============================*//* red error page text */.mkerror {		font-size: 12pt;	color: #ff0000;	font-weight:bold;}/* MKPQuote quotation text *//* .mkquote { 			color: #0000ff;	} *//* MKPGallery module ecard */.ecardtitle {	font-size: 10pt; 	font-weight: bold;	text-align: center;}/* MKPGallery slideshow caption text (modules/gallery/index.php function slide_update) *//* .mkslidecap {		font-family: Verdana, Arial, Helvetica, sans-serif; 	font-size: 12pt; 	font-weight: bold; 	color: #ffffff;} *//*=============================MK  BBcode quote stylesP=============================*/.mkquoteball {	font-size: 9px; 	color: #666666;	font-family: Verdana, Arial, Helvetica, sans-serif;	font-weight: normal;	background-color: #ffffff;		padding: 0;	}.mkquotetext {	font-size: 10px; 	color: #666666;	font-family: Verdana, Arial, Helvetica, sans-serif;	font-weight: normal;	background-color: #ffffff;	margin: 0;	padding: 0;	}table .mkquotetable{					width: auto; /* IE */		text-align: left;}

The only way I could get rid of it was to thank the post again!

[NeutralizeR]

Waiting for a fix again...

[Abe1]

Version 3.2 (2/13/06):

• [FIXED] Fixed another bug with reputation.
• [FIXED] Sped up the one query used to retrieve the thanks.

[Abe1]

Originally Posted by AnhTuanCool

Ahhhhh, I think I've made a terrible mistake here.

I figured out what the problem is that the mixing query I suggested awhile ago actually makes the hack's query time worse. When using multiple WHERE's in query, it queries ALL the entries out of the table and the filter it through the second WHERE. If there are a lot of thanks entries like mine, it tremendously stresses the server. Look at the image I attached above, at column Row and you'll understand why.

So I strongly recommend switch back to the old time query.

$post_thanks_querys = $db->query("SELECT postid FROM ". TABLE_PREFIX ."post WHERE threadid = '$post[threadid]'");
    $post_thanks_postids = 0;
    
    while ($post_thanks_query = $db->fetch_array($post_thanks_querys))
    {
      $post_thanks_postids .= ",$post_thanks_query[postid]";
    }

    $post_thanks_cashe = $db->query("SELECT * FROM " .TABLE_PREFIX. "post_thanks WHERE postid IN ($post_thanks_postids) ORDER BY username ASC");

Lastly, I terribly sorry for suggesting such a flawful mod...

I went back to this BUT, I did not use a query to get the postids. I used the one that vb made already. You should see improvement in the speed.

[Abe1]

Originally Posted by NeutralizeR

Waiting for a fix again...

This update fixes this.

[optrex]

I've got 2.6 - what is the most reliable upgrade proceedure

[The Realist]

Getting this database error when thanks is clicked?

Database error in vBulletin 3.5.3:

Invalid SQL:

		    UPDATE user
		    SET post_thanks_thanked_times = 1 + post_thanks_thanked_times, post_thanks_thanked_posts = 1 + post_thanks_thanked_posts, reputation = $vboptions[post_thanks_reputation] + reputation
		    WHERE userid = 26;

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[post_thanks_reputation] + reputation
		    WHERE userid = 26' at line 2
Error Number : 1064
Date         : Monday, February 13th 2006 @ 02:48:06 PM
Script       : http://www.tech-tronix.com/showthread.php?do=post_thanks&p=3718
Referrer     : 
IP Address   : xx.xx.xx.xxx
Username     : Realist
Classname    : xxxxxxxx

Any ideas?

Laters

[Abe1]

Originally Posted by The Realist

Getting this database error when thanks is clicked?

Database error in vBulletin 3.5.3:

Invalid SQL:

		    UPDATE user
		    SET post_thanks_thanked_times = 1 + post_thanks_thanked_times, post_thanks_thanked_posts = 1 + post_thanks_thanked_posts, reputation = $vboptions[post_thanks_reputation] + reputation
		    WHERE userid = 26;

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[post_thanks_reputation] + reputation
		    WHERE userid = 26' at line 2
Error Number : 1064
Date         : Monday, February 13th 2006 @ 02:48:06 PM
Script       : http://www.tech-tronix.com/showthread.php?do=post_thanks&p=3718
Referrer     : 
IP Address   : xx.xx.xx.xxx
Username     : Realist
Classname    : vb_database

Any ideas?

Laters

Do you have the latest version installed?