01.11.2013, 02:18
Yeah,
Problem is name:
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;
}
Код:
[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` = ''
