Looking for help on what I'm doing wrong with my Mod

[brickmod]

To put is shortly, I'm trying to make an OP version of the unique improvement, Kurgan. Below is what I've used to mod the improvement but I'm failing at getting it to give Housing and Amenity/Entertainment. The yield changes (food, prod, faith, and science) all work fine but I would like to have the Housing and Amenity too.

Spoiler Epic Kurgan :

-- EPIC_TRAIT_CIVILIZATION_IMPROVEMENT_KURGAN
INSERT OR REPLACE INTO Improvement_YieldChanges (ImprovementType, YieldType, YieldChange) VALUES ('IMPROVEMENT_KURGAN', 'YIELD_FOOD', 2);
INSERT OR REPLACE INTO Improvement_YieldChanges (ImprovementType, YieldType, YieldChange) VALUES ('IMPROVEMENT_KURGAN', 'YIELD_SCIENCE', 1);
INSERT OR REPLACE INTO Improvement_YieldChanges (ImprovementType, YieldType, YieldChange) VALUES ('IMPROVEMENT_KURGAN', 'YIELD_FAITH', 10);
INSERT OR REPLACE INTO Improvement_YieldChanges (ImprovementType, YieldType, YieldChange) VALUES ('IMPROVEMENT_KURGAN', 'YIELD_PRODUCTION', 4);
INSERT OR REPLACE INTO Improvement_YieldChanges (ImprovementType, YieldType, YieldChange) VALUES ('IMPROVEMENT_KURGAN', 'YIELD_GOLD', 15);
INSERT OR REPLACE INTO Modifiers (ModifierId, ModifierType, SubjectRequirementSetId)
VALUES ('KURGAN_AMENITY', 'MODIFIER_SINGLE_CITY_ADJUST_IMPROVEMENT_AMENITY', 'PLAYER_HAS_TECHNOLOGY_REQUIREMENTS'),
('KURGAN_HOUSING', 'MODIFIER_SINGLE_CITY_ADJUST_IMPROVEMENT_HOUSING', 'PLAYER_HAS_TECHNOLOGY_REQUIREMENTS');



INSERT OR REPLACE INTO ModifierArguments (ModifierId, Name, Value)
VALUES ('KURGAN_AMENITY', 'AMOUNT', 5),
('KURGAN_HOUSING', 'AMOUNT', 1);



INSERT OR REPLACE INTO ImprovementsModifiers (ImprovementType, ModifierId)
VALUE ('IMPROVEMENT_KURGAN', 'KURGAN_AMENITY'),
('IMPROVEMENT_KURGAN', 'KURGAN_HOUSING');


UPDATE Improvements SET Entertainment=5, Housing=1 WHERE ImprovementType='IMPROVEMENT_KURGAN';

 

[slushfund]

firstly, the table name is ImprovementModifiers, not ImprovementsModifiers. Secondly, it looks like you're missing an entry into DynamicModifiers. I suggest taking a look at this modifier flowchart by JNR, I've found it quite helpful.