Ulixes
Prince
- Joined
- May 2, 2010
- Messages
- 312
I'm trying to give Neighborhood District +1 Housing when adjacent to Industrial Zone and when adjacent to Harbor but the increase is more than 1. (at least 2 or 3, I'm still testing but it seem to work fine with the first and it increase with each neighborhood district placed)
Here's the code:
Can someone please help me figure out what I'm doing wrong?
(Also: is there someone who already did this, or something similar?)
Here's the code:
Code:
INSERT INTO Modifiers (ModifierId, ModifierType, RunOnce, Permanent, SubjectRequirementSetId ) VALUES
('U_NEIGHBORHOOD_INDUSTRIAL_ZONE_HOUSING', 'MODIFIER_PLAYER_DISTRICTS_ADJUST_HOUSING', 1, 1, 'U_PLOT_ADJACENT_TO_INDUSTRIAL_ZONE' ),
('U_NEIGHBORHOOD_HARBOR_HOUSING', 'MODIFIER_PLAYER_DISTRICTS_ADJUST_HOUSING', 1, 1, 'U_PLOT_ADJACENT_TO_HARBOR' );
INSERT INTO ModifierArguments (ModifierId, Name, Value ) VALUES
('U_NEIGHBORHOOD_INDUSTRIAL_ZONE_HOUSING', 'Amount', '1' ),
('U_NEIGHBORHOOD_HARBOR_HOUSING', 'Amount', '1' );
INSERT INTO DistrictModifiers (DistrictType, ModifierId ) VALUES
('DISTRICT_NEIGHBORHOOD', 'U_NEIGHBORHOOD_INDUSTRIAL_ZONE_HOUSING' ),
('DISTRICT_NEIGHBORHOOD', 'U_NEIGHBORHOOD_HARBOR_HOUSING' );
INSERT INTO RequirementSets (RequirementSetId, RequirementSetType ) VALUES
('U_PLOT_ADJACENT_TO_INDUSTRIAL_ZONE', 'REQUIREMENTSET_TEST_ALL' ),
('U_PLOT_ADJACENT_TO_HARBOR', 'REQUIREMENTSET_TEST_ALL' );
INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementID ) VALUES
('U_PLOT_ADJACENT_TO_INDUSTRIAL_ZONE', 'U_REQUIRES_PLOT_ADJACENT_TO_INDUSTRIAL_ZONE' ),
('U_PLOT_ADJACENT_TO_INDUSTRIAL_ZONE', 'REQUIRES_DISTRICT_IS_NEIGHBORHOOD' ),
('U_PLOT_ADJACENT_TO_HARBOR', 'U_REQUIRES_PLOT_ADJACENT_TO_HARBOR' ),
('U_PLOT_ADJACENT_TO_HARBOR', 'REQUIRES_DISTRICT_IS_NEIGHBORHOOD' );
INSERT INTO Requirements (RequirementId, RequirementType ) VALUES
('U_REQUIRES_PLOT_ADJACENT_TO_INDUSTRIAL_ZONE', 'REQUIREMENT_PLOT_ADJACENT_DISTRICT_TYPE_MATCHES' ),
('U_REQUIRES_PLOT_ADJACENT_TO_HARBOR', 'REQUIREMENT_PLOT_ADJACENT_DISTRICT_TYPE_MATCHES' );
INSERT INTO RequirementArguments (RequirementId, Name, Value ) VALUES
('U_REQUIRES_PLOT_ADJACENT_TO_INDUSTRIAL_ZONE', 'DistrictType', 'DISTRICT_INDUSTRIAL_ZONE' ),
('U_REQUIRES_PLOT_ADJACENT_TO_HARBOR', 'DistrictType', 'DISTRICT_HARBOR' );
Can someone please help me figure out what I'm doing wrong?
(Also: is there someone who already did this, or something similar?)
Last edited: