Store Page
Sid Meier's Civilization VI
All Discussions Screenshots Artwork Broadcasts Videos Workshop News Guides Reviews

Sid Meier's Civilization VI

Store Page
Sid Meier's Civilization VI >  Workshop > Leugi's Workshop > Monopoly++: Tycoons and Investors > Discussions
Monopoly++: Tycoons and Investors
Description Discussions3 Comments166 Change Notes
Madisonian 26 Apr, 2024 @ 2:18am
Transnational/Offshore Tank resources
Hi, just a minor thing I noticed in the Civilopedia is that the Transnational Company and Offshore Tanker are showing resources they can't actually improve since you simply used resource classes to insert into Improvement_ValidResources. Things like Jeans, Perfume, etc., or Renewable Battery Charges from Renewable Energy Complexity.

I wrote some code that more accurately selects the resources used for both of those improvements by adding checks for SeaFrequency, including some conditional modded resources. Feel free to use it if you wish, it cleans up the Civilopedia entry nicely.

INSERT INTO Improvement_ValidResources (ImprovementType, ResourceType, MustRemoveFeature) SELECT 'IMPROVEMENT_LEU_TRANSNATIONAL', ResourceType, 0 FROM Resources WHERE ResourceClassType = 'RESOURCECLASS_STRATEGIC' AND ResourceType!='RESOURCE_JNR_BATTERY_CHARGE' AND ResourceType!='RESOURCE_STEEL' --Project Metropolis AND SeaFrequency=0; INSERT INTO Improvement_ValidResources (ImprovementType, ResourceType, MustRemoveFeature) SELECT 'IMPROVEMENT_LEU_TRANSNATIONAL_SEA', ResourceType, 0 FROM Resources WHERE ResourceClassType = 'RESOURCECLASS_STRATEGIC' AND SeaFrequency>=1; INSERT INTO Improvement_ValidResources (ImprovementType, ResourceType, MustRemoveFeature) SELECT 'IMPROVEMENT_LEU_TRANSNATIONAL', ResourceType, 0 FROM Resources WHERE ResourceClassType = 'RESOURCECLASS_LUXURY' AND ResourceType!='RESOURCE_JEANS' AND ResourceType!='RESOURCE_PERFUME' AND ResourceType!='RESOURCE_COSMETICS' AND ResourceType!='RESOURCE_TOYS' AND ResourceType!='RESOURCE_CINNAMON' AND ResourceType!='RESOURCE_CLOVES' AND ResourceType!='RESOURCE_PHANTA_WOLONG_GIANT_PANDA' --Wolong Wonder AND ResourceType!='RESOURCE_COREEX_COMPUTERS' --City Lights AND SeaFrequency=0; INSERT INTO Improvement_ValidResources (ImprovementType, ResourceType, MustRemoveFeature) SELECT 'IMPROVEMENT_LEU_TRANSNATIONAL_SEA', ResourceType, 0 FROM Resources WHERE ResourceClassType = 'RESOURCECLASS_LUXURY' AND SeaFrequency>=1;

To replace this in MonopolyPlus_Improvements.sql:
INSERT INTO Improvement_ValidResources (ImprovementType, ResourceType, MustRemoveFeature) SELECT 'IMPROVEMENT_LEU_TRANSNATIONAL', ResourceType, 0 FROM Resources WHERE ResourceClassType = 'RESOURCECLASS_STRATEGIC' UNION ALL SELECT 'IMPROVEMENT_LEU_TRANSNATIONAL_SEA', ResourceType, 0 FROM Resources WHERE ResourceClassType = 'RESOURCECLASS_STRATEGIC'; INSERT INTO Improvement_ValidResources (ImprovementType, ResourceType, MustRemoveFeature) SELECT 'IMPROVEMENT_LEU_TRANSNATIONAL', ResourceType, 0 FROM Resources WHERE ResourceClassType = 'RESOURCECLASS_LUXURY' UNION ALL SELECT 'IMPROVEMENT_LEU_TRANSNATIONAL_SEA', ResourceType, 0 FROM Resources WHERE ResourceClassType = 'RESOURCECLASS_LUXURY';
Last edited by Madisonian; 26 Apr, 2024 @ 5:33pm