Unit Ability modifier question

[Craig_Sutter]

I have created a unit ability for my Hirdmann unit for my mod. Two of the abilities are that the unit has +5 Combat Strength on land adjacent to coast and +5 Combat Strength on plots adjacent to rivers.

I have a suspicion that the code I used will be additive on plots both adjacent to a river and a coastal hex (+10). This is not my intent... I would prefer that the two not be additive.

Is this possible using the xml provided? If possible, how should I change the code listed?

The code as created does not generate any errors.

Here is the code for the unit (ignore the Drekar stuff, and the +5 on attack for Hirdmann which should be additive.):

<GameInfo>
    <Types>
        <Row Type="UNIT_DANISH_HIRDMANN" Kind="KIND_UNIT"/>
        <Row Type="ABILITY_HIRDMANN" Kind="KIND_ABILITY"/>
        <Row Type="UNIT_DANISH_DREKAR" Kind="KIND_UNIT"/>
    </Types>
    <UnitAiInfos>
        <Row UnitType="UNIT_DANISH_HIRDMANN" AiType="UNITAI_COMBAT"/>
        <Row UnitType="UNIT_DANISH_HIRDMANN" AiType="UNITAI_EXPLORE"/>
        <Row UnitType="UNIT_DANISH_HIRDMANN" AiType="UNITTYPE_MELEE"/>
        <Row UnitType="UNIT_DANISH_HIRDMANN" AiType="UNITTYPE_LAND_COMBAT"/>
        <Row UnitType="UNIT_DANISH_DREKAR" AiType="UNITAI_COMBAT"/>
        <Row UnitType="UNIT_DANISH_DREKAR" AiType="UNITAI_EXPLORE"/>
        <Row UnitType="UNIT_DANISH_DREKAR" AiType="UNITTYPE_MELEE"/>
        <Row UnitType="UNIT_DANISH_DREKAR" AiType="UNITTYPE_NAVAL"/>
    </UnitAiInfos>
    <Tags>
    <Row Tag="CLASS_HIRDMANN" Vocabulary="ABILITY_CLASS"/>
    <Row Tag="CLASS_DREKAR" Vocabulary="ABILITY_CLASS"/>
    </Tags>
    <TypeTags>
        <Row Type="ABILITY_HIRDMANN" Tag=CLASS_HIRDMANN"/>
        <Row Type="UNIT_DANISH_HIRDMANN" Tag="CLASS_HIRDMANN"/>
        <Row Type="UNIT_DANISH_HIRDMANN" Tag="CLASS_MELEE"/>
        <Row Type="UNIT_DANISH_DREKAR" Tag="CLASS_NAVAL_RAIDER"/>
        <Row Type="UNIT_DANISH_DREKAR" Tag="CLASS_NAVAL_MELEE"/>
        <Row Type="UNIT_DANISH_DREKAR" Tag="CLASS_DREKAR"/>
    </TypeTags>
    <UnitReplaces>
        <Row CivUniqueUnitType="UNIT_DANISH_HIRDMANN" ReplacesUnitType="UNIT_SWORDSMAN"/>
        <Row CivUniqueUnitType="UNIT_DANISH_DREKAR" ReplacesUnitType="UNIT_GALLEY"/>
    </UnitReplaces>
      <Units>
        <Row UnitType="UNIT_DANISH_HIRDMANN" BaseMoves="2" Cost="110" AdvisorType="ADVISOR_CONQUEST" BaseSightRange="2" ZoneOfControl="true" Domain="DOMAIN_LAND" FormationClass="FORMATION_CLASS_LAND_COMBAT" Name="LOC_UNIT_DANISH_HIRDMANN_NAME" Description="LOC_UNIT_DANISH_HIRDMANN_DESCRIPTION" PurchaseYield="YIELD_GOLD" PromotionClass="PROMOTION_CLASS_MELEE" Maintenance="2" Combat="40" TraitType="TRAIT_LEADER_UNIT_DANISH_HIRDMANN" PrereqTech="TECH_IRON_WORKING" MandatoryObsoleteTech="TECH_REPLACEABLE_PARTS"/>
        <Row UnitType="UNIT_DANISH_DREKAR" BaseMoves="3" Cost="65" AdvisorType="ADVISOR_CONQUEST" BaseSightRange="2" ZoneOfControl="true" Domain="DOMAIN_SEA" FormationClass="FORMATION_CLASS_NAVAL" Name="LOC_UNIT_DANISH_DREKAR_NAME" Description="LOC_UNIT_DANISH_DREKAR_DESCRIPTION" PurchaseYield="YIELD_GOLD" PromotionClass="PROMOTION_CLASS_NAVAL_MELEE" Maintenance="1" Combat="30" TraitType="TRAIT_CIVILIZATION_UNIT_DANISH_DREKAR" PrereqTech="TECH_SAILING" MandatoryObsoleteTech="TECH_ELECTRICITY"/>
      </Units>
    <UnitUpgrades>
        <Row Unit="UNIT_DANISH_HIRDMANN" UpgradeUnit="UNIT_MUSKETMAN"/>
        <Row Unit="UNIT_DANISH_DREKAR" UpgradeUnit="UNIT_CARAVEL"/>
    </UnitUpgrades>
    <UnitAbilities>
        <Row UnitAbilityType="ABILITY_HIRDMANN" Name="LOC_ABILITY_HIRDMANN_NAME" Description="LOC_ABILITY_HIRDMANN_DESCRIPTION"/>
    </UnitAbilities>
    <UnitAbilityModifiers>
        <Row>
            <UnitAbilityType>ABILITY_HIRDMANN</UnitAbilityType>
            <ModifierId>HIRDMANN_COMBAT_COASTAL_LAND</ModifierId>
        </Row>
        <Row>
            <UnitAbilityType>ABILITY_HIRDMANN</UnitAbilityType>
            <ModifierId>HIRDMANN_COMBAT_RIVER_LAND</ModifierId>
        </Row>
        <Row>
            <UnitAbilityType>ABILITY_HIRDMANN</UnitAbilityType>
            <ModifierId>UNIT_HIRDMANN_ATTACK</ModifierId>
        </Row>
    </UnitAbilityModifiers>
    <Modifiers>
        <Row>
            <ModifierId>HIRDMANN_COMBAT_COASTAL_LAND</ModifierId>
            <ModifierType>MODIFIER_UNIT_ADJUST_COMBAT_STRENGTH</ModifierType>
            <SubjectRequirementSetId>HIRDMANN_PLOT_IS_COASTAL_LAND_REQUIREMENTS</SubjectRequirementSetId>
        </Row>
        <Row>
            <ModifierId>HIRDMANN_COMBAT_RIVER_LAND</ModifierId>
            <ModifierType>MODIFIER_UNIT_ADJUST_COMBAT_STRENGTH</ModifierType>
            <SubjectRequirementSetId>HIRDMANN_PLOT_IS_RIVER_LAND_REQUIREMENTS</SubjectRequirementSetId>
        </Row>
        <Row>
            <ModifierId>UNIT_HIRDMANN_ATTACK</ModifierId>
            <ModifierType>MODIFIER_UNIT_ADJUST_COMBAT_STRENGTH</ModifierType>
            <SubjectRequirementSetId>UNIT_HIRDMANN_ATTACK_REQUIREMENTS</SubjectRequirementSetId>
        </Row>
    </Modifiers>
    <ModifierArguments>
        <Row>
            <ModifierId>HIRDMANN_COMBAT_COASTAL_LAND</ModifierId>
            <Name>Amount</Name>
            <Value>5</Value>
        </Row>
        <Row>
            <ModifierId>HIRDMANN_COMBAT_RIVER_LAND</ModifierId>
            <Name>Amount</Name>
            <Value>5</Value>
        </Row>
        <Row>
            <ModifierId>UNIT_HIRDMANN_ATTACK</ModifierId>
            <Name>Amount</Name>
            <Value>5</Value>
        </Row>
    </ModifierArguments>
    <RequirementSets>
        <Row>
            <RequirementSetId>HIRDMANN_PLOT_IS_COASTAL_LAND_REQUIREMENTS</RequirementSetId>
            <RequirementSetType>REQUIREMENTSET_TEST_ALL</RequirementSetType>
        </Row>
        <Row>
            <RequirementSetId>HIRDMANN_PLOT_IS_RIVER_LAND_REQUIREMENTS</RequirementSetId>
            <RequirementSetType>REQUIREMENTSET_TEST_ALL</RequirementSetType>
        </Row>
        <Row>
            <RequirementSetId>UNIT_STRONG_ATTACKER_REQUIREMENTS</RequirementSetId>
            <RequirementSetType>REQUIREMENTSET_TEST_ALL</RequirementSetType>
        </Row>
    </RequirementSets>
    <RequirementSetRequirements>      
        <Row>
            <RequirementSetId>HIRDMANN_PLOT_IS_COASTAL_LAND_REQUIREMENTS</RequirementSetId>
            <RequirementId>HIRDMANN_ADJCOAST_REQUIREMENT</RequirementId>
        </Row>
        <Row>
            <RequirementSetId>HIRDMANN_PLOT_IS_RIVER_LAND_REQUIREMENTS</RequirementSetId>
            <RequirementId>HIRDMANN_ADJRIVER_REQUIREMENT</RequirementId>
        </Row>
        <Row>
            <RequirementSetId>UNIT_STRONG_ATTACKER_REQUIREMENTS</RequirementSetId>
            <RequirementId>UNIT_STRONG_ATTACKER_REQUIREMENT</RequirementId>
        </Row>
       
    </RequirementSetRequirements>
    <Requirements>      
        <Row>
            <RequirementId>HIRDMANN_ADJCOAST_REQUIREMENT</RequirementId>
            <RequirementType>REQUIREMENT_PLOT_IS_COASTAL_LAND</RequirementType>
        </Row>
        <Row>
            <RequirementId>HIRDMANN_ADJRIVER_REQUIREMENT</RequirementId>
            <RequirementType>REQUIREMENT_PLOT_ADJACENT_TO_RIVER</RequirementType>
        </Row>
        <Row>
            <RequirementId>UNIT_STRONG_ATTACKER_REQUIREMENT</RequirementId>
            <RequirementType>REQUIREMENT_PLAYER_IS_ATTACKING</RequirementType>
        </Row>
    </Requirements>
