mysql problem save hp - Printable Version

mysql problem save hp - 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 problem save hp (/showthread.php?tid=644508)

mysql problem save hp - Kubad - 09.11.2017

Hello guys i trying save health in mysql but i have problem if i try this i failed i trying saving with classic update.

Код:

new Float:hp;
GetPlayerHealth(playerid, hp);

format(query,sizeof(query),"UPDATE `data` SET `Health` = '%d' WHERE  `name` =  '%s';",hp,name(playerid));
mysql_query(handle,query);

Re: mysql problem save hp - Erioni - 09.11.2017

Well, you get your health as a float, so save it as a Float.
Change %d to %f

Rep+ if you think I helped and feel free to ask me anything else!

Re: mysql problem save hp - Kubad - 09.11.2017

thank you you help me

Re: mysql problem save hp - Erioni - 09.11.2017

No problem mate, feel free to PM me about anything and I'll help you as best as I can!