vb.org Archive
Page 50 of 100 « First 404849 50 515260 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   [AJAX] Post Thank You Hack (https://vborg.vbsupport.ru/showthread.php?t=92410)

AnhTuanCool 02-13-2006 02:03 AM
Add the patch in my #485 post BEFORE:

Code:
$act = 1;
and that should be it!

dai-kun 02-13-2006 03:11 AM
i did that

Code:
global $post_thanks_cash, $post_thanks_done, $db;

if (empty($post_thanks_done))
{
$post_thanks_querys = $db->query("SELECT postid FROM ". TABLE_PREFIX ."post WHERE threadid = '$post[threadid]'");
    $post_thanks_postids = 0;
   
    while ($post_thanks_query = $db->fetch_array($post_thanks_querys))
    {
      $post_thanks_postids .= ",$post_thanks_query[postid]";
    }

    $post_thanks_cashe = $db->query("SELECT * FROM " .TABLE_PREFIX. "post_thanks WHERE postid IN ($post_thanks_postids) ORDER BY username ASC");

    $act = 1;
and when i go to thank, i get this error

Code:
Database error in vBulletin 3.5.1:

Invalid SQL:

                    UPDATE vb3_user
                    SET post_thanks_thanked_times = 1 + post_thanks_thanked_times, post_thanks_thanked_posts = 1 + post_thanks_thanked_posts, reputation = $vboptions[post_thanks_reputation] + reputation
                    WHERE userid = 741;

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 '[post_thanks_reputation] + reputation
                    WHERE userid = 741' at line 2

C_P 02-13-2006 04:12 AM
Quote:
Originally Posted by NeutralizeR
Can't remove thanks.
Ditto! I get same error:
Code:
Database error in vBulletin 3.5.2:
Invalid SQL:
DELETE FROM reputation WHERE postid = 12795 AND AND whoadded = 1 reason = 'Thanked Post';
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 'AND whoadded = 1 reason = 'Thanked Post'' at line 1
Error Number : 1064
Date : Monday, February 13th 2006 @ 06:08:34 AM
Script : http://www.cpfools.com/forum/showthr...e_user&p=12795
Referrer : http://www.cpfools.com/forum/showthr...2795#post12795
IP Address : xxxxxx
Username : CP
Classname : xxxxxxxxxx
Also at top of my page it shows this:
Code:
Warning: Invalid argument supplied for foreach() in /includes/class_postbit.php(251) : eval()'d code on line 131

Warning: Invalid argument supplied for foreach() in /includes/class_postbit.php(251) : eval()'d code on line 141
/*+--------------------------------------------------------------------------|  Cascading Style Sheet for MKportal "Forum" Portal Template|  ========================================|  by Meo aka Luponero [Amedeo de longis]|      visiblesoul [Don K. Colburn]|  (c) 2004-2005 mkportal.it|  http://www.mkportal.it|  Email: luponero@mclink.it+--------------------------------------------------------------------------|  > MKPortal|  > Written By Amedeo de longis|  > Date started: 9.2.2004+--------------------------------------------------------------------------*//*=============================MK  global stylesP=============================*//* IMPORT body */body,body{        background: #FFFFFF;        color: #000000;        font: 10pt verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;                padding: 0px;}body {        font-size: 10px;        margin:0px;        padding:0px; /* Opera 0 margin */                text-align: center; /* center in IE */ }/* IMPORT body background (used for SMF) */.importbgbody {        font-size: 10px;}/* portal wrapper */#mkwrapper {        text-align:left; /* left-align text in IE */                margin: 0px auto 0px auto;}/* IMPORT logostrip */#mklogostrip,.page{        background: #FFFFFF;        color: #000000;}/* logostrip */#mklogostrip {        text-align: left;}/* IMPORT global font formatting */table,tr,td,.tdglobal,td, th, p, li{        font: 10pt 'trebuchet ms', verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;}/* global font formatting */table,tr,td,.tdglobal {        font-size: 10px;        }/* IMPORT main portal table bg (if different than body bg) */.tabmain,.page{        background: #FFFFFF;        color: #000000;}/* main portal table */.tabmain {        margin:0px;        padding:0px;        }/* image link border */img {                        border: 0px;}/*=============================MK IMPORT LIGHT BACKGROUNDP=============================*/.modulecell,.urlo2,.tabnews,.trattini,.trattini3,.tablemenu,.taburlo,.alt1, .alt1Active{        background: #DFE6EE;        color: #000000;}/*=============================MK IMPORT MEDIUM BACKGROUNDP=============================*/.navigatore,.tdblock,.moduleborder,.modulex,.mkpagecurrent,.alt2, .alt2Active{        background: #DFE6EE;        color: #000000;}/*=============================MK IMPORT DARK BACKGROUNDP=============================*/.urlo,.sottotitolo,.tcat{        background: #397DD0 url(../forum/images_pb/gradients/gradient_tcat.gif) repeat-x top left;        color: #FFFFFF;        font: bold 10pt verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;}/*=============================MK  border and divider stylesP=============================*//* vertical spacer image used in portal skin *//* .vspacer {        background-image: url(../forum/../mkportal/templates/CPstyle/images/punto_vert.gif);        background-repeat: repeat-y;        background-color: transparent;        } *//* IMPORT border-color */.tabmain,.tablemenu, /* block wrapper, chat button strip */.taburlo,.urlo2,.tabnews,.trattini,.trattini2,.trattini3,.mkpagelink,.mkpagelinklast,.mkpagecurrent,.titadmin,.tborder{                color: #000000;        border: 1px solid #072A68;}        .trattini {        border-width: 1px 0 0 0;        border-style: dashed;}/* blocks admin */.trattini2 {        border-width: 0 1px 0 0;        border-style: dashed;}/* Quotes, Shoutbox */.trattini3 {        border-width: 0 0 1px 0;        border-style: dashed;}/*=============================MK  hyperlink stylesP=============================*//* IMPORT global links */a:link,a:active,a.uno:link,a:link{        color: #000000;}a:visited,a.uno:visited,a:visited{        color: #000000;}a:hover,a.uno:hover,a:hover, a:active{        color: #465584;}/* a:active {        font-family: Verdana, Arial, Helvetica, sans-serif;        color: #496c9f;                text-decoration: none;        } *//* bold navbar, block, module links */a.uno:link {        font-size: 10px;        font-weight: bold;        text-decoration: none}a.uno:visited {                font-size: 10px;        font-weight: bold;        text-decoration: none}a.uno:hover {        font-size: 10px;        font-weight: bold;        text-decoration: underline;}/* block text links *//* .tablemenu a:link, a:visited {        font-family: Verdana, Arial, Helvetica, sans-serif;        color: #496c9f;                text-decoration: none;        }.tablemenu a:hover {        text-decoration: underline;}.tablemenu a:active {        text-decoration: none;        } *//* global contrasting text and hyperlink color */.mktxtcontr,a.mktxtcontr:link, a.mktxtcontr:visited {                color: #ff0000;        font-weight: bold;        text-decoration: none;}a.mktxtcontr:hover {        font-weight: bold;        text-decoration: underline;}/* contrasting text and hyperlink color 2 (admin) */.mktxtcontr2,a.mktxtcontr2:link, a.mktxtcontr2:visited {        color: #0000ff;        font-weight: bold;        text-decoration: none;}a.mktxtcontr2:hover {        font-weight: bold;        text-decoration: underline;}/*=============================MK  form stylesP=============================*//* IMPORT form styles */input,textarea,select,.bgselect, /* input fields */.mkbutton, /* global submit buttons */.mkblkinput, /* block input */.mkradio, .bginput{        background: #FFFFFF;        color: #000000;        font: 10pt verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;}/* set form padding and margin *//*.mkbutton,*/ /* global submit buttons *//* textarea,*/input,select,.bgselect, /* input fields */.mkblkinput /* block input */{        margin: 0px;        padding: 0px;        font-size: 9px;        font-weight: normal; /* needed for Mozilla */        }/* radio/checkbox buttons - remove background color and border in IE */ /* .mkradio {        background-color: transparent;        border-width: 0px;} *//* configure blog textarea */textarea.mkwrap1 {        overflow: auto;        /* width: 230px; */        width: 100%;}/* edit blog textarea */textarea.mkwrap2 {        overflow: auto;        width: 500px ;}/*=============================MK  navstrip stylesP=============================*//* top navstrip */.navigatore {                vertical-align: bottom;        text-align: center;        font-family: Verdana, Arial, Helvetica, sans-serif;        font-weight: 300;        font-size: 9px;        border: 0;}/*=============================MK  block stylesP=============================*//* used in functions.php (function main_page) */.blocks {        padding: 0px;}/* block td cell */.tdblock {        font-family: Verdana, Arial, Helvetica, sans-serif;        font-size: 10px;        font-weight: bold;        border: 0;        margin: 2px;        }/* block title bar */.sottotitolo {        vertical-align: bottom;                text-align: left;        font-size: 11px;        font-weight: bold;        }/* horizontal spacer between blocks */.tdspacer {        line-height: 3px;}/*=============================MK  module global stylesP=============================*//* IMPORT module table headings */th.modulex,.thead{        background: #BCCFEA url(../forum/images_pb/gradients/gradient_thead.gif) repeat-x top left;        color: #3A4F6D;        font: bold 11px tahoma, verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;}.modulex {                border-width: 0 0 0 0;        white-space: nowrap;        /* font-weight: normal;*/}/* Reviews description text */.modulelite {        font-size: 8pt;        /* color:#a6bbcd;*/}/* block padding (news, admin) */.contents {        padding: 10px;        }/* module pagination links */.mkpagelink {        padding:1px 3px 1px 3px;        font-weight: normal;}.mkpagelinklast {        padding:1px 3px 1px 3px;        font-weight:normal;}.mkpagecurrent {        padding:1px 3px 1px 3px;        font-weight:normal;}/*=============================MK  shoutbox module stylesP=============================*/td.taburlo{                margin:5px;        padding:5px;        border: 0;        }        /* shouter and date cell */.urlo {        line-height: 18px;        vertical-align: bottom;        text-align: left;                font-size: 11px;        font-weight: bold;        padding: 4px;                }/* shout cell */.urlo2 {        padding: 4px;        border-width: 0 0 1px 0;        border-style: solid;        text-align: left;        font-size: 11px;        font-weight: bold;}/* white shouter text *//* .urlocontrast {                color: #ffffff;} *//*=============================MK  news module stylesP=============================*//* news table with border */.tabnews {        border-width: 1px;        border-style: dashed;        margin:0px;        padding:0px;        font-size: 10px;        }/*=============================MK  admin cp stylesP=============================*//* admin cp titles with top border */.titadmin {        margin: 0px;        font-size: 11px;        font-weight: bold;        border-width: 1px 0 0 0;        border-style: dashed;}/*=============================MK  font stylesP=============================*//* red error page text */.mkerror {                font-size: 12pt;        color: #ff0000;        font-weight:bold;}/* MKPQuote quotation text *//* .mkquote {                        color: #0000ff;        } *//* MKPGallery module ecard */.ecardtitle {        font-size: 10pt;        font-weight: bold;        text-align: center;}/* MKPGallery slideshow caption text (modules/gallery/index.php function slide_update) *//* .mkslidecap {                font-family: Verdana, Arial, Helvetica, sans-serif;        font-size: 12pt;        font-weight: bold;        color: #ffffff;} *//*=============================MK  BBcode quote stylesP=============================*/.mkquoteball {        font-size: 9px;        color: #666666;        font-family: Verdana, Arial, Helvetica, sans-serif;        font-weight: normal;        background-color: #ffffff;                padding: 0;        }.mkquotetext {        font-size: 10px;        color: #666666;        font-family: Verdana, Arial, Helvetica, sans-serif;        font-weight: normal;        background-color: #ffffff;        margin: 0;        padding: 0;        }table .mkquotetable{                                        width: auto; /* IE */                text-align: left;}
The only way I could get rid of it was to thank the post again!

NeutralizeR 02-13-2006 08:40 AM
Waiting for a fix again...

Abe1 02-13-2006 12:38 PM
Version 3.2 (2/13/06):
  • [FIXED] Fixed another bug with reputation.
  • [FIXED] Sped up the one query used to retrieve the thanks.

Abe1 02-13-2006 12:39 PM
Quote:
Originally Posted by AnhTuanCool
Ahhhhh, I think I've made a terrible mistake here.

I figured out what the problem is that the mixing query I suggested awhile ago actually makes the hack's query time worse. When using multiple WHERE's in query, it queries ALL the entries out of the table and the filter it through the second WHERE. If there are a lot of thanks entries like mine, it tremendously stresses the server. Look at the image I attached above, at column Row and you'll understand why.

So I strongly recommend switch back to the old time query.
Code:
$post_thanks_querys = $db->query("SELECT postid FROM ". TABLE_PREFIX ."post WHERE threadid = '$post[threadid]'");
    $post_thanks_postids = 0;
   
    while ($post_thanks_query = $db->fetch_array($post_thanks_querys))
    {
      $post_thanks_postids .= ",$post_thanks_query[postid]";
    }

    $post_thanks_cashe = $db->query("SELECT * FROM " .TABLE_PREFIX. "post_thanks WHERE postid IN ($post_thanks_postids) ORDER BY username ASC");
Lastly, I terribly sorry for suggesting such a flawful mod...
I went back to this BUT, I did not use a query to get the postids. I used the one that vb made already. You should see improvement in the speed.

Abe1 02-13-2006 12:40 PM
Quote:
Originally Posted by NeutralizeR
Waiting for a fix again...
This update fixes this.

optrex 02-13-2006 12:47 PM
I've got 2.6 - what is the most reliable upgrade proceedure

The Realist 02-13-2006 12:50 PM
Getting this database error when thanks is clicked?

Code:
Database error in vBulletin 3.5.3:

Invalid SQL:

                    UPDATE user
                    SET post_thanks_thanked_times = 1 + post_thanks_thanked_times, post_thanks_thanked_posts = 1 + post_thanks_thanked_posts, reputation = $vboptions[post_thanks_reputation] + reputation
                    WHERE userid = 26;

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 '[post_thanks_reputation] + reputation
                    WHERE userid = 26' at line 2
Error Number : 1064
Date        : Monday, February 13th 2006 @ 02:48:06 PM
Script      : http://www.tech-tronix.com/showthread.php?do=post_thanks&p=3718
Referrer    :
IP Address  : xx.xx.xx.xxx
Username    : Realist
Classname    : xxxxxxxx
Any ideas?

Laters

Abe1 02-13-2006 01:35 PM
Quote:
Originally Posted by The Realist
Getting this database error when thanks is clicked?

Code:
Database error in vBulletin 3.5.3:

Invalid SQL:

                    UPDATE user
                    SET post_thanks_thanked_times = 1 + post_thanks_thanked_times, post_thanks_thanked_posts = 1 + post_thanks_thanked_posts, reputation = $vboptions[post_thanks_reputation] + reputation
                    WHERE userid = 26;

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 '[post_thanks_reputation] + reputation
                    WHERE userid = 26' at line 2
Error Number : 1064
Date        : Monday, February 13th 2006 @ 02:48:06 PM
Script      : http://www.tech-tronix.com/showthread.php?do=post_thanks&p=3718
Referrer    :
IP Address  : xx.xx.xx.xxx
Username    : Realist
Classname    : vb_database
Any ideas?

Laters
Do you have the latest version installed?


All times are GMT. The time now is 09:15 PM.
Page 50 of 100 « First 404849 50 515260 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.02930 seconds
  • Memory Usage 1,811KB
  • 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
  • (8)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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