[AJAX] Post Thank You Hack

[Qatif]

A wonderful addition

Regards

[desirulez]

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in [path]/post_thanks.php on line 57

i got this error couple of times is it because im using 4.0.2?

[Gursimran]

it is giving me this error whenever someone hits thanks

Database error in vBulletin 4.0.2:

Invalid SQL:

REPLACE INTO vb_search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
VALUES (0, '216.129.119.44', 1, 'kamena', '', 'post.dateline', 'DESC', 0.02024, 1, '68244,67192,65715,65241,64400,63989,63672,63579,6 3461,63445,63440,63356', 1270133814, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:7721;s:6:\"kamena\";}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\";}}', 'b670002f01f717b90617aa618d41fef3');

MySQL Error : Table '*****.vb_search' doesn't exist
Error Number : 1146
Request Date : Thursday, April 1st 2010 @ 08:26:54 PM
Error Date : Thursday, April 1st 2010 @ 08:26:54 PM
Script : http://******/forum/post_thanks.php?do=findthanks&u=7721
Referrer :
IP Address : 216.129.119.44
Username : Unregistered
Classname : vB_Database
MySQL Version :

[badawidollah]

you here to bro gursimran

[buontaiviem]

it is giving me this error whenever someone hits thanks

got this error too :(

[Gursimran]

you here to bro gursimran

yep :P

[Julie]

Thanks for upgrading this to 4.0! :) *upgrades*

[bruschetta]

it is giving me this error whenever someone hits thanks

I solved this mod:

https://vborg.vbsupport.ru/showpost.php?p=1958396&postcount=396

using notepad++ you put a second

[djbaxter]

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

$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.

Hope this helps!

Thank you. Trying this now.

To make it easier for others, if you want to try this fix, I've attached the the revised post_thanks.php file. Save a backup of the old one and upload this new one to the root directory for your forum.

[Vaira]

Abe1,

I would like to thank you for it. It's a really great addition to my forums!

I have installed it and running 4.0.2 PL4. There are no major issues.
I can confirm that it runs fine. I don't have another mod installed, so nothing could interfere with.

Some minor issues I could resolve with the useful info posted at this thread.

I know you are busy and I would like to use your hack all the time. Therefore I would like to know if you are still supporting this version and if you have planned to add a search function to it as well to make it complete.

A short reply about would be nice.

Thanks again. :)

Vaira (Yen)

[grc]

Hopefully, we'll get a complete upgraded version of this mod someday soon, but till then I'll mention that I stumbled upon a workaround, sort of, that fills in the missing thanks search capability. Come to think of it, I may be the only person who didn't know this!

Anyway, if you turn on the vB reputation system and have the Thanks mod set up to give a reputation point for thanks, users can click on "Settings" and see which of their posts have been "thanked."

The reputation system defaults to showing only the five most recent reputation boosts they've received but you can increase that to whatever number you want.

Our users have been disappointed that they can't find their "thanks" and this workaround restores that to some limited functionality.

[PamelaE]

Can this be altered so its a groan mod? I prefer groaning to thanking.

[djbaxter]

I prefer groaning to thanking.

What an admission! :eek:

Comic book guy on The Simpsons: "No groaning in my store!"

[Vaira]

Hopefully, we'll get a complete upgraded version of this mod someday soon, but till then I'll mention that I stumbled upon a workaround, sort of, that fills in the missing thanks search capability. Come to think of it, I may be the only person who didn't know this!

Anyway, if you turn on the vB reputation system and have the Thanks mod set up to give a reputation point for thanks, users can click on "Settings" and see which of their posts have been "thanked."

The reputation system defaults to showing only the five most recent reputation boosts they've received but you can increase that to whatever number you want.

Our users have been disappointed that they can't find their "thanks" and this workaround restores that to some limited functionality.

Thanks for that great idea.

[robbiefritz]

Hopefully, we'll get a complete upgraded version of this mod someday soon, but till then I'll mention that I stumbled upon a workaround, sort of, that fills in the missing thanks search capability. Come to think of it, I may be the only person who didn't know this!

Anyway, if you turn on the vB reputation system and have the Thanks mod set up to give a reputation point for thanks, users can click on "Settings" and see which of their posts have been "thanked."

The reputation system defaults to showing only the five most recent reputation boosts they've received but you can increase that to whatever number you want.

Our users have been disappointed that they can't find their "thanks" and this workaround restores that to some limited functionality.

Many thanks for this. Our members have been asking about this since we upgraded to 4.0

[Vaira]

Hi again.

It seems that one question is still unanswered and asked by others as well.

How can I make the font of the entire users (and date) that have thanked, listed at the box below of the post, smaller?
I have tried to analyse it with firebug, but wasn't able to manage it by myself.

If I could make it smaller to gain space would be nice.

Anybody?

Thanks in advance.

[War.Frog]

Hi again.

It seems that one question is still unanswered and asked by others as well.

How can I make the font of the entire users (and date) that have thanked, listed at the box below of the post, smaller?
I have tried to analyse it with firebug, but wasn't able to manage it by myself.

If I could make it smaller to gain space would be nice.

Anybody?

Thanks in advance.

This solution by grc worked well for me: https://vborg.vbsupport.ru/showpost.php?p=1986809&postcount=560

[Gursimran]

Thanks djbaxter for the file

[Vaira]

This solution by grc worked well for me: https://vborg.vbsupport.ru/showpost.php?p=1986809&postcount=560

Yes, sure it affects the: "The Following X Users Say Thank You to YZ For This Useful Post:" line only. (As described by grc.)

My question was about the font size of all listed users that have thanked! (All user names and dates in the box.)

Still unresolved?

Any solution?

Thanks.

[grc]

Yes, sure it affects the: "The Following X Users Say Thank You to YZ For This Useful Post:" line only. (As described by grc.)

My question was about the font size of all listed users that have thanked! (All user names and dates in the box.)

Still unresolved?

Any solution?

Thanks.

When I made the edits I described it also changed the font size of the users who are listed on my forum. Are you perhaps talking about the horizontal screen real estate taken up by the usernames plus the dates? You might consider just turning off the dates. So far as our forum users are concerned I don't think the date is all that important. In fact, I doubt they even know that that option is available since I've never activated it.

[TheGorf]

I am repeatedly getting this error in my forums:

Database error in vBulletin 4.0.2:

Invalid SQL:

REPLACE INTO vb_search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
VALUES (0, '173.160.151.225', 1, 'Hugs & Hisses', '', 'post.dateline', 'DESC', 0.00521, 1, '82076,81918,80565,80397,79291,78669,78659,78334,7 7976,77744,77266,76845,76782,76717,76494,76449,764 45,76304,75850,75787,75386,75385,74770,74633,73678 ,73162,73035,72371,72230,71802,71394,70338,69937,6 8475,67925,66787,66205,66188,66098,64710,64644,642 96,64069,63850,63826,63627,63545,63493,63487,63411 ,63202,62754,62329,61424,60658,60652,59645', 1270507241, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:813;s:17:\"Hugs & Hisses\";}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\";}}', 'ba678b6b15c81aac30e8c7c52ddb73a8');

MySQL Error : Table 'pnwhs_forums.vb_search' doesn't exist
Error Number : 1146
Request Date : Monday, April 5th 2010 @ 03:40:41 PM
Error Date : Monday, April 5th 2010 @ 03:40:41 PM
Script : http://forums.pnwhs.org/post_thanks.php?do=findthanks&u=813
Referrer :
IP Address : 173.160.151.225
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :

I see quite clearly where it is coming from. Line 278 of post_thanks.php is the file that has that SQL query and is part of the IF block that has the do=findthanks. However this script also generates the error for do=findthanks_user_gave as well. If I go look in the vB database there is no "search" table. Anyone have any idea why this is?

*edit*
Ok I see that this is a common error in this hack and that the best solution appears to be this:
https://vborg.vbsupport.ru/showpost.php?p=1958396&postcount=396

However, why am I commenting out dozens of lines of code? Is this actually broken then? Abe1 would you care to comment on this?

[War.Frog]

However, why am I commenting out dozens of lines of code? Is this actually broken then? Abe1 would you care to comment on this?

Abe1 has gone MIA I'm afraid.

[djbaxter]

However, why am I commenting out dozens of lines of code? Is this actually broken then? Abe1 would you care to comment on this?

You are commenting out the lines that are involved in the search function, which has never worked for 4.02.

See https://vborg.vbsupport.ru/showpost.php?p=2014885&postcount=760

[Vaira]

When I made the edits I described it also changed the font size of the users who are listed on my forum. Are you perhaps talking about the horizontal screen real estate taken up by the usernames plus the dates? You might consider just turning off the dates. So far as our forum users are concerned I don't think the date is all that important. In fact, I doubt they even know that that option is available since I've never activated it.

Thanks. I have turned off the date. Anyway I would like to know how to make the font size of the listed user smaller......your 'hack' affects definetively the headline, not what's listed in the box!

[grc]

Thanks. I have turned off the date. Anyway I would like to know how to make the font size of the listed user smaller......your 'hack' affects definetively the headline, not what's listed in the box!

I guess I changed the font of the user's name elsewhere, possibly not related to this hack of the thanks mod. I was thinking the usernames were changed when I did the hack. I reversed it on my forum and I see that the usernames stayed the same, smaller size.

Frankly, I can't remember how I did it but I think its somewhere in the Style Variable Editor. Sorry for the misdirection.

[TheGorf]

So now I find that with this mod, a user deleting their own thanks gets a permission denied error, but the thanks still gets deleted.

The block of code is on about line 116 and starts:

if ($_REQUEST['do'] == 'post_thanks_remove_user')
{
($hook = vBulletinHook::fetch_hook('post_thanks_main_remove _user_thanks_start')) ? eval($hook) : false;

if (!(delete_thanks($postinfo, $vbulletin->userinfo['userid'])))
{
$using_ajax ? exit : print_no_permission();
}

So I altered the logic in that block and removed the bang from infront of delete_thanks() and it works fine now. Another bug in this hack... *sigh*

Oh and while we are on the subject, is anyone else having problems with this hack using AJAX? No matter what options I select adding or removing a Thanks causes a full page refresh.

[Kolbi]

Can´t reproduce these issues..

[Antonio Pereira]

Inside a Thread if a try Inline Mod (Select All) only select a first post.

Anyone can reproduce this bug?

Best Regards

[mad@Max]

Mostly for developer.
Some improvements with js for OOP: one namespace, autoset events, less size.
Would be even better if the hack work with xml :)

[Antonio Pereira]

Mostly for developer.
Some improvements with js for OOP: one namespace, autoset events, less size.
Would be even better if the hack work with xml :)

