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

[Nook_Neformat]

Thanks a lot, man!

[n00bl3t]

I tried asking this on DBtechs Post Thank you mod because that is the mod I have installed however he replied saying that it is your mod. I am really confused and I just need an answer and help. I originally posted this:

I'm having bit of a problem and I don't know if should post here or create a new thread...

Basically I am getting a report just from one user, no one else, saying that every time he tries to go to the forums page; he receives a database error. Now I keep receiving emails about it since I get an email every time a database error occurs. This is what he see's and I receive:

Database error in vBulletin 4.1.4:

Invalid SQL:

                       SELECT userid, usergroupid, displaygroupid, username, posts, post_thanks_thanked_times
                       FROM user AS user
                       WHERE post_thanks_thanked_times > '0' AND user.usergroupid NOT IN (17, 3)
                       ORDER BY post_thanks_thanked_times DESC
                       LIMIT 0, 10;

MySQL Error   : Unknown column 'post_thanks_thanked_times' in 'field list'
Error Number  : 1054
Request Date  : Monday, November 14th 2011 @ 08:08:31 PM
Error Date    : Monday, November 14th 2011 @ 08:08:31 PM
Script        : http://www.MYWEBSITE.com/forum.php
Referrer      :
IP Address    : ***.***.***.***
Username      : USERNAME
Classname     : vB_Database
MySQL Version : 5.1.56

The stuff in red I just made red to indicated what I changed in the error to protect identity. The rest is directly what I and him received.

Now I am replying here because the error mentions post_thanks_thanked_times so my first thought is that it is an error relating to this script/mod. HOWEVER I don't think this script/mod is interfering with anything because I actually temporarily disabled the entire mod in plugins manager and he was still receiving the database error. He said it first started when he received a notification that he received a Like/Thanks and when he clicked the notification it happened. Basically he can see the home page; his profile, and all other pages EXCEPT for the /forum.php area; so basically the forums is the only area he can't access and when he tries he gets this error. Basically I made him register a new account and everything is working fine now on his new account however I feel like I should still bring this up because he has over 500 posts and I feel it kinda sucks to see or have him just kinda restart...

So my questions are

1) Does anyone know what is up with this?

2) Is this related or tied into this plugin/mod and any way to fix? It is strange to see only this 1 person is having this problem.


Thanks for the feedback!

I just had another user run into this problem and now both are unable to get into the forums section.

[ForceHSS]

Originally Posted by n00bl3t

I tried asking this on DBtechs Post Thank you mod because that is the mod I have installed however he replied saying that it is your mod. I am really confused and I just need an answer and help. I originally posted this:



I just had another user run into this problem and now both are unable to get into the forums section.

the error is not from dbtech thanks plugin it is from the plugin from this post just take the one from my sig install the uninstall making sure you remove all files from the ftp. If you have already removed the plugin then remove all files from the ftp and mysql tables

[n00bl3t]

Originally Posted by ForceHSS

the error is not from dbtech thanks plugin it is from the plugin from this post just take the one from my sig install the uninstall making sure you remove all files from the ftp. If you have already removed the plugin then remove all files from the ftp and mysql tables

How do I find the mysql tables?

Much appreciated! Thanks.

[Hippy]

phpmyadmin or you can use the compare mod for admincp

Table and Field Comparison Utility: Compare your database to out-of-the-box vBulletin

[n00bl3t]

Originally Posted by Hippy

phpmyadmin or you can use the compare mod for admincp

Table and Field Comparison Utility: Compare your database to out-of-the-box vBulletin

I'm sorry I should have been more clear; could you possibly walk me through or quickly give the steps to finding the tables. I know it is within PHPmyadmin but I have 0 experience in that area unfortunately.

[Hippy]

search the xml file.. for the tables added then search for them in your DB via phpmyadmin..
but you can do it easy wit hthat mod I posted it will show all tables not stock to vb and you can pick out the post thank ones and kill them there..

if you want install that mod and pm me details and I will do it for you..

[ForceHSS]

you can also use navicat to login to see all the tables this would be the easy option but you can only do that if your servername does not say locolhost check config for that info if it does not I can help you with that pm me if you need help

[Videx]

Personally I would just leave the old tables alone. Nothing is calling them and it's not like they're taking up a lot of space (?).

[thenamesgould]

Originally Posted by Videx

Then you must have neglected to uninstall it properly. You've left one or more of the uploaded files on your server.

Thanks Videx ... I stupidly ALWAYS forget to delete the uploaded files when I uninstall a mod! Cleaned them up (as well as a few from another mod I removed) and it's all fixed.

THANKS!!!