Few More Buildings for VP

[gwennog]

As much as I read, I don't understand what you mean Adan (period?). In any case, the Marina is not balanced, it is too powerful. I would have to modify it and make it more original in relation to the Ski resort.

 

[AndreyK]

As much as I read, I don't understand what you mean Adan (period?). In any case, the Marina is not balanced, it is too powerful. I would have to modify it and make it more original in relation to the Ski resort.

Yes, and I don't play with Marina, it's too strong.

 

[franzacq]

As much as I read, I don't understand what you mean Adan (period?). In any case, the Marina is not balanced, it is too powerful. I would have to modify it and make it more original in relation to the Ski resort.

I ended up being busy yesterday so I'm going to make the thread today. I'll post it with the current Marina, and there can be a balance discussion - which is needed for multiple buildings anyway.

 

[jarcast2]

For the Marina nerfing the culture/tourism bonus from +2 per coast tile to +0.75 per worked coast tile would already be a step in the good direction.

Spoiler Old :

INSERT INTO Building_TerrainYieldChanges
    (BuildingType, TerrainType, YieldType, Yield) VALUES 
    ('BUILDING_MARINA', 'TERRAIN_COAST',    'YIELD_TOURISM', 2),
    ('BUILDING_MARINA', 'TERRAIN_COAST',    'YIELD_CULTURE', 2);

INSERT INTO Building_YieldPerXTerrainTimes100
    (BuildingType, TerrainType, YieldType, Yield) VALUES 
    ('BUILDING_MARINA', 'TERRAIN_COAST',    'YIELD_TOURISM', 75),
    ('BUILDING_MARINA', 'TERRAIN_COAST',    'YIELD_CULTURE', 75);

 

[gwennog]

I was thinking about it and maybe +1/ per 2 Coast tiles with a +1/ on fishing boats including those of Better Lakes (excellent version that you proposed by the way, @jarcast2 ) and atolls.

 

[jarcast2]

I was thinking about it and maybe +1/ per 2 Coast tiles with a +1/ on fishing boats including those of Better Lakes (excellent version that you proposed by the way, @jarcast2 ) and atolls.

Good idea.

I updated the mod with your changes.
I also updated the relevant text.

Spoiler NEW Code :

INSERT INTO Building_YieldPerXTerrainTimes100
    (BuildingType, TerrainType, YieldType, Yield) VALUES 
    ('BUILDING_MARINA', 'TERRAIN_COAST',    'YIELD_TOURISM', 50),
    ('BUILDING_MARINA', 'TERRAIN_COAST',    'YIELD_CULTURE', 50);
    
INSERT INTO Building_FeatureYieldChanges
        (BuildingType,         FeatureType, YieldType, Yield)
SELECT 'BUILDING_MARINA', 'FEATURE_ATOLL', 'YIELD_TOURISM', 1 UNION ALL
SELECT 'BUILDING_MARINA', 'FEATURE_ATOLL', 'YIELD_CULTURE', 1;
    
INSERT INTO Building_ImprovementYieldChanges 
        (BuildingType,        ImprovementType,                    YieldType,        Yield)
SELECT 'BUILDING_MARINA',    'IMPROVEMENT_FISHING_BOATS',        Type,    1 FROM Yields WHERE Type IN ('YIELD_TOURISM','YIELD_CULTURE') UNION ALL
SELECT 'BUILDING_MARINA',    'IMPROVEMENT_IA_LAKE_FISHING_BOATS',Type,    1 FROM Yields WHERE Type IN ('YIELD_TOURISM','YIELD_CULTURE')
AND EXISTS (SELECT * FROM Improvements WHERE Type='IMPROVEMENT_IA_LAKE_FISHING_BOATS');

CREATE TRIGGER IF NOT EXISTS MarinaBetterLakes AFTER INSERT ON Improvements
WHEN NEW.Type = "IMPROVEMENT_IA_LAKE_FISHING_BOATS"
BEGIN
    INSERT INTO Building_ImprovementYieldChanges 
            (BuildingType,        ImprovementType,    YieldType,        Yield)
    SELECT 'BUILDING_MARINA',    NEW.Type,            'YIELD_TOURISM',    1 UNION ALL
    SELECT 'BUILDING_MARINA',    NEW.Type,            'YIELD_CULTURE',    1;
END;

 

[franzacq]

This is a great update to the Marina, thank you for the edits. I'll add this change in and begin the new thread with v2.

 

[franzacq]

New thread posted: https://forums.civfanatics.com/threads/few-more-buildings-for-vp-franzacq-continuation.689717/