[TheLeech]

Code:

../gamemodes/Functions.pwn(492) : error 017: undefined symbol "mysql_function_query"
../gamemodes/Functions.pwn(540) : error 017: undefined symbol "mysql_function_query"
Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


2 Errors.

Code:

stock LoadApplications()
{
	new query[256];
	for(new i = 1; i < MAX_APPLICATIONS; i++)
	{
		format(query, sizeof(query), "SELECT * FROM applications WHERE ID=%i", i);
		mysql_function_query(mysql, query, true, "LoadApplicationsSQL", "d", i);
	}
	return 1;
}

forward LoadApplicationsSQL(id);
public LoadApplicationsSQL(id)
{
    new fields, rows;
    cache_get_row_count(rows);
	cache_get_field_count(fields);
    if(rows)
    {
        if(ApplicationInfo[id][SentIn] == 0)
    	{
        	new fetch[256];
        	cache_get_value_name(0, "ID", fetch);
			ApplicationInfo[id][ID]= strval(fetch);
        	cache_get_value_name(0, "Name", fetch);
  			format(ApplicationInfo[id][Name], 128, fetch);
  			cache_get_value_name(0, "Question1", fetch);
  			format(ApplicationInfo[id][Question1], 128, fetch);
  			cache_get_value_name(0, "Question2", fetch);
  			format(ApplicationInfo[id][Question2], 128, fetch);
  			cache_get_value_name(0, "Question3", fetch);
  			format(ApplicationInfo[id][Question3], 128, fetch);
  			cache_get_value_name(0, "Question4", fetch);
  			format(ApplicationInfo[id][Question4], 128, fetch);
  			cache_get_value_name(0, "Question5", fetch);
  			format(ApplicationInfo[id][Question5], 128, fetch);
  			cache_get_value_name(0, "Question6", fetch);
  			format(ApplicationInfo[id][Question6], 128, fetch);
  			cache_get_value_name(0, "Accepted", fetch);
			ApplicationInfo[id][AppPassed]= strval(fetch);
			cache_get_value_name(0, "SentIn", fetch);
			ApplicationInfo[id][SentIn]= strval(fetch);
			ApplicationInfo[id][PlayerID] = -1;
		}
	}
	return 1;
}

stock LoadBuildings()
{
	new query[256];
	for(new i = 1; i < MAX_APPLICATIONS; i++)
	{
		format(query, sizeof(query), "SELECT * FROM buildings WHERE ID=%i", i);
		mysql_function_query(mysql, query, true, "LoadBuildingsSQL", "d", i);
	}
	return 1;
}

forward LoadBuildingsSQL(id);
public LoadBuildingsSQL(id)
{
    new fields, rows;
    cache_get_row_count(rows);
	cache_get_field_count(fields);
    if(rows)
    {
   		new fetch[256];
    	cache_get_value_name(0, "ID", fetch);
		BuildingInfo[id][ID]= strval(fetch);
 		cache_get_value_name(0, "Name", fetch);
		format(BuildingInfo[id][Name], 256, fetch);
		cache_get_value_name_float(0, "EnterX", BuildingInfo[id][EnterX]);
		cache_get_value_name_float(0, "EnterY", BuildingInfo[id][EnterY]);
		cache_get_value_name_float(0, "EnterZ", BuildingInfo[id][EnterZ]);
		cache_get_value_name_float(0, "ExitX", BuildingInfo[id][ExitX]);
		cache_get_value_name_float(0, "ExitY", BuildingInfo[id][ExitY]);
		cache_get_value_name_float(0, "ExitZ", BuildingInfo[id][ExitZ]);
		cache_get_value_name_int(0, "Interior", BuildingInfo[id][Int]);
		cache_get_value_name_int(0, "VirtualWorld", BuildingInfo[id][VW]);
		cache_get_value_name_int(0, "FreezeTimer", BuildingInfo[id][FreezeTimer]);
		if(BuildingInfo[id][EnterX] > 0.0) {
		    new string[256];
  			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]);
		}
	}
	return 1;
}