03.04.2015, 13:36
Hi, i have a small mysql problem, so my accounts doesn't load , i have check mysql log i have find this ( i'am using mysql on PPC_Trucking )
my code
Thx for advance.
pawn Код:
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "StatsAssistance", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Level", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "VIP", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Jailed", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Bans", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "BanTime", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "TruckerLicense", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "BusLicense", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "PilotLicense", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "MafiaLicense", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Team", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Leader", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_float - row: 0, field_name: "StatsMetersDriven", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_float - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "StatsTruckerJobs", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "StatsConvoyJobs", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "StatsBusDriverJobs", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "StatsPilotJobs", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "StatsMafiaJobs", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "StatsMafiaStolen", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "StatsPoliceFined", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "StatsPoliceJailed", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "StatsCourierJobs", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "StatsRoadworkerJobs", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Money", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Score", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "RulesRead", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Muted", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Minutesjouer", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Heuresjouer", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
PHP код:
public PlayerFile_Load(playerid)
{
APlayerData[playerid][StatsAssistance] = cache_get_field_content_int(0, "StatsAssistance");
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_float(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");
APlayerData[playerid][RulesRead] = cache_get_field_content_int(0, "RulesRead");
APlayerData[playerid][Muted] = cache_get_field_content_int(0, "Muted");
APlayerData[playerid][pMinutes] = cache_get_field_content_int(0, "Minutesjouer");
APlayerData[playerid][pHeures] = cache_get_field_content_int(0, "Heuresjouer");
printf("SERVER STATS : AN ACCOUNT HAVE BEEN LOADED.");
return 1;
}