saving user coordinates doesn't work mysql
#4

pawn Code:
SavePlayer(playerid)
{
    if(pInfo[playerid][Logged] == 1)
    {
        new Query[500];
        GetPlayerPos(playerid, pInfo[playerid][pLastX], pInfo[playerid][pLastY], pInfo[playerid][pLastZ]);
        format(Query, sizeof(Query), "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: 2 Guest(s)