Changing district yield adjacencies for only play civ

davidn000

Chieftain
Joined
May 28, 2020
Messages
3
I'm trying to edit this mod and only have the district adjacencies for my own civ. I have done a little research and I know that OwnerRequirementSetId in modifiers is what checks that for me but I have not the littlest clue in how to incorporate that into this SQL code.


--======================================================================================================================================================================================================--
/* DOWNTOWN DISTRICT */
--======================================================================================================================================================================================================--
INSERT INTO Types
( Type, Kind ) VALUES
( 'DISTRICT_DOWNTOWN', 'KIND_DISTRICT' );

INSERT INTO Districts
( DistrictType, Name, Description, PrereqTech, PlunderType, PlunderAmount, AdvisorType, Cost, CostProgressionModel, CostProgressionParam1, OnePerCity, RequiresPlacement, RequiresPopulation, Aqueduct, NoAdjacentCity, InternalOnly, CaptureRemovesBuildings, CaptureRemovesCityDefenses, MilitaryDomain, Housing, Maintenance, CityStrengthModifier ) VALUES
( 'DISTRICT_DOWNTOWN', 'LOC_DISTRICT_DOWNTOWN_NAME', 'LOC_DISTRICT_DOWNTOWN_DESCRIPTION', 'TECH_INDUSTRIALIZATION', 'PLUNDER_GOLD', '50', 'ADVISOR_GENERIC', '54', 'COST_PROGRESSION_GAME_PROGRESS', '1000', '0', '1', '0', '0', '0', '0', '0', '0', 'NO_DOMAIN', '3', '2', '200' );

INSERT INTO Adjacency_YieldChanges
( ID, Description, YieldType, YieldChange, TilesRequired, AdjacentDistrict ) VALUES
( 'Downtown_Campus', 'LOC_DISTRICT_DOWNTOWN_CAMPUS', 'YIELD_SCIENCE', 200, 1, 'DISTRICT_CAMPUS' ),
( 'Downtown_HolySite', 'LOC_DISTRICT_DOWNTOWN_HOLYSITE', 'YIELD_FAITH', 2, 1, 'DISTRICT_HOLY_SITE' ),
( 'Downtown_CommHub', 'LOC_DISTRICT_DOWNTOWN_COMMHUB', 'YIELD_GOLD', 2, 1, 'DISTRICT_COMMERCIAL_HUB' ),
( 'Downtown_Theater', 'LOC_DISTRICT_DOWNTOWN_THEATER', 'YIELD_CULTURE', 2, 1, 'DISTRICT_THEATER' ),
( 'Downtown_Harbor', 'LOC_DISTRICT_DOWNTOWN_HARBOR', 'YIELD_GOLD', 1, 1, 'DISTRICT_HARBOR' ),
( 'Downtown_HarborProd', 'LOC_DISTRICT_DOWNTOWN_HARBORPROD', 'YIELD_PRODUCTION', 1500, 1, 'DISTRICT_HARBOR' ),
( 'Downtown_Industrial', 'LOC_DISTRICT_DOWNTOWN_INDUSTRIAL', 'YIELD_PRODUCTION', 2000, 1, 'DISTRICT_INDUSTRIAL_ZONE' ),
( 'Downtown_Aqueduct', 'LOC_DISTRICT_DOWNTOWN_AQUEDUCT', 'YIELD_FOOD', 2500, 1, 'DISTRICT_AQUEDUCT' ),
( 'Downtown_Acropolis', 'LOC_DISTRICT_DOWNTOWN_ACROPOLIS', 'YIELD_CULTURE', 2000, 1, 'DISTRICT_ACROPOLIS' ),
( 'Downtown_AcropolisFaith', 'LOC_DISTRICT_DOWNTOWN_ACROPOLISFAITH', 'YIELD_FAITH', 1, 1, 'DISTRICT_ACROPOLIS' ),
( 'Downtown_Bath', 'LOC_DISTRICT_DOWNTOWN_BATH', 'YIELD_FOOD', 2, 1, 'DISTRICT_BATH' ),
( 'Downtown_BathCulture', 'LOC_DISTRICT_DOWNTOWN_BATHCULTURE', 'YIELD_CULTURE', 1, 1, 'DISTRICT_BATH' ),
( 'Downtown_Hansa', 'LOC_DISTRICT_DOWNTOWN_HANSA', 'YIELD_PRODUCTION', 2, 1, 'DISTRICT_HANSA' ),
( 'Downtown_HansaGold', 'LOC_DISTRICT_DOWNTOWN_HANSAGOLD', 'YIELD_GOLD', 1, 1, 'DISTRICT_HANSA' ),
( 'Downtown_Lavra', 'LOC_DISTRICT_DOWNTOWN_LAVRA', 'YIELD_FAITH', 2, 1, 'DISTRICT_LAVRA' ),
( 'Downtown_LavraScience', 'LOC_DISTRICT_DOWNTOWN_LAVRASCIENCE', 'YIELD_SCIENCE', 1, 1, 'DISTRICT_LAVRA' ),
( 'Downtown_RoyalNavyGold', 'LOC_DISTRICT_DOWNTOWN_ROYALGOLD', 'YIELD_GOLD', 2, 1, 'DISTRICT_ROYAL_NAVY_DOCKYARD' ),
( 'Downtown_RoyalNavyProd', 'LOC_DISTRICT_DOWNTOWN_ROYALPROD', 'YIELD_PRODUCTION', 1, 1, 'DISTRICT_ROYAL_NAVY_DOCKYARD' );

INSERT INTO District_Adjacencies
( DistrictType, YieldChangeID ) VALUES
( 'DISTRICT_DOWNTOWN', 'Downtown_Campus' ),
( 'DISTRICT_DOWNTOWN', 'Downtown_HolySite' ),
( 'DISTRICT_DOWNTOWN', 'Downtown_CommHub' ),
( 'DISTRICT_DOWNTOWN', 'Downtown_Theater' ),
( 'DISTRICT_DOWNTOWN', 'Downtown_Harbor' ),
( 'DISTRICT_DOWNTOWN', 'Downtown_HarborProd' ),
( 'DISTRICT_DOWNTOWN', 'Downtown_Industrial' ),
( 'DISTRICT_DOWNTOWN', 'Downtown_Aqueduct' ),
( 'DISTRICT_DOWNTOWN', 'Downtown_Acropolis' ),
( 'DISTRICT_DOWNTOWN', 'Downtown_AcropolisFaith' ),
( 'DISTRICT_DOWNTOWN', 'Downtown_Bath' ),
( 'DISTRICT_DOWNTOWN', 'Downtown_BathCulture' ),
( 'DISTRICT_DOWNTOWN', 'Downtown_Hansa' ),
( 'DISTRICT_DOWNTOWN', 'Downtown_HansaGold' ),
( 'DISTRICT_DOWNTOWN', 'Downtown_Lavra' ),
( 'DISTRICT_DOWNTOWN', 'Downtown_LavraScience' ),
( 'DISTRICT_DOWNTOWN', 'Downtown_RoyalNavyGold' ),
( 'DISTRICT_DOWNTOWN', 'Downtown_RoyalNavyProd' );

INSERT INTO District_TradeRouteYields
( DistrictType, YieldType, YieldChangeAsOrigin, YieldChangeAsDomesticDestination, YieldChangeAsInternationalDestination ) VALUES
( 'DISTRICT_DOWNTOWN', 'YIELD_GOLD', '-1', '0', '2' ),
( 'DISTRICT_DOWNTOWN', 'YIELD_FOOD', '0', '1', '0' ),
( 'DISTRICT_DOWNTOWN', 'YIELD_PRODUCTION', '0', '1', '0' );

INSERT INTO Requirements
( RequirementId, RequirementType ) VALUES
( 'IT_NEXT_TO_AERODROME', 'REQUIREMENT_PLOT_ADJACENT_DISTRICT_TYPE_MATCHES' ),
( )
( 'IT_NEXT_TO_ENTERTAINMENT', 'REQUIREMENT_PLOT_ADJACENT_DISTRICT_TYPE_MATCHES' );

INSERT INTO RequirementArguments
( RequirementId, Name, Value ) VALUES
( 'IT_NEXT_TO_AERODROME', 'DistrictType', 'DISTRICT_AERODROME' ),
( 'IT_NEXT_TO_ENTERTAINMENT', 'DistrictType', 'DISTRICT_ENTERTAINMENT_COMPLEX' );

INSERT INTO RequirementSets
( RequirementSetId, RequirementSetType ) VALUES
( 'IT_AERODROME_ADJACENT', 'REQUIREMENTSET_TEST_ALL' ),
( 'IT_ENTERTAINMENT_ADJACENT', 'REQUIREMENTSET_TEST_ALL' );

INSERT INTO RequirementSetRequirements
( RequirementSetId, RequirementId ) VALUES
( 'IT_AERODROME_ADJACENT', 'IT_NEXT_TO_AERODROME' ),
( 'IT_ENTERTAINMENT_ADJACENT', 'IT_NEXT_TO_ENTERTAINMENT' );

INSERT INTO Modifiers
( ModifierId, ModifierType, RunOnce, Permanent, OwnerRequirementSetId, SubjectRequirementSetId ) VALUES
( 'DOWNTOWN_AERODROME_AIRSLOTS', 'MODIFIER_PLAYER_DISTRICT_GRANT_AIR_SLOTS', 0, 0, PLAYER_IS_HUMAN, 'IT_AERODROME_ADJACENT' ),
( 'DOWNTOWN_ENTERTAINMENT_AMENITIES', 'MODIFIER_PLAYER_CITIES_ADJUST_POLICY_AMENITY', 0, 0, PLAYER_IS_HUMAN, 'IT_ENTERTAINMENT_ADJACENT' );

INSERT INTO ModifierArguments
( ModifierId, Name, Value ) VALUES
( 'DOWNTOWN_AERODROME_AIRSLOTS', 'Amount', '2' ),
( 'DOWNTOWN_ENTERTAINMENT_AMENITIES', 'Amount', '2' );

INSERT INTO DistrictModifiers
( DistrictType, ModifierId ) VALUES
( 'DISTRICT_DOWNTOWN', 'DOWNTOWN_AERODROME_AIRSLOTS' ),
( 'DISTRICT_DOWNTOWN', 'DOWNTOWN_ENTERTAINMENT_AMENITIES' );

--======================================================================================================================================================================================================--

Also, I am playing mid game so if I modify the mod will it carry out into the game?
 
Top Bottom