API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 27th, 2017
63
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 49.22 KB | None | 0 0
raw download clone embed print report
  1. DROP TABLE IF EXISTS `vehicle_data`;
  2. CREATE TABLE `vehicle_data` (
  3.   `entry` mediumint(5) UNSIGNED NOT NULL,
  4.   `flags` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  5.   `Spell1` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  6.   `Spell2` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  7.   `Spell3` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  8.   `Spell4` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  9.   `Spell5` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  10.   `Spell6` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  11.   `Spell7` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  12.   `Spell8` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  13.   `Spell9` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  14.   `Spell10` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  15.   `req_aura` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  16.   PRIMARY KEY  (`entry`)
  17. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Vehicle System';
  18.  
  19. DROP TABLE IF EXISTS `vehicle_seat_data`;
  20. CREATE TABLE `vehicle_seat_data` (
  21.   `seat` mediumint(5) UNSIGNED NOT NULL,
  22.   `flags` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  23.   PRIMARY KEY  (`seat`)
  24. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Vehicle Seat System';
  25.  
  26. ALTER TABLE creature_addon
  27.   ADD COLUMN  vehicle_id  SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER moveflags,
  28.   ADD COLUMN  passengers  text AFTER vehicle_id;
  29.  
  30. ALTER TABLE creature_template_addon
  31.   ADD COLUMN  vehicle_id  SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER moveflags,
  32.   ADD COLUMN  passengers  text AFTER vehicle_id;
  33.  
  34. /* vehicle multi seat mounts */
  35. ALTER TABLE creature_template
  36.   ADD COLUMN `VehicleEntry` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `PetSpellDataId`;
  37. REPLACE INTO `vehicle_data`/* Mechano-hog, Mekgineer's Chopper */
  38. UPDATE creature_template SET VehicleEntry = 318, IconName = 'vehichleCursor' WHERE entry IN (29929, 32286);
  39.  
  40. /* Traveler's Tundra Mammoth, Grand Ice Mammoth, Grand Black War Mammoth, Grand Caravan Mammoth */
  41. UPDATE creature_template SET VehicleEntry = 312, IconName = 'vehichleCursor' WHERE entry IN (32633, 32640, 31857, 31858, 31861, 31862, 32212, 32213);
  42.  
  43. /* X-53 Touring Rocket */
  44. UPDATE creature_template SET VehicleEntry = 774, IconName = 'vehichleCursor' WHERE entry = 40725;
  45.  
  46. UPDATE creature_template SET minlevel = 80, maxlevel = 80 WHERE entry IN (28312,32627,28319,32629,28094,28670);
  47. UPDATE creature_template SET speed_run = 2, InhabitType = 1 WHERE entry IN (28312,32627,28319,32629,28094,29929,28782);
  48. UPDATE creature_template SET mechanic_immune_mask = 652951551 WHERE entry IN (28670,28312,32627,28319,32629,28094,29929,28782);
  49.  
  50. /* Frostbrood Vanquisher */
  51. UPDATE creature_template SET maxhealth = 133525, minhealth = 133525, maxmana = 51360, minmana = 51360, speed_run = 2.4, InhabitType = 3 WHERE entry = 28670;
  52. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (28670);
  53. INSERT INTO npc_spellclick_spells VALUES (28670, 52196, 12779, 1, 12779, 0);
  54. REPLACE INTO creature_template_addon VALUES (28670, 0, 50331648, 1, 0, 1024, 156, NULL, '53112 0 53112 1 48602 2');
  55. REPLACE INTO vehicle_data VALUES (156, 24, 53114, 0, 53110, 0, 0, 0, 0, 0, 0, 0, 0);
  56. REPLACE INTO vehicle_seat_data VALUES (1986, 3),(1987, 8);
  57. UPDATE quest_template SET ReqItemId1 = 39700, ReqItemCount1 = 1 WHERE entry = 12779;
  58.  
  59. /* Argent Tournament (new) */
  60. DELETE FROM creature WHERE id IN (33844,33845);
  61. DELETE FROM creature_addon WHERE guid IN (SELECT guid FROM creature WHERE id IN (33844,33845));
  62. REPLACE INTO vehicle_data VALUES (349, 24, 62544, 62575, 63010, 62552, 64077, 62863, 0, 0, 0, 0, 62853);
  63. REPLACE INTO vehicle_seat_data VALUES ('3129', '1');
  64. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (33842, 33843);
  65. INSERT INTO npc_spellclick_spells VALUES (33842,63791,13829,1,0,3),(33842,63791,13839,1,0,3),(33842,63791,13838,1,0,3),(33843,63792,13828,1,0,3),(33843,63792,13837,1,0,3),(33843,63792,13835,1,0,3);
  66. REPLACE INTO creature_template_addon VALUES (33844, 0, 0, 2049, 0, 0, 349, NULL, NULL),(33845, 0, 0, 2049, 0, 0, 349, NULL, NULL);
  67. UPDATE creature_template SET AIName = 'NullAI' WHERE entry IN (33243,33229,33272);
  68. /* Alliance and Horde Tournament Mounts (DaViper fixes) */
  69. UPDATE creature_template SET minlevel = 80, maxlevel = 80, minhealth = 50000, maxhealth = 50000, minmana = 1000, maxmana = 1000, armor = 9730,
  70. speed_run = 1.5, mindmg = 420, maxdmg = 630, attackpower = 157, dmg_multiplier = 1.4, rangeattacktime = 2000, unit_flags = 8, minrangedmg = 336,
  71. maxrangedmg = 504, rangedattackpower = 126 WHERE entry IN (33217,33316,33317,33318,33319,33320,33321,33322,33323,33324,33844,33845);
  72.  
  73. /* Quest Grand Theft Palomino (12680) */
  74. REPLACE INTO spell_script_target VALUES (52264,1,28653);
  75. REPLACE INTO vehicle_data VALUES (123, 4, 52264, 52268, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  76. REPLACE INTO vehicle_seat_data VALUES (1782, 1);
  77. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (28605,28606,28607);
  78. INSERT INTO npc_spellclick_spells VALUES (28605, 52263, 12680, 1, 12680, 3),(28606, 52263, 12680, 1, 12680, 3),(28607, 52263, 12680, 1, 12680, 3);
  79. REPLACE INTO creature_template_addon VALUES (28605, 0, 0, 1, 0, 0, 123, NULL, NULL),(28606, 0, 0, 1, 0, 0, 123, NULL, NULL),(28607, 0, 0, 1, 0, 0, 123, NULL, NULL);
  80. DELETE FROM creature_addon WHERE guid IN (SELECT guid FROM creature WHERE id IN (28605,28606,28607));
  81.  
  82. /* Quest Into the Realm of Shadows (12687) */
  83. REPLACE INTO spell_script_target VALUES (52349,1,28782);
  84. UPDATE creature_template SET faction_A = 2082, faction_H = 2082, unit_flags = 32768 WHERE entry = 28782;
  85. DELETE FROM creature_addon WHERE guid IN (SELECT guid FROM creature WHERE id = 28782);
  86. REPLACE INTO vehicle_data VALUES (135, 4, 52362, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  87. REPLACE INTO vehicle_seat_data VALUES (1871, 1);
  88. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (28782);
  89. INSERT INTO npc_spellclick_spells VALUES (28782, 52349, 12687, 1, 12687, 3);
  90. REPLACE INTO creature_template_addon VALUES (28782, 0, 0, 1, 0, 0, 135, NULL, NULL);
  91. UPDATE quest_template SET SrcSpell = 52693 WHERE entry = 12687;
  92.  
  93. /* Quest Going Bearback */
  94. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (29598);
  95. INSERT INTO npc_spellclick_spells VALUES (29598, 54908, 12851, 1, 12851, 1);
  96. REPLACE INTO creature_template_addon VALUES (29598, 0, 0, 1, 0, 0, 308, NULL, NULL);
  97. REPLACE INTO `vehicle_data` VALUES (308, 24, 54897, 54907, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  98. REPLACE INTO vehicle_seat_data VALUES (2699, 1);
  99.  
  100. /* Massacre At Light's Point (new) */
  101. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (28887,28833,28864);
  102. INSERT INTO npc_spellclick_spells VALUES (28833,52447,12701,1,12701,1),(28887,52447,12701,1,12701,1),(28864,67373,0,0,0,1);
  103. REPLACE INTO creature_template_addon VALUES (28887,0,0,2049,0,0,79,NULL,NULL),(28833,0,0,2049,0,0,79,NULL,NULL),(28864,0,0,0,0,0,143,NULL,'48602 0 48602 2');
  104. REPLACE INTO vehicle_data VALUES (143,12,0,0,0,0,0,0,0,0,0,0,0),(79,5,52435,52576,0,52588,0,0,0,0,0,0,0);
  105. REPLACE INTO vehicle_seat_data VALUES (1427, 1),(1902, 3);
  106. UPDATE creature_model_info SET bounding_radius = 0 WHERE modelid = 25723;
  107. UPDATE creature_template SET IconName = 'Gunner' WHERE entry IN (28887,28833);
  108. UPDATE creature_template SET IconName = 'vehichleCursor', InhabitType = 3 WHERE entry IN (28864);
  109. DELETE FROM creature_addon WHERE guid IN (SELECT guid FROM creature WHERE id IN (28887,28833,28864));
  110.  
  111. /* Traveler's Tundra Mammoth, Grand Ice Mammoth */
  112. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (32633, 32640, 31857);
  113. INSERT INTO npc_spellclick_spells VALUES (32633, 65403, 0, 0, 0, 0),(32640, 65403, 0, 0, 0, 0),(31857, 65403, 0, 0, 0, 0);
  114. REPLACE INTO creature_template_addon VALUES (32633,0,0,0,0,0,312,NULL,NULL),(32640,0,0,0,0,0,312,NULL,NULL),(31857,0,0,0,0,0,312,NULL,NULL);
  115. REPLACE INTO vehicle_data VALUES (312, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  116.  
  117. /* Salvaged Chopper */
  118. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (33062);
  119. INSERT INTO npc_spellclick_spells VALUES (33062, 65403, 0, 0, 0, 0);
  120. REPLACE INTO creature_template_addon VALUES (33062, 0, 0, 0, 0, 0, 335, NULL, NULL);
  121. REPLACE INTO vehicle_data VALUES (335, 4, 62974, 62286, 62299, 64660, 0, 0, 0, 0, 0, 0, 0);
  122. REPLACE INTO vehicle_seat_data VALUES (3005, 3),(3004, 2);
  123. UPDATE creature_model_info SET bounding_radius = '0.306' WHERE modelid IN (25870,25871);
  124.  
  125. /* Salvaged Demolisher */
  126. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (33109);
  127. INSERT INTO npc_spellclick_spells VALUES (33109, 65403, 0, 0, 0, 0);
  128. REPLACE INTO creature_template_addon VALUES (33109, 0, 0, 0, 0, 0, 338, '33167 1', NULL);
  129. REPLACE INTO vehicle_data VALUES (338, 4, 62306, 62490, 62308, 62324, 0, 0, 0, 0, 0, 0, 0);
  130. REPLACE INTO vehicle_seat_data VALUES (3011, 3),(3146, 8),(3013, 8),(3147, 8);
  131.  
  132. /* Salvaged Siege Engine */
  133. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (33060);
  134. INSERT INTO npc_spellclick_spells VALUES (33060, 65403, 0, 0, 0, 0);
  135. REPLACE INTO creature_template_addon VALUES (33060, 0, 0, 0, 0, 0, 336, '33067 7', NULL);
  136. REPLACE INTO vehicle_data VALUES (336, 4, 62345, 62522, 62346, 0, 0, 0, 0, 0, 0, 0, 0);
  137. REPLACE INTO vehicle_seat_data VALUES (3006, 3),(4026, 8),(4027, 8),(3009, 8);
  138.  
  139. /* Salvaged Siege Turret */
  140. DELETE FROM npc_spellclick_spells WHERE npc_entry = 33067;
  141. INSERT INTO npc_spellclick_spells VALUES (33067, 65403, 0, 0, 0, 1);
  142. REPLACE INTO creature_template_addon VALUES (33067, 0, 0, 0, 0, 0, 337, NULL, NULL);
  143. REPLACE INTO vehicle_data VALUES (337, 5, 62358, 64677, 62359, 0, 0, 0, 0, 0, 0, 0, 0);
  144. REPLACE INTO vehicle_seat_data VALUES (3010, 3);
  145. UPDATE creature_template SET minhealth = 1134000, maxhealth = 1134000, unit_flags = 32768, IconName = 'Gunner' WHERE entry = 33067;
  146. DELETE FROM creature WHERE id = 33067;
  147.  
  148. /* Mechanic Seat Salvaged Demolisher */
  149. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (33167);
  150. INSERT INTO npc_spellclick_spells VALUES (33167, 65403, 0, 0, 0, 1);
  151. REPLACE INTO creature_template_addon VALUES (33167, 0, 0, 0, 0, 0, 345, NULL, NULL);
  152. REPLACE INTO vehicle_data VALUES (345, 5, 62634, 64979, 62479, 62471, 0, 62428, 0, 0, 0, 0, 0);
  153. REPLACE INTO vehicle_seat_data VALUES (3077, 3),(3106, 8);
  154. UPDATE creature_template SET minhealth = 630000, maxhealth = 630000, unit_flags = 32768, IconName = 'Gunner' WHERE entry = 33167;
  155. DELETE FROM creature WHERE id = 33167;
  156.  
  157. /* Ulduar Salvaged vehicles (unifieddb fix) */
  158. DELETE FROM creature_addon WHERE guid IN (SELECT guid FROM creature WHERE id IN (33060,33062,33109));
  159.  
  160. /* Wintergrasp Tower Cannon (new) */
  161. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (28366);
  162. INSERT INTO npc_spellclick_spells VALUES (28366, 60968, 0, 0, 0, 1);
  163. REPLACE INTO creature_template_addon VALUES (28366, 0, 0, 0, 0, 0, 244, NULL, NULL);
  164. REPLACE INTO vehicle_data VALUES (244, 5, 51362, 51421, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  165. REPLACE INTO vehicle_seat_data VALUES (2283, 3);
  166. UPDATE creature_template SET IconName = 'Gunner' WHERE entry = 28366;
  167.  
  168. /* the Oculus (new) */
  169. DELETE FROM spell_script_target WHERE entry IN (49460, 49346, 49464);
  170. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (27755, 27692, 27756);
  171. DELETE FROM creature_template_addon WHERE entry IN (27755, 27692, 27756);
  172. UPDATE creature_template SET IconName = 'vehichleCursor', InhabitType = 3 WHERE entry IN (27755,27756,27692);
  173. /* Amber Drake */
  174. INSERT INTO spell_script_target VALUES (49460, 1, 27755);
  175. INSERT INTO npc_spellclick_spells VALUES (27755, 49459, 0, 0, 0, 1);
  176. INSERT INTO creature_template_addon VALUES (27755, 0, 0, 0, 0, 0, 70, NULL, '48602 0 48602 2');
  177. REPLACE INTO vehicle_data VALUES (70, 12, 49840, 49838, 49592, 0, 0, 0, 0, 0, 0, 0, 0);
  178. REPLACE INTO vehicle_seat_data VALUES (1323, 3);
  179. /* Emerald Drake */
  180. INSERT INTO spell_script_target VALUES (49346, 1, 27692);
  181. INSERT INTO npc_spellclick_spells VALUES (27692, 49427, 0, 0, 0, 1);
  182. INSERT INTO creature_template_addon VALUES (27692, 0, 0, 0, 0, 0, 181, NULL, '48602 0 48602 2');
  183. REPLACE INTO vehicle_data VALUES (181, 12, 50328, 50341, 50344, 0, 0, 0, 0, 0, 0, 0, 0);
  184. REPLACE INTO vehicle_seat_data VALUES (2081, 3);
  185. /* Ruby Drake */
  186. INSERT INTO spell_script_target VALUES (49464, 1, 27756);
  187. INSERT INTO npc_spellclick_spells VALUES (27756, 49463, 0, 0, 0, 1);
  188. INSERT INTO creature_template_addon VALUES (27756, 0, 0, 0, 0, 0, 186, NULL, '48602 0 48602 2');
  189. REPLACE INTO vehicle_data VALUES (186, 12, 50232, 50248, 50240, 0, 0, 0, 0, 0, 0, 0, 0);
  190. REPLACE INTO vehicle_seat_data VALUES (2089, 3);
  191.  
  192. /* vehicle accessory */
  193. REPLACE INTO creature_template_addon (`entry`,`passengers`) VALUES (27850,'27905 1');
  194. REPLACE INTO creature_template_addon (`entry`,`vehicle_id`,`passengers`) VALUES
  195. (32930,328,'32933 1 32934 7'),(33114,341,'33142 1 33143 2'),(33214,348,'33218 1'),(33113,387,'33114 0 33114 1 33114 2 33114 3 33139 7');
  196.  
  197. /* 7th Legion Chain Gun */
  198. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (27714);
  199. INSERT INTO npc_spellclick_spells VALUES (27714, 65403, 0, 0, 0, 1);
  200. REPLACE INTO creature_template_addon VALUES (27714, 0, 0, 0, 0, 0, 68, NULL, NULL);
  201. REPLACE INTO vehicle_data VALUES (68, 5, 49190, 49550, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  202. REPLACE INTO vehicle_seat_data VALUES (1301, 1);
  203. UPDATE creature_template SET IconName = 'Gunner' WHERE entry IN (27714);
  204.  
  205. /* Alliance Steam Tank */
  206. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (27587);
  207. INSERT INTO npc_spellclick_spells VALUES (27587, 43695, 0, 0, 0, 0);
  208. REPLACE INTO creature_template_addon VALUES (27587, 0, 0, 0, 0, 0, 56, NULL, NULL);
  209. REPLACE INTO vehicle_data VALUES (56, 4, 49315, 49333, 49109, 49081, 0, 0, 0, 0, 0, 0, 0);
  210. REPLACE INTO vehicle_seat_data VALUES (945, 3),(946, 8),(949, 8),(950, 8);
  211. REPLACE INTO spell_area (`spell`,`area`) VALUES (49081, 4246);
  212. UPDATE creature_template SET modelid_1 = 25341, modelid_2 = 0, modelid_3 = 0, IconName = 'vehichleCursor' WHERE entry IN (27587);
  213. UPDATE creature_model_info SET modelid_other_gender = 0 WHERE modelid = 25341;
  214. -- UPDATE creature_template_addon SET passengers = '27163 1 27588 2 27588 3' WHERE entry = 27587;
  215.  
  216. /* Broken-down Shredder */
  217. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (27354);
  218. INSERT INTO npc_spellclick_spells VALUES (27354, 65403, 0, 0, 0, 1);
  219. REPLACE INTO creature_template_addon VALUES (27354, 0, 0, 0, 0, 0, 49, NULL, NULL);
  220. REPLACE INTO vehicle_data VALUES (49, 4, 48558, 48604, 48548, 0, 48610, 0, 0, 0, 0, 0, 0);
  221. REPLACE INTO vehicle_seat_data VALUES (821, 1);
  222. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry IN (27354);
  223.  
  224. /* Enraged Mammoth */
  225. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (28851);
  226. INSERT INTO npc_spellclick_spells VALUES (28851, 65403, 0, 0, 0, 1);
  227. REPLACE INTO creature_template_addon VALUES (28851, 0, 0, 0, 0, 0, 145, NULL, NULL);
  228. REPLACE INTO vehicle_data VALUES (145, 4, 52603, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  229. REPLACE INTO vehicle_seat_data VALUES (1906, 3);
  230. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry IN (28851);
  231.  
  232. /* Flamebringer */
  233. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (27292);
  234. INSERT INTO npc_spellclick_spells VALUES (27292, 65403, 0, 0, 0, 1);
  235. REPLACE INTO creature_template_addon VALUES (27292, 0, 0, 0, 0, 0, 50, NULL, NULL);
  236. REPLACE INTO vehicle_data VALUES (50, 4, 48619, 48620, 52812, 0, 0, 0, 0, 0, 0, 0, 0);
  237. REPLACE INTO vehicle_seat_data VALUES (841, 3);
  238. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry IN (27292);
  239.  
  240. /* Forsaken Blight Spreader */
  241. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (26523);
  242. INSERT INTO npc_spellclick_spells VALUES (26523, 47961, 0, 0, 0, 1);
  243. REPLACE INTO creature_template_addon VALUES (26523, 0, 0, 0, 0, 0, 36, NULL, NULL);
  244. REPLACE INTO vehicle_data VALUES (36, 4, 48211, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  245. REPLACE INTO vehicle_seat_data VALUES (644, 3);
  246. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry = 26523;
  247.  
  248. /* Highland Mustang */
  249. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (26472);
  250. INSERT INTO npc_spellclick_spells VALUES (26472, 65403, 0, 0, 0, 1);
  251. REPLACE INTO creature_template_addon VALUES (26472, 0, 0, 0, 0, 0, 62, NULL, NULL);
  252. REPLACE INTO vehicle_data VALUES (62, 4, 49285, 29577, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  253. REPLACE INTO vehicle_seat_data VALUES (1270, 3);
  254. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry IN (26472);
  255.  
  256. /* Horde Siege Tank */
  257. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (25334);
  258. INSERT INTO npc_spellclick_spells VALUES (25334, 43695, 0, 0, 0, 0);
  259. REPLACE INTO creature_template_addon VALUES (25334, 0, 0, 0, 0, 0, 26, NULL, NULL);
  260. REPLACE INTO vehicle_data VALUES (26, 4, 50672, 45750, 50677, 47849, 47962, 0, 0, 0, 0, 0, 0);
  261. REPLACE INTO vehicle_seat_data VALUES (365,3),(366,6),(367,6),(368,6);
  262. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry = 25334;
  263.  
  264. /* Infected Kodo Beast */
  265. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (25596);
  266. INSERT INTO npc_spellclick_spells VALUES (25596, 45875, 11690, 1, 11690, 1);
  267. REPLACE INTO creature_template_addon VALUES (25596, 0, 0, 0, 0, 0, 29, NULL, NULL);
  268. REPLACE INTO vehicle_data VALUES (29, 12, 45876, 45877, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  269. REPLACE INTO vehicle_seat_data VALUES (422, 3);
  270. UPDATE creature_template SET speed_run = 2, IconName = 'vehichleCursor' WHERE entry = 25596;
  271. REPLACE INTO spell_script_target VALUES (45877, 1, 25596);
  272.  
  273. /* Kor'kron War Rider */
  274. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (26813);
  275. INSERT INTO npc_spellclick_spells VALUES (26813, 47424, 0, 0, 0, 1);
  276. REPLACE INTO creature_template_addon VALUES (26813, 0, 0, 0, 0, 0, 80, NULL, '48602 0 48602 2');
  277. REPLACE INTO vehicle_data VALUES (80, 4, 47434, 63507, 47454, 0, 0, 0, 0, 0, 0, 0, 0);
  278. REPLACE INTO vehicle_seat_data VALUES (1431, 3),(1432, 2);
  279. UPDATE creature_template SET modelid_2 = 0, modelid_3 = 0, IconName = 'vehichleCursor' WHERE entry IN (26813);
  280.  
  281. /* Kor'kron War Rider II */
  282. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (26572);
  283. INSERT INTO npc_spellclick_spells VALUES (26572, 47424, 0, 0, 0, 1);
  284. REPLACE INTO creature_template_addon VALUES (26572, 0, 0, 0, 0, 0, 34, NULL, '48602 0 48602 2');
  285. REPLACE INTO vehicle_data VALUES (34, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  286. REPLACE INTO vehicle_seat_data VALUES (601, 3);
  287. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry IN (26572);
  288.  
  289. /* Onslaught Warhorse */
  290. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (27213);
  291. INSERT INTO npc_spellclick_spells VALUES (27213, 65403, 0, 0, 0, 1);
  292. REPLACE INTO creature_template_addon VALUES (27213, 0, 0, 0, 0, 0, 43, NULL, NULL);
  293. REPLACE INTO vehicle_data VALUES (43, 4, 48297, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  294. REPLACE INTO vehicle_seat_data VALUES (742, 3);
  295. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry = 27213;
  296.  
  297. /* Refurbished Shredder */
  298. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (27496);
  299. INSERT INTO npc_spellclick_spells VALUES (27496, 60944, 0, 0, 0, 1);
  300. REPLACE INTO creature_template_addon VALUES (27496, 0, 0, 0, 0, 0, 55, NULL, NULL);
  301. REPLACE INTO vehicle_data VALUES (55, 4, 48548, 48604, 48558, 0, 48610, 0, 0, 0, 0, 0, 0);
  302. REPLACE INTO vehicle_seat_data VALUES (922, 1);
  303. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry IN (27496);
  304.  
  305. /* Rocket Propelled Warhead */
  306. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (27593);
  307. INSERT INTO npc_spellclick_spells VALUES (27593, 49177, 0, 0, 0, 1);
  308. REPLACE INTO creature_template_addon VALUES (27593, 0, 0, 0, 0, 0, 57, NULL, NULL);
  309. REPLACE INTO vehicle_data VALUES (57, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  310. REPLACE INTO vehicle_seat_data VALUES (961, 1);
  311. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry IN (27593);
  312.  
  313. /* Steel Gate Flying Machine */
  314. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (24418);
  315. INSERT INTO npc_spellclick_spells VALUES (24418, 65403, 0, 0, 0, 1);
  316. REPLACE INTO creature_template_addon VALUES (24418, 0, 0, 0, 0, 0, 8, NULL, '48602 0 48602 2');
  317. REPLACE INTO vehicle_data VALUES (8, 4, 44009, 43770, 43799, 43769, 47769, 0, 0, 0, 0, 0, 0);
  318. REPLACE INTO vehicle_seat_data VALUES (261, 1),(461, 2);
  319. UPDATE creature_template SET IconName = 'vehichleCursor', InhabitType = 3 WHERE entry IN (24418);
  320.  
  321. /* Wintergarde Gryphon */
  322. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (27258);
  323. INSERT INTO npc_spellclick_spells VALUES (27258, 49288, 0, 0, 0, 1);
  324. REPLACE INTO creature_template_addon VALUES (27258, 0, 0, 0, 0, 0, 44, NULL, '48602 0 48602 2');
  325. REPLACE INTO vehicle_data VALUES (44, 4, 48363, 48397, 54170, 0, 0, 0, 0, 0, 0, 0, 0);
  326. REPLACE INTO vehicle_seat_data VALUES (762, 1),(764, 2);
  327. UPDATE creature_template SET IconName = 'vehichleCursor', InhabitType = 3 WHERE entry IN (27258);
  328.  
  329. /* Wintergarde Gryphon II, Into Hostile Territory quest */
  330. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (27661);
  331. INSERT INTO npc_spellclick_spells VALUES (27661, 48862, 0, 0, 0, 1);
  332. REPLACE INTO creature_template_addon VALUES (27661, 0, 0, 0, 0, 0, 61, NULL, '48602 0 48602 2');
  333. REPLACE INTO vehicle_data VALUES (61, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  334. REPLACE INTO vehicle_seat_data VALUES (1267, 1),(1268, 2);
  335. UPDATE creature_template SET IconName = 'vehichleCursor', InhabitType = 3 WHERE entry IN (27661);
  336.  
  337. /* Wooly Mammoth Bull */
  338. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (25743);
  339. INSERT INTO npc_spellclick_spells VALUES (25743, 43695, 11879, 1, 11879, 1);
  340. REPLACE INTO creature_template_addon VALUES (25743, 0, 0, 0, 0, 0, 72, NULL, NULL);
  341. REPLACE INTO vehicle_data VALUES (72, 12, 46317, 46315, 46316, 0, 0, 0, 0, 0, 0, 0, 0);
  342. REPLACE INTO vehicle_seat_data VALUES (1362, 3);
  343. UPDATE creature_template SET faction_A = 7, faction_H = 7, IconName = 'vehichleCursor' WHERE entry IN (25743);
  344.  
  345. /* Wyrmrest Defender */
  346. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (27629);
  347. INSERT INTO npc_spellclick_spells VALUES (27629, 49256, 12372, 1, 12372, 1);
  348. REPLACE INTO creature_template_addon VALUES (27629,0,50331648,1,0,0,60,NULL,'50069 0 50069 1 50069 2');
  349. REPLACE INTO vehicle_data VALUES (60,4,49161,49243,49263,49264,49367,0,0,0,0,0,0);
  350. REPLACE INTO vehicle_seat_data VALUES (1262, 3);
  351. UPDATE creature_template SET IconName = 'vehichleCursor', InhabitType = 3 WHERE entry IN (27629);
  352.  
  353. /* Wyrmrest Skytalon */
  354. DELETE FROM npc_spellclick_spells WHERE npc_entry = 32535;
  355. INSERT INTO npc_spellclick_spells VALUES (32535, 61245, 0, 0, 0, 1);
  356. REPLACE INTO creature_template_addon VALUES (32535, 0, 0, 0, 0, 0, 165, NULL, '48602 0 48602 2');
  357. REPLACE INTO vehicle_data VALUES (165, 12, 56091, 61621, 57090, 57143, 57108, 57092, 0, 0, 0, 0, 0);
  358. REPLACE INTO vehicle_seat_data VALUES (2061, 3);
  359. REPLACE INTO spell_script_target VALUES (61245,1,32535);
  360. UPDATE creature_template SET IconName = 'vehichleCursor', InhabitType = 3 WHERE entry = 32535;
  361.  
  362. /* Wyrmrest Vanquisher */
  363. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (27996);
  364. INSERT INTO npc_spellclick_spells VALUES (27996, 65403, 0, 0, 0, 1);
  365. REPLACE INTO creature_template_addon VALUES (27996, 0, 50331648, 1, 0, 0, 99, NULL, '48602 0 48602 2');
  366. REPLACE INTO vehicle_data VALUES (99, 4, 50430, 55987, 50348, 0, 0, 0, 0, 0, 0, 0, 0);
  367. REPLACE INTO vehicle_seat_data VALUES (1520, 3),(1521, 8);
  368. UPDATE creature_template SET IconName = 'vehichleCursor', InhabitType = 3 WHERE entry IN (27996);
  369.  
  370. /* Fizzcrank Bomber */
  371. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (25765);
  372. INSERT INTO npc_spellclick_spells VALUES (25765, 65403, 0, 0, 0, 1);
  373. REPLACE INTO creature_template_addon VALUES (25765, 0, 0, 0, 0, 0, 492, NULL, '48602 0 48602 2');
  374. REPLACE INTO vehicle_data VALUES (492, 4, 45971, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  375. REPLACE INTO vehicle_seat_data VALUES (5506, 3);
  376. UPDATE creature_template SET IconName = 'vehichleCursor', InhabitType = 3 WHERE entry IN (25765);
  377.  
  378. /* Dusk */
  379. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (26191);
  380. INSERT INTO npc_spellclick_spells VALUES (26191, 65403, 0, 0, 0, 1);
  381. REPLACE INTO creature_template_addon VALUES (26191, 0, 0, 0, 0, 0, 200, NULL, NULL);
  382. REPLACE INTO vehicle_data VALUES (200, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  383. REPLACE INTO vehicle_seat_data VALUES (2144, 3);
  384. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry IN (26191);
  385.  
  386. /* Tatjana's Horse */
  387. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (27626);
  388. INSERT INTO npc_spellclick_spells VALUES (27626, 65403, 0, 0, 0, 1);
  389. REPLACE INTO creature_template_addon VALUES (27626, 0, 0, 0, 0, 0, 59, NULL, NULL);
  390. REPLACE INTO vehicle_data VALUES (59, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  391. REPLACE INTO vehicle_seat_data VALUES (1241, 3),(1242, 2);
  392. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry IN (27626);
  393.  
  394. /* Antipersonnel Cannon */
  395. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (27894);
  396. INSERT INTO npc_spellclick_spells VALUES (27894, 65403, 0, 0, 0, 1);
  397. REPLACE INTO creature_template_addon VALUES (27894, 0, 0, 0, 0, 0, 160, NULL, NULL);
  398. REPLACE INTO vehicle_data VALUES (160, 5, 49872, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  399. REPLACE INTO vehicle_seat_data VALUES (2029, 3);
  400. UPDATE creature_template SET IconName = 'Gunner' WHERE entry IN (27894);
  401.  
  402. /* Antipersonnel Cannon II */
  403. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (32795);
  404. INSERT INTO npc_spellclick_spells VALUES (32795, 65403, 0, 0, 0, 1);
  405. REPLACE INTO creature_template_addon VALUES (32795, 0, 0, 0, 0, 0, 160, NULL, NULL);
  406. REPLACE INTO vehicle_data VALUES (160, 5, 49872, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  407. REPLACE INTO vehicle_seat_data VALUES (2029, 3);
  408. UPDATE creature_template SET IconName = 'Gunner' WHERE entry IN (32795);
  409.  
  410. /* Wintergrasp Demolisher */
  411. UPDATE creature_template SET maxhealth = 50000, minhealth = 50000 WHERE entry = 28094;
  412. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (28094);
  413. INSERT INTO npc_spellclick_spells VALUES (28094, 60968, 0, 0, 0, 1);
  414. REPLACE INTO creature_template_addon VALUES (28094, 0, 0, 0, 0, 0, 106, NULL, NULL);
  415. REPLACE INTO vehicle_data VALUES (106, 4, 50896, 50652, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  416. REPLACE INTO vehicle_seat_data VALUES (1554, 3),(1556, 6),(1557, 6);
  417. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry IN (28094);
  418.  
  419. /* Wintergrasp Siege Engine */
  420. UPDATE creature_template SET maxhealth = 75000, minhealth = 75000 WHERE entry IN (28312,32627);
  421. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (28312);
  422. INSERT INTO npc_spellclick_spells VALUES (28312, 60968, 0, 0, 0, 1);
  423. REPLACE INTO creature_template_addon VALUES (28312, 0, 0, 0, 0, 0, 117, '28319 7', NULL);
  424. REPLACE INTO vehicle_data VALUES (117, 4, 51678, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  425. REPLACE INTO vehicle_seat_data VALUES (1648, 3),(1649, 2),(1650, 2),(1652, 4);
  426. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry IN (28312);
  427.  
  428. /* Wintergrasp Siege Engine II */
  429. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (32627);
  430. INSERT INTO npc_spellclick_spells VALUES (32627, 60968, 0, 0, 0, 1);
  431. REPLACE INTO creature_template_addon VALUES (32627, 0, 0, 0, 0, 0, 324, '32629 7', NULL);
  432. REPLACE INTO vehicle_data VALUES (324, 4, 51678, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  433. REPLACE INTO vehicle_seat_data VALUES (2863, 3),(2864, 2),(2865, 2),(2866, 2);
  434. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry IN (32627);
  435.  
  436. /* Wintergrasp Siege Turret */
  437. UPDATE creature_template SET maxhealth = 50000, minhealth = 50000 WHERE entry IN (28319,32629);
  438. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (28319);
  439. INSERT INTO npc_spellclick_spells VALUES (28319, 60968, 0, 0, 0, 1);
  440. REPLACE INTO creature_template_addon VALUES (28319, 0, 0, 0, 0, 0, 116, NULL, NULL);
  441. REPLACE INTO vehicle_data VALUES (116, 5, 51362, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  442. REPLACE INTO vehicle_seat_data VALUES (1643, 3);
  443. UPDATE creature_template SET IconName = 'Gunner' WHERE entry IN (28319);
  444.  
  445. /* Wintergrasp Siege Turret II */
  446. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (32629);
  447. INSERT INTO npc_spellclick_spells VALUES (32629, 60968, 0, 0, 0, 1);
  448. REPLACE INTO creature_template_addon VALUES (32629, 0, 0, 0, 0, 0, 116, NULL, NULL);
  449. REPLACE INTO vehicle_data VALUES (116, 5, 51362, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  450. REPLACE INTO vehicle_seat_data VALUES (1643, 3);
  451. UPDATE creature_template SET IconName = 'Gunner' WHERE entry IN (32629);
  452.  
  453. /* Battleground Demolisher */
  454. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (28781);
  455. INSERT INTO npc_spellclick_spells VALUES (28781, 65403, 0, 0, 0, 1);
  456. REPLACE INTO creature_template_addon VALUES (28781, 0, 0, 0, 0, 0, 158, NULL, NULL);
  457. REPLACE INTO vehicle_data VALUES (158, 4, 52338, 60206, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  458. REPLACE INTO vehicle_seat_data VALUES (2021, 3),(2023, 2),(2024, 2);
  459. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry IN (28781);
  460.  
  461. /* Battleground Demolisher II */
  462. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (32796);
  463. INSERT INTO npc_spellclick_spells VALUES (32796, 65403, 0, 0, 0, 1);
  464. REPLACE INTO creature_template_addon VALUES (32796, 0, 0, 0, 0, 0, 158, NULL, NULL);
  465. REPLACE INTO vehicle_data VALUES (158, 4, 52338, 60206, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  466. REPLACE INTO vehicle_seat_data VALUES (2021, 3),(2023, 2),(2024, 2);
  467. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry IN (32796);
  468.  
  469. /* Frostbite */
  470. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (29857);
  471. INSERT INTO npc_spellclick_spells VALUES (29857, 65403, 0, 0, 0, 1);
  472. REPLACE INTO creature_template_addon VALUES (29857, 0, 0, 0, 0, 0, 202, NULL, NULL);
  473. REPLACE INTO vehicle_data VALUES (202, 4, 54996, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  474. REPLACE INTO vehicle_seat_data VALUES (2164, 3);
  475. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry IN (29857);
  476.  
  477. /* Valkyrion Harpoon Gun */
  478. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (30066);
  479. INSERT INTO npc_spellclick_spells VALUES (30066, 44002, 12953, 1, 12953, 1);
  480. REPLACE INTO creature_template_addon VALUES (30066, 0, 0, 0, 0, 0, 213, NULL, NULL);
  481. REPLACE INTO vehicle_data VALUES (213, 5, 55812, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  482. REPLACE INTO vehicle_seat_data VALUES (2186, 1);
  483. UPDATE creature_template SET IconName = 'Gunner' WHERE entry IN (30066);
  484.  
  485. /* Argent Skytalon */
  486. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (30228);
  487. INSERT INTO npc_spellclick_spells VALUES (30228, 65403, 0, 0, 0, 1);
  488. REPLACE INTO creature_template_addon VALUES (30228, 0, 50331648, 1, 0, 0, 234, NULL, '48602 0 48602 2');
  489. REPLACE INTO vehicle_data VALUES (234, 4, 56683, 56684, 56712, 0, 0, 0, 0, 0, 0, 0, 0);
  490. REPLACE INTO vehicle_seat_data VALUES (2235, 1),(2236, 8);
  491. UPDATE creature_template SET IconName = 'vehichleCursor', InhabitType = 3 WHERE entry IN (30228);
  492.  
  493. /* Jotunheim Rapid-Fire Harpoon */
  494. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (30337);
  495. INSERT INTO npc_spellclick_spells VALUES (30337, 65403, 0, 0, 0, 1);
  496. REPLACE INTO creature_template_addon VALUES (30337, 0, 0, 0, 0, 0, 229, NULL, NULL);
  497. REPLACE INTO vehicle_data VALUES (229, 5, 0, 0, 56570, 0, 0, 0, 0, 0, 0, 0, 0);
  498. REPLACE INTO vehicle_seat_data VALUES (2229, 1);
  499. UPDATE creature_template SET IconName = 'Gunner' WHERE entry IN (30337);
  500.  
  501. /* Nergeld */
  502. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (30403);
  503. INSERT INTO npc_spellclick_spells VALUES (30403, 56699, 0, 0, 0, 1);
  504. REPLACE INTO creature_template_addon VALUES (30403, 0, 0, 0, 0, 0, 236, NULL, NULL);
  505. REPLACE INTO vehicle_data VALUES (236, 4, 60540, 56746, 56748, 56747, 0, 0, 0, 0, 0, 0, 0);
  506. REPLACE INTO vehicle_seat_data VALUES (2238, 3);
  507. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry IN (30403);
  508.  
  509. /* Kor'kron Suppression Turret */
  510. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (31884);
  511. INSERT INTO npc_spellclick_spells VALUES (31884, 65403, 0, 0, 0, 1);
  512. REPLACE INTO creature_template_addon VALUES (31884, 0, 0, 0, 0, 0, 291, NULL, NULL);
  513. REPLACE INTO vehicle_data VALUES (291, 5, 59880, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  514. REPLACE INTO vehicle_seat_data VALUES (2553, 3);
  515. UPDATE creature_template SET IconName = 'Gunner' WHERE entry IN (31884);
  516.  
  517. /* Flame Leviathan Seat */
  518. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (33114);
  519. -- INSERT INTO npc_spellclick_spells VALUES (33114, 65403, 0, 0, 0, 1);
  520. REPLACE INTO creature_template_addon VALUES (33114, 0, 0, 0, 0, 0, 341, NULL, NULL);
  521. REPLACE INTO vehicle_data VALUES (341, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  522. REPLACE INTO vehicle_seat_data VALUES (3044, 1),(3075, 0),(3076, 0);
  523. UPDATE creature_template SET IconName = 'Gunner' WHERE entry IN (33114);
  524.  
  525. /* Brann's Flying Machine */
  526. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (34120);
  527. INSERT INTO npc_spellclick_spells VALUES (34120, 65403, 0, 0, 0, 1);
  528. REPLACE INTO creature_template_addon VALUES (34120, 0, 0, 0, 0, 0, 390, NULL, '48602 0 48602 2');
  529. REPLACE INTO vehicle_data VALUES (390, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  530. REPLACE INTO vehicle_seat_data VALUES (3926, 3);
  531. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry IN (34120);
  532.  
  533. /* Catapult */
  534. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (34793);
  535. INSERT INTO npc_spellclick_spells VALUES (34793, 65403, 0, 0, 0, 1);
  536. REPLACE INTO creature_template_addon VALUES (34793, 0, 0, 0, 0, 0, 438, NULL, NULL);
  537. REPLACE INTO vehicle_data VALUES (438, 4, 66218, 66296, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  538. REPLACE INTO vehicle_seat_data VALUES (4706, 3),(4726, 2);
  539. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry IN (34793);
  540.  
  541. /* Argent Warhorse */
  542. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (36557,35644);
  543. INSERT INTO npc_spellclick_spells VALUES (36557, 65403, 0, 0, 0, 1),(35644, 65403, 0, 0, 0, 1);
  544. REPLACE INTO creature_template_addon VALUES (36557, 0, 0, 0, 0, 0, 486, NULL, NULL),(35644, 0, 0, 0, 0, 0, 486, NULL, NULL);
  545. REPLACE INTO vehicle_data VALUES (486, 4, 68505, 62575, 68282, 66482, 0, 0, 0, 0, 0, 0, 0);
  546. REPLACE INTO vehicle_seat_data VALUES (5406, 3);
  547. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry IN (36557,35644);
  548.  
  549. /* Argent Battleworg */
  550. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (36559,36558);
  551. INSERT INTO npc_spellclick_spells VALUES (36559, 65403, 0, 0, 0, 1),(36558, 65403, 0, 0, 0, 1);
  552. REPLACE INTO creature_template_addon VALUES (36559, 0, 0, 0, 0, 0, 529, NULL, NULL),(36558, 0, 0, 0, 0, 0, 529, NULL, NULL);
  553. REPLACE INTO vehicle_data VALUES (529, 4, 68282, 62575, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  554. REPLACE INTO vehicle_seat_data VALUES (6126, 3);
  555. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry IN (36559,36558);
  556.  
  557. /* Keep Cannon */
  558. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (34944);
  559. INSERT INTO npc_spellclick_spells VALUES (34944, 65403, 0, 0, 0, 1);
  560. REPLACE INTO creature_template_addon VALUES (34944, 0, 0, 0, 0, 0, 510, NULL, NULL);
  561. REPLACE INTO vehicle_data VALUES (510, 5, 68169, 66541, 68170, 67452, 0, 0, 0, 0, 0, 0, 0);
  562. REPLACE INTO vehicle_seat_data VALUES (5786, 3);
  563. UPDATE creature_template SET IconName = 'Gunner' WHERE entry IN (34944);
  564.  
  565. /* Alliance Gunship Cannon */
  566. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (34929);
  567. INSERT INTO npc_spellclick_spells VALUES (34929, 65403, 0, 0, 0, 1);
  568. REPLACE INTO creature_template_addon VALUES (34929, 0, 0, 0, 0, 0, 452, NULL, NULL);
  569. REPLACE INTO vehicle_data VALUES (452, 5, 69495, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  570. REPLACE INTO vehicle_seat_data VALUES (4888, 3);
  571. UPDATE creature_template SET IconName = 'Gunner' WHERE entry IN (34929);
  572.  
  573. /* Alliance Gunship Cannon II */
  574. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (36838);
  575. INSERT INTO npc_spellclick_spells VALUES (36838, 65403, 0, 0, 0, 1);
  576. REPLACE INTO creature_template_addon VALUES (36838, 0, 0, 0, 0, 0, 554, NULL, NULL);
  577. REPLACE INTO vehicle_data VALUES (554, 5, 70174, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  578. REPLACE INTO vehicle_seat_data VALUES (6488, 3);
  579. UPDATE creature_template SET IconName = 'Gunner' WHERE entry IN (36838);
  580.  
  581. /* Horde Gunship Cannon */
  582. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (34935);
  583. INSERT INTO npc_spellclick_spells VALUES (34935, 65403, 0, 0, 0, 1);
  584. REPLACE INTO creature_template_addon VALUES (34935, 0, 0, 0, 0, 0, 453, NULL, NULL);
  585. REPLACE INTO vehicle_data VALUES (453, 5, 68825, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  586. REPLACE INTO vehicle_seat_data VALUES (4906, 3);
  587. UPDATE creature_template SET IconName = 'Gunner' WHERE entry IN (34935);
  588.  
  589. /* Demolisher */
  590. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (34775);
  591. INSERT INTO npc_spellclick_spells VALUES (34775, 65403, 0, 0, 0, 1);
  592. REPLACE INTO creature_template_addon VALUES (34775, 0, 0, 0, 0, 0, 509, NULL, NULL);
  593. REPLACE INTO vehicle_data VALUES (509, 4, 68068, 67440, 67442, 67441, 0, 0, 0, 0, 0, 0, 0);
  594. REPLACE INTO vehicle_seat_data VALUES (5766, 3),(5767, 2),(5768, 2);
  595. UPDATE creature_template SET IconName = 'vehichleCursor' WHERE entry IN (34775);
  596.  
  597. /* Broken Keep Cannon */
  598. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (35819);
  599. INSERT INTO npc_spellclick_spells VALUES (35819, 65403, 0, 0, 0, 1);
  600. REPLACE INTO creature_template_addon VALUES (35819, 0, 0, 0, 0, 0, 655, NULL, NULL);
  601. REPLACE INTO vehicle_data VALUES (655, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  602. UPDATE creature_template SET IconName = 'Gunner' WHERE entry IN (35819);
  603.  
  604. /* Flame Turret */
  605. DELETE FROM npc_spellclick_spells WHERE npc_entry IN (36356);
  606. INSERT INTO npc_spellclick_spells VALUES (36356, 65403, 0, 0, 0, 1);
  607. REPLACE INTO creature_template_addon VALUES (36356, 0, 0, 0, 0, 0, 436, NULL, NULL);
  608. REPLACE INTO vehicle_data VALUES (436, 5, 68832, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  609. REPLACE INTO vehicle_seat_data VALUES (4690, 3);
  610. UPDATE creature_template SET IconName = 'Gunner' WHERE entry IN (36356);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!