[AlexBlack]

The error is fixed, thank you +REP

but now i have a problиme IG, when i'am disconnecting nothing happen , the callback is called but nothing happen , the stats stay in the same

mysql_debug

Quote:

[03:00:54] [DEBUG] mysql_format - connection: 1, len: 1024, format: "%s" [03:00:54] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `users` SET `Password` = '', `Level` = 0, `VIP` = 0, `Jai", callback: "(null)", format: "(null)" [03:00:54] [DEBUG] CMySQLQuery::Execute[] - starting query execution [03:00:54] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 [03:00:54] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError

they have something wrong because i'am level 7 IG i'am not level 0

this is my load callback

PHP код:

forward PlayerFile_Load(playerid);
public PlayerFile_Load(playerid)
{
    new str[24];
    APlayerData[playerid][StatsAssistance] = cache_get_field_content_int(0, "StatsAssistance");
    APlayerData[playerid][PlayerPassword] = cache_get_field_content(0, "Password", str);
    APlayerData[playerid][PlayerLevel] = cache_get_field_content_int(0, "Level");
    APlayerData[playerid][VIPLevel] = cache_get_field_content_int(0, "VIP");
    APlayerData[playerid][PlayerJailed] = cache_get_field_content_int(0, "Jailed");
    APlayerData[playerid][Bans] = cache_get_field_content_int(0, "Bans");
    APlayerData[playerid][BanTime] = cache_get_field_content_int(0, "BanTime");
    APlayerData[playerid][TruckerLicense] = cache_get_field_content_int(0, "TruckerLicense");
    APlayerData[playerid][BusLicense] = cache_get_field_content_int(0, "BusLicense");    
    APlayerData[playerid][PilotLicense] = cache_get_field_content_int(0, "PilotLicense");    
    APlayerData[playerid][MafiaLicense] = cache_get_field_content_int(0, "MafiaLicense");    
    APlayerData[playerid][Team] = cache_get_field_content_int(0, "Team");    
    APlayerData[playerid][Leader] = cache_get_field_content_int(0, "Leader");
    APlayerData[playerid][StatsMetersDriven] = cache_get_field_content_int(0, "StatsMetersDriven");
    APlayerData[playerid][StatsTruckerJobs] = cache_get_field_content_int(0, "StatsTruckerJobs");
    APlayerData[playerid][StatsConvoyJobs] = cache_get_field_content_int(0, "StatsConvoyJobs");
    APlayerData[playerid][StatsBusDriverJobs] = cache_get_field_content_int(0, "StatsBusDriverJobs");
    APlayerData[playerid][StatsPilotJobs] = cache_get_field_content_int(0, "StatsPilotJobs");
    APlayerData[playerid][StatsMafiaJobs] = cache_get_field_content_int(0, "StatsMafiaJobs");
    APlayerData[playerid][StatsMafiaStolen] = cache_get_field_content_int(0, "StatsMafiaStolen");
    APlayerData[playerid][StatsPoliceFined] = cache_get_field_content_int(0, "StatsPoliceFined");
    APlayerData[playerid][StatsPoliceJailed] = cache_get_field_content_int(0, "StatsPoliceJailed");
    APlayerData[playerid][StatsCourierJobs] = cache_get_field_content_int(0, "StatsCourierJobs");
    APlayerData[playerid][StatsRoadworkerJobs] = cache_get_field_content_int(0, "StatsRoadworkerJobs");
    APlayerData[playerid][PlayerMoney] = cache_get_field_content_int(0, "Money");
    APlayerData[playerid][PlayerScore] = cache_get_field_content_int(0, "Score");
    printf("SERVER STATS: ACCOUNT HAVE BEEN LOADED");
    return 1;
}