Advertisement
Guest User

Untitled

a guest
Feb 13th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 6.67 KB | None | 0 0
  1. --==========================================================================================================================
  2. -- TRAITS
  3. --==========================================================================================================================
  4. -- Types
  5. -------------------------------------  
  6. INSERT INTO Types  
  7.         (TYPE,                                              Kind)
  8. VALUES  ('TRAIT_LEADER_FB_CAROLUS_REX',                     'KIND_TRAIT'        ),
  9.         ('TRAIT_CIVILIZATION_FB_STORMAKTSTIDEN',            'KIND_TRAIT');
  10.  
  11. -----------------------------------------------
  12. -- TraitModifiers
  13. -----------------------------------------------
  14.  
  15. INSERT INTO TraitModifiers 
  16.         (TraitType,                                     ModifierId                                  )
  17. VALUES  ('TRAIT_LEADER_FB_CAROLUS_REX',                 'MODIFIER_FB_KARL_UA_EMERGENCY_TARGET_STRENGTH' ),
  18.         ('TRAIT_CIVILIZATION_FB_STORMAKTSTIDEN',        'MODIFIER_FB_SWEDEN_CAMPUS_GOLDEN_AGE_YIELD'    ),
  19.         ('TRAIT_CIVILIZATION_FB_STORMAKTSTIDEN',        'MODIFIER_FB_SWEDEN_COMMERCIAL_GOLDEN_AGE_YIELD'    ),
  20.         ('TRAIT_CIVILIZATION_FB_STORMAKTSTIDEN',        'MODIFIER_FB_SWEDEN_INDUSTRIAL_GOLDEN_AGE_YIELD'    ),
  21.         ('TRAIT_CIVILIZATION_FB_STORMAKTSTIDEN',        'MODIFIER_FB_SWEDEN_HARBOR_GOLDEN_AGE_YIELD'    ),
  22.         ('TRAIT_CIVILIZATION_FB_STORMAKTSTIDEN',        'MODIFIER_FB_SWEDEN_THEATRE_GOLDEN_AGE_YIELD'   ),
  23.         ('TRAIT_CIVILIZATION_FB_STORMAKTSTIDEN',        'MODIFIER_FB_SWEDEN_HOLY_SITE_GOLDEN_AGE_YIELD' );
  24.  
  25.  
  26. -----------------------------------------------
  27. -- Modifiers
  28. -----------------------------------------------
  29.  
  30. INSERT INTO Modifiers
  31.         (ModifierId,                                        ModifierType,                               SubjectRequirementSetId             )
  32. VALUES  ('MODIFIER_FB_KARL_UA_EMERGENCY_TARGET_STRENGTH',   'MODIFIER_PLAYER_UNITS_ATTACH_MODIFIER',    'FB_SWEDEN_PLAYER_IS_EMERGENCY_TARGET'      ),
  33.         ('MODIFIER_FB_COMBAT_BONUS_EMERGENCY_TARGET',   'MODIFIER_UNIT_ADJUST_COMBAT_STRENGTH',     NULL        ),
  34.         ('MODIFIER_FB_SWEDEN_CAMPUS_GOLDEN_AGE_YIELD',  'MODIFIER_PLAYER_DISTRICT_ADJUST_YIELD_CHANGE',     'FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE'       ),
  35.         ('MODIFIER_FB_SWEDEN_INDUSTRIAL_GOLDEN_AGE_YIELD',  'MODIFIER_PLAYER_DISTRICT_ADJUST_YIELD_CHANGE',     'FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE_IND'       ),
  36.         ('MODIFIER_FB_SWEDEN_HARBOR_GOLDEN_AGE_YIELD',  'MODIFIER_PLAYER_DISTRICT_ADJUST_YIELD_CHANGE',     'FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE_HAR'       ),
  37.         ('MODIFIER_FB_SWEDEN_COMMERCIAL_GOLDEN_AGE_YIELD',  'MODIFIER_PLAYER_DISTRICT_ADJUST_YIELD_CHANGE',     'FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE_COM'       ),
  38.         ('MODIFIER_FB_SWEDEN_THEATRE_GOLDEN_AGE_YIELD', 'MODIFIER_PLAYER_DISTRICT_ADJUST_YIELD_CHANGE',     'FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE_THE'       ),
  39.         ('MODIFIER_FB_SWEDEN_HOLY_SITE_GOLDEN_AGE_YIELD',   'MODIFIER_PLAYER_DISTRICT_ADJUST_YIELD_CHANGE',     'FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE_HOL'       );
  40.        
  41. -----------------------------------------------
  42. -- ModifierArguments
  43. -----------------------------------------------
  44.  
  45. INSERT INTO ModifierArguments
  46.         (ModifierId,                                        Name,               VALUE   )
  47. VALUES  ('MODIFIER_FB_KARL_UA_EMERGENCY_TARGET_STRENGTH',   'ModifierID',       'MODIFIER_FB_COMBAT_BONUS_EMERGENCY_TARGET'     ),
  48.         ('MODIFIER_FB_COMBAT_BONUS_EMERGENCY_TARGET',   'Amount',           5           ),
  49.  
  50.         ('MODIFIER_FB_SWEDEN_CAMPUS_GOLDEN_AGE_YIELD',  'YieldType',        'YIELD_SCIENCE'         ),
  51.         ('MODIFIER_FB_SWEDEN_CAMPUS_GOLDEN_AGE_YIELD',  'Amount',           2           ),
  52.  
  53.         ('MODIFIER_FB_SWEDEN_INDUSTRIAL_GOLDEN_AGE_YIELD',  'YieldType',        'YIELD_PRODUCTION'          ),
  54.         ('MODIFIER_FB_SWEDEN_INDUSTRIAL_GOLDEN_AGE_YIELD',  'Amount',           2           ),
  55.  
  56.         ('MODIFIER_FB_SWEDEN_COMMERCIAL_GOLDEN_AGE_YIELD',  'YieldType',        'YIELD_GOLD'            ),
  57.         ('MODIFIER_FB_SWEDEN_COMMERCIAL_GOLDEN_AGE_YIELD',  'Amount',           2           ),
  58.  
  59.         ('MODIFIER_FB_SWEDEN_HARBOR_GOLDEN_AGE_YIELD',  'YieldType',        'YIELD_GOLD'            ),
  60.         ('MODIFIER_FB_SWEDEN_HARBOR_GOLDEN_AGE_YIELD',  'Amount',           2           ),
  61.  
  62.         ('MODIFIER_FB_SWEDEN_HOLY_SITE_GOLDEN_AGE_YIELD',   'YieldType',        'YIELD_FAITH'           ),
  63.         ('MODIFIER_FB_SWEDEN_HOLY_SITE_GOLDEN_AGE_YIELD',   'Amount',           2           ),
  64.  
  65.         ('MODIFIER_FB_SWEDEN_THEATRE_GOLDEN_AGE_YIELD', 'YieldType',        'YIELD_CULTURE'         ),
  66.         ('MODIFIER_FB_SWEDEN_THEATRE_GOLDEN_AGE_YIELD', 'Amount',           2           );
  67.        
  68.  
  69. --------------------------------------------------------------------------------------------------------------------------
  70. -- RequirementSets
  71. --------------------------------------------------------------------------------------------------------------------------
  72. INSERT INTO RequirementSets
  73.         (RequirementSetId,                                          RequirementSetType)
  74. VALUES  ('FB_SWEDEN_PLAYER_IS_EMERGENCY_TARGET',                          'REQUIREMENTSET_TEST_ALL'),
  75.         ('FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE',                          'REQUIREMENTSET_TEST_ALL'),
  76.         ('FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE_IND',                          'REQUIREMENTSET_TEST_ALL'),
  77.         ('FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE_THE',                          'REQUIREMENTSET_TEST_ALL'),
  78.         ('FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE_HAR',                          'REQUIREMENTSET_TEST_ALL'),
  79.         ('FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE_COM',                          'REQUIREMENTSET_TEST_ALL'),
  80.         ('FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE_HOL',                          'REQUIREMENTSET_TEST_ALL');
  81. --------------------------------------------------------------------------------------------------------------------------
  82. -- RequirementSetRequirements
  83. --------------------------------------------------------------------------------------------------------------------------
  84. INSERT INTO RequirementSetRequirements
  85.         (RequirementSetId,                                          RequirementId)
  86. VALUES  ('FB_SWEDEN_PLAYER_IS_EMERGENCY_TARGET',                         'REQUIRES_PLAYER_IS_EMERGENCY_TARGET'),
  87.        
  88.         ('FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE',                         'REQUIRES_PLAYER_HAS_GOLDEN_AGE'),
  89.         ('FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE',                         'REQUIRES_DISTRICT_IS_CAMPUS'),
  90.        
  91.         ('FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE_IND',                         'REQUIRES_PLAYER_HAS_GOLDEN_AGE'),
  92.         ('FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE_IND',                         'REQUIRES_DISTRICT_IS_INDUSTRIAL_ZONE'),
  93.        
  94.         ('FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE_THE',                         'REQUIRES_PLAYER_HAS_GOLDEN_AGE'),
  95.         ('FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE_THE',                         'REQUIRES_DISTRICT_IS_THEATER'),
  96.        
  97.         ('FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE_HAR',                         'REQUIRES_PLAYER_HAS_GOLDEN_AGE'),     
  98.         ('FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE_HAR',                         'REQUIRES_DISTRICT_IS_HARBOR'),
  99.        
  100.         ('FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE_COM',                         'REQUIRES_PLAYER_HAS_GOLDEN_AGE'),
  101.         ('FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE_COM',                         'REQUIRES_DISTRICT_IS_COMMERCIAL_HUB'),
  102.        
  103.         ('FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE_HOL',                         'REQUIRES_PLAYER_HAS_GOLDEN_AGE'),     
  104.         ('FB_SWEDEN_PLAYER_HAS_GOLDEN_AGE_HOL',                         'REQUIRES_DISTRICT_IS_HOLY_SITE');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement