Show Thread Enhancements - [AJAX] Post Thank You Hack

Post Thank You Hack

STAFF EDIT:
Note - The mod author has been unreachable for some time, but the vbulletin.org community has stepped up to provide a number of individual fixes over the years. ForceHSS, Hippy, and Seven Skins have all combined many of these fixes into product files.

ALL CREDIT STILL GOES TO ABE1 And this is still 'his' mod. Please still mark the mod as installed if you use any version of it.

That said so you don't need to apply a dozen + small fixes yourself you should consider downloading one of the updated packages below:

Hippy has one in this post.

AND / OR

ForceHSS has one in this post.

AND/OR

Seven Skins has one in this post.


- Original File Specs: post_thanks_7_82.zip (26.4 KB, 24844 downloads) - Original file removed, replaced with patched files including search fix (some admins noticed hackers attempting to use outdated code to exploit search in attempt to gain administrator password or similar).
- There are five total patched versions available, some with and without the search fix - I've replaced the main file with the patched versions... please be sure to download and install the correct version, the main mod post contains links to additional information and patched files!
- If Abe1 returns he can request these packages be removed.


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 guaranteed 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: 0
• Files to upload: 8
• Time to install: 1 minute max

Updates:


Version 7.80 (12/30/09):

• Release of this hack for vBulletin version 4.0

Version 7.81 (01/02/10):

• Fixed some install and uninstall database errors.
• Made styling for postbit legacy a little better.
• Fixed the "separator" issue.
• Javascript file updated.

Version 7.82 (01/03/10):

• Fixed info alignment issues in the postbit for custom edited phrases.

NOTE: *** Offer for paid services removed ***

[garretbyrne]

Hi War.Frog yep issue now solved.. weird alright, lol

[KristerSwe]

[Question]

Can i use this on the forumpart on a vB4 Publishing Suite

Thanks..

[ProFifaLeagues]

Loved this hack on 3.8 so will give it a try!

[War.Frog]

Originally Posted by garretbyrne

Hi War.Frog yep issue now solved.. weird alright, lol

Weird. Well how frustrating...I tried your method and no go! Seems like a lot of hoops to jump through to eliminate that refresh issue and most aren't working.

I'm hoping Abe can figure out why it's refreshing like that and why it's leaping back to the first page in the thread. Sigh.

[RoteRose]

Hello,

a bug occurs:

Database error in vBulletin 4.0.0:

Invalid SQL:
SELECT * FROM vb3_post_thanks AS post_thanks INNER JOIN vb3_user AS user USING (userid) WHERE post_thanks.postid IN () ORDER BY post_thanks.username ASC;

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 ') ORDER BY post_thanks.username ASC' at line 1
Error Number  : 1064
Request Date  : Sunday, January 10th 2010 @ 03:07:10 AM
Error Date    : Sunday, January 10th 2010 @ 03:07:10 AM
Script        : http://<<url>>/private.php?do=showpm&pmid=59086
Referrer      : http://<<url>>/private.php
Classname     : vB_Database

I got this bug in 2 days over 150times, please fix.

[Abe1]

Originally Posted by Darkimmortal

Database error in vBulletin 4.0.0:

Invalid SQL:

			REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
			VALUES (0, '208.115.111.243', 1, 'shadiku', '', 'post.dateline', 'DESC', 0.00032, 1, '45371', 1262569673, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:205;s:7:\"shadiku\";}s:6:\"forums\";i:0;s:7:\"options\";a:3:{s:11:\"starteronly\";i:0;s:11:\"childforums\";i:1;s:6:\"action\";s:7:\"process\";}}', '93ba3cebb32266d635fc1600bc5fabbe');

MySQL Error   : Table 'forum.search' doesn't exist
Error Number  : 1146
Request Date  : Monday, January 4th 2010 @ 01:47:53 AM
Error Date    : Monday, January 4th 2010 @ 01:47:53 AM
Script        : http://www.gamingmasters.co.uk/post_thanks.php?do=findthanks&u=205
Referrer      : 
IP Address    : 208.115.111.243
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

Database error in vBulletin 4.0.0:

Invalid SQL:

			REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
			VALUES (0, '208.115.111.243', 1, 'shadiku', '', 'post.dateline', 'DESC', 0.00021, 1, '45432,45054,44755', 1262569654, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:205;s:7:\"shadiku\";}s:6:\"forums\";i:0;s:7:\"options\";a:3:{s:11:\"starteronly\";i:0;s:11:\"childforums\";i:1;s:6:\"action\";s:7:\"process\";}}', 'aa2cf5c6dd7ff757d6f63558e8453e9b');

MySQL Error   : Table 'forum.search' doesn't exist
Error Number  : 1146
Request Date  : Monday, January 4th 2010 @ 01:47:34 AM
Error Date    : Monday, January 4th 2010 @ 01:47:34 AM
Script        : http://www.gamingmasters.co.uk/post_thanks.php?do=findthanks_user_gave&u=205
Referrer      : 
IP Address    : 208.115.111.243
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

No-where in this hack is the link to this any more. You must have left a link somewhere to search for thanked posts.

[RoteRose]

Is it possible to add an option for a thx button in every post if i use the option to thank only in first post. Hm bad text, i mean, i would like have the thanks button in every post but the thanks will only appear in Post 1.

[Abe1]

Originally Posted by exyuteam

I have this "problem" (see Capture.png). If someone not see, BLOG ENTRIES - 1 need to be in one line.. Not number 1 up, and text down You can see what I meen...

Problem is here:

<dd style="white-space: nowrap; display: inline; float: right;">

Please fix this. Maybee not using float - juts add text in next line..... ?

Thanks for great hack!!!!

Will be fixed in next version.

[Abe1]

Originally Posted by War.Frog

Strange - I was playing with this again tonight on my test forum and when I entered a multi-page thread, jumped to a later page (page 11 in this case) and clicked on Thanks, the URL changed back to the first page of the thread!?

So, e.g. on page 11 of the thread: http://www.example.com/vb4test/showt...-thread/page11

...the /page11 is stripped off and I'm brought back to the first page. I have the most up-to-date version of this hack installed.

Anyone else reporting such a problem?

[Abe1]

Originally Posted by MrKramer

I got this database error:

PHP Code:

Database error in vBulletin 4.0.0:
 
Invalid SQL:
 
            REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
            VALUES (0, '81.167.x.xxx', 1, 'icey', '', 'post.dateline', 'DESC', 0.91864, 1, '1709', 1262778281, 'a:6:{s:5:"words";a:0:{}s:9:"highlight";a:0:{}s:6:"common";a:0:{}s:5:"users";a:1:{i:615;s:4:"icey";}s:6:"forums";i:0;s:7:"options";a:3:{s:11:"starteronly";i:0;s:11:"childforums";i:1;s:6:"action";s:7:"process";}}', '1f9934b83b2cd7905cad1ae232f6d7da');
 
MySQL Error   : Table 'forum.search' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, January 6th 2010 @ 06:44:41 AM
Error Date    : Wednesday, January 6th 2010 @ 06:44:43 AM
Script        : http://www.vind-het-met-rapidlinks.com/post_thanks.php?do=findthanks_user_gave&u=615
Referrer      : 
IP Address    : 81.167.x.xxx
Username      : Niet geregistreerd
Classname     : vB_Database
MySQL Version : 


Do i now have to uninstall whole product and get a fresh install? but what if i dont wanna lose al thankes?

Go check if you have manual edits. This has nothing to do with the current version. You may have an old link still.