</GameInfo>

Thank-you for your advice.

 

[thecrazyscot]

You can combine the two into a single modifier so that there's no chance of stacking.

Use a single requirement set with the REQUIREMENTSET_TEST_ANY RequirementSet type. Then set the two requirement ids to have the same requirementsetid under RequirementSetRequirements.

This will create a modifier which only requires one of those requirement ids in order to activate. TEST_ALL needs all requirement ids to be met in order to activate the modifier. TEST_ANY will activate the modifier as long as one requirement id is met.

Does that make sense? On my phone so a bit harder to give longer coherent thoughts.

 

[Craig_Sutter]

That makes all kinds of sense. Thanks.

 

[N@udor]

That makes all kinds of sense. Thanks.

Hi.

Craig, can you give me all your code of your mod? I'm trying to make custom abilities for my new units, but I don't work and in the Game Effects.log I can see the next messages:

[968328.926] [Turn: 1] Warning: Object <Player: 0> does not support interface <{B3DF7354-0054-4FA5-9423-324C7704DA9F}>.
[968328.926] [Turn: 1] Warning: Failed to Attach Modifier <CAT_FRANCESC_MACIA_DEFENDER> to <Player: 0> because <Invalid Definition>.
[968328.926] [Turn: 1] Arguments:
[968328.926] [Turn: 1] Amount: 10

