Improved Neighborhoods 2017-12-01

[fodazd]

fodazd submitted a new resource:

Improved Neighborhoods - Neighborhoods get bonus yields based on buildings in the city.

Neighborhoods get bonus yields based on buildings in the city.

The following buildings increase the yield of Neighborhoods in the same city, in addition to their normal effects:
-> Research Lab (Campus): +1 Science per Neighborhood
-> Worship Building (Holy Site): +1 Faith per Neighborhood
-> Broadcast Center (Threatre Square): +1 Culture per Neighborhood
-> Military Academy (Encampment): +1 Production per Neighborhood
-> Seaport (Harbor): +1 Gold per Neighborhood
-> Stock Exchange...

Read more about this resource...

 

[fodazd]

INSERT INTO DistrictModifiers (DistrictType, ModifierId) VALUES ('DISTRICT_NEIGHBORHOOD', 'NEIGHBORHOOD_SCIENCE_FROM_RESEARCH_LAB');
INSERT INTO DistrictModifiers (DistrictType, ModifierId) VALUES ('DISTRICT_MBANZA', 'NEIGHBORHOOD_SCIENCE_FROM_RESEARCH_LAB');
INSERT INTO Modifiers (ModifierId, ModifierType, RunOnce, Permanent, SubjectRequirementSetId) VALUES ('NEIGHBORHOOD_SCIENCE_FROM_RESEARCH_LAB', 'MODIFIER_SINGLE_CITY_ADJUST_YIELD_CHANGE', '0', '0', 'CITY_HAS_RESEARCH_LAB_REQUIREMENTS');
INSERT INTO ModifierArguments (ModifierId, Name, Value) VALUES ('NEIGHBORHOOD_SCIENCE_FROM_RESEARCH_LAB', 'YieldType', 'YIELD_SCIENCE'), ('NEIGHBORHOOD_SCIENCE_FROM_RESEARCH_LAB', 'Amount', '1');

INSERT INTO RequirementSets (RequirementSetId, RequirementSetType) VALUES ('CITY_HAS_RESEARCH_LAB_REQUIREMENTS', 'REQUIREMENTSET_TEST_ALL');
INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES ('CITY_HAS_RESEARCH_LAB_REQUIREMENTS', 'REQUIRES_CITY_HAS_RESEARCH_LAB');
INSERT INTO Requirements (RequirementId, RequirementType) VALUES ('REQUIRES_CITY_HAS_RESEARCH_LAB', 'REQUIREMENT_CITY_HAS_BUILDING');
INSERT INTO RequirementArguments (RequirementId, Name, Value) VALUES ('REQUIRES_CITY_HAS_RESEARCH_LAB', 'BuildingType', 'BUILDING_RESEARCH_LAB');



INSERT INTO DistrictModifiers (DistrictType, ModifierId) VALUES ('DISTRICT_NEIGHBORHOOD', 'NEIGHBORHOOD_FAITH_FROM_WORSHIP_BUILDING');
INSERT INTO DistrictModifiers (DistrictType, ModifierId) VALUES ('DISTRICT_MBANZA', 'NEIGHBORHOOD_FAITH_FROM_WORSHIP_BUILDING');
INSERT INTO Modifiers (ModifierId, ModifierType, RunOnce, Permanent, SubjectRequirementSetId) VALUES ('NEIGHBORHOOD_FAITH_FROM_WORSHIP_BUILDING', 'MODIFIER_SINGLE_CITY_ADJUST_YIELD_CHANGE', '0', '0', 'CITY_HAS_WORSHIP_BUILDING_REQUIREMENTS');
INSERT INTO ModifierArguments (ModifierId, Name, Value) VALUES ('NEIGHBORHOOD_FAITH_FROM_WORSHIP_BUILDING', 'YieldType', 'YIELD_FAITH'), ('NEIGHBORHOOD_FAITH_FROM_WORSHIP_BUILDING', 'Amount', '1');

INSERT INTO RequirementSets (RequirementSetId, RequirementSetType) VALUES ('CITY_HAS_WORSHIP_BUILDING_REQUIREMENTS', 'REQUIREMENTSET_TEST_ANY');

INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES ('CITY_HAS_WORSHIP_BUILDING_REQUIREMENTS', 'REQUIRES_CITY_HAS_CATHEDRAL');
INSERT INTO Requirements (RequirementId, RequirementType) VALUES ('REQUIRES_CITY_HAS_CATHEDRAL', 'REQUIREMENT_CITY_HAS_BUILDING');
INSERT INTO RequirementArguments (RequirementId, Name, Value) VALUES ('REQUIRES_CITY_HAS_CATHEDRAL', 'BuildingType', 'BUILDING_CATHEDRAL');

INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES ('CITY_HAS_WORSHIP_BUILDING_REQUIREMENTS', 'REQUIRES_CITY_HAS_DAR_E_MEHR');
INSERT INTO Requirements (RequirementId, RequirementType) VALUES ('REQUIRES_CITY_HAS_DAR_E_MEHR', 'REQUIREMENT_CITY_HAS_BUILDING');
INSERT INTO RequirementArguments (RequirementId, Name, Value) VALUES ('REQUIRES_CITY_HAS_DAR_E_MEHR', 'BuildingType', 'BUILDING_DAR_E_MEHR');

INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES ('CITY_HAS_WORSHIP_BUILDING_REQUIREMENTS', 'REQUIRES_CITY_HAS_GURDWARA');
INSERT INTO Requirements (RequirementId, RequirementType) VALUES ('REQUIRES_CITY_HAS_GURDWARA', 'REQUIREMENT_CITY_HAS_BUILDING');
INSERT INTO RequirementArguments (RequirementId, Name, Value) VALUES ('REQUIRES_CITY_HAS_GURDWARA', 'BuildingType', 'BUILDING_GURDWARA');

INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES ('CITY_HAS_WORSHIP_BUILDING_REQUIREMENTS', 'REQUIRES_CITY_HAS_MEETING_HOUSE');
INSERT INTO Requirements (RequirementId, RequirementType) VALUES ('REQUIRES_CITY_HAS_MEETING_HOUSE', 'REQUIREMENT_CITY_HAS_BUILDING');
INSERT INTO RequirementArguments (RequirementId, Name, Value) VALUES ('REQUIRES_CITY_HAS_MEETING_HOUSE', 'BuildingType', 'BUILDING_MEETING_HOUSE');

INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES ('CITY_HAS_WORSHIP_BUILDING_REQUIREMENTS', 'REQUIRES_CITY_HAS_MOSQUE');
INSERT INTO Requirements (RequirementId, RequirementType) VALUES ('REQUIRES_CITY_HAS_MOSQUE', 'REQUIREMENT_CITY_HAS_BUILDING');
INSERT INTO RequirementArguments (RequirementId, Name, Value) VALUES ('REQUIRES_CITY_HAS_MOSQUE', 'BuildingType', 'BUILDING_MOSQUE');

INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES ('CITY_HAS_WORSHIP_BUILDING_REQUIREMENTS', 'REQUIRES_CITY_HAS_PAGODA');
INSERT INTO Requirements (RequirementId, RequirementType) VALUES ('REQUIRES_CITY_HAS_PAGODA', 'REQUIREMENT_CITY_HAS_BUILDING');
INSERT INTO RequirementArguments (RequirementId, Name, Value) VALUES ('REQUIRES_CITY_HAS_PAGODA', 'BuildingType', 'BUILDING_PAGODA');

INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES ('CITY_HAS_WORSHIP_BUILDING_REQUIREMENTS', 'REQUIRES_CITY_HAS_STUPA');
INSERT INTO Requirements (RequirementId, RequirementType) VALUES ('REQUIRES_CITY_HAS_STUPA', 'REQUIREMENT_CITY_HAS_BUILDING');
INSERT INTO RequirementArguments (RequirementId, Name, Value) VALUES ('REQUIRES_CITY_HAS_STUPA', 'BuildingType', 'BUILDING_STUPA');

INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES ('CITY_HAS_WORSHIP_BUILDING_REQUIREMENTS', 'REQUIRES_CITY_HAS_SYNAGOGUE');
INSERT INTO Requirements (RequirementId, RequirementType) VALUES ('REQUIRES_CITY_HAS_SYNAGOGUE', 'REQUIREMENT_CITY_HAS_BUILDING');
INSERT INTO RequirementArguments (RequirementId, Name, Value) VALUES ('REQUIRES_CITY_HAS_SYNAGOGUE', 'BuildingType', 'BUILDING_SYNAGOGUE');

INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES ('CITY_HAS_WORSHIP_BUILDING_REQUIREMENTS', 'REQUIRES_CITY_HAS_WAT');
INSERT INTO Requirements (RequirementId, RequirementType) VALUES ('REQUIRES_CITY_HAS_WAT', 'REQUIREMENT_CITY_HAS_BUILDING');
INSERT INTO RequirementArguments (RequirementId, Name, Value) VALUES ('REQUIRES_CITY_HAS_WAT', 'BuildingType', 'BUILDING_WAT');



INSERT INTO DistrictModifiers (DistrictType, ModifierId) VALUES ('DISTRICT_NEIGHBORHOOD', 'NEIGHBORHOOD_CULTURE_FROM_BROADCAST_CENTER');
INSERT INTO DistrictModifiers (DistrictType, ModifierId) VALUES ('DISTRICT_MBANZA', 'NEIGHBORHOOD_CULTURE_FROM_BROADCAST_CENTER');
INSERT INTO Modifiers (ModifierId, ModifierType, RunOnce, Permanent, SubjectRequirementSetId) VALUES ('NEIGHBORHOOD_CULTURE_FROM_BROADCAST_CENTER', 'MODIFIER_SINGLE_CITY_ADJUST_YIELD_CHANGE', '0', '0', 'CITY_HAS_BROADCAST_CENTER_REQUIREMENTS');
INSERT INTO ModifierArguments (ModifierId, Name, Value) VALUES ('NEIGHBORHOOD_CULTURE_FROM_BROADCAST_CENTER', 'YieldType', 'YIELD_CULTURE'), ('NEIGHBORHOOD_CULTURE_FROM_BROADCAST_CENTER', 'Amount', '1');

INSERT INTO RequirementSets (RequirementSetId, RequirementSetType) VALUES ('CITY_HAS_BROADCAST_CENTER_REQUIREMENTS', 'REQUIREMENTSET_TEST_ANY');

INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES ('CITY_HAS_BROADCAST_CENTER_REQUIREMENTS', 'REQUIRES_CITY_HAS_BROADCAST_CENTER');
INSERT INTO Requirements (RequirementId, RequirementType) VALUES ('REQUIRES_CITY_HAS_BROADCAST_CENTER', 'REQUIREMENT_CITY_HAS_BUILDING');
INSERT INTO RequirementArguments (RequirementId, Name, Value) VALUES ('REQUIRES_CITY_HAS_BROADCAST_CENTER', 'BuildingType', 'BUILDING_BROADCAST_CENTER');

INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES ('CITY_HAS_BROADCAST_CENTER_REQUIREMENTS', 'REQUIRES_CITY_HAS_FILM_STUDIO');
INSERT INTO Requirements (RequirementId, RequirementType) VALUES ('REQUIRES_CITY_HAS_FILM_STUDIO', 'REQUIREMENT_CITY_HAS_BUILDING');
INSERT INTO RequirementArguments (RequirementId, Name, Value) VALUES ('REQUIRES_CITY_HAS_FILM_STUDIO', 'BuildingType', 'BUILDING_FILM_STUDIO');



INSERT INTO DistrictModifiers (DistrictType, ModifierId) VALUES ('DISTRICT_NEIGHBORHOOD', 'NEIGHBORHOOD_PRODUCTION_FROM_MILITARY_ACADEMY');
INSERT INTO DistrictModifiers (DistrictType, ModifierId) VALUES ('DISTRICT_MBANZA', 'NEIGHBORHOOD_PRODUCTION_FROM_MILITARY_ACADEMY');
INSERT INTO Modifiers (ModifierId, ModifierType, RunOnce, Permanent, SubjectRequirementSetId) VALUES ('NEIGHBORHOOD_PRODUCTION_FROM_MILITARY_ACADEMY', 'MODIFIER_SINGLE_CITY_ADJUST_YIELD_CHANGE', '0', '0', 'CITY_HAS_MILITARY_ACADEMY_REQUIREMENTS');
INSERT INTO ModifierArguments (ModifierId, Name, Value) VALUES ('NEIGHBORHOOD_PRODUCTION_FROM_MILITARY_ACADEMY', 'YieldType', 'YIELD_PRODUCTION'), ('NEIGHBORHOOD_PRODUCTION_FROM_MILITARY_ACADEMY', 'Amount', '1');

