shortfatsteve
Chieftain
- Joined
- Mar 8, 2020
- Messages
- 3
Hi, new to modding, so I'm starting by altering some mods I like that I wanted to tweak. There's a mod called Sumeria Revamp by S1AL from the Steam workshop that I've started with since it's kind of OP. There's a few sections to it that I've tweaked and all work fine as far as I've tested except for the one altering the Ziggurat. All I've done is removed some late era yield bonuses, but nothing, including the added Tech Prerequisite, seems to be registering. I'd appreciate any help offered. Here's the code :
Code:
DELETE FROM ImprovementModifiers WHERE ImprovementType='IMPROVEMENT_ZIGGURAT';
DELETE FROM Improvement_BonusYieldChanges WHERE ImprovementType='IMPROVEMENT_ZIGGURAT';
DELETE FROM Improvement_YieldChanges WHERE ImprovementType='IMPROVEMENT_ZIGGURAT';
UPDATE Improvements
SET Housing='1' , TilesRequired='1' , OnePerCity='1' , SameAdjacentValid='0' , PrereqTech='TECH_MASONRY'
WHERE ImprovementType='IMPROVEMENT_ZIGGURAT';
INSERT INTO Improvement_ValidTerrains
(ImprovementType , TerrainType)
VALUES
('IMPROVEMENT_ZIGGURAT' , 'TERRAIN_DESERT_HILLS'),
('IMPROVEMENT_ZIGGURAT' , 'TERRAIN_TUNDRA_HILLS'),
('IMPROVEMENT_ZIGGURAT' , 'TERRAIN_PLAINS_HILLS'),
('IMPROVEMENT_ZIGGURAT' , 'TERRAIN_GRASS_HILLS' ),
('IMPROVEMENT_ZIGGURAT' , 'TERRAIN_SNOW_HILLS' );
INSERT INTO Improvement_YieldChanges
(ImprovementType , YieldType , YieldChange)
VALUES
('IMPROVEMENT_ZIGGURAT' , 'YIELD_SCIENCE' , '2'),
('IMPROVEMENT_ZIGGURAT' , 'YIELD_CULTURE' , '1'),
('IMPROVEMENT_ZIGGURAT' , 'YIELD_FAITH' , '2');
INSERT INTO Improvement_BonusYieldChanges
(Id , ImprovementType , YieldType , BonusYieldChange , PrereqTech , PrereqCivic)
VALUES
('261' , 'IMPROVEMENT_ZIGGURAT' , 'YIELD_CULTURE' , '1' , NULL , 'CIVIC_DRAMA_POETRY' ),
('262' , 'IMPROVEMENT_ZIGGURAT' , 'YIELD_FAITH' , '1' , NULL , 'CIVIC_CIVIL_SERVICE' ),
('263' , 'IMPROVEMENT_ZIGGURAT' , 'YIELD_SCIENCE' , '1' , NULL , 'CIVIC_THE_ENLIGHTENMENT'),
('264' , 'IMPROVEMENT_ZIGGURAT' , 'YIELD_CULTURE' , '1' , NULL , 'CIVIC_OPERA_BALLET' );
INSERT INTO District_Adjacencies
(DistrictType , YieldChangeId)
VALUES
('DISTRICT_CAMPUS' , 'Ziggurat_Science'),
('DISTRICT_THEATER' , 'Ziggurat_Culture'),
('DISTRICT_HOLY_SITE' , 'Ziggurat_Faith' );
INSERT INTO Adjacency_YieldChanges
(ID , Description , YieldType , YieldChange , TilesRequired , AdjacentImprovement)
VALUES
('Ziggurat_Science' , 'LOC_DISTRICT_ZIGGURAT_SCIENCE' , 'YIELD_SCIENCE' , '1' , '1' , 'IMPROVEMENT_ZIGGURAT'),
('Ziggurat_Culture' , 'LOC_DISTRICT_ZIGGURAT_CULTURE' , 'YIELD_CULTURE' , '1' , '1' , 'IMPROVEMENT_ZIGGURAT'),
('Ziggurat_Faith' , 'LOC_DISTRICT_ZIGGURAT_FAITH' , 'YIELD_FAITH' , '1' , '1' , 'IMPROVEMENT_ZIGGURAT');