Query string
#4

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


Messages In This Thread
Query string - by KinderClans - 09.08.2018, 19:28
Re: Query string - by GRiMMREAPER - 09.08.2018, 20:18
Re: Query string - by KinderClans - 09.08.2018, 23:15
Re: Query string - by Jefff - 09.08.2018, 23:26
Re: Query string - by Kraeror - 10.08.2018, 06:52
Re: Query string - by Banditul18 - 10.08.2018, 07:41
Re: Query string - by Calisthenics - 10.08.2018, 08:21
Re: Query string - by Banditul18 - 10.08.2018, 08:32
Re: Query string - by Juvanii - 10.08.2018, 09:34
Re: Query string - by KinderClans - 10.08.2018, 10:40

Forum Jump:


Users browsing this thread: 1 Guest(s)