This fix that bug?
Inside a Thread if a try Inline Mod (Select All) only select a first post.

Anyone can reproduce this bug?

Best Regards


Best Regards

[mad@Max]

Inside a Thread if a try Inline Mod (Select All) only select a first post.

Anyone can reproduce this bug?

Best Regards
In template post_thanks_box delete unnecessary class postbitim, it needed for inline moderation.

[Julie]

In template post_thanks_box delete unnecessary class postbitim, it needed for inline moderation.

Thanks!

[grc]

Mostly for developer.
Some improvements with js for OOP: one namespace, autoset events, less size.
Would be even better if the hack work with xml :)

Can you do anything to return search capability to the mod?

[djbaxter]

Mostly for developer.
Some improvements with js for OOP: one namespace, autoset events, less size.
Would be even better if the hack work with xml :)

This modification contains references to both post_thanks.js and post_thanks2.js but there is no file named post_thanks2.js.

[mad@Max]

You can remove it from template i forgot did it myself.
Can you do anything to return search capability to the mod?
I don't know, there is difficult with search criteria...

[Antonio Pereira]

In template post_thanks_box delete unnecessary class postbitim, it needed for inline moderation.

<li class="postbit<vb:if condition="$vboptions['legacypostbit']">legacy</vb:if> postbitim" id="post_thanks_box_{vb:raw post.postid}"<vb:if condition="!$post_thanks_box == 1"> style="display:none"</vb:if>>
{vb:raw post_thanks_box}
</li>

Hi can you explain?

Best Regards

[mad@Max]

Like that
<li class="postbit<vb:if condition="$vboptions['legacypostbit']">legacy</vb:if>" id="post_thanks_box_{vb:raw post.postid}"<vb:if condition="!$post_thanks_box == 1"> style="display:none"</vb:if>>
{vb:raw post_thanks_box}
</li>

[FractalizeR]

Looks like developer just keeps hack alive and that's all.

[Diablotic]

That's a shame. It is one of the best mods around but the developer is gone :(

[s0lidgr0und]

I'd assume the developer has more important things going on in his life than keeping a free modification up to date.

If it's not something you guys want to worry about, uninstall it.

[Vaira]

Like that
<li class="postbit<vb:if condition="$vboptions['legacypostbit']">legacy</vb:if>" id="post_thanks_box_{vb:raw post.postid}"<vb:if condition="!$post_thanks_box == 1"> style="display:none"</vb:if>>
{vb:raw post_thanks_box}
</li>

Thanks for that. :)

[Furcal15]

How can I make it so in the profile we can see "Find all thanked posts by this user" "Find all post that were thanked" just like the 3.8 version.

[TonicWater]

How can I make it so in the profile we can see "Find all thanked posts by this user" "Find all post that were thanked" just like the 3.8 version.

i am asking the same but nobody is answering...

[grc]

i am asking the same but nobody is answering...

Check out item number 2 in the very first post of this thread.

[djbaxter]

Check out item number 2 in the very first post of this thread.

I believe you mean "in the second post", i.e., post #2 at https://vborg.vbsupport.ru/showpost.php?p=1942292&postcount=2

[grc]

I believe you mean "in the second post", i.e., post #2 at https://vborg.vbsupport.ru/showpost.php?p=1942292&postcount=2

That's fine, but I think you'll find that it's the first post.

[djbaxter]

That's fine, but I think you'll find that it's the first post.

No. It may be the first REPLY but it's the second post, aka post #2.

[grc]

No. It may be the first REPLY but it's the second post, aka post #2.

My final post on the topic - would you mind providing me a link to the first post?

[djbaxter]

My final post on the topic - would you mind providing me a link to the first post?

Sure:

