API tools faq
paste
Guest User

6T Compatibility patch

a guest
May 28th, 2022
352
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 31.40 KB | None | 0 0
raw download clone embed print report
  1. -- Zees Strategic Resource Overhaul
  2. -- Author: _Zee
  3. --------------------------------------------------------------
  4.  
  5.  
  6. -- Increase Resource Extraction Rates -- BaseDefault 0 -- ImprovedDefault 2 -- StockCapDefault 50
  7. UPDATE Resource_Consumption SET BaseExtractionRate='1', ImprovedExtractionRate='1', StockpileCap='50' WHERE ResourceType='RESOURCE_HORSES';
  8. UPDATE Resource_Consumption SET BaseExtractionRate='1', ImprovedExtractionRate='1', StockpileCap='50' WHERE ResourceType='RESOURCE_IRON';
  9. UPDATE Resource_Consumption SET BaseExtractionRate='1', ImprovedExtractionRate='1', StockpileCap='50' WHERE ResourceType='RESOURCE_NITER';
  10. UPDATE Resource_Consumption SET BaseExtractionRate='1', ImprovedExtractionRate='1', StockpileCap='50' WHERE ResourceType='RESOURCE_ALUMINUM';
  11.  
  12. -- default 3
  13. UPDATE Resource_Consumption SET BaseExtractionRate='1', ImprovedExtractionRate='1', StockpileCap='50' WHERE ResourceType='RESOURCE_COAL';
  14. UPDATE Resource_Consumption SET BaseExtractionRate='1', ImprovedExtractionRate='1', StockpileCap='50' WHERE ResourceType='RESOURCE_OIL';
  15. UPDATE Resource_Consumption SET BaseExtractionRate='0', ImprovedExtractionRate='2', StockpileCap='50' WHERE ResourceType='RESOURCE_URANIUM';
  16.  
  17. -- Increase Oil Power Plant output -- default 4
  18. UPDATE Resource_Consumption SET PowerProvided='6' WHERE ResourceType='RESOURCE_OIL';
  19. -- Decrease Nuclear Power Plant output -- default 16
  20. UPDATE Resource_Consumption SET PowerProvided='10' WHERE ResourceType='RESOURCE_URANIUM';
  21.  
  22. -- Increase uranium cost of WMDs -- default 10
  23. UPDATE Project_ResourceCosts SET StartProductionCost='35' WHERE ProjectType='PROJECT_BUILD_NUCLEAR_DEVICE';
  24. -- default 20
  25. UPDATE Project_ResourceCosts SET StartProductionCost='70' WHERE ProjectType='PROJECT_BUILD_THERMONUCLEAR_DEVICE';
  26. -- default 30
  27. UPDATE Project_ResourceCosts SET StartProductionCost='100' WHERE ProjectType='PROJECT_ORBITAL_LASER';
  28.  
  29. -- Increase Resource consumption for units -- default ResourceCosts for pre-medival are 20, post are 1
  30. -- On Epic Timescale, 1 = 1, On Marathon Timescale, 1 = 1,
  31. -- 2 = 3, 2 = 6,
  32. -- 3 = 4, 3 = 9,
  33. -- 4 = 6, 4 = 12,
  34. -- 5 = 7, 5 = 15,
  35. -- 6 = 9, 6 = 18,
  36. -- 7 = 10, 7 = 21,
  37. -- 8 = 12, 8 = 24,
  38. -- 10 = 15, 10 = 30,
  39. -- 16 = 24, 16 = 48,
  40.  
  41. --Classical Era
  42. UPDATE Units_XP2 SET ResourceCost='7', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_HORSEMAN';
  43.  
  44. UPDATE Units_XP2 SET ResourceCost='7', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_SWORDSMAN';
  45.  
  46. --Medieval Era
  47. UPDATE Units_XP2 SET ResourceCost='10', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_COURSER';
  48.  
  49. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_KNIGHT';
  50. UPDATE Units_XP2 SET ResourceCost='10', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_KNIGHT';
  51.  
  52. UPDATE Units_XP2 SET ResourceCost='10', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_MAN_AT_ARMS';
  53.  
  54. --Renaissance Era
  55. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_MUSKETMAN';
  56. UPDATE Units_XP2 SET ResourceCost='5', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_MUSKETMAN';
  57.  
  58. UPDATE Units_XP2 SET ResourceCost='7', ResourceMaintenanceType='RESOURCE_NITER', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_BOMBARD';
  59.  
  60. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_FRIGATE';
  61. UPDATE Units_XP2 SET ResourceCost='10', ResourceMaintenanceType='RESOURCE_NITER', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_FRIGATE';
  62.  
  63. --Industrial Era
  64. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_LINE_INFANTRY';
  65. UPDATE Units_XP2 SET ResourceCost='7', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_LINE_INFANTRY';
  66.  
  67. UPDATE Units SET StrategicResource='RESOURCE_HORSES' WHERE UnitType='UNIT_CAVALRY';
  68. UPDATE Units_XP2 SET ResourceCost='14', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='2' WHERE UnitType='UNIT_CAVALRY';
  69.  
  70. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_CUIRASSIER';
  71. UPDATE Units_XP2 SET ResourceCost='12', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='2' WHERE UnitType='UNIT_CUIRASSIER';
  72.  
  73. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_IRONCLAD';
  74. UPDATE Units_XP2 SET ResourceCost='14', ResourceMaintenanceType='RESOURCE_COAL', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_IRONCLAD';
  75.  
  76. --Modern Era
  77. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_INFANTRY';
  78. REPLACE INTO Units_XP2
  79. (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount)
  80. VALUES ('UNIT_INFANTRY', 8, 'RESOURCE_IRON', 1);
  81.  
  82. UPDATE Units_XP2 SET ResourceCost='8', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_INFANTRY';
  83.  
  84. UPDATE Units SET StrategicResource='RESOURCE_OIL' WHERE UnitType='UNIT_TANK';
  85. UPDATE Units_XP2 SET ResourceCost='7', ResourceMaintenanceType='RESOURCE_OIL', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_TANK';
  86.  
  87. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_ARTILLERY';
  88. UPDATE Units_XP2 SET ResourceCost='10', ResourceMaintenanceType='RESOURCE_NITER', ResourceMaintenanceAmount='2' WHERE UnitType='UNIT_ARTILLERY';
  89.  
  90. UPDATE Units SET StrategicResource='RESOURCE_COAL' WHERE UnitType='UNIT_BATTLESHIP';
  91. UPDATE Units_XP2 SET ResourceCost='16', ResourceMaintenanceType='RESOURCE_COAL', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_BATTLESHIP';
  92.  
  93. UPDATE Units SET StrategicResource='RESOURCE_OIL' WHERE UnitType='UNIT_SUBMARINE';
  94. UPDATE Units_XP2 SET ResourceCost='5', ResourceMaintenanceType='RESOURCE_OIL', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_SUBMARINE';
  95.  
  96. UPDATE Units SET StrategicResource='RESOURCE_OIL' WHERE UnitType='UNIT_BIPLANE';
  97. UPDATE Units_XP2 SET ResourceCost='3', ResourceMaintenanceType='RESOURCE_OIL', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_BIPLANE';
  98.  
  99. --Atomic Era
  100. UPDATE Units SET StrategicResource='RESOURCE_ALUMINUM' WHERE UnitType='UNIT_FIGHTER';
  101. UPDATE Units_XP2 SET ResourceCost='8', ResourceMaintenanceType='RESOURCE_ALUMINUM', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_FIGHTER';
  102.  
  103. UPDATE Units SET StrategicResource='RESOURCE_ALUMINUM' WHERE UnitType='UNIT_BOMBER';
  104. UPDATE Units_XP2 SET ResourceCost='12', ResourceMaintenanceType='RESOURCE_ALUMINUM', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_BOMBER';
  105.  
  106. UPDATE Units SET StrategicResource='RESOURCE_ALUMINUM' WHERE UnitType='UNIT_HELICOPTER';
  107. UPDATE Units_XP2 SET ResourceCost='12', ResourceMaintenanceType='RESOURCE_ALUMINUM', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_HELICOPTER';
  108.  
  109. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_DESTROYER';
  110. UPDATE Units_XP2 SET ResourceCost='16', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_DESTROYER';
  111.  
  112. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_AIRCRAFT_CARRIER';
  113. REPLACE INTO Units_XP2
  114. (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount)
  115. VALUES ('UNIT_AIRCRAFT_CARRIER', 30, 'RESOURCE_OIL', 1);
  116.  
  117.  
  118. --Information Era
  119. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_MECHANIZED_INFANTRY';
  120. UPDATE Units_XP2 SET ResourceCost='10', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_MECHANIZED_INFANTRY';
  121.  
  122. UPDATE Units SET StrategicResource='RESOURCE_OIL' WHERE UnitType='UNIT_MODERN_ARMOR';
  123. UPDATE Units_XP2 SET ResourceCost='14', ResourceMaintenanceType='RESOURCE_OIL', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_MODERN_ARMOR';
  124.  
  125. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_ROCKET_ARTILLERY';
  126. UPDATE Units_XP2 SET ResourceCost='16', ResourceMaintenanceType='RESOURCE_NITER', ResourceMaintenanceAmount='2' WHERE UnitType='UNIT_ROCKET_ARTILLERY';
  127.  
  128. UPDATE Units SET StrategicResource='RESOURCE_OIL' WHERE UnitType='UNIT_MISSILE_CRUISER';
  129. UPDATE Units_XP2 SET ResourceCost='16', ResourceMaintenanceType='RESOURCE_OIL', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_MISSILE_CRUISER';
  130.  
  131. UPDATE Units SET StrategicResource='RESOURCE_URANIUM' WHERE UnitType='UNIT_NUCLEAR_SUBMARINE';
  132. UPDATE Units_XP2 SET ResourceCost='12', ResourceMaintenanceType='RESOURCE_URANIUM', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_NUCLEAR_SUBMARINE';
  133.  
  134. UPDATE Units SET StrategicResource='RESOURCE_ALUMINUM' WHERE UnitType='UNIT_JET_FIGHTER';
  135. UPDATE Units_XP2 SET ResourceCost='14', ResourceMaintenanceType='RESOURCE_ALUMINUM', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_JET_FIGHTER';
  136.  
  137. UPDATE Units SET StrategicResource='RESOURCE_ALUMINUM' WHERE UnitType='UNIT_JET_BOMBER';
  138. UPDATE Units_XP2 SET ResourceCost='20', ResourceMaintenanceType='RESOURCE_ALUMINUM', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_JET_BOMBER';
  139.  
  140. UPDATE Units SET StrategicResource='RESOURCE_URANIUM' WHERE UnitType='UNIT_GIANT_DEATH_ROBOT';
  141. UPDATE Units_XP2 SET ResourceCost='30', ResourceMaintenanceType='RESOURCE_URANIUM', ResourceMaintenanceAmount='3' WHERE UnitType='UNIT_GIANT_DEATH_ROBOT';
  142.  
  143.  
  144. -- Unique Units -- generally all get a discount on construction cost compared to their standard counterpart
  145.  
  146. -- early
  147. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_ROMAN_LEGION';
  148. UPDATE Units_XP2 SET ResourceCost='5', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_ROMAN_LEGION';
  149.  
  150. --UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_KONGO_SHIELD_BEARER';
  151. --UPDATE Units_XP2 SET ResourceCost='5', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_KONGO_SHIELD_BEARER';
  152.  
  153. --UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_MAORI_TOA';
  154. --UPDATE Units_XP2 SET ResourceCost='5', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_MAORI_TOA';
  155.  
  156. UPDATE Units SET StrategicResource='RESOURCE_HORSES' WHERE UnitType='UNIT_HUNGARY_BLACK_ARMY';
  157. UPDATE Units_XP2 SET ResourceCost='6', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_HUNGARY_BLACK_ARMY';
  158.  
  159. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_JAPANESE_SAMURAI';
  160. UPDATE Units_XP2 SET ResourceCost='4', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_JAPANESE_SAMURAI';
  161.  
  162. --UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_NORWEGIAN_BERSERKER';
  163. --UPDATE Units_XP2 SET ResourceCost='4', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_NORWEGIAN_BERSERKER';
  164.  
  165. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_ARABIAN_MAMLUK';
  166. UPDATE Units_XP2 SET ResourceCost='7', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_ARABIAN_MAMLUK';
  167.  
  168. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_MALI_MANDEKALU_CAVALRY';
  169. UPDATE Units_XP2 SET ResourceCost='7', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_MALI_MANDEKALU_CAVALRY';
  170.  
  171. -- mid
  172. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_SULEIMAN_JANISSARY';
  173. UPDATE Units_XP2 SET ResourceCost='3', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_SULEIMAN_JANISSARY';
  174.  
  175. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_SPANISH_CONQUISTADOR';
  176. UPDATE Units_XP2 SET ResourceCost='3', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_SPANISH_CONQUISTADOR';
  177.  
  178. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_ZEVEN_PROVINCIEN';
  179. UPDATE Units_XP2 SET ResourceCost='8', ResourceMaintenanceType='RESOURCE_NITER', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_ZEVEN_PROVINCIEN';
  180.  
  181. --UPDATE Units SET StrategicResource='RESOURCE_HORSES' WHERE UnitType='UNIT_HUNGARY_HUSZAR';
  182. --UPDATE Units_XP2 SET ResourceCost='12', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_HUNGARY_HUSZAR';
  183.  
  184. UPDATE Units SET StrategicResource='RESOURCE_HORSES' WHERE UnitType='UNIT_RUSSIAN_COSSACK';
  185. UPDATE Units_XP2 SET ResourceCost='12', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_RUSSIAN_COSSACK';
  186.  
  187. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_FRENCH_GARDE_IMPERIALE';
  188. UPDATE Units_XP2 SET ResourceCost='4', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_FRENCH_GARDE_IMPERIALE';
  189.  
  190. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_ENGLISH_REDCOAT';
  191. UPDATE Units_XP2 SET ResourceCost='4', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_ENGLISH_REDCOAT';
  192.  
  193.  
  194. -- late
  195. UPDATE Units SET StrategicResource='RESOURCE_COAL' WHERE UnitType='UNIT_BRAZILIAN_MINAS_GERAES';
  196. UPDATE Units_XP2 SET ResourceCost='12', ResourceMaintenanceType='RESOURCE_COAL', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_BRAZILIAN_MINAS_GERAES';
  197.  
  198. UPDATE Units SET StrategicResource='RESOURCE_OIL' WHERE UnitType='UNIT_GERMAN_UBOAT';
  199. UPDATE Units_XP2 SET ResourceCost='3', ResourceMaintenanceType='RESOURCE_OIL', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_GERMAN_UBOAT';
  200.  
  201. UPDATE Units SET StrategicResource='RESOURCE_ALUMINUM' WHERE UnitType='UNIT_AMERICAN_P51';
  202. UPDATE Units_XP2 SET ResourceCost='6', ResourceMaintenanceType='RESOURCE_ALUMINUM', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_AMERICAN_P51';
  203.  
  204.  
  205.  
  206. -- Steel and Thunder: Expansion Compatibility patch
  207.  
  208. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_DLV_RIFLEMAN';
  209. UPDATE Units_XP2 SET ResourceCost='7', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_DLV_RIFLEMAN';
  210.  
  211. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_DLV_LONGSWORDSMAN';
  212. UPDATE Units_XP2 SET ResourceCost='10', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_DLV_LONGSWORDSMAN';
  213.  
  214. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_DLV_SELF_PROPELLED_ARTILLERY';
  215. UPDATE Units_XP2 SET ResourceCost='16', ResourceMaintenanceType='RESOURCE_NITER', ResourceMaintenanceAmount='2' WHERE UnitType='UNIT_DLV_SELF_PROPELLED_ARTILLERY';
  216.  
  217. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_DLV_GALLEASS';
  218. UPDATE Units_XP2 SET ResourceCost='8', ResourceMaintenanceType='RESOURCE_NITER', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_DLV_GALLEASS';
  219. -- S&T compat
  220. UPDATE Units SET StrategicResource=NULL WHERE UnitType='UNIT_ROCKET_ARTILLERY' AND EXISTS (SELECT 1 FROM Units WHERE UnitType = 'UNIT_DLV_SELF_PROPELLED_ARTILLERY');
  221. UPDATE Units_XP2 SET ResourceCost='0', ResourceMaintenanceType=NULL, ResourceMaintenanceAmount='0' WHERE UnitType='UNIT_ROCKET_ARTILLERY' AND EXISTS (SELECT 1 FROM Units WHERE UnitType = 'UNIT_DLV_SELF_PROPELLED_ARTILLERY');
  222. -- end S&T compat
  223.  
  224. -- Warfare Expanded Reloaded Ground Compatibility patch
  225.  
  226. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_ARMORED_HORSEMAN';
  227. UPDATE Units_XP2 SET ResourceCost='8', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_ARMORED_HORSEMAN';
  228.  
  229. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_REITER';
  230. UPDATE Units_XP2 SET ResourceCost='12', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_REITER';
  231.  
  232. UPDATE Units SET StrategicResource='RESOURCE_HORSES' WHERE UnitType='UNIT_STRADIOT';
  233. UPDATE Units_XP2 SET ResourceCost='12', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_STRADIOT';
  234.  
  235. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_RIFLED_CANNON';
  236. UPDATE Units_XP2 SET ResourceCost='10', ResourceMaintenanceType='RESOURCE_NITER', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_RIFLED_CANNON';
  237.  
  238. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_WW1_INFANTRY';
  239. REPLACE INTO Units_XP2
  240. (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount)
  241. SELECT 'UNIT_WW1_INFANTRY', 8, 'RESOURCE_IRON', 1
  242. WHERE EXISTS (SELECT 1 FROM Units WHERE UnitType = 'UNIT_STRADIOT');
  243.  
  244. UPDATE Units SET StrategicResource='RESOURCE_OIL' WHERE UnitType='UNIT_LANDSHIP';
  245. UPDATE Units_XP2 SET ResourceCost='6', ResourceMaintenanceType='RESOURCE_OIL', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_LANDSHIP';
  246.  
  247. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_HEAVY_HOWITZER';
  248. UPDATE Units_XP2 SET ResourceCost='14', ResourceMaintenanceType='RESOURCE_NITER', ResourceMaintenanceAmount='2' WHERE UnitType='UNIT_HEAVY_HOWITZER';
  249.  
  250. UPDATE Units SET StrategicResource='RESOURCE_HORSES' WHERE UnitType='UNIT_MOUNTED_RIFLES';
  251. UPDATE Units_XP2 SET ResourceCost='16', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='2' WHERE UnitType='UNIT_MOUNTED_RIFLES';
  252.  
  253. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_MODERN_INFANTRY';
  254. REPLACE INTO Units_XP2
  255. (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount)
  256. SELECT 'UNIT_MODERN_INFANTRY', 10, 'RESOURCE_IRON', 1
  257. WHERE EXISTS (SELECT 1 FROM Units WHERE UnitType = 'UNIT_STRADIOT');
  258.  
  259. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_ARMORED_INFANTRY';
  260. UPDATE Units_XP2 SET ResourceCost='8', ResourceMaintenanceType='RESOURCE_OIL', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_ARMORED_INFANTRY';
  261.  
  262. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_MECHANIZED_INFANTRY' AND EXISTS (SELECT 1 FROM Units WHERE UnitType = 'UNIT_LIGHT_CRUISER');
  263. UPDATE Units_XP2 SET ResourceCost='10', ResourceMaintenanceType='RESOURCE_OIL', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_MECHANIZED_INFANTRY' AND EXISTS (SELECT 1 FROM Units WHERE UnitType = 'UNIT_LIGHT_CRUISER');
  264.  
  265.  
  266. -- Warfare Expanded Reloaded Part Water Compatibility patch
  267.  
  268. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_INDUSTRIAL_MARINE'; --infantry
  269. UPDATE Units_XP2 SET ResourceCost='12', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_INDUSTRIAL_MARINE';
  270.  
  271. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_WW2_MARINE'; --infantry
  272. REPLACE INTO Units_XP2
  273. (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount)
  274. SELECT 'UNIT_WW2_MARINE', 14, 'RESOURCE_IRON', 1
  275. WHERE EXISTS (SELECT 1 FROM Units WHERE UnitType = 'UNIT_LIGHT_CRUISER');
  276.  
  277. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_MODERN_MARINE'; --infantry
  278. UPDATE Units_XP2 SET ResourceCost='14', ResourceMaintenanceType='RESOURCE_OIL', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_MODERN_MARINE';
  279.  
  280.  
  281. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_GALLEASS';
  282. UPDATE Units_XP2 SET ResourceCost='8', ResourceMaintenanceType='RESOURCE_NITER', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_GALLEASS';
  283.  
  284. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_CARRACK';
  285. UPDATE Units_XP2 SET ResourceCost='10', ResourceMaintenanceType='RESOURCE_NITER', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_CARRACK';
  286.  
  287. UPDATE Units SET StrategicResource=NULL WHERE UnitType='UNIT_CORVETTE';
  288. UPDATE Units_XP2 SET ResourceCost='0' WHERE UnitType='UNIT_CORVETTE';
  289.  
  290. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_SHIP_OF_THE_LINE';
  291. UPDATE Units_XP2 SET ResourceCost='12', ResourceMaintenanceType='RESOURCE_NITER', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_SHIP_OF_THE_LINE';
  292.  
  293. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_RAIDER';
  294. UPDATE Units_XP2 SET ResourceCost='10', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_RAIDER';
  295.  
  296. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_ARMORED_CRUISER';
  297. UPDATE Units_XP2 SET ResourceCost='14', ResourceMaintenanceType='RESOURCE_NITER', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_ARMORED_CRUISER';
  298.  
  299. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_PRE_DREADNOUGHT';
  300. UPDATE Units_XP2 SET ResourceCost='14', ResourceMaintenanceType='RESOURCE_NITER', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_PRE_DREADNOUGHT';
  301.  
  302. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_TORPEDO_GUNBOAT';
  303. UPDATE Units_XP2 SET ResourceCost='16', ResourceMaintenanceType='RESOURCE_COAL', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_TORPEDO_GUNBOAT';
  304.  
  305. UPDATE Units SET StrategicResource='RESOURCE_COAL' WHERE UnitType='UNIT_LIGHT_CRUISER';
  306. UPDATE Units_XP2 SET ResourceCost='16', ResourceMaintenanceType='RESOURCE_COAL', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_LIGHT_CRUISER';
  307.  
  308. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_DREADNOUGHT';
  309. UPDATE Units_XP2 SET ResourceCost='16', ResourceMaintenanceType='RESOURCE_NITER', ResourceMaintenanceAmount='2' WHERE UnitType='UNIT_DREADNOUGHT';
  310.  
  311. UPDATE Units SET StrategicResource='RESOURCE_OIL' WHERE UnitType='UNIT_BATTLECRUISER';
  312. UPDATE Units_XP2 SET ResourceCost='16', ResourceMaintenanceType='RESOURCE_OIL', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_BATTLECRUISER';
  313.  
  314. UPDATE Units SET StrategicResource='RESOURCE_OIL' WHERE UnitType='UNIT_ATTACK_SUBMARINE';
  315. REPLACE INTO Units_XP2
  316. (UnitType, ResourceCost, ResourceMaintenanceType, ResourceMaintenanceAmount)
  317. SELECT 'UNIT_ATTACK_SUBMARINE', 10, 'RESOURCE_OIL', 1
  318. WHERE EXISTS (SELECT 1 FROM Units WHERE UnitType = 'UNIT_LIGHT_CRUISER');
  319.  
  320. UPDATE Units SET StrategicResource='RESOURCE_URANIUM' WHERE UnitType='UNIT_SUPERCARRIER';
  321. UPDATE Units_XP2 SET ResourceCost='20', ResourceMaintenanceType='RESOURCE_URANIUM', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_SUPERCARRIER';
  322.  
  323. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_MISSILE_DESTROYER';
  324. UPDATE Units_XP2 SET ResourceCost='20', ResourceMaintenanceType='RESOURCE_OIL', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_MISSILE_DESTROYER';
  325.  
  326. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_MISSILE_FRIGATE';
  327. UPDATE Units_XP2 SET ResourceCost='20', ResourceMaintenanceType='RESOURCE_URANIUM', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_MISSILE_FRIGATE';
  328.  
  329.  
  330. -- Warfare Expanded Reloaded Part Air Compatibility patch
  331.  
  332. UPDATE Units SET StrategicResource='RESOURCE_OIL' WHERE UnitType='UNIT_WW1_GROUND_ATTACK';
  333. UPDATE Units_XP2 SET ResourceCost='4', ResourceMaintenanceType='RESOURCE_OIL', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_WW1_GROUND_ATTACK';
  334.  
  335. UPDATE Units SET StrategicResource='RESOURCE_OIL' WHERE UnitType='UNIT_WW1_BOMBER';
  336. UPDATE Units_XP2 SET ResourceCost='5', ResourceMaintenanceType='RESOURCE_OIL', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_WW1_BOMBER';
  337.  
  338. UPDATE Units SET StrategicResource='RESOURCE_ALUMINUM' WHERE UnitType='UNIT_GROUND_ATTACK';
  339. UPDATE Units_XP2 SET ResourceCost='10', ResourceMaintenanceType='RESOURCE_ALUMINUM', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_GROUND_ATTACK';
  340.  
  341. UPDATE Units SET StrategicResource='RESOURCE_ALUMINUM' WHERE UnitType='UNIT_JET_GROUND_ATTACK';
  342. UPDATE Units_XP2 SET ResourceCost='18', ResourceMaintenanceType='RESOURCE_ALUMINUM', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_JET_GROUND_ATTACK';
  343.  
  344. UPDATE Units SET StrategicResource='RESOURCE_ALUMINUM' WHERE UnitType='UNIT_UAV';
  345. UPDATE Units_XP2 SET ResourceCost='10', ResourceMaintenanceType='RESOURCE_ALUMINUM', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_UAV';
  346.  
  347. UPDATE Units SET StrategicResource='RESOURCE_ALUMINUM' WHERE UnitType='UNIT_STEALTH_FIGHTER';
  348. UPDATE Units_XP2 SET ResourceCost='16', ResourceMaintenanceType='RESOURCE_ALUMINUM', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_STEALTH_FIGHTER';
  349.  
  350. UPDATE Units SET StrategicResource='RESOURCE_ALUMINUM' WHERE UnitType='UNIT_STEALTH_BOMBER';
  351. UPDATE Units_XP2 SET ResourceCost='24', ResourceMaintenanceType='RESOURCE_ALUMINUM', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_STEALTH_BOMBER';
  352.  
  353.  
  354. -- 6T Compatibility patch
  355.  
  356. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_JNR_LONGSWORDSMAN';
  357. UPDATE Units_XP2 SET ResourceCost='9', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_JNR_LONGSWORDSMAN';
  358.  
  359. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_KONGO_SHIELD_BEARER';
  360. UPDATE Units_XP2 SET ResourceCost='8', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_KONGO_SHIELD_BEARER';
  361.  
  362. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_MAORI_TOA';
  363. UPDATE Units_XP2 SET ResourceCost='8', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_MAORI_TOA';
  364.  
  365. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_NORWEGIAN_BERSERKER';
  366. UPDATE Units_XP2 SET ResourceCost='8', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_NORWEGIAN_BERSERKER';
  367.  
  368. UPDATE Units_XP2 SET ResourceCost='5', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_JNR_SCOUT_RIDER';
  369.  
  370. UPDATE Units_XP2 SET ResourceCost='12', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='2' WHERE UnitType='UNIT_JNR_HARQUEBUSIER';
  371.  
  372. UPDATE Units_XP2 SET ResourceCost='11', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_HUNGARY_HUSZAR';
  373.  
  374. UPDATE Units SET StrategicResource='RESOURCE_ALUMINUM' WHERE UnitType='UNIT_JNR_ASSAULT_GUN';
  375. UPDATE Units_XP2 SET ResourceCost='11', ResourceMaintenanceType='RESOURCE_ALUMINUM', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_JNR_ASSAULT_GUN';
  376.  
  377. UPDATE Units_XP2 SET ResourceCost='5', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_HEAVY_CHARIOT';
  378.  
  379. UPDATE Units_XP2 SET ResourceCost='3', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_SUMERIAN_WAR_CART';
  380.  
  381. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_JNR_CATAPHRACT';
  382. UPDATE Units_XP2 SET ResourceCost='9', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_JNR_CATAPHRACT';
  383.  
  384. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_MACEDONIAN_HETAIROI';
  385. UPDATE Units_XP2 SET ResourceCost='8', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_MACEDONIAN_HETAIROI';
  386.  
  387. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_JNR_LANCER';
  388. UPDATE Units_XP2 SET ResourceCost='14', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='2' WHERE UnitType='UNIT_JNR_LANCER';
  389.  
  390. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_AMERICAN_ROUGH_RIDER';
  391. UPDATE Units_XP2 SET ResourceCost='13', ResourceMaintenanceType='RESOURCE_HORSES', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_AMERICAN_ROUGH_RIDER';
  392.  
  393. UPDATE Units SET StrategicResource='RESOURCE_OIL' WHERE UnitType='UNIT_JNR_LANDSHIP';
  394. UPDATE Units_XP2 SET ResourceCost='6', ResourceMaintenanceType='RESOURCE_OIL', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_JNR_LANDSHIP';
  395.  
  396. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_JNR_SIEGE_CANNON';
  397. UPDATE Units_XP2 SET ResourceCost='9', ResourceMaintenanceType='RESOURCE_NITER', ResourceMaintenanceAmount='2' WHERE UnitType='UNIT_JNR_SIEGE_CANNON';
  398.  
  399. UPDATE Units SET StrategicResource='RESOURCE_NITER' WHERE UnitType='UNIT_JNR_MOBILE_ARTILLERY';
  400. UPDATE Units_XP2 SET ResourceCost='13', ResourceMaintenanceType='RESOURCE_NITER', ResourceMaintenanceAmount='2' WHERE UnitType='UNIT_JNR_MOBILE_ARTILLERY';
  401.  
  402. UPDATE Units SET StrategicResource='RESOURCE_IRON' WHERE UnitType='UNIT_JNR_STEALTH_DESTROYER';
  403. UPDATE Units_XP2 SET ResourceCost='18', ResourceMaintenanceType='RESOURCE_IRON', ResourceMaintenanceAmount='2' WHERE UnitType='UNIT_JNR_STEALTH_DESTROYER';
  404.  
  405. UPDATE Units SET StrategicResource='RESOURCE_COAL' WHERE UnitType='UNIT_JNR_STEAMSHIP';
  406. UPDATE Units_XP2 SET ResourceCost='14', ResourceMaintenanceType='RESOURCE_COAL', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_JNR_STEAMSHIP';
  407.  
  408. UPDATE Units SET StrategicResource='RESOURCE_OIL' WHERE UnitType='UNIT_JNR_MONITOR';
  409. UPDATE Units_XP2 SET ResourceCost='4', ResourceMaintenanceType='RESOURCE_OIL', ResourceMaintenanceAmount='1' WHERE UnitType='UNIT_JNR_MONITOR';
  410.  
  411. UPDATE Units SET StrategicResource='RESOURCE_ALUMINUM' WHERE UnitType='UNIT_JNR_STEALTH_FIGHTER';
  412. UPDATE Units_XP2 SET ResourceCost='16', ResourceMaintenanceType='RESOURCE_ALUMINUM', ResourceMaintenanceAmount='2' WHERE UnitType='UNIT_JNR_STEALTH_FIGHTER';
  413.  
  414. UPDATE Units SET StrategicResource='RESOURCE_ALUMINUM' WHERE UnitType='UNIT_JNR_STEALTH_BOMBER';
  415. UPDATE Units_XP2 SET ResourceCost='22', ResourceMaintenanceType='RESOURCE_ALUMINUM', ResourceMaintenanceAmount='2' WHERE UnitType='UNIT_JNR_STEALTH_BOMBER';
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!