Fix New Techs UI Placement

Hajee

Prince
Joined
Nov 4, 2014
Messages
361
So I am trying to recreate a Tech Tree (Civic too) with the new techs added in the GS dlc. However the the UI Placement of the new techs are still random on game load.

Any ideas on reason why.

Code:
UPDATE Technologies SET Critical='0' WHERE Critical='1';
DELETE FROM    Technologies_XP2;
DELETE FROM TechnologyRandomCosts;

UPDATE Technologies SET EraType='ERA_CLASSICAL' WHERE TechnologyType='TECH_SAILING';
UPDATE Technologies SET EraType='ERA_CLASSICAL' WHERE TechnologyType='TECH_ARCHERY';
UPDATE Technologies SET EraType='ERA_MEDIEVAL' WHERE TechnologyType='TECH_CONSTRUCTION';
UPDATE Technologies SET EraType='ERA_INDUSTRIAL' WHERE TechnologyType='TECH_STEEL';
UPDATE Technologies SET EraType='ERA_MODERN' WHERE TechnologyType='TECH_COMBINED_ARMS';
UPDATE Technologies SET EraType='ERA_MODERN' WHERE TechnologyType='TECH_ADVANCED_BALLISTICS';
UPDATE Technologies SET EraType='ERA_ATOMIC' WHERE TechnologyType='TECH_TELECOMMUNICATIONS';
UPDATE Technologies SET EraType='ERA_ATOMIC' WHERE TechnologyType='TECH_SATELLITES';
UPDATE Technologies SET EraType='ERA_ATOMIC' WHERE TechnologyType='TECH_GUIDANCE_SYSTEMS';
UPDATE Technologies SET EraType='ERA_INFORMATION' WHERE TechnologyType='TECH_CYBERNETICS';
UPDATE Technologies SET EraType='ERA_INFORMATION' WHERE TechnologyType='TECH_SEASTEADS';
UPDATE Technologies SET EraType='ERA_INFORMATION' WHERE TechnologyType='TECH_PREDICTIVE_SYSTEMS';
  
--UIUpdate--           
  
--AncientEra--         
UPDATE Technologies SET UITreeRow='-2' WHERE TechnologyType='TECH_IRRIGATION';
UPDATE Technologies SET UITreeRow='-1' WHERE TechnologyType='TECH_ASTROLOGY';
UPDATE Technologies SET UITreeRow='0' WHERE TechnologyType='TECH_POTTERY';
UPDATE Technologies SET UITreeRow='1' WHERE TechnologyType='TECH_MINING';
UPDATE Technologies SET UITreeRow='2' WHERE TechnologyType='TECH_THE_WHEEL';
  
UPDATE Technologies SET UITreeRow='-2' WHERE TechnologyType='TECH_WRITING';
UPDATE Technologies SET UITreeRow='-1' WHERE TechnologyType='TECH_ANIMAL_HUSBANDRY';
UPDATE Technologies SET UITreeRow='1' WHERE TechnologyType='TECH_BRONZE_WORKING';
UPDATE Technologies SET UITreeRow='2' WHERE TechnologyType='TECH_MASONRY';
  
--ClassicalEra--       
  
UPDATE Technologies SET UITreeRow='-2' WHERE TechnologyType='TECH_SAILING';
UPDATE Technologies SET UITreeRow='-1' WHERE TechnologyType='TECH_MATHEMATICS';
UPDATE Technologies SET UITreeRow='0' WHERE TechnologyType='TECH_CURRENCY';
UPDATE Technologies SET UITreeRow='1' WHERE TechnologyType='TECH_ARCHERY';
UPDATE Technologies SET UITreeRow='2' WHERE TechnologyType='TECH_HORSEBACK_RIDING';
  
UPDATE Technologies SET UITreeRow='-2' WHERE TechnologyType='TECH_SHIPBUILDING';
UPDATE Technologies SET UITreeRow='-1' WHERE TechnologyType='TECH_CELESTIAL_NAVIGATION';
UPDATE Technologies SET UITreeRow='1' WHERE TechnologyType='TECH_ENGINEERING';
UPDATE Technologies SET UITreeRow='2' WHERE TechnologyType='TECH_IRON_WORKING';
  