First Post (https://vborg.vbsupport.ru/showthread.php?t=231666) (aka the OP or thread starter)

Second Post (https://vborg.vbsupport.ru/showpost.php?p=1942292&postcount=2) (notice how the URL even says "postcount=2" and how it is labelled "#2"?)

[grc]

Sure:

First Post (https://vborg.vbsupport.ru/showthread.php?t=231666) (aka the OP or thread starter)

Second Post (https://vborg.vbsupport.ru/showpost.php?p=1942292&postcount=2) (notice how the URL even says "postcount=2" and how it is labelled "#2"?)

Perhaps you somehow have a different view that I do, are you telling me you see a post that is labeled #1?

What I see is that the first post is labeled #2. When I said it is the first post in the thread, I mean that it's the first post. I didn't say the post labeled #1 - just that it's the first post.

I take it you actually see a post prior to #2?

Sorry to everyone for the off topic posts...but it has me curious now.

[djbaxter]

Perhaps you somehow have a different view that I do, are you telling me you see a post that is labeled #1?

What I see is that the first post is labeled #2. When I said it is the first post in the thread, I mean that it's the first post. I didn't say the post labeled #1 - just that it's the first post.

I take it you actually see a post prior to #2?

Sorry to everyone for the off topic posts...but it has me curious now.

Yes, of course I see a post prior to #2: the original post or thread starter as I said above. And you see it to. Now please stop being obtuse and derailing the thread any further. I corrected you because I went to the first post looking for that "point 2" mentioned in your post and of course it wasn't there - because "point 2" is in POST #2, i.e., THE SECOND POST.

[grc]

Yes, of course I see a post prior to #2: the original post or thread starter as I said above. And you see it to. Now please stop being obtuse and derailing the thread any further. I corrected you because I went to the first post looking for that "point 2" mentioned in your post and of course it wasn't there - because "point 2" is in POST #2, i.e., THE SECOND POST.

Sorry to be "obtuse." I wanted to give you every opportunity to explain your need to correct me when it's obvious that my instructions were perfectly good. Apparently, for some reason, you can't admit that post #2 is the first post in the thread. Perhaps if you don't feel obligated to do another post insulting me the thread won't be derailed any farther. However, if you just have to, go ahead and insult me again. Maybe it will feed your ego or whatever is going on here.

[War.Frog]

Ironically, we need both a THANKS and a GROAN button activated in this thread. Too bad the developer has run for the hills.

[grc]

Ironically, we need both a THANKS and a GROAN button activated in this thread. Too bad the developer has run for the hills.

My apologies for my part in it.

By the way, for those looking for search capabilities - the vB4 version of this mod doesn't have search capabilities.

There is a sort of workaround - I posted about it here (https://vborg.vbsupport.ru/showpost.php?p=2015769&postcount=762).

[steve1966]

4) If you want to move the Thanx button to near the edit post button,
open template postbit
find

HTML Code:
{vb:raw template_hook.postbit_controls}and move it under

HTML Code:
<span class="postcontrols">

this causes an overlap when using vb4.03

[nikki712]

On the bottom line, where it tells how many times Ii've been thanked, there's a problem. Instead of this line being aligned to the left, it's aligned to the right. How do I fix this? Anyone else have this problem?

[Mastergumble]

Lets see if Abe appear with solutions, i have disabled it atm waiting for valid fixes, just hope to see Abe working on it, if not i hope he give permission to other coder keep this awesome module alive.

[Sunka]

Like that
<li class="postbit<vb:if condition="$vboptions['legacypostbit']">legacy</vb:if>" id="post_thanks_box_{vb:raw post.postid}"<vb:if condition="!$post_thanks_box == 1"> style="display:none"</vb:if>>
{vb:raw post_thanks_box}
</li>


If I do that, I can not save template because this error (old <if condition>)

adding child to non-existent node!

What to do!

[Fungsten]

I installed it and it's not showing up at all. Anyone else had this?

[wayne.richards@]

Really cant see how so many people have has so many problems with this hack! Running it in 4.0.3 with no problems at all! my members love it!

Was wondering if there was a way to make the hack add to the forum posts total as well as the users post total?

[Fungsten]

Was wondering if there was a way to make the hack add to the forum posts total as well as the users post total?

Ditto. (But I still can't get it to work.)

On Edit:

Oooops! Just got it to work!!

[wayne.richards@]

I Edited The Reply A Bit To Suit The Forum Type, I Found That When Members Get "Thanks" They Feel Appriciated And Post More! Best Hack For VB Ever!

https://vborg.vbsupport.ru/external/2010/04/44.jpg

[Vaira]

:up:If I do that, I can not save template because this error (old <if condition>)



What to do!


Delete the entire contents of template post_thanks_box and copy in entire code of code box...

@all: This hack is great and working at 4.0.3. If you read this thread closely you'll be able to fit it for your needs.:)

[Bravo]

When people use the search for thanks post, They get a db error stating that MySQL Error : Table 'xxxxx.search' doesn't exist.

Database error in vBulletin 4.0.2:

Invalid SQL:

REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)

MySQL Error : Table 'xxxxx.search' doesn't exist
Error Number : 1146

Script: /post_thanks.php?do=findthanks&u=1234

Happens like 20 times a day or so

Any Ideas?

Thanks

[djbaxter]

When people use the search for thanks post, They get a db error stating that MySQL Error : Table 'xxxxx.search' doesn't exist.


Database error in vBulletin 4.0.2:

Invalid SQL:

REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)

MySQL Error : Table 'xxxxx.search' doesn't exist
Error Number : 1146

Script: /post_thanks.php?do=findthanks&u=1234

Happens like 20 times a day or so

Any Ideas?

Thanks

Reported many times. There is NO search capability in this version yet. That code is left over from a previous version.

[Bravo]

Reported many times. There is NO search capability in this version yet. That code is left over from a previous version.

Ahh, Ok.

[grc]

Ahh, Ok.

There is a sort of workaround using the reputation system. I posted about it here (https://vborg.vbsupport.ru/showpost.php?p=2015769&postcount=762).

[Sunka]

:up:
Delete the entire contents of template post_thanks_box and copy in entire code of code box...



Thank you, it is working now! :D

Another question... how to make thanks box smaller (it is too high when you have 1-5 thanks in there (usernames)

[MarekJan]

Datenbankfehler 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, '216.129.119.42', 1, 'Ivonne', '', 'post.dateline', 'DESC', 0.05864, 1, '70300,70124,70114,70080,70071,70067,70066,70061,6 6249,51134', 1271223879, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:1972;s:6:\"Ivonne\";}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\";}}', 'b9a494bd475d19b2263813af5581cbb2');

MySQL-Fehler : Table 'xxxxxxxxx.search' doesn't exist
Fehler-Nr. : 1146
Fehler-Zeit : Wednesday, 14.04.2010 @ 07:44:39
Datum : Wednesday, 14.04.2010 @ 07:44:40
Skript : http://www.xxxxxxxxxxxxxxx.de/board/post_thanks.php?do=findthanks_user_gave&u=1972
Referrer :
IP-Adresse : 216.129.119.42
Benutzername : Unregistriert
Klassenname : vB_Database
MySQL-Version :

sorry I do not speak English, therefore I could read the topic nich. me can someone will exactly explain like I this error? thank you very much

Transelted babelfish yahoo :)
Marek

[pmk_1992]

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 (1, '123.18.242.208', 1, 'fox.luv', '', 'post.dateline', 'DESC', 0.02314, 1, '11589,10950,8048', 1271248697, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:193;s:7:\"fox.luv\";}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\";}}', '9e55a48faff1882a5973d0fc89e33c1c');

MySQL Error : Table 'XXXXX.search' doesn't exist
Error Number : 1146
Request Date : Wednesday, April 14th 2010 @ 07:38:17 AM
Error Date : Wednesday, April 14th 2010 @ 07:38:17 AM
Script : post_thanks.php?do=findthanks&u=193
Referrer :
IP Address : 123.18.242.208
Username : pmk_1992
Classname : vB_Database
MySQL Version : 5.0.90-community-log

[dtommy79]

Hi,

I'm trying to edit my post bit infos and put them in a table. Check this image:

https://vborg.vbsupport.ru/external/2010/04/47.png

I managed to do it with all of them except the "Thanked 230 Times in 146 Posts" part.

I'm trying to edit the "post_thanks_postbit_info" template but i can't figure out how to do it. For the "Thanks" part I used a class called "postbitinfo_table" like this:


<vb:if condition="$post['userid']">
<div class="postbitinfo_table"><dt>{vb:rawphrase post_thanks_thanks}</dt> <dd>{vb:raw post.post_thanks_user_amount_formatted}</dd></div>

<vb:if condition="$post['post_thanks_thanked_times'] == 1">
<dd style="white-space:nowrap; display:inline; float: {vb:stylevar left};">{vb:rawphrase post_thanks_time_post}</dd>
<vb:elseif condition="$post['post_thanks_thanked_posts'] == 1" />
<dd style="white-space:nowrap; display:inline; float: {vb:stylevar left};">{vb:rawphrase post_thanks_times_post, {vb:raw post.post_thanks_thanked_times_formatted}}</dd>
<vb:else />
<dd style="white-space:nowrap; display:inline; float: {vb:stylevar left};">{vb:rawphrase post_thanks_times_posts, {vb:raw post.post_thanks_thanked_times_formatted}, {vb:raw post.post_thanks_thanked_posts_formatted}}</dd>
</vb:if>
</vb:if>



can anyone suggest how I could finish it?

Thanks

[Bravo]

There is a sort of workaround using the reputation system. I posted about it here (https://vborg.vbsupport.ru/showpost.php?p=2015769&postcount=762).

I already had done this, but I keep getting emails from people getting the same databases, it's starting to get annoying receiving so many...

[encryption]

I have a similar problem to the post before last, my Thank you text is dislodged. Any idea how I can fix this?

(See attachment)

[Diablotic]

Any idea how I can fix this?
Yes, read this thread.

[wayne.richards@]

I have a similar problem to the post before last, my Thank you text is dislodged. Any idea how I can fix this?

(See attachment)

See Here................

https://vborg.vbsupport.ru/showpost.php?p=1966241&postcount=449

[encryption]

Yes, read this thread.

aren't you the sharp one in the shed, if my add would let me read through 55 pages or even 825 posts, I wouldn't have posted here would I ;)

[twista46]

Works not in 4.0.3

Hide Content is not show when i click the thanks button,

Post Reply its works :confused:

[Diablotic]

aren't you the sharp one in the shed, if my add would let me read through 55 pages or even 825 posts, I wouldn't have posted here would I ;)

OK, you have to:

in post_thanks_postbit_info template, look for {vb:stylevar right} and replace with {vb:stylevar left}

[twista46]

Works not in 4.0.3

Hide Content is not show when i click the thanks button,

Post Reply its works

Any can help me?

[grc]

So folks, is "Not Supported" as this mod is now designated

an automatic thing that happens when the coder is no longer posting updates or is it
a designator that is added if the author checks some box off saying he or she isn't going to support it any more?

[tiga2]

Everything works fine but im trying to figure out since 6 hours already how to change

ex. "Thanked 2 Times in 2 Posts" to simply "Thanked 2"

cause the 2Posts are useless information for me.. hope some has a solution...

[War.Frog]

So folks, is "Not Supported" as this mod is now designated

an automatic thing that happens when the coder is no longer posting updates or is it
a designator that is added if the author checks some box off saying he or she isn't going to support it any more?


Abe1 came back yesterday around 10:30 p.m. EST to update the status of this mod to "unsupported". He may have moved on to other interests.

I'm hoping he considers releasing this mod to the community to update.

EDIT: I just PM'd him asking him to consider opening his mod(s) to the vB.org community, waiving his copyright, or allowing for additional coders to have update authorization. I really hope he considers these moves.

[hoadiem]

AdminCp>Styles & Templates>Style Manager>Postbit

Now find this in postbit

{vb:raw template_hook.postbit_controls}

Highlight it, copy it and delete it.

Now find this bit in postbit

<span class="postcontrols">

and press enter after it and paste the first one.


<div class="postfoot">
<div class="textcontrols">
<span class="postcontrols">
{vb:raw template_hook.postbit_controls}
<img style="display:none" id="progress_{vb:raw post.postid}" src="{vb:stylevar imgdir_misc}/progress.gif" alt="{vb:rawphrase loading_editor_please_wait}" />
<vb:if

didn't work for me please help , vb4.0.3

[grc]

Everything works fine but im trying to figure out since 6 hours already how to change

ex. "Thanked 2 Times in 2 Posts" to simply "Thanked 2"

cause the 2Posts are useless information for me.. hope some has a solution...

Go to AdminCP>Languages and Phrases>Search in Phrases

Search for: Times in

You should find two instances of it, both related to this mod.

You'll want to edit both of them.

[racharx]

This works perfectly for my 4.0.3 site.

How would I go about making the actual box that says "The Following Users Say thank you..." a bit smaller? it's quite large right now height-wise.

Does anyone know where to find the code to adjust the height?

[b6gm6n]

failed on 3.8... works, but you press the thanks button and a large window opens up with all the css of my forum in, you can just close it and thats it... and carry on thanking...or pressing the button, i should of checked this out more, waste of my f*cking time again.

[grc]

failed on 3.8... works, but you press the thanks button and a large window opens up with all the css of my forum in, you can just close it and thats it... and carry on thanking...or pressing the button, i should of checked this out more, waste of my f*cking time again.

You really should have checked it out more since this mod isn't for 3.8.

[djbaxter]

failed on 3.8... works, but you press the thanks button and a large window opens up with all the css of my forum in, you can just close it and thats it... and carry on thanking...or pressing the button, i should of checked this out more, waste of my f*cking time again.

You really should have checked it out more since this mod isn't for 3.8.

Yes, it's amazing what taking a few minutes to actually read the instructions and the thread can do, isn't it? :)

[b6gm6n]

Don't have a go at me for this failed mod... the link in the ACP for this mod go's to this thread and this isn't the 3.8 forum is it?

[djbaxter]

Don't have a go at me for this failed mod... the link in the ACP for this mod go's to this thread and this isn't the 3.8 forum is it?

Try https://vborg.vbsupport.ru/showthread.php?t=165673

[Dave-M]

This works perfectly for my 4.0.3 site.

How would I go about making the actual box that says "The Following Users Say thank you..." a bit smaller? it's quite large right now height-wise.

Does anyone know where to find the code to adjust the height?

Did you manage to find out about this? :)

[giorgino]

I hope for future support... :(

[FractalizeR]

Anyone have the function of finding all thanked posts working without database errors?

[grc]

Anyone have the function of finding all thanked posts working without database errors?

Abe never implemented it in the 4.x version of the hack. A work around is posted here:
https://vborg.vbsupport.ru/showpost.php?p=2015769&postcount=762

[jacobomoya]

I upgraded my forum to VB4 along with the Post Thank You plugin, however, since then, pressing the Thanks button refreshes the page (as it was suggested as a source of this problem, I'll say that I don't have and never had the Post Groan plugin installed), any ideas why could this be happening?

[riskofficer]

Where can you edit the padding size of the Thanks box below each post?
I've got the same question, default table too big, and default font too huge.

Developer Last Online: Jan 2010

How long does a mod sit without support before it is declared abandoned?
Why is this mod not supported now? Whats wrong?

[grc]

I take it that this mod now becomes frozen and will become useless as vB is advanced. Is that correct?

[djbaxter]

I take it that this mod now becomes frozen and will become useless as vB is advanced. Is that correct?

Not necessarily.

For one thing, I am still using some 3.6 mods in 4.x. Some required minor tweaking but they still work. For another, if Abe isn't able to fix bugs, I'm confident others will take over that role. This is a popular mod so it's unlikely the vBulletin peer community will let it die.

[KHALIK]

Super Moderators unable to view who thanked them "username of thanker" under CP Settings.

This only occured once the vb was updated to version 4.0.3

[Weeds]

You spelled the note pad wrong Instructions maybe fix it to next version :)

[Mastergumble]

The mod is currently unsupported and without reusable code...

Maybe some one got the permissions to keep this alive but so far no info at all.

[popcornic]

I've got the same question, default table too big, and default font too huge.


Why is this mod not supported now? Whats wrong?

I'd also like to know how to change/reduce the size of the font in the
"The Following X Users Say Thank You to Y For This Useful Post:"

Once there are several thanks in one page it becomes a nuisance.

[djbaxter]

Change font size (https://vborg.vbsupport.ru/showpost.php?p=1986809&postcount=560 ):

In post_thanks_postbit find:

<h2 class="<vb:if condition="!$vboptions['legacypostbit']">post</vb:if>title">

If you're using the legacy (vertical) postbit template: change the word "title" to "bitlegacy"

Otherwise change the word "title" to "content".


Align Left (https://vborg.vbsupport.ru/showthread.php?p=1993250#post1993250 ):

Below is what I have in my post_thanks_postbit_info file and we've no alignment issues anymore

You want to set the 3 lines to be {vb:stylevar left}

<vb:if condition="$post['userid']">
<dt>{vb:rawphrase post_thanks_thanks}</dt> <dd>{vb:raw post.post_thanks_user_amount_formatted}</dd>
<vb:if condition="$post['post_thanks_thanked_times'] == 1">
<dd style="white-space:nowrap; display:inline; float: {vb:stylevar left};">{vb:rawphrase post_thanks_time_post}</dd>
<vb:elseif condition="$post['post_thanks_thanked_posts'] == 1" />
<dd style="white-space:nowrap; display:inline; float: {vb:stylevar left};">{vb:rawphrase post_thanks_times_post, {vb:raw post.post_thanks_thanked_times_formatted}}</dd>
<vb:else />
<dd style="white-space:nowrap; display:inline; float: {vb:stylevar left};">{vb:rawphrase post_thanks_times_posts, {vb:raw post.post_thanks_thanked_times_formatted}, {vb:raw post.post_thanks_thanked_posts_formatted}}</dd>
</vb:if>
</vb:if>

[popcornic]

Thanks but I've already tried the change to "title"/"bitlegacy" and it's not a good solution for me.

I wanted to know if there's any way to make the changes more flexible, for example:

- Smaller font that is bold
- Different color
- Different font (Times, Calibri, Verdana etc.)

[popcornic]

Thanks but I've already tried the change to "title"/"bitlegacy" and it's not a good solution for me.

I wanted to know if there's any way to make the changes more flexible, for example:

- Smaller font that is bold
- Different color
- Different font (Times, Calibri, Verdana etc.)

Bump :confused:

[vikris]

Anyone have the function of finding all thanked posts working without database errors?

I hope this will be worked up. The workaround posted: https://vborg.vbsupport.ru/showpost.php?p=2015769&postcount=762 is with very limited functionality :(

[grc]

I hope this will be worked up. The workaround posted: https://vborg.vbsupport.ru/showpost.php?p=2015769&postcount=762 is with very limited functionality :(

I agree. When I stumbled upon the workaround I hoped it was very temporary.

I'm not a coder and when I looked at Abe's code for the search function I could tell what was going on, but trying to modify it to work with vB4 is way beyond my capability.

I hope someone will be interested in continuing this project. It's one of the top ranked mods on vb.org and it's a real shame to see it go away.

[War.Frog]

Abe1 is back and has released some new mods, so hopefully he'll revisit this for fixes.

[Dave-M]

Does anyone know how to make the "thanked by" box smaller? I've done the fixes in this thread to make the font smaller and not bold, but the box is still mahoosive!

Thanks.

[Abe1]

Abe1 is back and has released some new mods, so hopefully he'll revisit this for fixes.

Yes, I am back ... at least for now. Every time I looked at the search code vb has now, I curse them out. vB, has totally re-written most of it's code. Not just the search, but almost every part of the code is a mess. Everything use to be so clean and neat. Now everything is all over the place and written on a level that most PHP developers would need hours to understand.

Will the search come back? I dont know. I blocked out the old search which doesn't work now and when I'm in an already bad mood, maybe i'll take another peak.

I release some of my other hacks so I can get my feet wet. Hopefully it will work.

[tini_lam]

welcome back abe1 :)

[grc]

Will the search come back? I dont know. I blocked out the old search which doesn't work now and when I'm in an already bad mood, maybe i'll take another peak.


Welcome back Abe. Good to see you!

[FractalizeR]

Yes, I am back ... at least for now. Every time I looked at the search code vb has now, I curse them out. vB, has totally re-written most of it's code. Not just the search, but almost every part of the code is a mess. Everything use to be so clean and neat. Now everything is all over the place and written on a level that most PHP developers would need hours to understand

Welcome back!
I agree, VB4 code quality looks lower, than of VB3. Code begins to be hard to understand...

[dilbert]

Welcome back, and please know that your mods and the time you spend developing them is greatly appreciated.

[Don Z.]

I have a user that shows 4,294,967,295 thank yous. What is the best way to rebuild the thank you DB so this is corrected?

I'm still running 7.7. This is a great hack.

[mhme]

Welcome back Abe1 :)

[popcornic]

Good to see you Abe1, looking forward to your updates and fixes :D

[Bravo]

Yes, I am back ... at least for now. Every time I looked at the search code vb has now, I curse them out. vB, has totally re-written most of it's code. Not just the search, but almost every part of the code is a mess. Everything use to be so clean and neat. Now everything is all over the place and written on a level that most PHP developers would need hours to understand.

Will the search come back? I dont know. I blocked out the old search which doesn't work now and when I'm in an already bad mood, maybe i'll take another peak.

I release some of my other hacks so I can get my feet wet. Hopefully it will work.

Was the package updated for the blocking of the old search? still shows v7.82

I'm tired of getting hundreds of database error emails about the search function.

[Abe1]

Was the package updated for the blocking of the old search? still shows v7.82

I'm tired of getting hundreds of database error emails about the search function.
Why do you still have links linking to it?

[syrn]

i think 4.0.3 have already this hack , am i right ???

[thesun103]

I followed the instruction at all. Everything worked great except the button, anybody help me to fix it please :(:(

Thank you so much !

[MonkYZ]

Can you please add an option for "No Thanks" or "Thumbs down" ? Something to be the exact reverse of Thanks... because it seems everyone is abusing Thanks on my forum, but bad comments can't be rated. It would be really great to be able to rate down a post.

Thank you in advance and keep up the good work ! This is probably the most used mod on my forum :)

[Dr House]

I received this error.
Do you know why?
How can i protect my forum?
Thanks

Database error in vBulletin 4.0.3:

Invalid SQL:

REPLACE INTO chsearch (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
VALUES (0, '67.195.112.181', 1, '', '', 'post.dateline', 'DESC', 0.28908, 1, '320156,320155,320150,320140,320137,320134,320129, 320121,320084,320076,320074,320066,320065,320058,3 20056,320044,320042,320027,320019,320018,320010,32 0002,319975,319970,319951,319937,319936,319924,319 917,319915,319913,319909,319908,319907,319904,3199 01,319899,319887,319875,319861,319860,319857,31984 0,319833,319826,319825,319821,319819,319814,319800 ,319797,319786,319785,319767,319762,319759,319758, 319753,319752,319748,319744,319742,319741,319739,3 19738,319734,319732,319731,319730,319729,319728,31 9727,319726,319724,319719,319716,319715,319714,319 713,319710,319709,319708,319707,319706,319703,3196 93,319692,319691,319690,319689,319688,319685,31968 4,319683,319682,319681,319680,319679,319663,319643 ,319641,319640,319639,319638,319637,319636,319622, 319618,319609,319607,319600,319594,319572,319569,3 19567,319564,319559,319549,319548,319542,319540,31 9537,319528,319525,319509,319504,319501,319492,319 491,319487,319482,319480,319478,319477,319475,3194 72,319470,319469,319467,319466,319463,319462,31946 0,319456,319453,319452,319441,319420,319411,319396 ,319395,319392,319391,319390,319389,319386,319384, 319382,319379,319377,319376,319374,319367,319365,3 19363,319361,319360,319359,319354,319352,319351,31 9292,319291,319264,319222,319198,319188,319187,319 186,319181,319177,319174,319170,319169,319165,3191 64,319163,319162,319161,319159,319156,319153,31915 2,319150,319147,319142,319127,319125,319110,319109 ,319105,319090,319089,319088,319074,319061,319051, 319046,319045,319013,318999,318997,318995,318994,3 18988,318987,318986,318984,318983,318975,318969,31 8968,318961,318959,318955,318935,318933,318931,318 930,318921,318920,318917,318916,318915,318914,3189 11,318909,318903,318902,318900,318898,318896,31889 4,318893,318884,318881,318880,318879,318875,318874 ,318872,318871,318868,318862,318858,318841,318836, 318834,318826,318825,318818,318810,318804,318798,3 18791,318750,318745,318744,318737,318736,318710,31 8702,318680,318670,318665,318653,318652,318642,318 635,318633,318632,318612,318609,318607,318605,3186 03,318602,318601,318600,318598,318593,318592,31859 1,318590,318588,318587,318586,318584,318579,318575 ,318574,318571,318569,318568,318551,318545,318544, 318542,318537,318535,318530,318529,318520,318518,3 18507,318505,318501,318499,318497,318496,318494,31 8493,318488,318485,318484,318482,318481,318479,318 478,318477,318474,318473,318466,318432,318426,3184 23,318389,318387,318383,318379,318376,318367,31835 3,318350,318348,318347,318336,318326,318313,318310 ,318305,318304,318298,318291,318283,318279,318277, 318270,318269,318265,318264,318263,318262,318261,3 18254,318253,318252,318245,318238,318230,318228,31 8226,318224,318221,318182,318179,318176,318157,318 148,318144,318137,318135,318112,318109,318108,3181 06,318105,318097,318094,318092,318089,318088,31808 7,318086,318085,318084,318083,318080,318078,318075 ,318064,318063,318062,318054,318053,318051,318047, 318043,318038,318027,318025,318024,318017,318014,3 18013,318008,318007,318005,318000,317999,317998,31 7995,317993,317991,317985,317984,317977,317975,317 974,317969,317968,317967,317966,317965,317959,3179 58,317954,317952,317951,317944,317938,317937,31793 6,317934,317932,317930,317929,317927,317926,317924 ,317923,317909,317896,317867,317866,317856,317839, 317821,317813,317811,317810,317808,317807,317806,3 17804,317799,317793,317790,317789,317786,317785,31 7784,317782,317776,317773,317771,317766,317763,317 759,317757,317755,317746,317745,317744,317738,3177 36,317735,317727,317726,317725,317724,317721,31771 5,317710,317709,317708,317700,317697,317696,317694 ,317693,317684,317682,317681,317680,317678,317677, 317676,317674,317673,317671,317669,317668,317667,3 17661,317660,317658,317652,317651,317650,317638,31 7629,317628,317626,317612,317611,317610,317609,317 607,317606,317605,317603,317602,317600,317599,3175 98,317596,317594,317592,317590,317589,317587,31758 4,317577,317573,317571,317569,317568,317567,317566 ,317564,317562,317560,317556,317555,317553,317549, 317547,317530,317525,317521,317518,317516,317514,3 17512,317508,317507,317505,317485,317472,317450,31 7446,317443,317433,317401,317392,317391,317383,317 377,317366,317365,317359,317357,317354,317352,3173 50,317346,317347,317330,317329,317327,317325,31731 8,317316,317315,317314,317311,317308,317305,317301 ,317300,317296,317295,317293,317292,317290,317289, 317288,317279,317274,317268,317266,317260,317258,3 17257,317256,317248,317247,317245,317244,317241,31 7240,317239,317237,317235,317234,317232,317231,317 230,317229,317220,317217,317216,317214,317213,3172 09,317208,317207,317205,317203,317202,317201,31719 9,317197,317195,317193,317189,317179,317174,317170 ,317167,317153,317151,317150,317149,317148,317141, 317132,317125,317119,317111,317110,317109,317108,3 17106,317104,317103,317101,317100,317097,317096,31 7095,317094,317092,317086,317084,317081,317075,317 070,317069,317067,317063,317060,317059,317055,3170 54,317052,317044,317028,317023,317020,316994,31697 6,316974,316972,316943,316942,316941,316935,316933 ,316931,316927,316926,316925,316924,316919,316910, 316907,316858,316847,316846,316845,316844,316835,3 16825,316824,316821,316818,316817,316814,316811,31 6810,316809,316808,316807,316806,316805,316802,316 801,316800,316799,316794,316791,316790,316778,3167 75,316769,316767,316766,316764,316762,316760,31675 8,316751,316744,316736,316734,316723,316707,316704 ,316693,316685,316682,316681,316668,316667,316665, 316664,316662,316648,316646,316644,316641,316640,3 16631,316623,316624,316622,316613,316602,316601,31 6594,316589,316586,316585,316570,316564,316560,316 559,316551,316550,316548,316543,316538,316526,3165 25,316523,316522,316521,316519,316518,316514,31651 3,316512,316511,316510,316509,316508,316506,316504 ,316503,316501,316495,316489,316486,316479,316476, 316475,316473,316466,316465,316464,316462,316461,3 16459,316456,316452,316451,316449,316448,316447,31 6445,316444,316429,316427,316424,316420,316419,316 418,316416,316415,316414,316406,316405,316404,3164 03,316400,316395,316394,316391,316389,316388,31638 2,316381,316379,316378,316377,316375,316374,316373 ,316372,316364,316362,316358,316350,316335,316332, 316331,316325,316316,316314,316309,316306,316303,3 16301,316298,316297,316287,316285,316282,316279,31 6277,316275,316274,316272,316270,316267,316264,316 263,316262,316261,316255,316254,316253,316252,3162 42,316239,316225,316222,316217,316216,316214,31621 2,316210,316209,316207,316205,316203,316201,316199 ,316198,316197,316193,316192,316191,316185,316174, 316165,316161,316160,316159,316152,316149,316138,3 16136,316135,316126,316125,316124,316122,316121,31 6114,316108,316106,316105,316103,316102,316101,316 100,316099,316098,316091,316083,316065,316063,3160 41,316035,316024,316016,316003,315997,315995,31599 4,315988,315986,315984,315983,315981,315980,315979 ,315935,315930,315921,315918,315914,315907,315896, 315894,315887,315882,315878,315865,315864,315863,3 15861,315840,315836,315835,315830,315829,315828,31 5827,315823,315815,315813,315808,315807,315800,315 799,315797,315795,315794,315792,315786,315782,3157 79,315777,315773,315772,315769,315767,315761,31576 0,315758,315757,315756,315748,315744,315739,315737 ', 1273491048, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{s:0:\"\";N;}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\";}}', 'a38cb59aec7edf7bd7a37cfc4d61c38a');

MySQL Error : Table 'mysqlserver.chsearch' doesn't exist
Error Number : 1146
Request Date : Monday, May 10th 2010 @ 01:30:48 PM
Error Date : Monday, May 10th 2010 @ 01:30:49 PM
Script : http://www.myforum.it/forum/post_thanks.php?do=findallthanks
Referrer :
IP Address : 67.195.112.181
Username : Non registrato
Classname : vB_Database
MySQL Version :

[heugabel]

same here.

[redfox2010]

look the alignment of thanks... Why i have this error?

tnx

[inziva]

I switched to vb4, but the hack no longer works. Once I activate the hack, is in the wrong topic "of the service is not available" what to do?

[anthracite]

I get the following error when trying to use the "Delete All of a Users Thanks" from Admin cp:

could not find phrase 'post_thanks_delete_all_users_thanks_successfully'

Using VB 4.0.3

[x626xblack]

Installed on vb 4.0.3 and works fine. No errors no issues.

Thanks Abe1!

[sontran]

I received this error.
Do you know why?
How can i protect my forum?
Thanks

Database error in vBulletin 4.0.3:

Invalid SQL:

REPLACE INTO chsearch (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
VALUES (0, '67.195.112.181', 1, '', '', 'post.dateline', 'DESC', 0.28908, 1, '320156,320155,320150,320140,320137,320134,320129, 320121,320084,320076,320074,320066,320065,320058,3 20056,320044,320042,320027,320019,320018,320010,32 0002,319975,319970,319951,319937,319936,319924,319 917,319915,319913,319909,319908,319907,319904,3199 01,319899,319887,319875,319861,319860,319857,31984 0,319833,319826,319825,319821,319819,319814,319800 ,319797,319786,319785,319767,319762,319759,319758, 319753,319752,319748,319744,319742,319741,319739,3 19738,319734,319732,319731,319730,319729,319728,31 9727,319726,319724,319719,319716,319715,319714,319 713,319710,319709,319708,319707,319706,319703,3196 93,319692,319691,319690,319689,319688,319685,31968 4,319683,319682,319681,319680,319679,319663,319643 ,319641,319640,319639,319638,319637,319636,319622, 319618,319609,319607,319600,319594,319572,319569,3 19567,319564,319559,319549,319548,319542,319540,31 9537,319528,319525,319509,319504,319501,319492,319 491,319487,319482,319480,319478,319477,319475,3194 72,319470,319469,319467,319466,319463,319462,31946 0,319456,319453,319452,319441,319420,319411,319396 ,319395,319392,319391,319390,319389,319386,319384, 319382,319379,319377,319376,319374,319367,319365,3 19363,319361,319360,319359,319354,319352,319351,31 9292,319291,319264,319222,319198,319188,319187,319 186,319181,319177,319174,319170,319169,319165,3191 64,319163,319162,319161,319159,319156,319153,31915 2,319150,319147,319142,319127,319125,319110,319109 ,319105,319090,319089,319088,319074,319061,319051, 319046,319045,319013,318999,318997,318995,318994,3 18988,318987,318986,318984,318983,318975,318969,31 8968,318961,318959,318955,318935,318933,318931,318 930,318921,318920,318917,318916,318915,318914,3189 11,318909,318903,318902,318900,318898,318896,31889 4,318893,318884,318881,318880,318879,318875,318874 ,318872,318871,318868,318862,318858,318841,318836, 318834,318826,318825,318818,318810,318804,318798,3 18791,318750,318745,318744,318737,318736,318710,31 8702,318680,318670,318665,318653,318652,318642,318 635,318633,318632,318612,318609,318607,318605,3186 03,318602,318601,318600,318598,318593,318592,31859 1,318590,318588,318587,318586,318584,318579,318575 ,318574,318571,318569,318568,318551,318545,318544, 318542,318537,318535,318530,318529,318520,318518,3 18507,318505,318501,318499,318497,318496,318494,31 8493,318488,318485,318484,318482,318481,318479,318 478,318477,318474,318473,318466,318432,318426,3184 23,318389,318387,318383,318379,318376,318367,31835 3,318350,318348,318347,318336,318326,318313,318310 ,318305,318304,318298,318291,318283,318279,318277, 318270,318269,318265,318264,318263,318262,318261,3 18254,318253,318252,318245,318238,318230,318228,31 8226,318224,318221,318182,318179,318176,318157,318 148,318144,318137,318135,318112,318109,318108,3181 06,318105,318097,318094,318092,318089,318088,31808 7,318086,318085,318084,318083,318080,318078,318075 ,318064,318063,318062,318054,318053,318051,318047, 318043,318038,318027,318025,318024,318017,318014,3 18013,318008,318007,318005,318000,317999,317998,31 7995,317993,317991,317985,317984,317977,317975,317 974,317969,317968,317967,317966,317965,317959,3179 58,317954,317952,317951,317944,317938,317937,31793 6,317934,317932,317930,317929,317927,317926,317924 ,317923,317909,317896,317867,317866,317856,317839, 317821,317813,317811,317810,317808,317807,317806,3 17804,317799,317793,317790,317789,317786,317785,31 7784,317782,317776,317773,317771,317766,317763,317 759,317757,317755,317746,317745,317744,317738,3177 36,317735,317727,317726,317725,317724,317721,31771 5,317710,317709,317708,317700,317697,317696,317694 ,317693,317684,317682,317681,317680,317678,317677, 317676,317674,317673,317671,317669,317668,317667,3 17661,317660,317658,317652,317651,317650,317638,31 7629,317628,317626,317612,317611,317610,317609,317 607,317606,317605,317603,317602,317600,317599,3175 98,317596,317594,317592,317590,317589,317587,31758 4,317577,317573,317571,317569,317568,317567,317566 ,317564,317562,317560,317556,317555,317553,317549, 317547,317530,317525,317521,317518,317516,317514,3 17512,317508,317507,317505,317485,317472,317450,31 7446,317443,317433,317401,317392,317391,317383,317 377,317366,317365,317359,317357,317354,317352,3173 50,317346,317347,317330,317329,317327,317325,31731 8,317316,317315,317314,317311,317308,317305,317301 ,317300,317296,317295,317293,317292,317290,317289, 317288,317279,317274,317268,317266,317260,317258,3 17257,317256,317248,317247,317245,317244,317241,31 7240,317239,317237,317235,317234,317232,317231,317 230,317229,317220,317217,317216,317214,317213,3172 09,317208,317207,317205,317203,317202,317201,31719 9,317197,317195,317193,317189,317179,317174,317170 ,317167,317153,317151,317150,317149,317148,317141, 317132,317125,317119,317111,317110,317109,317108,3 17106,317104,317103,317101,317100,317097,317096,31 7095,317094,317092,317086,317084,317081,317075,317 070,317069,317067,317063,317060,317059,317055,3170 54,317052,317044,317028,317023,317020,316994,31697 6,316974,316972,316943,316942,316941,316935,316933 ,316931,316927,316926,316925,316924,316919,316910, 316907,316858,316847,316846,316845,316844,316835,3 16825,316824,316821,316818,316817,316814,316811,31 6810,316809,316808,316807,316806,316805,316802,316 801,316800,316799,316794,316791,316790,316778,3167 75,316769,316767,316766,316764,316762,316760,31675 8,316751,316744,316736,316734,316723,316707,316704 ,316693,316685,316682,316681,316668,316667,316665, 316664,316662,316648,316646,316644,316641,316640,3 16631,316623,316624,316622,316613,316602,316601,31 6594,316589,316586,316585,316570,316564,316560,316 559,316551,316550,316548,316543,316538,316526,3165 25,316523,316522,316521,316519,316518,316514,31651 3,316512,316511,316510,316509,316508,316506,316504 ,316503,316501,316495,316489,316486,316479,316476, 316475,316473,316466,316465,316464,316462,316461,3 16459,316456,316452,316451,316449,316448,316447,31 6445,316444,316429,316427,316424,316420,316419,316 418,316416,316415,316414,316406,316405,316404,3164 03,316400,316395,316394,316391,316389,316388,31638 2,316381,316379,316378,316377,316375,316374,316373 ,316372,316364,316362,316358,316350,316335,316332, 316331,316325,316316,316314,316309,316306,316303,3 16301,316298,316297,316287,316285,316282,316279,31 6277,316275,316274,316272,316270,316267,316264,316 263,316262,316261,316255,316254,316253,316252,3162 42,316239,316225,316222,316217,316216,316214,31621 2,316210,316209,316207,316205,316203,316201,316199 ,316198,316197,316193,316192,316191,316185,316174, 316165,316161,316160,316159,316152,316149,316138,3 16136,316135,316126,316125,316124,316122,316121,31 6114,316108,316106,316105,316103,316102,316101,316 100,316099,316098,316091,316083,316065,316063,3160 41,316035,316024,316016,316003,315997,315995,31599 4,315988,315986,315984,315983,315981,315980,315979 ,315935,315930,315921,315918,315914,315907,315896, 315894,315887,315882,315878,315865,315864,315863,3 15861,315840,315836,315835,315830,315829,315828,31 5827,315823,315815,315813,315808,315807,315800,315 799,315797,315795,315794,315792,315786,315782,3157 79,315777,315773,315772,315769,315767,315761,31576 0,315758,315757,315756,315748,315744,315739,315737 ', 1273491048, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{s:0:\"\";N;}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\";}}', 'a38cb59aec7edf7bd7a37cfc4d61c38a');

MySQL Error : Table 'mysqlserver.chsearch' doesn't exist
Error Number : 1146
Request Date : Monday, May 10th 2010 @ 01:30:48 PM
Error Date : Monday, May 10th 2010 @ 01:30:49 PM
Script : http://www.myforum.it/forum/post_thanks.php?do=findallthanks
Referrer :
IP Address : 67.195.112.181
Username : Non registrato
Classname : vB_Database
MySQL Version :

I have the same issue :(

[Mastergumble]

If you have the mod VSA - Advanced Forum Statistics disable the option Top Thanked Users

[sontran]

I don't have that mod :(

I checked in the post_thanks.php and found thse lines

// check if search already done
//if ($search = $db->query_first("SELECT searchid FROM " . TABLE_PREFIX . "search AS search WHERE searchhash = '" . $db->escape_string($searchhash) . "'"))
//{
// $vbulletin->url = 'search.php?' . $vbulletin->session->vars['sessionurl'] . "searchid=$search[searchid]";
// eval(print_standard_redirect('search'));
//}

It refer to a table name prefix ... search but in the db I couldn't found any table having that name!

Could you please kindly check and let us know about that!

Thanks

[Abe1]

Like I posted before, I'll post again. There is NO working search feature currently in Post Thanx Hack. All template edits are done automatically. If you have users searching, then it means you have a manual edit. REMOVE IT. You can find edits by searching "post thank" in a template search.

[RS_Jelle]

Some suggestions:

1. Fix the missing <dt> in the postbit. It's making the definition list XHTML invalid and causing some incompatibilities with other mods (https://vborg.vbsupport.ru/showpost.php?p=2036765&postcount=726).

Current style:
Thanks: x
Thanked x times in x posts
Suggested style:
Thanks: x
Thanked: x times in x posts

2. Get rid of the inline CSS for people with CSS stored as files. With the new XML based CSS rollups you can merge it into showthread-rollup.css
And put a conditional around the JavaScript include so it's not loaded for people who can't thank a thread. Less includes give you a better Google page speed result.

Create /includes/xml/cssrollup_postthanks.xml
<?xml version="1.0" encoding="ISO-8859-1"?>
<css product="post_thanks">
<rollup name="showthread-rollup.css">
<template>postthanks.css</template>
</rollup>
</css>
and create a new postthanks.css template with the raw CSS.

Then put some conditionals into the post_thanks_javascript template:
<vb:if condition="permission to thank">
<script type="text/javascript" src="clientscript/post_thanks.js"></script>
</vb:if>

<vb:if condition="!$vboptions['storecssasfile']">
<link rel="stylesheet" type="text/css" href="{vb:raw vbcsspath}postthanks.css" />
</vb:if>

[shempsall2009]

Hi Great Mod... Installed...

If you update this again would it be possible to have an option to hide attachments until Thanks Button is click???

Thanks :D

[Golzarion]

Some suggestions:

Nice idea..

[Valter]

You must not completely disable 'Top Thanked' in VSa - Advanced Stats to avoid database errors.

Just replace:
<a href="post_thanks.php?do=findthanks&u={vb:raw getstats_thx.userid}">{vb:raw getstats_thx.post_thanks_thanked_times}</a>
with:
{vb:raw getstats_thx.post_thanks_thanked_times}
in 'vsa_topstats_thanks' template.

[cmeinck]

Like I posted before, I'll post again. There is NO working search feature currently in Post Thanx Hack. All template edits are done automatically. If you have users searching, then it means you have a manual edit. REMOVE IT. You can find edits by searching "post thank" in a template search.

I haven't edited the hack in any way, yet I'm getting search db errors -- and I get them in bucket loads.

[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 :

[Thousand Sunny]

I can not find a Thanks Button!!!!!!!

[Mastergumble]

You must not completely disable 'Top Thanked' in VSa - Advanced Stats to avoid database errors.

Just replace:
<a href="post_thanks.php?do=findthanks&u={vb:raw getstats_thx.userid}">{vb:raw getstats_thx.post_thanks_thanked_times}</a>
with:
{vb:raw getstats_thx.post_thanks_thanked_times}
in 'vsa_topstats_thanks' template.


Thanks Valter, the step was to prevent users to follow the ammount of thanked links.

[FractalizeR]

Abe1, can you please at least patch out critical things about this mod? Or let me publish patched version... Styles also needs to be at least patched... Because they look a little bit ugly on 4.x style. Big letters and such...

[djbaxter]

Abe1, can you please at least patch out critical things about this mod? Or let me publish patched version... Styles also needs to be at least patched... Because they look a little bit ugly on 4.x style. Big letters and such...

Yes, please. If nothing else, it will cut down on people cluttering up the thread with questions already answered repeatedly.

I certainly get that you may be too busy to do it yourself but if you have a volunteer willing to take on the task please provide the permission for him to do so.

[Diablotic]

Abe1, can you please at least patch out critical things about this mod? Or let me publish patched version... Styles also needs to be at least patched... Because they look a little bit ugly on 4.x style. Big letters and such...

I second that

[djbaxter]

I second that

Yiou can't second it. It's already been seconded. You'll have to third it.

[popcornic]

Yiou can't second it. It's already been seconded. You'll have to third it.


I'll 4th it!

[zelnik]

5th!

[riskofficer]

Abe1, can you please at least patch out critical things about this mod? Or let me publish patched version... Styles also needs to be at least patched... Because they look a little bit ugly on 4.x style. Big letters and such...
Just upload your patch please! Default ugly style annoying.

[macjoshua]

Thanks for that great mod!
But I have some problems with my style when I activate it. All my fonts in the community navbar-menu are not readable because they are all white on a white backround. When I hover over the menu, they became black color on white backround an I can read it. When I deactivate the mod, all is fine. So, anyone can help me?

[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 :)

[MikalMirkas]

Is this supported on 4.0.3 PL1?

[djbaxter]

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]

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]

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 !

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

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


$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.php?p=2041759&postcount=900

[djbaxter]

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
<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
<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:rolleyes:

[ellinofatsa]

https://vborg.vbsupport.ru/external/2010/05/4.png

i have this problem i dont see the button only text

[visageiii]

hi, i'm hoping someone can help me solve a problem.

while doing a forum upgrade, and subsequent mod installs/reinstalls, (backups were made at several points) I lost all my "post thanks" in my forum.

Now I have the backups to grab the old tables from, but I don't know which tables should be merged/overwritten. If I want to "fix" my post thanks from a backup which tables etc would I need and a little instruction would be very helpful. thanks for a wonderful hack and believe me, my members want thier hard earned thanks back lol.

[Kaosvf]

Hi,
I activated the mod of "thanks" and now there's a problem, the number of listings blog is a top line, how do I fix it?
Thanks

http://img227.imageshack.us/img227/4834/catturaci.png

[Trek]

I uninstalled and am now getting the following error:

Database error in vBulletin 4.0.3:

Invalid SQL:

SELECT userid, usergroupid, displaygroupid, username, posts, post_thanks_thanked_times
FROM asd_user AS user
WHERE post_thanks_thanked_times > '0'
ORDER BY post_thanks_thanked_times DESC
LIMIT 0, 15;

MySQL Error : Unknown column 'post_thanks_thanked_times' in 'field list'


What didn't uninstall and how can I fix it?

[Dave-M]

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.

Thanks for this, but I'm having a few odd issues with it now. When I add a thanks now, it adds thanks after it refreshes the entire page, rather than just adding the thanks. It's the same when removing thanks too.

The other issue is that the box with the thanks in, is still huge. The font is indeed smaller, but that makes no difference to the size of the area of the surrounding box. I even have shortened the phrase to "thanked by", but it's still taking up a lot of space.

So is there a way to make this box smaller? Anyone please? :)

[mad@Max]

Rewrote js, that i've made earlier.

[Diablotic]

madmax - what does it do?

[Dave-M]

Rewrote js, that i've made earlier.

Thanks, but still the same issues as reported earlier for me. :)

[mad@Max]

Diablotic, js optimisation.
Dave-M, this js required changes that i made in xml.

[mhackl]

Would it be very difficult to modify this hack to be "Like" instead of "Thank you" like faceboook?

[War.Frog]

Has anyone tried converting this hack's stats into Dragonbyte's version (https://vborg.vbsupport.ru/showthread.php?t=243510)? It doesn't look like Abe is planning on further updates or releases (Post Groan).

[persianpros]

Persian Language For Post Thank You Hack

By Persian Prince

Good Luck

[Seven Skins]

Hi Abe1,

One curly backet is missing in "post_thanks_javascript" template (just before closing style tag) and it is causing issues with html validation etc.

.

[Kolbi]

Can you show this passage and how to fix manually?

[Philippe J]

Thanks Seven Skins !
That solves the issue Dave-M reported earlier.

[Kolbi]

I found the place:


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


should be right...

what issue does this fixs?

[The Pudge]

I am unable to upload any of the files once extracted? can anyone tell me what i am doing wrong?

XML Error: Invalid document end at Line 539

[Philippe J]

what issue does this fixs?

It fixes this one :

When I add a thanks now, it adds thanks after it refreshes the entire page, rather than just adding the thanks. It's the same when removing thanks too.

[Philippe J]

Correction : the issue is fixed with FF or Chrome, but not with IE.

[Diablotic]

Any chance of adding search functionality?

[FractalizeR]

I would say "thanks" only for correction of mistakes. Forget search functionality.

[Merih]

How this can I correct ?

http://img535.imageshack.us/img535/7718/qweqwen.jpg

[Sdahe]

How can I change the font size at the thanks box inside the thread?

here...
118596

[mgcom]

XML Error: Invalid document end at Line 539

Any idea what that means ?

Cheers

[bchertov]

What's the current status of this hack? Is the official download file on this up to date or are there required/recommended fixes included in this thread that have not been incorporated into the download?

Thanks!

[Nosfer@tu]

What's the current status of this hack? Is the official download file on this up to date or are there required/recommended fixes included in this thread that have not been incorporated into the download?

Thanks!

I was hoping to know to :)

This mod is so popular that even though I read throw all 7-8 pages last week, I was not totaly clear on what I needed to do to fix the alignment issue :)

[rrudeboy]

i get a database error (had it on 3.8.x, updated to 4.0.3 today...) lost the thank count as well :(

error:

Database error in vBulletin 4.0.3:

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

MySQL Error : Unknown column '0Array' in 'where clause'
Error Number : 1054
Request Date : Tuesday, June 22nd 2010 @ 09:03:49 PM
Error Date : Tuesday, June 22nd 2010 @ 09:03:50 PM
Script : http://totalsmartphone.net/forum/showthread.php?1921-Long-time-friend-selling-a-MacBook...-Apple
Referrer : http://totalsmartphone.net/forum/forumdisplay.php?12-General-Talk
IP Address : 24.208.173.41
Username : rudeboy
Classname : vB_Database
MySQL Version : 4.1.20-max-log

[Nosfer@tu]

Running with version 7.82 I still have problems with the alignment of Thanks.

I can change the alignment from Rigth to left in Firefox via Firebug, but finding that placement in the template of my site, I cant :(

Problem being that the element is floating rigth when it accualy should float left.

<dd style="white-space: nowrap; display: inline; float: right;">Takket 6 Gange i 6 Indl?g</dd>

I will try for the 3 time to make this change, but it would be very nice to sum up the problems in the coders mod post, or at least post 1.

Becasue there is ALOT of replies in this thread :(

[tiga2]

How can I delete the "Remove All" button? I dont know how to remove it. Pleae help :)

[David Sims]

Thanks Abe1 for the great mod. I would love to see findthanks and findthanks_user_gave functional in the future. Do you have a decent idea when this will be available?

[Charlie98902]

Thanks Abe1 for the great mod. I would love to see findthanks and findthanks_user_gave functional in the future. Do you have a decent idea when this will be available?

June 9, 2010 was the last time this person was online. More and more people are moving to this - https://vborg.vbsupport.ru/showthread.php?t=243510 due to support etc...... I am thinking of porting over as well.

[David Sims]

Thanks Charlie98902. I'll give it a go.

[vauge]

June 9, 2010 was the last time this person was online. More and more people are moving to this - https://vborg.vbsupport.ru/showthread.php?t=243510 due to support etc...... I am thinking of porting over as well.
Unsure if that is an option for us larger boards, you have to PAY for the "FREE" import script to see if it even works. If you are really considering it - please review the thread and notice how he said two things about large forums to me. First he said he had not tested it, then he said many customers use it.

I'm holding out for ABE1 or someone else to get some reports up for this hack. :)

I wonder if cron based script might be better to create the reports than a crazy on-the-fly query...

[djbaxter]

Unsure if that is an option for us larger boards, you have to PAY for the "FREE" import script to see if it even works. If you are really considering it - please review the thread and notice how he said two things about large forums to me. First he said he had not tested it, then he said many customers use it.

I'm holding out for ABE1 or someone else to get some reports up for this hack. :)

I wonder if cron based script might be better to create the reports than a crazy on-the-fly query...

I agree.

June 9, 2010 was the last time this person was online. More and more people are moving to this - https://vborg.vbsupport.ru/showthread.php?t=243510 due to support etc...... I am thinking of porting over as well.

Be aware that without the import script, for which you have to pay with no guarantee that it will work, you will lose your current Thanks stats accumulated under Abe's add-on.

[Bisha]

did someone founded any solution for database .search errors?

Thnx

[djbaxter]

did someone founded any solution for database .search errors?

Yes. See https://vborg.vbsupport.ru/showpost.php?p=2042792&postcount=904

[SomeDude-GP]

This mod has been exploited via SQL injection.

https://vborg.vbsupport.ru/showthread.php?t=245207

[djbaxter]

This mod has been exploited via SQL injection.

https://vborg.vbsupport.ru/showthread.php?t=245207

As I said in that thread:

Your screenshot in https://vborg.vbsupport.ru/showpost.php?p=2060449&postcount=6 shows a Thank You plugin at the global_setup_complete hook.

There is no Thank You plugin that's using that hook.

To blame the Thank You hack for this seems misguided. You were hacked by tapatalk. Lord knows what else got corrputed in the process.

[mtlcore]

Hey guys, sorry if this has already been asked:

I upgraded to 4.0.4, and I unintalled all plugins including thanks, is there a way to import the thanks stats from the old server ( i still have it live ) ?

[LuisManson]

any chances to mix this with any hide plugin?

[dippetas]

i am making a small hack with drop down menu in toplinks, and i want to add the option to show how many thanks has received, and how many thanks the user has given. Does anybody know how to retrieve these counters? and how am i gonna make them to show?
any help would be appreciated

thanks in advance Dippetas

edit: never mind, i found the solution by myself, if you like the dropdown toplinks pm me.

cheers

[MarkoXaser]

i have an error

http://forum.justoverclock.com/justoverclock-square/5798-breve-sistema-feedback-vendite.html#post56419

if u see my forum, you can see in postbit the alignement is bad!

hoc can i do?

[neofobic]

vbulletin 4.0.4 version install problems. Version incompatible error is.

[optize]

Is there anyway to change 'Thanks' to 'Like' so people Like posts, instead of Thanking? I think that would be better?

[rolfw1]

i have an error

http://forum.justoverclock.com/justoverclock-square/5798-breve-sistema-feedback-vendite.html#post56419

if u see my forum, you can see in postbit the alignement is bad!

hoc can i do?

Your alignment looked Ok there, did you get it sorted? As I have an alignment problem http://www.thamesvalleybirds.co.uk/bird-photos-general/11314-reed-warbler-lavells-lake.html#post41864 for example.

[Ortix]

Hey! This mod is absolutely great, but i was wondering if there is a way to integrate it with my Joomla! site. vB and Joomla! are synced with each other through jFusion. All I want is the thanks button to appear in a post and when clicked the thank count goes up for the user who posted the article. Is it hard to do?

[heugabel]

in showthread the inline-moderatiom -> mark all posts is not working, only the first post is marked.

[rolfw1]

in showthread the inline-moderatiom -> mark all posts is not working, only the first post is marked.

Hadn't noticed that, but same on mine.

[MaxInfinity]

Is there anyway to change 'Thanks' to 'Like' so people Like posts, instead of Thanking? I think that would be better?

I believe vb has its own built in like button

[djbaxter]

I believe vb has its own built in like button

Sort of. However, you have to enable the Facebook platform and it's only for threads, not for individual posts. Not really the same at all.

[MaxInfinity]

Sort of. However, you have to enable the Facebook platform and it's only for threads, not for individual posts. Not really the same at all.

right wasnt sure just remember seeing it in the options.
Thanx for correcting that.

[BadgerDog]

Anyone else having a problem with the postbit display element of this mod overflowing the edges of the screen display (shows outside the postbit user box) when a user has a lot of thank you's?

Is there a fix?

Thanks .. :)

Regards,
Badger

[DAMINK]

Yea its not working well with my postbit either.
Also i have a test tread i posted 3 times and well you see the effect.
http://www.ftw.net.au/showthread.php/9589-clean-test-thread!
It repeats itsself each time making duplicate thankyou bits.

[BadgerDog]

Yea its not working well with my postbit either.
Also i have a test tread i posted 3 times and well you see the effect.
http://www.ftw.net.au/showthread.php/9589-clean-test-thread!
It repeats itsself each time making duplicate thankyou bits.

I have not seen the duplicates yet, but I guess I should do a test thread as well. The field overflow for members with large amounts of Thank You's is ugly, so I'll turn it off until someone can post a fix ...

Thanks... :)

Regards,
Badger

[Jollyware]

This would be an even more awsome mod if attahements could be hidden and shown once the thanks buttonwas clicked.

[Gn_Snake]

Your alignment looked Ok there, did you get it sorted? As I have an alignment problem http://www.thamesvalleybirds.co.uk/bird-photos-general/11314-reed-warbler-lavells-lake.html#post41864 for example.

I have the same problem?...Any idea for solve?

Thx

[RobbieZ]

Is there anyway to change 'Thanks' to 'Like' so people Like posts, instead of Thanking? I think that would be better?

Search in phrases and change it to 'Like'

in showthread the inline-moderatiom -> mark all posts is not working, only the first post is marked.

Its the thanks_hack, as ive disabled it to check also http://www.vbulletin.com/forum/project.php?issueid=36383

Anyone else having a problem with the postbit display element of this mod overflowing the edges of the screen display (shows outside the postbit user box) when a user has a lot of thank you's?

Is there a fix?

Thanks .. :)

Regards,
Badger

Noticed this too, Animemike (https://vborg.vbsupport.ru/member.php?u=274111) is using css boxes around his and his seems to be fixed, whether asking him will sort this problem ??

[BadgerDog]

Noticed this too, Animemike (https://vborg.vbsupport.ru/member.php?u=274111) is using css boxes around his and his seems to be fixed, whether asking him will sort this problem ??

Thanks... :)

I can also confirm that using 4.0.4pl1 and FireFox 3.6.6, that this hack does NOT break the in-line moderation of the forum thread listing. My inline moderation drop down box does not work to permit me to select and highlight any threads when viewing the forum thread listing. However, whether this mod is enabled or disabled, for me neither makes any difference and the inline moderation capability still doesn;t work.

Regards,
Badger

[Hellmaster]

How to add a "Collapse" block with thanks?

[RobbieZ]

You will have to disable all your mods and try your inline and keep turning them on until you discover which mod is causing this.

I have limited mods installed on my test board so it's slightly easier for me.

It's a pain but the best solution.

[Dark_Jack]

wonderful plugin!! :D

[tiga2]

Is there not some kind of plugin which shows the TOP 10 Users who recieved thanks?

[NarutoFTW]

How can I set it so that in the users profile. they could view thanked post thread?

[Ted S]

...

[Danny M]

Hey guys,

How do you remove the "Thanked 0 Times in 0 Posts" from this product? For example, my forum currently displays in the postbit of a thread page:

Thanks: 1
Thanked 1 Times in 1 Posts

But I want it to just display:

Thanks: 1

Thanks in advance.

[saltedm8]

Hi, is it possible to show a scaled version of the users avatar, rather than their name in the "Thanks" box ?

[LuisManson]

this should have a hide addon option!!! PLEASEEEE

[mac47]

Can I remove "thanked 0 times in 0 posts"? I jsut want to keep the "Thanks" count.

[sinucello]

Hi,
But I want it to just display:

Thanks: 1


Can I remove "thanked 0 times in 0 posts"? I jsut want to keep the "Thanks" count.

edit the xml file and look for the phrases section. You can edit most things that are shown in the forum there. Save and re-install with overwrite option set and you`re done.

all the best,
Sacha

[jesus likes pie]

vb4 version available?

[Greight]

This is vb4 version!

[hendri]

when i click thank you button :

this message appear : Could not find phrase 'post_thanks'.

but the hack work ok.

how to fix that ?

[hendri]

when i click thank you button :

this message appear : Could not find phrase 'post_thanks'.

but the hack work ok.

how to fix that ?

i disable the hack until i got the answer / solution

[jesus likes pie]

This is vb4 version!

haha, silly me :x

[andryus]

Hello , thanks for your great mod!

I have errors like this on my vb database:

REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
VALUES (0, '216.129.119.40', 1, 'username', '', 'post.dateline', 'DESC', 0.04064, 1, '260371', 1280030292, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:35491;s:10:\"username\";}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\";}}', '790c9cbc323124a8f76f8ca016781b46');


How i can repair it?

When i find thanks the error appear:

post_thanks.php?do=findthanks&u=35491

Best Regards.

[Ddiablo]

Thanks, works fine:)

[Krosi1906]

How to fix this problem ?

[JIMBOND27]

Hi everybody. How can I get rid of the "Thanks"?

[nektar]

Anyone else having a problem with the postbit display element of this mod overflowing the edges of the screen display (shows outside the postbit user box) when a user has a lot of thank you's?

Is there a fix?

Thanks .. :)

Regards,
Badger

Template: post_thanks_postbit_info

Find

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

Replace with: (more than 1 instances)

<dd>

In other words, remove styling and it will align fine and text will be wrapped. ;)

[Devanand]

Got a problem. I have checked "Show Stats in Profile" but it doesn't show links to search all posts that user gave thanks to and all posts of his/hers that got thanked by someone else. It showes only number of thanks.

[BrightStar]

Database error in vBulletin 4.0.5:

Invalid SQL:

SELECT post_thanks.postid AS postid
FROM _forumpost_thanks AS post_thanks
LEFT JOIN _forumpost AS post USING (postid)
INNER JOIN _forumthread AS thread ON(thread.threadid = post.threadid)
WHERE post_thanks.userid = 29
AND thread.forumid IN(3,4,5,28,34,35,36,37,38,6,39,7,9,8,13,22,23,32, 43,42,40,41,10,11,12,18,29,19, 21,31,17,30,20,14,16,25,33,26,27,15,24)
ORDER BY post.dateline DESC
LIMIT 1000;

MySQL Error : Table 'homeforum_forum._forumpost_thanks' doesn't exist
Error Number : 1146
Request Date : Tuesday, July 27th 2010 @ 01:08:19 PM
Error Date : Tuesday, July 27th 2010 @ 01:08:19 PM
Script : http://www.homeforum.org/forum/post_...user_gave&u=29
Referrer :
IP Address : 195.62.212.79
Username : Admin
Classname : vB_Database
MySQL Version : 5.0.90-community

Any idea how to fix the error after uninstalling this mod?

Thanks

[coloradomoms]

is it possible to have this hack in twice? once as thanks and once again where I rename the phrases to Hugs?

[djbaxter]

is it possible to have this hack in twice? once as thanks and once again where I rename the phrases to Hugs?

Eewwwww..... :eek:

[midnz]

Eewwwww..... :eek:

http://img818.imageshack.us/img818/3642/giggle.gif

is it possible to have this hack in twice? once as thanks and once again where I rename the phrases to Hugs?

Yes but you'd have to go through each file and change all of the references from thanks to hugs before installing.
A mate of mine edited an earlier version of Post_Thanks to give us a Post_Lol hack on vB 3.6. I've tried to do the same with this current version of Post_Thanks but viewers were unable to view the username of those who had Lol'd their posts for some reason. Apart from that everything else worked as it should. I'm still trying to work it out for myself :confused:.

[coloradomoms]

I know, but I run a board for moms and we like to hug a lot. LOL

I tried it but it just changed all thanks to hugs, not installing it twice, just over writing it. Not a big deal. I tried installing the other thanks/like hack but it annihilated my admincp. Just got that back working and leaving it with this hack once for now.

Thanks!

[sulasno]

is it possible to run a query to determine who has given and receive 100 Thanks?

[JIMBOND27]

Would I be able to put the "thanks" on the right side of the posts, so it is more visible?

[Afsoul]

Would I be able to put the "thanks" on the right side of the posts, so it is more visible?

Yeah I have the same thoughts with JIMBOND2, can we put the "thanks" on the right side of posts?:confused:

Thx before :)

[vivamexico55]

Getting an error on 4.06

Database error in vBulletin 4.0.6:

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

MySQL Error : Unknown column '0Array' in 'where clause'
Error Number : 1054
Request Date : Thursday, August 12th 2010 @ 05:45:08 PM

Classname : vB_Database
MySQL Version : 5.0.85-community

[Victor S]

Getting an error on 4.06

Database error in vBulletin 4.0.6:

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

MySQL Error : Unknown column '0Array' in 'where clause'
Error Number : 1054
Request Date : Thursday, August 12th 2010 @ 05:45:08 PM

Classname : vB_Database
MySQL Version : 5.0.85-community

It works fine on 4.0.5 for me. Can anyone else confirm that it actually breaks with 4.0.6...?