SA-MP Forums Archive
mysql 0,0,0 pos - 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: mysql 0,0,0 pos (/showthread.php?tid=657245)


mysql 0,0,0 pos - reddoxx - 03.08.2018

this code will give back 0,0,0 position

Код:
			if(!strcmp(option2, "interior", true))
			{
				new Float:pos[3];
        		GetPlayerPos(playerid, pos[0], pos[1], pos[2]);
        		new interior = GetPlayerInterior(playerid);
				mysql_format(SQL_CONNECTION, query, sizeof(query), "UPDATE Business SET InteriorX = %f, InteriorY = %f, InteriorZ = %f, Interior = %f WHERE SQLID = %d LIMIT 1",
												pos[0],
												pos[1],
												pos[2],
												interior,
												Business[playerid][SQLID]);
				//mysql_tquery(SQL_CONNECTION, query, "GetBizID", "i", playerid);

				mysql_tquery(SQL_CONNECTION, query);
				SendClientMessage(playerid, COLOR_GREEN, "> Biznisz frissнtve!");
				ReloadBiz();
			}


Re: mysql 0,0,0 pos - reddoxx - 06.08.2018

bump

Re: mysql 0,0,0 pos - Florin48 - 06.08.2018

you try to save biz pos ? or what you cant do?

Re: mysql 0,0,0 pos - Sew_Sumi - 06.08.2018

First thing I'd check is that the coord tables in the database are actually floats...