--MedievalEra--       
  
UPDATE Technologies SET UITreeRow='-2' WHERE TechnologyType='TECH_MILITARY_ENGINEERING';
UPDATE Technologies SET UITreeRow='-1' WHERE TechnologyType='TECH_MILITARY_TACTICS';
UPDATE Technologies SET UITreeRow='0' WHERE TechnologyType='TECH_APPRENTICESHIP';
UPDATE Technologies SET UITreeRow='1' WHERE TechnologyType='TECH_CONSTRUCTION';
UPDATE Technologies SET UITreeRow='2' WHERE TechnologyType='TECH_BUTTRESS';
  
UPDATE Technologies SET UITreeRow='-2' WHERE TechnologyType='TECH_MACHINERY';
UPDATE Technologies SET UITreeRow='-1' WHERE TechnologyType='TECH_EDUCATION';
UPDATE Technologies SET UITreeRow='2' WHERE TechnologyType='TECH_STIRRUPS';
UPDATE Technologies SET UITreeRow='1' WHERE TechnologyType='TECH_CASTLES';
  
--RenaissanceEra--     
  
UPDATE Technologies SET UITreeRow='-2' WHERE TechnologyType='TECH_CARTOGRAPHY';
UPDATE Technologies SET UITreeRow='-1' WHERE TechnologyType='TECH_ASTRONOMY';
UPDATE Technologies SET UITreeRow='0' WHERE TechnologyType='TECH_BANKING';
UPDATE Technologies SET UITreeRow='1' WHERE TechnologyType='TECH_MASS_PRODUCTION';
UPDATE Technologies SET UITreeRow='2' WHERE TechnologyType='TECH_PRINTING';
  
UPDATE Technologies SET UITreeRow='-2' WHERE TechnologyType='TECH_SQUARE_RIGGING';
UPDATE Technologies SET UITreeRow='-1' WHERE TechnologyType='TECH_METAL_CASTING';
UPDATE Technologies SET UITreeRow='1' WHERE TechnologyType='TECH_GUNPOWDER';
UPDATE Technologies SET UITreeRow='2' WHERE TechnologyType='TECH_SIEGE_TACTICS';
  
--IndustrialEra--     
  
UPDATE Technologies SET UITreeRow='-2' WHERE TechnologyType='TECH_SCIENTIFIC_THEORY';
UPDATE Technologies SET UITreeRow='-1' WHERE TechnologyType='TECH_INDUSTRIALIZATION';
UPDATE Technologies SET UITreeRow='0' WHERE TechnologyType='TECH_BALLISTICS';
UPDATE Technologies SET UITreeRow='1' WHERE TechnologyType='TECH_MILITARY_SCIENCE';
UPDATE Technologies SET UITreeRow='2' WHERE TechnologyType='TECH_RIFLING';
  
UPDATE Technologies SET UITreeRow='-2' WHERE TechnologyType='TECH_STEAM_POWER';
UPDATE Technologies SET UITreeRow='-1' WHERE TechnologyType='TECH_SANITATION';
UPDATE Technologies SET UITreeRow='1' WHERE TechnologyType='TECH_ECONOMICS';
UPDATE Technologies SET UITreeRow='2' WHERE TechnologyType='TECH_STEEL';
  
--ModernEra--         
  
UPDATE Technologies SET UITreeRow='-2' WHERE TechnologyType='TECH_REFINING';
UPDATE Technologies SET UITreeRow='-1' WHERE TechnologyType='TECH_ELECTRICITY';
UPDATE Technologies SET UITreeRow='0' WHERE TechnologyType='TECH_RADIO';
UPDATE Technologies SET UITreeRow='1' WHERE TechnologyType='TECH_FLIGHT';
UPDATE Technologies SET UITreeRow='2' WHERE TechnologyType='TECH_REPLACEABLE_PARTS';
  
