radi0ac7iv3
Chieftain
- Joined
- Aug 11, 2012
- Messages
- 3
In GEM 1.053, the file GEC_Start.sql in 'Cities' is setting happiness yields to 0 on all buildings. Colosseum, theatre, and stadium later have their happiness increased by 1 in the same file, giving them 1 total happiness. I am assuming this is a bug since it is different than the UI. The following code appears to cause the problem (located near the start of the file):
INSERT OR REPLACE INTO Building_YieldChanges
(BuildingType, YieldType, Yield)
SELECT DISTINCT Type, 'YIELD_HAPPINESS', Happiness + UnmoddedHappiness
FROM Buildings WHERE (Happiness + UnmoddedHappiness) <> 0;
UPDATE Buildings SET Happiness = 0;
UPDATE Buildings SET UnmoddedHappiness = 0;
INSERT OR REPLACE INTO Building_YieldChanges
(BuildingType, YieldType, Yield)
SELECT DISTINCT Type, 'YIELD_HAPPINESS', Happiness + UnmoddedHappiness
FROM Buildings WHERE (Happiness + UnmoddedHappiness) <> 0;
UPDATE Buildings SET Happiness = 0;
UPDATE Buildings SET UnmoddedHappiness = 0;
