Advertisement
Guest User

Untitled

a guest
Sep 23rd, 2017
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.82 KB | None | 0 0
  1. -- instance oculus
  2. UPDATE creature_template SET unit_flags=0 WHERE entry=30879;
  3. UPDATE gameobject_template SET AIName="SmartGameObjectAI" WHERE entry=188715;
  4. UPDATE creature_template SET AIName="SmartAI" WHERE entry IN(27636, 27633, 27635, 27638, 27639, 27640, 28276, 27642, 27644, 27645, 27647, 27648, 27650, 27651, 27653, 28239);
  5. UPDATE creature_template SET ScriptName="npc_oculus_drakes" WHERE entry IN(27692, 27755, 27756);
  6. UPDATE creature_template SET ScriptName="npc_arcane_beam" WHERE entry=28239;
  7.  
  8. UPDATE creature_template SET mingold=7666, maxgold=12776 WHERE entry IN(30901, 30904, 30915, 30916, 31558, 31559, 31560);
  9. UPDATE creature_template SET mingold=3866, maxgold=6433 WHERE entry IN(27654, 27447);
  10.  
  11. UPDATE creature_template SET speed_walk=2.8 WHERE entry IN(27755, 27756, 27692);
  12.  
  13. DELETE FROM spell_script_names WHERE spell_id IN(50341, 49838, 49840, 50240, 49592);
  14. INSERT INTO spell_script_names VALUES
  15. (50341, "spell_emerald_drake_touch_the_nightmare"),
  16. (49840, "spell_amber_drake_schock_lance"),
  17. (49838, "spell_amber_drake_time_stop"),
  18. (50240, "spell_ruby_drake_evasive_maneuvers"),
  19. (49592, "spell_amber_drake_temporal_rift");
  20.  
  21. DELETE FROM spell_proc_event WHERE entry=50240;
  22. INSERT INTO spell_proc_event VALUES
  23. (50240, 0, 0, 0, 0, 0, 0, 0x0000004, 0, 100, 0);
  24.  
  25. DELETE FROM smart_scripts WHERE entryorguid IN (27636, 27633, 27635, 27638, 27639, 27640, 28276, 27642, 27644, 27645, 27647, 27648,27650, 27651, 27653, 188715);
  26. INSERT INTO smart_scripts VALUES
  27. -- trash
  28. (27636, 0, 0, 0, 0, 0, 100, 0x02, 2000, 4000, 2000, 4000, 11, 50705, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Ley-Whelp - Arcane Bolt normal"),
  29. (27636, 0, 1, 0, 0, 0, 100, 0x04, 2000, 4000, 2000, 4000, 11, 59210, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Ley-Whelp - Arcane Bolt heroic"),
  30. (27633, 0, 0, 0, 0, 0, 100, 0, 3000, 5000, 6000, 8000, 11, 50573, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Azure Inquisitor - Arcane Cleave"),
  31. (27633, 0, 1, 0, 0, 0, 100, 0, 9000, 10000, 15000, 20000, 11, 50690, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Azure Inquisitor - immobilizing field"),
  32. (27633, 0, 2, 0, 9, 0, 100, 0x02, 5, 30, 3000, 5000, 11, 51454, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Azure Inquisitor - Throw normal"),
  33. (27633, 0, 3, 0, 9, 0, 100, 0x04, 5, 30, 3000, 5000, 11, 59209, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Azure Inquisitor - Throw heroic"),
  34. (27635, 0, 0, 0, 0, 0, 100, 0x02, 3000, 5000, 7000, 10000, 11, 50702, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Azure Spellbinder - Arcane Volley normal"),
  35. (27635, 0, 1, 0, 0, 0, 100, 0x04, 3000, 5000, 7000, 10000, 11, 59212, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Azure Spellbinder - Arcane Volley heroic"),
  36. (27635, 0, 2, 0, 0, 0, 100, 0x02, 7000, 9000, 15000, 20000, 11, 50566, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, "Azure Spellbinder - Mind Warp normal"),
  37. (27635, 0, 3, 0, 0, 0, 100, 0x04, 7000, 9000, 15000, 20000, 11, 38047, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, "Azure Spellbinder - Mind Warp heroic"),
  38. (27635, 0, 4, 0, 0, 0, 100, 0, 10000, 13000, 20000, 25000, 11, 50572, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, "Azure Spellbinder - Power Sap"),
  39. (27638, 0, 0, 0, 0, 0, 100, 0x02, 3000, 6000, 14000, 18000, 11, 49549, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Azure Ring Guardian - Ice Beam normal"),
  40. (27638, 0, 1, 0, 0, 0, 100, 0x04, 3000, 6000, 14000, 18000, 11, 59211, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Azure Ring Guardian - Ice Beam heroic"),
  41. (27639, 0, 0, 0, 0, 0, 100, 0x02, 4000, 5000, 12000, 15000, 11, 50715, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Ring-Lord Sorceress - Blizzard normal"),
  42. (27639, 0, 1, 0, 0, 0, 100, 0x04, 4000, 5000, 12000, 15000, 11, 59278, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Ring-Lord Sorceress - Blizzard heroic"),
  43. (27639, 0, 2, 0, 0, 0, 100, 0x02, 10000, 12000, 19000, 22000, 11, 16102, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, "Ring-Lord Sorceress - Flamestrike normal"),
  44. (27639, 0, 3, 0, 0, 0, 100, 0x04, 10000, 12000, 19000, 22000, 11, 61402, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, "Ring-Lord Sorceress - Flamestrike heroic"),
  45. (27640, 0, 0, 0, 4, 0, 100, 0x02, 0, 0, 0, 0, 11, 50717, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Ring-Lord Conjurer - Charged Skin normal"),
  46. (27640, 0, 1, 0, 4, 0, 100, 0x04, 0, 0, 0, 0, 11, 59276, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Ring-Lord Conjurer - Charged Skin normal"),
  47. (28276, 0, 0, 0, 0, 0, 100, 0x02, 2000, 4000, 4000, 7000, 11, 62249, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Ley-Whelp - Arcane Bolt normal"),
  48. (28276, 0, 1, 0, 0, 0, 100, 0x04, 2000, 4000, 4000, 7000, 11, 62250, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Ley-Whelp - Arcane Bolt heroic"),
  49.  
  50. -- Mage-Lord adds
  51. (27642, 0, 0, 0, 9, 0, 100, 0, 8, 25, 6000, 8000, 11, 32323, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Phantasmal Mammoth - Charge"),
  52. (27642, 0, 1, 0, 0, 0, 100, 0, 4000, 6000, 10000, 12000, 11, 51253, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Phantasmal Mammoth - Trample"),
  53. (27644, 0, 0, 0, 0, 0, 100, 0x02, 3000, 6000, 12000, 14000, 11, 50728, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Phantasmal Wolf - Furious Howl normal"),
  54. (27644, 0, 1, 0, 0, 0, 100, 0x04, 3000, 6000, 12000, 14000, 11, 59274, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Phantasmal Wolf - Furious Howl heroic"),
  55. (27644, 0, 2, 0, 0, 0, 100, 0x02, 5000, 8000, 14000, 17000, 11, 50729, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Phantasmal Wolf - Carnivorous Bite normal"),
  56. (27644, 0, 3, 0, 0, 0, 100, 0x04, 5000, 8000, 14000, 17000, 11, 59269, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Phantasmal Wolf - Carnivorous Bite normal"),
  57. (27645, 0, 0, 0, 0, 0, 100, 0x02, 6000, 8000, 8000, 10000, 11, 59220, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Phantasmal Cloudscraper - Chain Lightning normal"),
  58. (27645, 0, 1, 0, 0, 0, 100, 0x04, 6000, 8000, 8000, 10000, 11, 15588, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Phantasmal Cloudscraper - Chain Lightning heroic"),
  59. (27645, 0, 2, 0, 0, 0, 100, 0x02, 2000, 4000, 10000, 12000, 11, 15588, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Phantasmal Cloudscraper - Thunderclap normal"),
  60. (27645, 0, 3, 0, 0, 0, 100, 0x04, 2000, 4000, 10000, 12000, 11, 59217, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Phantasmal Cloudscraper - Thunderclap heroic"),
  61. (27647, 0, 0, 0, 0, 0, 100, 0, 2000, 5000, 7000, 9000, 11, 50731, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Phantasmal Ogre - Mace Smash"),
  62. (27647, 0, 1, 0, 0, 0, 100, 0, 8000, 12000, 25000, 35000, 11, 50730, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Phantasmal Ogre - Bloodlust"),
  63. (27648, 0, 0, 0, 0, 0, 100, 0x02, 3000, 5000, 12000, 14000, 11, 50732, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Phantasmal Naga - Water Tomb normal"),
  64. (27648, 0, 1, 0, 0, 0, 100, 0x04, 3000, 5000, 12000, 14000, 11, 59261, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Phantasmal Naga - Water Tomb heroic"),
  65. (27650, 0, 0, 0, 0, 0, 100, 0x02, 1000, 3000, 15000, 2000, 75, 25020, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Phantasmal Air - Lightning Shield normal"),
  66. (27650, 0, 1, 0, 0, 0, 100, 0x04, 1000, 3000, 15000, 2000, 75, 20545, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Phantasmal Air - Lightning Shield heroic"),
  67. (27651, 0, 0, 0, 0, 0, 100, 0x02, 3000, 5000, 5000, 8000, 11, 50744, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Phantasmal Fire - Blaze normal"),
  68. (27651, 0, 1, 0, 0, 0, 100, 0x04, 3000, 5000, 5000, 8000, 11, 59225, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Phantasmal Fire - Blaze heroic"),
  69. (27653, 0, 0, 0, 0, 0, 100, 0x02, 5000, 8000, 7000, 9000, 11, 37924, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Phantasmal Water - Water Bolt Volley normal"),
  70. (27653, 0, 1, 0, 0, 0, 100, 0x04, 5000, 8000, 7000, 9000, 11, 59266, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Phantasmal Water - Water Bolt Volley heroic"),
  71.  
  72. -- misc
  73. (188715, 1, 0, 0, 64, 0, 100, 0, 0, 0, 0, 0, 62, 571, 0, 0, 0, 0, 0, 7, 0, 0, 0, 3872.2, 6984.4, 108.2, 0, "Teleport on Orb use");
  74.  
  75. DELETE FROM creature_loot_template WHERE entry IN(30901, 30902, 30904, 30905, 30906, 30907, 30908, 30909, 30910, 30911, 30912, 30913, 30914, 30915, 30916);
  76. INSERT INTO creature_loot_template VALUES
  77. (30902, 33631, 73, 1, 0, 1, 1),
  78. (30902, 33632, 17, 1, 0, 1, 1),
  79. (30902, 37366, 1, 1, 0, 1, 1),
  80. (30902, 37365, 1, 1, 0, 1, 1),
  81. (30902, 37364, 1, 1, 0, 1, 1),
  82. (30902, 43297, 0.1, 1, 0, 1, 1),
  83. (30902, 45912, 0.1, 1, 0, 1, 1),
  84. (30901, 33470, 33, 1, 0, 1, 7),
  85. (30901, 43852, 19, 1, 0, 1, 1),
  86. (30901, 33454, 8, 1, 0, 1, 1),
  87. (30901, 33445, 4, 1, 0, 1, 1),
  88. (30901, 33447, 2, 1, 0, 1, 1),
  89. (30901, 33448, 2, 1, 0, 1, 1),
  90. (30901, 37364, 1.2, 1, 0, 1, 1),
  91. (30901, 37366, 1, 1, 0, 1, 1),
  92. (30901, 37365, 1, 1, 0, 1, 1),
  93. (30901, 43297, 0.1, 1, 0, 1, 1),
  94. (30901, 45912, 0.1, 1, 0, 1, 1),
  95. (30904, 33470, 31, 1, 0, 1, 7),
  96. (30904, 43852, 19, 1, 0, 1, 1),
  97. (30904, 33454, 7, 1, 0, 1, 1),
  98. (30904, 33445, 4, 1, 0, 1, 1),
  99. (30904, 33447, 2, 1, 0, 1, 1),
  100. (30904, 37366, 1, 1, 0, 1, 1),
  101. (30904, 37365, 1, 1, 0, 1, 1),
  102. (30904, 37364, 1, 1, 0, 1, 1),
  103. (30904, 43297, 0.1, 1, 0, 1, 1),
  104. (30904, 45912, 0.1, 1, 0, 1, 1),
  105. (30916, 33470, 32, 1, 0, 1, 7),
  106. (30916, 43852, 18, 1, 0, 1, 1),
  107. (30916, 33454, 8, 1, 0, 1, 1),
  108. (30916, 33445, 4, 1, 0, 1, 1),
  109. (30916, 33447, 2, 1, 0, 1, 1),
  110. (30916, 37366, 1, 1, 0, 1, 1),
  111. (30916, 37365, 1, 1, 0, 1, 1),
  112. (30916, 37364, 1, 1, 0, 1, 1),
  113. (30916, 43297, 0.1, 1, 0, 1, 1),
  114. (30916, 45912, 0.1, 1, 0, 1, 1),
  115. (30915, 33470, 33, 1, 0, 1, 7),
  116. (30915, 43852, 19, 1, 0, 1, 1),
  117. (30915, 33454, 8, 1, 0, 1, 1),
  118. (30915, 33445, 4, 1, 0, 1, 1),
  119. (30915, 33447, 2, 1, 0, 1, 1),
  120. (30915, 33478, 2, 1, 0, 1, 1),
  121. (30915, 37366, 1, 1, 0, 1, 1),
  122. (30915, 37365, 1, 1, 0, 1, 1),
  123. (30915, 37364, 1, 1, 0, 1, 1),
  124. (30915, 43297, 0.1, 1, 0, 1, 1),
  125. (30915, 45912, 0.1, 1, 0, 1, 1),
  126. (30905, 39209, 72, 1, 0, 1, 1),
  127. (30905, 39210, 17, 1, 0, 1, 1),
  128. (30905, 37366, 1, 1, 0, 1, 1),
  129. (30905, 37365, 1, 1, 0, 1, 1),
  130. (30905, 37364, 1, 1, 0, 1, 1),
  131. (30905, 43297, 0.1, 1, 0, 1, 1),
  132. (30905, 45912, 0.1, 1, 0, 1, 1),
  133. (30906, 39512, 72, 1, 0, 1, 4),
  134. (30906, 37700, 28, 1, 0, 1, 4),
  135. (30906, 39513, 17, 1, 0, 1, 4),
  136. (30906, 37366, 1, 1, 0, 1, 1),
  137. (30906, 37365, 1, 1, 0, 1, 1),
  138. (30906, 37364, 1, 1, 0, 1, 1),
  139. (30908, 39512, 69, 1, 0, 1, 4),
  140. (30908, 37702, 30, 1, 0, 1, 4),
  141. (30908, 39513, 18, 1, 0, 1, 4),
  142. (30908, 37366, 1.7, 1, 0, 1, 1),
  143. (30908, 37365, 1, 1, 0, 1, 1),
  144. (30908, 37364, 1, 1, 0, 1, 1),
  145. (30913, 39512, 72, 1, 0, 1, 4),
  146. (30913, 37705, 30, 1, 0, 1, 4),
  147. (30913, 39513, 18, 1, 0, 1, 4),
  148. (30913, 37366, 1, 1, 0, 1, 1),
  149. (30913, 37365, 1, 1, 0, 1, 1),
  150. (30913, 37364, 1, 1, 0, 1, 1),
  151. (30912, 33470, 33, 1, 0, 1, 4),
  152. (30912, 43852, 18, 1, 0, 1, 1),
  153. (30912, 33454, 7, 1, 0, 1, 1),
  154. (30912, 33445, 6, 1, 0, 1, 1),
  155. (30912, 33447, 2, 1, 0, 1, 1),
  156. (30912, 33764, 1.8, 1, 0, 1, 1),
  157. (30912, 36047, 1.1, 1, 0, 1, 1),
  158. (30912, 36148, 1.1, 1, 0, 1, 1),
  159. (30912, 37097, 1, 1, 0, 1, 1),
  160. (30912, 33448, 2, 1, 0, 1, 1),
  161. (30912, 36371, 1.3, 1, 0, 1, 1),
  162. (30912, 37366, 1, 1, 0, 1, 1),
  163. (30912, 37365, 1, 1, 0, 1, 1),
  164. (30912, 37364, 1, 1, 0, 1, 1),
  165. (30910, 17057, 27, 1, 0, 1, 1),
  166. (30910, 17058, 25, 1, 0, 1, 1),
  167. (30910, 33470, 19, 1, 0, 1, 1),
  168. (30910, 36781, 16, 1, 0, 1, 1),
  169. (30910, 43852, 12, 1, 0, 1, 1),
  170. (30910, 37365, 1.2, 1, 0, 1, 1),
  171. (30910, 33447, 2, 1, 0, 1, 1),
  172. (30910, 37366, 1, 1, 0, 1, 1),
  173. (30910, 37364, 1, 1, 0, 1, 1),
  174. (30911, 17057, 26, 1, 0, 1, 1),
  175. (30911, 17058, 25, 1, 0, 1, 1),
  176. (30911, 33470, 17, 1, 0, 1, 7),
  177. (30911, 36781, 14, 1, 0, 1, 1),
  178. (30911, 43853, 10, 1, 0, 1, 1),
  179. (30911, 37366, 1, 1, 0, 1, 1),
  180. (30911, 37365, 1, 1, 0, 1, 1),
  181. (30911, 37364, 1, 1, 0, 1, 1),
  182. (30914, 39211, 71, 1, 0, 1, 5),
  183. (30914, 43011, 46, 1, 0, 1, 1),
  184. (30914, 39212, 17, 1, 0, 1, 4),
  185. (30914, 43013, 13, 1, 0, 1, 1),
  186. (30914, 37366, 1, 1, 0, 1, 1),
  187. (30914, 37365, 1, 1, 0, 1, 1),
  188. (30914, 37364, 1, 1, 0, 1, 1),
  189. (30907, 39567, 73, 1, 0, 1, 5),
  190. (30907, 39568, 16, 1, 0, 1, 4),
  191. (30907, 37366, 1, 1, 0, 1, 1),
  192. (30907, 37365, 1, 1, 0, 1, 1),
  193. (30907, 37364, 1, 1, 0, 1, 1),
  194. (30909, 39562, 72, 1, 0, 1, 4),
  195. (30909, 34736, 49, 1, 0, 1, 1),
  196. (30909, 39563, 18, 1, 0, 1, 3),
  197. (30909, 43013, 11, 1, 0, 1, 1),
  198. (30909, 33422, 1, 1, 0, 1, 1),
  199. (30909, 37366, 1, 1, 0, 1, 1),
  200. (30909, 37365, 1, 1, 0, 1, 1),
  201. (30909, 37364, 1, 1, 0, 1, 1);
  202.  
  203. DELETE FROM script_texts WHERE Entry IN(-1578005,-1578006, -1578007, -1578008, -1578009, -1578010, -1578011, -1578012, -1578013, -1578014, -1578015, -1578016, -1578017, -1578018, -1578019, -1578020, -1578021, -1578022, -1578023, -1578024);
  204. INSERT INTO script_texts VALUES
  205. (27654, -1578005, "The prisoners shall not go free. The word of Malygos is law!", "", "", "", "", "", "", "", "", 0, 1, 0, 0, ""),
  206. (27654, -1578006, "A fitting punishment!", "", "", "", "", "", "", "", "", 0, 1, 0, 0, ""),
  207. (27654, -1578007, "Sentence: executed!", "", "", "", "", "", "", "", "", 0, 1, 0, 0, ""),
  208. (27654, -1578008, "Another casualty of war!", "", "", "", "", "", "", "", "", 0, 1, 0, 0, ""),
  209. (27654, -1578009, "The war... goes on.", "", "", "", "", "", "", "", "", 0, 1, 0, 0, ""),
  210. (27654, -1578010, "Intruders, your victory will be short-lived. I am Commander Varos Cloudstrider. My drakes control the skies and protect this conduit. I will see to it personally that the Oculus does not fall into your hands!", "", "", "", "", "", "", "", "", 0, 1, 0, 0, ""),
  211. (27654, -1578011, "It is too late to run!", "", "", "", "", "", "", "", "", 0, 1, 0, 0, ""),
  212. (27654, -1578012, "Gather 'round...", "", "", "", "", "", "", "", "", 0, 1, 0, 0, ""),
  213. (27654, -1578013, "None shall escape!", "", "", "", "", "", "", "", "", 0, 1, 0, 0, ""),
  214. (27654, -1578014, "I condemn you to death!", "", "", "", "", "", "", "", "", 0, 1, 0, 0, ""),
  215. (27654, -1578015, "Tremble, worms!", "", "", "", "", "", "", "", "", 0, 1, 0, 0, ""),
  216. (27654, -1578016, "I will crush you!", "", "", "", "", "", "", "", "", 0, 1, 0, 0, ""),
  217. (27654, -1578017, "Can you fly?", "", "", "", "", "", "", "", "", 0, 1, 0, 0, ""),
  218. (27655, -1578018, "Everything I've done... has been for Azeroth...", "", "", "", "", "", "", "", "", 0, 1, 0, 0, ""),
  219. (27655, -1578019, "If only you understood!", "", "", "", "", "", "", "", "", 0, 1, 0, 0, ""),
  220. (27655, -1578020, "Now do you see? Do you?!", "", "", "", "", "", "", "", "", 0, 1, 0, 0, ""),
  221. (27655, -1578021, "Unfortunate, but necessary.", "", "", "", "", "", "", "", "", 0, 1, 0, 0, ""),
  222. (27656, -1578022, "It's a long way down...", "", "", "", "", "", "", "", "", 0, 1, 0, 0, ""),
  223. (27656, -1578023, "Back to the earth with you!", "", "", "", "", "", "", "", "", 0, 1, 0, 0, ""),
  224. (27656, -1578024, "Enjoy the fall!", "", "", "", "", "", "", "", "", 0, 1, 0, 0, "");
  225.  
  226. DELETE FROM creature_onkill_reputation WHERE creature_id IN(30902, 30901, 30904, 30915, 30916, 30905, 30903, 31558, 31559, 31560, 31561);
  227. INSERT INTO creature_onkill_reputation VALUES
  228. (30902, 1037, 1052, 7, 0, 2, 7, 0, 2, 1),
  229. (30901, 1037, 1052, 7, 0, 15, 7, 0, 15, 1),
  230. (30904, 1037, 1052, 7, 0, 15, 7, 0, 15, 1),
  231. (30915, 1037, 1052, 7, 0, 15, 7, 0, 15, 1),
  232. (30916, 1037, 1052, 7, 0, 15, 7, 0, 15, 1),
  233. (30905, 1037, 1052, 7, 0, 30, 7, 0, 30, 1),
  234. (30903, 1037, 1052, 7, 0, 15, 7, 0, 15, 1),
  235. (31558, 1037, 1052, 7, 0, 250, 7, 0, 250, 1),
  236. (31559, 1037, 1052, 7, 0, 250, 7, 0, 250, 1),
  237. (31560, 1037, 1052, 7, 0, 250, 7, 0, 250, 1),
  238. (31561, 1037, 1052, 7, 0, 250, 7, 0, 250, 1);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement