Mysql pos and armour
#3

I need mysql, because i read it from a webpage..
Yeah, its string, its my last try. (unter enum)
Код:
	pPosX[30],
	pPosY[30],
	pPosZ[30],
Its read the pos: (load player stat)
Код:
    cache_get_row(0, 13, temp); PlayerInfo[playerid][pPosX] = temp;
    cache_get_row(0, 14, temp); PlayerInfo[playerid][pPosY] = temp;
    cache_get_row(0, 15, temp); PlayerInfo[playerid][pPosZ] = temp;
Its the save: (save player stat)
Код:
	new Float: x, Float: y, Float: z;
	GetPlayerPos(playerid, x, y, z);

	mysql_format(sqldb, query, sizeof(query), "UPDATE users SET posx ='%f' WHERE nev ='%e'", x, GetName(playerid));
	mysql_query(sqldb, query);

	mysql_format(sqldb, query, sizeof(query), "UPDATE users SET posy ='%f' WHERE nev ='%e'", y, GetName(playerid));
	mysql_query(sqldb, query);

	mysql_format(sqldb, query, sizeof(query), "UPDATE users SET posz ='%f' WHERE nev ='%e'", z, GetName(playerid));
	mysql_query(sqldb, query);
After login
Код:
SetPlayerPos(playerid, PlayerInfo[playerid][pPosX], PlayerInfo[playerid][pPosY], PlayerInfo[playerid][pPosZ]);
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)