Advertisement
Guest User

Untitled

a guest
Oct 23rd, 2019
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.08 KB | None | 0 0
  1. REPLACE INTO Requirements(RequirementId, RequirementType, Likeliness, Impact, Inverse, Reverse, Persistent, ProgressWeight, Triggered)
  2. Values
  3. ('REQUIRES_CITY_HAS_CAMPUS', 'REQUIREMENT_CITY_HAS_DISTRICT', 0, 0, 0, 0, 0, 1, 0);
  4.  
  5. REPLACE INTO Requirements(RequirementId, RequirementType, Likeliness, Impact, Inverse, Reverse, Persistent, ProgressWeight, Triggered)
  6. Values
  7. ('REQUIRES_CITY_HAS_HOLY_SITE', 'REQUIREMENT_CITY_HAS_DISTRICT', 0, 0, 0, 0, 0, 1, 0);
  8.  
  9.  
  10. REPLACE INTO Requirements(RequirementId, RequirementType, Likeliness, Impact, Inverse, Reverse, Persistent, ProgressWeight, Triggered)
  11. Values
  12. ('REQUIRES_CITY_HAS_THEATER_DISTRICT', 'REQUIREMENT_CITY_HAS_DISTRICT', 0, 0, 0, 0, 0, 1, 0);
  13.  
  14. REPLACE INTO RequirementArguments(RequirementId, Name, Type, Value, Extra, SecondExtra)
  15. Values
  16. ('REQUIRES_CITY_HAS_CAMPUS', 'DistrictType', 'ARGTYPE_IDENTITY', 'DISTRICT_CAMPUS', NULL, NULL),
  17. ('REQUIRES_CITY_HAS_HOLY_SITE', 'DistrictType', 'ARGTYPE_IDENTITY', 'DISTRICT_HOLY_SITE', NULL, NULL),
  18. ('REQUIRES_CITY_HAS_THEATER_DISTRICT', 'DistrictType', 'ARGTYPE_IDENTITY', 'DISTRICT_THEATER_DISTRICT', NULL, NULL);
  19.  
  20.  
  21. REPLACE INTO RequirementSets(RequirementSetId, RequirementSetType)
  22. VALUES
  23. ('PLAYER_HAS_CAMPUSES', 'REQUIREMENTSET_TEST_ALL'),
  24. ('PLAYER_HAS_HOLY_SITES', 'REQUIREMENTSET_TEST_ALL'),
  25. ('PLAYER_HAS_THEATER_DISTRICTS', 'REQUIREMENTSET_TEST_ALL');
  26.  
  27. REPLACE INTO RequirementSetRequirements(RequirementSetId, RequirementId)
  28. VALUES
  29. ('PLAYER_HAS_CAMPUSES', 'REQUIRES_CITY_HAS_CAMPUS'),
  30. ('PLAYER_HAS_HOLY_SITES', 'REQUIRES_CITY_HAS_HOLY_SITE'),
  31. ('PLAYER_HAS_THEATER_DISTRICTS', 'REQUIRES_CITY_HAS_THEATER_DISTRICT');
  32.  
  33. REPLACE INTO Modifiers (ModifierId, ModifierType, RunOnce, NewOnly, Permanent, OwnerRequirementSetId, SubjectRequirementSetId, OwnerStackLimit, SubjectStackLimit)
  34. VALUES
  35. ('PLAYER_SCIENCE_PENALTY', 'MODIFIER_ALL_CITIES_ATTACH_MODIFIER', 0, 0, 0, NULL, 'PLAYER_HAS_CAMPUSES', NULL, NULL),
  36. ('PLAYER_SCIENCE_PENALTY_MODIFIER', 'MODIFIER_PLAYER_CAPITAL_CITY_ADJUST_CITY_YIELD_CHANGE', 0, 0, 0, NULL, 'PLAYER_HAS_CAMPUSES', NULL, NULL);
  37.  
  38.  
  39. --MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER
  40. REPLACE INTO Modifiers (ModifierId, ModifierType, RunOnce, NewOnly, Permanent, OwnerRequirementSetId, SubjectRequirementSetId, OwnerStackLimit, SubjectStackLimit)
  41. VALUES
  42. ('PLAYER_FAITH_PENALTY', 'MODIFIER_ALL_CITIES_ATTACH_MODIFIER', 0, 0, 0, NULL, 'PLAYER_HAS_HOLY_SITES', NULL, NULL),
  43. ('PLAYER_FAITH_PENALTY_MODIFIER', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER', 0, 0, 0, NULL, 'PLAYER_HAS_HOLY_SITES', NULL, NULL);
  44.  
  45. REPLACE INTO Modifiers (ModifierId, ModifierType, RunOnce, NewOnly, Permanent, OwnerRequirementSetId, SubjectRequirementSetId, OwnerStackLimit, SubjectStackLimit)
  46. VALUES
  47. ('PLAYER_CULTURE_PENALTY', 'MODIFIER_ALL_CITIES_ATTACH_MODIFIER', 0, 0, 0, NULL, 'PLAYER_HAS_THEATER_DISTRICTS', NULL, NULL),
  48. ('PLAYER_CULTURE_PENALTY_MODIFIER', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_MODIFIER', 0, 0, 0, NULL, 'PLAYER_HAS_THEATER_DISTRICTS', NULL, NULL);
  49.  
  50. REPLACE INTO ModifierArguments (ModifierId, Name, Type, Value, Extra, SecondExtra)
  51. VALUES
  52. ('PLAYER_SCIENCE_PENALTY', 'ModifierId', 'ARGTYPE_IDENTITY', 'PLAYER_SCIENCE_PENALTY_MODIFIER', NULL, NULL),
  53. ('PLAYER_SCIENCE_PENALTY_MODIFIER', 'Amount', 'ARGTYPE_IDENTITY', 20, NULL, NULL),
  54. ('PLAYER_SCIENCE_PENALTY_MODIFIER', 'YieldType', 'ARGTYPE_IDENTITY', 'YIELD_SCIENCE', NULL, NULL);
  55.  
  56. REPLACE INTO ModifierArguments (ModifierId, Name, Type, Value, Extra, SecondExtra)
  57. VALUES
  58. ('PLAYER_FAITH_PENALTY', 'ModifierId', 'ARGTYPE_IDENTITY', 'PLAYER_FAITH_PENALTY_MODIFIER', NULL, NULL),
  59. ('PLAYER_FAITH_PENALTY_MODIFIER', 'Amount', 'ARGTYPE_IDENTITY', -40, NULL, NULL),
  60. ('PLAYER_FAITH_PENALTY_MODIFIER', 'YieldType', 'ARGTYPE_IDENTITY', 'YIELD_FAITH', NULL, NULL);
  61.  
  62. REPLACE INTO ModifierArguments (ModifierId, Name, Type, Value, Extra, SecondExtra)
  63. VALUES
  64. ('PLAYER_CULTURE_PENALTY', 'ModifierId', 'ARGTYPE_IDENTITY', 'PLAYER_CULTURE_PENALTY_MODIFIER', NULL, NULL),
  65. ('PLAYER_CULTURE_PENALTY_MODIFIER', 'Amount', 'ARGTYPE_IDENTITY', -20, NULL, NULL),
  66. ('PLAYER_CULTURE_PENALTY_MODIFIER', 'YieldType', 'ARGTYPE_IDENTITY', 'YIELD_CULTURE', NULL, NULL);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement