09.08.2018, 23:26
strcat doesnt supports %, you need use format
pawn Код:
UpdatePlayerData(playerid)
{
if(Player[playerid][IsLoggedIn] == false) return 0;
new query[2000],p = playerid;
format(query,sizeof(query), "UPDATE `players` SET `LastLogin` = '%s', `Kills` = %d, `Deaths` = %d, `Score` = %i, `Money` = %i, `Level` = %d, `WantedLevel` = %d, `Skin` = %d, `PlayerTeam` = %d, `PlayerGender` = %d,",
ReturnDate(),
Player[p][Kills],
Player[p][Deaths],
GetPlayerScore(p),
GetPlayerMoney(p),
Player[p][Level],
GetPlayerWantedLevel(p),
GetPlayerSkin(p),
GetPlayerTeam(p),
Player[p][PlayerGender]
);
format(query,sizeof(query),"%s `PlayingHours` = %d, `PlayingMinutes` = %d, `FirstSpawn` = %d, `Job` = %d, `Bank` = %d, `NoPm` = %d, `Diseases` = %d", query,
Player[p][PlayingHours],
Player[p][PlayingMinutes],
Player[p][FirstSpawn],
Player[p][Job],
Player[p][Bank],
Player[p][NoPm],
Player[p][Diseases]
);
format(query,sizeof(query),"%s `VehicleLicense` = %d, `MotorbikeLicense` = %d, `PlaneLicense` = %d, `HelicopterLicense` = %d, `BankDeposited` = %d, `BankWithdrawal` = %d WHERE `ID`= %d", query,
Player[p][VehicleLicense],
Player[p][MotorbikeLicense],
Player[p][PlaneLicense],
Player[p][HelicopterLicense],
Player[p][BankDeposited],
Player[p][BankWithdrawal],
Player[p][ID]
);
mysql_tquery(g_SQL, query);
return 1;
}