INSERT INTO RequirementSets (RequirementSetId, RequirementSetType) VALUES ('CITY_HAS_MILITARY_ACADEMY_REQUIREMENTS', 'REQUIREMENTSET_TEST_ALL');
INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES ('CITY_HAS_MILITARY_ACADEMY_REQUIREMENTS', 'REQUIRES_CITY_HAS_MILITARY_ACADEMY');
-- REQUIRES_CITY_HAS_MILITARY_ACADEMY already exists in the base code.



INSERT INTO DistrictModifiers (DistrictType, ModifierId) VALUES ('DISTRICT_NEIGHBORHOOD', 'NEIGHBORHOOD_GOLD_FROM_SEAPORT');
INSERT INTO DistrictModifiers (DistrictType, ModifierId) VALUES ('DISTRICT_MBANZA', 'NEIGHBORHOOD_GOLD_FROM_SEAPORT');
INSERT INTO Modifiers (ModifierId, ModifierType, RunOnce, Permanent, SubjectRequirementSetId) VALUES ('NEIGHBORHOOD_GOLD_FROM_SEAPORT', 'MODIFIER_SINGLE_CITY_ADJUST_YIELD_CHANGE', '0', '0', 'CITY_HAS_SEAPORT_REQUIREMENTS');
INSERT INTO ModifierArguments (ModifierId, Name, Value) VALUES ('NEIGHBORHOOD_GOLD_FROM_SEAPORT', 'YieldType', 'YIELD_GOLD'), ('NEIGHBORHOOD_GOLD_FROM_SEAPORT', 'Amount', '1');
-- CITY_HAS_SEAPORT_REQUIREMENTS already exists in the base code.



INSERT INTO DistrictModifiers (DistrictType, ModifierId) VALUES ('DISTRICT_NEIGHBORHOOD', 'NEIGHBORHOOD_GOLD_FROM_STOCK_EXCHANGE');
INSERT INTO DistrictModifiers (DistrictType, ModifierId) VALUES ('DISTRICT_MBANZA', 'NEIGHBORHOOD_GOLD_FROM_STOCK_EXCHANGE');
INSERT INTO Modifiers (ModifierId, ModifierType, RunOnce, Permanent, SubjectRequirementSetId) VALUES ('NEIGHBORHOOD_GOLD_FROM_STOCK_EXCHANGE', 'MODIFIER_SINGLE_CITY_ADJUST_YIELD_CHANGE', '0', '0', 'CITY_HAS_STOCK_EXCHANGE_REQUIREMENTS');
INSERT INTO ModifierArguments (ModifierId, Name, Value) VALUES ('NEIGHBORHOOD_GOLD_FROM_STOCK_EXCHANGE', 'YieldType', 'YIELD_GOLD'), ('NEIGHBORHOOD_GOLD_FROM_STOCK_EXCHANGE', 'Amount', '1');

INSERT INTO RequirementSets (RequirementSetId, RequirementSetType) VALUES ('CITY_HAS_STOCK_EXCHANGE_REQUIREMENTS', 'REQUIREMENTSET_TEST_ALL');
INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES ('CITY_HAS_STOCK_EXCHANGE_REQUIREMENTS', 'REQUIRES_CITY_HAS_STOCK_EXCHANGE');
INSERT INTO Requirements (RequirementId, RequirementType) VALUES ('REQUIRES_CITY_HAS_STOCK_EXCHANGE', 'REQUIREMENT_CITY_HAS_BUILDING');
INSERT INTO RequirementArguments (RequirementId, Name, Value) VALUES ('REQUIRES_CITY_HAS_STOCK_EXCHANGE', 'BuildingType', 'BUILDING_STOCK_EXCHANGE');



