error load some map from mysql
#1

script
Код:
forward MapLoad();
public MapLoad()
{
	new query[254], jet;
	mysql_format(mysql, query, sizeof(query), "SELECT * FROM `maps` WHERE `mapid` = '%d' LIMIT 1", MapInfo[mapid]);
	mysql_tquery(mysql, query, "LoadMaps", "i", jet);
	return 1;
}
forward LoadMaps(jet);
public LoadMaps(jet)
{
	new jans[45];
	MapInfo[mapid] = cache_get_field_content_int(0,"mapid");
	cache_get_field_content(0, "Mapname", MapInfo[NamaMap], mysql, 50);
		   
	cache_get_field_content(0, "HumanS", jans, mysql, 35);
	sscanf(jans, "p<,>fff",MapInfo[HumanX],MapInfo[HumanY],MapInfo[HumanZ]);

	cache_get_field_content(0, "ZombieS", MapInfo[ZombieX], mysql, 35);
	sscanf(jans, "p<,>fff",MapInfo[ZombieX],MapInfo[ZombieY],MapInfo[ZombieZ]);
		   
	MapInfo[Durasi] = cache_get_field_content_int(0,"Duration");
	MapInfo[Deadtime] = cache_get_field_content_int(0,"Deadtime");
	MapInfo[Time] = cache_get_field_content_int(0,"Time");
	MapInfo[Weather] = cache_get_field_content_int(0,"Weather");
	MapInfo[Interior] = cache_get_field_content_int(0,"Interior");
	cache_get_field_content(0, "Filterscript", MapInfo[Filterscript], mysql, 30);
	new str[128];
	format(str,90,"loadfs %s",MapInfo[Filterscript]);
	SendRconCommand(str);
	format(str,90,"Map Name : ~y~%s(%d)",MapInfo[NamaMap],MapInfo[mapid]);
	TextDrawSetString(Zombie_TextDraw[3],str);
	TextDrawShowForAll(Zombie_TextDraw[3]);
	format(str, sizeof(str), "ZM v1.2 (%d/%d)", mapid, MAXMAP);
 	SetGameModeText(str);
	SetWorldTime(MapInfo[Time]);
	SetWeather(MapInfo[Weather]);
	PlayerLoop(i) SpawnPlayer(i);
	return 1;
}
no error at compile (pawn)

but error at mysql
this error
Код:
[10:11:47] [DEBUG] CMySQLQuery::Execute[LoadMaps] - starting query execution
[10:11:47] [DEBUG] CMySQLQuery::Execute[LoadMaps] - query was successfully executed within 0.378 milliseconds
[10:11:47] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[10:11:47] [DEBUG] Calling callback "LoadMaps"..
[10:11:47] [DEBUG] cache_get_field_content_int - row: 0, field_name: "mapid", connection: 1
[10:11:47] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[10:11:47] [ERROR] cache_get_field_content_int - invalid datatype
[10:11:47] [DEBUG] cache_get_field_content - row: 0, field_name: "Mapname", connection: 1, max_len: 50
[10:11:47] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[10:11:47] [DEBUG] cache_get_field_content - row: 0, field_name: "HumanS", connection: 1, max_len: 35
[10:11:47] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[10:11:47] [DEBUG] cache_get_field_content - row: 0, field_name: "ZombieS", connection: 1, max_len: 35
[10:11:47] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[10:11:47] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Duration", connection: 1
[10:11:47] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[10:11:47] [ERROR] cache_get_field_content_int - invalid datatype
[10:11:47] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Deadtime", connection: 1
[10:11:47] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[10:11:47] [ERROR] cache_get_field_content_int - invalid datatype
[10:11:47] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Time", connection: 1
[10:11:47] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[10:11:47] [ERROR] cache_get_field_content_int - invalid datatype
[10:11:47] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Weather", connection: 1
[10:11:47] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[10:11:47] [ERROR] cache_get_field_content_int - invalid datatype
[10:11:47] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Interior", connection: 1
[10:11:47] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[10:11:47] [ERROR] cache_get_field_content_int - invalid datatype
[10:11:47] [DEBUG] cache_get_field_content - row: 0, field_name: "Filterscript", connection: 1, max_len: 30
[10:11:47] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[10:11:47] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
thanks before
Reply


Messages In This Thread
error load some map from mysql - by kloning1 - 11.12.2016, 02:19
Re: error load some map from mysql - by kloning1 - 11.12.2016, 03:39
Re: error load some map from mysql - by benjenden - 11.12.2016, 03:49

Forum Jump:


Users browsing this thread: 2 Guest(s)