My units file is this:

<?xml version="1.0" encoding="utf-8"?>
<GameData>
<Types>
<Row Type="UNIT_CAT_ALMOGAVERS" Kind="KIND_UNIT"/>
<Row Type="UNIT_CAT_MIQUELETS" Kind="KIND_UNIT"/>
<Row Type="CAT_FRANCESC_MACIA_DAMAGE_REDUCTION" Kind="KIND_MODIFIER"/>
<Row Type="CAT_FRANCESC_MACIA_DEFENDER" Kind="KIND_MODIFIER"/>
<Row Type="CAT_FRANCESC_MACIA_ABILITY_DAMAGE_REDUCTION" Kind="KIND_ABILITY"/>
<Row Type="CAT_FRANCESC_MACIA_ABILITY_DEFENDER" Kind="KIND_ABILITY"/>
</Types>
<Units>
<Row UnitType="UNIT_CAT_ALMOGAVERS" BaseMoves="2" Cost= "1" AdvisorType="ADVISOR_CONQUEST" BaseSightRange="2" ZoneOfControl="true" Domain="DOMAIN_LAND" FormationClass="FORMATION_CLASS_LAND_COMBAT" Name="LOC_UNIT_CAT_ALMOGAVERS_NAME" Description="LOC_UNIT_CAT_ALMOGAVERS_DESCRIPTION" PurchaseYield="YIELD_GOLD" PromotionClass="PROMOTION_CLASS_MELEE" Combat="40" MandatoryObsoleteTech="TECH_GUNPOWDER" TraitType="TRAIT_LEADER_CAT_FRANCESC_MACIA_UNIT_ALMOGAVER"/>
<Row UnitType="UNIT_CAT_MIQUELETS" BaseMoves="2" Cost="120" AdvisorType="ADVISOR_CONQUEST" BaseSightRange="2" ZoneOfControl="true" Domain="DOMAIN_LAND" FormationClass="FORMATION_CLASS_LAND_COMBAT" Name="LOC_UNIT_CAT_MIQUELETS_NAME" Description="LOC_UNIT_CAT_MIQUELETS_DESCRIPTION" PurchaseYield="YIELD_GOLD" PromotionClass="PROMOTION_CLASS_MELEE" Maintenance="3" Combat="50" MandatoryObsoleteTech="TECH_SATELLITES" PrereqTech="TECH_GUNPOWDER" StrategicResource="RESOURCE_NITER" TraitType="TRAIT_LEADER_CAT_FRANCESC_MACIA_UNIT_MIQUELET"/>
</Units>

