--------------------------------------------------------------
--------------------------------------------------------------
INSERT INTO Types
(Type, Kind )
VALUES ('UNIT_MER_KARBANTOS', 'KIND_UNIT' );
INSERT INTO Tags
(Tag, Vocabulary )
VALUES ('CLASS_MER_KARBANTOS', 'ABILITY_CLASS' );
INSERT INTO TypeTags
(Type, Tag)
SELECT 'UNIT_MER_KARBANTOS', Tag
FROM TypeTags
WHERE Type = 'UNIT_HEAVY_CHARIOT';
INSERT INTO TypeTags
(Type, Tag )
VALUES ('UNIT_MER_KARBANTOS', 'CLASS_MER_KARBANTOS' );
INSERT INTO UnitAiInfos
(UnitType, AiType)
SELECT 'UNIT_MER_KARBANTOS', AiType
FROM UnitAiInfos
WHERE UnitType = 'UNIT_HEAVY_CHARIOT';
INSERT INTO UnitAiInfos
(UnitType, AiType )
VALUES ('UNIT_MER_KARBANTOS', 'UNITAI_BUILD' );
INSERT INTO UnitReplaces
(CivUniqueUnitType, ReplacesUnitType)
VALUES ('UNIT_MER_KARBANTOS', 'UNIT_HEAVY_CHARIOT');
INSERT INTO Units (
UnitType,
Name,
Description,
TraitType,
BaseMoves,
Cost,
Maintenance,
PurchaseYield,
AdvisorType,
Combat,
RangedCombat,
Range,
BaseSightRange,
InitialLevel,
ZoneOfControl,
Domain,
FormationClass,
PromotionClass,
PseudoYieldType,
MandatoryObsoleteTech,
PrereqTech,
PrereqCivic
)
SELECT 'UNIT_MER_KARBANTOS', -- UnitType
'LOC_UNIT_MER_KARBANTOS_NAME', -- Name
'LOC_UNIT_MER_KARBANTOS_DESCRIPTION', -- Description
'TRAIT_LEADER_UNIT_MER_KARBANTOS', -- TraitType
BaseMoves,
Cost,
Maintenance,
PurchaseYield,
AdvisorType,
28,
28,
2,
BaseSightRange,
InitialLevel,
ZoneOfControl,
Domain,
FormationClass,
'PROMOTION_CLASS_HEAVY_CAVALRY',
PseudoYieldType,
MandatoryObsoleteTech,
PrereqTech, -- PrereqTech
PrereqCivic -- PrereqCivic
FROM Units
WHERE UnitType = 'UNIT_HEAVY_CHARIOT';
INSERT INTO UnitUpgrades
(Unit, UpgradeUnit)
SELECT 'UNIT_MER_KARBANTOS', UpgradeUnit
FROM UnitUpgrades
WHERE Unit = 'UNIT_HEAVY_CHARIOT';
-----------------------------------------------
-- Types
-------------------------------------
INSERT INTO Types
(Type, Kind)
VALUES --('ABILITY_MER_KARBANTOS_MOVEMENT', 'KIND_ABILITY'),
('ABILITY_MER_KARBANTOS_MOVEMENT_WOODS', 'KIND_ABILITY'),
('ABILITY_MER_KARBANTOS_CULTURE', 'KIND_ABILITY'),
('ABILITY_MER_SACRED_GROVES_MOVEMENT', 'KIND_ABILITY');
-----------------------------------------------
-- TypeTags
-------------------------------------
INSERT INTO TypeTags
(Type, Tag)
VALUES --('ABILITY_MER_KARBANTOS_MOVEMENT', 'CLASS_MER_KARBANTOS'),
('ABILITY_MER_KARBANTOS_MOVEMENT_WOODS', 'CLASS_MER_KARBANTOS'),
('ABILITY_MER_KARBANTOS_CULTURE', 'CLASS_MER_KARBANTOS'),
('ABILITY_MER_SACRED_GROVES_MOVEMENT', 'CLASS_LANDCIVILIAN'),
('ABILITY_MER_SACRED_GROVES_MOVEMENT', 'CLASS_ANTI_CAVALRY'),
('ABILITY_MER_SACRED_GROVES_MOVEMENT', 'CLASS_MELEE'),
('ABILITY_MER_SACRED_GROVES_MOVEMENT', 'CLASS_RANGED'),
('ABILITY_MER_SACRED_GROVES_MOVEMENT', 'CLASS_RECON'),
('ABILITY_MER_SACRED_GROVES_MOVEMENT', 'CLASS_SUPPORT'),
('ABILITY_MER_SACRED_GROVES_MOVEMENT', 'CLASS_MER_KARBANTOS'),
('ABILITY_MER_SACRED_GROVES_MOVEMENT', 'CLASS_RELIGIOUS');
-----------------------------------------------
-- UnitAbilities
-----------------------------------------------
INSERT INTO UnitAbilities
(UnitAbilityType, Name, Description, Inactive)
VALUES --('ABILITY_MER_KARBANTOS_MOVEMENT', 'LOC_MODIFIER_MER_KARBANTOS_MOVEMENT_NAME', 'LOC_MODIFIER_MER_KARBANTOS_MOVEMENT_DESC', null ),
('ABILITY_MER_KARBANTOS_MOVEMENT_WOODS', 'LOC_MODIFIER_MER_KARBANTOS_MOVEMENT_NAME', 'LOC_MODIFIER_MER_KARBANTOS_MOVEMENT_DESC', 0 ),
('ABILITY_MER_KARBANTOS_CULTURE', 'LOC_MODIFIER_MER_KARBANTOS_CULTURE_NAME', 'LOC_MODIFIER_MER_KARBANTOS_CULTURE_DESC', 0 ),
('ABILITY_MER_SACRED_GROVES_MOVEMENT', 'LOC_MODIFIER_MER_SACRED_GROVES_MOVEMENT_NAME', 'LOC_MODIFIER_MER_SACRED_GROVES_MOVEMENT_DESC', 1 );
INSERT INTO UnitAbilityModifiers
(UnitAbilityType, ModifierId )
VALUES --('ABILITY_MER_KARBANTOS_MOVEMENT', 'MER_KARBANTOS_MOVEMENT' ),
('ABILITY_MER_KARBANTOS_MOVEMENT_WOODS', 'MER_KARBANTOS_MOVEMENT_WOODS' ),
('ABILITY_MER_KARBANTOS_CULTURE', 'MER_KARBANTOS_CULTURE' ),
('ABILITY_MER_SACRED_GROVES_MOVEMENT', 'MER_SACRED_GROVES_MOVEMENT' );
--('ABILITY_MER_SACRED_GROVES_MOVEMENT', 'MER_SACRED_GROVES_MOVEMENT_2' );
-----------------------------------------------
-- Modifiers
-----------------------------------------------
INSERT INTO Modifiers
(ModifierId, ModifierType, SubjectRequirementSetId )
VALUES ('MER_KARBANTOS_CULTURE', 'MODIFIER_UNIT_ADJUST_POST_COMBAT_YIELD', null ),
--('MER_KARBANTOS_MOVEMENT', 'MODIFIER_PLAYER_UNIT_ADJUST_CLEAR_TERRAIN_START_MOVEMENT', null ),
('MER_KARBANTOS_MOVEMENT_WOODS', 'MODIFIER_PLAYER_UNIT_ADJUST_MOVEMENT', 'MER_BRITON_PLOT_HAS_WOODS' ),
('MER_SACRED_GROVES_MOVEMENT', 'MODIFIER_PLAYER_UNIT_ADJUST_IGNORE_TERRAIN_COST', null );
--('MER_SACRED_GROVES_MOVEMENT_2', 'MODIFIER_PLAYER_UNIT_ADJUST_MOVEMENT', 'PLOT_HAS_JUNGLE_REQUIREMENTS' );
-----------------------------------------------
-- ModifierArguments
-----------------------------------------------
INSERT INTO ModifierArguments
(ModifierId, Name, Value )
VALUES ('MER_KARBANTOS_CULTURE', 'YieldType', 'YIELD_CULTURE' ),
('MER_KARBANTOS_CULTURE', 'PercentDefeatedStrength', 50 ),
--('MER_KARBANTOS_MOVEMENT', 'Amount', 1 ),
('MER_KARBANTOS_MOVEMENT_WOODS', 'Amount', 1 ),
('MER_SACRED_GROVES_MOVEMENT', 'Ignore', 1 ),
('MER_SACRED_GROVES_MOVEMENT', 'Type', 'FOREST' );
--('MER_SACRED_GROVES_MOVEMENT_2', 'Amount', -1 );