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.
New option: Remove User's Thanks Count When Deleting Post
New phrase: post_thanks_search_user_gave
FIX User reputation level now updates. (Thanks to liwo for this one.)
NEW Added option to view all posts a user has thanked.
FIX Fixed Special Action - Delete All of a Users Thanks
FIX Should have fixed some 'foreach()' errors.
Version 7.3 (03/15/08):
Updated file: functions_post_thanks.php
Updated template: post_thanks_memberinfo_block
Deleted template: post_thanks_memberinfo_css
New option: Choice to use Markup Usernames or not. (Thanks to Namaless)
New option: Ban User from Getting Thanks
New option: Max Thanks a User can Give Per Day
FIX Fixed repeating bug on vb 3.6.7 forums.
CHANGE Changed where the post thanks info shows on the Profile Page. Moved to same box as statistics. (This will require a template edit if you are running vb3.7 beta 2-4)
Version 7.4 (03/21/08):
FIX: Fixed Profile Stats for vb3.7.0 RC1 users.
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:
Showing the 'thanks' button and stats in Postbit
Showing post after 'thanks' (user view)
Showing post after 'thanks' with legacy posts (admin view)
I think I can explain that problem. In reputation.php, not only the reputation points of a user are updated, but also the reputationlevelid. That way, the reputation level of a user is updated instantly. You just give the reputation points, but do not update the reputationlevelid. So if a user gets 1000 reputation points by post thank you hack, but does not get any reputation the normal way, his reputationlevel will not update.
To fix this problem, a minor change to function add_thanks() is sufficent i think
if ($vbulletin->db->affected_rows() != 0)
{
////////////////////////////////////////////////
// BEGIN FIX
////////////////////////////////////////////////
// Query copied from reputation.php
// Determine this user's reputationlevelid.
$reputationlevel = $vbulletin->db->query_first_slave("
SELECT reputationlevelid
FROM " . TABLE_PREFIX . "reputationlevel
WHERE " . ($postinfo['reputation'] + $vbulletin->options['post_thanks_reputation']) . " >= minimumreputation
ORDER BY minimumreputation
DESC LIMIT 1
");
// I do not store the new reputation calculated for the query above and use it here again to avoid a potential race condition
$set_user_got .= ", reputation = " . $vbulletin->options['post_thanks_reputation'] . " + reputation, reputationlevelid = " . intval($reputationlevel['reputationlevelid']);
////////////////////////////////////////////////
// END FIX
////////////////////////////////////////////////
}
}
I hope that small note helps you improving that great hack further!
Invalid SQL:
SELECT * FROM post_thanks WHERE postid IN () ORDER BY 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 username ASC' at line 1 Error Number : 1064
Date : Friday, January 18th 2008 @ 06:25:54 AM
Script : http://www.xxxxx.com/post_thanks.php...sing_ajax=1&p=
Referrer :
IP Address : xx.xx.xx.xxxx
Username : Badger
Classname : vB_Database
Do you know where you are getting this error from? It seems like some is clicking to remove their thanks and the link is not good. The postID is not being sent. Please check the post thanks templates.
Do you know where you are getting this error from? It seems like some is clicking to remove their thanks and the link is not good. The postID is not being sent. Please check the post thanks templates.
Ok, will check.... :up:
I haven't seen another one since I posted the message here ...
How do you change the VIEWS column to show the amount of thanks a thread has?
Because, we all know that the number of views a thread has doesn't mean anything compare to the amount of thanks it has. It would make it easier for users to find old quality threads when surfing the forum.
Can I set an additional 'thanks' button? For "job well done" or some such thing? How do I go about adding a button -- I can do the graphics, but is there a problem with having two "thanks" hacks on a forum?
How do you change the VIEWS column to show the amount of thanks a thread has?
Because, we all know that the number of views a thread has doesn't mean anything compare to the amount of thanks it has. It would make it easier for users to find old quality threads when surfing the forum.
Thanks!
This is a good idea!
However rather than having a forumdisplay column, I would suggest adding icon in the thread title column, ala the rating graphics, that shows up if there is any thanks for any post on the thread with tool tip with "Thread contains x posts that where thanked a total of Y times".
Note that thanks are registered on the post level rather than the thread level. Still it is easy enough to find out if any posts on that thread have been thanked.
[AJAX] Post Thank You Hack Details »»
About Developer
DB Changes 
No support by the author.
01-17-2008, 07:20 PM
