Sid Meier's Civilization VI

Sid Meier's Civilization VI

Warfare Expanded Complete Edition
DB  [developer] 16 Jul, 2019 @ 1:11pm
Adding Naval Bombard Units to Maritime Industries, Press Gangs, & Int Waters
Here is the SQL to add naval bombard to the policies listed above:

INSERT INTO PolicyModifiers (PolicyType, ModifierId) VALUES ('POLICY_MARITIME_INDUSTRIES', 'MARITIMIEINDUSTRIES_ANCIENT_NAVAL_BOMBARD_PRODUCTION'), ('POLICY_MARITIME_INDUSTRIES', 'MARITIMIEINDUSTRIES_CLASSICAL_NAVAL_BOMBARD_PRODUCTION'), ('POLICY_PRESS_GANGS','MARITIMIEINDUSTRIES_ANCIENT_NAVAL_BOMBARD_PRODUCTION'), ('POLICY_PRESS_GANGS','MARITIMIEINDUSTRIES_CLASSICAL_NAVAL_BOMBARD_PRODUCTION'), ('POLICY_PRESS_GANGS','PRESSGANGS_MEDIEVAL_NAVAL_BOMBARD_PRODUCTION'), ('POLICY_PRESS_GANGS','PRESSGANGS_RENAISSANCE_NAVAL_BOMBARD_PRODUCTION'), ('POLICY_PRESS_GANGS','PRESSGANGS_INDUSTRIAL_NAVAL_BOMBARD_PRODUCTION'), ('POLICY_INTERNATIONAL_WATERS','MARITIMIEINDUSTRIES_ANCIENT_NAVAL_BOMBARD_PRODUCTION'), ('POLICY_INTERNATIONAL_WATERS','MARITIMIEINDUSTRIES_CLASSICAL_NAVAL_BOMBARD_PRODUCTION'), ('POLICY_INTERNATIONAL_WATERS','PRESSGANGS_MEDIEVAL_NAVAL_BOMBARD_PRODUCTION'), ('POLICY_INTERNATIONAL_WATERS','PRESSGANGS_RENAISSANCE_NAVAL_BOMBARD_PRODUCTION'), ('POLICY_INTERNATIONAL_WATERS','PRESSGANGS_INDUSTRIAL_NAVAL_BOMBARD_PRODUCTION'), ('POLICY_INTERNATIONAL_WATERS','INTERNATIONALWATERS_MODERN_NAVAL_BOMBARD_PRODUCTION'), ('POLICY_INTERNATIONAL_WATERS','INTERNATIONALWATERS_ATOMIC_NAVAL_BOMBARD_PRODUCTION'), ('POLICY_INTERNATIONAL_WATERS','INTERNATIONALWATERS_INFORMATION_NAVAL_BOMBARD_PRODUCTION') ; INSERT INTO Modifiers (ModifierId, ModifierType) VALUES ('MARITIMIEINDUSTRIES_ANCIENT_NAVAL_BOMBARD_PRODUCTION', 'MODIFIER_PLAYER_CITIES_ADJUST_UNIT_TAG_ERA_PRODUCTION'), ('MARITIMIEINDUSTRIES_CLASSICAL_NAVAL_BOMBARD_PRODUCTION', 'MODIFIER_PLAYER_CITIES_ADJUST_UNIT_TAG_ERA_PRODUCTION'), ('PRESSGANGS_MEDIEVAL_NAVAL_BOMBARD_PRODUCTION', 'MODIFIER_PLAYER_CITIES_ADJUST_UNIT_TAG_ERA_PRODUCTION'), ('PRESSGANGS_RENAISSANCE_NAVAL_BOMBARD_PRODUCTION', 'MODIFIER_PLAYER_CITIES_ADJUST_UNIT_TAG_ERA_PRODUCTION'), ('PRESSGANGS_INDUSTRIAL_NAVAL_BOMBARD_PRODUCTION', 'MODIFIER_PLAYER_CITIES_ADJUST_UNIT_TAG_ERA_PRODUCTION'), ('INTERNATIONALWATERS_MODERN_NAVAL_BOMBARD_PRODUCTION', 'MODIFIER_PLAYER_CITIES_ADJUST_UNIT_TAG_ERA_PRODUCTION'), ('INTERNATIONALWATERS_ATOMIC_NAVAL_BOMBARD_PRODUCTION', 'MODIFIER_PLAYER_CITIES_ADJUST_UNIT_TAG_ERA_PRODUCTION'), ('INTERNATIONALWATERS_INFORMATION_NAVAL_BOMBARD_PRODUCTION', 'MODIFIER_PLAYER_CITIES_ADJUST_UNIT_TAG_ERA_PRODUCTION') ; INSERT INTO ModifierArguments (ModifierId, Name, Value) VALUES ('MARITIMIEINDUSTRIES_ANCIENT_NAVAL_BOMBARD_PRODUCTION', 'Amount', 100), ('MARITIMIEINDUSTRIES_ANCIENT_NAVAL_BOMBARD_PRODUCTION', 'EraType', 'ERA_ANCIENT'), ('MARITIMIEINDUSTRIES_ANCIENT_NAVAL_BOMBARD_PRODUCTION', 'UnitPromotionClass', 'PROMOTION_CLASS_NAVAL_BOMBARD'), ('MARITIMIEINDUSTRIES_CLASSICAL_NAVAL_BOMBARD_PRODUCTION', 'Amount', 100), ('MARITIMIEINDUSTRIES_CLASSICAL_NAVAL_BOMBARD_PRODUCTION', 'EraType', 'ERA_CLASSICAL'), ('MARITIMIEINDUSTRIES_CLASSICAL_NAVAL_BOMBARD_PRODUCTION', 'UnitPromotionClass', 'PROMOTION_CLASS_NAVAL_BOMBARD'), ('PRESSGANGS_MEDIEVAL_NAVAL_BOMBARD_PRODUCTION', 'Amount', 100), ('PRESSGANGS_MEDIEVAL_NAVAL_BOMBARD_PRODUCTION', 'EraType', 'ERA_MEDIEVAL'), ('PRESSGANGS_MEDIEVAL_NAVAL_BOMBARD_PRODUCTION', 'UnitPromotionClass', 'PROMOTION_CLASS_NAVAL_BOMBARD'), ('PRESSGANGS_RENAISSANCE_NAVAL_BOMBARD_PRODUCTION', 'Amount', 100), ('PRESSGANGS_RENAISSANCE_NAVAL_BOMBARD_PRODUCTION', 'EraType', 'ERA_RENAISSANCE'), ('PRESSGANGS_RENAISSANCE_NAVAL_BOMBARD_PRODUCTION', 'UnitPromotionClass', 'PROMOTION_CLASS_NAVAL_BOMBARD'), ('PRESSGANGS_INDUSTRIAL_NAVAL_BOMBARD_PRODUCTION', 'Amount', 100), ('PRESSGANGS_INDUSTRIAL_NAVAL_BOMBARD_PRODUCTION', 'EraType', 'ERA_INDUSTRIAL'), ('PRESSGANGS_INDUSTRIAL_NAVAL_BOMBARD_PRODUCTION', 'UnitPromotionClass', 'PROMOTION_CLASS_NAVAL_BOMBARD'), ('INTERNATIONALWATERS_MODERN_NAVAL_BOMBARD_PRODUCTION', 'Amount', 100), ('INTERNATIONALWATERS_MODERN_NAVAL_BOMBARD_PRODUCTION', 'EraType', 'ERA_MODERN'), ('INTERNATIONALWATERS_MODERN_NAVAL_BOMBARD_PRODUCTION', 'UnitPromotionClass', 'PROMOTION_CLASS_NAVAL_BOMBARD'), ('INTERNATIONALWATERS_ATOMIC_NAVAL_BOMBARD_PRODUCTION', 'Amount', 100), ('INTERNATIONALWATERS_ATOMIC_NAVAL_BOMBARD_PRODUCTION', 'EraType', 'ERA_ATOMIC'), ('INTERNATIONALWATERS_ATOMIC_NAVAL_BOMBARD_PRODUCTION', 'UnitPromotionClass', 'PROMOTION_CLASS_NAVAL_BOMBARD'), ('INTERNATIONALWATERS_INFORMATION_NAVAL_BOMBARD_PRODUCTION', 'Amount', 100), ('INTERNATIONALWATERS_INFORMATION_NAVAL_BOMBARD_PRODUCTION', 'EraType', 'ERA_INFORMATION'), ('INTERNATIONALWATERS_INFORMATION_NAVAL_BOMBARD_PRODUCTION', 'UnitPromotionClass', 'PROMOTION_CLASS_NAVAL_BOMBARD') ;

Kind regards,
DB
< >
Showing 1-1 of 1 comments
DB  [developer] 27 Jul, 2019 @ 11:37am 
Fixed on 7/26/2019.
< >
Showing 1-1 of 1 comments
Per page: 1530 50