The Arcive of Official vBulletin Modifications Site.

Post Thank You Hack 1.10 · **Released**: 12-27-2004

Click here for vBulletin 3.5 version

Post Thank You Hack 1.10

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.

The hack has been tested VERY well, including 5 weeks of beta testing, but I'm only human I can't guaranty there are no problems.

There is a similar hack called 'Automatic Thank You Hack'. That hack only lets you thank the first post of a thread and not just any post. The options in this hack doesn't compare to my hack. It's also unsupportive and was release for an older version of vBulletin.

Features:

Comes with easy installer/updater/uninstaller file
Places an easy to use button next to the edit button
Separate looks for postbit and postbit_legacy
Places all Thank Yous into one small box
[NEW]Uses only ONE query every time you view a showthread page!
Users can't thank twice
Users can't 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 Thank Yous from a single post
Turn on and off hack
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
[NEW]Option to add to post count when someone clicks 'thanks'.
[NEW]Option to give a user who receives thanks reputation points.
Ban Usergroups
Ban Users
Update Counters in ACP (found in 'Import & Maintenance')
Uses Phrases
Guaranteed to be liked by ALL users on your forum!

Installation information on hack:

Files edited: 3
Templates edited: 4
New Phrases: 44 (installer installs them)
New Templates: 2 (installer installs them)
Queries: 15 excluding phase and template queries (installer installs it)
Files to upload: 4
Time to install: between 5-10 minutes

Updates:

Version 1.0 (12/28/04):

Release

Version 1.01 (1/10/05):

[FIX]Templates stay when you upgrade your forum

Version 1.02 (2/22/05):

[NEW]Installer Has Installer for After You Upgrade Your Forum
[NEW]Search for a users thanked posts
[NEW]Search for all thanked posts

Version 1.03 (2/23/05):

[FIX]Turn hack on for only first posts of threads now works

Version 1.10 (5/9/05):

[FIX]Compatibility for vBulletin 3.0.7
[FIX]Reduced the amount of queries need to run this hack every time you view a showthread page to only ONE query. No more 1 to 2 queries per post that comes up.
[FIX]I cached the templates used to save 1 query.
[NEW]Option to add to post count when someone clicks 'thanks'.
[NEW]Option to give a user who receives thanks reputation points.

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
Showing post after 'thanks' (admin view)
Showing post after 'thanks' with legacy posts (admin view)
Stats in member?s profile
Hacks settings
Update counts view

I'll try to get some updated pictures up soon.

Abe1 · #42 01-09-2005, 12:31 PM

Quote:

Originally Posted by TTG

For anyone that has a problem after upgrading to vbulletin 3.0.5. Simply run the installer again and all will then work as intended

I realized there was a problem with the templates when you upgrade. I should be comming out with minor upadte soon to fix that problem for future updates.

Okiewan · #43 01-09-2005, 01:43 PM

Quote:

Database error in vBulletin 4.0.2:

Invalid SQL: INSERT INTO settinggroup VALUES ('post_thanks', 1234, 0)
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Ideas? I do have your Post Award hack installed (and love it!)

Abe1 · #44 01-09-2005, 01:57 PM

Quote:

Originally Posted by Okiewan

Ideas? I do have your Post Award hack installed (and love it!)

you have vbulletin 4.0.2??????

Intex · #45 01-09-2005, 03:28 PM

Abe - It looks like it's because the queries didn't run properly to me. I tried running one of the ones from the install file directly in phpadmin:

Code:

$DB_site->query("INSERT INTO " . TABLE_PREFIX . "setting VALUES ('post_thanks_on_off', 'post_thanks','1','1', 'yesno', 10, 0, 0)");

Produced the following error:

Code:

Error
 
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
 
ERROR: Unknown Punctuation String @ 9
STR: ->
SQL: $DB_site->query("INSERT INTO " . TABLE_PREFIX . "setting VALUES ('post_thanks_on_off', 'post_thanks','1','1', 'yesno', 10, 0, 0)")
SQL-query : 
 
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "setting VALUES ('post_thanks_on_off', 'post_thanks','1','1', 'yesno', 10, 0, 0)") 
 
MySQL said: 
 
 
#1064 - 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 '$DB_site->query("INSERT INTO " . TABLE_PREFIX . "setting VALUES

All the queries where the syntax is using 'INSERT INTO' produce the same problem and these are all related to the settings. The other queries which ALTER tables, such as the 'user' and 'post' run successfully and they're working because it's tracking the amount of thank you's someone has.

Can you see what's wrong with the syntax? I'm running 3.0.1 and mySQL 3.23.49.

Okiewan · #46 01-09-2005, 03:46 PM

Quote:

Originally Posted by Abe1

you have vbulletin 4.0.2??????

LOL... yeah that was a joke for a another board admin. Guess I should change it back. :nervous:

Abe1 · #47 01-09-2005, 04:59 PM

Quote:

Originally Posted by Intex

Abe - It looks like it's because the queries didn't run properly to me. I tried running one of the ones from the install file directly in phpadmin:

Code:

$DB_site->query("INSERT INTO " . TABLE_PREFIX . "setting VALUES ('post_thanks_on_off', 'post_thanks','1','1', 'yesno', 10, 0, 0)");

Produced the following error:

Code:

Error
 
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
 
ERROR: Unknown Punctuation String @ 9
STR: ->
SQL: $DB_site->query("INSERT INTO " . TABLE_PREFIX . "setting VALUES ('post_thanks_on_off', 'post_thanks','1','1', 'yesno', 10, 0, 0)")
SQL-query : 
 
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "setting VALUES ('post_thanks_on_off', 'post_thanks','1','1', 'yesno', 10, 0, 0)") 
 
MySQL said: 
 
 
#1064 - 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 '$DB_site->query("INSERT INTO " . TABLE_PREFIX . "setting VALUES

All the queries where the syntax is using 'INSERT INTO' produce the same problem and these are all related to the settings. The other queries which ALTER tables, such as the 'user' and 'post' run successfully and they're working because it's tracking the amount of thank you's someone has.

Can you see what's wrong with the syntax? I'm running 3.0.1 and mySQL 3.23.49.

I have no copy of v3.0.1. So I can't try. I'll try to fix this in my minor update in a few days.

Abe1 · #48 01-09-2005, 05:01 PM

Quote:

Originally Posted by Okiewan

Ideas? I do have your Post Award hack installed (and love it!)

I'll try to fix this for next version. I hope some time this week.

dacho · #49 01-10-2005, 09:29 AM

did user can 10X to himself ?
if so, how can i repair that ?

Abe1 · #50 01-10-2005, 01:36 PM

Quote:

Originally Posted by dacho

did user can 10X to himself ?
if so, how can i repair that ?

A user can't thank him self.

Abe1 · #51 01-10-2005, 01:42 PM

Version 1.01 released.

Tiny update. When you upgrade your forum, the templates stay.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04833 seconds Memory Usage 2,324KB Queries Executed 25 (?)
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 (4)bbcode_code (7)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 (1)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_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!