-
Notifications
You must be signed in to change notification settings - Fork 0
/
AudioThings.sql
114 lines (109 loc) · 9.78 KB
/
AudioThings.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_AMERICA_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_ARABIA_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_ASSYRIA_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_AUSTRIA_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_AZTEC_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_BABYLON_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_BRAZIL_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_BYZANTIUM_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_CARTHAGE_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_CELTS_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_CHINA_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_DENMARK_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_EGYPT_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_ENGLAND_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_ETHIOPIA_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_FRANCE_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_GERMANY_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_GREECE_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_HUNS_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_INCA_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_INDIA_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_INDONESIA_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_IROQUOIS_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_JAPAN_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_KOREA_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_MAYA_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_MONGOL_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_MOROCCO_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_NETHERLANDS_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_OTTOMAN_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_PERSIA_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_POLAND_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_POLYNESIA_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_PORTUGAL_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_ROME_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_RUSSIA_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_SHOSHONE_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_SIAM_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_SONGHAI_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_SPAIN_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_SWEDEN_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_VENICE_UE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ECIV' WHERE Type = 'EVENT_ZULU_UE';
CREATE TRIGGER Event_AudioForCustomCiv
AFTER INSERT ON Events
BEGIN
UPDATE Events
SET EventAudio = 'AS2D_EVENT_ECIV'
WHERE EventClass = 'EVENT_CLASS_CIV_SPECIFIC' AND RandomChance = 125 AND RandomChanceDelta = 125;
END;
UPDATE Events SET EventAudio = 'AS2D_EVENT_EECONOMIC' WHERE Type = 'EVENT_AES_ECONOMIC';
UPDATE Events SET EventAudio = 'AS2D_EVENT_EECONOMIC' WHERE Type = 'EVENT_AES_ECONOMIC_PLAYER_GOOD';
UPDATE Events SET EventAudio = 'AS2D_EVENT_EECONOMIC' WHERE Type = 'EVENT_AES_ECONOMIC_PLAYER_BAD';
UPDATE Events SET EventAudio = 'AS2D_EVENT_EECONOMIC' WHERE Type = 'EVENT_AES_ECONOMIC_PLAYER_TRADE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_EFOREIGN' WHERE Type = 'EVENT_AES_FOREIGN';
UPDATE Events SET EventAudio = 'AS2D_EVENT_EFOREIGN' WHERE Type = 'EVENT_AES_FOREIGN_PLAYER_GOOD';
UPDATE Events SET EventAudio = 'AS2D_EVENT_EFOREIGN' WHERE Type = 'EVENT_AES_FOREIGN_PLAYER_BAD';
UPDATE Events SET EventAudio = 'AS2D_EVENT_EFOREIGN' WHERE Type = 'EVENT_AES_FOREIGN_PLAYER_TRADE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ESCIENCE' WHERE Type = 'EVENT_AES_SCIENCE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ESCIENCE' WHERE Type = 'EVENT_AES_SCIENCE_PLAYER_GOOD';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ESCIENCE' WHERE Type = 'EVENT_AES_SCIENCE_PLAYER_BAD';
UPDATE Events SET EventAudio = 'AS2D_EVENT_ESCIENCE' WHERE Type = 'EVENT_AES_SCIENCE_PLAYER_TRADE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_EMILITARY' WHERE Type = 'EVENT_AES_WAR';
UPDATE Events SET EventAudio = 'AS2D_EVENT_EMILITARY' WHERE Type = 'EVENT_AES_WAR_PLAYER_GOOD';
UPDATE Events SET EventAudio = 'AS2D_EVENT_EMILITARY' WHERE Type = 'EVENT_AES_WAR_PLAYER_BAD';
UPDATE Events SET EventAudio = 'AS2D_EVENT_EMILITARY' WHERE Type = 'EVENT_AES_WAR_PLAYER_TRADE';
UPDATE Events SET EventAudio = 'AS2D_EVENT_EDISCOVERY' WHERE Type = 'PLAYER_EVENT_LOSTLUXURIES';
UPDATE EventChoices SET EventChoiceAudio = 'AS2D_EVENT_ECULTUREEXPANDS' WHERE Type = 'PLAYER_EVENT_LOSTLUXURIES_CHOICE_1';
UPDATE EventChoices SET EventChoiceAudio = 'AS2D_EVENT_EFIRSTTOSOMETHING' WHERE Type = 'PLAYER_EVENT_LOSTLUXURIES_CHOICE_2';
UPDATE EventChoices SET EventChoiceAudio = 'AS2D_EVENT_ECITYCAPTURE' WHERE Type = 'CITY_EVENT_FIREFIRE_CHOICE_1';
UPDATE EventChoices SET EventChoiceAudio = 'AS2D_EVENT_ECITYCAPTURE' WHERE Type = 'CITY_EVENT_FIREFIRE_CHOICE_2';
UPDATE EventChoices SET EventChoiceAudio = 'AS2D_EVENT_ECROWDCHEER' WHERE Type = 'CITY_EVENT_FIREFIRE_CHOICE_3';
UPDATE EventChoices SET EventChoiceAudio = 'AS2D_EVENT_ECROWDCHEER' WHERE Type = 'CITY_EVENT_FIREFIRE_CHOICE_4';
UPDATE EventChoices SET EventChoiceAudio = 'AS2D_EVENT_ECROWDCHEER' WHERE Type = 'CITY_EVENT_EYEFOREYE_CHOICE_1';
UPDATE EventChoices SET EventChoiceAudio = 'AS2D_EVENT_EFIRSTTOSOMETHING' WHERE Type = 'CITY_EVENT_EYEFOREYE_CHOICE_2';
UPDATE EventChoices SET EventChoiceAudio = 'AS2D_EVENT_EREVOLUTIONEND' WHERE Type = 'CITY_EVENT_EYEFOREYE_CHOICE_3';
UPDATE EventChoices SET EventChoiceAudio = 'AS2D_EVENT_ECITYCAPTURE' WHERE Type = 'CITY_EVENT_RAIDRAID_CHOICE_1';
UPDATE EventChoices SET EventChoiceAudio = 'AS2D_EVENT_ECITYCAPTURE' WHERE Type = 'CITY_EVENT_RAIDRAID_CHOICE_2';
UPDATE EventChoices SET EventChoiceAudio = 'AS2D_EVENT_ECITYCAPTURE' WHERE Type = 'CITY_EVENT_RAIDRAID2_CHOICE_1';
UPDATE EventChoices SET EventChoiceAudio = 'AS2D_EVENT_ECITYCAPTURE' WHERE Type = 'CITY_EVENT_RAIDRAID2_CHOICE_2';
UPDATE EventChoices SET EventChoiceAudio = 'AS2D_EVENT_ECITYCAPTURE' WHERE Type = 'CITY_EVENT_RAIDRAID3_CHOICE_1';
UPDATE EventChoices SET EventChoiceAudio = 'AS2D_EVENT_ECITYCAPTURE' WHERE Type = 'CITY_EVENT_RAIDRAID3_CHOICE_2';
UPDATE EventChoices SET EventChoiceAudio = 'AS2D_EVENT_EPLAGUE' WHERE Type = 'CITY_EVENT_PLAGUEPLAGUE_CHOICE_1';
UPDATE EventChoices SET EventChoiceAudio = 'AS2D_EVENT_EPLAGUE' WHERE Type = 'CITY_EVENT_PLAGUEPLAGUE_CHOICE_2';
UPDATE EventChoices SET EventChoiceAudio = 'AS2D_EVENT_ECROWDCHEER' WHERE Type = 'CITY_EVENT_DRUNKWLTKD_CHOICE_1';
UPDATE EventChoices SET EventChoiceAudio = 'AS2D_EVENT_ECROWDCHEER' WHERE Type = 'CITY_EVENT_DRUNKWLTKD_CHOICE_2';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_ECITYREVOLT' WHERE Type = 'CITY_EVENT_FIREFIRE';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_EPLAGUE' WHERE Type = 'CITY_EVENT_JUNGLEFEVER';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_EDECLAREWAR' WHERE Type = 'CITY_EVENT_RAIDRAID';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_EDECLAREWAR' WHERE Type = 'CITY_EVENT_RAIDRAID2';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_ESTRIKE' WHERE Type = 'CITY_EVENT_RAIDRAID3';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_EPLAGUE' WHERE Type = 'CITY_EVENT_PLAGUEPLAGUE';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_EFIRSTTOSOMETHING' WHERE Type = 'CITY_EVENT_NW_BARRINGER_CRATER';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_EFIRSTTOSOMETHING' WHERE Type = 'CITY_EVENT_NW_EL_DORADO';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_EFIRSTTOSOMETHING' WHERE Type = 'CITY_EVENT_NW_FOUNTAIN_YOUTH';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_EFIRSTTOSOMETHING' WHERE Type = 'CITY_EVENT_NW_FUJI';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_EFIRSTTOSOMETHING' WHERE Type = 'CITY_EVENT_NW_MESA';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_EFIRSTTOSOMETHING' WHERE Type = 'CITY_EVENT_NW_REEF';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_EFIRSTTOSOMETHING' WHERE Type = 'CITY_EVENT_NW_KILIMANJARO';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_EFIRSTTOSOMETHING' WHERE Type = 'CITY_EVENT_NW_VOLCANO';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_EFIRSTTOSOMETHING' WHERE Type = 'CITY_EVENT_NW_LAKE_VICTORIA';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_EFIRSTTOSOMETHING' WHERE Type = 'CITY_EVENT_NW_MT_KAILASH';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_EFIRSTTOSOMETHING' WHERE Type = 'CITY_EVENT_NW_MT_SINAI';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_EFIRSTTOSOMETHING' WHERE Type = 'CITY_EVENT_NW_GEYSER';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_EFIRSTTOSOMETHING' WHERE Type = 'CITY_EVENT_NW_POTOSI';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_EFIRSTTOSOMETHING' WHERE Type = 'CITY_EVENT_NW_GIBRALTAR';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_EFIRSTTOSOMETHING' WHERE Type = 'CITY_EVENT_NW_SOLOMONS_MINES';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_EFIRSTTOSOMETHING' WHERE Type = 'CITY_EVENT_NW_SRI_PADA';
UPDATE CityEvents SET CityEventAudio = 'AS2D_EVENT_EFIRSTTOSOMETHING' WHERE Type = 'CITY_EVENT_NW_ULURU';