SavePlayerData - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: SavePlayerData (/showthread.php?tid=614084)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: SavePlayerData (/showthread.php?tid=614084)
SavePlayerData - Skinnz - 04.08.2016
hello, when i use "SavePlayerData" the game is blocked, can you help me ?
Код HTML:
[13:55:37] [DEBUG] CMySQLConnection::Disconnect - connection was closed
[13:55:37] [DEBUG] CMySQLHandle::~CMySQLHandle - deconstructor called
[13:56:25] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "samp", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[13:56:25] [DEBUG] CMySQLHandle::Create - creating new connection..
[13:56:25] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[13:56:25] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[13:56:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[13:56:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[13:56:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[13:56:25] [DEBUG] mysql_errno - connection: 1
[13:56:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[13:56:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[13:56:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[13:56:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[13:56:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[13:56:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[13:56:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[13:56:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[13:56:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[13:56:55] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `pass`, `ID` FROM `comptes` WHERE `pseudo` = '%e' LIMIT 1"
[13:56:55] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `pass`, `ID` FROM `comptes` WHERE `pseudo` = 'Malcom Saka", callback: "VerificationCompte", format: "i"
[13:56:55] [DEBUG] CMySQLQuery::Execute[VerificationCompte] - starting query execution
[13:56:55] [DEBUG] CMySQLQuery::Execute[VerificationCompte] - query was successfully executed within 0.302 milliseconds
[13:56:55] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[13:56:55] [DEBUG] Calling callback "VerificationCompte"..
[13:56:55] [DEBUG] cache_get_data - connection: 1
[13:56:55] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[13:57:03] [DEBUG] mysql_format - connection: 1, len: 250, format: "INSERT INTO `comptes` (`pseudo`, `pass`) VALUES ('%e', '%e')"
[13:57:03] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `comptes` (`pseudo`, `pass`) VALUES ('Malcom Sakafay", callback: "CreationCompte", format: "i"
[13:57:03] [DEBUG] CMySQLQuery::Execute[CreationCompte] - starting query execution
[13:57:03] [DEBUG] CMySQLQuery::Execute[CreationCompte] - query was successfully executed within 1.716 milliseconds
[13:57:03] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[13:57:03] [DEBUG] Calling callback "CreationCompte"..
[13:57:03] [DEBUG] cache_insert_id - connection: 1
[13:57:03] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[13:57:08] [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..."
[13:57:08] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `comptes` SET `admin` = 0,`sexe` = 1,`age` = 25,`register", callback: "(null)", format: "(null)"
[13:57:08] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[13:57:08] [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` = 11' at line 1
[13:57:08] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
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_tquery(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_tquery(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_tquery(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_tquery(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_tquery(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_tquery(mysql, requete6, "", "");
SCM(playerid,BLANC,"SAVEFIN");
return 1;
}
[13:48:33] SAVE2
Re: SavePlayerData - F1N4L - 04.08.2016
Try it
Код:
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;
}
Re: SavePlayerData - Skinnz - 04.08.2016
thank you, but what you have changed?
Re: SavePlayerData - F1N4L - 04.08.2016
Код:
mysql_tquery(...);
Код:
mysql_query(...);
Re: SavePlayerData - Skinnz - 04.08.2016
Same problem
Код 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
Re: SavePlayerData - Skinnz - 04.08.2016
and
[DEBUG] mysql_query - connection: 1, query: "UPDATE `comptes` SET `admin` = 0,`sexe` = 1,`age` = 23,`register", use_cache: true
but
Re: SavePlayerData - F1N4L - 04.08.2016
Yeah! the problem isn't found ` in one line...
Код:
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, false);
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, false);
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, false);
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, false);
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, false);
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, false);
SCM(playerid,BLANC,"SAVEFIN");
return 1;
}
Make a debug...
Re: SavePlayerData - Skinnz - 04.08.2016
Same problem
Код HTML:
[14:33:45] [DEBUG] CMySQLConnection::Disconnect - connection was closed
[14:33:45] [DEBUG] CMySQLHandle::~CMySQLHandle - deconstructor called
[14:33:49] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "samp", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[14:33:49] [DEBUG] CMySQLHandle::Create - creating new connection..
[14:33:49] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[14:33:49] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[14:33:49] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[14:33:49] [DEBUG] CMySQLConnection::Connect - connection was successful
[14:33:49] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[14:33:49] [DEBUG] mysql_errno - connection: 1
[14:33:49] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[14:33:49] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[14:33:49] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[14:33:49] [DEBUG] CMySQLConnection::Connect - connection was successful
[14:33:49] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[14:33:49] [DEBUG] CMySQLConnection::Connect - connection was successful
[14:33:49] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[14:33:49] [DEBUG] CMySQLConnection::Connect - connection was successful
[14:33:49] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[14:34:30] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `pass`, `ID` FROM `comptes` WHERE `pseudo` = '%e' LIMIT 1"
[14:34:30] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `pass`, `ID` FROM `comptes` WHERE `pseudo` = 'Malcom Saka", callback: "VerificationCompte", format: "i"
[14:34:30] [DEBUG] CMySQLQuery::Execute[VerificationCompte] - starting query execution
[14:34:30] [DEBUG] CMySQLQuery::Execute[VerificationCompte] - query was successfully executed within 0.536 milliseconds
[14:34:30] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[14:34:30] [DEBUG] Calling callback "VerificationCompte"..
[14:34:30] [DEBUG] cache_get_data - connection: 1
[14:34:30] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[14:34:37] [DEBUG] mysql_format - connection: 1, len: 250, format: "INSERT INTO `comptes` (`pseudo`, `pass`) VALUES ('%e', '%e')"
[14:34:37] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `comptes` (`pseudo`, `pass`) VALUES ('Malcom Sakafay", callback: "CreationCompte", format: "i"
[14:34:37] [DEBUG] CMySQLQuery::Execute[CreationCompte] - starting query execution
[14:34:37] [DEBUG] CMySQLQuery::Execute[CreationCompte] - query was successfully executed within 3.525 milliseconds
[14:34:37] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[14:34:37] [DEBUG] Calling callback "CreationCompte"..
[14:34:37] [DEBUG] cache_insert_id - connection: 1
[14:34:37] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[14:34:42] [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:34:42] [DEBUG] mysql_query - connection: 1, query: "UPDATE `comptes` SET `admin` = 0,`sexe` = 1,`age` = 23,`register", use_cache: false
[14:34:42] [DEBUG] CMySQLQuery::Execute - starting query execution
[14:34:42] [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` = 13' at line 1
[14:26:07] SAVE2
how to do ?
Re: SavePlayerData - F1N4L - 04.08.2016
Register is integer or varchar?
Re: SavePlayerData - Skinnz - 04.08.2016
integer, samllint(5)
Re: SavePlayerData - Stinged - 04.08.2016
First of all, I don't get why changing threaded queries to non threaded ones would fix the problem.
All it does it make stuff a lot slower. Threaded is much better.
You should fix your table. Too many fields. I can't imagine what a mess it looks like.
Also, start re-using strings. No need to create 6 strings with 2500 cells.
Just reformat the same one after you run it.
Re: SavePlayerData - Skinnz - 04.08.2016
PHP Code:
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, false);
SCM(playerid,BLANC,"SAVE2");
//new requete2[2500];
mysql_format(mysql, requete, sizeof(requete), "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, requete, false);
SCM(playerid,BLANC,"SAVE3");
//new requete3[2500];
mysql_format(mysql, requete, sizeof(requete), "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, requete, false);
SCM(playerid,BLANC,"SAVE4");
//new requete4[2500];
mysql_format(mysql, requete, sizeof(requete), "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, requete, false);
SCM(playerid,BLANC,"SAVE5");
//new requete5[2500];
mysql_format(mysql, requete, sizeof(requete), "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, requete, false);
SCM(playerid,BLANC,"SAVE6");
// new requete6[2500];
mysql_format(mysql, requete, sizeof(requete), "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, requete, false);
SCM(playerid,BLANC,"SAVEFIN");
return 1;
}
HTML Code:
[15:04:36] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "samp", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[15:04:36] [DEBUG] CMySQLHandle::Create - creating new connection..
[15:04:36] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[15:04:36] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[15:04:36] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[15:04:36] [DEBUG] CMySQLConnection::Connect - connection was successful
[15:04:36] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[15:04:36] [DEBUG] mysql_errno - connection: 1
[15:04:36] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[15:04:36] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[15:04:36] [DEBUG] CMySQLConnection::Connect - connection was successful
[15:04:36] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[15:04:36] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[15:04:36] [DEBUG] CMySQLConnection::Connect - connection was successful
[15:04:36] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[15:04:36] [DEBUG] CMySQLConnection::Connect - connection was successful
[15:04:36] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[15:05:01] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `pass`, `ID` FROM `comptes` WHERE `pseudo` = '%e' LIMIT 1"
[15:05:01] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `pass`, `ID` FROM `comptes` WHERE `pseudo` = 'Malcom Saka", callback: "VerificationCompte", format: "i"
[15:05:01] [DEBUG] CMySQLQuery::Execute[VerificationCompte] - starting query execution
[15:05:01] [DEBUG] CMySQLQuery::Execute[VerificationCompte] - query was successfully executed within 0.499 milliseconds
[15:05:01] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[15:05:01] [DEBUG] Calling callback "VerificationCompte"..
[15:05:01] [DEBUG] cache_get_data - connection: 1
[15:05:01] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[15:05:08] [DEBUG] mysql_format - connection: 1, len: 250, format: "INSERT INTO `comptes` (`pseudo`, `pass`) VALUES ('%e', '%e')"
[15:05:08] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `comptes` (`pseudo`, `pass`) VALUES ('Malcom Sakafay", callback: "CreationCompte", format: "i"
[15:05:08] [DEBUG] CMySQLQuery::Execute[CreationCompte] - starting query execution
[15:05:09] [DEBUG] CMySQLQuery::Execute[CreationCompte] - query was successfully executed within 16.84 milliseconds
[15:05:09] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[15:05:09] [DEBUG] Calling callback "CreationCompte"..
[15:05:09] [DEBUG] cache_insert_id - connection: 1
[15:05:09] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[15:05:13] [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..."
[15:05:13] [DEBUG] mysql_query - connection: 1, query: "UPDATE `comptes` SET `admin` = 0,`sexe` = 1,`age` = 23,`register", use_cache: false
[15:05:13] [DEBUG] CMySQLQuery::Execute - starting query execution
[15:05:13] [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` = 14' at line 1
[15:05:13] [DEBUG] mysql_format - connection: 1, len: 2500, format: "UPDATE `comptes` SET `timeduty` = %d,`timedutyjob` = %d,`timedutyjobpv` = %d,`coke` = %d,`cokec` = %d,`morphine` = %d,`morphinec..."
[15:05:13] [DEBUG] mysql_query - connection: 1, query: "UPDATE `comptes` SET `timeduty` = 0,`timedutyjob` = 0,`timedutyj", use_cache: false
[15:05:13] [DEBUG] CMySQLQuery::Execute - starting query execution
[15:05:13] [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` = 14' at line 1
[15:05:13] [DEBUG] mysql_format - connection: 1, len: 2500, format: "UPDATE `comptes` SET `arme1` = %d,`arme2` = %d,`arme3` = %d,`arme4` = %d,`arme5` = %d,`arme6` = %d,`arme7` = %d,`arme8` = %d,`ar..."
[15:05:13] [DEBUG] mysql_query - connection: 1, query: "UPDATE `comptes` SET `arme1` = 0,`arme2` = 0,`arme3` = 0,`arme4`", use_cache: false
[15:05:13] [DEBUG] CMySQLQuery::Execute - starting query execution
[15:05:13] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 1.609 milliseconds
[15:05:13] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[15:05:13] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[15:05:13] [DEBUG] mysql_format - connection: 1, len: 2500, format: "UPDATE `comptes` SET `c_name11` = '%e',`c_name12` = '%e',`c_name13` = '%e',`c_name14` = '%e',`c_name15` = '%e',`c_name16` = '%e'..."
[15:05:13] [DEBUG] mysql_query - connection: 1, query: "UPDATE `comptes` SET `c_name11` = '',`c_name12` = '',`c_name13` ", use_cache: false
[15:05:13] [DEBUG] CMySQLQuery::Execute - starting query execution
[15:05:13] [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` = 14' at line 1
[15:05:13] [DEBUG] mysql_format - connection: 1, len: 2500, format: "UPDATE `comptes` SET `pmodelid1` = %d,`pmodelid2` = %d,`pmodelid3` = %d,`pmodelid4` = %d,`pmodelid5` = %d,`pboneid0` = %d,`pbone..."
[15:05:13] [DEBUG] mysql_query - connection: 1, query: "UPDATE `comptes` SET `pmodelid1` = 0,`pmodelid2` = 0,`pmodelid3`", use_cache: false
[15:05:13] [DEBUG] CMySQLQuery::Execute - starting query execution
[15:05:13] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 2.497 milliseconds
[15:05:13] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[15:05:13] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[15:05:13] [DEBUG] mysql_format - connection: 1, len: 2500, format: "UPDATE `comptes` SET `pfroty2` = %f,`pfroty3` = %f,`pfroty4` = %f,`pfroty5` = %f,`pfrotz0` = %f,`pfrotz1` = %f,`pfrotz2` = %f,`p..."
[15:05:13] [DEBUG] mysql_query - connection: 1, query: "UPDATE `comptes` SET `pfroty2` = 0.0,`pfroty3` = 0.0,`pfroty4` =", use_cache: false
[15:05:13] [DEBUG] CMySQLQuery::Execute - starting query execution
[15:05:13] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 1.161 milliseconds
[15:05:13] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[15:05:13] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[14:56:38] SAVE2
[14:56:38] SAVE3
[14:56:38] SAVE4
[14:56:38] SAVE5
[14:56:38] SAVE6
[14:56:38] SAVEFIN
but not save in database
Re: SavePlayerData - Dutheil - 04.08.2016
Try this :
PHP Code:
new requete[1024];
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_tquery(mysql, requete);
SCM(playerid,BLANC,"SAVE2");
mysql_format(mysql, requete, sizeof(requete), "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_tquery(mysql, requete);
SCM(playerid,BLANC,"SAVE3");
mysql_format(mysql, requete, sizeof(requete), "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_tquery(mysql, requete);
SCM(playerid,BLANC,"SAVE4");
mysql_format(mysql, requete, sizeof(requete), "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_tquery(mysql, requete);
SCM(playerid,BLANC,"SAVE5");
mysql_format(mysql, requete, sizeof(requete), "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_tquery(mysql, requete);
SCM(playerid,BLANC,"SAVE6");
mysql_format(mysql, requete, sizeof(requete), "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_tquery(mysql, requete);
SCM(playerid,BLANC,"SAVEFIN");
return 1;
Re: SavePlayerData - Stinged - 04.08.2016
If Dutheil's query doesn't work (Which I didn't read), add this and post the logs:
Code:
public OnQueryError(errorid, error[], callback[], query[], connectionHandle)
{
printf("Error ID: %i\n\nError: %s\n\nCallback: %s\n\nQuery: %s", errorid, error, callback, query);
return 1;
}
What even makes it more easier (And it's a way I use to fix my bad queries), is copying the query it prints out after adding that small part of code, and trying it on phpmyadmin. It will tell you exactly where the error is.
Re: SavePlayerData - Skinnz - 04.08.2016
Its good Dutheil, thank you
Re: SavePlayerData - Dutheil - 04.08.2016
Firstly, to use mysql_tquery you can use only 2 arguments like this :
Code:
mysql_tquery(mysql, query);
Code:
`viplvl` = %d\
WHERE `ID` = %d",
Code:
`viplvl` = %dWHERE `ID` = %d