[Skinnz]

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] SAVE1

[13:48:33] SAVE2

[F1N4L]

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; 
}

[Skinnz]

thank you, but what you have changed?

[F1N4L]

Код:

mysql_tquery(...);

to

Код:

mysql_query(...);

[Skinnz]

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] SAVEPLAYERDATA

[14:06:11] SAVE1

[14:06:11] SAVE2

[Skinnz]

and
[DEBUG] mysql_query - connection: 1, query: "UPDATE `comptes` SET `admin` = 0,`sexe` = 1,`age` = 23,`register", use_cache: true

but

[F1N4L]

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; 
}

@edit

Make a debug...

[Skinnz]

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] SAVE1

[14:26:07] SAVE2

how to do ?

[F1N4L]

Register is integer or varchar?

[Skinnz]

integer, samllint(5)

[Stinged]

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.

[Skinnz]

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] SAVE1

[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

[Dutheil]

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; 


[Stinged]

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;
}

I'm sorry but I'm too lazy to carefully check for the logs you posted, so that'll make it easier to identify the error.

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.

[Skinnz]

Its good Dutheil, thank you

[Dutheil]

Firstly, to use mysql_tquery you can use only 2 arguments like this :

Code:

mysql_tquery(mysql, query);

Then, the problem came from the control character:

Code:

    `viplvl` = %d\ 
    WHERE `ID` = %d",

Compiles like that :

Code:

`viplvl` = %dWHERE `ID` = %d

So WHERE%d (or WHERE2 per exemple) isn't known by the language SQL, you need so to put a space character before your backslash.