UPDATE Technologies SET UITreeRow='-2' WHERE TechnologyType='TECH_CHEMISTRY';
UPDATE Technologies SET UITreeRow='-1' WHERE TechnologyType='TECH_COMBINED_ARMS';
UPDATE Technologies SET UITreeRow='1' WHERE TechnologyType='TECH_ADVANCED_BALLISTICS';
UPDATE Technologies SET UITreeRow='2' WHERE TechnologyType='TECH_COMBUSTION';
  
--AtomicEra--         
  
UPDATE Technologies SET UITreeRow='-2' WHERE TechnologyType='TECH_PLASTICS';
UPDATE Technologies SET UITreeRow='-1' WHERE TechnologyType='TECH_COMPUTERS';
UPDATE Technologies SET UITreeRow='0' WHERE TechnologyType='TECH_NUCLEAR_FISSION';
UPDATE Technologies SET UITreeRow='1' WHERE TechnologyType='TECH_ADVANCED_FLIGHT';
UPDATE Technologies SET UITreeRow='2' WHERE TechnologyType='TECH_ROCKETRY';
  
UPDATE Technologies SET UITreeRow='-2' WHERE TechnologyType='TECH_TELECOMMUNICATIONS';
UPDATE Technologies SET UITreeRow='-1' WHERE TechnologyType='TECH_SYNTHETIC_MATERIALS';
UPDATE Technologies SET UITreeRow='1' WHERE TechnologyType='TECH_SATELLITES';
UPDATE Technologies SET UITreeRow='2' WHERE TechnologyType='TECH_GUIDANCE_SYSTEMS';
  
--InfoEra--           
  
UPDATE Technologies SET UITreeRow='-2' WHERE TechnologyType='TECH_LASERS';
UPDATE Technologies SET UITreeRow='-1' WHERE TechnologyType='TECH_ROBOTICS';
UPDATE Technologies SET UITreeRow='0' WHERE TechnologyType='TECH_NUCLEAR_FUSION';
UPDATE Technologies SET UITreeRow='1' WHERE TechnologyType='TECH_NANOTECHNOLOGY';
UPDATE Technologies SET UITreeRow='2' WHERE TechnologyType='TECH_COMPOSITES';
  
UPDATE Technologies SET UITreeRow='-2' WHERE TechnologyType='TECH_STEALTH_TECHNOLOGY';
UPDATE Technologies SET UITreeRow='-1' WHERE TechnologyType='TECH_CYBERNETICS';
UPDATE Technologies SET UITreeRow='1' WHERE TechnologyType='TECH_SEASTEADS';
UPDATE Technologies SET UITreeRow='2' WHERE TechnologyType='TECH_PREDICTIVE_SYSTEMS';
  
--FutureEra--         
UPDATE Technologies SET UITreeRow='-2' WHERE TechnologyType='TECH_ADVANCED_AI';
UPDATE Technologies SET UITreeRow='-1' WHERE TechnologyType='TECH_SMART_MATERIALS';
UPDATE Technologies SET UITreeRow='1' WHERE TechnologyType='TECH_ADVANCED_POWER_CELLS';
UPDATE Technologies SET UITreeRow='2' WHERE TechnologyType='TECH_OFFWORLD_MISSION';
UPDATE Technologies SET UITreeRow='0' WHERE TechnologyType='TECH_FUTURE_TECH';
  
--Cost--               
  
--AncientEra--         
UPDATE Technologies SET Cost='10' WHERE TechnologyType='TECH_IRRIGATION';
UPDATE Technologies SET Cost='10' WHERE TechnologyType='TECH_ASTROLOGY';
UPDATE Technologies SET Cost='10' WHERE TechnologyType='TECH_POTTERY';
UPDATE Technologies SET Cost='10' WHERE TechnologyType='TECH_MINING';
UPDATE Technologies SET Cost='10' WHERE TechnologyType='TECH_THE_WHEEL';
  
