vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Show Thread Enhancements - [AJAX] Post Thank You Hack (https://vborg.vbsupport.ru/showthread.php?t=231666)

sontran 05-14-2010 05:43 AM

I don't have that mod :(

I checked in the post_thanks.php and found thse lines

PHP Code:

// 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 05-14-2010 01:01 PM

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 05-14-2010 01:14 PM

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.

Current style:
Quote:

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

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

<?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:
Code:

<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 05-15-2010 07:26 PM

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 05-17-2010 12:05 PM

Quote:

Originally Posted by RS_Jelle (Post 2036922)
Some suggestions:

Nice idea..

Valter 05-18-2010 06:40 PM

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

Just replace:
Code:

<a href="post_thanks.php?do=findthanks&u={vb:raw getstats_thx.userid}">{vb:raw getstats_thx.post_thanks_thanked_times}</a>
with:
Code:

{vb:raw getstats_thx.post_thanks_thanked_times}
in 'vsa_topstats_thanks' template.

cmeinck 05-18-2010 10:38 PM

Quote:

Originally Posted by Abe1 (Post 2036914)
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 05-19-2010 04:17 PM

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

Code:

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 05-19-2010 04:20 PM

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

Mastergumble 05-19-2010 04:26 PM

Quote:

Originally Posted by Valter (Post 2039410)
You must not completely disable 'Top Thanked' in VSa - Advanced Stats to avoid database errors.

Just replace:
Code:

<a href="post_thanks.php?do=findthanks&u={vb:raw getstats_thx.userid}">{vb:raw getstats_thx.post_thanks_thanked_times}</a>
with:
Code:

{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 05-20-2010 07:28 AM

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 05-20-2010 02:10 PM

Quote:

Originally Posted by FractalizeR (Post 2040388)
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 05-20-2010 02:32 PM

Quote:

Originally Posted by FractalizeR (Post 2040388)
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 05-20-2010 02:44 PM

Quote:

Originally Posted by Diablotic (Post 2040559)
I second that

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

popcornic 05-20-2010 05:26 PM

Quote:

Originally Posted by djbaxter (Post 2040575)
Yiou can't second it. It's already been seconded. You'll have to third it.


I'll 4th it!

zelnik 05-20-2010 06:34 PM

5th!

riskofficer 05-21-2010 06:15 PM

Quote:

Originally Posted by FractalizeR (Post 2040388)
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 05-21-2010 07:56 PM

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 05-22-2010 06:43 AM

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

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 05-23-2010 07:25 PM

Is this supported on 4.0.3 PL1?

djbaxter 05-23-2010 09:14 PM

Quote:

Originally Posted by MikalMirkas (Post 2042366)
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 05-24-2010 06:22 PM

Quote:

Originally Posted by cmeinck (Post 2039956)
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".

Code:

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 05-24-2010 06:36 PM

1 Attachment(s)
Quote:

Originally Posted by cmeinck (Post 2039956)
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".

Code:

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 :


Quote:

Originally Posted by Golzarion (Post 2042787)
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.

Quote:

Originally Posted by imagirlgeek (Post 1958396)
What I did to resolve this was to comment out these lines in post_thanks.php...

PHP Code:

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

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

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

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

empty2002 05-25-2010 12:38 AM

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

djbaxter 05-25-2010 12:48 AM

Quote:

Originally Posted by empty2002 (Post 2041759)
hey, when I upgrade from 3.8.4 to 4.0.3, then I reinstall this MOD, but I have an error :-s
Code:

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 05-26-2010 12:46 PM

eror 500

jacobomoya 05-27-2010 09:13 AM

Maybe the operation takes too long and your server timeouts?

kmohamed 05-27-2010 07:01 PM

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 05-29-2010 11:31 AM

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

in post_thanks_javascript template
this is the original code
PHP Code:

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

<
style type="text/css">
.
postbitlegacy .postfoot .textcontrols a.post_thanks_button, .postbit .postfoot .textcontrols a.post_thanks_button  {
    
backgroundurl({vb:stylevar imgdir_button}/post_thanks.pngno-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  {
    
backgroundurl({vb:stylevar imgdir_button}/post_thanks-hover.pngno-repeat transparent {vb:stylevar left};

</
style

I added a } at the end before /style

so it looks like this now
PHP Code:

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

<
style type="text/css">
.
postbitlegacy .postfoot .textcontrols a.post_thanks_button, .postbit .postfoot .textcontrols a.post_thanks_button  {
    
backgroundurl({vb:stylevar imgdir_button}/post_thanks.pngno-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  {
    
backgroundurl({vb:stylevar imgdir_button}/post_thanks-hover.pngno-repeat transparent {vb:stylevar left};
}
</
style

hope it helps someone out

sebaldus 05-30-2010 02:02 AM

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

Code:

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 05-30-2010 07:37 PM

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

i have this problem i dont see the button only text

visageiii 06-02-2010 04:23 AM

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 06-02-2010 02:06 PM

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 06-04-2010 12:18 AM

I uninstalled and am now getting the following error:

Quote:

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 06-04-2010 12:09 PM

Quote:

Originally Posted by djbaxter (Post 2042792)

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 06-04-2010 03:29 PM

1 Attachment(s)
Rewrote js, that i've made earlier.

Diablotic 06-04-2010 03:40 PM

madmax - what does it do?

Dave-M 06-04-2010 05:01 PM

Quote:

Originally Posted by mad@Max (Post 2048269)
Rewrote js, that i've made earlier.

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

mad@Max 06-04-2010 05:24 PM

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

mhackl 06-04-2010 07:09 PM

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


All times are GMT. The time now is 09:30 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05564 seconds
  • Memory Usage 1,901KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (12)bbcode_code_printable
  • (4)bbcode_php_printable
  • (19)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete