· 9 years ago · Jan 10, 2017, 04:34 AM
1--==========================================================================================================================
2-- JFD CULTURAL DIVERSITY
3--==========================================================================================================================
4-- Civilization_JFD_CultureTypes
5------------------------------
6CREATE TABLE IF NOT EXISTS
7Civilization_JFD_CultureTypes(
8 CivilizationType text REFERENCES Civilizations(Type) default null,
9 CultureType text default null,
10 ArtDefineTag text default null,
11 DefeatScreenEarlyTag text default null,
12 DefeatScreenMidTag text default null,
13 DefeatScreenLateTag text default null,
14 IdealsTag text default null,
15 SplashScreenTag text default null,
16 SoundtrackTag text default null,
17 UnitDialogueTag text default null);
18
19INSERT INTO Civilization_JFD_CultureTypes
20 (CivilizationType, ArtDefineTag, CultureType, DefeatScreenEarlyTag, DefeatScreenMidTag, DefeatScreenLateTag, IdealsTag, SplashScreenTag, SoundtrackTag, UnitDialogueTag)
21SELECT 'CIVILIZATION_UC_BEST_KOREA', 'JFD_TOTALITARIAN', 'CULTURE_JFD_TOTALITARIAN', DefeatScreenEarlyTag, DefeatScreenMidTag, DefeatScreenLateTag, 'JFD_Totalitarian', 'JFD_Totalitarian', 'JFD_Totalitarian', 'AS2D_SOUND_JFD_KOREAN'
22FROM Civilization_JFD_CultureTypes WHERE CivilizationType = 'CIVILIZATION_KOREA';
23------------------------------
24-- Civilizations
25------------------------------
26UPDATE Civilizations
27SET SoundtrackTag = 'JFD_Totalitarian'
28WHERE Type = 'CIVILIZATION_UC_BEST_KOREA'
29AND EXISTS (SELECT * FROM Civilization_JFD_CultureTypes WHERE SoundtrackTag = 'JFD_Totalitarian')
30AND EXISTS (SELECT * FROM JFD_GlobalUserSettings WHERE Type = 'JFD_CULDIV_SOUNDTRACK_ADDON' AND Value = 1);