UPDATE Technologies SET Cost='20' WHERE TechnologyType='TECH_WRITING';
UPDATE Technologies SET Cost='20' WHERE TechnologyType='TECH_ANIMAL_HUSBANDRY';
UPDATE Technologies SET Cost='20' WHERE TechnologyType='TECH_BRONZE_WORKING';
UPDATE Technologies SET Cost='20' WHERE TechnologyType='TECH_MASONRY';
  
--ClassicalEra--       
  
UPDATE Technologies SET Cost='40' WHERE TechnologyType='TECH_SAILING';
UPDATE Technologies SET Cost='40' WHERE TechnologyType='TECH_MATHEMATICS';
UPDATE Technologies SET Cost='40' WHERE TechnologyType='TECH_CURRENCY';
UPDATE Technologies SET Cost='40' WHERE TechnologyType='TECH_ARCHERY';
UPDATE Technologies SET Cost='40' WHERE TechnologyType='TECH_HORSEBACK_RIDING';
  
UPDATE Technologies SET Cost='50' WHERE TechnologyType='TECH_SHIPBUILDING';
UPDATE Technologies SET Cost='50' WHERE TechnologyType='TECH_CELESTIAL_NAVIGATION';
UPDATE Technologies SET Cost='50' WHERE TechnologyType='TECH_ENGINEERING';
UPDATE Technologies SET Cost='50' WHERE TechnologyType='TECH_IRON_WORKING';
  
--MedievalEra--       
  
UPDATE Technologies SET Cost='100' WHERE TechnologyType='TECH_MILITARY_ENGINEERING';
UPDATE Technologies SET Cost='100' WHERE TechnologyType='TECH_MILITARY_TACTICS';
UPDATE Technologies SET Cost='100' WHERE TechnologyType='TECH_APPRENTICESHIP';
UPDATE Technologies SET Cost='100' WHERE TechnologyType='TECH_CONSTRUCTION';
UPDATE Technologies SET Cost='100' WHERE TechnologyType='TECH_BUTTRESS';
  
UPDATE Technologies SET Cost='110' WHERE TechnologyType='TECH_MACHINERY';
UPDATE Technologies SET Cost='110' WHERE TechnologyType='TECH_EDUCATION';
UPDATE Technologies SET Cost='110' WHERE TechnologyType='TECH_STIRRUPS';
UPDATE Technologies SET Cost='110' WHERE TechnologyType='TECH_CASTLES';
  
--RenaissanceEra--     
  
UPDATE Technologies SET Cost='220' WHERE TechnologyType='TECH_CARTOGRAPHY';
UPDATE Technologies SET Cost='220' WHERE TechnologyType='TECH_ASTRONOMY';
UPDATE Technologies SET Cost='220' WHERE TechnologyType='TECH_BANKING';
UPDATE Technologies SET Cost='220' WHERE TechnologyType='TECH_MASS_PRODUCTION';
UPDATE Technologies SET Cost='220' WHERE TechnologyType='TECH_PRINTING';
  
UPDATE Technologies SET Cost='230' WHERE TechnologyType='TECH_SQUARE_RIGGING';
UPDATE Technologies SET Cost='230' WHERE TechnologyType='TECH_METAL_CASTING';
UPDATE Technologies SET Cost='230' WHERE TechnologyType='TECH_GUNPOWDER';
UPDATE Technologies SET Cost='230' WHERE TechnologyType='TECH_SIEGE_TACTICS';
  
--IndustrialEra--     
  
UPDATE Technologies SET Cost='460' WHERE TechnologyType='TECH_SCIENTIFIC_THEORY';
UPDATE Technologies SET Cost='460' WHERE TechnologyType='TECH_INDUSTRIALIZATION';
UPDATE Technologies SET Cost='460' WHERE TechnologyType='TECH_BALLISTICS';
UPDATE Technologies SET Cost='460' WHERE TechnologyType='TECH_MILITARY_SCIENCE';
UPDATE Technologies SET Cost='460' WHERE TechnologyType='TECH_RIFLING';
  
UPDATE Technologies SET Cost='470' WHERE TechnologyType='TECH_STEAM_POWER';
UPDATE Technologies SET Cost='470' WHERE TechnologyType='TECH_SANITATION';
UPDATE Technologies SET Cost='470' WHERE TechnologyType='TECH_ECONOMICS';
UPDATE Technologies SET Cost='470' WHERE TechnologyType='TECH_STEEL';
  
--ModernEra--         
  
UPDATE Technologies SET Cost='940' WHERE TechnologyType='TECH_REFINING';
UPDATE Technologies SET Cost='940' WHERE TechnologyType='TECH_ELECTRICITY';
UPDATE Technologies SET Cost='940' WHERE TechnologyType='TECH_RADIO';
UPDATE Technologies SET Cost='940' WHERE TechnologyType='TECH_FLIGHT';
UPDATE Technologies SET Cost='940' WHERE TechnologyType='TECH_REPLACEABLE_PARTS';
  
UPDATE Technologies SET Cost='950' WHERE TechnologyType='TECH_CHEMISTRY';
UPDATE Technologies SET Cost='950' WHERE TechnologyType='TECH_COMBINED_ARMS';
UPDATE Technologies SET Cost='950' WHERE TechnologyType='TECH_ADVANCED_BALLISTICS';
UPDATE Technologies SET Cost='950' WHERE TechnologyType='TECH_COMBUSTION';
  
--AtomicEra--         

UPDATE Technologies SET Cost='1900' WHERE TechnologyType='TECH_PLASTICS';
UPDATE Technologies SET Cost='1900' WHERE TechnologyType='TECH_COMPUTERS';
UPDATE Technologies SET Cost='1900' WHERE TechnologyType='TECH_NUCLEAR_FISSION';
UPDATE Technologies SET Cost='1900' WHERE TechnologyType='TECH_ADVANCED_FLIGHT';
UPDATE Technologies SET Cost='1900' WHERE TechnologyType='TECH_ROCKETRY';

UPDATE Technologies SET Cost='1910' WHERE TechnologyType='TECH_TELECOMMUNICATIONS';
UPDATE Technologies SET Cost='1910' WHERE TechnologyType='TECH_SYNTHETIC_MATERIALS';
UPDATE Technologies SET Cost='1910' WHERE TechnologyType='TECH_SATELLITES';
UPDATE Technologies SET Cost='1910' WHERE TechnologyType='TECH_GUIDANCE_SYSTEMS';

--InfoEra--           

UPDATE Technologies SET Cost='3820' WHERE TechnologyType='TECH_LASERS';
UPDATE Technologies SET Cost='3820' WHERE TechnologyType='TECH_ROBOTICS';
UPDATE Technologies SET Cost='3820' WHERE TechnologyType='TECH_NUCLEAR_FUSION';
UPDATE Technologies SET Cost='3820' WHERE TechnologyType='TECH_NANOTECHNOLOGY';
UPDATE Technologies SET Cost='3820' WHERE TechnologyType='TECH_COMPOSITES';

UPDATE Technologies SET Cost='3830' WHERE TechnologyType='TECH_STEALTH_TECHNOLOGY';
UPDATE Technologies SET Cost='3830' WHERE TechnologyType='TECH_CYBERNETICS';
UPDATE Technologies SET Cost='3830' WHERE TechnologyType='TECH_SEASTEADS';
UPDATE Technologies SET Cost='3830' WHERE TechnologyType='TECH_PREDICTIVE_SYSTEMS';

--FutureEra--         
UPDATE Technologies SET Cost='4000' WHERE TechnologyType='TECH_ADVANCED_AI';
UPDATE Technologies SET Cost='4000' WHERE TechnologyType='TECH_SMART_MATERIALS';
UPDATE Technologies SET Cost='4000' WHERE TechnologyType='TECH_ADVANCED_POWER_CELLS';
UPDATE Technologies SET Cost='4000' WHERE TechnologyType='TECH_OFFWORLD_MISSION';
UPDATE Technologies SET Cost='4500' WHERE TechnologyType='TECH_FUTURE_TECH';

DELETE FROM TechnologyPrereqs;
INSERT INTO TechnologyPrereqs(Technology,PrereqTech)VALUES
--AncientEra--
('TECH_WRITING','TECH_IRRIGATION'),
('TECH_WRITING','TECH_ASTROLOGY'),
('TECH_ANIMAL_HUSBANDRY','TECH_ASTROLOGY'),
('TECH_ANIMAL_HUSBANDRY','TECH_POTTERY'),
('TECH_BRONZE_WORKING','TECH_POTTERY'),
('TECH_BRONZE_WORKING','TECH_MINING'),
('TECH_MASONRY','TECH_MINING'),
('TECH_MASONRY','TECH_THE_WHEEL'),
--ClassicalEra--
('TECH_SAILING','TECH_WRITING'),
('TECH_SAILING','TECH_ANIMAL_HUSBANDRY'),
('TECH_MATHEMATICS','TECH_WRITING'),
('TECH_MATHEMATICS','TECH_ANIMAL_HUSBANDRY'),
('TECH_CURRENCY','TECH_ANIMAL_HUSBANDRY'),
('TECH_CURRENCY','TECH_BRONZE_WORKING'),
('TECH_ARCHERY','TECH_BRONZE_WORKING'),
('TECH_ARCHERY','TECH_MASONRY'),
('TECH_HORSEBACK_RIDING','TECH_BRONZE_WORKING'),
('TECH_HORSEBACK_RIDING','TECH_MASONRY'),

('TECH_SHIPBUILDING','TECH_SAILING'),
('TECH_SHIPBUILDING','TECH_MATHEMATICS'),
('TECH_CELESTIAL_NAVIGATION','TECH_MATHEMATICS'),
('TECH_CELESTIAL_NAVIGATION','TECH_CURRENCY'),
('TECH_ENGINEERING','TECH_CURRENCY'),
('TECH_ENGINEERING','TECH_ARCHERY'),
('TECH_IRON_WORKING','TECH_ARCHERY'),
('TECH_IRON_WORKING','TECH_HORSEBACK_RIDING'),

--MedievalEra--

('TECH_MILITARY_ENGINEERING','TECH_SHIPBUILDING'),
('TECH_MILITARY_ENGINEERING','TECH_CELESTIAL_NAVIGATION'),
('TECH_MILITARY_TACTICS','TECH_SHIPBUILDING'),
('TECH_MILITARY_TACTICS','TECH_CELESTIAL_NAVIGATION'),
('TECH_APPRENTICESHIP','TECH_CELESTIAL_NAVIGATION'),
('TECH_APPRENTICESHIP','TECH_ENGINEERING'),
('TECH_CONSTRUCTION','TECH_ENGINEERING'),
('TECH_CONSTRUCTION','TECH_IRON_WORKING'),
('TECH_BUTTRESS','TECH_ENGINEERING'),
('TECH_BUTTRESS','TECH_IRON_WORKING'),

('TECH_MACHINERY','TECH_MILITARY_ENGINEERING'),
('TECH_MACHINERY','TECH_MILITARY_TACTICS'),
('TECH_EDUCATION','TECH_MILITARY_TACTICS'),
('TECH_EDUCATION','TECH_APPRENTICESHIP'),
('TECH_CASTLES','TECH_APPRENTICESHIP'),
('TECH_CASTLES','TECH_CONSTRUCTION'),
('TECH_STIRRUPS','TECH_CONSTRUCTION'),
('TECH_STIRRUPS','TECH_BUTTRESS'),

--RenaissanceEra--

