saving user coordinates doesn't work mysql
#2

Use minimum 3 character ( i have tested, it will not work with single character)
x = posx
y = posy
z = posz
Code:
SavePlayer(playerid)
{
    if(pInfo[playerid][Logged] == 1)
    {
    	new Query[500];
    	new Float:X, Float:Y, Float:Z;
		GetPlayerPos(playerid, X, Y, Z);
        format(Query, 500, "UPDATE `playerdata` SET `admin` = '%d', `score` = '%d', `money` = '%d', `kills` = '%d', `deaths` = '%d',`posx` = '%f',`posy` = '%f',`posz` = '%f',`pInt` = '%d',`pskin` = '%d' WHERE `id` = '%d' LIMIT 1",
        pInfo[playerid][pAdmin],
        pInfo[playerid][pScore],
        pInfo[playerid][pMoney],
        pInfo[playerid][pKills],
        pInfo[playerid][pDeaths],
        pInfo[playerid][pLastX],
        pInfo[playerid][pLastY],
        pInfo[playerid][pLastZ],
        pInfo[playerid][pInt],
        pInfo[playerid][pSkin],
        pInfo[playerid][ID]);
        mysql_query(Query);
    }
}
Reply


Messages In This Thread
saving user coordinates doesn't work mysql - by Steve1312 - 20.03.2014, 07:04
Re: saving user coordinates doesn't work mysql - by VishvaJeet - 20.03.2014, 07:10
Re: saving user coordinates doesn't work mysql - by Steve1312 - 20.03.2014, 08:24
Re: saving user coordinates doesn't work mysql - by iZN - 20.03.2014, 08:50
Re: saving user coordinates doesn't work mysql - by VishvaJeet - 20.03.2014, 08:54
Re: saving user coordinates doesn't work mysql - by Steve1312 - 20.03.2014, 09:44

Forum Jump:


Users browsing this thread: 1 Guest(s)