-
Notifications
You must be signed in to change notification settings - Fork 0
/
SDG_Beliefs13_Naval.sql
26 lines (23 loc) · 2.53 KB
/
SDG_Beliefs13_Naval.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
-- ------------------------------------
-- ------------------------------------
-- Eternal Father Strong to Save
-- ------------------------------------
-- ------------------------------------
INSERT INTO Types (Type, Kind) VALUES ('SDG_ABILITY_ETERNAL_FATHER_HEAL', 'KIND_ABILITY') ;
INSERT INTO TypeTags (Type, Tag) VALUES ('SDG_ABILITY_ETERNAL_FATHER_HEAL', 'DB_CLASS_NAVAL_COMBAT') ;
INSERT INTO UnitAbilities (UnitAbilityType, Name, Description, Inactive) VALUES ('SDG_ABILITY_ETERNAL_FATHER_HEAL', 'LOC_SDG_ABILITY_ETERNAL_FATHER_HEAL_NAME', 'LOC_SDG_ABILITY_ETERNAL_FATHER_HEAL_DESCRIPTION', 1) ;
INSERT INTO UnitAbilityModifiers (UnitAbilityType, ModifierId) VALUES ('SDG_ABILITY_ETERNAL_FATHER_HEAL', 'SDG_ABILITY_EF_MODIFIER') ;
INSERT INTO Modifiers (ModifierId, ModifierType) VALUES ('SDG_ABILITY_EF_MODIFIER', 'MODIFIER_PLAYER_UNIT_ADJUST_HEAL_PER_TURN') ;
INSERT INTO ModifierArguments (ModifierId, Name, Value) VALUES
('SDG_ABILITY_EF_MODIFIER', 'Amount', 20),
('SDG_ABILITY_EF_MODIFIER', 'Type', 'NEUTRAL') ;
INSERT INTO Types (Type, Kind) VALUES ('SDG_ETERNAL_FATHER', 'KIND_BELIEF') ;
INSERT INTO BeliefClasses (BeliefClassType, Name, MaxInReligion, AdoptionOrder)
SELECT 'SDG_BELIEF_CLASS_NAVAL_' || (SELECT cast(COUNT(BeliefType) + 100 as text) FROM Beliefs WHERE BeliefClassType LIKE 'SDG_BELIEF_CLASS_%'), 'LOC_SDG_BELIEF_CLASS_NAVAL_NAME', 999, (SELECT COUNT(BeliefType) + 100 FROM Beliefs WHERE BeliefClassType LIKE 'SDG_BELIEF_CLASS_%') ;
INSERT INTO Beliefs (BeliefType, Name, Description, BeliefClassType)
SELECT 'SDG_ETERNAL_FATHER', 'LOC_SDG_ETERNAL_FATHER', 'LOC_SDG_ETERNAL_FATHER_DESCRIPTION', 'SDG_BELIEF_CLASS_NAVAL_' || (SELECT cast(COUNT(BeliefType) + 100 as text) FROM Beliefs WHERE BeliefClassType LIKE 'SDG_BELIEF_CLASS_%') ;
INSERT INTO BeliefModifiers (BeliefType, ModifierID) VALUES ('SDG_ETERNAL_FATHER', 'SDG_ETERNAL_FATHER_CITIES_ATTACH_MODIFIER') ;
INSERT INTO Modifiers (ModifierId, ModifierType, SubjectRequirementSetId) VALUES ('SDG_ETERNAL_FATHER_CITIES_ATTACH_MODIFIER', 'MODIFIER_ALL_CITIES_ATTACH_MODIFIER', 'CITY_FOLLOWS_RELIGION_REQUIREMENTS') ;
INSERT INTO ModifierArguments (ModifierId, Name, Value) VALUES ('SDG_ETERNAL_FATHER_CITIES_ATTACH_MODIFIER', 'ModifierId', 'SDG_ACTIVATE_EF_HEALING') ;
INSERT INTO Modifiers (ModifierId, ModifierType) VALUES ('SDG_ACTIVATE_EF_HEALING', 'MODIFIER_SINGLE_CITY_GRANT_ABILITY_FOR_TRAINED_UNITS') ;
INSERT INTO ModifierArguments (ModifierId, Name, Value) VALUES ('SDG_ACTIVATE_EF_HEALING', 'AbilityType', 'SDG_ABILITY_ETERNAL_FATHER_HEAL') ;