GloriousMadness
Chieftain
- Joined
- Feb 27, 2022
- Messages
- 3
Making a nomadic forest civ, and i was really hoping to do something for the civ UA like:
So I've narrowed the root cause (probably not the only root cause, mind) of the SQL down to the requirements section of the trait.
Have I managed to miss anything/mess up somewhere here?
Here is the rest of the trait coding:
I've got other parts of the UA to balance it out, but those work fine. It's getting the above to work that i'm having an issue with.Cities gain +1 Amenity per 4 Forest tiles workable by that City, and +1 Housing per 2 such tiles.
So I've narrowed the root cause (probably not the only root cause, mind) of the SQL down to the requirements section of the trait.
Have I managed to miss anything/mess up somewhere here?
Spoiler Requirement Code :
Code:
INSERT INTO Requirements
(RequirementId, RequirementType )
VALUES ('HARN_2_FOREST_REQUIREMENT', 'REQUIREMENT_COLLECTION_COUNT_ATLEAST' ),
('HARN_4_FOREST_REQUIREMENT', 'REQUIREMENT_COLLECTION_COUNT_ATLEAST' ),
('HARN_8_FOREST_REQUIREMENT', 'REQUIREMENT_COLLECTION_COUNT_ATLEAST' ),
('HARN_10_FOREST_REQUIREMENT', 'REQUIREMENT_COLLECTION_COUNT_ATLEAST' ),
('HARN_12_FOREST_REQUIREMENT', 'REQUIREMENT_COLLECTION_COUNT_ATLEAST' ),
('HARN_14_FOREST_REQUIREMENT', 'REQUIREMENT_COLLECTION_COUNT_ATLEAST' ),
('HARN_16_FOREST_REQUIREMENT', 'REQUIREMENT_COLLECTION_COUNT_ATLEAST' ),
('HARN_18_FOREST_REQUIREMENT', 'REQUIREMENT_COLLECTION_COUNT_ATLEAST' ),
('HARN_20_FOREST_REQUIREMENT', 'REQUIREMENT_COLLECTION_COUNT_ATLEAST' ),
('HARN_22_FOREST_REQUIREMENT', 'REQUIREMENT_COLLECTION_COUNT_ATLEAST' ),
('HARN_24_FOREST_REQUIREMENT', 'REQUIREMENT_COLLECTION_COUNT_ATLEAST' ),
('HARN_26_FOREST_REQUIREMENT', 'REQUIREMENT_COLLECTION_COUNT_ATLEAST' ),
('HARN_28_FOREST_REQUIREMENT', 'REQUIREMENT_COLLECTION_COUNT_ATLEAST' ),
('HARN_30_FOREST_REQUIREMENT', 'REQUIREMENT_COLLECTION_COUNT_ATLEAST' ),
('HARN_32_FOREST_REQUIREMENT', 'REQUIREMENT_COLLECTION_COUNT_ATLEAST' ),
('HARN_34_FOREST_REQUIREMENT', 'REQUIREMENT_COLLECTION_COUNT_ATLEAST' ),
('HARN_36_FOREST_REQUIREMENT', 'REQUIREMENT_COLLECTION_COUNT_ATLEAST' );
INSERT INTO RequirementSets
(RequirementSetId, RequirementSetType )
VALUES ('REQSET_PLOT_HAS_FOREST', 'REQUIREMENTSET_TEST_ALL' ),
('HARN_2_FOREST', 'REQUIREMENTSET_TEST_ALL' ),
('HARN_4_FOREST', 'REQUIREMENTSET_TEST_ALL' ),
('HARN_6_FOREST', 'REQUIREMENTSET_TEST_ALL' ),
('HARN_8_FOREST', 'REQUIREMENTSET_TEST_ALL' ),
('HARN_10_FOREST', 'REQUIREMENTSET_TEST_ALL' ),
('HARN_12_FOREST', 'REQUIREMENTSET_TEST_ALL' ),
('HARN_14_FOREST', 'REQUIREMENTSET_TEST_ALL' ),
('HARN_16_FOREST', 'REQUIREMENTSET_TEST_ALL' ),
('HARN_18_FOREST', 'REQUIREMENTSET_TEST_ALL' ),
('HARN_20_FOREST', 'REQUIREMENTSET_TEST_ALL' ),
('HARN_20_FOREST', 'REQUIREMENTSET_TEST_ALL' ),
('HARN_24_FOREST', 'REQUIREMENTSET_TEST_ALL' ),
('HARN_26_FOREST', 'REQUIREMENTSET_TEST_ALL' ),
('HARN_28_FOREST', 'REQUIREMENTSET_TEST_ALL' ),
('HARN_30_FOREST', 'REQUIREMENTSET_TEST_ALL' ),
('HARN_32_FOREST', 'REQUIREMENTSET_TEST_ALL' ),
('HARN_34_FOREST', 'REQUIREMENTSET_TEST_ALL' ),
('HARN_36_FOREST', 'REQUIREMENTSET_TEST_ALL' );
INSERT INTO RequirementSetRequirements
(RequirementSetId, RequirementId )
VALUES ('REQSET_PLOT_HAS_FOREST', 'PLOT_IS_FOREST_REQUIREMENT' ),
('HARN_2_FOREST', 'HARN_2_FOREST_REQUIREMENT' ),
('HARN_4_FOREST', 'HARN_4_FOREST_REQUIREMENT' ),
('HARN_6_FOREST', 'HARN_6_FOREST_REQUIREMENT' ),
('HARN_8_FOREST', 'HARN_8_FOREST_REQUIREMENT' ),
('HARN_10_FOREST', 'HARN_10_FOREST_REQUIREMENT' ),
('HARN_12_FOREST', 'HARN_12_FOREST_REQUIREMENT' ),
('HARN_14_FOREST', 'HARN_14_FOREST_REQUIREMENT' ),
('HARN_16_FOREST', 'HARN_16_FOREST_REQUIREMENT' ),
('HARN_18_FOREST', 'HARN_18_FOREST_REQUIREMENT' ),
('HARN_20_FOREST', 'HARN_20_FOREST_REQUIREMENT' ),
('HARN_22_FOREST', 'HARN_22_FOREST_REQUIREMENT' ),
('HARN_24_FOREST', 'HARN_24_FOREST_REQUIREMENT' ),
('HARN_26_FOREST', 'HARN_26_FOREST_REQUIREMENT' ),
('HARN_28_FOREST', 'HARN_28_FOREST_REQUIREMENT' ),
('HARN_30_FOREST', 'HARN_30_FOREST_REQUIREMENT' ),
('HARN_32_FOREST', 'HARN_32_FOREST_REQUIREMENT' ),
('HARN_34_FOREST', 'HARN_34_FOREST_REQUIREMENT' ),
('HARN_36_FOREST', 'HARN_36_FOREST_REQUIREMENT' );
INSERT INTO RequirementArguments
(RequirementId, Name, Value )
VALUES ('HARN_2_FOREST_REQUIREMENT', 'CollectionType', 'COLLECTION_CITY_PLOT_YIELDS' ),
('HARN_2_FOREST_REQUIREMENT', 'Count', 2 ),
('HARN_2_FOREST_REQUIREMENT', 'RequirementSetId', 'REQSET_PLOT_HAS_FOREST' ),
('HARN_4_FOREST_REQUIREMENT', 'CollectionType', 'COLLECTION_CITY_PLOT_YIELDS' ),
('HARN_4_FOREST_REQUIREMENT', 'Count', 4 ),
('HARN_4_FOREST_REQUIREMENT', 'RequirementSetId', 'REQSET_PLOT_HAS_FOREST' ),
('HARN_6_FOREST_REQUIREMENT', 'CollectionType', 'COLLECTION_CITY_PLOT_YIELDS' ),
('HARN_6_FOREST_REQUIREMENT', 'Count', 6 ),
('HARN_6_FOREST_REQUIREMENT', 'RequirementSetId', 'REQSET_PLOT_HAS_FOREST' ),
('HARN_8_FOREST_REQUIREMENT', 'CollectionType', 'COLLECTION_CITY_PLOT_YIELDS' ),
('HARN_8_FOREST_REQUIREMENT', 'Count', 8 ),
('HARN_8_FOREST_REQUIREMENT', 'RequirementSetId', 'REQSET_PLOT_HAS_FOREST' ),
('HARN_10_FOREST_REQUIREMENT', 'CollectionType', 'COLLECTION_CITY_PLOT_YIELDS' ),
('HARN_10_FOREST_REQUIREMENT', 'Count', 10 ),
('HARN_10_FOREST_REQUIREMENT', 'RequirementSetId', 'REQSET_PLOT_HAS_FOREST' ),
('HARN_12_FOREST_REQUIREMENT', 'CollectionType', 'COLLECTION_CITY_PLOT_YIELDS' ),
('HARN_12_FOREST_REQUIREMENT', 'Count', 12 ),
('HARN_12_FOREST_REQUIREMENT', 'RequirementSetId', 'REQSET_PLOT_HAS_FOREST' ),
('HARN_14_FOREST_REQUIREMENT', 'CollectionType', 'COLLECTION_CITY_PLOT_YIELDS' ),
('HARN_14_FOREST_REQUIREMENT', 'Count', 14 ),
('HARN_14_FOREST_REQUIREMENT', 'RequirementSetId', 'REQSET_PLOT_HAS_FOREST' ),
('HARN_16_FOREST_REQUIREMENT', 'CollectionType', 'COLLECTION_CITY_PLOT_YIELDS' ),
('HARN_16_FOREST_REQUIREMENT', 'Count', 16 ),
('HARN_16_FOREST_REQUIREMENT', 'RequirementSetId', 'REQSET_PLOT_HAS_FOREST' ),
('HARN_18_FOREST_REQUIREMENT', 'CollectionType', 'COLLECTION_CITY_PLOT_YIELDS' ),
('HARN_18_FOREST_REQUIREMENT', 'Count', 18 ),
('HARN_18_FOREST_REQUIREMENT', 'RequirementSetId', 'REQSET_PLOT_HAS_FOREST' ),
('HARN_20_FOREST_REQUIREMENT', 'CollectionType', 'COLLECTION_CITY_PLOT_YIELDS' ),
('HARN_20_FOREST_REQUIREMENT', 'Count', 20 ),
('HARN_20_FOREST_REQUIREMENT', 'RequirementSetId', 'REQSET_PLOT_HAS_FOREST' ),
('HARN_22_FOREST_REQUIREMENT', 'CollectionType', 'COLLECTION_CITY_PLOT_YIELDS' ),
('HARN_22_FOREST_REQUIREMENT', 'Count', 22 ),
('HARN_22_FOREST_REQUIREMENT', 'RequirementSetId', 'REQSET_PLOT_HAS_FOREST' ),
('HARN_24_FOREST_REQUIREMENT', 'CollectionType', 'COLLECTION_CITY_PLOT_YIELDS' ),
('HARN_24_FOREST_REQUIREMENT', 'Count', 24 ),
('HARN_24_FOREST_REQUIREMENT', 'RequirementSetId', 'REQSET_PLOT_HAS_FOREST' ),
('HARN_26_FOREST_REQUIREMENT', 'CollectionType', 'COLLECTION_CITY_PLOT_YIELDS' ),
('HARN_26_FOREST_REQUIREMENT', 'Count', 26 ),
('HARN_26_FOREST_REQUIREMENT', 'RequirementSetId', 'REQSET_PLOT_HAS_FOREST' ),
('HARN_28_FOREST_REQUIREMENT', 'CollectionType', 'COLLECTION_CITY_PLOT_YIELDS' ),
('HARN_28_FOREST_REQUIREMENT', 'Count', 28 ),
('HARN_28_FOREST_REQUIREMENT', 'RequirementSetId', 'REQSET_PLOT_HAS_FOREST' ),
('HARN_30_FOREST_REQUIREMENT', 'CollectionType', 'COLLECTION_CITY_PLOT_YIELDS' ),
('HARN_30_FOREST_REQUIREMENT', 'Count', 30 ),
('HARN_30_FOREST_REQUIREMENT', 'RequirementSetId', 'REQSET_PLOT_HAS_FOREST' ),
('HARN_32_FOREST_REQUIREMENT', 'CollectionType', 'COLLECTION_CITY_PLOT_YIELDS' ),
('HARN_32_FOREST_REQUIREMENT', 'Count', 32 ),
('HARN_32_FOREST_REQUIREMENT', 'RequirementSetId', 'REQSET_PLOT_HAS_FOREST' ),
('HARN_34_FOREST_REQUIREMENT', 'CollectionType', 'COLLECTION_CITY_PLOT_YIELDS' ),
('HARN_34_FOREST_REQUIREMENT', 'Count', 34 ),
('HARN_34_FOREST_REQUIREMENT', 'RequirementSetId', 'REQSET_PLOT_HAS_FOREST' ),
('HARN_36_FOREST_REQUIREMENT', 'CollectionType', 'COLLECTION_CITY_PLOT_YIELDS' ),
('HARN_36_FOREST_REQUIREMENT', 'Count', 36 ),
('HARN_36_FOREST_REQUIREMENT', 'RequirementSetId', 'REQSET_PLOT_HAS_FOREST' );
Here is the rest of the trait coding:
Spoiler Rest of Trait :
Code:
INSERT INTO Types
(Type, Kind )
VALUES ('TRAIT_CIVILIZATION_GUVAR', 'KIND_TRAIT' );
INSERT INTO Traits
(TraitType, Name, Description )
VALUES ('TRAIT_CIVILIZATION_GUVAR', 'LOC_TRAIT_CIVILIZATION_GUVAR_NAME', 'LOC_TRAIT_CIVILIZATION_GUVAR_DESCRIPTION' );
INSERT INTO ExcludedDistricts
(DistrictType, TraitType )
VALUES ('DISTRICT_NEIGHBORHOOD', 'TRAIT_CIVILIZATION_GUVAR' );
INSERT INTO CivilizationTraits
(CivilizationType, TraitType )
VALUES ('CIVILIZATION_GM_HARNDON', 'TRAIT_CIVILIZATION_GUVAR' );
INSERT INTO TraitModifiers
(TraitType, ModifierId )
VALUES ('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_FOREST_GIVE_FOOD' ),
('TRAIT_CIVILIZATION_GUVAR', 'TRAIT_MAORI_PREVENT_HARVEST' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_2_FOREST_GIVE_HOUSING' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_4_FOREST_GIVE_HOUSING' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_6_FOREST_GIVE_HOUSING' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_8_FOREST_GIVE_HOUSING' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_10_FOREST_GIVE_HOUSING' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_12_FOREST_GIVE_HOUSING' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_14_FOREST_GIVE_HOUSING' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_16_FOREST_GIVE_HOUSING' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_18_FOREST_GIVE_HOUSING' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_20_FOREST_GIVE_HOUSING' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_22_FOREST_GIVE_HOUSING' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_24_FOREST_GIVE_HOUSING' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_26_FOREST_GIVE_HOUSING' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_28_FOREST_GIVE_HOUSING' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_30_FOREST_GIVE_HOUSING' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_32_FOREST_GIVE_HOUSING' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_34_FOREST_GIVE_HOUSING' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_36_FOREST_GIVE_HOUSING' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_4_FOREST_GIVE_AMENITY' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_8_FOREST_GIVE_AMENITY' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_12_FOREST_GIVE_AMENITY' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_16_FOREST_GIVE_AMENITY' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_20_FOREST_GIVE_AMENITY' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR-24_FOREST_GIVE_AMENITY' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_28_FOREST_GIVE_AMENITY' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_32_FOREST_GIVE_AMENITY' ),
('TRAIT_CIVILIZATION_GUVAR', 'MODIFIER_GUVAR_36_FOREST_GIVE_AMENITY' );
INSERT INTO Modifiers
(ModifierId, ModifierType, SubjectRequirementSetId )
VALUES ('MODIFIER_GUVAR_FOREST_GIVE_FOOD', 'MODIFIER_PLAYER_ADJUST_PLOT_YIELD', 'REQSET_PLOT_HAS_FOREST' ),
('MODIFIER_GUVAR_2_FOREST_GIVE_HOUSING', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_2_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_2', 'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_HOUSING', null ),
('MODIFIER_GUVAR_4_FOREST_GIVE_HOUSING', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_4_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_4', 'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_HOUSING', null ),
('MODIFIER_GUVAR_6_FOREST_GIVE_HOUSING', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_6_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_6', 'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_HOUSING', null ),
('MODIFIER_GUVAR_8_FOREST_GIVE_HOUSING', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_8_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_8', 'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_HOUSING', null ),
('MODIFIER_GUVAR_10_FOREST_GIVE_HOUSING', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_10_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_10', 'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_HOUSING', null ),
('MODIFIER_GUVAR_12_FOREST_GIVE_HOUSING', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_12_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_12', 'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_HOUSING', null ),
('MODIFIER_GUVAR_14_FOREST_GIVE_HOUSING', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_14_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_14', 'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_HOUSING', null ),
('MODIFIER_GUVAR_16_FOREST_GIVE_HOUSING', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_16_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_16', 'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_HOUSING', null ),
('MODIFIER_GUVAR_18_FOREST_GIVE_HOUSING', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_18_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_18', 'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_HOUSING', null ),
('MODIFIER_GUVAR_20_FOREST_GIVE_HOUSING', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_20_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_20', 'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_HOUSING', null ),
('MODIFIER_GUVAR_22_FOREST_GIVE_HOUSING', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_22_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_22', 'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_HOUSING', null ),
('MODIFIER_GUVAR_24_FOREST_GIVE_HOUSING', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_24_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_24', 'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_HOUSING', null ),
('MODIFIER_GUVAR_26_FOREST_GIVE_HOUSING', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_26_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_26', 'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_HOUSING', null ),
('MODIFIER_GUVAR_28_FOREST_GIVE_HOUSING', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_28_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_28', 'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_HOUSING', null ),
('MODIFIER_GUVAR_30_FOREST_GIVE_HOUSING', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_30_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_30', 'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_HOUSING', null ),
('MODIFIER_GUVAR_32_FOREST_GIVE_HOUSING', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_32_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_32', 'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_HOUSING', null ),
('MODIFIER_GUVAR_34_FOREST_GIVE_HOUSING', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_34_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_34', 'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_HOUSING', null ),
('MODIFIER_GUVAR_36_FOREST_GIVE_HOUSING', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_36_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_36', 'MODIFIER_PLAYER_CITIES_ADJUST_BUILDING_HOUSING', null ),
('MODIFIER_GUVAR_4_FOREST_GIVE_AMENITY', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_4_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_AMENITY_4', 'MODIFIER_PLAYER_CITIES_ADJUST_TRAIT_AMENITY', null ),
('MODIFIER_GUVAR_8_FOREST_GIVE_AMENITY', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_8_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_AMENITY_8', 'MODIFIER_PLAYER_CITIES_ADJUST_TRAIT_AMENITY', null ),
('MODIFIER_GUVAR_12_FOREST_GIVE_AMENITY', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_12_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_AMENITY_12', 'MODIFIER_PLAYER_CITIES_ADJUST_TRAIT_AMENITY', null ),
('MODIFIER_GUVAR_16_FOREST_GIVE_AMENITY', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_16_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_AMENITY_16', 'MODIFIER_PLAYER_CITIES_ADJUST_TRAIT_AMENITY', null ),
('MODIFIER_GUVAR_20_FOREST_GIVE_AMENITY', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_20_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_AMENITY_20', 'MODIFIER_PLAYER_CITIES_ADJUST_TRAIT_AMENITY', null ),
('MODIFIER_GUVAR_24_FOREST_GIVE_AMENITY', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_24_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_AMENITY_24', 'MODIFIER_PLAYER_CITIES_ADJUST_TRAIT_AMENITY', null ),
('MODIFIER_GUVAR_28_FOREST_GIVE_AMENITY', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_28_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_AMENITY_28', 'MODIFIER_PLAYER_CITIES_ADJUST_TRAIT_AMENITY', null ),
('MODIFIER_GUVAR_32_FOREST_GIVE_AMENITY', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_32_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_AMENITY_32', 'MODIFIER_PLAYER_CITIES_ADJUST_TRAIT_AMENITY', null ),
('MODIFIER_GUVAR_36_FOREST_GIVE_AMENITY', 'MODIFIER_PLAYER_CITIES_ATTACH_MODIFIER', 'HARN_36_FOREST' ),
('MODIFIER_GUVAR_FOREST_GIVE_AMENITY_36', 'MODIFIER_PLAYER_CITIES_ADJUST_TRAIT_AMENITY', null );
INSERT INTO ModifierArguments
(ModifierId, Name, Value )
VALUES ('MODIFIER_GUVAR_FOREST_GIVE_FOOD', 'YieldType', 'YIELD_FOOD' ),
('MODIFIER_GUVAR_FOREST_GIVE_FOOD', 'Amount', 1 ),
('MODIFIER_GUVAR_2_FOREST_GIVE_HOUSING', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_HOUSING_2' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_2', 'Amount', 1 ),
('MODIFIER_GUVAR_4_FOREST_GIVE_HOUSING', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_HOUSING_4' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_4', 'Amount', 2 ),
('MODIFIER_GUVAR_6_FOREST_GIVE_HOUSING', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_HOUSING_6' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_6', 'Amount', 3 ),
('MODIFIER_GUVAR_8_FOREST_GIVE_HOUSING', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_HOUSING_8' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_8', 'Amount', 4 ),
('MODIFIER_GUVAR_10_FOREST_GIVE_HOUSING', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_HOUSING_10' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_10', 'Amount', 5 ),
('MODIFIER_GUVAR_12_FOREST_GIVE_HOUSING', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_HOUSING_12' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_12', 'Amount', 6 ),
('MODIFIER_GUVAR_14_FOREST_GIVE_HOUSING', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_HOUSING_14' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_14', 'Amount', 7 ),
('MODIFIER_GUVAR_16_FOREST_GIVE_HOUSING', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_HOUSING_16' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_16', 'Amount', 8 ),
('MODIFIER_GUVAR_18_FOREST_GIVE_HOUSING', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_HOUSING_18' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_18', 'Amount', 9 ),
('MODIFIER_GUVAR_20_FOREST_GIVE_HOUSING', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_HOUSING_20' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_20', 'Amount', 10 ),
('MODIFIER_GUVAR_22_FOREST_GIVE_HOUSING', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_HOUSING_22' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_22', 'Amount', 11 ),
('MODIFIER_GUVAR_24_FOREST_GIVE_HOUSING', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_HOUSING_24' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_24', 'Amount', 12 ),
('MODIFIER_GUVAR_26_FOREST_GIVE_HOUSING', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_HOUSING_26' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_26', 'Amount', 13 ),
('MODIFIER_GUVAR_28_FOREST_GIVE_HOUSING', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_HOUSING_28' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_28', 'Amount', 14 ),
('MODIFIER_GUVAR_30_FOREST_GIVE_HOUSING', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_HOUSING_30' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_30', 'Amount', 15 ),
('MODIFIER_GUVAR_32_FOREST_GIVE_HOUSING', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_HOUSING_32' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_32', 'Amount', 16 ),
('MODIFIER_GUVAR_34_FOREST_GIVE_HOUSING', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_HOUSING_34' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_34', 'Amount', 17 ),
('MODIFIER_GUVAR_36_FOREST_GIVE_HOUSING', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_HOUSING_36' ),
('MODIFIER_GUVAR_FOREST_GIVE_HOUSING_36', 'Amount', 18 ),
('MODIFIER_GUVAR_4_FOREST_GIVE_AMENITY', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_AMENITY_36' ),
('MODIFIER_GUVAR_FOREST_GIVE_AMENITY_4', 'Amount', 1 ),
('MODIFIER_GUVAR_8_FOREST_GIVE_AMENITY', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_AMENITY_36' ),
('MODIFIER_GUVAR_FOREST_GIVE_AMENITY_8', 'Amount', 2 ),
('MODIFIER_GUVAR_12_FOREST_GIVE_AMENITY', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_AMENITY_36' ),
('MODIFIER_GUVAR_FOREST_GIVE_AMENITY_12', 'Amount', 3 ),
('MODIFIER_GUVAR_16_FOREST_GIVE_AMENITY', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_AMENITY_36' ),
('MODIFIER_GUVAR_FOREST_GIVE_AMENITY_16', 'Amount', 4 ),
('MODIFIER_GUVAR_20_FOREST_GIVE_AMENITY', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_AMENITY_36' ),
('MODIFIER_GUVAR_FOREST_GIVE_AMENITY_20', 'Amount', 5 ),
('MODIFIER_GUVAR_24_FOREST_GIVE_AMENITY', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_AMENITY_36' ),
('MODIFIER_GUVAR_FOREST_GIVE_AMENITY_24', 'Amount', 6 ),
('MODIFIER_GUVAR_28_FOREST_GIVE_AMENITY', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_AMENITY_36' ),
('MODIFIER_GUVAR_FOREST_GIVE_AMENITY_28', 'Amount', 7 ),
('MODIFIER_GUVAR_32_FOREST_GIVE_AMENITY', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_AMENITY_36' ),
('MODIFIER_GUVAR_FOREST_GIVE_AMENITY_32', 'Amount', 8 ),
('MODIFIER_GUVAR_36_FOREST_GIVE_AMENITY', 'ModifierId', 'MODIFIER_GUVAR_FOREST_GIVE_AMENITY_36' ),
('MODIFIER_GUVAR_FOREST_GIVE_AMENITY_36', 'Amount', 9 );