19.03.2015, 02:37
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
they have something wrong because i'am level 7 IG i'am not level 0
this is my load callback
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 |
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;
}