01.11.2018, 19:18
For that use threaded queries:
pawn Code:
mysql_tquery(Database, "SELECT * FROM `dealerships`, "LoadDealerships", ""); // Call it separately, OnGameModeInit if you want to
pawn Code:
forward LoadDealerships();
public LoadDealerships()
{
for (new i; i < MAX_DEALERSHIPS; i++)
{
/*
cache_get_value_name(row_idx, const column_name[], destination[], max_len = sizeof(destination)
cache_get_value_name_bool(row_idx, column_name[], &bool:destination)
cache_get_value_name_int(row_idx, const column_name[], destination)
cache_get_value_name_float(row_idx, const column_name[], Float:destination)
*/
cache_get_value_name(i, "dealership_name", DealershipStatistics[i][dealership_name]);
// ...
}
return 1;
}

