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 snake-boy

Tried to upgrade as instructed, and when posting a message I get "error in functions_showthread.php"

Now clicking on any post gives me:

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT * FROM award AS award ORDER BY awardid ASC
mysql error: Unknown column 'awardid' in 'order clause'

mysql error number: 1054

Got no errors during the install process, made the file changes with no probems as directed by the installer.

Help?

-snake

You may have edited my hack over another hack. The table 'award' has nothing to do with this hack.

[snake-boy]

I have this hack installed as well:

hxxp://www.vbulletin.org/forum/showthread.php?t=61108

I don't understand how yours could be installed 'over' this one. I had both installed and working perfectly before this upgrade, now I'm stranded with a shut board.

I have tried uninstalling the Thank You hack and reinstalling it from scratch (with the fix you added above). Result stays the same. Clicking on any post gives the error above. Creating a new post, clicking on submit gives the error, but the post DOES appear in the forum if I refresh the forum page, but clicking on the post goes back to this error.

Could you please take a look at the details of the awards hacks and determine if your installer is destroying anything unintentionally. I can't be the only one with both these hacks installed, and it's bound to create a compatibility problem for others too.

Please assist me further.

thanks you

-snake

[Abe1]

Originally Posted by snake-boy

I have this hack installed as well:

hxxp://www.vbulletin.org/forum/showthread.php?t=61108

I don't understand how yours could be installed 'over' this one. I had both installed and working perfectly before this upgrade, now I'm stranded with a shut board.

I have tried uninstalling the Thank You hack and reinstalling it from scratch (with the fix you added above). Result stays the same. Clicking on any post gives the error above. Creating a new post, clicking on submit gives the error, but the post DOES appear in the forum if I refresh the forum page, but clicking on the post goes back to this error.

Could you please take a look at the details of the awards hacks and determine if your installer is destroying anything unintentionally. I can't be the only one with both these hacks installed, and it's bound to create a compatibility problem for others too.

Please assist me further.

thanks you

-snake

I took a look. I think the best would be to get a fresh functions_showthread.php and do both of these hacks file edits. It seems that this error your getting is comming from the award not the thanks.

[BigIke]

Nice work Abe. My members love the addition.

[Abe1]

Originally Posted by bringindaruckus

Nice work Abe. My members love the addition.

Glad to hear that. Just dont forget to click 'install'. Also, the best part about this update is the speed increase when viewing threads. On my forum, I cut the queries down from about 47 to about 15. The speed the page was created went down like 60-70%!

[-=Sniper=-]

Originally Posted by Abe1

in includes/functions_showthread.php
find all the times

PHP Code:

$number_rows 


and replace with

PHP Code:

$nb 


I'll update the zip download in a min. Also, anyone else who installed v1.10 alreadyshould do this.

on doing so the thanked_postbit no longer shows, under the thanked post.

[Abe1]

Originally Posted by -=Sniper=-

on doing so the thanked_postbit no longer shows, under the thanked post.

You have to edit in 3 spots. Make sure you did all 3.

[snake-boy]

Ok, I tried copying over a fresh copy and making the changes as specified, but it does not help at all, as I am still getting the same error each time.

I appreciate your help, but could you please suggest anything else I could try. I'm getting really despirate now I wish I had the php knowledge to be able to be of more help, but I don't know how to do much more than is specfied in the instructions.

Please help.

thank you

-snake

[Abe1]

Originally Posted by snake-boy

Ok, I tried copying over a fresh copy and making the changes as specified, but it does not help at all, as I am still getting the same error each time.

I appreciate your help, but could you please suggest anything else I could try. I'm getting really despirate now I wish I had the php knowledge to be able to be of more help, but I don't know how to do much more than is specfied in the instructions.

Please help.

thank you

-snake

I hope this helps. Let me disect your error.

Invalid SQL: SELECT * FROM award AS award ORDER BY awardid ASC
mysql error: Unknown column 'awardid' in 'order clause'

Unknown column 'awardid' in 'order clause' can only mean that there is no column in the award table that is called awardid.

This seems to be a problem with the award system and you should try re-installing it or something like that. I'm sure if you remove the award hack code from the file you shouldn't get any errors. As you saw when you removed all of my hack you were still getting errors.

If you have phpmyadmin, I can look at your database at see what is missing fromt he award system. You'd have to send me a PM with the info on how to get in.

Other wise, there is nothing I can do.

[-=Sniper=-]

Originally Posted by Abe1

You have to edit in 3 spots. Make sure you did all 3.

thanks