[Jeffry]

There you go:

Code:

stock LoadApplications() 
{
	mysql_tquery(mysql, "SELECT * FROM applications", "LoadApplicationsSQL", ""); 
	return 1; 
}

forward LoadApplicationsSQL(); 
public LoadApplicationsSQL() 
{
	new rows, string[128]; 
	cache_get_row_count(rows); 
	for(new id = 0; id < rows; id++)
	{
		cache_get_value_name_int(id, "ID", ApplicationInfo[id][ID]); 
		cache_get_value_name(id, "Name", string); 
		format(ApplicationInfo[id][Name], 128, string); 
		cache_get_value_name(id, "Question1", string); 
		format(ApplicationInfo[id][Question1], 128, string); 
		cache_get_value_name(id, "Question2", string); 
		format(ApplicationInfo[id][Question2], 128, string); 
		cache_get_value_name(id, "Question3", string); 
		format(ApplicationInfo[id][Question3], 128, string); 
		cache_get_value_name(id, "Question4", string); 
		format(ApplicationInfo[id][Question4], 128, string); 
		cache_get_value_name(id, "Question5", string); 
		format(ApplicationInfo[id][Question5], 128, string); 
		cache_get_value_name(id, "Question6", string); 
		format(ApplicationInfo[id][Question6], 128, string); 
		cache_get_value_name_int(id, "Accepted", ApplicationInfo[id][AppPassed]); 
		cache_get_value_name_int(id, "SentIn", ApplicationInfo[id][SentIn]); 
		ApplicationInfo[id][PlayerID] = -1; 
		format(string, sizeof(string), "Application for %s loaded", ApplicationInfo[id][Name]); 
		print(string); 
	}
	return 1; 
}

stock LoadBuildings() 
{
	mysql_tquery(mysql, "SELECT * FROM buildings", "LoadBuildingsSQL", ""); 
	return 1; 
}

forward LoadBuildingsSQL(id); 
public LoadBuildingsSQL(id) 
{
	new rows, string[128]; 
	cache_get_row_count(rows); 
	for(new id = 0; id < rows; id++)
	{
		cache_get_value_name_int(id, "ID", BuildingInfo[id][ID]); 
		cache_get_value_name(id, "Name", string); 
		format(BuildingInfo[id][Name], 256, string); 
		cache_get_value_name_float(id, "EnterX", BuildingInfo[id][EnterX]); 
		cache_get_value_name_float(id, "EnterY", BuildingInfo[id][EnterY]); 
		cache_get_value_name_float(id, "EnterZ", BuildingInfo[id][EnterZ]); 
		cache_get_value_name_float(id, "ExitX", BuildingInfo[id][ExitX]); 
		cache_get_value_name_float(id, "ExitY", BuildingInfo[id][ExitY]); 
		cache_get_value_name_float(id, "ExitZ", BuildingInfo[id][ExitZ]); 
		cache_get_value_name_int(id, "Interior", BuildingInfo[id][Int]); 
		cache_get_value_name_int(id, "VirtualWorld", BuildingInfo[id][VW]); 
		cache_get_value_name_int(id, "FreezeTimer", BuildingInfo[id][FreezeTimer]); 
		if(BuildingInfo[id][EnterX] > 0.0) 
		{
			format(string, sizeof(string), "%s\nPress H to enter\nAlso /Enter or /Exit", BuildingInfo[id][Name]); 
			Build3D[id] = CreateDynamic3DTextLabel(string,0xFFFFFFFF,BuildingInfo[id][EnterX],BuildingInfo[id][EnterY],BuildingInfo[id][EnterZ]+0.75, 25.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, 0, 0, -1, 100.0); 
			BuildPickup[id] = CreateDynamicPickup(1318, 1, BuildingInfo[id][EnterX],BuildingInfo[id][EnterY],BuildingInfo[id][EnterZ]); 
			format(string, sizeof(string), "%s created successfully", BuildingInfo[id][Name]); 
			print(string); 
		}
	}
	return 1; 
}

By the way, you can also use

Code:

cache_get_value_name(id, "Question1", ApplicationInfo[id][Question1], LENGTH_HERE);

Instead of fetching it in a variable first and using format afterwards. Not a big deal though, that's why I kept it, for your understanding.