[adri1]

I have this:

pawn Код:

stock UpdateUserData(playerid)
{
    new Query[500], Float:p[4], Float:ha[2];
    GetPlayerHealth(playerid, ha[0]);
    GetPlayerArmour(playerid, ha[1]);
    GetPlayerPos(playerid, p[0], p[1], p[2]);
    GetPlayerFacingAngle(playerid, p[3]);
    format(Query, 500, "UPDATE `USERS` SET `POSX` = '%f', `POSY` = '%f', `POSZ` = '%f', `ANGLE` = '%f', `INTERIORID` = '%d', `VWID` = '%d', `DINERO` = '%d', `DINEROBANK` = '%d', `SEXO` = '%d', \
    `EDAD` = '%d', `SKIN` = '%d', `VIDA` = '%f', `CHALECO` = '%f', `ADMLVL` = '%d', `EMPADRONADO` = '%d', `PHONENUMBER` = '%d', `INTERIOR` = '%d' WHERE `NAME` = '%s'",
    p[0], p[1], p[2], p[3], GetPlayerInterior(playerid), GetPlayerVirtualWorld(playerid), PlayerInfo[playerid][email], GetPlayerMoney(playerid), PlayerInfo[playerid][dinerobank], PlayerInfo[playerid][sexo],
    PlayerInfo[playerid][edad], GetPlayerSkin(playerid), ha[0], ha[1], PlayerInfo[playerid][admlvl], PlayerInfo[playerid][empadronado], PlayerInfo[playerid][phonenumber], PlayerInfo[playerid][Interior], DB_Escape(PlayerNameNormal(playerid)));
    db_free_result(db_query(Database, Query));
    return 1;
}

And database no update info...

[Jefff]

print(Query); under db_free_result(db_query(Database, Query));

PlayerInfo[playerid][email] is `VWID` = '%d' ?

[adri1]

Yeah,

pawn Код:

stock UpdateUserData(playerid)
{
    new Query[750], Float:p[4], Float:ha[2], name[MAX_PLAYER_NAME];
    GetPlayerName(playerid, name, sizeof(name));
    printf("%s", name);
    GetPlayerHealth(playerid, ha[0]);
    GetPlayerArmour(playerid, ha[1]);
    GetPlayerPos(playerid, p[0], p[1], p[2]);
    GetPlayerFacingAngle(playerid, p[3]);
    format(Query, 750, "UPDATE `USERS` SET `POSX` = '%f', `POSY` = '%f', `POSZ` = '%f', `ANGLE` = '%f', `INTERIORID` = '%d', `VWID` = '%d', `DINERO` = '%d', `DINEROBANK` = '%d', `SEXO` = '%d', \
    `EDAD` = '%d', `SKIN` = '%d', `VIDA` = '%f', `CHALECO` = '%f', `ADMLVL` = '%d', `EMPADRONADO` = '%d', `PHONENUMBER` = '%d', `INTERIOR` = '%d' WHERE `NAME` = '%s'",
    p[0], p[1], p[2], p[3], GetPlayerInterior(playerid), GetPlayerVirtualWorld(playerid), PlayerInfo[playerid][virtualworldid], GetPlayerMoney(playerid), PlayerInfo[playerid][dinerobank], PlayerInfo[playerid][sexo],
    PlayerInfo[playerid][edad], GetPlayerSkin(playerid), ha[0], ha[1], PlayerInfo[playerid][admlvl], PlayerInfo[playerid][empadronado], PlayerInfo[playerid][phonenumber], PlayerInfo[playerid][Interior], name);
    db_free_result(db_query(Database, Query));
    print(Query);
    return 1;
}

Problem is name:

Код:

[03:30:01] adri1m
[03:30:01] UPDATE `USERS` SET `POSX` = '16.268283', `POSY` = '14.208209', `POSZ` = '3.117187', `ANGLE` = '0.000000', `INTERIORID` = '0', `VWID` = '0', `DINERO` = '0', `DINEROBANK` = '0', `SEXO` = '0', `EDAD` = '0', `SKIN` = '21', `VIDA` = '0.000000', `CHALECO` = '100.000000', `ADMLVL` = '0', `EMPADRONADO` = '0', `PHONENUMBER` = '0', `INTERIOR` = '0' WHERE `NAME` = ''

[Jefff]

Here is the problem GetPlayerVirtualWorld(playerid), PlayerInfo[playerid][virtualworldid] choose one

[adri1]

LOL, fail. Thanks Jefff!