-
Notifications
You must be signed in to change notification settings - Fork 0
/
CompatibilityOptions.sql
219 lines (176 loc) · 6.99 KB
/
CompatibilityOptions.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
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
/*
________________ Vox Populi Mod Compatibility! ________________
Thank you for downloading the Vox Populi Mod Compatibility!
______________________ OPTIONS FOR VPMC _______________________
All options below are preset to the default values of this mod.
-- OPTIONS --
-- If you have not read the instructions above, please do so now!
-- Disabling files below will only require you to set the value to 0.
-- Almost all values are automatically set to 2 and if it detects a desired mod, it will be enabled to 1.
*/
/*
Chateau!
0 = Disabled (Default)
1 = Enabled
*/
INSERT INTO COMMUNITY (Type, Value)
VALUES ('CBPMC_CHATEAU', 0);
/*
Brazilwood Camp!
0 = Disabled disregarding if its detects the Brazilwood Camp by BlouBlou.
1 = Force Enable regardless if it detects the Brazilwood Camp by BlouBlou and VP.
2 = Disabled until it detects something! (Default)
*/
INSERT INTO COMMUNITY (Type, Value)
VALUES ('CBPMC_BRAZILWOOD_CAMP', 2);
/*
Kasbah!
0 = Disabled disregarding if its detects the Kasbah by BlouBlou.
1 = Enabled if it detects the Kasbah by BlouBlou and VP.
2 = Disabled until it detects something! (Default)
*/
INSERT INTO COMMUNITY (Type, Value)
VALUES ('CBPMC_KASBAH', 2);
/*
Moai!
0 = Disabled disregarding if its detects the Moais by BlouBlou.
1 = Force Enable regardless if it detects the Moais by BlouBlou and VP.
2 = Disabled until it detects something! (Default)
*/
INSERT INTO COMMUNITY (Type, Value)
VALUES ('CBPMC_MOAI', 2);
/*
Motte-and-Bailey Fort!
0 = Disabled disregarding if its detects the Motte-and-Bailey Fort by BlouBlou.
1 = Force Enable regardless if it detects the Motte-and-Bailey Fort by BlouBlou and VP.
2 = Disabled until it detects something! (Default)
*/
INSERT INTO COMMUNITY (Type, Value)
VALUES ('CBPMC_MOTTE', 2);
/*
Polders!
0 = Disabled disregarding if its detects the Polders by BlouBlou.
1 = Force Enable regardless if it detects the Polders by BlouBlou and VP.
2 = Disabled until it detects something! (Default)
*/
INSERT INTO COMMUNITY (Type, Value)
VALUES ('CBPMC_POLDER', 2);
/*
Terrace Farm!
0 = Disabled disregarding if its detects the Terrace Farm by BlouBlou.
1 = Force Enable regardless if it detects the Terrace Farm by BlouBlou and VP.
2 = Disabled until it detects something! (Default)
*/
INSERT INTO COMMUNITY (Type, Value)
VALUES ('CBPMC_TERRACE_FARM', 2);
/*
Industrial Buildings!
0 = Disabled disregarding if its detects the Industrial Buildings by thecrazyscotsman.
1 = Force Enable regardless if it detects the Industrial Buildings by thecrazyscotsman and VP.
2 = Disabled until it detects something! (Default)
*/
INSERT INTO COMMUNITY (Type, Value)
VALUES ('CBPMC_INDUSTRIAL', 2);
/*
Medieval and Renaissance Buildings!
0 = Disabled disregarding if its detects the Medieval and Renaissance Buildings Pack by thecrazyscotsman.
1 = Force Enable regardless if it detects the Medieval and Renaissance Buildings Pack by thecrazyscotsman and VP.
2 = Disabled until it detects something! (Default)
*/
INSERT INTO COMMUNITY (Type, Value)
VALUES ('CBPMC_MEDIRENA', 2);
/*
Strategic Buildings!
0 = Disabled disregarding if its detects the Strategic Buildings by thecrazyscotsman.
1 = Force Enable regardless if it detects the Strategic Buildings by thecrazyscotsman and VP.
2 = Disabled until it detects something! (Default)
*/
INSERT INTO COMMUNITY (Type, Value)
VALUES ('CBPMC_STRATEGIC', 2);
/*
National Wonders!
0 = Disabled disregarding if its detects the National Wonders Collection by theframedarchitecture.
1 = Force Enable regardless if it detects the National Wonders Collection by theframedarchitecture and VP.
2 = Disabled until it detects something! (Default)
*/
INSERT INTO COMMUNITY (Type, Value)
VALUES ('CBPMC_NATIONAL', 2);
/*
Additional Industrial Buildings!
0 = Disabled disregarding if its detects the Additional Industrial Buildings by lordplane.
1 = Force Enable regardless if it detects the Additional Industrial Buildings by lordplane and VP.
2 = Disabled until it detects something! (Default)
*/
INSERT INTO COMMUNITY (Type, Value)
VALUES ('CBPMC_ADDINDUSTRIAL', 2);
/*
Strategic Resource Buildings!
0 = Disabled disregarding if its detects the Strategic Resource Buildings by Kelaris.
1 = Force Enable regardless if it detects the Strategic Resource Buildings by Kelaris and VP.
2 = Disabled until it detects something! (Default)
*/
INSERT INTO COMMUNITY (Type, Value)
VALUES ('CBPMC_RESBUILDING', 2);
--======================================--
-- MOD SETUP (DO NOT CHANGE ANY VALUE!) --
--======================================--
UPDATE COMMUNITY
SET Value = '1'
WHERE Type = 'CBPMC_BRAZILWOOD_CAMP'
AND EXISTS (SELECT * FROM Buildings WHERE Type='BUILDING_JCHURCH')
AND NOT EXISTS (SELECT * FROM COMMUNITY WHERE Type='CBPMC_BRAZILWOOD_CAMP' AND Value= 0);
UPDATE COMMUNITY
SET Value = '1'
WHERE Type = 'CBPMC_KASBAH'
AND EXISTS (SELECT * FROM Buildings WHERE Type='BUILDING_RIAD')
AND NOT EXISTS (SELECT * FROM COMMUNITY WHERE Type='CBPMC_KASBAH' AND Value= 0);
UPDATE COMMUNITY
SET Value = '1'
WHERE Type = 'CBPMC_MOAI'
AND EXISTS (SELECT * FROM Buildings WHERE Type='BUILDING_MARA')
AND NOT EXISTS (SELECT * FROM COMMUNITY WHERE Type='CBPMC_MOAI' AND Value= 0);
UPDATE COMMUNITY
SET Value = '1'
WHERE Type = 'CBPMC_MOTTE'
AND EXISTS (SELECT * FROM Improvements WHERE Type='IMPROVEMENT_MAB')
AND NOT EXISTS (SELECT * FROM COMMUNITY WHERE Type='CBPMC_MOTTE' AND Value= 0);
UPDATE COMMUNITY
SET Value = '1'
WHERE Type = 'CBPMC_POLDER'
AND EXISTS (SELECT * FROM Buildings WHERE Type='BUILDING_WIMMEN')
AND NOT EXISTS (SELECT * FROM COMMUNITY WHERE Type='CBPMC_POLDER' AND Value= 0);
UPDATE COMMUNITY
SET Value = '1'
WHERE Type = 'CBPMC_TERRACE_FARM'
AND EXISTS (SELECT * FROM Buildings WHERE Type='BUILDING_STEMPLES')
AND NOT EXISTS (SELECT * FROM COMMUNITY WHERE Type='CBPMC_TERRACE_FARM' AND Value= 0);
UPDATE COMMUNITY
SET Value = '1'
WHERE Type = 'CBPMC_INDUSTRIAL'
AND EXISTS (SELECT * FROM Buildings WHERE Type='BUILDING_CHEMIST')
AND NOT EXISTS (SELECT * FROM COMMUNITY WHERE Type='CBPMC_INDUSTRIAL' AND Value= 0);
UPDATE COMMUNITY
SET Value = '1'
WHERE Type = 'CBPMC_MEDIRENA'
AND EXISTS (SELECT * FROM Buildings WHERE Type='BUILDING_PRINTER')
AND NOT EXISTS (SELECT * FROM COMMUNITY WHERE Type='CBPMC_MEDIRENA' AND Value= 0);
UPDATE COMMUNITY
SET Value = '1'
WHERE Type = 'CBPMC_STRATEGIC'
AND EXISTS (SELECT * FROM Buildings WHERE Type='BUILDING_SCHOOL_OF_EQUESTRIAN_ART')
AND NOT EXISTS (SELECT * FROM COMMUNITY WHERE Type='CBPMC_STRATEGIC' AND Value= 0);
UPDATE COMMUNITY
SET Value = '1'
WHERE Type = 'CBPMC_NATIONAL'
AND EXISTS (SELECT * FROM Buildings WHERE Type='BUILDING_FA_ELECTRIC_CO')
AND NOT EXISTS (SELECT * FROM COMMUNITY WHERE Type='CBPMC_NATIONAL' AND Value= 0);
UPDATE COMMUNITY
SET Value = '1'
WHERE Type = 'CBPMC_ADDINDUSTRIAL'
AND EXISTS (SELECT * FROM Buildings WHERE Type='BUILDING_SYNTHFUEL_PLANT')
AND NOT EXISTS (SELECT * FROM COMMUNITY WHERE Type='CBPMC_ADDINDUSTRIAL' AND Value= 0);
UPDATE COMMUNITY
SET Value = '1'
WHERE Type = 'CBPMC_RESBUILDING'
AND EXISTS (SELECT * FROM Buildings WHERE Type='BUILDING_CORRAL')
AND NOT EXISTS (SELECT * FROM COMMUNITY WHERE Type='CBPMC_RESBUILDING' AND Value= 0);