('TECH_CARTOGRAPHY','TECH_MACHINERY'),
('TECH_CARTOGRAPHY','TECH_EDUCATION'),
('TECH_ASTRONOMY','TECH_MACHINERY'),
('TECH_ASTRONOMY','TECH_EDUCATION'),
('TECH_BANKING','TECH_EDUCATION'),
('TECH_BANKING','TECH_CASTLES'),
('TECH_MASS_PRODUCTION','TECH_CASTLES'),
('TECH_MASS_PRODUCTION','TECH_STIRRUPS'),
('TECH_PRINTING','TECH_CASTLES'),
('TECH_PRINTING','TECH_STIRRUPS'),

('TECH_SQUARE_RIGGING','TECH_CARTOGRAPHY'),
('TECH_SQUARE_RIGGING','TECH_ASTRONOMY'),
('TECH_METAL_CASTING','TECH_ASTRONOMY'),
('TECH_METAL_CASTING','TECH_BANKING'),
('TECH_GUNPOWDER','TECH_BANKING'),
('TECH_GUNPOWDER','TECH_MASS_PRODUCTION'),
('TECH_SIEGE_TACTICS','TECH_MASS_PRODUCTION'),
('TECH_SIEGE_TACTICS','TECH_PRINTING'),

--IndustrialEra--

('TECH_SCIENTIFIC_THEORY','TECH_SQUARE_RIGGING'),
('TECH_SCIENTIFIC_THEORY','TECH_METAL_CASTING'),
('TECH_INDUSTRIALIZATION','TECH_SQUARE_RIGGING'),
('TECH_INDUSTRIALIZATION','TECH_METAL_CASTING'),
('TECH_BALLISTICS','TECH_METAL_CASTING'),
('TECH_BALLISTICS','TECH_GUNPOWDER'),
('TECH_MILITARY_SCIENCE','TECH_GUNPOWDER'),
('TECH_MILITARY_SCIENCE','TECH_SIEGE_TACTICS'),
('TECH_RIFLING','TECH_GUNPOWDER'),
('TECH_RIFLING','TECH_SIEGE_TACTICS'),

('TECH_STEAM_POWER','TECH_SCIENTIFIC_THEORY'),
('TECH_STEAM_POWER','TECH_INDUSTRIALIZATION'),
('TECH_SANITATION','TECH_INDUSTRIALIZATION'),
('TECH_SANITATION','TECH_BALLISTICS'),
('TECH_ECONOMICS','TECH_BALLISTICS'),
('TECH_ECONOMICS','TECH_MILITARY_SCIENCE'),
('TECH_STEEL','TECH_MILITARY_SCIENCE'),
('TECH_STEEL','TECH_RIFLING'),

--ModernEra--

('TECH_REFINING','TECH_STEAM_POWER'),
('TECH_REFINING','TECH_SANITATION'),
('TECH_ELECTRICITY','TECH_STEAM_POWER'),
('TECH_ELECTRICITY','TECH_SANITATION'),
('TECH_RADIO','TECH_SANITATION'),
('TECH_RADIO','TECH_ECONOMICS'),
('TECH_FLIGHT','TECH_ECONOMICS'),
('TECH_FLIGHT','TECH_STEEL'),
('TECH_REPLACEABLE_PARTS','TECH_ECONOMICS'),
('TECH_REPLACEABLE_PARTS','TECH_STEEL'),

('TECH_CHEMISTRY','TECH_REFINING'),
('TECH_CHEMISTRY','TECH_ELECTRICITY'),
('TECH_COMBINED_ARMS','TECH_ELECTRICITY'),
('TECH_COMBINED_ARMS','TECH_RADIO'),
('TECH_ADVANCED_BALLISTICS','TECH_RADIO'),
('TECH_ADVANCED_BALLISTICS','TECH_FLIGHT'),
('TECH_COMBUSTION','TECH_FLIGHT'),
('TECH_COMBUSTION','TECH_REPLACEABLE_PARTS'),

--AtomicEra--

