Player Spawning
#1

Okay one more issue. Why are the players not saving the positions on player disconnect? Everything else is saving, just not the player position:

pawn Код:
stock SaveAccount(playerid)
{
    new query[2000], Float:x, Float:y, Float:z, Float:a, pname[24];

    GetPlayerPos(playerid, x, y, z);
    GetPlayerFacingAngle(playerid, a);
    GetPlayerName(playerid, pname, 24);
    PlayerInfo[playerid][pAdminDuty] = 0;
    PlayerInfo[playerid][pPos][0] = x;
    PlayerInfo[playerid][pPos][1] = y;
    PlayerInfo[playerid][pPos][2] = z;
    PlayerInfo[playerid][pPos][3] = a;

    format(query, sizeof(query), "UPDATE `playerdata` SET `Gender`=%d, `Cash`=%d, `Bank`=%d, `BankReg`=%d, `Level`=%d, `Skin`=%d, `Admin`=%d, `AdminDuty`=%d, `Owner`=%d, `Job`=%d, `Interior`=%d, `VirtualWorld`=%d, `NewbMute`=%d, `GetHouseID`=%d,");
    format(query, sizeof(query), "`VehID`=%d, `VehName`=%d, `VehX`=%f, `VehY`=%f, `VehZ`=%f, `VehA`=%f, `Veh2ID`=%d, `Veh2Name`=%d, `Veh2X`=%f, `Veh2Y`=%f, `Veh2Z`=%f, `Veh2A`=%f, `PosX`=%f, `PosY`=%f, `PosZ`=%f, `PosA`=%f WHERE `Username`=%s",
    PlayerInfo[playerid][pGender], PlayerInfo[playerid][pCash], PlayerInfo[playerid][pBank], PlayerInfo[playerid][pBankReg], PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pAdminDuty], PlayerInfo[playerid][pOwner],
    PlayerInfo[playerid][pJob], PlayerInfo[playerid][pInterior], PlayerInfo[playerid][pVirtualWorld], PlayerInfo[playerid][pNewbMute], PlayerInfo[playerid][pGetHouseID], PlayerInfo[playerid][pVehID], PlayerInfo[playerid][pVehName], PlayerInfo[playerid][pVehX],
    PlayerInfo[playerid][pVehY], PlayerInfo[playerid][pVehZ], PlayerInfo[playerid][pVehA], PlayerInfo[playerid][pVeh2ID], PlayerInfo[playerid][pVeh2Name], PlayerInfo[playerid][pVeh2X], PlayerInfo[playerid][pVeh2Y], PlayerInfo[playerid][pVeh2Z], PlayerInfo[playerid][pVeh2A],
    PlayerInfo[playerid][pPos][0], PlayerInfo[playerid][pPos][1], PlayerInfo[playerid][pPos][2], PlayerInfo[playerid][pPos][3], pname);
    mysql_function_query(dbHandle, query, false, "", "");
    return 1;
}
Reply
#2

No one?
Reply
#3

You such a big loser

