SA-MP Forums Archive
SQLite database no update - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: SQLite database no update (/showthread.php?tid=473029)



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!