04.08.2016, 12:14
Same problem
[14:06:11] SAVEPLAYERDATA
[14:06:11] SAVE1
[14:06:11] SAVE2
Код HTML:
[14:14:31] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `pass`, `ID` FROM `comptes` WHERE `pseudo` = '%e' LIMIT 1"
[14:14:31] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `pass`, `ID` FROM `comptes` WHERE `pseudo` = 'Malcom Saka", callback: "VerificationCompte", format: "i"
[14:14:31] [DEBUG] CMySQLQuery::Execute[VerificationCompte] - starting query execution
[14:14:31] [DEBUG] CMySQLQuery::Execute[VerificationCompte] - query was successfully executed within 0.539 milliseconds
[14:14:31] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[14:14:31] [DEBUG] Calling callback "VerificationCompte"..
[14:14:31] [DEBUG] cache_get_data - connection: 1
[14:14:31] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[14:14:40] [DEBUG] mysql_format - connection: 1, len: 250, format: "INSERT INTO `comptes` (`pseudo`, `pass`) VALUES ('%e', '%e')"
[14:14:40] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `comptes` (`pseudo`, `pass`) VALUES ('Malcom Sakafay", callback: "CreationCompte", format: "i"
[14:14:40] [DEBUG] CMySQLQuery::Execute[CreationCompte] - starting query execution
[14:14:40] [DEBUG] CMySQLQuery::Execute[CreationCompte] - query was successfully executed within 95.490 milliseconds
[14:14:40] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[14:14:40] [DEBUG] Calling callback "CreationCompte"..
[14:14:40] [DEBUG] cache_insert_id - connection: 1
[14:14:40] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[14:14:46] [DEBUG] mysql_format - connection: 1, len: 2500, format: "UPDATE `comptes` SET `admin` = %d,`sexe` = %d,`age` = %d,`register` = %d,`tuto` = %d,`ip` = '%e',`skin` = %d,`faction` = %d,`ran..."
[14:14:46] [DEBUG] mysql_query - connection: 1, query: "UPDATE `comptes` SET `admin` = 0,`sexe` = 1,`age` = 23,`register", use_cache: true
[14:14:46] [DEBUG] CMySQLQuery::Execute - starting query execution
[14:14:46] [ERROR] CMySQLQuery::Execute - (error #1064) 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 '`ID` = 12' at line 1
PHP код:
function SavePlayerData(playerid){
/*new INI:File = INI_Open(UserPath(playerid));
INI_SetTag(File,"data");*/
new Float:vie, Float:armure;
GetPlayerHealth(playerid, vie);
GetPlayerArmour(playerid, armure);
SCM(playerid,BLANC,"SAVE1");
//INI_WriteInt(File,"Pass", pinfo[playerid][Pass]);
new requete[2500];
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\
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][ID]);
mysql_query(mysql, requete);
SCM(playerid,BLANC,"SAVE2");
new requete2[2500];
mysql_format(mysql, requete2, sizeof(requete2), "UPDATE `comptes` SET `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\
WHERE `ID` = %d",
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][ID]);
mysql_query(mysql, requete2);
SCM(playerid,BLANC,"SAVE3");
new requete3[2500];
mysql_format(mysql, requete3, sizeof(requete3), "UPDATE `comptes` SET `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'\
WHERE `ID` = %d",
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][ID]);
mysql_query(mysql, requete3);
SCM(playerid,BLANC,"SAVE4");
new requete4[2500];
mysql_format(mysql, requete4, sizeof(requete4), "UPDATE `comptes` SET `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\
WHERE `ID` = %d",
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][ID]);
mysql_query(mysql, requete4);
SCM(playerid,BLANC,"SAVE5");
new requete5[2500];
mysql_format(mysql, requete5, sizeof(requete5), "UPDATE `comptes` SET `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\
WHERE `ID` = %d",
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][ID]);
mysql_query(mysql, requete5);
SCM(playerid,BLANC,"SAVE6");
new requete6[2500];
mysql_format(mysql, requete6, sizeof(requete6), "UPDATE `comptes` SET `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][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_query(mysql, requete6);
SCM(playerid,BLANC,"SAVEFIN");
return 1;
}
[14:06:11] SAVE1
[14:06:11] SAVE2