Save query

[KinderClans]

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.

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;
}

[jlalt]

To be able to use %e to escape you gotta use mysql_format not normal format.

[KinderClans]

Ok and what about score/money?

[jlalt]

Originally Posted by KinderClans

Ok and what about score/money?

They are part of that query as it failing due to %e so none being updated. Use mysql_format and all should be fixed.

[KinderClans]

Done, now getting argument type mismatch:

mysql_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);

[jlalt]

First parameter is connection handler.

PHP Code:

mysql_format(g_SQL, query,sizeof(query),...); 


[iLearner]

PHP Code:

mysql_format(g_SQL, 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);