[R&F] Where is the monastery data located?

[Question]

The CS Armagh lets builders build the monastery, which is a tile improvement that grants +2 faith and +15 hp healing to religious units.

The problem is i cannot find where this is defined ANYWHERE.

Its not in improvements.xml or the expansion improvements.xml. The colossal head, which is another CS improvement, is in improvements.xml, but the monastery is not.

Does anyone know where this is located?

VikingScenario_Improvements.xml has the Alcazar and Monastery, but their yields in the xml are very different from what the civlopedia says, so im not sure if they are the same ones.

 

[isau]

I don't know which DLC adds Armagh, but the Monastery data can be accessed with this SQL query:

select * from improvements
left join improvement_yieldchanges as iYC on iYC.improvementtype = improvements.ImprovementType
where improvements.ImprovementType like '%monas%'

 

[Question]

Oh, i found it in the VikingLandmarks_CityStates.xml file.

Not sure how that SQL query works. How do i change the yields using that?

 

[rattatatouille]

What yields are you looking to change in particular?

 

[Question]

I changed it to give 2 faith, 1 production and 1 science, but i dont know how to do it in the SQL method.

 

[rattatatouille]

Try this:

INSERT INTO Improvement_YieldChanges (ImprovementType, YieldType, YieldChange) VALUES ('IMPROVEMENT_MONASTERY', 'YIELD_PRODUCTION', '1');

INSERT INTO Improvement_YieldChanges (ImprovementType, YieldType, YieldChange) VALUES ('IMPROVEMENT_MONASTERY', 'YIELD_SCIENCE', '1');

Since Monasteries already should provide +2 Faith there's no need to insert that.

 

[isau]

Try this:

INSERT INTO Improvement_YieldChanges (ImprovementType, YieldType, YieldChange) VALUES ('IMPROVEMENT_MONASTERY', 'YIELD_PRODUCTION', '1');

INSERT INTO Improvement_YieldChanges (ImprovementType, YieldType, YieldChange) VALUES ('IMPROVEMENT_MONASTERY', 'YIELD_SCIENCE', '1');

Since Monasteries already should provide +2 Faith there's no need to insert that.

Good advice. Just chiming in to add that for added safety I would make this INSERT OR REPLACE INTO instead of just INSERT INTO. That way if it conflicts with another record (e.g. another mod) it won't crash back to the main menu.