vb.org Archive
Page 7 of 216 « First 56 7 891757107 Last »
Show 40 post(s) from this thread on one page

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)

Hornstar 08-10-2006 01:56 AM
Code:
Database error in vBulletin 3.6.0:

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
Date        : Wednesday, August 9th 2006 @ 09:07:13 PM
Script      : http://www.gamerzneeds.net/forums/showthread.php?do=post_thanks_remove_all_ajax&p=156656
Referrer    :
IP Address  :
Username    :
Classname    : vb_database
I've been using the thanks button on my site for so long, upgraded my forums to vb 3.6 gold and then upgraded to this version a few days ago, and then just a few hours ago I had a few database errors come through relating to the database error above.

Anyideas what caused that?

Thanks

unitedpunjab 08-10-2006 01:59 PM
How to totally disable this hack for guests ?
for the past few days google spends an hour daily trying to thank posts.

cavyspirit 08-10-2006 04:12 PM
Quote:
How to totally disable this hack for guests ?
for the past few days google spends an hour daily trying to thank posts.
You can set who can't thank by user group in the vbulletin options for the plugin.

Of all the posts I've ever read in this forum over the years, that one just totally cracked me up! :)

unitedpunjab 08-10-2006 04:15 PM
lol,Did that but dint help.

unitedpunjab 08-10-2006 04:31 PM
This is the problem,1/4 of the bots are trying to Thank :surprised:

cavyspirit 08-10-2006 05:14 PM
Do your guests see the thanks (and groan if you have it) option/button when on the forum? Is it visible to them?

unitedpunjab 08-10-2006 06:04 PM
No,but i think the problem is this code which is shown to all (logged in or not)

Please Check your showthread (view source) if you also have this problem.
Code:
<script type="text/javascript">
<!--
function post_thanks_give_84842()
{
    do_thanks_button = new vB_AJAX_Handler(true)
    do_thanks_button.onreadystatechange(thanks_button_Done_84842)
    do_thanks_button.send('showthread.php?do=post_thanks_button_ajax&p=84842')
    do_thanks_add = new vB_AJAX_Handler(true)
    do_thanks_add.onreadystatechange(thanks_add_Done_84842)
    do_thanks_add.send('showthread.php?do=post_thanks_add_ajax&p=84842')
}
function thanks_button_Done_84842()
{
    if (do_thanks_button.handler.readyState == 4 && do_thanks_button.handler.status == 200)
    {
        fetch_object('post_thanks_button_84842').innerHTML = do_thanks_button.handler.responseText
    }
}
function thanks_add_Done_84842()
{
    if (do_thanks_add.handler.readyState == 4 && do_thanks_add.handler.status == 200)
    {
        fetch_object('post_thanks_box_84842').innerHTML = do_thanks_add.handler.responseText
    }
}
function post_thanks_remove_all_84842()
{
    do_thanks_button = new vB_AJAX_Handler(true)
    do_thanks_button.onreadystatechange(thanks_button_Done_84842)
    do_thanks_button.send('showthread.php?do=post_thanks_button_add_ajax&p=84842')
    do_thanks_remove_all = new vB_AJAX_Handler(true)
    do_thanks_remove_all.onreadystatechange(thanks_remove_all_Done_84842)
    do_thanks_remove_all.send('showthread.php?do=post_thanks_remove_all_ajax&p=84842')
}
function thanks_remove_all_Done_84842()
{
    if (do_thanks_remove_all.handler.readyState == 4 && do_thanks_remove_all.handler.status == 200)
    {
        fetch_object('post_thanks_box_84842').innerHTML = do_thanks_remove_all.handler.responseText
    }
}
function post_thanks_remove_user_84842()
{
    do_thanks_button = new vB_AJAX_Handler(true)
    do_thanks_button.onreadystatechange(thanks_button_Done_84842)
    do_thanks_button.send('showthread.php?do=post_thanks_button_add_ajax&p=84842')
    do_thanks_remove_user = new vB_AJAX_Handler(true)
    do_thanks_remove_user.onreadystatechange(thanks_remove_user_Done_84842)
    do_thanks_remove_user.send('showthread.php?do=post_thanks_remove_user_ajax&p=84842')
}
function thanks_remove_user_Done_84842()
{
    if (do_thanks_remove_user.handler.readyState == 4 && do_thanks_remove_user.handler.status == 200)
    {
        fetch_object('post_thanks_box_84842').innerHTML = do_thanks_remove_user.handler.responseText
    }
}
//-->
</script>

cavyspirit 08-10-2006 10:01 PM
I have the same source. But the whole thing is commented out, right? So Google is trying to execute it anyway?

ktaylor 08-11-2006 03:20 AM
Quote:
Originally Posted by hornstar1337
Code:
Database error in vBulletin 3.6.0:

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
Date        : Wednesday, August 9th 2006 @ 09:07:13 PM
Script      : http://www.gamerzneeds.net/forums/showthread.php?do=post_thanks_remove_all_ajax&p=156656
Referrer    :
IP Address  :
Username    :
Classname    : vb_database
I've been using the thanks button on my site for so long, upgraded my forums to vb 3.6 gold and then upgraded to this version a few days ago, and then just a few hours ago I had a few database errors come through relating to the database error above.

Anyideas what caused that?

Thanks
does anyone have a fix for this? i get the same db error....

iran.gs 08-11-2006 01:13 PM
lnstalled


All times are GMT. The time now is 07:51 AM.
Page 7 of 216 « First 56 7 891757107 Last »
Show 40 post(s) from this thread on one page

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.02262 seconds
  • Memory Usage 1,749KB
  • 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
  • (3)bbcode_code_printable
  • (2)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
  • (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