<UnitAIInfos>
<Row UnitType="UNIT_CAT_ALMOGAVERS" AiType="UNITAI_COMBAT"/>
<Row UnitType="UNIT_CAT_ALMOGAVERS" AiType="UNITAI_EXPLORE"/>
<Row UnitType="UNIT_CAT_ALMOGAVERS" AiType="UNITTYPE_MELEE"/>
<Row UnitType="UNIT_CAT_ALMOGAVERS" AiType="UNITTYPE_LAND_COMBAT"/>
<Row UnitType="UNIT_CAT_MIQUELETS" AiType="UNITAI_COMBAT"/>
<Row UnitType="UNIT_CAT_MIQUELETS" AiType="UNITAI_EXPLORE"/>
<Row UnitType="UNIT_CAT_MIQUELETS" AiType="UNITTYPE_MELEE"/>
<Row UnitType="UNIT_CAT_MIQUELETS" AiType="UNITTYPE_LAND_COMBAT"/>
</UnitAIInfos>
<Tags>
<Row Tag="CLASS_CAT_ALMOGAVERS" Vocabulary="ABILITY_CLASS"/>
<Row Tag="CLASS_CAT_MIQUELETS" Vocabulary="ABILITY_CLASS"/>
</Tags>

<TypeTags>
<Row Type="UNIT_CAT_ALMOGAVERS" Tag="CLASS_CAT_ALMOGAVERS"/>
<Row Type="UNIT_CAT_MIQUELETS" Tag="CLASS_CAT_MIQUELETS"/>
<Row Type="UNIT_CAT_ALMOGAVERS" Tag="CLASS_MELEE"/>
<Row Type="UNIT_CAT_MIQUELETS" Tag="CLASS_MELEE"/>
</TypeTags>
<UnitAbilities>
<Row UnitAbilityType="CAT_FRANCESC_MACIA_ABILITY_DAMAGE_REDUCTION" Name="LOC_TRAIT_LEADER_CAT_FRANCESC_MACIA_UNIT_ALMOGAVER_NAME" Description="LOC_TRAIT_LEADER_CAT_FRANCESC_MACIA_UNIT_ALMOGAVER_DESCRIPTION"/>
<Row UnitAbilityType="CAT_FRANCESC_MACIA_ABILITY_DEFENDER" Name="LOC_TRAIT_LEADER_CAT_FRANCESC_MACIA_UNIT_MIQUELET_NAME" Description="LOC_TRAIT_LEADER_CAT_FRANCESC_MACIA_UNIT_MIQUELET_DESCRIPTION"/>
</UnitAbilities>

<UnitAbilityModifiers>
<Row>
<UnitAbilityType>CAT_FRANCESC_MACIA_ABILITY_DAMAGE_REDUCTION</UnitAbilityType>
<ModifierId>CAT_FRANCESC_MACIA_DAMAGE_REDUCTION</ModifierId>
</Row>
<Row>
<UnitAbilityType>CAT_FRANCESC_MACIA_ABILITY_DEFENDER</UnitAbilityType>
<ModifierId>CAT_FRANCESC_MACIA_DEFENDER</ModifierId>
</Row>
</UnitAbilityModifiers>

<MajorStartingUnits>
<Row Era="ERA_ANCIENT" Unit="UNIT_CAT_ALMOGAVERS"/>
<Row Era="ERA_ANCIENT" Unit="UNIT_CAT_MIQUELETS"/>
</MajorStartingUnits>

</GameData>

I have another file in SQL where I have the rest of the code (sorry but I have been trying different examples of this forum for 6 days):

