11.08.2016, 22:05
Hello, i have a problem, my Account not save mysql except pass and pseudo
mysql_log
i have already had this problem ( https://sampforum.blast.hk/showthread.php?tid=614084&page=2 ) but there is something else
can you help me please ?
mysql_log
PHP код:
[23:59:25] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "samp", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[23:59:25] [DEBUG] CMySQLHandle::Create - creating new connection..
[23:59:25] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[23:59:25] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[23:59:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:59:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:59:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:59:25] [DEBUG] mysql_errno - connection: 1
[23:59:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:59:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:59:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[23:59:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:59:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:59:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:59:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:59:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[23:59:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[23:59:57] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT * FROM `comptes` WHERE `pseudo` = '%e' LIMIT 1"
[23:59:57] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `comptes` WHERE `pseudo` = 'Malcom Sakafay' LIMIT ", callback: "VerificationCompte", format: "i"
[23:59:57] [DEBUG] CMySQLQuery::Execute[VerificationCompte] - starting query execution
[23:59:57] [DEBUG] CMySQLQuery::Execute[VerificationCompte] - query was successfully executed within 0.567 milliseconds
[23:59:57] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[23:59:57] [DEBUG] Calling callback "VerificationCompte"..
[23:59:57] [DEBUG] cache_get_data - connection: 1
[23:59:57] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[00:00:08] [DEBUG] mysql_format - connection: 1, len: 250, format: "INSERT INTO `comptes` (`pseudo`, `pass`) VALUES ('%e', '%e')"
[00:00:08] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `comptes` (`pseudo`, `pass`) VALUES ('Malcom Sakafay", callback: "CreationCompte", format: "i"
[00:00:08] [DEBUG] CMySQLQuery::Execute[CreationCompte] - starting query execution
[00:00:08] [DEBUG] CMySQLQuery::Execute[CreationCompte] - query was successfully executed within 44.609 milliseconds
[00:00:08] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[00:00:08] [DEBUG] Calling callback "CreationCompte"..
[00:00:08] [DEBUG] cache_get_field_content_int - row: 0, field_name: "id", connection: 1
[00:00:08] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[00:00:08] [ERROR] cache_get_field_content_int - invalid datatype
[00:00:08] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[00:00:17] [DEBUG] mysql_format - connection: 1, len: 1024, format: "UPDATE `comptes` SET `pseudo` = '%e',`pass` = '%e' WHERE `id` = %d"
[00:00:17] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `comptes` SET `pseudo` = 'Malcom Sakafay',`pass` = '' WHE", callback: "(null)", format: "(null)"
[00:00:17] [DEBUG] mysql_format - connection: 1, len: 1024, format: "UPDATE `comptes` SET `admin` = %d, `sexe` = %d, `age` = %d, `tokens` = %d, `tuto` = %d, `ip` = '%e', `skin` = %d, `faction` = %d..."
[00:00:17] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `comptes` SET `admin` = 0, `sexe` = 1, `age` = 23, `token", callback: "(null)", format: "(null)"
[00:00:17] [DEBUG] mysql_format - connection: 1, len: 1024, format: "UPDATE `comptes` SET `timeduty` = %d, `timedutyjob` = %d, `timedutyjobpv` = %d, `coke` = %d, `cokec` = %d, `morphine` = %d, `mor..."
[00:00:17] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `comptes` SET `timeduty` = 0, `timedutyjob` = 0, `timedut", callback: "(null)", format: "(null)"
[00:00:17] [DEBUG] mysql_format - connection: 1, len: 1024, format: "UPDATE `comptes` SET `arme1` = %d, `arme2` = %d, `arme3` = %d, `arme4` = %d, `arme5` = %d, `arme6` = %d, `arme7` = %d, `arme8` =..."
[00:00:17] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `comptes` SET `arme1` = 0, `arme2` = 0, `arme3` = 0, `arm", callback: "(null)", format: "(null)"
[00:00:17] [DEBUG] mysql_format - connection: 1, len: 1024, format: "UPDATE `comptes` SET `c_name11` = '%e', `c_name12` = '%e', `c_name13` = '%e', `c_name14` = '%e', `c_name15` = '%e', `c_name16` =..."
[00:00:17] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `comptes` SET `c_name11` = '', `c_name12` = '', `c_name13", callback: "(null)", format: "(null)"
[00:00:17] [DEBUG] mysql_format - connection: 1, len: 1024, format: "UPDATE `comptes` SET `pmodelid1` = %d, `pmodelid2` = %d, `pmodelid3` = %d, `pmodelid4` = %d, `pmodelid5` = %d, `pboneid0` = %d, ..."
[00:00:17] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `comptes` SET `pmodelid1` = 0, `pmodelid2` = 0, `pmodelid", callback: "(null)", format: "(null)"
[00:00:17] [DEBUG] mysql_format - connection: 1, len: 1024, format: "UPDATE `comptes` SET `pfroty2` = %f, `pfroty3` = %f, `pfroty4` = %f, `pfroty5` = %f, `pfrotz0` = %f, `pfrotz1` = %f, `pfrotz2` =..."
[00:00:17] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `comptes` SET `pfroty2` = 0.0, `pfroty3` = 0.0, `pfroty4`", callback: "(null)", format: "(null)"
[00:00:17] [DEBUG] mysql_format - connection: 1, len: 1024, format: "UPDATE `comptes` SET `ttel` = %d, `tplaque` = %d, `tnomoff` = %d, `tnomoffdur` = %d, `tnom` = %d, `tspray` = %d, `tspraydur` = %..."
[00:00:17] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `comptes` SET `ttel` = 0, `tplaque` = 0, `tnomoff` = 0, `", callback: "(null)", format: "(null)"
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.385 milliseconds
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.165 milliseconds
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.157 milliseconds
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.148 milliseconds
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.160 milliseconds
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.215 milliseconds
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.229 milliseconds
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.192 milliseconds
[00:00:17] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[00:00:53] [DEBUG] mysql_format - connection: 1, len: 1024, format: "UPDATE `comptes` SET `pseudo` = '%e',`pass` = '%e' WHERE `id` = %d"
[00:00:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `comptes` SET `pseudo` = 'Malcom Sakafay',`pass` = '' WHE", callback: "(null)", format: "(null)"
[00:00:53] [DEBUG] mysql_format - connection: 1, len: 1024, format: "UPDATE `comptes` SET `admin` = %d, `sexe` = %d, `age` = %d, `tokens` = %d, `tuto` = %d, `ip` = '%e', `skin` = %d, `faction` = %d..."
[00:00:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `comptes` SET `admin` = 0, `sexe` = 1, `age` = 23, `token", callback: "(null)", format: "(null)"
[00:00:53] [DEBUG] mysql_format - connection: 1, len: 1024, format: "UPDATE `comptes` SET `timeduty` = %d, `timedutyjob` = %d, `timedutyjobpv` = %d, `coke` = %d, `cokec` = %d, `morphine` = %d, `mor..."
[00:00:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `comptes` SET `timeduty` = 0, `timedutyjob` = 0, `timedut", callback: "(null)", format: "(null)"
[00:00:53] [DEBUG] mysql_format - connection: 1, len: 1024, format: "UPDATE `comptes` SET `arme1` = %d, `arme2` = %d, `arme3` = %d, `arme4` = %d, `arme5` = %d, `arme6` = %d, `arme7` = %d, `arme8` =..."
[00:00:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `comptes` SET `arme1` = 0, `arme2` = 0, `arme3` = 0, `arm", callback: "(null)", format: "(null)"
[00:00:53] [DEBUG] mysql_format - connection: 1, len: 1024, format: "UPDATE `comptes` SET `c_name11` = '%e', `c_name12` = '%e', `c_name13` = '%e', `c_name14` = '%e', `c_name15` = '%e', `c_name16` =..."
[00:00:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `comptes` SET `c_name11` = '', `c_name12` = '', `c_name13", callback: "(null)", format: "(null)"
[00:00:53] [DEBUG] mysql_format - connection: 1, len: 1024, format: "UPDATE `comptes` SET `pmodelid1` = %d, `pmodelid2` = %d, `pmodelid3` = %d, `pmodelid4` = %d, `pmodelid5` = %d, `pboneid0` = %d, ..."
[00:00:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `comptes` SET `pmodelid1` = 0, `pmodelid2` = 0, `pmodelid", callback: "(null)", format: "(null)"
[00:00:53] [DEBUG] mysql_format - connection: 1, len: 1024, format: "UPDATE `comptes` SET `pfroty2` = %f, `pfroty3` = %f, `pfroty4` = %f, `pfroty5` = %f, `pfrotz0` = %f, `pfrotz1` = %f, `pfrotz2` =..."
[00:00:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `comptes` SET `pfroty2` = 0.0, `pfroty3` = 0.0, `pfroty4`", callback: "(null)", format: "(null)"
[00:00:53] [DEBUG] mysql_format - connection: 1, len: 1024, format: "UPDATE `comptes` SET `ttel` = %d, `tplaque` = %d, `tnomoff` = %d, `tnomoffdur` = %d, `tnom` = %d, `tspray` = %d, `tspraydur` = %..."
[00:00:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `comptes` SET `ttel` = 0, `tplaque` = 0, `tnomoff` = 0, `", callback: "(null)", format: "(null)"
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.324 milliseconds
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.197 milliseconds
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.169 milliseconds
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.149 milliseconds
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.186 milliseconds
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.153 milliseconds
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.142 milliseconds
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.127 milliseconds
[00:00:53] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
PHP код:
function SavePlayerData(playerid){
new requete[1024]/*, ip[16]*/;
/*GetPlayerIp(playerid, ip, sizeof(ip));*/
mysql_format(mysql, requete, sizeof(requete), "UPDATE `comptes` SET `pseudo` = '%e',`pass` = '%e' WHERE `id` = %d",
RPName(playerid),
pinfo[playerid][Pass],
pinfo[playerid][ID]);
mysql_tquery(mysql, requete);
mysql_format(mysql, requete, sizeof(requete), "UPDATE `comptes` SET `admin` = %d, \
`sexe` = %d, \
`age` = %d, \
`tokens` = %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][Tokens],
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);
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);
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);
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);
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);
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, \
`adn` = %d \
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][ADN],
pinfo[playerid][ID]);
mysql_tquery(mysql, requete);
mysql_format(mysql, requete, sizeof(requete), "UPDATE `comptes` SET `ttel` = %d, \
`tplaque` = %d, \
`tnomoff` = %d, \
`tnomoffdur` = %d, \
`tnom` = %d, \
`tspray` = %d, \
`tspraydur` = %d, \
`tveh` = %d, \
`tvehdur` = %d, \
`tinv` = %d, \
`tinvdur` = %d, \
`tfac` = %d, \
`tfacdur` = %d, \
`tafk` = %d, \
`tafkdur` = %d, \
`tmaison` = %d, \
`tbiz` = %d, \
`tmaison2` = %d, \
`tbiz2` = %d, \
`tbiz3` = %d, \
`cyber` = %d \
WHERE `id` = %d",
pinfo[playerid][ttel],
pinfo[playerid][tplaque],
pinfo[playerid][tnomoff],
pinfo[playerid][tnomoffdur],
pinfo[playerid][tnom],
pinfo[playerid][tspray],
pinfo[playerid][tspraydur],
pinfo[playerid][tveh],
pinfo[playerid][tvehdur],
pinfo[playerid][tinv],
pinfo[playerid][tinvdur],
pinfo[playerid][tfac],
pinfo[playerid][tfacdur],
pinfo[playerid][tafk],
pinfo[playerid][tafkdur],
pinfo[playerid][tmaison],
pinfo[playerid][tbiz],
pinfo[playerid][tmaison2],
pinfo[playerid][tbiz2],
pinfo[playerid][tbiz3],
pinfo[playerid][cyber],
pinfo[playerid][ID]);
mysql_tquery(mysql, requete);
return 1;
}
