Lenin1870
Chieftain
- Joined
- Mar 16, 2013
- Messages
- 50
Code:
-----------------------------------------------
-- Types
-----------------------------------------------
INSERT INTO Types
(Type, Kind )
VALUES ('TRAIT_CIVILIZATION_SERVICE_CLUB_UA', 'KIND_TRAIT' ),
('MODTYPE_SERVICE_CLUB_UA_PRODUCTION', 'KIND_MODIFIER' );
-----------------------------------------------
-- Traits
-----------------------------------------------
INSERT INTO Traits
(TraitType, Name, Description )
VALUES ('TRAIT_CIVILIZATION_SERVICE_CLUB_UA', 'LOC_TRAIT_CIVILIZATION_SERVICE_CLUB_UA_NAME', 'LOC_TRAIT_CIVILIZATION_SERVICE_CLUB_UA_DESCRIPTION' );
-----------------------------------------------
-- CivilizationTraits
-----------------------------------------------
INSERT INTO CivilizationTraits
(CivilizationType, TraitType )
VALUES ('CIVILIZATION_SERVICE_CLUB', 'TRAIT_CIVILIZATION_SERVICE_CLUB_UA' );
-----------------------------------------------
-- TraitModifiers
-----------------------------------------------
INSERT INTO TraitModifiers
(TraitType, ModifierId )
VALUES ('TRAIT_CIVILIZATION_SERVICE_CLUB_UA', 'MODIFIER_SERVICE_CLUB_UA_PRODUCTION' );
-----------------------------------------------
-- EmergencyBuffs
-----------------------------------------------
INSERT INTO EmergencyBuffs (EmergencyType, ModifierId)
SELECT DISTINCT
EmergencyType,
'MODIFIER_SERVICE_CLUB_UA_PRODUCTION'
FROM EmergencyAlliances;
-----------------------------------------------
-- DynamicModifiers
-----------------------------------------------
INSERT INTO DynamicModifiers
(ModifierType, CollectionType, EffectType )
VALUES ('MODTYPE_SERVICE_CLUB_UA_PRODUCTION', 'COLLECTION_PLAYER_CITIES', 'EFFECT_ADJUST_BUILDING_YIELD_CHANGE' );
-----------------------------------------------
-- Modifiers
-----------------------------------------------
INSERT INTO Modifiers
(ModifierId, ModifierType, )
VALUES ('MODIFIER_SERVICE_CLUB_UA_PRODUCTION', 'MODTYPE_SERVICE_CLUB_UA_PRODUCTION' );
-----------------------------------------------
-- ModifierArguments
-----------------------------------------------
INSERT INTO ModifierArguments
(ModifierId, Name, Value )
VALUES ('MODIFIER_SERVICE_CLUB_UA_PRODUCTION', 'YieldType', 'YIELD_PRODUCTION' ),
('MODIFIER_SERVICE_CLUB_UA_PRODUCTION', 'Amount', 50 ),
-----------------------------------------------
-- RequirementSets
-----------------------------------------------
INSERT INTO RequirementSets
(RequirementSetId, RequirementSetType )
VALUES ('REQSET_SERVICE_CLUB_UA_IS_MEMBER', 'REQUIREMENTSET_TEST_ALL' ),
('REQSET_SERVICE_CLUB_UA_IS_TARGET', 'REQUIREMENTSET_TEST_ALL' );
-----------------------------------------------
-- RequirementSetRequirements
-----------------------------------------------
INSERT INTO RequirementSetRequirements
(RequirementSetId, RequirementId )
VALUES ('REQSET_SERVICE_CLUB_UA_IS_MEMBER', 'REQ_SERVICE_CLUB_UA_IS_MEMBER' ),
('REQSET_SERVICE_CLUB_UA_IS_MEMBER', 'REQ_CVS_PLAYER_IS_CHIBAN' ), -- Set in Civilization.sql
('REQSET_SERVICE_CLUB_UA_IS_TARGET', 'REQ_SERVICE_CLUB_UA_IS_TARGET' ),
('REQSET_SERVICE_CLUB_UA_IS_TARGET', 'REQ_CVS_PLAYER_IS_CHIBAN' ); -- Set in Civilization.sql
-----------------------------------------------
-- Requirements
-----------------------------------------------
INSERT INTO Requirements
(RequirementId, RequirementType, Inverse )
VALUES ('REQ_SERVICE_CLUB_UA_IS_MEMBER', 'REQUIREMENT_PLAYER_IS_EMERGENCY_TARGET', 1 ),
('REQ_SERVICE_CLUB_UA_IS_TARGET', 'REQUIREMENT_PLAYER_IS_EMERGENCY_TARGET', 0 );
Code:
-----------------------------------------------
-- Types
-----------------------------------------------
INSERT INTO Types
(Type, Kind )
VALUES ('TRAIT_LEADER_YUKINO_UA', 'KIND_TRAIT' );
-----------------------------------------------
-- Traits
-----------------------------------------------
INSERT INTO Traits
(TraitType, Name, Description )
VALUES ('TRAIT_LEADER_YUKINO_UA', 'LOC_TRAIT_LEADER_YUKINO_UA_NAME', 'LOC_TRAIT_LEADER_YUKINO_UA_DESCRIPTION' );
-----------------------------------------------
-- TraitModifiers
-----------------------------------------------
INSERT INTO TraitModifiers
(TraitType, ModifierId )
VALUES ('TRAIT_LEADER_YUKINO_UA', 'TRAIT_YUKINO_GRANT_ABILITY' ),
('TRAIT_LEADER_YUKINO_UA', 'TRAIT_YUKINO_DIPLOMATIC_FAVOR' ),
('TRAIT_LEADER_YUKINO_UA', 'TRAIT_YUKINO_GREAT_PEOPLE_POINTS' );
-----------------------------------------------
-- Modifiers
-----------------------------------------------
INSERT INTO Modifiers
(ModifierId, ModifierType, SubjectRequirementSetId )
VALUES ('TRAIT_YUKINO_GRANT_ABILITY', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER', 'PLAYER_HAS_LOW_CULTURE' ),
('TRAIT_YUKINO_GRANT_ABILITY', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER', 'PLAYER_HAS_LOW_SCIENCE' ),
('TRAIT_YUKINO_DIPLOMATIC_FAVOR', 'MODIFIER_PLAYER_ADD_FAVOR', 'PLAYER_HAS_GOLDEN_AGE' ),
('TRAIT_YUKINO_GREAT_PEOPLE_POINTS', 'MODIFIER_PLAYER_ADJUST_GREAT_PERSON_POINTS_PERCENT', 'PLAYER_HAS_GOLDEN_AGE' );
-----------------------------------------------
-- ModifierArguments
-----------------------------------------------
INSERT INTO ModifierArguments
(ModifierId, Name, Value )
VALUES ('TRAIT_YUKINO_GRANT_ABILITY', 'YieldType', 'Yield_SCIENCE' ),
('TRAIT_YUKINO_GRANT_ABILITY', 'YieldType', 'Yield_CULTURE' ),
('TRAIT_YUKINO_GRANT_ABILITY', 'Amount', '10' ),
('TRAIT_YUKINO_DIPLOMATIC_FAVOR', 'Favor', '1' ),
('TRAIT_YUKINO_DIPLOMATIC_FAVOR', 'Amount', '100' ),
('TRAIT_YUKINO_GREAT_PEOPLE_POINTS', 'GreatPersonClassType', 'GREAT_PERSON_CLASS_GENERAL' );
('TRAIT_YUKINO_GREAT_PEOPLE_POINTS', 'GreatPersonClassType', 'GREAT_PERSON_CLASS_ADMIRAL' );
('TRAIT_YUKINO_GREAT_PEOPLE_POINTS', 'GreatPersonClassType', 'GREAT_PERSON_CLASS_ENGINEER' );
('TRAIT_YUKINO_GREAT_PEOPLE_POINTS', 'GreatPersonClassType', 'GREAT_PERSON_CLASS_MERCHANT' );
('TRAIT_YUKINO_GREAT_PEOPLE_POINTS', 'GreatPersonClassType', 'GREAT_PERSON_CLASS_PROPHET' );
('TRAIT_YUKINO_GREAT_PEOPLE_POINTS', 'GreatPersonClassType', 'GREAT_PERSON_CLASS_SCIENTIST' );
('TRAIT_YUKINO_GREAT_PEOPLE_POINTS', 'GreatPersonClassType', 'GREAT_PERSON_CLASS_WRITER' );
('TRAIT_YUKINO_GREAT_PEOPLE_POINTS', 'Amount', '100' );
-----------------------------------------------
-- LeaderTraits
-----------------------------------------------
INSERT INTO LeaderTraits
(LeaderType, TraitType )
VALUES ('LEADER_YUKINO', 'TRAIT_LEADER_YUKINO_UA' );
I materialize my idea through SQL and Civ 6's modifiers, but I think my codes may have some issue. I'll appreciate if you check syntax and functional errors.
The link of My idea about Yukino: https://forums.civfanatics.com/thre...concrete-my-hoping-function-using-lua.656291/
About the Service Club Civ idea :
When SC Civ is diplomatic emergency, all cities of SC Civ have 50% production bonus until end of emergency.