API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 19th, 2017
59
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.81 KB | None | 0 0
raw download clone embed print report
  1. -- Fix possibile Deeprun Tram
  2. UPDATE gameobject SET rotation0 = '0', rotation1 = '0', rotation2 = 0, rotation3 = 1 WHERE id IN (176080,176081,176082,176083,176084,176085);
  3.  
  4. -- Fix Stat Boss ToC5
  5. DELETE FROM creature_template WHERE entry IN (34942,35032,35041,35520,35531,35536,35540,35541,35544);
  6. INSERT INTO `creature_template` VALUES (34942, 35531, 0, 0, 0, 0, 29525, 0, 0, 0, 'Memory of Hogger', '', '', 0, 82, 82, 390949, 390949, 0, 0, 0, 10328, 14, 14, 0, 1, 1.14286, 1, 1, 452, 678, 0, 169, 15, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 362, 542, 135, 7, 72, 0, 0, 0, 0, 0, 0, 0, 0, 0, 66620, 67679, 66619, 67678, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 29, 25, 0, 0, 0, 0, 0, 0, 0, 150, 1, 0, 0, 0, 0, 803160063, 0, 'mob_toc5_memory');
  7. INSERT INTO `creature_template` VALUES (35032, 35540, 0, 0, 0, 0, 25840, 0, 0, 0, 'Memory of Thunderaan', '', '', 0, 82, 82, 485316, 485316, 0, 0, 0, 10328, 14, 14, 0, 1, 1.14286, 1, 1, 452, 678, 0, 169, 2, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 362, 542, 135, 4, 72, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 29, 25, 0, 0, 0, 0, 0, 0, 0, 150, 1, 0, 0, 0, 0, 0, 0, 'mob_toc5_memory');
  8. INSERT INTO `creature_template` VALUES (35041, 35520, 0, 0, 0, 0, 29546, 0, 0, 0, 'Memory of Archimonde', '', '', 0, 82, 82, 390949, 390949, 0, 0, 0, 10328, 14, 14, 0, 1, 1.14286, 1, 1, 452, 678, 0, 169, 15, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 362, 542, 135, 3, 72, 0, 0, 0, 0, 0, 0, 0, 0, 0, 66620, 67679, 66619, 67678, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 29, 25, 0, 0, 0, 0, 0, 0, 0, 150, 1, 0, 0, 0, 0, 803160063, 0, 'mob_toc5_memory');
  9. INSERT INTO `creature_template` VALUES (35520, 0, 0, 0, 35041, 0, 29546, 0, 0, 0, 'Memory of Archimonde (1)', '', '', 0, 82, 82, 390949, 390949, 0, 0, 0, 10328, 14, 14, 0, 1, 1.14286, 1, 1, 452, 678, 0, 169, 15, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 362, 542, 135, 3, 72, 0, 0, 0, 0, 0, 0, 0, 0, 0, 66620, 67679, 66619, 67678, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 36, 25, 0, 0, 0, 0, 0, 0, 0, 150, 1, 0, 0, 0, 0, 803160063, 0, '');
  10. INSERT INTO `creature_template` VALUES (35531, 0, 0, 0, 34942, 0, 29525, 0, 0, 0, 'Memory of Hogger (1)', '', '', 0, 82, 82, 485316, 485316, 0, 0, 0, 10328, 14, 14, 0, 1, 1.14286, 1, 1, 452, 678, 0, 169, 15, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 362, 542, 135, 7, 72, 0, 0, 0, 0, 0, 0, 0, 0, 0, 66620, 67679, 66619, 67678, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 36, 25, 0, 0, 0, 0, 0, 0, 0, 150, 1, 0, 0, 0, 0, 803160063, 0, '');
  11. INSERT INTO `creature_template` VALUES (35536, 0, 0, 0, 35031, 0, 29562, 0, 0, 0, 'Memory of Lucifron (1)', '', '', 0, 82, 82, 485316, 485316, 0, 0, 0, 10328, 14, 14, 0, 1, 1.14286, 1, 1, 452, 678, 0, 169, 15, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 362, 542, 135, 7, 72, 0, 0, 0, 0, 0, 0, 0, 0, 0, 66620, 66619, 66552, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 36, 25, 0, 0, 0, 0, 0, 0, 0, 150, 1, 0, 0, 0, 0, 0, 0, '');
  12. INSERT INTO `creature_template` VALUES (35540, 0, 0, 0, 0, 0, 25840, 0, 0, 0, 'Memory of Thunderaan (1)', '', '', 0, 82, 82, 485316, 485316, 0, 0, 0, 10328, 14, 14, 0, 1, 1.14286, 1, 1, 452, 678, 0, 169, 2, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 362, 542, 135, 4, 72, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 36, 25, 0, 0, 0, 0, 0, 0, 0, 150, 1, 0, 0, 0, 0, 0, 0, '');
  13. INSERT INTO `creature_template` VALUES (35541, 0, 0, 0, 35028, 0, 29536, 0, 0, 0, 'Memory of VanCleef (1)', '', '', 0, 82, 82, 485316, 485316, 0, 0, 0, 10328, 14, 14, 0, 1, 1.14286, 1, 1, 452, 678, 0, 169, 15, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 362, 542, 135, 7, 72, 0, 0, 0, 0, 0, 0, 0, 0, 0, 66620, 67679, 66619, 67678, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 36, 25, 0, 0, 0, 0, 0, 0, 0, 150, 1, 0, 0, 0, 0, 803160063, 0, '');
  14. INSERT INTO `creature_template` VALUES (35544, 0, 0, 0, 35051, 0, 29552, 0, 0, 0, 'Memory of Vezax (1)', '', '', 0, 82, 82, 390949, 390949, 0, 229000, 229000, 8262, 14, 14, 0, 1, 1.14286, 1, 1, 330, 495, 0, 124, 20.5, 2000, 2000, 8, 0, 0, 0, 0, 0, 0, 0, 264, 396, 99, 10, 72, 0, 0, 0, 0, 0, 0, 0, 0, 0, 66620, 67679, 66619, 67678, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 36, 25, 0, 0, 0, 0, 0, 0, 0, 150, 1, 0, 0, 0, 0, 803160063, 0, '');
  15.  
  16.  
  17. -- Flag Boss ToC5
  18. UPDATE creature_template SET mechanic_immune_mask = 803160063 WHERE entry IN (36085,36090,36084,35517,35530,35490,35568,36089,35518,36091,35522,35541,35538,35527,35524,35534,35539,35529,35537,35528,36087,35542,35533,36086,36083,36082,36088,35535,35525,35546,35543,35531,35536,35540,35521,35520,35523,35532,35544,35519,35569,35571,35617,34928,35030,35451,35564,35572,35119,35570,35046,35028,35029,35039,35047,35045,35048,35049,35038,35034,34703,35040,35042,34657,34701,34702,34705,35037,35044,35545,35036,34942,35031,35032,35033,35041,35043,35050,35051,35052);
  19.  
  20. -- Mount veicoli
  21. UPDATE creature SET deathstate = 1 WHERE id IN (36559,36557);
  22.  
  23. -- Annunciatori in Heroic
  24. UPDATE creature_template SET difficulty_entry_1 = 35604 WHERE entry = 35005;
  25. UPDATE creature_template SET difficulty_entry_1 = 35589 WHERE entry = 35004;
  26. -- Archimonde in Heroic
  27. UPDATE creature_template SET difficulty_entry_1 = 35520 WHERE entry = 35041;
  28.  
  29.  
  30. -- Loot
  31. UPDATE gameobject_template SET data1 = 195709 WHERE entry = 195709;
  32. UPDATE gameobject_template SET data1 = 195710 WHERE entry = 195710;
  33. UPDATE gameobject_template SET data1 = 195374 WHERE entry = 195374;
  34. UPDATE gameobject_template SET data1 = 195375 WHERE entry = 195375;
  35. UPDATE gameobject_template SET data1 = 195323 WHERE entry = 195323;
  36. UPDATE gameobject_template SET data1 = 195324 WHERE entry = 195324;
  37. UPDATE creature_template SET lootid = 35451 WHERE entry = 35451;
  38. UPDATE creature_template SET lootid = 35490 WHERE entry = 35490;
  39. DELETE FROM gameobject_loot_template WHERE entry IN ('195709', '195710', '195374', '195375', '195323', '195324');
  40. DELETE FROM creature_loot_template WHERE entry IN (35451, 35490);
  41. INSERT INTO `gameobject_loot_template` VALUES (195323, 43228, 100, 0, 3, 3, 1, 57940, 0);
  42. INSERT INTO `gameobject_loot_template` VALUES (195323, 47177, 100, 0, -47177, 1, 0, 0, 0);
  43. INSERT INTO `gameobject_loot_template` VALUES (195323, 47211, 0, 1, 1, 1, 0, 0, 0);
  44. INSERT INTO `gameobject_loot_template` VALUES (195323, 47212, 0, 1, 1, 1, 0, 0, 0);
  45. INSERT INTO `gameobject_loot_template` VALUES (195323, 47214, 0, 1, 1, 1, 0, 0, 0);
  46. INSERT INTO `gameobject_loot_template` VALUES (195323, 47217, 0, 1, 1, 1, 0, 0, 0);
  47. INSERT INTO `gameobject_loot_template` VALUES (195323, 47218, 0, 1, 1, 1, 0, 0, 0);
  48. INSERT INTO `gameobject_loot_template` VALUES (195323, 47219, 0, 1, 1, 1, 0, 0, 0);
  49. INSERT INTO `gameobject_loot_template` VALUES (195323, 47514, 11.4312, 0, 1, 1, 0, 0, 0);
  50. INSERT INTO `gameobject_loot_template` VALUES (195324, 43228, 100, 0, 4, 4, 1, 57940, 0);
  51. INSERT INTO `gameobject_loot_template` VALUES (195324, 44990, 100, 0, 1, 1, 0, 0, 0);
  52. INSERT INTO `gameobject_loot_template` VALUES (195324, 47241, 100, 0, 1, 1, 0, 0, 0);
  53. INSERT INTO `gameobject_loot_template` VALUES (195324, 47245, 0, 1, 1, 1, 0, 0, 0);
  54. INSERT INTO `gameobject_loot_template` VALUES (195324, 47497, 100, 0, -47497, 1, 0, 0, 0);
  55. INSERT INTO `gameobject_loot_template` VALUES (195324, 47510, 0, 1, 1, 1, 0, 0, 0);
  56. INSERT INTO `gameobject_loot_template` VALUES (195324, 47511, 0, 1, 1, 1, 0, 0, 0);
  57. INSERT INTO `gameobject_loot_template` VALUES (195324, 47512, 0, 1, 1, 1, 0, 0, 0);
  58. INSERT INTO `gameobject_loot_template` VALUES (195324, 47514, 0, 1, 1, 1, 0, 0, 0);
  59. INSERT INTO `gameobject_loot_template` VALUES (195324, 47522, 0, 1, 1, 1, 0, 0, 0);
  60. INSERT INTO `gameobject_loot_template` VALUES (195374, 43228, 100, 0, 3, 3, 1, 57940, 0);
  61. INSERT INTO `gameobject_loot_template` VALUES (195374, 47177, 100, 0, -47177, 1, 0, 0, 0);
  62. INSERT INTO `gameobject_loot_template` VALUES (195374, 47197, 0, 1, 1, 1, 0, 0, 0);
  63. INSERT INTO `gameobject_loot_template` VALUES (195374, 47199, 0, 1, 1, 1, 0, 0, 0);
  64. INSERT INTO `gameobject_loot_template` VALUES (195374, 47200, 0, 1, 1, 1, 0, 0, 0);
  65. INSERT INTO `gameobject_loot_template` VALUES (195374, 47201, 0, 1, 1, 1, 0, 0, 0);
  66. INSERT INTO `gameobject_loot_template` VALUES (195374, 47202, 0, 1, 1, 1, 0, 0, 0);
  67. INSERT INTO `gameobject_loot_template` VALUES (195374, 47210, 0, 1, 1, 1, 0, 0, 0);
  68. INSERT INTO `gameobject_loot_template` VALUES (195375, 43228, 100, 0, 4, 4, 1, 57940, 0);
  69. INSERT INTO `gameobject_loot_template` VALUES (195375, 44990, 100, 0, 1, 1, 0, 0, 0);
  70. INSERT INTO `gameobject_loot_template` VALUES (195375, 47241, 100, 0, 1, 1, 0, 0, 0);
  71. INSERT INTO `gameobject_loot_template` VALUES (195375, 47497, 100, 0, -47497, 1, 0, 0, 0);
  72. INSERT INTO `gameobject_loot_template` VALUES (195375, 47501, 0, 1, 1, 1, 0, 0, 0);
  73. INSERT INTO `gameobject_loot_template` VALUES (195375, 47502, 0, 1, 1, 1, 0, 0, 0);
  74. INSERT INTO `gameobject_loot_template` VALUES (195375, 47503, 0, 1, 1, 1, 0, 0, 0);
  75. INSERT INTO `gameobject_loot_template` VALUES (195375, 47504, 0, 1, 1, 1, 0, 0, 0);
  76. INSERT INTO `gameobject_loot_template` VALUES (195375, 47508, 0, 1, 1, 1, 0, 0, 0);
  77. INSERT INTO `gameobject_loot_template` VALUES (195709, 43228, 100, 0, 3, 3, 1, 57940, 0);
  78. INSERT INTO `gameobject_loot_template` VALUES (195709, 47170, 0, 1, 1, 1, 0, 0, 0);
  79. INSERT INTO `gameobject_loot_template` VALUES (195709, 47171, 0, 1, 1, 1, 0, 0, 0);
  80. INSERT INTO `gameobject_loot_template` VALUES (195709, 47172, 0, 1, 1, 1, 0, 0, 0);
  81. INSERT INTO `gameobject_loot_template` VALUES (195709, 47173, 0, 1, 1, 1, 0, 0, 0);
  82. INSERT INTO `gameobject_loot_template` VALUES (195709, 47174, 0, 1, 1, 1, 0, 0, 0);
  83. INSERT INTO `gameobject_loot_template` VALUES (195709, 47175, 0, 1, 1, 1, 0, 0, 0);
  84. INSERT INTO `gameobject_loot_template` VALUES (195710, 43228, 100, 0, 4, 4, 1, 57940, 0);
  85. INSERT INTO `gameobject_loot_template` VALUES (195710, 44990, 100, 0, 1, 1, 0, 0, 0);
  86. INSERT INTO `gameobject_loot_template` VALUES (195710, 47241, 100, 0, 1, 1, 0, 0, 0);
  87. INSERT INTO `gameobject_loot_template` VALUES (195710, 47243, 0, 1, 1, 1, 0, 0, 0);
  88. INSERT INTO `gameobject_loot_template` VALUES (195710, 47244, 0, 1, 1, 1, 0, 0, 0);
  89. INSERT INTO `gameobject_loot_template` VALUES (195710, 47248, 0, 1, 1, 1, 0, 0, 0);
  90. INSERT INTO `gameobject_loot_template` VALUES (195710, 47249, 0, 1, 1, 1, 0, 0, 0);
  91. INSERT INTO `gameobject_loot_template` VALUES (195710, 47250, 0, 1, 1, 1, 0, 0, 0);
  92. INSERT INTO `gameobject_loot_template` VALUES (195710, 47493, 0, 1, 1, 1, 0, 0, 0);
  93. INSERT INTO `reference_loot_template` VALUES (47177, 47176, 0, 1, 1, 1, 0, 0, 0);
  94. INSERT INTO `reference_loot_template` VALUES (47177, 47177, 0, 1, 1, 1, 0, 0, 0);
  95. INSERT INTO `reference_loot_template` VALUES (47177, 47178, 0, 1, 1, 1, 0, 0, 0);
  96. INSERT INTO `reference_loot_template` VALUES (47177, 47181, 0, 1, 1, 1, 0, 0, 0);
  97. INSERT INTO `reference_loot_template` VALUES (47177, 47185, 0, 1, 1, 1, 0, 0, 0);
  98. INSERT INTO `reference_loot_template` VALUES (47177, 47213, 0, 1, 1, 1, 0, 0, 0);
  99. INSERT INTO `reference_loot_template` VALUES (47497, 47494, 0, 1, 1, 1, 0, 0, 0);
  100. INSERT INTO `reference_loot_template` VALUES (47497, 47495, 0, 1, 1, 1, 0, 0, 0);
  101. INSERT INTO `reference_loot_template` VALUES (47497, 47496, 0, 1, 1, 1, 0, 0, 0);
  102. INSERT INTO `reference_loot_template` VALUES (47497, 47497, 0, 1, 1, 1, 0, 0, 0);
  103. INSERT INTO `reference_loot_template` VALUES (47497, 47498, 0, 1, 1, 1, 0, 0, 0);
  104. INSERT INTO `reference_loot_template` VALUES (47497, 47500, 0, 1, 1, 1, 0, 0, 0);
  105. INSERT INTO `reference_loot_template` VALUES (47497, 47509, 0, 1, 1, 1, 0, 0, 0);
  106. INSERT INTO `creature_loot_template` VALUES (35451, 43228, 100, 0, 3, 3, 1, 57940, 0);
  107. INSERT INTO `creature_loot_template` VALUES (35451, 47215, 0, 2, 1, 1, 0, 0, 0);
  108. INSERT INTO `creature_loot_template` VALUES (35451, 47216, 0, 2, 1, 1, 0, 0, 0);
  109. INSERT INTO `creature_loot_template` VALUES (35451, 47220, 0, 1, 1, 1, 0, 0, 0);
  110. INSERT INTO `creature_loot_template` VALUES (35451, 47221, 0, 1, 1, 1, 0, 0, 0);
  111. INSERT INTO `creature_loot_template` VALUES (35451, 47222, 0, 1, 1, 1, 0, 0, 0);
  112. INSERT INTO `creature_loot_template` VALUES (35451, 47226, 0, 2, 1, 1, 0, 0, 0);
  113. INSERT INTO `creature_loot_template` VALUES (35451, 47227, 0, 2, 1, 1, 0, 0, 0);
  114. INSERT INTO `creature_loot_template` VALUES (35451, 47228, 0, 1, 1, 1, 0, 0, 0);
  115. INSERT INTO `creature_loot_template` VALUES (35451, 47229, 0, 2, 1, 1, 0, 0, 0);
  116. INSERT INTO `creature_loot_template` VALUES (35451, 47230, 0, 1, 1, 1, 0, 0, 0);
  117. INSERT INTO `creature_loot_template` VALUES (35451, 47231, 0, 1, 1, 1, 0, 0, 0);
  118. INSERT INTO `creature_loot_template` VALUES (35451, 47232, 0, 2, 1, 1, 0, 0, 0);
  119. INSERT INTO `creature_loot_template` VALUES (35490, 43102, 100, 0, 1, 1, 0, 0, 0);
  120. INSERT INTO `creature_loot_template` VALUES (35490, 43228, 100, 0, 4, 4, 1, 57940, 0);
  121. INSERT INTO `creature_loot_template` VALUES (35490, 44990, 100, 0, 1, 1, 0, 0, 0);
  122. INSERT INTO `creature_loot_template` VALUES (35490, 47241, 100, 0, 1, 1, 0, 0, 0);
  123. INSERT INTO `creature_loot_template` VALUES (35490, 47527, 0, 1, 1, 1, 0, 0, 0);
  124. INSERT INTO `creature_loot_template` VALUES (35490, 47529, 0, 1, 1, 1, 0, 0, 0);
  125. INSERT INTO `creature_loot_template` VALUES (35490, 47560, 0, 2, 1, 1, 0, 0, 0);
  126. INSERT INTO `creature_loot_template` VALUES (35490, 47561, 0, 1, 1, 1, 0, 0, 0);
  127. INSERT INTO `creature_loot_template` VALUES (35490, 47562, 0, 1, 1, 1, 0, 0, 0);
  128. INSERT INTO `creature_loot_template` VALUES (35490, 47563, 0, 1, 1, 1, 0, 0, 0);
  129. INSERT INTO `creature_loot_template` VALUES (35490, 47564, 0, 2, 1, 1, 0, 0, 0);
  130. INSERT INTO `creature_loot_template` VALUES (35490, 47565, 0, 2, 1, 1, 0, 0, 0);
  131. INSERT INTO `creature_loot_template` VALUES (35490, 47566, 0, 1, 1, 1, 0, 0, 0);
  132. INSERT INTO `creature_loot_template` VALUES (35490, 47567, 0, 2, 1, 1, 0, 0, 0);
  133. INSERT INTO `creature_loot_template` VALUES (35490, 47568, 0, 2, 1, 1, 0, 0, 0);
  134. INSERT INTO `creature_loot_template` VALUES (35490, 47569, 0, 2, 1, 1, 0, 0, 0);
  135. INSERT INTO `creature_loot_template` VALUES (35490, 48418, -100, 0, 1, 1, 0, 0, 0);
  136. INSERT INTO `creature_loot_template` VALUES (35490, 49682, 0, 2, 1, 1, 0, 0, 0);
  137.  
  138.  
  139. -- Campeones - Campeon del Alba Argenta - Caballero Negro
  140.  
  141. -- Eadric non si tiene addosso il buff Vengeance (se ne va dopo neanche un secondo)
  142. -- Eadric non sembra castare il Radiance (la spell funge)
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!