forked from adaneslavo/MUCfVP-EECompatibilityPatch
-
Notifications
You must be signed in to change notification settings - Fork 0
/
CompatibilityChanges.sql
199 lines (162 loc) · 7.06 KB
/
CompatibilityChanges.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
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
--Armada
UPDATE Unit_ClassUpgrades SET UnitClassType = 'UNITCLASS_EE_SHIP_OF_THE_LINE' WHERE UnitType = 'UNIT_SPAIN_ARMADA';
UPDATE Units SET ObsoleteTech = 'TECH_INDUSTRIALIZATION' WHERE Type = 'UNIT_SPAIN_ARMADA';
--Black Tug
UPDATE Units SET ObsoleteTech = 'TECH_RIFLING' WHERE Type = 'UNIT_MONGOLIA_BLACK_TUG';
--Cacadores
UPDATE Unit_ClassUpgrades SET UnitClassType = 'UNITCLASS_GATLINGGUN' WHERE UnitType = 'UNIT_PORTUGUESE_CACADORES';
UPDATE Units SET ObsoleteTech = 'TECH_BALLISTICS' WHERE Type = 'UNIT_PORTUGUESE_CACADORES';
--Fusta
UPDATE Unit_ClassUpgrades SET UnitClassType = 'UNITCLASS_EE_GALLEON' WHERE UnitType = 'UNIT_VENICE_FUSTA';
UPDATE Units SET ObsoleteTech = 'TECH_EE_WARSHIPS' WHERE Type = 'UNIT_VENICE_FUSTA';
--Great Bombard
UPDATE Unit_ClassUpgrades SET UnitClassType = 'UNITCLASS_EE_FIELD_GUN' WHERE UnitType = 'UNIT_OTTOMANS_GREAT_TURKISH_BOMBARD';
UPDATE Units SET ObsoleteTech = 'TECH_RIFLING' WHERE Type = 'UNIT_OTTOMANS_GREAT_TURKISH_BOMBARD';
--Great Galleas
UPDATE Unit_ClassUpgrades SET UnitClassType = 'UNITCLASS_EE_GALLEON' WHERE UnitType = 'UNIT_VENETIAN_GALLEASS';
UPDATE Units SET ObsoleteTech = 'TECH_EE_WARSHIPS' WHERE Type = 'UNIT_VENETIAN_GALLEASS';
--Hakkapeliitta
UPDATE Unit_ClassUpgrades SET UnitClassType = 'UNITCLASS_EE_UHLAN' WHERE UnitType = 'UNIT_SWEDISH_HAKKAPELIITTA';
UPDATE Units SET ObsoleteTech = 'TECH_COMBUSTION' WHERE Type = 'UNIT_SWEDISH_HAKKAPELIITTA';
--Klepht
UPDATE Unit_ClassUpgrades SET UnitClassType = 'UNITCLASS_GATLINGGUN' WHERE UnitType = 'UNIT_GREECE_KLEPHT';
UPDATE Units SET ObsoleteTech = 'TECH_BALLISTICS' WHERE Type = 'UNIT_GREECE_KLEPHT';
--Langskib
UPDATE Unit_ClassUpgrades SET UnitClassType = 'UNITCLASS_EE_CARRACK' WHERE UnitType = 'UNIT_DENMARK_LANGSKIB';
UPDATE Units SET ObsoleteTech = 'TECH_NAVIGATION' WHERE Type = 'UNIT_DENMARK_LANGSKIB';
--Mandekalu Cavalry
UPDATE Units SET ObsoleteTech = 'TECH_RIFLING' WHERE Type = 'UNIT_SONGHAI_MUSLIMCAVALRY';
--Prowler
UPDATE Unit_ClassUpgrades SET UnitClassType = 'UNITCLASS_EE_SKIRMISHER' WHERE UnitType = 'UNIT_IROQUOIS_PROWLER';
UPDATE Units SET ObsoleteTech = 'TECH_DYNAMITE' WHERE Type = 'UNIT_IROQUOIS_PROWLER';
--Qizilbash
UPDATE Unit_ClassUpgrades SET UnitClassType = 'UNITCLASS_EE_UHLAN' WHERE UnitType = 'UNIT_PERSIA_QIZILBASH';
UPDATE Units SET ObsoleteTech = 'TECH_COMBUSTION' WHERE Type = 'UNIT_PERSIA_QIZILBASH';
--Sofa
UPDATE Unit_ClassUpgrades SET UnitClassType = 'UNITCLASS_EE_SKIRMISHER' WHERE UnitType = 'UNIT_SONGHAI_SOFA';
UPDATE Units SET ObsoleteTech = 'TECH_DYNAMITE' WHERE Type = 'UNIT_SONGHAI_SOFA';
--Turtle Ship
UPDATE Units SET ObsoleteTech = 'TECH_EE_WARSHIPS' WHERE Type = 'UNIT_KOREAN_TURTLE_SHIP';
--Prau
UPDATE Units SET ObsoleteTech = 'TECH_EE_EXPLORATION' WHERE Type = 'UNIT_INDONESIA_PRAU';
--Dromon
UPDATE Units SET ObsoleteTech = 'TECH_EE_WARSHIPS' WHERE Type = 'UNIT_BYZANTIUM_DROMON';
--Shotel Swordsman
UPDATE Unit_ClassUpgrades SET UnitClassType = 'UNITCLASS_2HANDER' WHERE UnitType = 'UNIT_ETHIOPIA_SHOTELAI';
UPDATE Units SET ObsoleteTech = 'TECH_EE_FLINTLOCK' WHERE Type = 'UNIT_ETHIOPIA_SHOTELAI';
--Licorne
UPDATE Unit_ClassUpgrades SET UnitClassType = 'UNITCLASS_FIELD_GUN' WHERE UnitType = 'UNIT_RUSSIA_LICORNE';
UPDATE Units SET ObsoleteTech = 'TECH_BALLISTICS' WHERE Type = 'UNIT_RUSSIA_LICORNE';
Units:
China (Xiafan Guanjun, (Frigate))
Spoiler :
Unlock at Navigation
Morocco (Corsair -> Ship of the Line)
Spoiler :
set unitcombat to 35 (same as base SotL)
Unlocks at Navigation
400 production
flagship promotion
Spain (Armada (Corvette))
Spoiler :
Unlocks at Exploration
350 production
Greek (Klepht -> light infantry) --currently gatling gun
Spoiler :
Replace light infantry
Unlocks at Fortification
35RCS
19 CS
Light Skirmish promotion
325 production
Portugal (Cacadores -> light infantry) --currently gatling gun
Spoiler :
replaces light infantry
unlocks at fortification
Light Skirmish promotion
375 production
35 RCS
21 CS
Korea (Kobukseon >Carrack) -- currently caravel
Spoiler :
Replaces Carrack
Unlocked at exploration
3 movement (still has double move in coast)
250 production
38 CS
Russia (Licorne > Field Gun)
Spoiler :
Field Gun replacement
unlocked at Flintlock
375 production
35RCS
18CS
Siam (Seir Morb > Field Gun)
Spoiler :
Stays as VP field gun replacement (renamed Howitzer)
3 Range
Buildings:
England (White Tower -> Tower of Buddhist Incense) -- currently hermitage
Spoiler :
UW: White Tower - Tower of Buddhist Incense Replacement
Available at Sovereignty
Requires Castle in City (instead of Manor and Garden)
+5:c5strength: City Defense
+3:c5culture: culture (up from +2)
+2:c5culture: culture to Castles on Empire
+3:c5gold: Gold to Constabulary in City
+3:c5food: Food to Arsenal in City
1 Free Great Person of your choice
-10% :c5unhappy:Religious needs modifier
-25% spy stealing rate on empire
+1 :c5happy:Happiness for every enemy spy killed (permanent)
2 :greatwork:Great works of Art slot, +3 :c5gold:Gold and +3 :c5culture:Culture if themed
Comes with 1 free art: The Crown Jewels
Dutch (Waag -> weigh house) -- currently bank
Spoiler :
UB: Waag - Weigh House
Unlocked at Economics (1 tech earlier)
Requires Market (instead of Bank)
750:c5production: (down from 900)
5 :c5gold:Gold (up from 3:c5gold:)
+3:c5gold: to Market in city
1:c5citizen: Merchant Specialists Slot
+2% :c5greatperson: GPP and 2 :c5strength: CP in the city for every imported/exported luxury resource from other empires
1:c5gold: Gold for every 2:c5citizen:pop (up from 1 for 4 pop)
-10%:c5unhappy: poverty in city
Austrian (Schutzenstand -> gunsmith) -- currently arsenal
Spoiler :
UB - Schutzenstand - Gunsmith
Unlocks at Flintlock
750:c5production:
3:c5gold: maintenance
+3 :c5culture: Culture, +3 :c5production: Production
+30% :c5production: production to Gunpowder units and an additional 25XP for Gunpowder units
+15% :c5production:production to land military units
+2 :c5war:Supply cap
+1:c5production: Production and +1:c5culture: Culture for each allied CS
French (Grande ecole -> academy) -- currently public school
Spoiler :
UB - Grande École (Public School) Available at Humanism
Can be built in city with a salon (not mutually exclusive building)
750:c5production: Prod
5:c5gold: Maintenance (up from 3)
+3 :c5science: Science, +1 :c5culture: Culture, +2 :c5production: Production (up from 2 science)
1 Scientist Specialist
+2 :c5science: Science & +1 :c5production: Production for every 5 :c5citizen: Citizens in the City (up from 1 science for every 5 citizens)
+2:c5production: Production for Scientist Specialist & +2 :c5science:Science for Engineers in city
-20% :c5unhappy: Illiteracy in city
+2 :c5production:Production and +2 :c5science:Science at Computers.
Brazil (Sambadrome -> Salon) --currently opera house
Spoiler :
UB: Samba School (Opera House)
Available at Humanism
Can be built in city with an academy (not mutually exclusive building)
750:c5production: Prod
3:c5gold: maintenance
+4:c5culture: Culture, +4:c5goldenage:GAP (up from +2:c5culture: only)
1:c5culture: for every 6:c5citizen: population in city
1 Musician specialist slot
Musicians in city produce +1 :c5gold:gold and +2 :c5goldenage:GAP
+25% :c5goldenage:GAP during golden age
+2:tourism: Tourism at Radio