[Wizza]

Learn to use while-loops and use a single query not 100.

pawn Код:

forward LoadBuilding();
public LoadBuilding()
{
    new arrCoords[11][64];
    new row[512], idx;
    
    mysql_query("SELECT * FROM Buildings");
    mysql_store_result();
    
    while(mysql_fetch_row(row))
    {
        split(row, arrCoords, '|');
        Building[idx][EnterX] = floatstr(arrCoords[1]);
        Building[idx][EnterY] = floatstr(arrCoords[2]);
        Building[idx][EnterZ] = floatstr(arrCoords[3]);
        Building[idx][PickupID] = strval(arrCoords[4]);
        Building[idx][ExitX] = floatstr(arrCoords[5]);
        Building[idx][ExitY] = floatstr(arrCoords[6]);
        Building[idx][ExitZ] = floatstr(arrCoords[7]);
        strmid(Building[idx][BuildingName], arrCoords[8], 0, strlen(arrCoords[8]), 255);
        Building[idx][ExitInterior] = strval(arrCoords[9]);
        Building[idx][Custom] = strval(arrCoords[10]);

        //Building[idx][PickupID] = CreateStreamPickup(1239, 1, Building[idx][EnterX], Building[idx][EnterY], Building[idx][EnterZ],15);
        CreateDynamicPickup(1239, 1, Building[idx][EnterX], Building[idx][EnterY], Building[idx][EnterZ], -1, -1, -1, 40.0);
        idx++;
    }

    mysql_free_result();
    printf("%d Buildings loaded from database", idx);
    return true;
}