28.01.2013, 10:38
It duplicates the previous stats from a previous user all the way to "playerrobs", moneybags stay at "0" ..
I cant find any mistake i've made ..
I cant find any mistake i've made ..
pawn Код:
stock SaveAccount(playerid)
{
new score = GetPlayerScore(playerid);
new money = GetPlayerMoney(playerid);
new
query[300],
Float:pos[4],
Float:health,
Float:armour;
GetPlayerPos(playerid, posArr{pos});
GetPlayerFacingAngle(playerid, pos[3]);
GetPlayerHealth(playerid, health);
GetPlayerArmour(playerid, armour);
format(query, sizeof(query), "UPDATE `users` SET score = %d, money = %d, health = %.1f, armour = %.1f, X = %.2f, Y = %.2f, Z = %.2f, A = %.2f, interior = %d, vw = %d, skin = %d, wantedlevel = %d, admin = %d, tut = %d, muted = %d, kills = %d, deaths = %d, jailed = %d, frozen = %d, bankrobs = %d, storerobs = %d, playerrobs = %d, moneybags = %d, crimes = %d WHERE `id` = %d",
score,
money,
health,
armour,
posArrEx{pos},
GetPlayerInterior(playerid),
GetPlayerVirtualWorld(playerid),
GetPlayerSkin(playerid),
GetPlayerWantedLevel(playerid),
g_PlayerInfo[playerid][pAdmin],
g_PlayerInfo[playerid][pTut],
g_PlayerInfo[playerid][pMuted],
g_PlayerInfo[playerid][pKills],
g_PlayerInfo[playerid][pDeaths],
g_PlayerInfo[playerid][pJailed],
g_PlayerInfo[playerid][pFrozen],
g_PlayerInfo[playerid][pBankrobs],
g_PlayerInfo[playerid][pStorerobs],
g_PlayerInfo[playerid][pPlayerrobs],
g_PlayerInfo[playerid][pMoneybags],
g_PlayerInfo[playerid][pCrimes],
g_PlayerInfo[playerid][pSQLid]
);
mysql_function_query(g_Handle, query, false, "SendQuery", "");
return 1;
}