INSERT INTO DistrictModifiers (DistrictType, ModifierId) VALUES ('DISTRICT_NEIGHBORHOOD', 'NEIGHBORHOOD_PRODUCTION_FROM_POWER_PLANT');
INSERT INTO DistrictModifiers (DistrictType, ModifierId) VALUES ('DISTRICT_MBANZA', 'NEIGHBORHOOD_PRODUCTION_FROM_POWER_PLANT');
INSERT INTO Modifiers (ModifierId, ModifierType, RunOnce, Permanent, SubjectRequirementSetId) VALUES ('NEIGHBORHOOD_PRODUCTION_FROM_POWER_PLANT', 'MODIFIER_SINGLE_CITY_ADJUST_YIELD_CHANGE', '0', '0', 'CITY_HAS_POWER_PLANT_REQUIREMENTS');
INSERT INTO ModifierArguments (ModifierId, Name, Value) VALUES ('NEIGHBORHOOD_PRODUCTION_FROM_POWER_PLANT', 'YieldType', 'YIELD_PRODUCTION'), ('NEIGHBORHOOD_PRODUCTION_FROM_POWER_PLANT', 'Amount', '1');

INSERT INTO RequirementSets (RequirementSetId, RequirementSetType) VALUES ('CITY_HAS_POWER_PLANT_REQUIREMENTS', 'REQUIREMENTSET_TEST_ALL');
INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES ('CITY_HAS_POWER_PLANT_REQUIREMENTS', 'REQUIRES_CITY_HAS_POWER_PLANT');
INSERT INTO Requirements (RequirementId, RequirementType) VALUES ('REQUIRES_CITY_HAS_POWER_PLANT', 'REQUIREMENT_CITY_HAS_BUILDING');
INSERT INTO RequirementArguments (RequirementId, Name, Value) VALUES ('REQUIRES_CITY_HAS_POWER_PLANT', 'BuildingType', 'BUILDING_POWER_PLANT');



INSERT INTO DistrictModifiers (DistrictType, ModifierId) VALUES ('DISTRICT_NEIGHBORHOOD', 'NEIGHBORHOOD_AMENITIES_FROM_STADIUM');
INSERT INTO DistrictModifiers (DistrictType, ModifierId) VALUES ('DISTRICT_MBANZA', 'NEIGHBORHOOD_AMENITIES_FROM_STADIUM');
INSERT INTO Modifiers (ModifierId, ModifierType, RunOnce, Permanent, SubjectRequirementSetId) VALUES ('NEIGHBORHOOD_AMENITIES_FROM_STADIUM', 'MODIFIER_SINGLE_CITY_ADJUST_CITY_AMENITIES_FROM_GREAT_PEOPLE', '0', '0', 'CITY_HAS_STADIUM_REQUIREMENTS');
INSERT INTO ModifierArguments (ModifierId, Name, Value) VALUES ('NEIGHBORHOOD_AMENITIES_FROM_STADIUM', 'Amount', '1');
-- CITY_HAS_STADIUM_REQUIREMENTS already exists in the base code



INSERT INTO DistrictModifiers (DistrictType, ModifierId) VALUES ('DISTRICT_NEIGHBORHOOD', 'NEIGHBORHOOD_GOLD_FROM_AIRPORT');
INSERT INTO DistrictModifiers (DistrictType, ModifierId) VALUES ('DISTRICT_MBANZA', 'NEIGHBORHOOD_GOLD_FROM_AIRPORT');
INSERT INTO Modifiers (ModifierId, ModifierType, RunOnce, Permanent, SubjectRequirementSetId) VALUES ('NEIGHBORHOOD_GOLD_FROM_AIRPORT', 'MODIFIER_SINGLE_CITY_ADJUST_YIELD_CHANGE', '0', '0', 'CITY_HAS_AIRPORT_REQUIREMENTS');
INSERT INTO ModifierArguments (ModifierId, Name, Value) VALUES ('NEIGHBORHOOD_GOLD_FROM_AIRPORT', 'YieldType', 'YIELD_GOLD'), ('NEIGHBORHOOD_GOLD_FROM_AIRPORT', 'Amount', '1');

