[B3x7K]

Quote:

Originally Posted by TheLeech Still don't understand might just convert it back to the old MySQL. changed it now too this but still doesn't load? 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_tquery(mysql, query, "LoadApplicationsSQL", "d", i); } return 1; } forward LoadApplicationsSQL(id); public LoadApplicationsSQL(id) { new rows; cache_get_row_count(rows); if(rows) { if(ApplicationInfo[id][SentIn] == 0) { new fetch[256]; cache_get_value_name_int(id, "ID", ApplicationInfo[id][ID]); cache_get_value_name(id, "Name", fetch); format(ApplicationInfo[id][Name], 128, fetch); cache_get_value_name(id, "Question1", fetch); format(ApplicationInfo[id][Question1], 128, fetch); cache_get_value_name(id, "Question2", fetch); format(ApplicationInfo[id][Question2], 128, fetch); cache_get_value_name(id, "Question3", fetch); format(ApplicationInfo[id][Question3], 128, fetch); cache_get_value_name(id, "Question4", fetch); format(ApplicationInfo[id][Question4], 128, fetch); cache_get_value_name(id, "Question5", fetch); format(ApplicationInfo[id][Question5], 128, fetch); cache_get_value_name(id, "Question6", fetch); format(ApplicationInfo[id][Question6], 128, fetch); cache_get_value_name(id, "Accepted", fetch); ApplicationInfo[id][AppPassed]= strval(fetch); cache_get_value_name(id, "SentIn", fetch); ApplicationInfo[id][SentIn]= strval(fetch); ApplicationInfo[id][PlayerID] = -1; } } return 1; } stock LoadBuildings() { new query[256]; for(new i = 1; i < MAX_BUILDINGS; i++) { format(query, sizeof(query), "SELECT * FROM buildings WHERE ID=%i", i); mysql_tquery(mysql, query, "LoadBuildingsSQL", "d", i); } return 1; } forward LoadBuildingsSQL(id); public LoadBuildingsSQL(id) { new rows; cache_get_row_count(rows); if(rows) { new fetch[256]; cache_get_value_name_int(0, "ID", BuildingInfo[id][ID]); cache_get_value_name(id, "Name", fetch); format(BuildingInfo[id][Name], 256, fetch); 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) { 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; }

Still confused... but let me give you an example how to load some..

PHP Code:


public OnGameModeInit();
{
     //bla bla bla
     mysql_tquery(ConnectionHandle, "SELECT * FROM `Machines`", "Load_Machines");
forward Load_Machines();
public Load_Machines()
{
     new rows;
     cache_get_row_count(rows);
     for(new i; i < rows; i++) if(i < MAX_MACHINES) //loop rows, then check again is i less than MAX_MACHINES
     {
           cache_get_value_name_int(i, "mID", MachineData[i][MachineID]);
           cache_get_value_name(i, "mName", MachineData[i][MachineName]);
           //etc
     }
     return 1;
}