[AlexBlack]

Hi, i have a small problem with mysql R39-2 and i need some help's

PHP код:

forward PlayerFile_Save(playerid);
public PlayerFile_Save(playerid)
{
    new query[1024];
    strcat(database, query, sizeof(query), "UPDATE users SET Password = %s, Level = %d, \
    VIP = %d, Jailed = %d, Wanted = %d, \
    Bans = %d, BanTime = %d, TruckerLicense = %d, \
    BusLicense = %d, PilotLicense = %d, \
    MafiaLicense = %d, Muted = %d, \
    RulesRead = %d, StatsMetersDriven = %d, \
    StatsTruckerJobs = %d, StatsConvoyJobs = %d, \
    StatsBusDriverJobs = %d, StatsPilotJobs = %d, \
    StatsMafiaJobs = %d, StatsMafiaStolen = %d, \
    StatsPoliceFined = %d, StatsPoliceJailed = %d, \
    StatsCourierJobs = %d, StatsRoadworkerJobs = %d, \ 
    StatsAssistance = %d, Team = %d, Leader = %d, \
    Money = %d, Score = %d WHERE ID = %e", APlayerData[playerid][PlayerPassword],APlayerData[playerid][PlayerLevel],APlayerData[playerid][VIPLevel],APlayerData[playerid][PlayerJailed],GetPlayerWantedLevel(playerid),
    APlayerData[playerid][Bans],APlayerData[playerid][BanTime],APlayerData[playerid][TruckerLicense],APlayerData[playerid][BusLicense],APlayerData[playerid][PilotLicense],APlayerData[playerid][MafiaLicense],APlayerData[playerid][Muted],
    APlayerData[playerid][RulesRead],APlayerData[playerid][StatsMetersDriven],APlayerData[playerid][StatsTruckerJobs],APlayerData[playerid][StatsConvoyJobs],APlayerData[playerid][StatsBusDriverJobs],
    APlayerData[playerid][StatsPilotJobs],APlayerData[playerid][StatsMafiaJobs],APlayerData[playerid][StatsMafiaStolen],APlayerData[playerid][StatsPoliceFined],APlayerData[playerid][StatsPoliceFined],
    APlayerData[playerid][StatsPoliceJailed],APlayerData[playerid][StatsCourierJobs],APlayerData[playerid][StatsRoadworkerJobs],APlayerData[playerid][StatsAssistance],APlayerData[playerid][Team],
    APlayerData[playerid][Leader],APlayerData[playerid][PlayerMoney],APlayerData[playerid][PlayerScore],APlayerData[playerid][CompteID]);
    mysql_tquery(database, query);
    printf("SERVER STATS : ACCOUNT HAVE BEEN SAVED.");
    return 1;
} 


errors :

Quote:

(61) : error 075: input line too long (after substitutions) (62) : error 035: argument type mismatch (argument 1) (62) : error 035: argument type mismatch (argument 2) (62) : error 017: undefined symbol "UPDATE" (62) : fatal error 107: too many error messages on one line Compilation aborted.Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase 5 Errors.

line 61 and 62

PHP код:

    StatsPoliceFined = %d, StatsPoliceJailed = %d, \
    StatsCourierJobs = %d, StatsRoadworkerJobs = %d, \ 


when i use mysql_format

Quote:

error 075: input line too long (after substitutions) error 037: invalid string (possibly non-terminated string) error 017: undefined symbol "UPDATE" error 017: undefined symbol "users" fatal error 107: too many error messages on one line Compilation aborted.Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase 5 Errors.

Thx.