19.01.2015, 02:14
try this
pawn Код:
stock SaveAccount(playerid)
{
GetPlayerPos(playerid,PlayerInfo[playerid][pPosX],PlayerInfo[playerid][pPosY],PlayerInfo[playerid][pPosZ]);
GetPlayerFacingAngle(playerid,PlayerInfo[playerid][pPosA]);
GetPlayerHealth(playerid,PlayerInfo[playerid][pHealth]);
GetPlayerArmour(playerid,PlayerInfo[playerid][pArmor]);
new string[2000];
PlayerInfo[playerid][pSkin] = GetPlayerSkin(playerid);
mysql_format(sqlid,query,sizeof(query),"UPDATE `users` SET ,`px` = %f,`py` = %f,`pz` = %f,`pa` = %f,`hp` = %f,`armor` = %f WHERE username = '%e'",PlayerInfo[playerid][pPosX], PlayerInfo[playerid][pPosY], PlayerInfo[playerid][pPosZ], PlayerInfo[playerid][pPosA], PlayerInfo[playerid][pHealth], PlayerInfo[playerid][pArmor], GPN(playerid));
mysql_tquery(sqlid,query, "", "");