Post Thank You Hack 1.10

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:

1. Showing the 'thanks' button
2. Showing post after 'thanks' (admin view)
3. Showing post after 'thanks' with legacy posts (admin view)
4. Stats in member?s profile
5. Hacks settings
6. Update counts view

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

[Abe1]

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:

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

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]

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]

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

[Abe1]

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]

Version 1.01 released.

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

[Intex]

Thanks Abi1, getting that working would be appreciated, then I can release the hack.

Originally Posted by Abe1

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]

Originally Posted by Intex

Thanks Abi1, getting that working would be appreciated, then I can release the hack.

I sent you a PM about this error.

[TTG]

Just ran the update to 1.01 and the hack stopped working .. click on "thanks" and nothing happens !?

[Abe1]

Originally Posted by TTG

Just ran the update to 1.01 and the hack stopped working .. click on "thanks" and nothing happens !?

do you a template that is not a child of templateid 1?

[Abe1]

For now you can add these templates.

post_thanks_postbit

$spacer_open
<div style="padding:0px 0px $stylevar[cellpadding]px 0px">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="alt2" style="padding:0px">
<if condition="$nb == 1"><strong><phrase 1="User Says" 2="$post[username]">$vbphrase[post_thanks_users_say]</phrase></strong>
<else /><strong><phrase 1="$post[post_thanks_amount] Users Say" 2="$post[username]">$vbphrase[post_thanks_users_say]</phrase></strong></if>
</td>
<if condition="$bbuserinfo[usergroupid] == 6"><td class="alt2" style="padding:0px" align="right">
<a href="post_thanks.php?do=post_thanks_remove&p=$post[postid]">$vbphrase[post_thanks_remove]</a>
</td></if>
</tr>
<tr><td class="alt1" colspan="2"><div>$liste_user</div></td></tr>
</table>
</div>
$spacer_close

post_thanks_postbit_legacy

$spacer_open
<div style="padding:0px 0px $stylevar[cellpadding]px 0px">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="0" border="0" width="100%" align="center">
<tr valign="top">
<td class="alt2" width="175">
<if condition="$nb == 1"><strong><phrase 1="User Says" 2="$post[username]">$vbphrase[post_thanks_users_say]</phrase></strong>
<else /><strong><phrase 1="$post[post_thanks_amount] Users Say" 2="$post[username]">$vbphrase[post_thanks_users_say]</phrase></strong></if>
<if condition="$bbuserinfo[usergroupid] == 6"><br><a href="post_thanks.php?do=post_thanks_remove&p=$post[postid]">$vbphrase[post_thanks_remove]</a></if>
</td>
<td class="alt1">
<div>$liste_user</div>
</td>
</tr>
</table>
</div>
$spacer_close

[TTG]

Thanks Abe1 .. that worked.

Great support

[Abe1]

Originally Posted by TTG

Thanks Abe1 .. that worked.

Great support

Thanks.

I hope to come up wait a sollution for the install soon. Anyone else that has a problems with the templats not installing should add them manualy. Look up 2 posts.

[PcCopat]

can i use this hack with hide hack? can the member who thanks for the post, see the hidden content? u see, i thank for the post and c the hidden content? is this possible? i know it is, cause i saw this in other boards. sorry for my english. it's not so good.

[mindbuster]

How could i make it so the person getting thanked would recieve reputation too ?
Like one added reputation for each thank you he gets ?

[The Realist]

Im not getting the thank you box to show under the posts?

Any ideas?

WORKING NOW:

Deinstalled hack, reinstalled and noticed the install file does not install the templates so I manually added them.

Thanks.