Mysql pos and armour
#6

in the save ,edit yours to :
pawn Код:
new Float: x, Float: y, Float: z;
       GetPlayerPos(playerid, x, y, z);
       PlayerInfo[playerid][pPosX] = x;
       PlayerInfo[playerid][pPosY] = y;
       PlayerInfo[playerid][pPosZ] = z;
       mysql_format(sqldb, query, sizeof(query), "UPDATE users SET posx ='%f', posy ='%f',posz ='%f' WHERE nev ='%e'", PlayerInfo[playerid][pPosX],PlayerInfo[playerid][pPosY],PlayerInfo[playerid][pPosZ], GetName(playerid));
       mysql_query(sqldb, query);
you have to tell pawno that x = playerinfo[playerid][pposx] and y = PlayerInfo[playerid][pPosY] and z = PlayerInfo[playerid][pPosZ] , also you don't have to make more than one query, so i edited it to you to be one query.
Reply


Messages In This Thread
Mysql pos and armour - by n00el - 04.05.2014, 22:55
Re: Mysql pos and armour - by sekonoppa - 05.05.2014, 05:05
Re: Mysql pos and armour - by n00el - 05.05.2014, 05:22
Re: Mysql pos and armour - by n00el - 05.05.2014, 06:26
Re: Mysql pos and armour - by n00el - 05.05.2014, 12:23
Re: Mysql pos and armour - by Eth - 05.05.2014, 15:08
Re: Mysql pos and armour - by n00el - 05.05.2014, 16:41
Re: Mysql pos and armour - by n00el - 05.05.2014, 16:54
Re: Mysql pos and armour - by Eth - 05.05.2014, 17:37

Forum Jump:


Users browsing this thread: 1 Guest(s)