Resources

[Bladesss]

In my ignorance, I might have found something.
Using the published v3.5 the modinfo file has a line
<UpdateDatabase>UNUSED/CCTP/Resources/Resources.sql</UpdateDatabase>
and later line
<UpdateDatabase>UNUSED/CCTP/Resources/CCTP_Resources.xml</UpdateDatabase>

Gil hinted that some files loaded later may screw up the earlier files and the goal was shifting to sql files, so all i did was delete the second line (xml) and ran the program and the yields showed back up. I don't know it that impacts anything else, but the xml file was stepping on the yields.

 

[Gilgamesch]

In my ignorance, I might have found something.
Using the published v3.5 the modinfo file has a line
<UpdateDatabase>UNUSED/CCTP/Resources/Resources.sql</UpdateDatabase>
and later line
<UpdateDatabase>UNUSED/CCTP/Resources/CCTP_Resources.xml</UpdateDatabase>

Gil hinted that some files loaded later may screw up the earlier files and the goal was shifting to sql files, so all i did was delete the second line (xml) and ran the program and the yields showed back up. I don't know it that impacts anything else, but the xml file was stepping on the yields.

It will impact in some cases the game, but no game breaking.
It means that only horems resource yields are added to the database, the CCTP ones (and also others) where in this xml file, and there for not loaded.


To keep the mod better looking, easier working and better loading i spend some time to merge them all in there related sections.
This is in the work, also its a complete rework of CCTP, but this is a massiv time lurker.

 

[Bladesss]

Gil
removing the line
<UpdateDatabase>UNUSED/CCTP/Resources/CCTP_Resources.xml</UpdateDatabase>
fixes the yields but does not allow all of the CCTP resources to be improved.
The file improvements.xml seems to be the correct place to fix this but I could not fix it.

Note that the following resources are not covered in improvements.xml
(Rubber, Coconut, Tin, Amber, Coffee, Oak, Corn) some of those may not currently be supported but they are still in the resources.sql file.

Everyone else:
Note that some resources are not visible until they are discovered. I extracted the current ways to find resources from resources.sql, since it is not documented in the civopedia yet. They are discovered if either condition is met and seems to be working correctly.
(Subject to change)

RESOURCE_RUBBER' 'POLICY_COMMERCE', 'TECH_CHEMISTRY',
RESOURCE_COCONUT' POLICY_TRADITION', 'TECH_SAILING',
RESOURCE_TEA',' POLICY_EXPLORATION', 'TECH_SAILING'
RESOURCE_FLAX', POLICY_HONOR', 'TECH_POTTERY',
RESOURCE_BERRIES', POLICY_PIETY', 'TECH_POTTERY',
RESOURCE_CACAO',' POLICY_EXPLORATION', 'TECH_POTTERY'
RESOURCE_TIN' ' POLICY_LIBERTY', 'TECH_MINING',
RESOURCE_AMBER',' POLICY_LIBERTY', 'TECH_MINING',
RESOURCE_MANGANESE' 'POLICY_COMMERCE', 'TECH_METAL_CASTING',
RESOURCE_ALOE_VERA'' POLICY_PIETY', 'TECH_POTTERY',
RESOURCE_TITANIUM', POLICY_RATIONALISM', 'TECH_COMBINED_ARMS',
RESOURCE_POPPY'' POLICY_COMMERCE', 'TECH_POTTERY',
RESOURCE_COFFEE'' POLICY_EXPLORATION', 'TECH_SAILING',
RESOURCE_WOOD'' POLICY_EXPLORATION', 'TECH_MASONRY',
RESOURCE_OAK' POLICY_HONOR', 'TECH_POTTERY',
RESOURCE_MANGO',' POLICY_TRADITION', 'TECH_SAILING',
RESOURCE_BARLEY'' POLICY_TRADITION', 'TECH_POTTERY',
RESOURCE_CORN'' POLICY_TRADITION', 'TECH_POTTERY',
RESOURCE_TOBACCO'' POLICY_COMMERCE', 'TECH_POTTERY',
RESOURCE_JADE'' POLICY_COMMERCE', 'TECH_MASONRY',

 

[Gilgamesch]

Gil
removing the line
<UpdateDatabase>UNUSED/CCTP/Resources/CCTP_Resources.xml</UpdateDatabase>
fixes the yields but does not allow all of the CCTP resources to be improved.
The file improvements.xml seems to be the correct place to fix this but I could not fix it.

Note that the following resources are not covered in improvements.xml
(Rubber, Coconut, Tin, Amber, Coffee, Oak, Corn) some of those may not currently be supported but they are still in the resources.sql file.

Everyone else:
Note that some resources are not visible until they are discovered. I extracted the current ways to find resources from resources.sql, since it is not documented in the civopedia yet. They are discovered if either condition is met and seems to be working correctly.
(Subject to change)

RESOURCE_RUBBER' 'POLICY_COMMERCE', 'TECH_CHEMISTRY',
RESOURCE_COCONUT' POLICY_TRADITION', 'TECH_SAILING',
RESOURCE_TEA',' POLICY_EXPLORATION', 'TECH_SAILING'
RESOURCE_FLAX', POLICY_HONOR', 'TECH_POTTERY',
RESOURCE_BERRIES', POLICY_PIETY', 'TECH_POTTERY',
RESOURCE_CACAO',' POLICY_EXPLORATION', 'TECH_POTTERY'
RESOURCE_TIN' ' POLICY_LIBERTY', 'TECH_MINING',
RESOURCE_AMBER',' POLICY_LIBERTY', 'TECH_MINING',
RESOURCE_MANGANESE' 'POLICY_COMMERCE', 'TECH_METAL_CASTING',
RESOURCE_ALOE_VERA'' POLICY_PIETY', 'TECH_POTTERY',
RESOURCE_TITANIUM', POLICY_RATIONALISM', 'TECH_COMBINED_ARMS',
RESOURCE_POPPY'' POLICY_COMMERCE', 'TECH_POTTERY',
RESOURCE_COFFEE'' POLICY_EXPLORATION', 'TECH_SAILING',
RESOURCE_WOOD'' POLICY_EXPLORATION', 'TECH_MASONRY',
RESOURCE_OAK' POLICY_HONOR', 'TECH_POTTERY',
RESOURCE_MANGO',' POLICY_TRADITION', 'TECH_SAILING',
RESOURCE_BARLEY'' POLICY_TRADITION', 'TECH_POTTERY',
RESOURCE_CORN'' POLICY_TRADITION', 'TECH_POTTERY',
RESOURCE_TOBACCO'' POLICY_COMMERCE', 'TECH_POTTERY',
RESOURCE_JADE'' POLICY_COMMERCE', 'TECH_MASONRY',

Jip, it was a testing version, and the resources are only showed when the trigger ether a technology or policy.
In the next version when you start in the "Stone Age", with a Caveman you will not see any resources. All resources will need a prerequest, but thats minor...