[McGuiness]

Hey guys,

I'm working on a faction vehicle system that dynamically saves vehicles but the problem is that my system messes up on server start (meaning that when the loading of faction vehicles comes) it takes it time and makes it hard to figure out why it is restricting the server from fully loading.

Here is the code:

pawn Код:

stock LoadFactionVehicles()
{
    new Query[500];
    for(new i = 1;i<MAX_FACTION_VEHICLES;i++)
    {
        format(Query, sizeof(Query), "SELECT * FROM `vehicledata` WHERE `ID` = %d LIMIT 1", i);
        mysql_query(Query);
        mysql_store_result();
        while(mysql_fetch_row(Query))
        {
            mysql_fetch_int("ID", vInfo[i][ID]);
            mysql_fetch_int("ModelID", vInfo[i][ModelID]);
            mysql_fetch_int("posX", vInfo[i][posX]);
            mysql_fetch_int("posY", vInfo[i][posY]);
            mysql_fetch_int("posZ", vInfo[i][posZ]);
            mysql_fetch_int("posA", vInfo[i][posA]);
            mysql_fetch_int("ColorA", vInfo[i][ColorA]);
            mysql_fetch_int("ColorB", vInfo[i][ColorB]);
            mysql_fetch_int("Faction", vInfo[i][Faction]);
            mysql_fetch_int("Plate", vInfo[i][NrPlate]);

            CreateVehicle(vInfo[i][ModelID], vInfo[i][posX], vInfo[i][posY], vInfo[i][posZ], vInfo[i][posA], vInfo[i][ColorA], vInfo[i][ColorB], 10000000000000, 1);
            SetVehicleNumberPlate(i, vInfo[i][NrPlate]);

            SetVehicleParamsForPlayer(i, i, 0, 1);
            SetVehicleToRespawn(i);
        }
        mysql_free_result();
    }
    return 1;
}

I can post the other codes of the system if needed.