[Capotte]

hello I have a problem that keeps me off the mysql everything to 0 and do not understand why but if the stock I put in a cmd saved working properly

I have no errors or anything that keeps me alone value to 0

mysql_log

Quote:

UPDATE `cuenta` SET `posx` = 0.00,`posy` =0.00,`posz` =0.00,`angle` ='0.00 WHERE `nombre`=

Quote:

public OnPlayerDisconnect(playerid, reason) { GuardarDatos(playerid); retrun 1; }

datos al guardar

Quote:

forward GuardarDatos(playerid); public GuardarDatos(playerid) { new Query[1000], Float:ha[3], Floatos[3]; GetPlayerHealth(playerid, ha[0]); GetPlayerArmour(playerid, ha[1]); PlayerInfo[playerid][interiorid] = GetPlayerInterior(playerid); GivePlayerMoney(playerid, PlayerInfo[playerid][dinero]); GetPlayerPos(playerid, pos[0], pos[1], pos[2]); GetPlayerFacingAngle(playerid, PlayerInfo[playerid][angle]); new pName[24]; GetPlayerName(playerid, pName, 24); PlayerInfo[playerid][skin] = GetPlayerSkin(playerid); format(Query, sizeof(Query), "UPDATE `cuenta` SET `posx` = %.2f,`posy` =%.2f,`posz` =%.2f,`angle` ='%.2f WHERE `nombre`= %s", pos[0], pos[1], pos[2], PlayerInfo[playerid][angle], pName); mysql_function_query(TuberiasMySQL, Query, false, "OnQueryFinish", "ii", SIN_RESULTADO, playerid); format(Query, sizeof(Query), "UPDATE `cuenta` SET `interiorid`=%d,`virtualworldid`= %d,`adminlvl`= %d,`vgrotti`= %d,`vbank`= %d,`agonizando`= %d,`miembro`= %d,`rango`= %d WHERE `nombre`='%s'", PlayerInfo[playerid][interiorid],PlayerInfo[playerid][virtualworldid], PlayerInfo[playerid][adminlvl], PlayerInfo[playerid][VGrotti],PlayerInfo[playerid][VBank],PlayerInfo[playerid][Agonizando],PlayerInfo[playerid][miembro],PlayerInfo[playerid][rango], pName); mysql_function_query(TuberiasMySQL, Query, false, "OnQueryFinish", "ii", SIN_RESULTADO, playerid); format(Query, sizeof(Query), "UPDATE `cuenta` SET `cargo`= %d,`pmodel`= %d,`placa`= %d,`job`= %d,`vipjob`= %d,`dinero`= %d,`dinerobank`= %d,`banco`= %d,`movil`= %d WHERE `nombre`='%s'", PlayerInfo[playerid][Cargos], PlayerInfo[playerid][pModelo], PlayerInfo[playerid][Placa], PlayerInfo[playerid][job], PlayerInfo[playerid][vipjob],PlayerInfo[playerid][dinero],PlayerInfo[playerid][dinerobank], PlayerInfo[playerid][banco], PlayerInfo[playerid][movil], pName); mysql_function_query(TuberiasMySQL, Query, false, "OnQueryFinish", "ii", SIN_RESULTADO, playerid); format(Query, sizeof(Query), "UPDATE `cuenta` SET `dini`= %d,`sexo`= %d,`edad`= %d,`skin`= %d,`busquedad`= %d,`faccion`= %d,`lider`= %d, `tiempojail`= %d WHERE `nombre`='%s'", PlayerInfo[playerid][dni], PlayerInfo[playerid][sexo], PlayerInfo[playerid][edad], PlayerInfo[playerid][skin],PlayerInfo[playerid][Busqueda],PlayerInfo[playerid][faccion], PlayerInfo[playerid][lider], PlayerInfo[playerid][jailminutes], pName); mysql_function_query(TuberiasMySQL, Query, false, "OnQueryFinish", "ii", SIN_RESULTADO, playerid); format(Query, sizeof(Query), "UPDATE `cuenta` SET `vida`= %f,`chaleco`= %f,`canaldudas`= %d,`keycar1`= %d,`keycar2`= %d,`keycar3`= %d,`keycar4`= %d,`moneda`= %d,`encasa`=%d WHERE `nombre`='%s'", ha[0], ha[1], PlayerInfo[playerid][DudeChannel], PlayerInfo[playerid][PlayerVehicle][0],PlayerInfo[playerid][PlayerVehicle][1], PlayerInfo[playerid][PlayerVehicle][2], PlayerInfo[playerid][PlayerVehicle][3], PlayerInfo[playerid][Moneda], PlayerInfo[playerid][EnCasa], pName); mysql_function_query(TuberiasMySQL, Query, false, "OnQueryFinish", "ii", SIN_RESULTADO, playerid); format(Query, sizeof(Query),"UPDATE `cuenta` SET `enropero`= %d,`engarage`= %d,`hprecio`=%d,`hmoneda`= %d,`h2precio`= %d,`h2moneda`= %d,`casaid`= %d,`casaid2`= %d,`nivel`=%d WHERE `nombre`='%s'",PlayerInfo[playerid][EnRopero],PlayerInfo[playerid][EnGarage], PlayerInfo[playerid][hprecio],PlayerInfo[playerid][hmoneda],PlayerInfo[playerid][h2precio],PlayerInfo[playerid][h2moneda],PlayerInfo[playerid][CasaID],PlayerInfo[playerid][CasaID2], PlayerInfo[playerid][nivel], pName); mysql_function_query(TuberiasMySQL, Query, true, "OnQueryFinish", "ii", 0, playerid); format(Query, sizeof(Query), "UPDATE `cuenta` SET `exp`= %d,`barreta`= %d,`destornillador`= %d,`pnivelladron`= %d,`pexpladron`= %d,`martillo`= %d,`piezas`= %d,`pnivelarmero`= %d,`pexparmero`= %d WHERE `nombre`='%s'", PlayerInfo[playerid][jBarreta], PlayerInfo[playerid][jDestornillador], PlayerInfo[playerid][pNivelLadron], PlayerInfo[playerid][pexpladron], PlayerInfo[playerid][jMartillo], PlayerInfo[playerid][piezas], PlayerInfo[playerid][pNivelArmero], PlayerInfo[playerid][pExpArmero], pName); mysql_function_query(TuberiasMySQL, Query, true, "OnQueryFinish", "ii", 0, playerid); format(Query, sizeof(Query), "UPDATE `cuenta` SET `pmedicamentos`= %d,`pcrack`= %d,`pmateriales`= %d WHERE `nombre`='%s'", PlayerInfo[playerid][pMedicamentos], PlayerInfo[playerid][pCrack], PlayerInfo[playerid][pMateriales], pName); mysql_function_query(TuberiasMySQL, Query, true, "OnQueryFinish", "ii", 0, playerid); format(Query, sizeof(Query), "UPDATE `cuenta` SET `creditos`= %d,`pnivelcamionero`= %d,`pexpcamionero`= %d WHERE `nombre`='%s'", PlayerInfo[playerid][creditos], PlayerInfo[playerid][pNivelCamionero], PlayerInfo[playerid][pExpCamionero], pName); mysql_function_query(TuberiasMySQL, Query, true, "OnQueryFinish", "ii", 0, playerid); format(Query, sizeof(Query), "UPDATE `cuenta` SET `bankt`= %d,`vip`= %d,`banka`= %d,`arrestado`= %d WHERE `nombre`='%s'", PlayerInfo[playerid][bankt], PlayerInfo[playerid][vip],PlayerInfo[playerid][BankA], PlayerInfo[playerid][arrestado], pName); mysql_function_query(TuberiasMySQL, Query, true, "OnQueryFinish", "ii", 0, playerid); return 1; }

[TheDrx]

Quote:

'0.00 WHERE

Take the ' out. It shouln't be there.