savining pos [+rep]
#1

It doesnt save my pos in database, but why? and how i can fix it?

pawn Код:
enum pInfo
{
    pIP,
    pMoney,
    pScore,
    Float:pPos[4]
}


public OnPlayerDisconnect(playerid, reason)
{
    //================================================================//
    //                              MySQL part                        //
    //================================================================//
    if(Logged[playerid] == 1)
    {
        SetPlayerPos(playerid, PlayerInfo[playerid][pPos][0], PlayerInfo[playerid][pPos][1], PlayerInfo[playerid][pPos][2]);
        new score = GetPlayerScore(playerid);
        new money = GetPlayerMoney(playerid);
        new query[300], pname[24];
        GetPlayerName(playerid, pname, 24);
        format(query, sizeof(query), "UPDATE playerdata SET money=%d, score=%d, posx=%f, posy=%f, posz=%f, posa=%f  WHERE user='%s'",
        money,
        score,
        PlayerInfo[playerid][pPos][0],
        PlayerInfo[playerid][pPos][1],
        PlayerInfo[playerid][pPos][2],
        PlayerInfo[playerid][pPos][3],
        pname);
        mysql_query(query);
    }
    return 1;
}
Reply
#2

try this

pawn Код:
public OnPlayerDisconnect(playerid, reason)
{
    //================================================================//
    //                              MySQL part                        //
    //================================================================//
    if(Logged[playerid] == 1)
    {
        new score = GetPlayerScore(playerid);
        new money = GetPlayerMoney(playerid);
        new X,Y,X;
        new query[300], pname[24];
        GetPlayerName(playerid, pname, 24);
        format(query, sizeof(query), "UPDATE playerdata SET money=%d, score=%d, posx=%f, posy=%f, posz=%f, posa=%f  WHERE user='%s'",
        money,
        score,
        GetPlayerPosistion(playerid, x,y,z);
        x= PlayerInfo[playerid][pPos][0],
        y= PlayerInfo[playerid][pPos][1],
        z= PlayerInfo[playerid][pPos][2],
        PlayerInfo[playerid][pPos][3],
        pname);
        mysql_query(query);
    }
    return 1;
Reply
#3

Ok i got it work, was only missing:
pawn Код:
GetPlayerPos(playerid, PlayerInfo[playerid][pPos][0], PlayerInfo[playerid][pPos][1], PlayerInfo[playerid][pPos][2]);
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)