pawn Код:
stock SaveAccount(playerid)
{
    new query[2000], Float:x, Float:y, Float:z, Float:a, pname[24];

    GetPlayerPos(playerid, x, y, z);
    GetPlayerFacingAngle(playerid, a);
    GetPlayerName(playerid, pname, 24);
    PlayerInfo[playerid][pAdminDuty] = 0;
    PlayerInfo[playerid][pPos][0] = x;
    PlayerInfo[playerid][pPos][1] = y;
    PlayerInfo[playerid][pPos][2] = z;
    PlayerInfo[playerid][pPos][3] = a;

    format(query, sizeof(query), "UPDATE `playerdata` SET `Gender`='%d', `Cash`='%d', `Bank`='%d', `BankReg`='%d', `Level`='%d', `Skin`='%d', `Admin`='%d', `AdminDuty`='%d', `Owner`='%d', `Job`='%d', `Interior`='%d', `VirtualWorld`='%d', `NewbMute`='%d', `GetHouseID`='%d',");
    format(query, sizeof(query), "`VehID`=%d, `VehName`=%d, `VehX`=%f, `VehY`=%f, `VehZ`=%f, `VehA`=%f, `Veh2ID`=%d, `Veh2Name`=%d, `Veh2X`=%f, `Veh2Y`=%f, `Veh2Z`=%f, `Veh2A`=%f, `PosX`=%f, `PosY`=%f, `PosZ`=%f, `PosA`=%f WHERE `Username`=%s",
    PlayerInfo[playerid][pGender], PlayerInfo[playerid][pCash], PlayerInfo[playerid][pBank], PlayerInfo[playerid][pBankReg], PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pAdminDuty], PlayerInfo[playerid][pOwner],
    PlayerInfo[playerid][pJob], PlayerInfo[playerid][pInterior], PlayerInfo[playerid][pVirtualWorld], PlayerInfo[playerid][pNewbMute], PlayerInfo[playerid][pGetHouseID], PlayerInfo[playerid][pVehID], PlayerInfo[playerid][pVehName], PlayerInfo[playerid][pVehX],
    PlayerInfo[playerid][pVehY], PlayerInfo[playerid][pVehZ], PlayerInfo[playerid][pVehA], PlayerInfo[playerid][pVeh2ID], PlayerInfo[playerid][pVeh2Name], PlayerInfo[playerid][pVeh2X], PlayerInfo[playerid][pVeh2Y], PlayerInfo[playerid][pVeh2Z], PlayerInfo[playerid][pVeh2A],
    PlayerInfo[playerid][pPos][0], PlayerInfo[playerid][pPos][1], PlayerInfo[playerid][pPos][2], PlayerInfo[playerid][pPos][3], pname);
    mysql_function_query(dbHandle, query, false, "OnQueryFinish", "siii");
    return 1;
}
Reply
#4

Quote:
Originally Posted by xganyx
Посмотреть сообщение
You such a big loser

pawn Код:
stock SaveAccount(playerid)
{
    new query[2000], Float:x, Float:y, Float:z, Float:a, pname[24];

    GetPlayerPos(playerid, x, y, z);
    GetPlayerFacingAngle(playerid, a);
    GetPlayerName(playerid, pname, 24);
    PlayerInfo[playerid][pAdminDuty] = 0;
    PlayerInfo[playerid][pPos][0] = x;
    PlayerInfo[playerid][pPos][1] = y;
    PlayerInfo[playerid][pPos][2] = z;
    PlayerInfo[playerid][pPos][3] = a;

    format(query, sizeof(query), "UPDATE `playerdata` SET `Gender`='%d', `Cash`='%d', `Bank`='%d', `BankReg`='%d', `Level`='%d', `Skin`='%d', `Admin`='%d', `AdminDuty`='%d', `Owner`='%d', `Job`='%d', `Interior`='%d', `VirtualWorld`='%d', `NewbMute`='%d', `GetHouseID`='%d',");
    format(query, sizeof(query), "`VehID`=%d, `VehName`=%d, `VehX`=%f, `VehY`=%f, `VehZ`=%f, `VehA`=%f, `Veh2ID`=%d, `Veh2Name`=%d, `Veh2X`=%f, `Veh2Y`=%f, `Veh2Z`=%f, `Veh2A`=%f, `PosX`=%f, `PosY`=%f, `PosZ`=%f, `PosA`=%f WHERE `Username`=%s",
    PlayerInfo[playerid][pGender], PlayerInfo[playerid][pCash], PlayerInfo[playerid][pBank], PlayerInfo[playerid][pBankReg], PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pAdminDuty], PlayerInfo[playerid][pOwner],
    PlayerInfo[playerid][pJob], PlayerInfo[playerid][pInterior], PlayerInfo[playerid][pVirtualWorld], PlayerInfo[playerid][pNewbMute], PlayerInfo[playerid][pGetHouseID], PlayerInfo[playerid][pVehID], PlayerInfo[playerid][pVehName], PlayerInfo[playerid][pVehX],
    PlayerInfo[playerid][pVehY], PlayerInfo[playerid][pVehZ], PlayerInfo[playerid][pVehA], PlayerInfo[playerid][pVeh2ID], PlayerInfo[playerid][pVeh2Name], PlayerInfo[playerid][pVeh2X], PlayerInfo[playerid][pVeh2Y], PlayerInfo[playerid][pVeh2Z], PlayerInfo[playerid][pVeh2A],
    PlayerInfo[playerid][pPos][0], PlayerInfo[playerid][pPos][1], PlayerInfo[playerid][pPos][2], PlayerInfo[playerid][pPos][3], pname);
    mysql_function_query(dbHandle, query, false, "OnQueryFinish", "siii");
    return 1;
}
Fix up your attitude and quit calling someone else a loser when he is asking for a help.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)