[jtemple042996]

I'm attempting to build a Dynamic Faction System using MySQL and I'm having a problem with Loading.

My MySQL Table looks like this:
http://i.imgur.com/31ouOcm.png

Basically, what it's doing is loading the First faction, but not any others.

MySQL Log:

Код:

[19:25:28]  
[19:25:28]  ** MySQL Debugging enabled.
[19:25:28]  
[19:25:28] >> mysql_connect(localhost, samp, samp, ***) on port 3306
[19:25:28] CMySQLHandler::Connect() - Connection was successful.
[19:25:28] CMySQLHandler::Connect() - Auto-reconnect has been enabled.
[19:25:28] >> mysql_connect(localhost, samp, samp, ***) on port 3306
[19:25:28] CMySQLHandler::Connect() - Connection was successful.
[19:25:28] CMySQLHandler::Connect() - Auto-reconnect has been enabled.
[19:25:28] >> mysql_query_callback(Connection handle: 1)
[19:25:28] >> mysql_query_callback(Connection handle: 1)
[19:25:28] ProcessQueryThread(OnQueryFinish) - Executing query SELECT * FROM f_m...
[19:25:28] >> mysql_query_callback(Connection handle: 1)
[19:25:28] ProcessQueryThread(OnQueryFinish) - Query was successful.
[19:25:28] ProcessQueryThread(OnQueryFinish) - Data caching enabled.
[19:25:28] CMySQLHandler::StoreResult() - Result was stored.
[19:25:28] CMySQLHandler::FreeResult() - Result was successfully freed.
[19:25:28] ProcessQueryThread(OnQueryFinish) - Data being passed to ProcessTick().
[19:25:28] OnQueryFinish(i) - Callback is being called...
[19:25:28] >> cache_get_data(Connection handle: 1)
[19:25:28] ProcessTick() - The cache has been cleared.
[19:25:28] ProcessQueryThread(OnQueryFinish) - Executing query SELECT * FROM r_m...
[19:25:28] ProcessQueryThread(OnQueryFinish) - Query was successful.
[19:25:28] ProcessQueryThread(OnQueryFinish) - Data caching enabled.
[19:25:28] CMySQLHandler::StoreResult() - Result was stored.
[19:25:28] CMySQLHandler::FreeResult() - Result was successfully freed.
[19:25:28] ProcessQueryThread(OnQueryFinish) - Data being passed to ProcessTick().
[19:25:28] OnQueryFinish(i) - Callback is being called...
[19:25:28] >> cache_get_data(Connection handle: 1)
[19:25:28] ProcessTick() - The cache has been cleared.
[19:25:28] ProcessQueryThread(OnQueryFinish) - Executing query SELECT * FROM d_m...
[19:25:28] ProcessQueryThread(OnQueryFinish) - Query was successful.
[19:25:28] ProcessQueryThread(OnQueryFinish) - Data caching enabled.
[19:25:28] CMySQLHandler::StoreResult() - Result was stored.
[19:25:28] CMySQLHandler::FreeResult() - Result was successfully freed.
[19:25:28] ProcessQueryThread(OnQueryFinish) - Data being passed to ProcessTick().
[19:25:28] OnQueryFinish(i) - Callback is being called...
[19:25:28] >> cache_get_data(Connection handle: 1)
[19:25:28] ProcessTick() - The cache has been cleared.
[19:26:39]  
[19:26:39]  ** MySQL Debugging enabled.
[19:26:39]  
[19:26:39] >> mysql_connect(localhost, samp, samp, ***) on port 3306
[19:26:39] CMySQLHandler::Connect() - Connection was successful.
[19:26:39] CMySQLHandler::Connect() - Auto-reconnect has been enabled.
[19:26:39] >> mysql_connect(localhost, samp, samp, ***) on port 3306
[19:26:39] CMySQLHandler::Connect() - Connection was successful.
[19:26:39] CMySQLHandler::Connect() - Auto-reconnect has been enabled.
[19:26:39] >> mysql_query_callback(Connection handle: 1)
[19:26:39] ProcessQueryThread(OnQueryFinish) - Executing query SELECT * FROM f_m...
[19:26:39] >> mysql_query_callback(Connection handle: 1)
[19:26:39] ProcessQueryThread(OnQueryFinish) - Query was successful.
[19:26:39] ProcessQueryThread(OnQueryFinish) - Data caching enabled.
[19:26:39] CMySQLHandler::StoreResult() - Result was stored.
[19:26:39] CMySQLHandler::FreeResult() - Result was successfully freed.
[19:26:39] >> mysql_query_callback(Connection handle: 1)
[19:26:39] ProcessQueryThread(OnQueryFinish) - Data being passed to ProcessTick().
[19:26:39] OnQueryFinish(i) - Callback is being called...
[19:26:39] >> cache_get_data(Connection handle: 1)
[19:26:39] ProcessTick() - The cache has been cleared.
[19:26:39] ProcessQueryThread(OnQueryFinish) - Executing query SELECT * FROM r_m...
[19:26:39] ProcessQueryThread(OnQueryFinish) - Query was successful.
[19:26:39] ProcessQueryThread(OnQueryFinish) - Data caching enabled.
[19:26:39] CMySQLHandler::StoreResult() - Result was stored.
[19:26:39] CMySQLHandler::FreeResult() - Result was successfully freed.
[19:26:39] ProcessQueryThread(OnQueryFinish) - Data being passed to ProcessTick().
[19:26:39] OnQueryFinish(i) - Callback is being called...
[19:26:39] >> cache_get_data(Connection handle: 1)
[19:26:39] ProcessTick() - The cache has been cleared.
[19:26:39] ProcessQueryThread(OnQueryFinish) - Executing query SELECT * FROM d_m...
[19:26:39] ProcessQueryThread(OnQueryFinish) - Query was successful.
[19:26:39] ProcessQueryThread(OnQueryFinish) - Data caching enabled.
[19:26:39] CMySQLHandler::StoreResult() - Result was stored.
[19:26:39] CMySQLHandler::FreeResult() - Result was successfully freed.
[19:26:39] ProcessQueryThread(OnQueryFinish) - Data being passed to ProcessTick().
[19:26:39] OnQueryFinish(i) - Callback is being called...
[19:26:39] >> cache_get_data(Connection handle: 1)
[19:26:39] ProcessTick() - The cache has been cleared.

