The Arcive of Official vBulletin Modifications Site.

[AJAX] Post Thank You Hack · **Released**: 07-17-2005

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:

Showing the 'thanks' button and stats in Postbit
Showing post after 'thanks' (user view)
Showing post after 'thanks' (admin view)
Showing post after 'thanks' with legacy posts (admin view)
Stats in members profile and link
Link in Search drop down menu
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.

aranthorn · #**312** 12-20-2005, 04:31 PM

Quote:

Originally Posted by AnhTuanCool

Hey, nice hack there you made Abe1. /me clicked installed.

I made a modification to optimize the querying part of the hack as follow:
In plugin Post Thank You Hack at postbit_display_start, I'd changed:

PHP Code:


			
    $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");

Into

PHP Code:


			
    $post_thanks_cashe = $db->query("SELECT post_thanks.* FROM " . TABLE_PREFIX . "post_thanks, " . TABLE_PREFIX . "post WHERE post.postid = post_thanks.postid AND post.threadid = '$post[threadid]'");

It shortened the querying by one query, for some small or moderate boards, it doesn't make any noticeable different. But in any large board, it does help a lot.

You can include the mod if you want. Thanks for great hack!

changed mine over, thanks

masterross · #**313** 12-20-2005, 09:05 PM

Quote:

Originally Posted by AnhTuanCool

Hey, nice hack there you made Abe1. /me clicked installed.

I made a modification to optimize the querying part of the hack as follow:
In plugin Post Thank You Hack at postbit_display_start, I'd changed:

PHP Code:


			
    $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");

Into

PHP Code:


			
    $post_thanks_cashe = $db->query("SELECT post_thanks.* FROM " . TABLE_PREFIX . "post_thanks, " . TABLE_PREFIX . "post WHERE post.postid = post_thanks.postid AND post.threadid = '$post[threadid]'");

It shortened the querying by one query, for some small or moderate boards, it doesn't make any noticeable different. But in any large board, it does help a lot.

You can include the mod if you want. Thanks for great hack!

i've change too but get:
Database error in vBulletin 3.5.2:

Invalid SQL:
SELECT post_thanks.* FROM vb_post_thanks, vb_post WHERE post.postid = post_thanks.postid AND post.threadid = '43120';

MySQL Error : Unknown table 'post_thanks'
Error Number : 1051

AnhTuanCool · #**314** 12-21-2005, 03:20 PM

materros - Replace this line in that same plugin (Post Thank You Hack at postbit_display_start hook location)

PHP Code:


			
$post_thanks_cashe = $db->query("SELECT post_thanks.* FROM " . TABLE_PREFIX . "post_thanks, " . TABLE_PREFIX . "post WHERE post.postid = post_thanks.postid AND post.threadid = '$post[threadid]'");

OR (if you haven't applied the change from post 310 of mine)

PHP Code:


			
 $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");

To

PHP Code:


			
$post_thanks_cashe = $db->query("SELECT " . TABLE_PREFIX . "post_thanks.* FROM " . TABLE_PREFIX . "post_thanks, " . TABLE_PREFIX . "post WHERE post.postid = post_thanks.postid AND post.threadid = '$post[threadid]' ORDER BY " . TABLE_PREFIX . "post_thanks.username ASC");

That should fix it. Good luck

masterross · #**315** 12-22-2005, 05:14 PM

thanks for the update
after applied a little bit different error:

Database error in vBulletin 3.5.2:

Invalid SQL:
SELECT vb_post_thanks.* FROM vb_post_thanks, vb_post WHERE post.postid = post_thanks.postid AND post.threadid = '44699' ORDER BY vb_post_thanks.username ASC;

MySQL Error : Unknown table 'post' in where clause
Error Number : 1109
Date : Thursday, December 22nd 2005 @ 09:10:17 PM

masterross · #**316** 12-22-2005, 05:16 PM

i forgot to tell that i have table prefix - "vb_"

BR,
Ross

Abe1 · #**317** 12-22-2005, 05:17 PM

Quote:

Originally Posted by masterross

thanks for the update
after applied a little bit different error:

Database error in vBulletin 3.5.2:

Invalid SQL:
SELECT vb_post_thanks.* FROM vb_post_thanks, vb_post WHERE post.postid = post_thanks.postid AND post.threadid = '44699' ORDER BY vb_post_thanks.username ASC;

MySQL Error : Unknown table 'post' in where clause
Error Number : 1109
Date : Thursday, December 22nd 2005 @ 09:10:17 PM

Here: Use this.

PHP Code:


			
$post_thanks_cashe = $db->query("SELECT " . TABLE_PREFIX . "post_thanks.* FROM " . TABLE_PREFIX . "post_thanks, " . TABLE_PREFIX . "post WHERE " . TABLE_PREFIX . "post.postid = post_thanks.postid AND " . TABLE_PREFIX . "post.threadid = '$post[threadid]' ORDER BY " . TABLE_PREFIX . "post_thanks.username ASC");

masterross · #**318** 12-22-2005, 09:05 PM

sorry guys...
again prob:

Database error in vBulletin 3.5.2:

Invalid SQL:
SELECT vb_post_thanks.* FROM vb_post_thanks, vb_post WHERE vb_post.postid = post_thanks.postid AND vb_post.threadid = '44699' ORDER BY vb_post_thanks.username ASC;

MySQL Error : Unknown table 'post_thanks' in where clause
Error Number : 1109

masterross · #**319** 12-22-2005, 09:15 PM

i've handled it

)
thanks to Abe1 !

i've added everywhere - " . TABLE_PREFIX . "

and here is the final strings:

$post_thanks_cashe = $db->query("SELECT " . TABLE_PREFIX . "post_thanks.* FROM " . TABLE_PREFIX . "post_thanks, " . TABLE_PREFIX . "post WHERE " . TABLE_PREFIX . "post.postid = " . TABLE_PREFIX . "post_thanks.postid AND " . TABLE_PREFIX . "post.threadid = '$post[threadid]' ORDER BY " . TABLE_PREFIX . "post_thanks.username ASC");

Abe1 · #**320** 12-23-2005, 12:14 AM

Quote:

Originally Posted by masterross

sorry guys...
again prob:

Database error in vBulletin 3.5.2:

Invalid SQL:
SELECT vb_post_thanks.* FROM vb_post_thanks, vb_post WHERE vb_post.postid = post_thanks.postid AND vb_post.threadid = '44699' ORDER BY vb_post_thanks.username ASC;

MySQL Error : Unknown table 'post_thanks' in where clause
Error Number : 1109

Yup, forgot one place.

PHP Code:


			
$post_thanks_cashe = $db->query("SELECT " . TABLE_PREFIX . "post_thanks.* FROM " . TABLE_PREFIX . "post_thanks, " . TABLE_PREFIX . "post WHERE " . TABLE_PREFIX . "post.postid = " . TABLE_PREFIX . "post_thanks.postid AND " . TABLE_PREFIX . "post.threadid = '$post[threadid]' ORDER BY " . TABLE_PREFIX . "post_thanks.username ASC");

lolo? · #**321** 12-27-2005, 10:17 AM

works great thanks for this hack

i have one suggestion
it's possible to bump a thread when a member use the thanks button like a basic answer ?
hum i hope you understand
sorry for my bad english

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.15283 seconds Memory Usage 2,381KB Queries Executed 27 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (9)bbcode_php (4)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!