SQLite - Save position player - Printable Version

SQLite - Save position player - 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 - Save position player (/showthread.php?tid=443177)

SQLite - Save position player - u3games - 10.06.2013

Hi all ^^

My code:

Код:

new string[256];
new Float:posx;
new Float:posy;
new Float:posz;

GetPlayerPos(playerid, posx, posy, posz);
format(string, sizeof(string), "UPDATE `PLAYER` SET `POSX` = '%f' AND `POSY` = '%f' AND `POSZ` = '%f' WHERE NAME= '%s'", posx, posy, posz, DB_Escape(NamePlayer(playerid)));
db_free_result(db_query(Sqlite, string));

No save in Sqlite.db, code of table:

Код:

CREATE TABLE `PLAYER` (`NAME` VARCHAR(45), `SCORE` SMALLINT(5) DEFAULT 0, `KARMA` SMALLINT(5) DEFAULT 0, `POSX` FLOAT DEFAULT 0.0, `POSY` FLOAT DEFAULT 0.0, `POSZ` FLOAT DEFAULT 0.0, `SKIN` SMALLINT(3) DEFAULT 0);

PD: I create POSX, POSY and POSZ in table with Float. But not save, for default in db 0.0

Thx for all, waiting posible fix

Re: SQLite - Save position player - Knappen - 10.06.2013

pawn Код:

format(string, sizeof(string), "UPDATE `PLAYER` SET `POSX` = %f, `POSY` = %f, `POSZ` = %f WHERE `NAME`= '%s'", posx, posy, posz, DB_Escape(NamePlayer(playerid)));

Respuesta: Re: SQLite - Save position player - u3games - 10.06.2013

Quote:

Originally Posted by Knappen

pawn Код:

format(string, sizeof(string), "UPDATE `PLAYER` SET `POSX` = %f, `POSY` = %f, `POSZ` = %f WHERE `NAME`= '%s'", posx, posy, posz, DB_Escape(NamePlayer(playerid)));

Thx Knappen, work! ^^