Server Log:

Код:

[19:26:39] Loading Factions...
[19:26:39] Loading Faction Ranks...
[19:26:39] Loading Faction Divisions...
[19:26:39]   Filterscript 'Factions.amx' loaded.
[19:26:39] Rows Detected.
[19:26:39] Rows: 2
[19:26:39] [Slot 1] Test Government Faction Loaded.
[19:26:39] Rows: 2
[19:26:39] [Slot 2]  Loaded.
[19:26:39] Rows: 2
[19:26:39] [Slot 3] NULL Loaded.

As you can see from the Picture of the Database Picture above, there are two rows in the Database.
My Stock:

Код:

stock LoadFactions(){
	print("Loading Factions...");
	format(Query,sizeof(Query),"SELECT * FROM f_m");
	mysql_function_query(MainPipe,Query,true,"OnQueryFinish","i",THREAD_LOADFACTIONS);
	return 1;
}

My OnQueryFinish:

Код:

forward OnQueryFinish(resultid,extraid,ConnectionHandle);
public OnQueryFinish(resultid,extraid,ConnectionHandle){
	new temp[14],rows,fields;
	if(resultid != THREAD_NO_RESULT){
		cache_get_data(rows,fields);
	}
	switch(resultid){
	    case THREAD_LOADFACTIONS:{
	        if(rows){
				print("Rows Detected.");
				for(new i = 0; i <= rows; i++){
					printf("Rows: %i",rows);
				    TotFacs++;
					cache_get_field_content(i,"fid",temp);
					fData[TotFacs][fTitle] = strval(temp);
					cache_get_field_content(i,"type",temp);
					fData[TotFacs][fType] = strval(temp);
     				cache_get_field_content(i,"locale",temp);
					fData[TotFacs][fLocale] = strval(temp);
				 	cache_get_field_content(i,"parent",temp);
					fData[TotFacs][fParent] = strval(temp);
					cache_get_field_content(i,"abbr",fData[TotFacs][fAbbr]);
     				cache_get_field_content(i,"title",fData[TotFacs][fTitle]);
					cache_get_field_content(i,"disabled",temp);
					fData[TotFacs][fDisabled] = strval(temp);
					cache_get_field_content(i,"disabledReason",fData[TotFacs][fDisabledReason]);
					cache_get_field_content(i,"disabledAdmin",fData[TotFacs][fDisabledAdmin]);
					cache_get_field_content(i,"bank",temp);
					fData[TotFacs][fBank] = strval(temp);
					cache_get_field_content(i,"phone",temp);
					fData[TotFacs][fPhone] = strval(temp);
					cache_get_field_content(i,"defaultdiv",temp);
					fData[TotFacs][defaultdiv] = strval(temp);
					cache_get_field_content(i,"defauljoin",temp);
					fData[TotFacs][defaultjoin] = strval(temp);
					cache_get_field_content(i,"defaultleader",temp);
					fData[TotFacs][defaultleader] = strval(temp);
					cache_get_field_content(i,"budget",temp);
					fData[TotFacs][fBudget] = strval(temp);
					fData[TotFacs][fCreated] = true;
					printf("[Slot %i] %s Loaded.",TotFacs,fData[TotFacs][fTitle]);
				}
			}
		}
	}
	return 1;
}