The problem that I have is filling the database. It took a lot of time to fill it the first time (for the previous version), but new sets came out, more prop's are now supported, and so on. So, the database requires actualization.
I'm looking for the help of the grf sets creators or volunteers.
What do I need:
The database is filled with data from the txt file of the specific format. The text data of the set is represened in the database, the graphical is in the png files. So, for every set I need the txt file and a group of png files.
You can find it, as usual, here http://ttd.cernun.net/transport/
The format of the file is the following, TAB separator is used.
comment strings are allowed and can begin from #,; or TAB#
Code: Select all
#VType Name Land scape IDs (hex) Capacity 1 Weight FullWeight Cost Speed Power Running cost Year of introduction Life Engine Life Reliability decay Loading speed Multihead flag Acceleration Air resistance TE AI Rating Effect (hex) Set
# Default ships Ship Chugger-Chug Passenger Ferry Toyland 100 passengers 0 6.2 18279 32 0 1476 1946 30 0 20 20 0 0 0 0 0 0 Default Set
Ship Shivershake Passenger Ferry Toyland 130 passengers 0 8.1 21325 64 0 1312 1976 30 0 20 20 0 0 0 0 0 0 Default Set
Ship MightyMover Cargo Ship Toyland 160 bags of sweets 0 50 24372 24 0 2460 1947 30 0 20 20 0 0 0 0 0 0 Default Set
Ship Powernaut Cargo Ship Toyland 190 bags of sweets 0 59.3 27418 40 0 1853 1982 30 0 20 20 0 0 0 0 0 0 Default Set
Ship MPS Oil Tanker Temperate, Arctic, Tropical 220000 litres of oil 0 220 30465 24 0 2296 1928 30 0 20 20 0 0 0 0 0 0 Default Set
Ship CS-Inc Oil Tanker Temperate, Arctic, Tropical 350000 litres of oil 0 350 33511 40 0 2050 1968 30 0 20 20 0 0 0 0 0 0 Default Set
Ship MPS Passenger Ferry Temperate, Arctic, Tropical 100 passengers 0 6.2 18279 32 0 1476 1927 30 0 20 20 0 0 0 0 0 0 Default Set
Ship FFP Passenger Ferry Temperate, Arctic, Tropical 130 passengers 0 8.1 21325 64 0 1312 1971 30 0 20 20 0 0 0 0 0 0 Default Set
Ship Bakewell 300 Hovercraft Temperate, Arctic, Tropical 100 passengers 0 6.2 28180 112 0 3117 1968 25 0 20 20 0 0 0 0 0 0 Default Set
Ship Yate Cargo Ship Temperate, Arctic, Tropical 160 crates of goods 0 80 24327 24 0 2460 1927 30 0 20 20 0 0 0 0 0 0 Default Set
Ship Bakewell Cargo Ship Temperate, Arctic, Tropical 190 crates of goods 0 95 27418 40 0 1853 1975 30 0 20 20 0 0 0 0 0 0 Default Set
# Default Aircrafts Aircraft Ploddyphut 100 Toyland 25 passengers, 5 bags of mail 0 2.8 26660 476 0 2390 1945 20 0 20 40 0 0 0 0 0 0 Default Set
Aircraft Ploddyphut 500 Toyland 60 passengers, 9 bags of mail 0 6 36914 476 0 2812 1956 20 0 20 40 0 0 0 0 0 0 Default Set
Aircraft Flashbang X1 Toyland 90 passengers, 12 bags of mail 0 8.6 51269 952 0 3937 1966 20 0 20 40 0 0 0 0 0 0 Default Set
Aircraft Juggerplane M1 Toyland 200 passengers, 40 bags of mail 0 22.5 65625 952 0 6187 1978 20 0 20 40 0 0 0 0 0 0 Default Set
Aircraft Flashbang Wizzer Toyland 100 passengers, 30 bags of mail 0 13.7 164062 2330 0 7171 1985 20 0 20 40 0 0 0 0 0 0 Default Set
Aircraft-Helicopter Powernaut Helicopter Toyland 40 passengers, 10 bags of mail 0 5 30761 321 0 2250 1957 20 0 20 40 0 0 0 0 0 0 Default Set
Possible cargos are
("tonnes of coal", "passengers", "litres of oil", "items of livestock", "crates of goods", "tonnes of grain", "tonnes of wood", "tonnes of iron ore", "tonnes of steel", "bags of valuables", "bags of mail", "tonnes of wheat", "tonnes of paper", "bags of gold", "tonnes of food", "litres of rubber", "tonnes of fruit", "tonnes of maize", "tonnes of copper ore", "litres of water", "bags of diamonds", "tonnes of sugar", "toys", "batteries", "bags of sweets", "tonnes of toffee", "litres of cola", "tonnes of candyfloss", "bubbles", "litres of plastic", "fuzzy drinks");
Possible VTypes are
('Aircraft', 'Aircraft-Plane', 'Aircraft-Helicopter', 'Aircraft-Train', 'Railway-Steam', 'Railway-Diesel', 'Railway-Electric', 'Railway-Wagon', 'Railway-Train', 'Monorail-Steam','Monorail-Diesel', 'Monorail-Electric', 'Monorail-Wagon', 'Monorail-Train', 'Maglev-Steam','Maglev-Diesel', 'Maglev-Electric', 'Maglev-Wagon', 'Maglev-Train', 'Ship', 'Ship-Train', 'Vehicle-Lorry', 'Vehicle-Bus', 'Vehicle-Train');
Possible landscapes are
('Temperate', 'Arctic', 'Tropical', 'Toyland', 'Original');
The name field has a specific format and is used to determinate the png name. It allows a list of pngs too. Then, a name has to be separated with comma into parts. Like this
Code: Select all
Railway-Electric ICE 3, [ICE 3 Passenger Carriage], [ICE 3 Mail Van] Temperate 45 passengers 150 152.8 82031 330 10800 2531 1999 30 0 20 10 1 0 0 0 0 0 Temperate Set
The name of the png file is made from the name by removing all non-literal and non-numerical symbols, transfered into lowcase. That means 'Volvo FH16 610 {Fruit} Ref' will become volvofh16610ref. And so on.
If some one is ready to help me, any help is welcome.