vb.org Archive

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

topshams 11-02-2006 08:16 PM

Thanks for a great hack.

I am getting a few database error messages when I remove thanks. I doesn't happen every time I remove thanks just sometimes. I'm not sure why that is. Here is the message

Code:

Database error in vBulletin 3.6.2:

Invalid SQL:

                UPDATE vb3_user
                SET post_thanks_user_amount = post_thanks_user_amount - 1
                WHERE userid IN ();

MySQL Error  : You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near ')' at line 3
Error Number : 1064

Thanks for your help:)

Abe1 11-03-2006 02:34 AM

Quote:

Originally Posted by topshams
Thanks for a great hack.

I am getting a few database error messages when I remove thanks. I doesn't happen every time I remove thanks just sometimes. I'm not sure why that is. Here is the message

Code:

Database error in vBulletin 3.6.2:

Invalid SQL:

                UPDATE vb3_user
                SET post_thanks_user_amount = post_thanks_user_amount - 1
                WHERE userid IN ();

MySQL Error  : You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near ')' at line 3
Error Number : 1064

Thanks for your help:)

Did you click the button 2 times quickly?

topshams 11-03-2006 08:06 AM

Quote:

Did you click the button 2 times quickly?
Yes, thinking about it that's exactly what happened.

Thanks for getting back to me. I'm no longer worried about it now.

Razasharp 11-06-2006 02:25 AM

Hi Abe - excellent hack! I have a few questions I hope you can help with...

Quote:

Originally Posted by brandnew
This hack is messy. It includes a long string of javascript after each and every post in the thread. Why it has to be that? You can just put javascript in an external .js file, attach postid to the "Thank You" button in each post, and for every click, the postid is passed to the function.

Please clean this up. The vbulletin inline mod offers a good example to follow.

Quote:

Originally Posted by Abe1
Last time I checked, I had to do it this way because AJAX uses a second function that i am unable to send a variable to. I will look into it again since my knowledge for javascript has been increasing the past few weeks.

Did you manage to work this out Abe?

Also, if we don't need to show:

Quote:

Thanks: 0
Thanked 0 Times in 0 Posts
Can we minus the query you mentioned for showthread? Just wondering as this might help people with busy forums?

Thanks again for a great hack!

ociosos 11-06-2006 05:20 PM

i love this Hack....

im looking for a hack to work with this....

[hide] so people wont see the download links if they dont click on thanks????

any ideas where to get it?

thank you!!!!!

emtee 11-06-2006 08:46 PM

Quote:

Originally Posted by ociosos
i love this Hack....

im looking for a hack to work with this....

[hide] so people wont see the download links if they dont click on thanks????

any ideas where to get it?

thank you!!!!!

Somebody just made this hide + thanks combination: https://vborg.vbsupport.ru/showthread.php?t=130887

Check it out. :D

Abe1 11-07-2006 12:46 AM

Quote:

Originally Posted by Razasharp
Hi Abe - excellent hack! I have a few questions I hope you can help with...





Did you manage to work this out Abe?

Also, if we don't need to show:



Can we minus the query you mentioned for showthread? Just wondering as this might help people with busy forums?

Thanks again for a great hack!

AJAX is still in the template.

The stats dont come from the 1 query. They come from the user info.

Razasharp 11-08-2006 03:43 AM

Thanks for the reply Abe - are you still looking into it?
Cheers.

Abe1 11-08-2006 11:47 AM

Quote:

Originally Posted by Razasharp
Thanks for the reply Abe - are you still looking into it?
Cheers.

Only if some one shows me a small example if it done the other way.

SCRIPT3R 11-09-2006 02:58 AM

adding a Thanks column into the Members List page would be awesome! i'm trying to get my head around it right now (got it working actually, but the searching is attached to post count for some reason and i can't separate them), but with the recent vB upgrade and you mentioning a newer version coming out, i'll hold off for a bit in hopes that maybe it'll be included with the next version. ;)


All times are GMT. The time now is 07:22 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.02439 seconds
  • Memory Usage 1,746KB
  • 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
  • (2)bbcode_code_printable
  • (8)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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