SQLite database no update -
adri1 - 01.11.2013
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...
Re: SQLite database no update -
Jefff - 01.11.2013
print(Query); under db_free_result(db_query(Database, Query));
PlayerInfo[playerid][email] is `VWID` = '%d' ?
Respuesta: SQLite database no update -
adri1 - 01.11.2013
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` = ''
Re: SQLite database no update -
Jefff - 01.11.2013
Here is the problem GetPlayerVirtualWorld(playerid), PlayerInfo[playerid][virtualworldid] choose one
Respuesta: SQLite database no update -
adri1 - 01.11.2013
LOL, fail. Thanks Jefff!