Simple Question: how to remove yield from tundra hills?

Laz0r

Warlord
Joined
Oct 18, 2019
Messages
126
How do I remove a single production yield from specifically tundra hills? I'm not at all a modder and only know how to modify or repurpose lines from .sql files, so this is what I came up with to no success:

Code:
UPDATE Terrain_Yields
SET Yield = '-1'
WHERE TerrainType = 'TERRAIN_TUNDRA' AND 'REGION_HILLS' AND YieldType= 'YIELD_PRODUCTION';
 
UPDATE Terrain_HillsYieldChanges
SET Yield=(SELECT Yield FROM Terrain_HillsYieldChanges WHERE TerrainType='TERRAIN_TUNDRA' AND YieldType='YIELD_PRODUCTION')-1
WHERE TerrainType='TERRAIN_TUNDRA' AND YieldType='YIELD_PRODUCTION';
 
UPDATE Terrain_HillsYieldChanges
SET Yield=(SELECT Yield FROM Terrain_HillsYieldChanges WHERE TerrainType='TERRAIN_TUNDRA' AND YieldType='YIELD_PRODUCTION')-1
WHERE TerrainType='TERRAIN_TUNDRA' AND YieldType='YIELD_PRODUCTION';
Thank you sir, by chance is there a guide somewhere on this forum for learning the different variables that can be changed in SQL files?
 
 
Top Bottom