1. We have added the ability to collapse/expand forum categories and widgets on forum home.
    Dismiss Notice
  2. All Civ avatars are brought back and available for selection in the Avatar Gallery! There are 945 avatars total.
    Dismiss Notice
  3. To make the site more secure, we have installed SSL certificates and enabled HTTPS for both the main site and forums.
    Dismiss Notice
  4. Civ6 is released! Order now! (Amazon US | Amazon UK | Amazon CA | Amazon DE | Amazon FR)
    Dismiss Notice
  5. Dismiss Notice
  6. Forum account upgrades are available for ad-free browsing.
    Dismiss Notice

Improved Neighborhoods 2017-12-01

Neighborhoods get bonus yields based on buildings in the city.

  1. fodazd

    fodazd Chieftain

    Joined:
    Mar 5, 2013
    Messages:
    75
    fodazd submitted a new resource:

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

    Read more about this resource...
     
  2. fodazd

    fodazd Chieftain

    Joined:
    Mar 5, 2013
    Messages:
    75
    Code:
    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
     
  3. ctudor

    ctudor Chieftain

    Joined:
    Oct 30, 2016
    Messages:
    52
    Gender:
    Male
    > [Gameplay] ERROR: UNIQUE constraint failed: Requirements.RequirementId

    Getting this error in database.log
     
  4. Laurana Kanan

    Laurana Kanan Queen's

    Joined:
    Apr 10, 2014
    Messages:
    1,087
    Gender:
    Female
    Location:
    Near the Greatest Snow on Earth
    @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.
     
  5. ctudor

    ctudor Chieftain

    Joined:
    Oct 30, 2016
    Messages:
    52
    Gender:
    Male
    [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
     
  6. Laurana Kanan

    Laurana Kanan Queen's

    Joined:
    Apr 10, 2014
    Messages:
    1,087
    Gender:
    Female
    Location:
    Near the Greatest Snow on Earth
    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.
     
  7. fodazd

    fodazd Chieftain

    Joined:
    Mar 5, 2013
    Messages:
    75
    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.
     

Share This Page

Ebates: Get Paid to Shop