04.08.2016, 00:00
hello, i have error : (6148 -- 6271) : fatal error 102: table overflow: "staging buffer"
6148 : WHERE `ID` = %d",
6271 : pinfo[playerid][c_Name12],
can you help me ?
PHP код:
new requete[300];
mysql_format(mysql, requete, sizeof(requete), "UPDATE `comptes` SET `admin` = %d,\
'sexe' = %d,\
'age' = %d,\
'register' = %d,\
'tuto' = %d,\
'ip' = %e,\
'skin' = %d,\
'faction' = %d,\
'rank' = %d,\
'jobpv' = %d,\
'rankjob' = %d,\
'inte' = %d,\
'vw' = %d,\
'argent' = %d,\
'banque' = %d,\
'bancaire' = %d,\
'bancairesec' = %d,\
'hacker' = %d,\
'astuces' = %d,\
'nbrveh' = %d,\
'spec' = %d,\
'bannis' = %d,\
'jail' = %d,\
'jailtime' = %d,\
'level' = %d,\
'mort' = %d,\
'crash' = %d,\
'menotte' = %d,\
'cagoule' = %d,\
'nbrmaison' = %d,\
'nbrmaisonloc' = %d,\
'nbrbat' = %d,\
'nbrbiz' = %d,\
'lastint' = %d,\
'numtel' = %d,\
'calling' = %d,\
'payday' = %d,\
'timeduty' = %d,\
'timedutyjob' = %d,\
'timedutyjobpv' = %d,\
'coke' = %d,\
'cokec' = %d,\
'morphine' = %d,\
'morphinec' = %d,\
'weed' = %d,\
'weedc' = %d,\
'shit' = %d,\
'shitc' = %d,\
'graineweed' = %d,\
'graineweedc' = %d,\
'dependance' = %d,\
'dependancetype' = %d,\
'dependancetime' = %d,\
'job' = %d,\
'exp' = %d,\
'maxexp' = %d,\
'forces' = %d,\
'forcetime' = %d,\
'drogueforce' = %d,\
'drogueforcetime' = %d,\
'dette' = %d,\
'permisv' = %d,\
'permisc' = %d,\
'permisa' = %d,\
'timerweed = %d,\
'gps' = %d,\
'c4' = %d,\
'jerrican' = %d,\
'litrejerrican' = %d,\
'radio' = %d,\
'freqradio' = %d,\
'boombox' = %d,\
'averto' = %d,\
'matos' = %d,\
'vproprio1' = %d,\
'vproprio2' = %d,\
'vproprio3' = %d,\
'locationveh' = %d,\
'vloc' = %d,\
'vproprio4' = %d,\
'vproprio5' = %d,\
'vpreter' = %d,\
'vip' = %d,\
'viplvl' = %d,\
'arme1' = %d,\
'arme2' = %d,\
'arme3' = %d,\
'arme4' = %d,\
'arme5' = %d,\
'arme6' = %d,\
'arme7' = %d,\
'arme8' = %d,\
'arme9' = %d,\
'ammo1' = %d,\
'ammo2' = %d,\
'ammo3' = %d,\
'ammo4' = %d,\
'ammo5' = %d,\
'ammo6' = %d,\
'ammo7' = %d,\
'ammo8' = %d,\
'ammo9' = %d,\
'pos_x' = %f,\
'pos_y' = %f,\
'pos_z' = %f,\
'vie' = %f,\
'armure' = %f,\
'corde' = %d,\
'casque' = %d,\
'tel' = %d,\
'eobj' = %d,\
'c_name1' = %e,\
'c_name2' = %e,\
'c_name3' = %e,\
'c_name4' = %e,\
'c_name5' = %e,\
'c_name6' = %e,\
'c_name7' = %e,\
'c_name8' = %e,\
'c_name9' = %e,\
'c_name10' = %e,\
'c_name11' = %e,\
'c_name12' = %e,\
'c_name13' = %e,\
'c_name14' = %e,\
'c_name15' = %e,\
'c_name16' = %e,\
'c_name17' = %e,\
'c_name18' = %e,\
'c_name19' = %e,\
'c_name20' = %e,\
'c_num1' = %d,\
'c_num2' = %d,\
'c_num3' = %d,\
'c_num4' = %d,\
'c_num5' = %d,\
'c_num6' = %d,\
'c_num7' = %d,\
'c_num8' = %d,\
'c_num9' = %d,\
'c_num10' = %d,\
'c_num11' = %d,\
'c_num12' = %d,\
'c_num13' = %d,\
'c_num14' = %d,\
'c_num15' = %d,\
'c_num16' = %d,\
'c_num17' = %d,\
'c_num18' = %d,\
'c_num19' = %d,\
'c_num20' = %d,\
'pindex0' = %d,\
'pindex1' = %d,\
'pindex2' = %d,\
'pindex3' = %d,\
'pindex4' = %d,\
'pindex5' = %d,\
'pmodelid0' = %d,\
'pmodelid1' = %d,\
'pmodelid2' = %d,\
'pmodelid3' = %d,\
'pmodelid4' = %d,\
'pmodelid5' = %d,\
'pboneid0' = %d,\
'pboneid1' = %d,\
'pboneid2' = %d,\
'pboneid3' = %d,\
'pboneid4' = %d,\
'pboneid5' = %d,\
'pfoffsetx0' = %f,\
'pfoffsetx1' = %f,\
'pfoffsetx2' = %f,\
'pfoffsetx3' = %f,\
'pfoffsetx4' = %f,\
'pfoffsetx5' = %f,\
'pfoffsety0' = %f,\
'pfoffsety1' = %f,\
'pfoffsety2' = %f,\
'pfoffsety3' = %f,\
'pfoffsety4' = %f,\
'pfoffsety5' = %f,\
'pfoffsetz0' = %f,\
'pfoffsetz1' = %f,\
'pfoffsetz2' = %f,\
'pfoffsetz3' = %f,\
'pfoffsetz4' = %f,\
'pfoffsetz5' = %f,\
'pfrotx0' = %f,\
'pfrotx1' = %f,\
'pfrotx2' = %f,\
'pfrotx3' = %f,\
'pfrotx4' = %f,\
'pfrotx5' = %f,\
'pfroty0' = %f,\
'pfroty1' = %f,\
'pfroty2' = %f,\
'pfroty3' = %f,\
'pfroty4' = %f,\
'pfroty5' = %f,\
'pfrotz0' = %f,\
'pfrotz1' = %f,\
'pfrotz2' = %f,\
'pfrotz3' = %f,\
'pfrotz4' = %f,\
'pfrotz5' = %f,\
'pfscalex0' = %f,\
'pfscalex1' = %f,\
'pfscalex2' = %f,\
'pfscalex3' = %f,\
'pfscalex4' = %f,\
'pfscalex5' = %f,\
'pfscaley0' = %f,\
'pfscaley1' = %f,\
'pfscaley2' = %f,\
'pfscaley3' = %f,\
'pfscaley4' = %f,\
'pfscaley5' = %f,\
'pfscalez0' = %f,\
'pfscalez1' = %f,\
'pfscalez2' = %f,\
'pfscalez3' = %f,\
'pfscalez4' = %f,\
'pfscalez5' = %f\
WHERE `ID` = %d",
pinfo[playerid][Admin],
pinfo[playerid][Sexe],
pinfo[playerid][Age],
pinfo[playerid][Register],
pinfo[playerid][Tuto],
pinfo[playerid][IP],
pinfo[playerid][Skin],
pinfo[playerid][Faction],
pinfo[playerid][Rank],
pinfo[playerid][JobPv],
pinfo[playerid][RankJob],
pinfo[playerid][Int],
pinfo[playerid][Vw],
pinfo[playerid][Argent],
pinfo[playerid][Banque],
pinfo[playerid][Bancaire],
pinfo[playerid][BancaireSec],
pinfo[playerid][Hacker],
pinfo[playerid][Astuces],
pinfo[playerid][Id],
pinfo[playerid][Spec],
pinfo[playerid][Bannis],
pinfo[playerid][Jail],
pinfo[playerid][JailTime],
pinfo[playerid][Level],
pinfo[playerid][Mort],
pinfo[playerid][Crash],
pinfo[playerid][Menotte],
pinfo[playerid][Cagoule],
pinfo[playerid][NbrMaison],
pinfo[playerid][NbrMaisonLoc],
pinfo[playerid][NbrBat],
pinfo[playerid][NbrBiz],
pinfo[playerid][LastInt],
pinfo[playerid][NumTel],
pinfo[playerid][Calling],
pinfo[playerid][Payday],
pinfo[playerid][TimeDuty],
pinfo[playerid][TimeDutyJob],
pinfo[playerid][TimeDutyJobPv],
pinfo[playerid][Coke],
pinfo[playerid][Cokec],
pinfo[playerid][Morphine],
pinfo[playerid][Morphinec],
pinfo[playerid][Weed],
pinfo[playerid][Weedc],
pinfo[playerid][Shit],
pinfo[playerid][Shitc],
pinfo[playerid][GraineWeed],
pinfo[playerid][GraineWeedc],
pinfo[playerid][Dependance],
pinfo[playerid][DependanceType],
pinfo[playerid][DependanceTime],
pinfo[playerid][Job],
pinfo[playerid][Exp],
pinfo[playerid][MaxExp],
pinfo[playerid][Force],
pinfo[playerid][ForceTime],
pinfo[playerid][DrogueForce],
pinfo[playerid][DrogueForceTime],
pinfo[playerid][Dette],
pinfo[playerid][Permisv],
pinfo[playerid][Permisc],
pinfo[playerid][Permisa],
pinfo[playerid][TimerWeed],
pinfo[playerid][Gps],
pinfo[playerid][C4],
pinfo[playerid][Jerrican],
pinfo[playerid][LitreJerrican],
pinfo[playerid][Radio],
pinfo[playerid][FreqRadio],
pinfo[playerid][Boombox],
pinfo[playerid][Averto],
pinfo[playerid][Matos],
pinfo[playerid][vProprio1],
pinfo[playerid][vProprio2],
pinfo[playerid][vProprio3],
pinfo[playerid][LocationVeh],
pinfo[playerid][vLoc],
pinfo[playerid][vProprio4],
pinfo[playerid][vProprio5],
pinfo[playerid][vPreter],
pinfo[playerid][Vip],
pinfo[playerid][VipLvl],
pinfo[playerid][Arme1],
pinfo[playerid][Arme2],
pinfo[playerid][Arme3],
pinfo[playerid][Arme4],
pinfo[playerid][Arme5],
pinfo[playerid][Arme6],
pinfo[playerid][Arme7],
pinfo[playerid][Arme8],
pinfo[playerid][Arme9],
pinfo[playerid][Ammo1],
pinfo[playerid][Ammo2],
pinfo[playerid][Ammo3],
pinfo[playerid][Ammo4],
pinfo[playerid][Ammo5],
pinfo[playerid][Ammo6],
pinfo[playerid][Ammo7],
pinfo[playerid][Ammo8],
pinfo[playerid][Ammo9],
pinfo[playerid][Pos_X],
pinfo[playerid][Pos_Y],
pinfo[playerid][Pos_Z],
pinfo[playerid][Vie],
pinfo[playerid][Armure],
pinfo[playerid][Corde],
pinfo[playerid][Casque],
pinfo[playerid][Tel],
pinfo[playerid][eObj],
pinfo[playerid][c_Name1],
pinfo[playerid][c_Name2],
pinfo[playerid][c_Name3],
pinfo[playerid][c_Name4],
pinfo[playerid][c_Name5],
pinfo[playerid][c_Name6],
pinfo[playerid][c_Name7],
pinfo[playerid][c_Name8],
pinfo[playerid][c_Name9],
pinfo[playerid][c_Name10],
pinfo[playerid][c_Name11],
pinfo[playerid][c_Name12],
pinfo[playerid][c_Name13],
pinfo[playerid][c_Name14],
pinfo[playerid][c_Name15],
pinfo[playerid][c_Name16],
pinfo[playerid][c_Name17],
pinfo[playerid][c_Name18],
pinfo[playerid][c_Name19],
pinfo[playerid][c_Name20],
pinfo[playerid][c_Num1],
pinfo[playerid][c_Num2],
pinfo[playerid][c_Num3],
pinfo[playerid][c_Num4],
pinfo[playerid][c_Num5],
pinfo[playerid][c_Num6],
pinfo[playerid][c_Num7],
pinfo[playerid][c_Num8],
pinfo[playerid][c_Num9],
pinfo[playerid][c_Num10],
pinfo[playerid][c_Num11],
pinfo[playerid][c_Num12],
pinfo[playerid][c_Num13],
pinfo[playerid][c_Num14],
pinfo[playerid][c_Num15],
pinfo[playerid][c_Num16],
pinfo[playerid][c_Num17],
pinfo[playerid][c_Num18],
pinfo[playerid][c_Num19],
pinfo[playerid][c_Num20],
pinfo[playerid][pindex0],
pinfo[playerid][pindex1],
pinfo[playerid][pindex2],
pinfo[playerid][pindex3],
pinfo[playerid][pindex4],
pinfo[playerid][pindex5],
pinfo[playerid][pmodelid0],
pinfo[playerid][pmodelid1],
pinfo[playerid][pmodelid2],
pinfo[playerid][pmodelid3],
pinfo[playerid][pmodelid4],
pinfo[playerid][pmodelid5],
pinfo[playerid][pboneid0],
pinfo[playerid][pboneid1],
pinfo[playerid][pboneid2],
pinfo[playerid][pboneid3],
pinfo[playerid][pboneid4],
pinfo[playerid][pboneid5],
pinfo[playerid][pfOffsetX0],
pinfo[playerid][pfOffsetX1],
pinfo[playerid][pfOffsetX2],
pinfo[playerid][pfOffsetX3],
pinfo[playerid][pfOffsetX4],
pinfo[playerid][pfOffsetX5],
pinfo[playerid][pfOffsetY0],
pinfo[playerid][pfOffsetY1],
pinfo[playerid][pfOffsetY2],
pinfo[playerid][pfOffsetY3],
pinfo[playerid][pfOffsetY4],
pinfo[playerid][pfOffsetY5],
pinfo[playerid][pfOffsetZ0],
pinfo[playerid][pfOffsetZ1],
pinfo[playerid][pfOffsetZ2],
pinfo[playerid][pfOffsetZ3],
pinfo[playerid][pfOffsetZ4],
pinfo[playerid][pfOffsetZ5],
pinfo[playerid][pfRotX0],
pinfo[playerid][pfRotX1],
pinfo[playerid][pfRotX2],
pinfo[playerid][pfRotX3],
pinfo[playerid][pfRotX4],
pinfo[playerid][pfRotX5],
pinfo[playerid][pfRotY0],
pinfo[playerid][pfRotY1],
pinfo[playerid][pfRotY2],
pinfo[playerid][pfRotY3],
pinfo[playerid][pfRotY4],
pinfo[playerid][pfRotY5],
pinfo[playerid][pfRotZ0],
pinfo[playerid][pfRotZ1],
pinfo[playerid][pfRotZ2],
pinfo[playerid][pfRotZ3],
pinfo[playerid][pfRotZ4],
pinfo[playerid][pfRotZ5],
pinfo[playerid][pfScaleX0],
pinfo[playerid][pfScaleX1],
pinfo[playerid][pfScaleX2],
pinfo[playerid][pfScaleX3],
pinfo[playerid][pfScaleX4],
pinfo[playerid][pfScaleX5],
pinfo[playerid][pfScaleY0],
pinfo[playerid][pfScaleY1],
pinfo[playerid][pfScaleY2],
pinfo[playerid][pfScaleY3],
pinfo[playerid][pfScaleY4],
pinfo[playerid][pfScaleY5],
pinfo[playerid][pfScaleZ0],
pinfo[playerid][pfScaleZ1],
pinfo[playerid][pfScaleZ2],
pinfo[playerid][pfScaleZ3],
pinfo[playerid][pfScaleZ4],
pinfo[playerid][pfScaleZ5],
pinfo[playerid][ID]);
mysql_tquery(mysql, requete, "", "");
6271 : pinfo[playerid][c_Name12],
can you help me ?