I'm trying to move the Helicopter to the Aircraft class and make it require the Aerodrome while moving the Mechanized Infantry to the Light Cavalry class and have it be the final promotion for Cavalry. Finally, I want to buff Infantry and cutoff it's upgrade so its the final melee. Here's my code:
-- Infantry cutoff from promotion
UPDATE Units
SET Combat = Combat + 8, UpgradeUnit = NULL
WHERE UnitType = 'UNIT_INFANTRY';
UPDATE Units
SET UpgradeUnit = 'UNIT_INFANTRY'
WHERE Unit = 'UNIT_ENGLISH_REDCOAT';
UPDATE Units
SET UpgradeUnit = 'UNIT_INFANTRY'
WHERE Unit = 'UNIT_FRENCH_GARDE_IMPERIALE';
-- Mechanized Infantry to Light Cavalry
UPDATE Units
SET Combat = Combat - 5, BaseMoves = 4, PromotionClass = 'PROMOTION_CLASS_LIGHT_CAVALRY'
WHERE UnitType = 'UNIT_MECHANIZED_INFANTRY';
UPDATE Units
SET Tag = 'CLASS_LIGHT_CAVALRY'
WHERE Type = 'UNIT_MECHANIZED_INFANTRY';
INSERT INTO TypeTags (Type, Tag)
VALUES ('UNIT_MECHANIZED_INFANTRY', 'CLASS_LIGHT_CHARIOT');
UPDATE = Units
SET UpgradeUnit = 'UNIT_MECHANIZED_INFANTRY'
WHERE Unit = 'UNIT_RUSSIAN_COSSACK';
UPDATE = Units
SET UpgradeUnit = 'UNIT_MECHANIZED_INFANTRY'
WHERE Unit = 'UNIT_CAVALRY';
--Helicopter to Aerodrome
UPDATE = Units
SET PrereqDistrict = 'DISTRICT_AERODROME'
WHERE UnitType = 'UNIT_HELICOPTER';
INSERT INTO TypeTags (Type, Tag)
VALUES ('UNIT_HELICOPTER', 'CLASS_AIRCRAFT');
The only thing that shows up in-game are the text edits I made in another file.
-- Infantry cutoff from promotion
UPDATE Units
SET Combat = Combat + 8, UpgradeUnit = NULL
WHERE UnitType = 'UNIT_INFANTRY';
UPDATE Units
SET UpgradeUnit = 'UNIT_INFANTRY'
WHERE Unit = 'UNIT_ENGLISH_REDCOAT';
UPDATE Units
SET UpgradeUnit = 'UNIT_INFANTRY'
WHERE Unit = 'UNIT_FRENCH_GARDE_IMPERIALE';
-- Mechanized Infantry to Light Cavalry
UPDATE Units
SET Combat = Combat - 5, BaseMoves = 4, PromotionClass = 'PROMOTION_CLASS_LIGHT_CAVALRY'
WHERE UnitType = 'UNIT_MECHANIZED_INFANTRY';
UPDATE Units
SET Tag = 'CLASS_LIGHT_CAVALRY'
WHERE Type = 'UNIT_MECHANIZED_INFANTRY';
INSERT INTO TypeTags (Type, Tag)
VALUES ('UNIT_MECHANIZED_INFANTRY', 'CLASS_LIGHT_CHARIOT');
UPDATE = Units
SET UpgradeUnit = 'UNIT_MECHANIZED_INFANTRY'
WHERE Unit = 'UNIT_RUSSIAN_COSSACK';
UPDATE = Units
SET UpgradeUnit = 'UNIT_MECHANIZED_INFANTRY'
WHERE Unit = 'UNIT_CAVALRY';
--Helicopter to Aerodrome
UPDATE = Units
SET PrereqDistrict = 'DISTRICT_AERODROME'
WHERE UnitType = 'UNIT_HELICOPTER';
INSERT INTO TypeTags (Type, Tag)
VALUES ('UNIT_HELICOPTER', 'CLASS_AIRCRAFT');
The only thing that shows up in-game are the text edits I made in another file.
