[JordanDoughty]

pawn Код:

stock LoadDoors()
{
    new DBResult:query = db_query(Database, "SELECT * FROM Doors"), szValue[64], dTitle[128];
    for(new i=0; i < db_num_rows(query); i++)
    {
        db_get_field_assoc(query, "TITLE", szValue, sizeof(szValue));
        format(DoorInfo[i][dName], 64, "%s", szValue);

        db_get_field_assoc(query, "EXTERIOR_POSX", szValue, 64);
        DoorInfo[i][dExteriorX] = floatstr(szValue);
        db_get_field_assoc(query, "EXTERIOR_POSY", szValue, 64);
        DoorInfo[i][dExteriorY] = floatstr(szValue);
        db_get_field_assoc(query, "EXTERIOR_POSZ", szValue, 64);
        DoorInfo[i][dExteriorZ] = floatstr(szValue);
        db_get_field_assoc(query, "EXTERIOR_ANGLE", szValue, 64);
        DoorInfo[i][dExteriorAngle] = floatstr(szValue);
        db_get_field_assoc(query, "EXTERIOR_INT", szValue, 64);
        DoorInfo[i][dExteriorInt] = strval(szValue);
        db_get_field_assoc(query, "EXTERIOR_VW", szValue, 64);
        DoorInfo[i][dExteriorVir] = strval(szValue);

        db_get_field_assoc(query, "INTERIOR_POSX", szValue, 64);
        DoorInfo[i][dInteriorX] = floatstr(szValue);
        db_get_field_assoc(query, "INTERIOR_POSY", szValue, 64);
        DoorInfo[i][dInteriorY] = floatstr(szValue);
        db_get_field_assoc(query, "INTERIOR_POSZ", szValue, 64);
        DoorInfo[i][dInteriorZ] = floatstr(szValue);
        db_get_field_assoc(query, "INTERIOR_ANGLE", szValue, 64);
        DoorInfo[i][dInteriorAngle] = floatstr(szValue);
        db_get_field_assoc(query, "INTERIOR_INT", szValue, 64);
        DoorInfo[i][dInteriorInt] = strval(szValue);
        db_get_field_assoc(query, "INTERIOR_VW", szValue, 64);
        DoorInfo[i][dInteriorVir] = strval(szValue);

        DoorInfo[i][dPickup] = CreateDynamicPickup(1318, 1, DoorInfo[i][dExteriorX], DoorInfo[i][dExteriorY], DoorInfo[i][dExteriorZ]);
        format(dTitle, sizeof(dTitle), "(ID: %i)\n%s", i, DoorInfo[i][dName]);
        DoorInfo[i][dDynamicText] = CreateDynamic3DTextLabel(dTitle, COLOR_WHITE, DoorInfo[i][dExteriorX], DoorInfo[i][dExteriorY], DoorInfo[i][dExteriorZ], 20.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1);

        db_next_row(query);
    }
}