15.08.2018, 13:15
I have a problem, this function doesn't save LastLogin, Score and Money. In mysql log LastLogin says: "LastLogin: e", meanwhile score/money to 0.
Other values are saved correctly.
Other values are saved correctly.
pawn Code:
UpdatePlayerData(playerid)
{
if(Player[playerid][IsLoggedIn] == false) return 0;
new query[1300], p = playerid;
format(query,sizeof(query), "UPDATE `players` SET `LastLogin` = '%e', `Kills` = %d, `Deaths` = %d, `Score` = %i, `Money` = %i, `Level` = %d, `WantedLevel` = %d, `Skin` = %d, `PlayerGender` = %d WHERE `ID`= %d",
ReturnDate(), Player[p][Kills], Player[p][Deaths], GetPlayerScore(p), GetPlayerMoney(p), Player[p][Level], GetPlayerWantedLevel(p), GetPlayerSkin(p) ,Player[p][PlayerGender], Player[p][ID]);
mysql_query(g_SQL, query);
format(query,sizeof(query),"UPDATE `players` SET `PlayingHours` = %d, `PlayingMinutes` = %d, `FirstSpawn` = %d, `Job` = %d, `Bank` = %d, `NoPm` = %d, `Diseases` = %d WHERE `ID`= %d",
Player[p][PlayingHours], Player[p][PlayingMinutes], Player[p][FirstSpawn], Player[p][Job], Player[p][Bank], Player[p][NoPm], Player[p][Diseases], Player[p][ID]);
mysql_query(g_SQL, query);
format(query,sizeof(query), "UPDATE `players` SET `VehicleLicense` = %d, `MotorbikeLicense` = %d, `PlaneLicense` = %d, `HelicopterLicense` = %d, `BankDeposited` = %d, `BankWithdrawal` = %d, `Jailed` = %d, `Warns` = %d WHERE `ID`= %d",
Player[p][VehicleLicense], Player[p][MotorbikeLicense], Player[p][PlaneLicense], Player[p][HelicopterLicense], Player[p][BankDeposited], Player[p][BankWithdrawal], Player[p][Jailed], Player[p][Warns], Player[p][ID]);
mysql_query(g_SQL, query);
format(query,sizeof(query),"UPDATE `players` SET `MarijuanaSeeds` = %d, `CocaineSeeds` = %d, `HeroinSeeds` = %d, `Drugs` = %d WHERE `ID`= %d",
Player[p][MarijuanaSeeds], Player[p][CocaineSeeds], Player[p][HeroinSeeds], Player[p][Drugs], Player[p][ID]);
mysql_query(g_SQL, query);
return 1;
}