Position saving - Printable Version

Position saving - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Position saving (/showthread.php?tid=143142)

Position saving - martyz-lithuania - 21.04.2010

Hello, I'm using this -http://forum.sa-mp.com/index.php?topic=148182.0 MySQL plugin, but i have the problem with the player position saving. It can save everything, but not the player position..

Here's the code:

Код:

<...>
GetPlayerPos(playerid,Pos[0],Pos[1],Pos[2]);
<...>
format(query, 1024,"UPDATE "SQL_TABLE" SET Numeris = '%d', Mobilus = '%d', X_Kordinate = '%s', Y_Kordinate = '%s', Z_Kordinate = '%s' WHERE vardas = '%s'",pInfo[playerid][Mobilus],Pos[0],Pos[1],Pos[2],pInfo[playerid][Nick]);
  mysql_query(query);
  mysql_free_result();
<...>

Help me someone

Re: Position saving - martyz-lithuania - 21.04.2010

I don't want to spam or something, but I really need help fast!

Re: Position saving - Sergei - 21.04.2010

Since whne are coordinates strings?

Код:

<...>
GetPlayerPos(playerid,Pos[0],Pos[1],Pos[2]);
<...>
format(query, 1024,"UPDATE "SQL_TABLE" SET Numeris = %d, Mobilus = %d, X_Kordinate = %f, Y_Kordinate = %f, Z_Kordinate = %f WHERE vardas = '%s'",pInfo[playerid][Mobilus],Pos[0],Pos[1],Pos[2],pInfo[playerid][Nick]);
  mysql_query(query);
<...>

And next time ask in plugin's topic.

Re: Position saving - martyz-lithuania - 22.04.2010

it's in the top of save stock..

Re: Position saving - martyz-lithuania - 22.04.2010

help!

Re: Position saving - martyz-lithuania - 23.04.2010

someone?