The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
[AJAX] Post Thank You Hack Details »» | |||||||||||||||||||||||||
Post Thank You Hack 4.5 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. Features:
Version 2.0 GOLD (10/02/05):
Version 2.7 (12/18/05):
Version 2.8 (2/5/06):
Version 2.9 (2/8/06):
Version 3.0 (2/10/06):
Version 3.1 (2/11/06):
Version 3.2 (2/13/06):
Version 3.3 (2/14/06):
Version 3.4 (3/17/06):
Version 4.0 (4/17/06):
Version 4.1 (4/18/06):
Version 4.2 (4/23/06):
Version 4.3 (5/4/06):
Version 4.4 (5/7/06):
Version 4.5 (6/19/06):
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:
Show Your Support
|
Comments |
#482
|
|||
|
|||
and i have the same error when click THANKS:
Quote:
|
#483
|
||||
|
||||
Version 3.1 (2/11/06):
|
#484
|
||||
|
||||
|
#485
|
||||
|
||||
Quote:
Time Before: 0.13631 seconds Time After: 0.13647 seconds Time Taken: 0.00016 seconds |
#486
|
||||
|
||||
Ahhhhh, I think I've made a terrible mistake here.
I figured out what the problem is that the mixing query I suggested awhile ago actually makes the hack's query time worse. When using multiple WHERE's in query, it queries ALL the entries out of the table and the filter it through the second WHERE. If there are a lot of thanks entries like mine, it tremendously stresses the server. Look at the image I attached above, at column Row and you'll understand why. So I strongly recommend switch back to the old time query. Code:
$post_thanks_querys = $db->query("SELECT postid FROM ". TABLE_PREFIX ."post WHERE threadid = '$post[threadid]'"); $post_thanks_postids = 0; while ($post_thanks_query = $db->fetch_array($post_thanks_querys)) { $post_thanks_postids .= ",$post_thanks_query[postid]"; } $post_thanks_cashe = $db->query("SELECT * FROM " .TABLE_PREFIX. "post_thanks WHERE postid IN ($post_thanks_postids) ORDER BY username ASC"); |
#487
|
|||
|
|||
For some reason, as soon as I enable this product, my server load spike up to 10-20... why is that?
I have a lot of members online (around 200 at the same time) and a lot of thanked posts. I'm using the latest version. As soon as I disable this, server load goes back to normal (1-3). |
#488
|
|||
|
|||
Can't remove thanks.
Quote:
Quote:
|
#489
|
|||
|
|||
Quote:
Thanks, I've revert it back toversion 2.5 and the server load seems to be less than 3-4 now Before it was 20-30 edit: nvm.. it's fluctuating now.. going around 6-15 |
#490
|
||||
|
||||
@dai-kun - Did you delete this line in the hook?
Code:
$post_thanks_cashe = $db->query("SELECT " . TABLE_PREFIX . "post_thanks.* FROM " . TABLE_PREFIX . "post_thanks, " . TABLE_PREFIX . "post WHERE " . TABLE_PREFIX . "post.postid = " . TABLE_PREFIX . "post_thanks.postid AND " . TABLE_PREFIX . "post.threadid = '$post[threadid]' ORDER BY " . TABLE_PREFIX . "post_thanks.username ASC"); |
#491
|
|||
|
|||
Ok so how would I do this? Do I edit out that code in the 3.0 version? I tried that and it giving me errors.
Cam on. PHP Code:
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|