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 ***

[djbaxter]

Originally Posted by MikalMirkas

Is this supported on 4.0.3 PL1?

Is it supported on 4.03 PL1? No. That's why it says "Not Supported" up there at the top of the page in the first post.

Does it work on 4.03 PL1? Yes. It works even better if you apply a couple of tweaks mentioned in this thread.

[Golzarion]

Originally Posted by cmeinck

I'm sure I'm not the only one, so would appreciate any help on how to prevent these database errors. As far as I can tell, there are no visible links to "find thanks".

Database error in vBulletin 4.0.3:

Invalid SQL:

            REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
            VALUES (0, '66.249.65.181', 1, 'manic', '', 'post.dateline', 'DESC', 0.12551, 1, '351328,351311,348467,348466,346458,346411,344262,342697,342689', 1274289300, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:118484;s:5:\"manic\";}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\";}}', 'cd78b1a0b7a48890db58b480739e121c');

MySQL Error   : Table 'my_forum.search' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, May 19th 2010 @ 12:15:00 PM
Error Date    : Wednesday, May 19th 2010 @ 12:15:01 PM
Script        : http://www.mysite.com/forum/post_thanks.php?do=findthanks_user_gave&u=118484
Referrer      : 
IP Address    : 66.249.65.181
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

The same problem .... I think it is a bug for this hack on vB 4.0.3 !

[djbaxter]

Originally Posted by cmeinck

I'm sure I'm not the only one, so would appreciate any help on how to prevent these database errors. As far as I can tell, there are no visible links to "find thanks".

Database error in vBulletin 4.0.3:

Invalid SQL:

			REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
			VALUES (0, '66.249.65.181', 1, 'manic', '', 'post.dateline', 'DESC', 0.12551, 1, '351328,351311,348467,348466,346458,346411,344262,342697,342689', 1274289300, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:118484;s:5:\"manic\";}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\";}}', 'cd78b1a0b7a48890db58b480739e121c');

MySQL Error   : Table 'my_forum.search' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, May 19th 2010 @ 12:15:00 PM
Error Date    : Wednesday, May 19th 2010 @ 12:15:01 PM
Script        : http://www.mysite.com/forum/post_thanks.php?do=findthanks_user_gave&u=118484
Referrer      : 
IP Address    : 66.249.65.181
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

Originally Posted by Golzarion

The same problem .... I think it is a bug for this hack on vB 4.0.3 !

This questioned has been asked and answered several times in this thread.

Originally Posted by imagirlgeek

What I did to resolve this was to comment out these lines in post_thanks.php...

PHP Code:

$db->query_write("
   REPLACE INTO " . TABLE_PREFIX . "search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
   VALUES (" . $vbulletin->userinfo['userid'] . ", '" . $db->escape_string(IPADDRESS) . "', 1, '" . $db->escape_string($user['username']) . "', '" . $db->escape_string($forumchoice) . "', 'post.dateline', 'DESC', $searchtime, 1, '" . $db->escape_string(implode(',', $orderedids)) . "', " . TIMENOW . ", '" . $db->escape_string(serialize($display)) . "', '" . $db->escape_string($searchhash) . "')
  ");
  $searchid = $db->insert_id();
 
  $vbulletin->url = 'search.php?' . $vbulletin->session->vars['sessionurl'] . "searchid=$searchid";
  eval(print_standard_redirect('search')); 


I found this query on lines 278 - 285, 413 - 420, and 527 - 534. I commented out all of them 3 days ago and haven't received this error and also haven't seen any adverse effects.

If you don't know how to do those edits, upload the attached corrected post_thanks.php file to the forum root and import the attached corrected product-post_thanks.xml file, making sure you select the "overwrite" option.

To fix the cosmetic (font size) errors, apply the fixes in post_thanks_7_82_improvements.zip, posted earlier in this thread bu attached here for convenience.

[empty2002]

Plz help me
https://vborg.vbsupport.ru/showpost....&postcount=900

[djbaxter]

Originally Posted by empty2002

hey, when I upgrade from 3.8.4 to 4.0.3, then I reinstall this MOD, but I have an error :-s

http://mydomain.com/forum/post_thanks.php?do=post_thanks_add&p=22591&securitytoken=1274514074-1434d6d6da7a61dbd3ee2a933f54435b1bdc3c5c

And I can't rebuilt quantity of thanks!!!
PLZ help me
thx

If you uninstalled this add-on, upgraded, and then reinstalled the vBulletin 4.x version, you probably will lose the previous "thanks" counts.

As for the error, exactly what does the error message say?

[empty2002]

eror 500

[jacobomoya]

Maybe the operation takes too long and your server timeouts?

[kmohamed]

is it possible to have a list with highest thanked threads
via admin panel
i am planing to use this thread for something else ?

[Hippy]

The problem I noticed was in IE7 or IE8 running in compatibility view.
In a private forum when a admin other than yourself was last to post.
the report icon would get pushed out of the comment area and push
the foot a full screen down where it would display that little report post icon..
I have had this mod install for many version and just noticed this debugging a different problem
the fix is as followed

in post_thanks_javascript template
this is the original code

PHP Code:

<script type="text/javascript" src="clientscript/post_thanks.js"></script>

<style type="text/css">
.postbitlegacy .postfoot .textcontrols a.post_thanks_button, .postbit .postfoot .textcontrols a.post_thanks_button  {
    background: url({vb:stylevar imgdir_button}/post_thanks.png) no-repeat transparent {vb:stylevar left};
    padding-{vb:stylevar left}: 20px;
}
.postbitlegacy .postfoot .textcontrols a.post_thanks_button:hover, .postbit .postfoot .textcontrols a.post_thanks_button:hover  {
    background: url({vb:stylevar imgdir_button}/post_thanks-hover.png) no-repeat transparent {vb:stylevar left};

</style> 


I added a } at the end before /style

so it looks like this now

PHP Code:

<script type="text/javascript" src="clientscript/post_thanks.js"></script>

<style type="text/css">
.postbitlegacy .postfoot .textcontrols a.post_thanks_button, .postbit .postfoot .textcontrols a.post_thanks_button  {
    background: url({vb:stylevar imgdir_button}/post_thanks.png) no-repeat transparent {vb:stylevar left};
    padding-{vb:stylevar left}: 20px;
}
.postbitlegacy .postfoot .textcontrols a.post_thanks_button:hover, .postbit .postfoot .textcontrols a.post_thanks_button:hover  {
    background: url({vb:stylevar imgdir_button}/post_thanks-hover.png) no-repeat transparent {vb:stylevar left};
}
</style> 


hope it helps someone out

[sebaldus]

Hi.

I have installed both This hack, Ajax Advance Stats, and Ajax Chat Box.
Get this error code from my forums every day and two -five times each day, now..

Database error in vBulletin 4.0.2:

Invalid SQL:

               SELECT
                       userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
                       IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
                       language.phrasegroup_global AS phrasegroup_global,
                       language.phrasegroup_posting AS phrasegroup_posting,
                       language.phrasegroup_search AS phrasegroup_search,
                       language.phrasegroup_socialgroups AS phrasegroup_socialgroups,
                       language.options AS lang_options,
                       language.languagecode AS lang_code,
                       language.charset AS lang_charset,
                       language.locale AS lang_locale,
                       language.imagesoverride AS lang_imagesoverride,
                       language.dateoverride AS lang_dateoverride,
                       language.timeoverride AS lang_timeoverride,
                       language.registereddateoverride AS lang_registereddateoverride,
                       language.calformat1override AS lang_calformat1override,
                       language.calformat2override AS lang_calformat2override,
                       language.logdateoverride AS lang_logdateoverride,
                       language.decimalsep AS lang_decimalsep,
                       language.thousandsep AS lang_thousandsep

               FROM vb_user AS user
               LEFT JOIN vb_userfield AS userfield ON (user.userid = userfield.userid)
               LEFT JOIN vb_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN vb_language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

               WHERE user.userid = 5;

MySQL Error   : MySQL server has gone away
Error Number  : 2006
Request Date  : Saturday, May 29th 2010 @ 09:38:29 PM
Error Date    : Saturday, May 29th 2010 @ 11:38:31 PM
Script        : http://www.sebaldus.no/ajax.php
Referrer      : http://www.sebaldus.no/forum.php
IP Address    : 85.164.231.112
Username      :
Classname     : vB_Database
MySQL Version :

Do you know what this is?

How I can correct it?
[Script : http://www.sebaldus.no/ajax.php]

Have try to close one and one of those hack, but cant find out what it crash with?
Thanks in Advance.
Regards from Sebaldus