INSERT INTO RequirementSets (RequirementSetId, RequirementSetType) VALUES ('CITY_HAS_AIRPORT_REQUIREMENTS', 'REQUIREMENTSET_TEST_ALL');
INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES ('CITY_HAS_AIRPORT_REQUIREMENTS', 'REQUIRES_CITY_HAS_AIRPORT');
INSERT INTO Requirements (RequirementId, RequirementType) VALUES ('REQUIRES_CITY_HAS_AIRPORT', 'REQUIREMENT_CITY_HAS_BUILDING');
INSERT INTO RequirementArguments (RequirementId, Name, Value) VALUES ('REQUIRES_CITY_HAS_AIRPORT', 'BuildingType', 'BUILDING_AIRPORT');



INSERT INTO DistrictModifiers (DistrictType, ModifierId) VALUES ('DISTRICT_NEIGHBORHOOD', 'NEIGHBORHOOD_FOOD_FROM_SEWER');
INSERT INTO DistrictModifiers (DistrictType, ModifierId) VALUES ('DISTRICT_MBANZA', 'NEIGHBORHOOD_FOOD_FROM_SEWER');
INSERT INTO Modifiers (ModifierId, ModifierType, RunOnce, Permanent, SubjectRequirementSetId) VALUES ('NEIGHBORHOOD_FOOD_FROM_SEWER', 'MODIFIER_SINGLE_CITY_ADJUST_YIELD_CHANGE', '0', '0', 'CITY_HAS_SEWER_REQUIREMENTS');
INSERT INTO ModifierArguments (ModifierId, Name, Value) VALUES ('NEIGHBORHOOD_FOOD_FROM_SEWER', 'YieldType', 'YIELD_FOOD'), ('NEIGHBORHOOD_FOOD_FROM_SEWER', 'Amount', '1');

INSERT INTO RequirementSets (RequirementSetId, RequirementSetType) VALUES ('CITY_HAS_SEWER_REQUIREMENTS', 'REQUIREMENTSET_TEST_ALL');
INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES ('CITY_HAS_SEWER_REQUIREMENTS', 'REQUIRES_CITY_HAS_SEWER');
INSERT INTO Requirements (RequirementId, RequirementType) VALUES ('REQUIRES_CITY_HAS_SEWER', 'REQUIREMENT_CITY_HAS_BUILDING');
INSERT INTO RequirementArguments (RequirementId, Name, Value) VALUES ('REQUIRES_CITY_HAS_SEWER', 'BuildingType', 'BUILDING_SEWER');

Workshop Link: http://steamcommunity.com/sharedfiles/filedetails/?id=1217692940

 

[ctudor]

> [Gameplay] ERROR: UNIQUE constraint failed: Requirements.RequirementId

Getting this error in database.log

 

[Laurana Kanan]

@ctudor - What does the modding.log say at the same timestamp in the database.log?

@fodazd - You may want to consider changing your modifier from MODIFIER_SINGLE_CITY_ADJUST_YIELD_CHANGE to MODIFIER_PLAYER_DISTRICT_ADJUST_BASE_YIELD_CHANGE. The former folds the bonus yields into the main city totals making it difficult to tell what bonuses you are receiving. Whereas the latter will allow you to hover over the District and see exactly what bonuses you are getting as it applies directly to the District itself. Additionally, you might want to add the new Aquatics Center from the Water Park District.

 

[ctudor]

[965140.154] UpdateDatabase - Loading Neighborhood_Modifiers.sql
[965140.159] Warning: UpdateDatabase - Error Loading SQL.
[965140.159] Applying Component - RTX10DatabaseUpdate (UpdateDatabase)

[965140.159] [Gameplay] ERROR: UNIQUE constraint failed: Requirements.RequirementId
[965140.159] [Gameplay] ERROR: UNIQUE constraint failed: Requirements.RequirementId

 

[Laurana Kanan]

There might be something else, but the RequirementId REQUIRES_CITY_HAS_STOCK_EXCHANGE already exists in the database so trying to insert it again would give you a Unique Constraint Error. Try changing each instance to something unique like REQ_CTUDOR_CITY_HAS_STOCK_EXCHANGE and see if that fixes the error.

 

[fodazd]

Thank you for the feedback, but I don't plan to support my mods anymore in the near future, since I am busy doing other things.