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! ^^