('TECH_PLASTICS','TECH_CHEMISTRY'),
('TECH_PLASTICS','TECH_COMBINED_ARMS'),
('TECH_COMPUTERS','TECH_CHEMISTRY'),
('TECH_COMPUTERS','TECH_COMBINED_ARMS'),
('TECH_NUCLEAR_FISSION','TECH_COMBINED_ARMS'),
('TECH_NUCLEAR_FISSION','TECH_ADVANCED_BALLISTICS'),
('TECH_ADVANCED_FLIGHT','TECH_ADVANCED_BALLISTICS'),
('TECH_ADVANCED_FLIGHT','TECH_COMBUSTION'),
('TECH_ROCKETRY','TECH_ADVANCED_BALLISTICS'),
('TECH_ROCKETRY','TECH_COMBUSTION'),

('TECH_TELECOMMUNICATIONS','TECH_PLASTICS'),
('TECH_TELECOMMUNICATIONS','TECH_COMPUTERS'),
('TECH_SYNTHETIC_MATERIALS','TECH_COMPUTERS'),
('TECH_SYNTHETIC_MATERIALS','TECH_NUCLEAR_FISSION'),
('TECH_SATELLITES','TECH_NUCLEAR_FISSION'),
('TECH_SATELLITES','TECH_ADVANCED_FLIGHT'),
('TECH_GUIDANCE_SYSTEMS','TECH_ADVANCED_FLIGHT'),
('TECH_GUIDANCE_SYSTEMS','TECH_ROCKETRY'),

--InfoEra--

('TECH_LASERS','TECH_TELECOMMUNICATIONS'),
('TECH_LASERS','TECH_SYNTHETIC_MATERIALS'),
('TECH_ROBOTICS','TECH_TELECOMMUNICATIONS'),
('TECH_ROBOTICS','TECH_SYNTHETIC_MATERIALS'),
('TECH_NUCLEAR_FUSION','TECH_SYNTHETIC_MATERIALS'),
('TECH_NUCLEAR_FUSION','TECH_SATELLITES'),
('TECH_NANOTECHNOLOGY','TECH_SATELLITES'),
('TECH_NANOTECHNOLOGY','TECH_GUIDANCE_SYSTEMS'),
('TECH_COMPOSITES','TECH_GUIDANCE_SYSTEMS'),
('TECH_COMPOSITES','TECH_SATELLITES'),

('TECH_STEALTH_TECHNOLOGY','TECH_LASERS'),
('TECH_STEALTH_TECHNOLOGY','TECH_ROBOTICS'),
('TECH_CYBERNETICS','TECH_ROBOTICS'),
('TECH_CYBERNETICS','TECH_NUCLEAR_FUSION'),
('TECH_SEASTEADS','TECH_NUCLEAR_FUSION'),
('TECH_SEASTEADS','TECH_NANOTECHNOLOGY'),
('TECH_PREDICTIVE_SYSTEMS','TECH_NANOTECHNOLOGY'),
('TECH_PREDICTIVE_SYSTEMS','TECH_COMPOSITES'),

--FutureEra--
('TECH_ADVANCED_AI','TECH_STEALTH_TECHNOLOGY'),
('TECH_ADVANCED_AI','TECH_CYBERNETICS'),
('TECH_SMART_MATERIALS','TECH_STEALTH_TECHNOLOGY'),
('TECH_SMART_MATERIALS','TECH_CYBERNETICS'),
('TECH_ADVANCED_POWER_CELLS','TECH_SEASTEADS'),
('TECH_ADVANCED_POWER_CELLS','TECH_PREDICTIVE_SYSTEMS'),
('TECH_OFFWORLD_MISSION','TECH_SEASTEADS'),
('TECH_OFFWORLD_MISSION','TECH_PREDICTIVE_SYSTEMS'),
('TECH_FUTURE_TECH','TECH_ADVANCED_AI'),
('TECH_FUTURE_TECH','TECH_SMART_MATERIALS'),
('TECH_FUTURE_TECH','TECH_ADVANCED_POWER_CELLS'),
('TECH_FUTURE_TECH','TECH_OFFWORLD_MISSION');
 
Back
Top Bottom