--==========================================================================================================================
-- LEADERS
--==========================================================================================================================
-- Types
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Types
(Type, Kind)
VALUES ('LEADER_CAT_FRANCESC_MACIA', 'KIND_LEADER');
--------------------------------------------------------------------------------------------------------------------------
-- Leaders
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Leaders
(LeaderType, Name, InheritFrom, SceneLayers)
VALUES ('LEADER_CAT_FRANCESC_MACIA', 'LOC_LEADER_CAT_FRANCESC_MACIA_NAME', 'LEADER_DEFAULT', 4);
--------------------------------------------------------------------------------------------------------------------------
-- LeaderQuotes
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO LeaderQuotes
(LeaderType, Quote)
VALUES ('LEADER_CAT_FRANCESC_MACIA', 'LOC_PEDIA_LEADERS_PAGE_LEADER_CAT_FRANCESC_MACIA_QUOTE');
--------------------------------------------------------------------------------------------------------------------------
-- HistoricalAgendas
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO HistoricalAgendas
(LeaderType, AgendaType)
VALUES ('LEADER_CAT_FRANCESC_MACIA', 'AGENDA_PEACEKEEPER');
--------------------------------------------------------------------------------------------------------------------------
-- AgendaPreferredLeaders
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO AgendaPreferredLeaders
(LeaderType, AgendaType)
VALUES ('LEADER_CAT_FRANCESC_MACIA', 'AGENDA_CIVILIZED');
--==========================================================================================================================
-- LEADERS: COLOURS
--==========================================================================================================================
-- PlayerColors
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO PlayerColors
(Type, Usage, PrimaryColor, SecondaryColor, TextColor)
VALUES ('LEADER_CAT_FRANCESC_MACIA', 'Unique', 'COLOR_PLAYER_CAT_FRANCESC_MACIA_PRIMARY', 'COLOR_PLAYER_CAT_FRANCESC_MACIA_SECONDARY', 'COLOR_PLAYER_WHITE_TEXT');
INSERT INTO Colors
(Type, Red, Green, Blue, Alpha)
VALUES ('COLOR_PLAYER_CAT_FRANCESC_MACIA_PRIMARY', 1, 1, 0, 1),
('COLOR_PLAYER_CAT_FRANCESC_MACIA_SECONDARY', 1, 0, 0, 1);
--==========================================================================================================================
-- LEADERS: LOADING INFO
--==========================================================================================================================
-- LoadingInfo
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO LoadingInfo
(LeaderType, BackgroundImage, ForegroundImage, PlayDawnOfManAudio)
VALUES ('LEADER_CAT_FRANCESC_MACIA', 'LEADER_FRANCESC_MACIA_BACKGROUND', 'LEADER_FRANCESC_MACIA_NEUTRAL', 0);
--==========================================================================================================================
-- CIVILIZATIONS
--==========================================================================================================================
-- Types
----------------------------------------------------------------------------------------------------------------------------
INSERT INTO Types
(Type, Kind)
VALUES ('CIVILIZATION_CAT', 'KIND_CIVILIZATION');
----------------------------------------------------------------------------------------------------------------------------
-- Civilizations
----------------------------------------------------------------------------------------------------------------------------
INSERT INTO Civilizations
(CivilizationType, Name, Description, Adjective, StartingCivilizationLevelType, RandomCityNameDepth, Ethnicity)
VALUES ('CIVILIZATION_CAT', 'LOC_CIVILIZATION_CAT_NAME', 'LOC_CIVILIZATION_CAT_DESCRIPTION', 'LOC_CIVILIZATION_CAT_ADJECTIVE', 'CIVILIZATION_LEVEL_FULL_CIV', 30, 'ETHNICITY_EURO');
----------------------------------------------------------------------------------------------------------------------------
-- CityNames
----------------------------------------------------------------------------------------------------------------------------
INSERT INTO CityNames
(CivilizationType, CityName)
VALUES ('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_1'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_2'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_3'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_22'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_23'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_24'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_25'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_26'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_27'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_4'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_5'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_6'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_7'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_8'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_9'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_10'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_11'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_12'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_13'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_14'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_15'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_16'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_17'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_18'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_19'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_20'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_21'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_28'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_29'),
('CIVILIZATION_CAT', 'LOC_CITY_NAME_CAT_30');
----------------------------------------------------------------------------------------------------------------------------
-- CivilizationCitizenNames
----------------------------------------------------------------------------------------------------------------------------
INSERT INTO CivilizationCitizenNames
(CivilizationType, CitizenName, Female, Modern)
VALUES ('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MALE_1', 0, 0),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MALE_2', 0, 0),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MALE_3', 0, 0),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MALE_4', 0, 0),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MALE_5', 0, 0),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MALE_6', 0, 0),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MALE_7', 0, 0),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MALE_8', 0, 0),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MALE_9', 0, 0),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MALE_10', 0, 0),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_FEMALE_1', 1, 0),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_FEMALE_2', 1, 0),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_FEMALE_3', 1, 0),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_FEMALE_4', 1, 0),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_FEMALE_5', 1, 0),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_FEMALE_6', 1, 0),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_FEMALE_7', 1, 0),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_FEMALE_8', 1, 0),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_FEMALE_9', 1, 0),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_FEMALE_10', 1, 0),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MODERN_MALE_1', 0, 1),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MODERN_MALE_2', 0, 1),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MODERN_MALE_3', 0, 1),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MODERN_MALE_4', 0, 1),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MODERN_MALE_5', 0, 1),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MODERN_MALE_6', 0, 1),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MODERN_MALE_7', 0, 1),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MODERN_MALE_8', 0, 1),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MODERN_MALE_9', 0, 1),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MODERN_MALE_10', 0, 1),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MODERN_FEMALE_1', 1, 1),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MODERN_FEMALE_2', 1, 1),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MODERN_FEMALE_3', 1, 1),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MODERN_FEMALE_4', 1, 1),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MODERN_FEMALE_5', 1, 1),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MODERN_FEMALE_6', 1, 1),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MODERN_FEMALE_7', 1, 1),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MODERN_FEMALE_8', 1, 1),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MODERN_FEMALE_9', 1, 1),
('CIVILIZATION_CAT', 'LOC_CITIZEN_CAT_MODERN_FEMALE_10', 1, 1);
----------------------------------------------------------------------------------------------------------------------------
-- CivilizationInfo
----------------------------------------------------------------------------------------------------------------------------
INSERT INTO CivilizationInfo
(CivilizationType, Header, Caption, SortIndex)
VALUES ('CIVILIZATION_CAT', 'LOC_CIVINFO_LOCATION', 'LOC_CIVINFO_CAT_LOCATION', 10),
('CIVILIZATION_CAT', 'LOC_CIVINFO_SIZE', 'LOC_CIVINFO_CAT_SIZE', 20),
('CIVILIZATION_CAT', 'LOC_CIVINFO_POPULATION', 'LOC_CIVINFO_CAT_POPULATION', 30),
('CIVILIZATION_CAT', 'LOC_CIVINFO_CAPITAL', 'LOC_CIVINFO_CAT_CAPITAL', 40);
----------------------------------------------------------------------------------------------------------------------------
-- CivilizationLeaders
----------------------------------------------------------------------------------------------------------------------------
INSERT INTO CivilizationLeaders
(CivilizationType, LeaderType, CapitalName)
VALUES ('CIVILIZATION_CAT', 'LEADER_CAT_FRANCESC_MACIA', 'LOC_CITY_NAME_CAT_0');
--------------------------------------------------------------------------------------------------------------------------
-- BackGround Art
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO DiplomacyInfo
(Type, BackgroundImage)
VALUES ('LEADER_CAT_FRANCESC_MACIA', 'ART_LEADER_FRANCESC_MACIA.dds');
--==========================================================================================================================
-- LEADERS: TRAITS
--==========================================================================================================================
-- Types
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Types
(Type, Kind)
VALUES ('TRAIT_LEADER_CAT_FRANCESC_MACIA_FRUITFUL_ENGINEER', 'KIND_TRAIT'),
('TRAIT_LEADER_CAT_FRANCESC_MACIA_UNIT_ALMOGAVER', 'KIND_TRAIT'),
('TRAIT_LEADER_CAT_FRANCESC_MACIA_UNIT_MIQUELET', 'KIND_TRAIT');
--------------------------------------------------------------------------------------------------------------------------
-- Traits
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Traits
(TraitType, Name, Description)
VALUES ('TRAIT_LEADER_CAT_FRANCESC_MACIA_FRUITFUL_ENGINEER', 'LOC_TRAIT_LEADER_CAT_FRANCESC_MACIA_FRUITFUL_ENGINEER_NAME', 'LOC_TRAIT_LEADER_CAT_FRANCESC_MACIA_FRUITFUL_ENGINEER_DESCRIPTION'),
('TRAIT_LEADER_CAT_FRANCESC_MACIA_UNIT_ALMOGAVER', 'LOC_TRAIT_LEADER_CAT_FRANCESC_MACIA_UNIT_ALMOGAVER_NAME', 'LOC_TRAIT_LEADER_CAT_FRANCESC_MACIA_UNIT_ALMOGAVER_DESCRIPTION'),
('TRAIT_LEADER_CAT_FRANCESC_MACIA_UNIT_MIQUELET', 'LOC_TRAIT_LEADER_CAT_FRANCESC_MACIA_UNIT_MIQUELET_NAME', 'LOC_TRAIT_LEADER_CAT_FRANCESC_MACIA_UNIT_MIQUELET_DESCRIPTION');
--------------------------------------------------------------------------------------------------------------------------
-- TraitModifiers
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO TraitModifiers
(TraitType, ModifierId)
VALUES ('TRAIT_LEADER_CAT_FRANCESC_MACIA_FRUITFUL_ENGINEER', 'CAT_FRANCESC_MACIA_FRUITFUL_ENGINEER_FACTORY'),
('TRAIT_LEADER_CAT_FRANCESC_MACIA_UNIT_ALMOGAVER', 'CAT_FRANCESC_MACIA_DAMAGE_REDUCTION'),
('TRAIT_LEADER_CAT_FRANCESC_MACIA_UNIT_MIQUELET', 'CAT_FRANCESC_MACIA_DEFENDER');
--------------------------------------------------------------------------------------------------------------------------
-- Requirements
-------------------------------------------------------------------------------------------------------------------------
INSERT INTO Requirements
(RequirementId, RequirementType, Inverse)
VALUES ('MIQUELETS_IN_OWNER_TERRITORY', 'UNIT_IN_OWNER_TERRITORY_REQUIREMENT', 0);
--------------------------------------------------------------------------------------------------------------------------
-- RequirementSets
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO RequirementSets
(RequirementSetId, RequirementSetType)
VALUES ('MIQUELETS_PLOT_IS_OWNER_REQUIREMENTS', 'REQUIREMENTSET_TEST_ALL');
--------------------------------------------------------------------------------------------------------------------------
-- RequirementSetRequirements
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO RequirementSetRequirements
(RequirementSetId, RequirementId)
VALUES ('MIQUELETS_PLOT_IS_OWNER_REQUIREMENTS', 'MIQUELETS_IN_OWNER_TERRITORY');
--------------------------------------------------------------------------------------------------------------------------
-- Modifiers
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Modifiers
(ModifierId, ModifierType, SubjectRequirementSetId)
VALUES ('CAT_FRANCESC_MACIA_FRUITFUL_ENGINEER_FACTORY', 'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_YIELD_CHANGE', NULL),
('CAT_FRANCESC_MACIA_DAMAGE_REDUCTION', 'MODIFIER_UNIT_ADJUST_COMBAT_STRENGTH', 'MIQUELETS_PLOT_IS_OWNER_REQUIREMENTS'),
('CAT_FRANCESC_MACIA_DEFENDER', 'MODIFIER_UNIT_ADJUST_COMBAT_STRENGTH', 'MIQUELETS_PLOT_IS_OWNER_REQUIREMENTS');
--------------------------------------------------------------------------------------------------------------------------
-- ModifierArguments
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO ModifierArguments
(ModifierId, Name, Value)
VALUES ('CAT_FRANCESC_MACIA_FRUITFUL_ENGINEER_FACTORY', 'Amount', '2'),
('CAT_FRANCESC_MACIA_FRUITFUL_ENGINEER_FACTORY', 'BuildingType', 'BUILDING_FACTORY'),
('CAT_FRANCESC_MACIA_FRUITFUL_ENGINEER_FACTORY', 'YieldType', 'YIELD_PRODUCTION'),
('CAT_FRANCESC_MACIA_DAMAGE_REDUCTION', 'Amount', '10'),
('CAT_FRANCESC_MACIA_DEFENDER', 'Amount', '10');
-------------------------------------------------------------------------------------------------------------------------
--ModifierStrings
-------------------------------------------------------------------------------------------------------------------------
INSERT INTO ModifierStrings
(ModifierId, Context, Text)
VALUES ('CAT_FRANCESC_MACIA_DAMAGE_REDUCTION', 'Preview', 'LOC_TRAIT_LEADER_CAT_FRANCESC_MACIA_UNIT_ALMOGAVER_DESCRIPTION'),
('CAT_FRANCESC_MACIA_DEFENDER', 'Preview', 'LOC_TRAIT_LEADER_CAT_FRANCESC_MACIA_UNIT_MIQUELET_DESCRIPTION');
-------------------------------------------------------------------------------------------------------------------------
--==========================================================================================================================
-- CIVILIZATIONS: TRAITS
--==========================================================================================================================
-- Types
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Types
(Type, Kind)
VALUES ('TRAIT_CIVILIZATION_CAT_COMMERCIAL_TRADITION', 'KIND_TRAIT'),
('TRAIT_CIVILIZATION_CAT_PLAYGROUND_WORLD', 'KIND_TRAIT');
--------------------------------------------------------------------------------------------------------------------------
-- Traits
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Traits
(TraitType, Name, Description)
VALUES ('TRAIT_CIVILIZATION_CAT_COMMERCIAL_TRADITION', 'LOC_TRAIT_CIVILIZATION_CAT_COMMERCIAL_TRADITION_NAME', 'LOC_TRAIT_CIVILIZATION_CAT_COMMERCIAL_TRADITION_DESCRIPTION'),
('TRAIT_CIVILIZATION_CAT_PLAYGROUND_WORLD', 'LOC_TRAIT_CIVILIZATION_CAT_PLAYGROUND_WORLD_NAME', 'LOC_TRAIT_CIVILIZATION_CAT_PLAYGROUND_WORLD_DESCRIPTION');
--------------------------------------------------------------------------------------------------------------------------
-- TraitModifiers
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO TraitModifiers
(TraitType, ModifierId)
VALUES ('TRAIT_CIVILIZATION_CAT_COMMERCIAL_TRADITION', 'TRAIT_INTERNATIONAL_TRADE_GAIN_GOLD_CAT'),
('TRAIT_CIVILIZATION_CAT_COMMERCIAL_TRADITION', 'TRAIT_INCOMING_TRADE_GAIN_GOLD_CAT'),
('TRAIT_CIVILIZATION_CAT_COMMERCIAL_TRADITION', 'TRAIT_INCOMING_TRADE_OFFER_FOOD_CAT'),
('TRAIT_CIVILIZATION_CAT_PLAYGROUND_WORLD', 'TRAIT_DOUBLETOURISM_CAT');
--------------------------------------------------------------------------------------------------------------------------
-- Modifiers
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO Modifiers
(ModifierId, ModifierType)
VALUES ('TRAIT_INTERNATIONAL_TRADE_GAIN_GOLD_CAT', 'MODIFIER_PLAYER_CITIES_ADJUST_TRADE_ROUTE_YIELD_FROM_OTHERS'),
('TRAIT_INCOMING_TRADE_GAIN_GOLD_CAT', 'MODIFIER_PLAYER_CITIES_ADJUST_TRADE_ROUTE_YIELD_TO_OTHERS'),
('TRAIT_INCOMING_TRADE_OFFER_FOOD_CAT', 'MODIFIER_PLAYER_ADJUST_TRADE_ROUTE_YIELD_FOR_INTERNATIONAL'),
('TRAIT_DOUBLETOURISM_CAT', 'MODIFIER_PLAYER_CITIES_ADJUST_TOURISM');
--------------------------------------------------------------------------------------------------------------------------
-- ModifierArguments
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO ModifierArguments
(ModifierId, Name, Value)
VALUES ('TRAIT_INTERNATIONAL_TRADE_GAIN_GOLD_CAT', 'Amount', '2'),
('TRAIT_INTERNATIONAL_TRADE_GAIN_GOLD_CAT', 'Intercontinental', '0'),
('TRAIT_INTERNATIONAL_TRADE_GAIN_GOLD_CAT', 'YieldType', 'YIELD_GOLD'),
('TRAIT_INCOMING_TRADE_OFFER_FOOD_CAT', 'Amount', '2'),
('TRAIT_INCOMING_TRADE_OFFER_FOOD_CAT', 'YieldType', 'YIELD_FOOD'),
('TRAIT_INCOMING_TRADE_GAIN_GOLD_CAT', 'Amount', '2'),
('TRAIT_INCOMING_TRADE_GAIN_GOLD_CAT', 'YieldType', 'YIELD_GOLD'),
('TRAIT_DOUBLETOURISM_CAT', 'Modifier', '100'),
('TRAIT_DOUBLETOURISM_CAT', 'MinimumEra', 'ERA_MODERN');

--------------------------------------------------------------------------------------------------------------------------
-- LeaderTraits
--------------------------------------------------------------------------------------------------------------------------
INSERT INTO LeaderTraits
(LeaderType, TraitType)
VALUES ('LEADER_CAT_FRANCESC_MACIA', 'TRAIT_LEADER_CAT_FRANCESC_MACIA_FRUITFUL_ENGINEER'),
('LEADER_CAT_FRANCESC_MACIA', 'TRAIT_LEADER_CAT_FRANCESC_MACIA_UNIT_ALMOGAVER'),
('LEADER_CAT_FRANCESC_MACIA', 'TRAIT_LEADER_CAT_FRANCESC_MACIA_UNIT_MIQUELET');
----------------------------------------------------------------------------------------------------------------------------
-- CivilizationTraits
----------------------------------------------------------------------------------------------------------------------------
INSERT INTO CivilizationTraits
(TraitType, CivilizationType)
VALUES ('TRAIT_CIVILIZATION_CAT_COMMERCIAL_TRADITION', 'CIVILIZATION_CAT'),
('TRAIT_CIVILIZATION_CAT_PLAYGROUND_WORLD', 'CIVILIZATION_CAT');

Thanks a lot.