Guest User

more.slots.sql

a guest
Aug 16th, 2024
27
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.83 KB | None | 0 0
  1. --
  2.  
  3. ---me messing around with GPP slots
  4.  
  5. --update medici to give 10 slots to the bank
  6.  
  7.  
  8. UPDATE ModifierArguments SET Value = 'GREATWORKSLOT_PRODUCT' WHERE Name = 'GreatWorkSlotType' AND ModifierId = 'GREATPERSON_BANK_GREAT_WORK_SLOTS';
  9. UPDATE ModifierArguments SET Value = 8 WHERE Name = 'Amount' AND ModifierId = 'GREATPERSON_BANK_GREAT_WORK_SLOTS';
  10. UPDATE ModifierArguments SET Value = 'BUILDING_JNR_WAYSTATION' WHERE ModifierId='GREATPERSON_BANK_GREAT_WORK_SLOTS' AND Name = 'BuildingType'; */
  11.  
  12.  
  13.  
  14.  
  15.  
  16. INSERT OR REPLACE INTO GreatPersonIndividualActionModifiers
  17. (GreatPersonIndividualType, ModifierId, AttachmentTargetType)
  18. VALUES
  19. -- note: city centre
  20. ('GREAT_PERSON_INDIVIDUAL_SARAH_BREEDLOVE', 'GREATPERSON_BARRIER_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  21. ('GREAT_PERSON_INDIVIDUAL_SARAH_BREEDLOVE', 'GREATPERSON_GRANARY_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  22. ('GREAT_PERSON_INDIVIDUAL_SARAH_BREEDLOVE', 'GREATPERSON_MONUMENT_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  23. ('GREAT_PERSON_INDIVIDUAL_SARAH_BREEDLOVE', 'GREATPERSON_IRRIGATION_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE');
  24.  
  25.  
  26.  
  27.  
  28.  
  29.  
  30. INSERT OR REPLACE INTO GreatPersonIndividualActionModifiers
  31. (GreatPersonIndividualType, ModifierId, AttachmentTargetType)
  32. VALUES
  33. ('', 'GREATPERSON_OFFSHORE_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  34. ('', 'GREATPERSON_HANGAR_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  35. ('', 'GREATPERSON_AIRPORT_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  36. -- note: city centre
  37. ('', 'GREATPERSON_BARRIER_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  38. ('', 'GREATPERSON_GRANARY_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  39. ('', 'GREATPERSON_MONUMENT_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  40. ('', 'GREATPERSON_IRRIGATION_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  41. -- note: commercial,
  42. ('', 'GREATPERSON_BANK_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  43. ('', 'GREATPERSON_MERCHANT_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  44. ('', 'GREATPERSON_WAYSTATION_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  45. ('', 'GREATPERSON_STOCK_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  46. ('', 'GREATPERSON_COMMODITY_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  47. -- note: science
  48. ('', 'GREATPERSON_UNIVERSITY_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  49. ('', 'GREATPERSON_IOT_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  50. ('', 'GREATPERSON_LAB_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  51. -- note: industrial,
  52. ('', 'GREATPERSON_WORKSHOP_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  53. ('', 'GREATPERSON_MANUFACTORY_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  54. ('', 'GREATPERSON_FACTORY_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  55. ('', 'GREATPERSON_PLANT_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  56. ('', 'GREATPERSON_LOGISTICS_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE'),
  57. ('', 'GREATPERSON_BATTERY_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE')
  58. ;
  59.  
  60.  
  61.  
  62.  
  63. -- EMPORIUM = WAYSTATION
  64.  
  65.  
  66. INSERT OR REPLACE INTO Modifiers
  67. (ModifierId, ModifierType, RunOnce, Permanent )
  68. VALUES
  69. ('GREATPERSON_OFFSHORE_GREAT_WORK_SLOTS', 'MODIFIER_SINGLE_CITY_ADJUST_EXTRA_GREAT_WORK_SLOTS', 1, 1 ),
  70. ('GREATPERSON_HANGAR_GREAT_WORK_SLOTS', 'MODIFIER_SINGLE_CITY_ADJUST_EXTRA_GREAT_WORK_SLOTS', 1, 1 ),
  71. ('GREATPERSON_AIRPORT_GREAT_WORK_SLOTS', 'MODIFIER_SINGLE_CITY_ADJUST_EXTRA_GREAT_WORK_SLOTS', 1, 1 ),
  72. -- note: city centre
  73. ('GREATPERSON_GRANARY_GREAT_WORK_SLOTS', 'MODIFIER_SINGLE_CITY_ADJUST_EXTRA_GREAT_WORK_SLOTS', 1, 1 ),
  74. ('GREATPERSON_MONUMENT_GREAT_WORK_SLOTS', 'MODIFIER_SINGLE_CITY_ADJUST_EXTRA_GREAT_WORK_SLOTS', 1, 1 ),
  75. ('GREATPERSON_IRRIGATION_GREAT_WORK_SLOTS', 'MODIFIER_SINGLE_CITY_ADJUST_EXTRA_GREAT_WORK_SLOTS', 1, 1 ),
  76. ('GREATPERSON_BARRIER_GREAT_WORK_SLOTS', 'MODIFIER_SINGLE_CITY_ADJUST_EXTRA_GREAT_WORK_SLOTS', 1, 1 ),
  77. -- note: commercial
  78. ('GREATPERSON_BANK_GREAT_WORK_SLOTS', 'MODIFIER_SINGLE_CITY_ADJUST_EXTRA_GREAT_WORK_SLOTS', 1, 1 ),
  79. ('GREATPERSON_MERCHANT_GREAT_WORK_SLOTS', 'MODIFIER_SINGLE_CITY_ADJUST_EXTRA_GREAT_WORK_SLOTS', 1, 1 ),
  80. ('GREATPERSON_WAYSTATION_GREAT_WORK_SLOTS', 'MODIFIER_SINGLE_CITY_ADJUST_EXTRA_GREAT_WORK_SLOTS', 1, 1 ),
  81. ('GREATPERSON_STOCK_GREAT_WORK_SLOTS', 'MODIFIER_SINGLE_CITY_ADJUST_EXTRA_GREAT_WORK_SLOTS', 1, 1 ),
  82. ('GREATPERSON_COMMODITY_GREAT_WORK_SLOTS', 'MODIFIER_SINGLE_CITY_ADJUST_EXTRA_GREAT_WORK_SLOTS', 1, 1 ),
  83. -- note: science
  84. ('GREATPERSON_UNIVERSITY_GREAT_WORK_SLOTS', 'MODIFIER_SINGLE_CITY_ADJUST_EXTRA_GREAT_WORK_SLOTS', 1, 1 ),
  85. ('GREATPERSON_IOT_GREAT_WORK_SLOTS', 'MODIFIER_SINGLE_CITY_ADJUST_EXTRA_GREAT_WORK_SLOTS', 1, 1 ),
  86. ('GREATPERSON_LAB_GREAT_WORK_SLOTS', 'MODIFIER_SINGLE_CITY_ADJUST_EXTRA_GREAT_WORK_SLOTS', 1, 1 ),
  87. -- note: industrial zone
  88. ('GREATPERSON_WORKSHOP_GREAT_WORK_SLOTS', 'MODIFIER_SINGLE_CITY_ADJUST_EXTRA_GREAT_WORK_SLOTS', 1, 1 ),
  89. ('GREATPERSON_MANUFACTORY_GREAT_WORK_SLOTS', 'MODIFIER_SINGLE_CITY_ADJUST_EXTRA_GREAT_WORK_SLOTS', 1, 1 ),
  90. ('GREATPERSON_FACTORY_GREAT_WORK_SLOTS', 'MODIFIER_SINGLE_CITY_ADJUST_EXTRA_GREAT_WORK_SLOTS', 1, 1 ),
  91. ('GREATPERSON_PLANT_GREAT_WORK_SLOTS', 'MODIFIER_SINGLE_CITY_ADJUST_EXTRA_GREAT_WORK_SLOTS', 1, 1 ),
  92. ('GREATPERSON_LOGISTICS_GREAT_WORK_SLOTS', 'MODIFIER_SINGLE_CITY_ADJUST_EXTRA_GREAT_WORK_SLOTS', 1, 1 ),
  93. ('GREATPERSON_BATTERY_GREAT_WORK_SLOTS', 'MODIFIER_SINGLE_CITY_ADJUST_EXTRA_GREAT_WORK_SLOTS', 1, 1 );
  94.  
  95.  
  96. INSERT OR REPLACE INTO ModifierArguments
  97. (ModifierId, Name, Value )
  98. VALUES
  99. ('GREATPERSON_HANGAR_GREAT_WORK_SLOTS', 'BuildingType', 'BUILDING_HANGAR' ),
  100. ('GREATPERSON_HANGAR_GREAT_WORK_SLOTS', 'GreatWorkSlotType', 'GREATWORKSLOT_PRODUCT' ),
  101. ('GREATPERSON_HANGAR_GREAT_WORK_SLOTS', 'Amount', 4 ),
  102. ('GREATPERSON_AIRPORT_GREAT_WORK_SLOTS', 'BuildingType', 'BUILDING_AIRPORT' ),
  103. ('GREATPERSON_AIRPORT_GREAT_WORK_SLOTS', 'GreatWorkSlotType', 'GREATWORKSLOT_PRODUCT' ),
  104. ('GREATPERSON_AIRPORT_GREAT_WORK_SLOTS', 'Amount', 4 ),
  105. ('GREATPERSON_OFFSHORE_GREAT_WORK_SLOTS', 'BuildingType', 'BUILDING_JNR_COMMODITY_EXCHANGE' ),
  106. ('GREATPERSON_OFFSHORE_GREAT_WORK_SLOTS', 'GreatWorkSlotType', 'GREATWORKSLOT_PRODUCT' ),
  107. ('GREATPERSON_OFFSHORE_GREAT_WORK_SLOTS', 'Amount', 4 ),
  108. -- note: science
  109. ('GREATPERSON_UNIVERSITY_GREAT_WORK_SLOTS', 'BuildingType', 'BUILDING_UNIVERSITY' ),
  110. ('GREATPERSON_UNIVERSITY_GREAT_WORK_SLOTS', 'GreatWorkSlotType', 'GREATWORKSLOT_PRODUCT' ),
  111. ('GREATPERSON_UNIVERSITY_GREAT_WORK_SLOTS', 'Amount', 4 ),
  112. ('GREATPERSON_IOT_GREAT_WORK_SLOTS', 'BuildingType', 'BUILDING_RESEARCH_LAB' ),
  113. ('GREATPERSON_IOT_GREAT_WORK_SLOTS', 'GreatWorkSlotType', 'GREATWORKSLOT_PRODUCT' ),
  114. ('GREATPERSON_IOT_GREAT_WORK_SLOTS', 'Amount', 4 ),
  115. ('GREATPERSON_LAB_GREAT_WORK_SLOTS', 'BuildingType', 'BUILDING_JNR_LABORATORY' ),
  116. ('GREATPERSON_LAB_GREAT_WORK_SLOTS', 'GreatWorkSlotType', 'GREATWORKSLOT_PRODUCT' ),
  117. ('GREATPERSON_LAB_GREAT_WORK_SLOTS', 'Amount', 4 ),
  118. -- note: city centre
  119. ('GREATPERSON_GRANARY_GREAT_WORK_SLOTS', 'BuildingType', 'BUILDING_GRANARY' ),
  120. ('GREATPERSON_GRANARY_GREAT_WORK_SLOTS', 'GreatWorkSlotType', 'GREATWORKSLOT_PRODUCT' ),
  121. ('GREATPERSON_GRANARY_GREAT_WORK_SLOTS', 'Amount', 4 ),
  122. ('GREATPERSON_MONUMENT_GREAT_WORK_SLOTS', 'BuildingType', 'BUILDING_MONUMENT' ),
  123. ('GREATPERSON_MONUMENT_GREAT_WORK_SLOTS', 'GreatWorkSlotType', 'GREATWORKSLOT_PRODUCT' ),
  124. ('GREATPERSON_MONUMENT_GREAT_WORK_SLOTS', 'Amount', 4 ),
  125. ('GREATPERSON_IRRIGATION_GREAT_WORK_SLOTS', 'BuildingType', 'BUILDING_WATER_MILL' ),
  126. ('GREATPERSON_IRRIGATION_GREAT_WORK_SLOTS', 'GreatWorkSlotType', 'GREATWORKSLOT_PRODUCT' ),
  127. ('GREATPERSON_IRRIGATION_GREAT_WORK_SLOTS', 'Amount', 4 ),
  128. ('GREATPERSON_BARRIER_GREAT_WORK_SLOTS', 'BuildingType', 'BUILDING_FLOOD_BARRIER' ),
  129. ('GREATPERSON_BARRIER_GREAT_WORK_SLOTS', 'GreatWorkSlotType', 'GREATWORKSLOT_PRODUCT' ),
  130. ('GREATPERSON_BARRIER_GREAT_WORK_SLOTS', 'Amount', 4 ),
  131. -- note: commercial-- note: industrial zone
  132. ('GREATPERSON_BANK_GREAT_WORK_SLOTS', 'BuildingType', 'BUILDING_BANK' ),
  133. ('GREATPERSON_BANK_GREAT_WORK_SLOTS', 'GreatWorkSlotType', 'GREATWORKSLOT_PRODUCT' ),
  134. ('GREATPERSON_BANK_GREAT_WORK_SLOTS', 'Amount', 4 ),
  135. ('GREATPERSON_MERCHANT_GREAT_WORK_SLOTS', 'BuildingType', 'BUILDING_JNR_MERCHANT_QUARTER' ),
  136. ('GREATPERSON_MERCHANT_GREAT_WORK_SLOTS', 'GreatWorkSlotType', 'GREATWORKSLOT_PRODUCT' ),
  137. ('GREATPERSON_MERCHANT_GREAT_WORK_SLOTS', 'Amount', 4 ),
  138. ('GREATPERSON_WAYSTATION_GREAT_WORK_SLOTS', 'BuildingType', 'BUILDING_JNR_WAYSTATION' ),
  139. ('GREATPERSON_WAYSTATION_GREAT_WORK_SLOTS', 'GreatWorkSlotType', 'GREATWORKSLOT_PRODUCT' ),
  140. ('GREATPERSON_WAYSTATION_GREAT_WORK_SLOTS', 'Amount', 4 ),
  141. ('GREATPERSON_STOCK_GREAT_WORK_SLOTS', 'BuildingType', 'BUILDING_STOCK_EXCHANGE' ),
  142. ('GREATPERSON_STOCK_GREAT_WORK_SLOTS', 'GreatWorkSlotType', 'GREATWORKSLOT_PRODUCT' ),
  143. ('GREATPERSON_STOCK_GREAT_WORK_SLOTS', 'Amount', 4 ),
  144. ('GREATPERSON_COMMODITY_GREAT_WORK_SLOTS', 'BuildingType', 'BUILDING_JNR_COMMODITY_EXCHANGE' ),
  145. ('GREATPERSON_COMMODITY_GREAT_WORK_SLOTS', 'GreatWorkSlotType', 'GREATWORKSLOT_PRODUCT' ),
  146. ('GREATPERSON_COMMODITY_GREAT_WORK_SLOTS', 'Amount', 4 ),
  147. -- note: industrial zone
  148. ('GREATPERSON_WORKSHOP_GREAT_WORK_SLOTS', 'BuildingType', 'BUILDING_WORKSHOP' ),
  149. ('GREATPERSON_WORKSHOP_GREAT_WORK_SLOTS', 'GreatWorkSlotType', 'GREATWORKSLOT_PRODUCT' ),
  150. ('GREATPERSON_WORKSHOP_GREAT_WORK_SLOTS', 'Amount', 4 ),
  151. ('GREATPERSON_MANUFACTORY_GREAT_WORK_SLOTS', 'BuildingType', 'BUILDING_JNR_MANUFACTURY' ),
  152. ('GREATPERSON_MANUFACTORY_GREAT_WORK_SLOTS', 'GreatWorkSlotType', 'GREATWORKSLOT_PRODUCT' ),
  153. ('GREATPERSON_MANUFACTORY_GREAT_WORK_SLOTS', 'Amount', 4 ),
  154. ('GREATPERSON_FACTORY_GREAT_WORK_SLOTS', 'BuildingType', 'BUILDING_FACTORY' ),
  155. ('GREATPERSON_FACTORY_GREAT_WORK_SLOTS', 'GreatWorkSlotType', 'GREATWORKSLOT_PRODUCT' ),
  156. ('GREATPERSON_FACTORY_GREAT_WORK_SLOTS', 'Amount', 4 ),
  157. ('GREATPERSON_PLANT_GREAT_WORK_SLOTS', 'BuildingType', 'BUILDING_JNR_CHEMICAL' ),
  158. ('GREATPERSON_PLANT_GREAT_WORK_SLOTS', 'GreatWorkSlotType', 'GREATWORKSLOT_PRODUCT' ),
  159. ('GREATPERSON_PLANT_GREAT_WORK_SLOTS', 'Amount', 4 ),
  160. ('GREATPERSON_LOGISTICS_GREAT_WORK_SLOTS', 'BuildingType', 'BUILDING_JNR_FREIGHT_YARD' ),
  161. ('GREATPERSON_LOGISTICS_GREAT_WORK_SLOTS', 'GreatWorkSlotType', 'GREATWORKSLOT_PRODUCT' ),
  162. ('GREATPERSON_LOGISTICS_GREAT_WORK_SLOTS', 'Amount', 4 ),
  163. ('GREATPERSON_BATTERY_GREAT_WORK_SLOTS', 'BuildingType', 'BUILDING_JNR_RENEWABLE_DISTRIBUTION' ),
  164. ('GREATPERSON_BATTERY_GREAT_WORK_SLOTS', 'GreatWorkSlotType', 'GREATWORKSLOT_PRODUCT' ),
  165. ('GREATPERSON_BATTERY_GREAT_WORK_SLOTS', 'Amount', 4 )
  166. ;
  167. */
  168.  
  169.  
  170. --('GREAT_PERSON_INDIVIDUAL_JNR_MA_JUN', 'GREATPERSON_BANK_GREAT_WORK_SLOTS', 'GREAT_PERSON_ACTION_ATTACHMENT_TARGET_DISTRICT_IN_TILE')
  171.  
  172.  
  173.  
  174. --CHANGE BUILDINGS TO STOP CROWDING
  175.  
  176. --UPDATE ModifierArguments SET Value = 'BUILDING_JNR_OFFSHORE_TERMINAL' WHERE ModifierId='GREATPERSON_BANK_GREAT_WORK_SLOTS' AND Name = 'BuildingType';
  177. --UPDATE ModifierArguments SET Value = 'BUILDING_AIRPORT' WHERE ModifierId='GREATPERSON_BANK_GREAT_WORK_SLOTS' AND Name = 'BuildingType';
  178.  
  179.  
  180.  
  181. -- francis drake doubles plunder yields
  182. UPDATE ModifierArguments SET Value = 100 WHERE ModifierId='FRANCIS_DRAKE_PLUNDER_BONUS' AND Name = 'Amount';
  183. --make el cid boost to army instead of corp
  184. UPDATE ModifierArguments SET Value = 'ARMY_MILITARY_FORMATION' WHERE ModifierId='GREATPERSON_EL_CID_ACTIVE' AND Name = 'MilitaryFormationType';
  185. -- amiona, ana nzinga, gives 3 envoys instead of 1
  186. UPDATE ModifierArguments SET Value = 2 WHERE ModifierId='GREATPERSON_ANA_NZINGA_ACTIVE' AND Name = 'Amount';
  187. --adolphus gives an ARTILLERY instead of a shitty bombard, 2 times
  188. UPDATE GreatPersonIndividuals SET ActionCharges = 2 WHERE GreatPersonIndividualType='GREAT_PERSON_INDIVIDUAL_GUSTAVUS_ADOLPHUS' AND Name = 'LOC_GREAT_PERSON_INDIVIDUAL_GUSTAVUS_ADOLPHUS_NAME';
  189. UPDATE ModifierArguments SET Value = 'UNIT_ARTILLERY' WHERE ModifierId='GREATPERSON_GUSTAVUS_ADOLPHUS_ACTIVE' AND Name = 'UnitType';
  190. --ching shih better plunder bonus was 60, doubling it
  191. UPDATE ModifierArguments SET Value = 120 WHERE ModifierId='CHING_SHIH_PLUNDER_BONUS' AND Name = 'Amount';
  192. --apart of a bone can do it 3 times giggidy
  193. UPDATE GreatPersonIndividuals SET ActionCharges = 3 WHERE GreatPersonIndividualType='GREAT_PERSON_INDIVIDUAL_NAPOLEON_BONAPARTE' AND Name = 'LOC_GREAT_PERSON_INDIVIDUAL_NAPOLEON_BONAPARTE_NAME';
  194. --upgrade john monash to 150% extra experience per the unit he creates
  195. UPDATE ModifierArguments SET Value = 150 WHERE ModifierId='JOHN_MONASH_BONUS_EXPERIENCE' AND Name = 'Amount';
  196. UPDATE GreatPersonIndividuals SET ActionCharges = 3 WHERE GreatPersonIndividualType = 'GREAT_PERSON_INDIVIDUAL_JOHN_MONASH' AND Name = 'LOC_GREAT_PERSON_INDIVIDUAL_JOHN_MONASH_NAME';
  197. --gorsh whatever the fuck has 3 charges
  198. UPDATE GreatPersonIndividuals SET ActionCharges = 3 WHERE GreatPersonIndividualType='GREAT_PERSON_INDIVIDUAL_SERGEY_GORSHKOV' AND Name = 'LOC_GREAT_PERSON_INDIVIDUAL_SERGEY_GORSHKOV_NAME';
  199. --breedlove 5% per action to make 20% total but give 4 chances for slots
  200. UPDATE GreatPersonIndividuals SET ActionCharges = 4 WHERE GreatPersonIndividualType='GREAT_PERSON_INDIVIDUAL_SARAH_BREEDLOVE' AND Name = 'LOC_GREAT_PERSON_INDIVIDUAL_SARAH_BREEDLOVE_NAME';
  201. UPDATE ModifierArguments SET Value = 10 WHERE ModifierId='EPSTWEAK_SARAH_BREEDLOVE_TOURISM' AND Name = 'Amount';
  202. --ACTION CHARGES
  203. UPDATE GreatPersonIndividuals SET ActionCharges = 3 WHERE GreatPersonIndividualType = 'GREAT_PERSON_INDIVIDUAL_JNR_MARTINE_DE_BERTEREAU' AND Name = 'LOC_GREAT_PERSON_INDIVIDUAL_JNR_MARTINE_DE_BERTEREAU_NAME';
  204. --ammal change from 5000 to 500 because of 4 charges
  205. UPDATE GreatPersonIndividuals SET ActionCharges = 8 WHERE GreatPersonIndividualType = 'GREAT_PERSON_INDIVIDUAL_JANAKI_AMMAL' AND Name = 'LOC_GREAT_PERSON_INDIVIDUAL_JANAKI_AMMAL_NAME';
  206. UPDATE ModifierArguments SET Value = 500 WHERE ModifierId='EPSTWEAK_JANAKI_AMMAL_SCIENCE' AND Name = 'Amount';
  207. --bentz 5 charges, 10% PER TIME
  208. UPDATE GreatPersonIndividuals SET ActionCharges = 10 WHERE GreatPersonIndividualType = 'GREAT_PERSON_INDIVIDUAL_MELITTA_BENTZ' AND Name = 'LOC_GREAT_PERSON_INDIVIDUAL_MELITTA_BENTZ';
  209. UPDATE ModifierArguments SET Value = 5 WHERE ModifierId='GREATPERSON_TRADE_ROUTE_TOURISM_MODIFIER' AND Name = 'Amount';
  210.  
  211. --ZHUKOV FLANKING DOUBLED
  212. UPDATE ModifierArguments SET Value = 100 WHERE ModifierId='GEORGY_ZHUKOV_FLANKING_BONUS' AND Name = 'Percent';
  213.  
  214.  
  215.  
  216.  
  217.  
Add Comment
Please, Sign In to add comment