API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 18th, 2011
338
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 166.39 KB | None | 0 0
raw download clone embed print report
  1. -- Naxxramas Worshiper (missing Fireball spell)
  2. UPDATE creature_template SET spell2 = 28732 WHERE entry = 16506;
  3. -- Maexxna Spiderling
  4. UPDATE creature_template SET faction_A = 21, faction_H = 21 WHERE entry = 17055;
  5. -- Maexxna Web Wrap
  6. UPDATE creature_template SET faction_A = 21, faction_H = 21 WHERE entry = 16486;
  7. -- Noth creatures
  8. UPDATE creature_template SET faction_A = 21, faction_H = 21 WHERE entry IN(16982, 16981, 16983);
  9. -- Noth teleport spells
  10. DELETE FROM spell_target_position WHERE id IN(29216, 29231);
  11. INSERT INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
  12. (29216, 533, 2631.37, -3529.68, 274.04, 0);
  13. INSERT INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
  14. (29231, 533, 2684.8, -3502.52, 261.31, 0);
  15. -- Noth summon spells
  16. DELETE FROM spell_target_position WHERE id IN(29217,29224,29225,29226,29227,29237,29238,29239,29247,29248,29249,29255,29256,29257,29258,29262,29267,29268);
  17. INSERT INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
  18. (29217, 533, 2642.34, -3485.28, 262.273, 6.17666),
  19. (29224, 533, 2646.55, -3471.47, 262.413, 5.43839),
  20. (29225, 533, 2651.09, -3464.07, 262.112, 5.45017),
  21. (29226, 533, 2722.29, -3514.68, 262.431, 2.87018),
  22. (29227, 533, 2663.92, -3464.7, 262.574, 5.15958),
  23. (29237, 533, 2648.83, -3467.3, 262.399, 5.46297),
  24. (29238, 533, 2684.95, -3457.55, 262.578, 4.62159),
  25. (29239, 533, 2706.78, -3461.59, 262.517, 4.00358),
  26. (29247, 533, 2648.83, -3467.3, 262.399, 5.46297),
  27. (29248, 533, 2704.13, -3462.44, 262.403, 4.31236),
  28. (29249, 533, 2722.42, -3514.74, 262.467, 3.09084),
  29. (29255, 533, 2704.22, -3461.86, 262.546, 4.37027),
  30. (29256, 533, 2669.42, -3463.75, 262.63, 5.07774),
  31. (29257, 533, 2724.82, -3466.21, 262.622, 3.85584),
  32. (29258, 533, 2722.03, -3514.3, 262.354, 2.84269),
  33. (29262, 533, 2726.13, -3534.64, 262.31, 2.60314),
  34. (29267, 533, 2711.72, -3458.56, 262.384, 4.02864),
  35. (29268, 533, 2646.93, -3470.95, 262.427, 5.51363);
  36. -- Gate Naxxramas
  37. DELETE FROM gameobject WHERE id IN(181126,181195,181235,194022,181197,181209,181198,181199,181200,181201,181202,181203,181241,181124,181125,181170,193426,181123,181120,181121,181225,181228,181212,181211,181210,181213,181577,181578,181576) AND map = 533;
  38. INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  39. (NULL, 181577, 533, 2909, -4025.02, 273.475, 3.14159, 0, 0, 1, 0, 180, 0, 1),
  40. (NULL, 181120, 533, 3339.16, -3100.64, 296.813, 3.14159, 0, 0, 1, 0, 180, 0, 1),
  41. (NULL, 181121, 533, 3421.86, -3017.51, 295.615, 3.14159, 0, 0, 1, 0, 180, 0, 1),
  42. (NULL, 181123, 533, 3317.97, -3254.35, 293.346, -1.5708, 0, 0, 1, 0, 180, 0, 1),
  43. (NULL, 181124, 533, 2750.49, -3384.36, 267.341, 0, 0, 0, 1, 0, 180, 0, 0),
  44. (NULL, 181125, 533, 2633.84, -3336.82, 267.084, 0, 0, 0, 1, 0, 180, 0, 1),
  45. (NULL, 181126, 533, 3202.67, -3475.94, 287.034, 3.14159, 0, 0, 1, 0, 180, 0, 0),
  46. (NULL, 181170, 533, 2692.07, -3360.78, 267.504, 3.14159, 0, 0, 1, 0, 180, 0, 0),
  47. (NULL, 181195, 533, 3143.96, -3572.22, 287.097, 2.35619, 0, 0, 1, 0, 180, 0, 1),
  48. (NULL, 181197, 533, 3452.74, -3863.67, 308.341, 3.14159, 0, 0, 1, 0, 180, 0, 0),
  49. (NULL, 181198, 533, 2963.16, -3476.83, 297.596, -2.35619, 0, 0, 1, 0, 180, 0, 0),
  50. (NULL, 181199, 533, 2847.43, -3489.47, 297.839, 3.14159, 0, 0, 1, 0, 180, 0, 0),
  51. (NULL, 181200, 533, 2737.66, -3489.72, 262.095, 3.14159, 0, 0, 1, 0, 180, 0, 0),
  52. (NULL, 181201, 533, 2684.28, -3559.36, 261.913, 1.5708, 0, 0, 1, 0, 180, 0, 1),
  53. (NULL, 181202, 533, 2822.93, -3685.3, 273.541, 3.14159, 0, 0, 1, 0, 180, 0, 1),
  54. (NULL, 181203, 533, 2771.5, -3737.34, 273.596, 1.5708, 0, 0, 1, 0, 180, 0, 1),
  55. (NULL, 181209, 533, 3427.56, -3846.01, 310.369, 0.001245, 0, 0, 1, 0, 180, 0, 1),
  56. (NULL, 181210, 533, 2991.71, -3420.18, 300.972, 3.14159, 0, 0, 1, 0, 180, 0, 1),
  57. (NULL, 181211, 533, 2991.58, -3448.51, 300.972, 3.14159, 0, 0, 1, 0, 180, 0, 1),
  58. (NULL, 181212, 533, 3020.08, -3448.65, 300.972, 3.14159, 0, 0, 1, 0, 180, 0, 1),
  59. (NULL, 181213, 533, 3019.93, -3420.31, 300.972, 3.14159, 0, 0, 1, 0, 180, 0, 1),
  60. (NULL, 194022, 533, 3121.47, -3791.07, 273.915, 3.14159, 0, 0, 1, 0, 180, 0, 1),
  61. (NULL, 181235, 533, 3318.65, -3695.85, 259.094, 3.14159, 0, 0, 1, 0, 180, 0, 0),
  62. (NULL, 181241, 533, 2909.69, -3947.28, 273.553, 3.14159, 0, 0, 1, 0, 180, 0, 0),
  63. (NULL, 181225, 533, 3536.81, -5158.41, 142.862, -1.77151, -0.774393, 0.632705, 1, 0, 604800, 0, 0),
  64. (NULL, 181228, 533, 3637.4, -5090.35, 143.231, 4.52682, 0, 0, 0, 0, 25, 0, 0),
  65. (NULL, 193426, 533, 2511.51, -2943.93, 245.552, 5.48707, 0, 0, 0.387631, -0.921815, -604800, 100, 1);
  66. -- Rotting Maggot
  67. UPDATE creature_template SET faction_A = 21, faction_H = 21 WHERE entry = 16057;
  68. -- Heigan erupts
  69. DELETE FROM gameobject WHERE id IN(181510,181511,181512,181513,181514,181515,181516,181517,181518,181519,181520,181521,181522,181523,181524,181525,181526,181527,181528,181529,181530,181531,181532,181533,181534,181535,181536,181537,181538,181539,181540,181541,181542,181543,181544,181545,181546,181547,181548,181549,181550,181551,181552,181676,181677,181678,181695);
  70. INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  71. (NULL, 181510, 533, 2787.26, -3654.13, 274.317, -2.74888, 0, 0, 1, 0, 180, 0, 1),
  72. (NULL, 181511, 533, 2782.4, -3660.4, 274.315, 2.11089, 0, 0, 1, 0, 180, 0, 1),
  73. (NULL, 181512, 533, 2778.43, -3651.31, 274.317, -2.74259, 0, 0, 1, 0, 180, 0, 1),
  74. (NULL, 181513, 533, 2774.3, -3660.66, 274.317, -0.183933, 0, 0, 1, 0, 180, 0, 1),
  75. (NULL, 181514, 533, 2757.84, -3659.56, 274.317, 1.97116, 0, 0, 1, 0, 180, 0, 1),
  76. (NULL, 181515, 533, 2755.24, -3649.9, 274.317, -2.88634, 0, 0, 1, 0, 180, 0, 1),
  77. (NULL, 181516, 533, 2763.55, -3654.04, 274.317, -2.88396, 0, 0, 1, 0, 180, 0, 1),
  78. (NULL, 181517, 533, 2793.24, -3664.13, 274.317, 0.635802, 0, 0, 1, 0, 180, 0, 1),
  79. (NULL, 181518, 533, 2802.51, -3664.73, 274.317, 0.635802, 0, 0, 1, 0, 180, 0, 1),
  80. (NULL, 181519, 533, 2812, -3671.98, 274.073, -0.473312, 0, 0, 1, 0, 180, 0, 1),
  81. (NULL, 181520, 533, 2810.56, -3680.58, 274.317, -3.09646, 0, 0, 1, 0, 180, 0, 1),
  82. (NULL, 181521, 533, 2800.15, -3682.71, 274.352, 1.03882, 0, 0, 1, 0, 180, 0, 1),
  83. (NULL, 181522, 533, 2805.96, -3691.67, 274.317, -1.84881, 0, 0, 1, 0, 180, 0, 1),
  84. (NULL, 181523, 533, 2795.81, -3677.56, 274.073, 2.85315, 0, 0, 1, 0, 180, 0, 1),
  85. (NULL, 181524, 533, 2792.33, -3684.13, 274.317, -1.30703, 0, 0, 1, 0, 180, 0, 1),
  86. (NULL, 181525, 533, 2783.36, -3688.36, 274.385, -3.12187, 0, 0, 1, 0, 180, 0, 1),
  87. (NULL, 181526, 533, 2781.56, -3671, 274.352, -3.12955, 0, 0, 1, 0, 180, 0, 1),
  88. (NULL, 181527, 533, 2777.41, -3677.64, 274.387, 0.79134, 0, 0, 1, 0, 180, 0, 1),
  89. (NULL, 181528, 533, 2769.25, -3671.42, 274.422, -0.424006, 0, 0, 1, 0, 180, 0, 1),
  90. (NULL, 181529, 533, 2763.33, -3680.53, 274.352, -3.13681, 0, 0, 1, 0, 180, 0, 1),
  91. (NULL, 181530, 533, 2758.16, -3667.13, 274.352, 3.13883, 0, 0, 1, 0, 180, 0, 1),
  92. (NULL, 181531, 533, 2749.34, -3662.21, 274.352, -2.64632, 0, 0, 1, 0, 180, 0, 1),
  93. (NULL, 181532, 533, 2743.09, -3671.32, 274.317, 2.46425, 0, 0, 1, 0, 180, 0, 1),
  94. (NULL, 181533, 533, 2754.01, -3673.77, 274.387, 0.79134, 0, 0, 1, 0, 180, 0, 1),
  95. (NULL, 181534, 533, 2737.17, -3675.16, 274.317, -1.91353, 0, 0, 1, 0, 180, 0, 1),
  96. (NULL, 181535, 533, 2747.13, -3684.35, 274.352, 3.13243, 0, 0, 1, 0, 180, 0, 1),
  97. (NULL, 181536, 533, 2740.49, -3692.13, 274.387, 0.792787, 0, 0, 1, 0, 180, 0, 1),
  98. (NULL, 181537, 533, 2738.4, -3703.13, 274.385, -0.537079, 0, 0, 1, 0, 180, 0, 1),
  99. (NULL, 181538, 533, 2752.93, -3706.52, 274.317, 1.04784, 0, 0, 1, 0, 180, 0, 1),
  100. (NULL, 181539, 533, 2746.13, -3700.19, 274.317, -0.789904, 0, 0, 1, 0, 180, 0, 1),
  101. (NULL, 181540, 533, 2752.92, -3693.02, 274.317, -2.18329, 0, 0, 1, 0, 180, 0, 1),
  102. (NULL, 181541, 533, 2760.58, -3688.31, 274.387, 0.412781, 0, 0, 1, 0, 180, 0, 1),
  103. (NULL, 181542, 533, 2764.29, -3698.09, 274.422, -0.792388, 0, 0, 1, 0, 180, 0, 1),
  104. (NULL, 181543, 533, 2772.08, -3692.15, 274.352, -1.26434, 0, 0, 1, 0, 180, 0, 1),
  105. (NULL, 181544, 533, 2774.96, -3701.13, 274.317, 0.523547, 0, 0, 1, 0, 180, 0, 1),
  106. (NULL, 181545, 533, 2772.29, -3711.44, 274.422, -0.260754, 0, 0, 1, 0, 180, 0, 1),
  107. (NULL, 181546, 533, 2761.82, -3711.92, 274.315, -2.32171, 0, 0, 1, 0, 180, 0, 1),
  108. (NULL, 181547, 533, 2754.19, -3718.12, 274.317, -0.91283, 0, 0, 1, 0, 180, 0, 1),
  109. (NULL, 181548, 533, 2765.76, -3718.73, 274.317, -1.4752, 0, 0, 1, 0, 180, 0, 1),
  110. (NULL, 181549, 533, 2776.16, -3721.79, 274.387, -2.34582, 0, 0, 1, 0, 180, 0, 1),
  111. (NULL, 181550, 533, 2765.33, -3728.61, 274.315, -0.065239, 0, 0, 1, 0, 180, 0, 1),
  112. (NULL, 181551, 533, 2774.99, -3731.79, 274.387, -2.35527, 0, 0, 1, 0, 180, 0, 1),
  113. (NULL, 181552, 533, 2784.17, -3724.73, 274.385, 1.05084, 0, 0, 1, 0, 180, 0, 1),
  114. (NULL, 181676, 533, 2771.37, -3681.64, 273.667, -0.104719, 0, 0, 0, 1, 180, 0, 1),
  115. (NULL, 181676, 533, 2753.28, -3643.09, 273.618, 0.436332, 0, 0, 0, 1, 180, 0, 1),
  116. (NULL, 181676, 533, 2766.39, -3642.32, 273.853, -2.77507, 0, 0, 0, 1, 180, 0, 1),
  117. (NULL, 181676, 533, 2779.17, -3684.18, 273.668, 2.67035, 0, 0, 0, 1, 180, 0, 1),
  118. (NULL, 181676, 533, 2765.45, -3663.31, 273.667, -1.3439, 0, 0, 0, 1, 180, 0, 1),
  119. (NULL, 181676, 533, 2746.33, -3649.14, 273.621, -2.82743, 0, 0, 0, 1, 180, 0, 1),
  120. (NULL, 181676, 533, 2783.05, -3681.86, 273.67, -1.44862, 0, 0, 0, 1, 180, 0, 1),
  121. (NULL, 181676, 533, 2771.77, -3652.75, 273.658, -0.645772, 0, 0, 0, 1, 180, 0, 1),
  122. (NULL, 181676, 533, 2776.29, -3642.56, 273.965, 0.017452, 0, 0, 0, 1, 180, 0, 1),
  123. (NULL, 181676, 533, 2746.2, -3658.67, 273.619, 3.00195, 0, 0, 0, 1, 180, 0, 1),
  124. (NULL, 181676, 533, 2771.85, -3665.62, 273.667, 3.10665, 0, 0, 0, 1, 180, 0, 1),
  125. (NULL, 181676, 533, 2761.93, -3648.03, 273.626, -0.366518, 0, 0, 0, 1, 180, 0, 1),
  126. (NULL, 181676, 533, 2771.63, -3642.94, 274.379, -0.733038, 0, 0, 0, 1, 180, 0, 1),
  127. (NULL, 181676, 533, 2762.27, -3672.94, 273.667, -2.82743, 0, 0, 0, 1, 180, 0, 1),
  128. (NULL, 181676, 533, 2752.57, -3655.19, 273.626, 1.46608, 0, 0, 0, 1, 180, 0, 1),
  129. (NULL, 181676, 533, 2782.95, -3641.68, 273.594, -0.872664, 0, 0, 0, 1, 180, 0, 1),
  130. (NULL, 181676, 533, 2759.67, -3641.1, 273.591, -0.645772, 0, 0, 0, 1, 180, 0, 1),
  131. (NULL, 181676, 533, 2752.82, -3666.02, 273.654, 2.58308, 0, 0, 0, 1, 180, 0, 1),
  132. (NULL, 181677, 533, 2735.92, -3697.26, 273.65, 0.523598, 0, 0, 0, 1, 180, 0, 1),
  133. (NULL, 181677, 533, 2778.21, -3694.98, 273.638, 0.663223, 0, 0, 0, 1, 180, 0, 1),
  134. (NULL, 181677, 533, 2747.86, -3676.92, 273.662, 0.296705, 0, 0, 0, 1, 180, 0, 1),
  135. (NULL, 181677, 533, 2745.5, -3666.69, 273.639, -1.55334, 0, 0, 0, 1, 180, 0, 1),
  136. (NULL, 181677, 533, 2755.71, -3682.96, 273.666, -1.27409, 0, 0, 0, 1, 180, 0, 1),
  137. (NULL, 181677, 533, 2768.83, -3701.38, 273.665, 1.51844, 0, 0, 0, 1, 180, 0, 1),
  138. (NULL, 181677, 533, 2747.2, -3693.01, 273.666, -1.85005, 0, 0, 0, 1, 180, 0, 1),
  139. (NULL, 181677, 533, 2734.93, -3688.94, 273.628, -0.645772, 0, 0, 0, 1, 180, 0, 1),
  140. (NULL, 181677, 533, 2766.62, -3687.92, 273.664, -0.436332, 0, 0, 0, 1, 180, 0, 1),
  141. (NULL, 181677, 533, 2729.2, -3673.43, 273.621, -0.157079, 0, 0, 0, 1, 180, 0, 1),
  142. (NULL, 181677, 533, 2729.52, -3697.78, 273.625, 0.104719, 0, 0, 0, 1, 180, 0, 1),
  143. (NULL, 181677, 533, 2729.02, -3684.86, 274.373, -0.034906, 0, 0, 0, 1, 180, 0, 1),
  144. (NULL, 181677, 533, 2734, -3663.36, 273.621, -1.91986, 0, 0, 0, 1, 180, 0, 1),
  145. (NULL, 181677, 533, 2740.54, -3681.25, 273.644, 1.81514, 0, 0, 0, 1, 180, 0, 1),
  146. (NULL, 181677, 533, 2761.62, -3693.18, 273.664, 2.60053, 0, 0, 0, 1, 180, 0, 1),
  147. (NULL, 181678, 533, 2807.49, -3668.25, 273.644, -1.55334, 0, 0, 0, 1, 180, 0, 1),
  148. (NULL, 181678, 533, 2819.54, -3677.43, 273.638, 1.51844, 0, 0, 0, 1, 180, 0, 1),
  149. (NULL, 181678, 533, 2808.35, -3685.41, 273.645, -1.27409, 0, 0, 0, 1, 180, 0, 1),
  150. (NULL, 181678, 533, 2802.32, -3659.69, 273.626, 1.46608, 0, 0, 0, 1, 180, 0, 1),
  151. (NULL, 181678, 533, 2795.44, -3687.74, 273.622, -0.506145, 0, 0, 0, 1, 180, 0, 1),
  152. (NULL, 181678, 533, 2821.09, -3691.97, 275.804, 2.79252, 0, 0, 0, 1, 180, 0, 1),
  153. (NULL, 181678, 533, 2818.81, -3672.17, 273.629, -1.3439, 0, 0, 0, 1, 180, 0, 1),
  154. (NULL, 181678, 533, 2787.77, -3674.88, 273.668, 0.296705, 0, 0, 0, 1, 180, 0, 1),
  155. (NULL, 181678, 533, 2793.97, -3656.83, 273.637, 0.663223, 0, 0, 0, 1, 180, 0, 1),
  156. (NULL, 181678, 533, 2789.24, -3668.48, 273.669, -0.366518, 0, 0, 0, 1, 180, 0, 1),
  157. (NULL, 181678, 533, 2793, -3646.92, 273.62, -0.95993, 0, 0, 0, 1, 180, 0, 1),
  158. (NULL, 181678, 533, 2813.31, -3699.76, 273.621, -1.85005, 0, 0, 0, 1, 180, 0, 1),
  159. (NULL, 181678, 533, 2817.4, -3684.56, 273.623, -0.820303, 0, 0, 0, 1, 180, 0, 1),
  160. (NULL, 181678, 533, 2786.82, -3647.31, 273.635, -0.436332, 0, 0, 0, 1, 180, 0, 1),
  161. (NULL, 181678, 533, 2817.31, -3687.08, 273.621, 2.60053, 0, 0, 0, 1, 180, 0, 1),
  162. (NULL, 181678, 533, 2803.58, -3675.67, 273.666, -2.80997, 0, 0, 0, 1, 180, 0, 1),
  163. (NULL, 181678, 533, 2815.57, -3697.73, 273.621, 0.994837, 0, 0, 0, 1, 180, 0, 1),
  164. (NULL, 181678, 533, 2811.57, -3663.93, 273.623, 3.00195, 0, 0, 0, 1, 180, 0, 1),
  165. (NULL, 181678, 533, 2796.98, -3671.73, 273.669, 2.58308, 0, 0, 0, 1, 180, 0, 1),
  166. (NULL, 181695, 533, 2749.96, -3724.48, 273.623, 0.645772, 0, 0, 0, 1, 180, 0, 1),
  167. (NULL, 181695, 533, 2745.57, -3720.84, 273.654, 1.8675, 0, 0, 0, 1, 180, 0, 1),
  168. (NULL, 181695, 533, 2771.05, -3717.31, 273.67, -0.366518, 0, 0, 0, 1, 180, 0, 1),
  169. (NULL, 181695, 533, 2757.5, -3708.95, 273.668, -0.95993, 0, 0, 0, 1, 180, 0, 1),
  170. (NULL, 181695, 533, 2752.93, -3699.58, 273.667, 0.436332, 0, 0, 0, 1, 180, 0, 1),
  171. (NULL, 181695, 533, 2766.44, -3708.41, 273.667, -1.27409, 0, 0, 0, 1, 180, 0, 1),
  172. (NULL, 181695, 533, 2760.5, -3732.28, 273.632, -1.18682, 0, 0, 0, 1, 180, 0, 1),
  173. (NULL, 181695, 533, 2791.41, -3726.31, 273.622, 1.48353, 0, 0, 0, 1, 180, 0, 1),
  174. (NULL, 181695, 533, 2787.4, -3731.16, 273.616, -1.09956, 0, 0, 0, 1, 180, 0, 1),
  175. (NULL, 181695, 533, 2779.75, -3728.21, 273.644, 2.67035, 0, 0, 0, 1, 180, 0, 1),
  176. (NULL, 181695, 533, 2771.59, -3736.93, 273.618, 1.48353, 0, 0, 0, 1, 180, 0, 1),
  177. (NULL, 181695, 533, 2745.73, -3711.43, 273.621, 0.767944, 0, 0, 0, 1, 180, 0, 1),
  178. (NULL, 181695, 533, 2759.15, -3718.01, 273.669, -2.00713, 0, 0, 0, 1, 180, 0, 1),
  179. (NULL, 181695, 533, 2759.64, -3724.62, 273.66, 2.1293, 0, 0, 0, 1, 180, 0, 1),
  180. (NULL, 181695, 533, 2771.05, -3727.31, 273.67, -0.436332, 0, 0, 0, 1, 180, 0, 1),
  181. (NULL, 181695, 533, 2737.57, -3710.51, 273.624, 2.96704, 0, 0, 0, 1, 180, 0, 1),
  182. (NULL, 181695, 533, 2781.85, -3735.08, 273.62, 1.51844, 0, 0, 0, 1, 180, 0, 1),
  183. (NULL, 181695, 533, 2731.62, -3706.18, 273.623, -2.77507, 0, 0, 0, 1, 180, 0, 1),
  184. (NULL, 181695, 533, 2755.07, -3728.92, 273.626, 0.523598, 0, 0, 0, 1, 180, 0, 1),
  185. (NULL, 181695, 533, 2781.35, -3720.31, 273.64, 2.67035, 0, 0, 0, 1, 180, 0, 1);
  186. -- Loatheb spore
  187. UPDATE creature_template SET ScriptName = "mob_loatheb_spore" WHERE entry = 16286;
  188. -- Smite
  189. UPDATE creature_template SET ScriptName = "boss_mr_smite" WHERE entry = 646;
  190. -- Flying bat in zul'gurub
  191. UPDATE creature_template SET InhabitType = 4 WHERE entry IN(14965, 11368, 14750);
  192. -- Razzashi Cobra
  193. UPDATE creature_template SET ScriptName = "mob_razzashi_cobra" WHERE entry = 11373;
  194. -- Frenzied Bloodseeker Bat
  195. UPDATE creature_template SET ScriptName = "" WHERE entry = 14965;
  196. -- Gurubashi Bat Rider
  197. UPDATE creature_template SET ScriptName = "mob_gurubashi_bat_rider" WHERE entry = 14750;
  198. -- Zul'gurub brazier
  199. DELETE FROM gameobject_scripts WHERE id = 28704;
  200. UPDATE gameobject_template SET ScriptName = "go_brazier_of_madness" WHERE entry = 180327;
  201. -- Sunken temple : Atal'arion event
  202. DELETE FROM creature WHERE id = 8580;
  203. UPDATE gameobject_template SET ScriptName = "go_atalai_statue" WHERE entry IN(148830,148831,148832,148833,148834,148835);
  204. -- Sunken Temple : Instance template
  205. UPDATE instance_template SET ScriptName = "instance_sunken_temple" WHERE map = 109;
  206. -- Sunken temple force field
  207. DELETE FROM gameobject WHERE id = 149431;
  208. DELETE FROM gameobject WHERE guid = 500142;
  209. INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  210. (500142, 149431, 109, -518.474, -86.9691, -91.2008, 0.000848293, 0, 0, 0.000000, 1, 25, 100, 1);
  211. -- Sunken Temple Hakkar doors
  212. DELETE FROM gameobject WHERE id IN(149432, 149433);
  213. DELETE FROM gameobject WHERE guid IN(500143, 500144);
  214. INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  215. (500143, 149432, 109, -518.32, 276.029, -91.201, 6.27888, 0, 0, 0.000000, -1.0000, 25, 100, 0),
  216. (500144, 149433, 109, -415.588, 275.997, -91.201, 3.14121, 0, 0, 1, 0.0000000, 25, 100, 0);
  217. -- Avatar of Hakkar summon
  218. DELETE FROM event_scripts WHERE id = 8502;
  219. INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`, `comments`) VALUES
  220. (8502, 0, 10, 8440, 9000000, 0, -466.86, 272.31, -90.74, 3.52, "Avatar of Hakkar summon");
  221. -- Avatar of Hakkar summons
  222. DELETE FROM spell_script_target WHERE entry = 12623;
  223. INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
  224. (12623, 1, 8440);
  225. UPDATE creature_template SET ScriptName = "boss_avatar_of_hakkar" WHERE entry = 8440;
  226. UPDATE creature_template SET minlevel = 49, maxlevel = 49, minhealth = 8467, maxhealth = 10492, faction_A = 16, faction_H = 16, mindmg = 300, maxdmg = 388, attackpower = 159, speed_walk = 4.28, baseattacktime = 1225, rangeattacktime = 1347, minrangedmg = 56.0352, maxrangedmg = 77.0484, MovementType = 1, mechanic_immune_mask = 8388624 WHERE entry = 8440;
  227. UPDATE gameobject_template SET ScriptName = "go_eternal_flame" WHERE entry IN(148418,148419,148420,148421);
  228. -- Scarlet monastery
  229. -- Azshir the Sleepless
  230. DELETE FROM creature WHERE guid = 500002;
  231. DELETE FROM creature WHERE id = 6490;
  232. INSERT INTO `creature` (`guid`, `id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
  233. (500002, 6490, 189, 0, 0, 1833.65, 1316.91, 19.0162, 1.68073, 43200, 0, 0, 2765, 0, 0, 0);
  234. --
  235. DELETE FROM spell_script_target WHERE entry = 10252;
  236. INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
  237. (10252, 1, 7076);
  238. DELETE FROM spell_script_target WHERE entry = 10256;
  239. INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
  240. (10256, 1, 10120);
  241. DELETE FROM spell_script_target WHERE entry = 10259;
  242. INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
  243. (10259, 1, 7077),
  244. (10259, 1, 7309);
  245. -- Baron Aquanis
  246. UPDATE gameobject_template SET ScriptName = "go_fathom_stone" WHERE entry = 177964;
  247. UPDATE creature_template SET ScriptName = "npc_morridune" WHERE entry = 6729;
  248. -- Anachronos ring quests
  249. UPDATE quest_template SET ExclusiveGroup = 8747 WHERE entry IN(8747, 8757, 8752);
  250. UPDATE quest_template SET ExclusiveGroup = 8748 WHERE entry IN(8748, 8758, 8753);
  251. UPDATE quest_template SET ExclusiveGroup = 8749 WHERE entry IN(8749, 8759, 8754);
  252. UPDATE quest_template SET ExclusiveGroup = 8750 WHERE entry IN(8750, 8760, 8755);
  253. UPDATE quest_template SET ExclusiveGroup = 8751 WHERE entry IN(8751, 8761, 8756);
  254. -- The Wrath of Neptulon
  255. UPDATE creature_loot_template SET ChanceOrQuestChance = -100 WHERE item = 21137 AND entry = 15571;
  256. -- The platinum disk
  257. UPDATE quest_template SET StartScript = 2278 WHERE entry = 2278;
  258. DELETE FROM quest_start_scripts WHERE id = 2278;
  259. INSERT INTO `quest_start_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
  260. (2278, 1, 10, 7172, 600000, 0, 148.657, 309.864, -52.1173, 5.23599);
  261. -- Jamal'an
  262. DELETE FROM creature_ai_scripts WHERE id = 571011;
  263. INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES
  264. (571011, 5710, 6, 0, 100, 2, 0, 0, 0, 0, 34, 3, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Jammal''an - Set Instance Data on Death');
  265. UPDATE creature_template SET ScriptName = "npc_malfurion_stormrage" WHERE entry = 15362;
  266. -- Death from Bellow
  267. UPDATE creature_template SET ScriptName = "npc_shakes_obreen" WHERE entry = 2610;
  268. DELETE FROM spell_target_position WHERE id = 4170;
  269. INSERT INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
  270. (4170, 0, -2137.14, -1991.27, 8.07, 0.0);
  271. UPDATE gameobject_template SET ScriptName = "go_arathi_cannon" WHERE entry = 113531;
  272. DELETE FROM gameobject WHERE id = 113529;
  273. -- Deeprun Rat Round Up
  274. UPDATE creature_template SET ScriptName = "mob_deeprun_rat" WHERE entry = 13016;
  275. -- Lethon
  276. UPDATE creature_template SET ScriptName = "boss_lethon" WHERE entry = 14888;
  277. UPDATE creature_template SET ScriptName = "npc_spirit_shade" WHERE entry = 15261;
  278. -- Twilight Corrupter
  279. UPDATE creature_template SET faction_A = 16, faction_H = 16, ScriptName = "boss_twilight_corrupter" WHERE entry = 15625;
  280. DELETE FROM scripted_areatrigger WHERE entry = 4017;
  281. INSERT INTO `scripted_areatrigger` (`entry`, `ScriptName`) VALUES
  282. (4017, 'at_twilight_grove');
  283. -- Lethon
  284. UPDATE creature_template SET ScriptName = "boss_lethon" WHERE entry = 14888;
  285. UPDATE creature_template SET ScriptName = "npc_spirit_shade" WHERE entry = 15261;
  286. -- Twilight drakes
  287. UPDATE creature_template SET minLevel = 60, maxLevel = 60, faction_A = 14, faction_H = 14, ScriptName = "npc_dream_fog" WHERE entry = 15224;
  288. UPDATE creature_template SET faction_A = 14, faction_H = 14 WHERE entry = 15302;
  289. -- The eye of divinity
  290. DELETE FROM creature_template_addon WHERE entry = 14494;
  291. INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `b2_0_sheath`, `b2_1_flags`, `emote`, `moveflags`, `auras`) VALUES
  292. (14494, 0, 0, 0, 0, 0, 0, '23196 0');
  293. DELETE FROM creature WHERE id = 14494;
  294. INSERT INTO `creature` (`guid`, `id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
  295. (NULL, 14494, 0, 0, 0, 3287.64, -2917, 153.564, 3.834, 600, 0, 0, 3052, 0, 0, 0);
  296. -- Mr Smite
  297. DELETE FROM script_texts WHERE entry IN(-1036002, -1036003, -1036004);
  298. INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
  299. (-1036002, 'We''re under attack! Avast ya swabs! Repel the invaders!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5777, 1, 0, 0, 'smite SAY_AGGRO'),
  300. (-1036003, 'You land lovers are tougher then I thought! I will need to improvise', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5778, 0, 0, 0, 'smite SAY_HEALTH_1'),
  301. (-1036004, 'D''ah! Now you''re making me angry!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5779, 0, 0, 0, 'smite SAY_HEALTH_2');
  302. -- Les pierres de Suntara
  303. DELETE FROM script_waypoint WHERE entry = 8284;
  304. INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES
  305. (8284, 1, -7005.79, -1723.68, 234.09, 0, ''),
  306. (8284, 2, -6986.64, -1737.41, 241.14, 0, ''),
  307. (8284, 3, -6941.26, -1740.15, 240.74, 0, ''),
  308. (8284, 4, -6920.54, -1780.83, 240.74, 5000, ''),
  309. (8284, 5, -6868.47, -1832.80, 240.69, 0, ''),
  310. (8284, 6, -6815.45, -1854.05, 244.14, 0, ''),
  311. (8284, 7, -6751.12, -1878.64, 244.15, 5000, ''),
  312. (8284, 8, -6698.57, -1898.00, 244.14, 0, ''),
  313. (8284, 9, -6663.31, -1916.10, 244.14, 0, ''),
  314. (8284, 10, -6574.78, -1920.31, 244.15, 5000, ''),
  315. (8284, 11, -6480.81, -1969.45, 244.15, 0, ''),
  316. (8284, 12, -6389.08, -1983.95, 246.73, 10000, '');
  317. DELETE FROM script_texts WHERE entry IN(-1500000,-1500001,-1500002,-1500003,-1500004,-1500005,-1500006,-1500007,-1500008);
  318. INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
  319. (-1500000, 'C''est OK ! $n, je vous présente mes poings. Mes poings, dites bonjour à $n.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, ''),
  320. (-1500001, 'Allez-vous laisser un nain blessé travailler à votre place ?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, ''),
  321. (-1500002, 'C''est ici, $r : Le Chaudron ! Marquez-le sur une carte ou faites quelque chose pour ne pas oublier. S''il m''arrivait quoi que ce soit, mon équipe serait coincée dans cette mine pour toujours.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, ''),
  322. (-1500003, 'Il faut que j''arrête de fumer ! Donnez-moi une minute pour reprendre mon souffle.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, ''),
  323. (-1500004, 'En avant ! Et soyez sur vos gardes, cette fois ! Je ne vais pas supporter d''autres combats.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, ''),
  324. (-1500005, 'Stop... je dois reprendre... mon souffle.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, ''),
  325. (-1500006, 'Nous sommes presque en sécurité. À partir d''ici, il faut courir. Essayez de ne pas rester trop loin derrière ! ON Y VA !', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, ''),
  326. (-1500007, 'La porte est en vue ! Nous allons réussir ! Mais d''abord, je dois me reposer un peu.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, ''),
  327. (-1500008, 'ARRRRRGH ! Il m''a eu !', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, '');
  328. UPDATE creature_template SET ScriptName = 'npc_dorius_stonetender' WHERE entry = 8284;
  329. -- Rise Obsidion!
  330. DELETE FROM script_texts WHERE entry IN(-1500010,-1500011,-1500012,-1500013,-1500014,-1500015,-1500016,-1500017,-1500018);
  331. INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
  332. (-1500010, 'Bravo ! Bravo ! Excellent. Comment ? Vous pensiez que je n''étais plus de ce monde ?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  333. (-1500011, 'Imbéciles, je savais qu''en touchant le point sensible de mon frère, je le ferais envoyer des "sauveteurs".', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  334. (-1500012, 'Vous manipuler pour que vous repreniez la dernière Pierre de Suntara aux idiots du Marteau du crépuscule aura été facile !', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  335. (-1500013, 'Lorsque je trébuchai sur les pierres de Suntara, sur le site de fouilles de Crasseboue, la puissance de Ragnaros afflua dans mon corps. Ragnaros m''avait donné un but.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  336. (-1500014, 'C''est Ragnaros qui a voulu construire l''Obsidion. L''Obsidion détruira les orcs du pic Rochenoire, en nous unissant à nos frères des profondeurs flamboyantes.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  337. (-1500015, 'Et finalement, ce fut Ragnaros qui me donna un nom quand je naquis de nouveau sous la forme d''un acolyte de feu : Lathoric... Lathoric le Noir.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  338. (-1500016, 'Le rire de Dorius s''estompe...', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, 0, 0, ''),
  339. (-1500017, 'Votre tâche est accomplie. Préparez-vous à affronter votre destin.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  340. (-1500018, 'Obsidion, levez-vous et servez votre maître !', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, '');
  341. UPDATE creature_template SET ScriptName = "npc_dorius" WHERE entry = 8421;
  342. UPDATE quest_template SET StartScript = 3566 WHERE entry = 3566;
  343. DELETE FROM quest_start_scripts WHERE id = 3566;
  344. INSERT INTO `quest_start_scripts` ( `id` , `delay` , `command` , `datalong` , `datalong2` , `dataint` , `x` , `y` , `z` , `o` , `comments` )
  345. VALUES ( 3566, 0, 10, 8421, 600000, 0, - 6472.14, - 1248.07, 180.30, 0, '') ;
  346. -- Twilight Corrupter
  347. DELETE FROM script_texts WHERE entry IN(-1500020,-1500021,-1500022);
  348. INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
  349. (-1500020, 'Come, $N. See what the Nightmare brings...', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 6, 0, 0, ''),
  350. (-1500021, 'The Nightmare cannot be stopped!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, ''),
  351. (-1500022, 'Twilight Corrupter squeezes the last bit of life out of $N and swallows their soul.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, '');
  352. -- L'attaque
  353. UPDATE `creature_template` SET `ScriptName`='npc_tyrion' WHERE `entry`=7766;
  354. UPDATE `creature_template` SET `ScriptName`='npc_tyrion_spybot' WHERE `entry`=8856;
  355. UPDATE `creature_template` SET `ScriptName`='npc_lord_gregor_lescovar' WHERE `entry`=1754;
  356. UPDATE `creature_template` SET `ScriptName`='npc_marzon_silent_blade' WHERE `entry`=1755;
  357. DELETE FROM `script_texts` WHERE `entry` IN (-1500030,-1500031,-1500032,-1500033,-1500034,-1500035,-1500036,-1500037,-1500038,-1500039,-1500040,-1500041,-1500042,-1500043,-1500044);
  358. INSERT INTO `script_texts` (`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,`type`,`language`,`emote`,`comment`) VALUES
  359. (-1500030,'By your command!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
  360. (-1500031,'Wait here. Spybot will make Lescovar come out as soon as possible. Be ready! Attack only after you''ve overheard their conversation.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
  361. (-1500032,'Good day to you both. I would speak to Lord Lescovar.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
  362. (-1500033,'Of course. He awaits you in the library.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
  363. (-1500034,'Thank you. The Light be with you both.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
  364. (-1500035,'Milord, your guest has arrived. He awaits your presence.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
  365. (-1500036,'Ah, thank you kindly. I will leave you to the library while I tend to this small matter.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
  366. (-1500037,'I shall use the time wisely, milord. Thank you.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
  367. (-1500038,'It''s time for my meditation, leave me.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
  368. (-1500039,'Yes, sir!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
  369. (-1500040,'There you are. What news from Westfall?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
  370. (-1500041,'VanCleef sends word that the plans are underway. But he''s hear rumors about someone snooping about.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
  371. (-1500042,'Hmm, it could be that meddle Shaw. I will see what I can discover. Be off with you. I''ll contact you again soon.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
  372. (-1500043,'That''s it! That''s what you were waiting for! KILL THEM!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,''),
  373. (-1500044,'The Defias shall succeed! No meek adventurer will stop us!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'');
  374. DELETE FROM `script_waypoint` WHERE `entry` = 1754;
  375. INSERT INTO `script_waypoint` VALUES
  376. (1754, 1, -8334.89, 394.130, 122.274, 0, ''),
  377. (1754, 2, -8335.58, 393.519, 122.275, 0, ''),
  378. (1754, 3, -8352.99, 379.932, 122.275, 0, ''),
  379. (1754, 4, -8356.65, 385.247, 122.275, 0, ''),
  380. (1754, 5, -8364.29, 395.317, 122.275, 0, ''),
  381. (1754, 6, -8361.75, 402.852, 122.275, 0, ''),
  382. (1754, 7, -8359.94, 410.92, 122.275, 0, ''),
  383. (1754, 8, -8362.84, 415.409, 122.275, 0, ''),
  384. (1754, 9, -8370.42, 424.6, 122.275, 0, ''),
  385. (1754, 10, -8380.45, 437.115, 122.275, 0, ''),
  386. (1754, 11, -8386.37, 444.906, 122.275, 0, ''),
  387. (1754, 12, -8388.5, 447.314, 123.275, 0, ''),
  388. (1754, 13, -8390.25, 449.247, 124.275, 0, ''),
  389. (1754, 14, -8392.84, 452.397, 123.761, 0, ''),
  390. (1754, 15, -8397.52, 457.326, 123.761, 0, ''),
  391. (1754, 16, -8402.42, 461.646, 123.761, 0, ''),
  392. (1754, 17, -8409.52, 462.677, 123.761, 0, '');
  393.  
  394. DELETE FROM `script_waypoint` WHERE `entry` = 8856;
  395. INSERT INTO `script_waypoint` VALUES
  396. (8856, 1, -8409.34, 453.345, 123.761, 0, ''),
  397. (8856, 2, -8409.52, 462.677, 123.761, 0, ''),
  398. (8856, 3, -8402.42, 461.646, 123.761, 0, ''),
  399. (8856, 4, -8397.52, 457.326, 123.761, 0, ''),
  400. (8856, 5, -8392.84, 452.397, 123.761, 0, ''),
  401. (8856, 6, -8390.25, 449.247, 124.275, 0, ''),
  402. (8856, 7, -8388.5, 447.314, 123.275, 0, ''),
  403. (8856, 8, -8386.37, 444.906, 122.275, 0, ''),
  404. (8856, 9, -8380.45, 437.115, 122.275, 0, ''),
  405. (8856, 10, -8370.42, 424.6, 122.275, 0, ''),
  406. (8856, 11, -8362.84, 415.409, 122.275, 0, ''),
  407. (8856, 12, -8359.94, 410.92, 122.275, 0, ''),
  408. (8856, 13, -8361.75, 402.852, 122.275, 0, ''),
  409. (8856, 14, -8364.29, 395.317, 122.275, 0, ''),
  410. (8856, 15, -8356.65, 385.247, 122.275, 0, ''),
  411. (8856, 16, -8352.99, 379.932, 122.275, 0, ''),
  412. (8856, 17, -8335.58, 393.519, 122.275, 0, ''),
  413. (8856, 18, -8334.89, 394.13, 122.274, 0, '');
  414. -- Une jolie pagaille
  415. UPDATE creature_template SET ScriptName = "npc_kernobee" WHERE entry = 7850;
  416. -- Supplies to Auberdine
  417. UPDATE creature_template SET ScriptName = "npc_feero_ironhand" WHERE entry = 4484;
  418. DELETE FROM script_waypoint WHERE entry = 4484;
  419. INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES
  420. (4484, 1, 3179.79, 196.78, 3.81, 0, ''),
  421. (4484, 2, 3222.18, 183.80, 6.65, 0, ''),
  422. (4484, 3, 3233.44, 226.65, 10.05, 0, ''),
  423. (4484, 4, 3276.48, 224.90, 10.67, 0, ''),
  424. (4484, 5, 3318.03, 209.70, 12.07, 0, ''),
  425. (4484, 6, 3344.40, 214.54, 13.34, 0, ''),
  426. (4484, 7, 3380.64, 227.54, 10.82, 0, ''),
  427. (4484, 8, 3435.41, 225.65, 10.35, 0, ''),
  428. (4484, 9, 3477.99, 213.39, 12.73, 0, ''),
  429. (4484, 10, 3605.79, 217.41, 1.08, 0, ''),
  430. (4484, 11, 3668.80, 205.64, 2.55, 0, ''),
  431. (4484, 12, 3765.95, 157.72, 7.57, 0, ''),
  432. (4484, 13, 3892.72, 46.08, 15.37, 0, ''),
  433. (4484, 14, 3971.50, -1.38, 17.00, 0, ''),
  434. (4484, 15, 4027.92, -6.90, 16.56, 0, ''),
  435. (4484, 16, 4089.55, 14.82, 16.19, 0, ''),
  436. (4484, 17, 4165.55, 55.60, 26.86, 0, ''),
  437. (4484, 18, 4263.72, 134.12, 41.81, 0, ''),
  438. (4484, 19, 4313.07, 161.9, 47.14, 0, '');
  439. DELETE FROM `script_texts` WHERE `entry` IN (-1500050,-1500051,-1500052,-1500053,-1500054,-1500055,-1500056,-1500057,-1500058);
  440. INSERT INTO `script_texts` (`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,`type`,`language`,`emote`,`comment`) VALUES
  441. (-1500050,'It looks like we''re in trouble. Look lively, here they come!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
  442. (-1500051,'Assassins from that cult you found... Let''s get moving before someone else finds us out here.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
  443. (-1500052,'Hold! I sense an evil presence... Undead!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
  444. (-1500053,'A paladin! Slaying him would please the master. Attack!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
  445. (-1500054,'They''re coming out of the woodwork today. Let''s keep moving or we may find more things that want me dead.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
  446. (-1500055,'These three again?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
  447. (-1500056,'I''ll finish you off for good this time!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
  448. (-1500057,'Not quite so sure of yourself without the Purifier, hm?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
  449. (-1500058,'Well done! I should be fine on my own from here. Remember to talk to Delgren when you return to Maestra''s Post in Ashenvale.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'');
  450. -- Azuregos Spirit
  451. DELETE FROM npc_text WHERE id IN(200000,200001,200002,200003,200004,200005,200006,200007,200008,200009,200010,200011,200012);
  452. UPDATE creature_template SET ScriptName = "npc_azuregos_spirit" WHERE entry = 15481;
  453. INSERT INTO npc_text (id,text0_0,text0_1) VALUES (200000,"You seek the scepter shard charged to the protection of the Blue Flight?","You seek the scepter shard charged to the protection of the Blue Flight?");
  454. INSERT INTO npc_text (id,text0_0,text0_1) VALUES (200001,"Of course I do not have the shard. That would be asinine. I walk amongst savages in this cursed land! I cannot take five steps without some crazed orc or human trying to thrust a sharp stick into my hide. At any given time you could very well be speaking to my ghostly spirit.\n\nAnyhow... I hid it.\n\nGo on... ask me where.","Of course I do not have the shard. That would be asinine. I walk amongst savages in this cursed land! I cannot take five steps without some crazed orc or human trying to thrust a sharp stick into my hide. At any given time you could very well be speaking to my ghostly spirit.\n\nAnyhow... I hid it.\n\nGo on... ask me where.");
  455. INSERT INTO npc_text (id,text0_0,text0_1) VALUES (200002,"You are going to love this story, $R. See, here is the thing. As soon as Malygos charged me with protecting the scepter shard, I knew I was in for an eternity of headache and pain.\n\nAll I wanted to do is study these magic rich shorelines and take in what artifacts might remain from the Sundering. You know, there was once a thriving Highborne civilization here! You don't have to tell me that there is going to be some solid magical items around here, $R. I can smell it!","You are going to love this story, $R. See, here is the thing. As soon as Malygos charged me with protecting the scepter shard, I knew I was in for an eternity of headache and pain.\n\nAll I wanted to do is study these magic rich shorelines and take in what artifacts might remain from the Sundering. You know, there was once a thriving Highborne civilization here! You don't have to tell me that there is going to be some solid magical items around here, $R. I can smell it!");
  456. INSERT INTO npc_text (id,text0_0,text0_1) VALUES (200003,"As I was saying, I held onto the scepter shard for a good five-hundred years and it was nothing but trouble. It attracted all kinds of attention - the wrong kind of attention. I want to be left alone to my studies not babysit some would be hero's ticket to glory. So... I gave it to the fish.","As I was saying, I held onto the scepter shard for a good five-hundred years and it was nothing but trouble. It attracted all kinds of attention - the wrong kind of attention. I want to be left alone to my studies not babysit some would be hero's ticket to glory. So... I gave it to the fish.");
  457. INSERT INTO npc_text (id,text0_0,text0_1) VALUES (200004,"Not just any fish, mortal. This fish was a minnow. A very special minnow.","Not just any fish, mortal. This fish was a minnow. A very special minnow.");
  458. INSERT INTO npc_text (id,text0_0,text0_1) VALUES (200005,"Exactly!","Exactly!");
  459. INSERT INTO npc_text (id,text0_0,text0_1) VALUES (200006,"Genius, I know... It will never be found; but, in case it is found, I gave the minnow some special powers.","Genius, I know... It will never be found; but, in case it is found, I gave the minnow some special powers.");
  460. INSERT INTO npc_text (id,text0_0,text0_1) VALUES (200007,"Correct. You've been listening! This minnow is really quite a terrible creature of my own creation. When I am relaxing I like to think of the unlucky fishermen who have run into this minnow and been devoured whole. I bet they were quite surprised!\n\n<Azuregos laughs.>","Correct. You've been listening! This minnow is really quite a terrible creature of my own creation. When I am relaxing I like to think of the unlucky fishermen who have run into this minnow and been devoured whole. I bet they were quite surprised!\n\n<Azuregos laughs.>");
  461. INSERT INTO npc_text (id,text0_0,text0_1) VALUES (200008,"Genius is often misunderstood, $R. Now, about the scepter shard... If you want that shard and do not wish to spend the next ten thousand years searching for it, you are going to have to listen very carefully.","Genius is often misunderstood, $R. Now, about the scepter shard... If you want that shard and do not wish to spend the next ten thousand years searching for it, you are going to have to listen very carefully.");
  462. INSERT INTO npc_text (id,text0_0,text0_1) VALUES (200009,"Two words: Arcanite buoy.","Two words: Arcanite buoy.");
  463. INSERT INTO npc_text (id,text0_0,text0_1) VALUES (200010,"Right then... You have to build an arcanite buoy and place it in the ocean. My minnow will be attracted to the magical emanations. When he gets near the buoy - BLAMO! It will explode in a glorious pulse of arcane energy, revealing the minnow's true form. Also, you may or may not incur the wrath of Neptulon. A 50/50 chance I would say.","Right then... You have to build an arcanite buoy and place it in the ocean. My minnow will be attracted to the magical emanations. When he gets near the buoy - BLAMO! It will explode in a glorious pulse of arcane energy, revealing the minnow's true form. Also, you may or may not incur the wrath of Neptulon. A 50/50 chance I would say.");
  464. INSERT INTO npc_text (id,text0_0,text0_1) VALUES (200011,"If I did not know better I would think that you were mocking me, mortal; but yes, that is mostly correct. You may remain fully clothed.","If I did not know better I would think that you were mocking me, mortal; but yes, that is mostly correct. You may remain fully clothed.");
  465. INSERT INTO npc_text (id,text0_0,text0_1) VALUES (200012,"Take this ledger to an old acquaintance of mine in Tanaris. His name is Narian Soothfancy - terrible, terrible, psychic, but an amazing engineer! He should be able to make sense of it all.\n\nNo need to thank me, <Name>. It's the least I could do.\n\nGood day!","Take this ledger to an old acquaintance of mine in Tanaris. His name is Narian Soothfancy - terrible, terrible, psychic, but an amazing engineer! He should be able to make sense of it all.\n\nNo need to thank me, <Name>. It's the least I could do.\n\nGood day!");
  466. DELETE FROM `script_texts` WHERE `entry` = -1500059;
  467. INSERT INTO `script_texts` (`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,`type`,`language`,`emote`,`comment`) VALUES
  468. (-1500059,'I SAID GOOD DAY!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'');
  469. -- A Crew Under Fire
  470. UPDATE creature_template SET ScriptName = "npc_captain_vanessa_beltis_naga" WHERE entry IN(12205, 12204);
  471. UPDATE creature_template SET ScriptName = "npc_captain_vanessa_beltis" WHERE entry = 8380;
  472. DELETE FROM script_waypoint WHERE entry = 12205;
  473. INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES
  474. (12205, 1, 2379.43, -5903.78, 10.79, 0, ''),
  475. (12205, 2, 2373.98, -5965.98, 10.12, 600000, '');
  476. DELETE FROM script_waypoint WHERE entry = 12204;
  477. INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES
  478. (12204, 1, 2379.43, -5903.78, 10.79, 0, ''),
  479. (12204, 2, 2373.98, -5965.98, 10.12, 600000, '');
  480. -- Portal of the legion
  481. UPDATE gameobject_template SET ScriptName = "go_demon_portal" WHERE entry IN(177243, 177365, 177366, 177367, 177368, 177369, 177397, 177398, 177399, 177400);
  482. -- Get Me Out Of Here!
  483. DELETE FROM script_waypoint WHERE entry = 12277 ;
  484. INSERT INTO script_waypoint VALUES
  485. ('12277','0','-1164.330322', '2714.562744', '111.741516', 0, ''),
  486. ('12277','1','-1190.222900', '2707.088379', '111.593864', 0, ''),
  487. ('12277','2','-1234.538452', '2686.017090', '111.401115', 0, ''),
  488. ('12277','3','-1277.848755', '2667.413818', '111.556389', 0, ''),
  489. ('12277','4','-1301.844116', '2631.502930', '111.556618', 0, ''),
  490. ('12277','5','-1325.671143', '2602.701172', '111.556351', 0, ''),
  491. ('12277','6','-1351.805054', '2574.429932', '111.556351', 0, ''),
  492. ('12277','7','-1361.813843', '2559.989258', '110.566650', 0, ''),
  493. ('12277','8','-1376.847412', '2518.233154', '96.845490', 0, ''),
  494. ('12277','9','-1384.587158', '2488.729736', '88.923859', 0, ''),
  495. ('12277','10','-1388.210938', '2450.398682', '88.455811', 0, ''),
  496. ('12277','11','-1392.611328', '2403.852783', '89.508888', 0, ''),
  497. ('12277','12','-1408.148315', '2348.764893', '92.659248', 0, ''),
  498. ('12277','13','-1404.849731', '2308.187256', '91.802071', 0, ''),
  499. ('12277','14','-1418.018677', '2278.302490', '91.742928', 0, ''),
  500. ('12277','15','-1432.626709', '2268.276123', '92.043549', 0, ''),
  501. ('12277','16','-1435.218628', '2246.169922', '92.166252', 0, ''),
  502. ('12277','17','-1449.785400', '2225.094238', '91.026123', 0, ''),
  503. ('12277','18','-1428.572021', '2196.801025', '91.017731', 0, ''),
  504. ('12277','19','-1446.070557', '2180.824463', '91.066788', 0, ''),
  505. ('12277','20','-1471.465454', '2189.873047', '86.395462', 0, ''),
  506. ('12277','21','-1484.633789', '2179.783936', '77.028336', 0, ''),
  507. ('12277','22','-1497.426758', '2151.151855', '61.680458', 0, ''),
  508. ('12277','23','-1504.889160', '2102.811035', '61.981800', 0, ''),
  509. ('12277','24','-1460.801758', '2070.246582', '62.741787', 0, ''),
  510. ('12277','25','-1420.537842', '2060.375488', '62.585442', 0, ''),
  511. ('12277','26','-1398.471313', '2077.599121', '61.888081', 20000, ''),
  512. ('12277','27','-1551.591675', '2007.516479', '61.856163', 0, '');
  513. DELETE FROM script_texts WHERE entry IN(-1500060, -1500061, -1500062);
  514. INSERT INTO script_texts (entry,content_default,sound,type,language,emote,comment) VALUES
  515. (-1500060,'We''re going ot have to scratch the Maraudines off our list. Too hard to work with...',0,0,0,0,' '),
  516. (-1500061,'Well, I''m off to the Gelkis. They''re not as dumb as the Maraudines, but they''re more reasonable.',0,0,0,0,''),
  517. (-1500062,'Bye! Better luck next time!',0,0,0,0,'');
  518. UPDATE creature_template SET ScriptName='npc_melizza_brimbuzzle' WHERE entry=12277;
  519. -- Return to Vahlarriel
  520. UPDATE creature_template SET ScriptName='npc_dalinda_malem' WHERE entry=5644;
  521. DELETE FROM script_waypoint WHERE entry = 5644;
  522. INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES
  523. (5644, 1, -339.679, 1752.04, 139.482, 0, ''),
  524. (5644, 2, -328.957, 1734.95, 139.327, 0, ''),
  525. (5644, 3, -350.747, 1731.12, 139.338, 0, ''),
  526. (5644, 4, -365.064, 1739.04, 139.376, 0, ''),
  527. (5644, 5, -371.105, 1746.03, 139.374, 0, ''),
  528. (5644, 6, -383.141, 1738.62, 138.93, 0, ''),
  529. (5644, 7, -390.445, 1733.98, 136.353, 0, ''),
  530. (5644, 8, -401.368, 1726.77, 131.071, 0, ''),
  531. (5644, 9, -416.016, 1721.19, 129.807, 0, ''),
  532. (5644, 10, -437.139, 1709.82, 126.342, 0, ''),
  533. (5644, 11, -459.862, 1687.92, 116.059, 0, ''),
  534. (5644, 12, -460.686, 1679.55, 111.976, 0, ''),
  535. (5644, 13, -461.485, 1670.94, 109.033, 0, ''),
  536. (5644, 14, -468.53, 1645.51, 102.811, 0, ''),
  537. (5644, 15, -474.529, 1615.97, 97.228, 0, ''),
  538. (5644, 16, -474.329, 1590.01, 94.4982, 0, '');
  539. -- Ghost-o-plasm Round Up
  540. UPDATE creature_template SET ScriptName='npc_magrami_spectre' WHERE entry=11560;
  541. UPDATE item_template SET ScriptName='item_crate_of_ghost_magnets' WHERE entry=15848;
  542. -- Morridune Spawn
  543. UPDATE creature_template SET faction_A = 35, faction_H = 35 WHERE entry = 4829;
  544. DELETE FROM creature_ai_scripts WHERE id = 482903;
  545. INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES
  546. (482903, 4829, 6, 0, 100, 2, 0, 0, 0, 0, 34, 4, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Aku''mai - Instance Data on Death');
  547. DELETE FROM `script_waypoint` WHERE `entry`=6729;
  548. INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES
  549. (6729, 1, -861.803, -460.36, -33.8918, 0, ''),
  550. (6729, 2, -856.168, -464.425, -33.9223, 0, ''),
  551. (6729, 3, -849.964, -469.231, -34.0381, 0, ''),
  552. (6729, 4, -839.838, -473.654, -34.0535, 0, ''),
  553. (6729, 5, -837.417, -473.105, -34.0288, 0, '');
  554. DELETE FROM `script_texts` WHERE `entry` IN(-1048004, -1048003);
  555. INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
  556. (-1048004, 'Speak with me to hear my tale', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  557. (-1048003, 'Aku''mai is dead! At last,I can leave this wretched place.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, '');
  558. -- Lazy peons
  559. DELETE FROM script_texts WHERE entry = -1500063;
  560. INSERT INTO script_texts (entry,content_default,sound,type,language,emote,comment) VALUES
  561. (-1500063,'Ow! OK, I''ll get back to work, $N!',0,0,0,0,' ');
  562. UPDATE creature_template SET ScriptName = "npc_lazy_peon" WHERE entry = 10556;
  563. -- Stinky's Escape
  564. UPDATE creature_template SET ScriptName='npc_stinky' WHERE entry=4880;
  565. DELETE FROM script_texts WHERE entry BETWEEN -1500079 AND -1500070;
  566. INSERT INTO script_texts (entry,content_default,sound,type,language,emote,comment) VALUES
  567. (-1500070,'Ok, let''s get started.',0,0,0,0,'stinky - quest accepted'),
  568. (-1500071,'Now let''s look for the herb.',0,0,0,0,'stinky - say1'),
  569. (-1500072,'Nope, not here...',0,0,0,0,'stinky - say2'),
  570. (-1500073,'There must be one around here somewhere...',0,0,0,0,'stinky - say3'),
  571. (-1500074,'Ah, there''s one! ',0,0,0,0,'stinky - say4'),
  572. (-1500075,'Come, $N! Let''s go over there and collect it!',0,0,0,0,'stinky - say5'),
  573. (-1500076,'Ok, now let''s get out of here! ',0,0,0,0,'stinky - say6'),
  574. (-1500077,'I can make it from here. Thanks, $N! And talk to my employer about a reward!',0,0,0,0,'stinky - quest complete'),
  575. (-1500078,'Help! The beast is on me!',0,0,0,0,'stinky - aggro'),
  576. (-1500079,'%s disappears back into the swamp.',0,2,0,0,'stinky - emote disapper');
  577. DELETE FROM script_waypoint WHERE entry=4880;
  578. INSERT INTO `script_waypoint` VALUES
  579. (4880,0,-2646.429932,-3436.070068,35.373199,0, ''),
  580. (4880,1,-2650.82617,-3440.15332,35.138092,0, ''),
  581. (4880,2,-2662.3147,-3447.67285,35.10891,0, ''),
  582. (4880,3,-2680.4834,-3454.59766,34.6538124,0, ''),
  583. (4880,4,-2701.01855,-3457.43628,34.26906,0, ''),
  584. (4880,5,-2724.063,-3458.63623,33.6734657,0, ''),
  585. (4880,6,-2745.0127,-3459.28125,32.53458,0, ''),
  586. (4880,7,-2759.419,-3464.78174,32.714283,3000, ''),
  587. (4880,8,-2763.63,-3471.50732,33.53883,0, ''),
  588. (4880,9,-2771.789,-3480.88721,33.2553253,0, ''),
  589. (4880,10,-2780.66455,-3488.76343,31.8750439,0, ''),
  590. (4880,11,-2796.144775,-3489.013184,30.858467,3000, ''),
  591. (4880,12,-2792.117920,-3495.966797,30.732433,0, ''),
  592. (4880,13,-2789.059814,-3502.372559,30.670414,0, ''),
  593. (4880,14,-2787.715576,-3515.013428,31.117569,0, ''),
  594. (4880,15,-2790.841309,-3523.311768,30.573286,0, ''),
  595. (4880,16,-2796.58545,-3520.61963,29.9187489,0, ''),
  596. (4880,17,-2798.563,-3518.91064,30.3887444,0, ''),
  597. (4880,18,-2801.46875,-3516.745,30.1914845,0, ''),
  598. (4880,19,-2804.356201,-3513.899170,29.550812,0, ''),
  599. (4880,20,-2807.97559,-3517.99634,29.94883,0, ''),
  600. (4880,21,-2815.680664,-3521.739014,29.772268,0, ''),
  601. (4880,22,-2823.386230,-3526.234131,31.71944,0, ''),
  602. (4880,23,-2836.109619,-3544.695557,32.493855,0, ''),
  603. (4880,24,-2830.392578,-3568.862305,30.410404,0, ''),
  604. (4880,25,-2824.842285,-3569.516846,31.281128,0, ''),
  605. (4880,26,-2818.663818,-3567.801025,30.920368,6000, ''),
  606. (4880,27,-2817.663818,-3568.935059,30.431194,6000, ''),
  607. (4880,28,-2820.394043,-3592.223389,30.716301,6000, ''),
  608. (4880,29,-2820.765625,-3592.497803,30.886147,0, ''),
  609. (4880,30,-2829.909424,-3588.730713,30.683064,0, ''),
  610. (4880,31,-2842.322021,-3577.498291,36.848869,0, ''),
  611. (4880,32,-2851.180420,-3567.579346,38.515850,0, ''),
  612. (4880,33,-2865.554932,-3551.582275,41.438988,0, ''),
  613. (4880,34,-2871.234863,-3548.145020,40.761391,0, ''),
  614. (4880,35,-2877.840332,-3544.147461,38.670235,0, ''),
  615. (4880,36,-2890.394775,-3542.388672,34.314426,0, ''),
  616. (4880,37,-2898.729980,-3543.635742,34.319958,6000, ''),
  617. (4880,38,-2910.064453,-3568.957275,34.250011,0, ''),
  618. (4880,39,-2932.509766,-3584.618652,37.238464,0, '');
  619. -- Freedom for all creatures
  620. UPDATE creature_template SET ScriptName = "npc_kindal_moonweaver" WHERE entry = 7956;
  621. UPDATE creature_template SET ScriptName = "npc_captured_sprite_darter" WHERE entry = 7997;
  622. UPDATE gameobject_template SET ScriptName = "go_sprite_darter_cage_door" WHERE entry = 143979;
  623. DELETE FROM script_waypoint WHERE entry = 7956;
  624. INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES
  625. (7956, 1, -4483.04, 862.62, 74.55, 0, ''),
  626. (7956, 2, -4488.18, 865.62, 80.93, 0, ''),
  627. (7956, 3, -4500.39, 866.58, 86.83, 0, ''),
  628. (7956, 4, -4510.04, 866.36, 85.04, 0, ''),
  629. (7956, 5, -4517.45, 865.08, 80.50, 0, ''),
  630. (7956, 6, -4528.99, 874.46, 67.00, 0, ''),
  631. (7956, 7, -4545.52, 883.62, 57.18, 0, ''),
  632. (7956, 8, -4558.16, 886.59, 58.42, 0, ''),
  633. (7956, 9, -4568.73, 857.06, 61.15, 0, '');
  634. DELETE FROM script_waypoint WHERE entry = 7997;
  635. INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES
  636. (7997, 1, -4533.19, 808.51, 60.06, 0, ''),
  637. (7997, 2, -4536.75, 800.89, 60.14, 0, ''),
  638. (7997, 3, -4548.87, 807.85, 60.76, 0, ''),
  639. (7997, 4, -4568.73, 857.06, 61.15, 0, ''),
  640. (7997, 5, -4589.96, 891.12, 68.72, 0, '');
  641. -- Waking Legends
  642. UPDATE creature_template SET ScriptName = "npc_keeper_remulos" WHERE entry = 11832;
  643. DELETE FROM script_texts WHERE entry BETWEEN -1500091 AND -1500080;
  644. INSERT INTO script_texts (entry,content_default,sound,type,language,emote,comment) VALUES
  645. (-1500080, 'Come $N, the lake is right around the bend.', 0, 0, 0, 0, 'Keeper Remulos'),
  646. (-1500081, 'Stand near me, $N, in case anything should go wrong.', 0, 0, 0, 0, 'Keeper Remulos'),
  647. (-1500082, 'Remulos, old friend. It is good to see you once more. I knew this message would find its way to you - one way or another.', 0, 0, 0, 0, 'Malfurion Stormrage'),
  648. (-1500083, 'It was shrouded in nightmares, Malfurion. What is happening in the Dream? What could cause such atrocities?', 0, 0, 0, 0, 'Keeper Remulos'),
  649. (-1500084, 'I fear for the worst, old friend. Within the Dream we fight a new foe, born of an ancient evil. Ysera''s ancient brood has fallen victim to the old whisperings. It seems as though the Nightmare has broken through the realm and seeks a new host on Azeroth.', 0, 0, 0, 0, 'Malfurion Stormrage'),
  650. (-1500085, 'I sensed as much, Malfurion. Dark days loom ahead.', 0, 0, 0, 0, 'Keeper Remulos'),
  651. (-1500086, 'Aye, Remulos. Prepare the mortal races.', 0, 0, 0, 0, 'Malfurion Stormrage'),
  652. (-1500087, 'You have been gone too long, Malfurion. Peace between the children of Azeroth is tenuous at best. What of my father? Of your brother? Have you any news?', 0, 0, 0, 0, 'Keeper Remulos'),
  653. (-1500088, 'Cenarius fights at my side. Illidan sits upon his throne in the Outland - brooding. I am afraid his loss to Arthas proved to be his breaking point. Madness has embraced him, Remulos. He replays the events in his head a thousand times per day, but in his mind, he is the victor and Arthas is utterly defeated. He is too far gone, old friend. I fear the time may soon come that our bond is tested and it will not be as it was at the Well in Zin-Azshari.', 0, 0, 0, 0, 'Malfurion Stormrage'),
  654. (-1500089, 'Remulos, I am being drawn back... Tyrande... send her my love... Tell her I am safe. Tell her... Tell her I will return... Farewell...', 0, 0, 0, 0, 'Malfurion Stormrage'),
  655. (-1500090, 'Farewell, old friend... Farewell...', 0, 0, 0, 0, 'Keeper Remulos'),
  656. (-1500091, 'Let us return to the grove, mortal.', 0, 0, 0, 0, 'Keeper Remulos');
  657. DELETE FROM script_waypoint WHERE entry = 11832;
  658. INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES
  659. (11832, 1, 7831.83, -2243.35, 464.13, 0, ''),
  660. (11832, 2, 7826.65, -2280.17, 459.42, 0, ''),
  661. (11832, 3, 7817.42, -2303.98, 455.96, 0, ''),
  662. (11832, 4, 7809.91, -2302.23, 455.81, 0, ''),
  663. (11832, 5, 7797.46, -2314.16, 455.54, 0, ''),
  664. (11832, 6, 7784.85, -2320.61, 454.44, 0, ''),
  665. (11832, 7, 7767.19, -2315.55, 456.28, 0, ''),
  666. (11832, 8, 7756.05, -2312.04, 455.89, 0, ''),
  667. (11832, 9, 7761.78, -2296.11, 459.07, 0, ''),
  668. (11832, 10, 7771.94, -2276.98, 454.94, 0, ''),
  669. (11832, 11, 7787.59, -2266.76, 458.70, 0, ''),
  670. (11832, 12, 7790.35, -2254.36, 457.87, 0, ''),
  671. (11832, 13, 7813.68, -2244.12, 461.87, 0, ''),
  672. (11832, 14, 7837.05, -2219.84, 467.81, 0, ''),
  673. (11832, 15, 7848.29, -2216.35, 470.88, 0, '');
  674. DELETE FROM creature_template WHERE entry = 17949;
  675. INSERT INTO `creature_template` (`entry`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `name`, `subname`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Civilian`, `RacialLeader`, `RegenHealth`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES
  676. (17949, 0, 0, 15399, 0, 'Malfurion Stormrage', NULL, 0, 60, 60, 334125, 334125, 0, 0, 0, 994, 994, 2, 1.27, 1.14286, 0, 1, 648, 722, 0, 316, 1, 1666, 1833, 0, 0, 0, 0, 0, 0, 0, 0, 1.4664, 2.0163, 100, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1468, 7341, '', 0, 3, 0, 0, 1, 0, 0, 0, 617299803, 2, '');
  677. -- Glyph Chasing
  678. UPDATE gameobject_template SET ScriptName = "go_glyphed_crystal" WHERE entry IN(180453, 180454, 180455);
  679. -- Silithus
  680. UPDATE gameobject_template SET ScriptName = "go_lesser_wind_stone" WHERE entry IN(180529, 180456, 180518, 180544, 180549, 180564);
  681. UPDATE gameobject_template SET ScriptName = "go_wind_stone" WHERE entry IN(180554, 180461, 180534);
  682. UPDATE gameobject_template SET ScriptName ="go_greater_wind_stone" WHERE entry IN(180466, 180539, 180559);
  683. UPDATE creature_template SET ScriptName = "npc_azenel" WHERE entry = 15610;
  684. --
  685. UPDATE `gameobject_template` SET `ScriptName`='go_crystalline_tear' WHERE `entry`=180633;
  686. UPDATE `creature_template` SET `ScriptName`='mob_qiraj_war_spawn' WHERE `entry` IN (15414,15422,15424,15423);
  687. UPDATE `creature_template` SET `ScriptName`='npc_anachronos_the_ancient' WHERE `entry`=15381;
  688. UPDATE `creature_template` SET `ScriptName`='npc_anachronos_quest_trigger' WHERE `entry`=15454;
  689. DELETE FROM `script_texts` WHERE `entry` BETWEEN -1350030 AND -1350000;
  690. INSERT INTO `script_texts` (`entry`,`content_default`,`type`,`emote`,`comment`) VALUES
  691. (-1350000,'We must act quickly or all shall be lost!',0,1,'ANACHRONOS_SAY_1'),
  692. (-1350001,'NOW, STAGHELM! WE GO NOW! Prepare your magic!',0,81,'ANACHRONOS_SAY_2'),
  693. (-1350002,'Stay close...',0,1,'ANACHRONOS_SAY_3'),
  694. (-1350003,'The sands of time will halt, but only for a moment! I will now conjure the barrier.',0,1,'ANACHRONOS_SAY_4'),
  695. (-1350004,'FINISH THE SPELL STAGHELM! I CANNOT HOLD THE GLYPHS OF WARDING IN PLACE MUCH LONGER! CALL FORTH THE ROOTS!',0,53,'ANACHRONOS_SAY_5'),
  696. (-1350005,'It... It is over, Lord Staghelm. We are victorious. Albeit the cost for this victory was great.',0,1,'ANACHRONOS_SAY_6'),
  697. (-1350006,'There is but one duty that remains...',0,1,'ANACHRONOS_SAY_7'),
  698. (-1350007,'Before I leave this place, I make one final offreing to you, Lord Staghelm. Should a time arise in which you must gain entry to this accursed fortress, use the Scepter of the Shifting Sands on the sacred gong. The magic holding the barrier together will dissipate and the horrors of Ahn''Qiraj will be unleashed upon the world once more.',0,1,'ANACHRONOS_SAY_8'),
  699. (-1350008,'Lord Staghelm, where are you going? You would shatter our bond for the sake of pride?',0,1,'ANACHRONOS_SAY_9'),
  700. (-1350009,'And now you know all that there is to know, mortal...',0,1,'ANACHRONOS_SAY_10'),
  701. (-1350010,'hands the Scepter of the Shifting Sands to Fandral Staghelm.',2,1,'ANACHRONOS_EMOTE_1'),
  702. (-1350011,'shakes his head in dissapointment.',2,274,'ANACHRONOS_EMOTE_2'),
  703. (-1350012,'kneels down to pick up the fragments of the shattered scepter.',2,87,'ANACHRONOS_EMOTE_3'),
  704. (-1350013,'My forces cannot overcome the Qiraji defenses. We will not be able to get close enough to place your precious barrier, dragon.',0,1,'FANDRAL_SAY_1'),
  705. (-1350014,'It is done dragon. Lead the way...',0,1,'FANDRAL_SAY_2'),
  706. (-1350015,'Ancient ones guide my hand... Wake from your slumber! WAKE AND SEAL THIS CURSED PLACE!',0,1,'FANDRAL_SAY_3'),
  707. (-1350016,'After the savagery that my people have witnessed and felt, you expect me to accept another burden, dragon? Surely you are mad.',0,25,'FANDRAL_SAY_4'),
  708. (-1350017,'I want nothing to do with Silithus, the Qiraji and least of all, any damned dragons!',0,1,'FANDRAL_SAY_5'),
  709. (-1350018,'My son''s soul will find no comfort in this hollow victory, dragon. I will have him back.Thought it takes a millennia, I WILL have my son back!',0,254,'FANDRAL_SAY_6'),
  710. (-1350019,'falls to one knee - exhausted.',2,16,'FANDRAL_EMOTE_1'),
  711. (-1350020,'hurls the Scepter of the Shifting Sands into the barrier, shattering it.',2,0,'FANDRAL_EMOTE_2'),
  712. (-1350021,'Aye, Fandral, remember these words: Let not your grief guide your faith. These thoughts you hold... dark places you go, night elf. Absolution cannot be had through misguided vengeance.',0,1,'CAELESTRASZ_SAY_1'),
  713. (-1350022,'Do not forget the sacrifices made on this day, night elf. We have all suffered immensely at the hands of these beasts.',0,1,'CAELESTRASZ_SAY_2'),
  714. (-1350023,'Alexstrasza grant me the resolve to drive our enemies back!',1,53,'CAELESTRASZ_YELL_1'),
  715. (-1350024,'This distraction will give you and the young druid time enough to seal the gate. Do not falter. Now, let us see how they deal with chaotic magic.',0,1,'ARYGOS_SAY_1'),
  716. (-1350025,'Let them feel the wrath of the Blue Flight! May Malygos protect me!',1,53,'ARYGOS_YELL_1'),
  717. (-1350026,'nods knowingly.',2,273,'ARYGOS_EMOTE_1'),
  718. (-1350027,'There is a way...',0,1,'MERITHRA_SAY_1'),
  719. (-1350028,'We will push them back, Anachronos. This I vow. Uphold the end of this task. Let not your hands falter as you seal our fates behind the barrier.',0,1,'MERITHRA_SAY_2'),
  720. (-1350029,'Succumb to the endless dream, little ones. Let it consume you!',1,53,'MERITHRA_YELL_1'),
  721. (-1350030,'glances at her compatriots.',2,2,'MERITHRA_EMOTE_1');
  722. -- Gerenzo's Orders
  723. UPDATE creature_template SET ScriptName = "npc_piznik" WHERE entry = 4276;
  724. -- Meridith the mermaiden
  725. UPDATE creature_template SET ScriptName = "npc_meridith_the_mermaiden" WHERE entry = 15526;
  726. -- Counterattack
  727. UPDATE creature_ai_scripts SET action1_param3 = 2 WHERE id = 945602;
  728. UPDATE creature_template SET ScriptName = "npc_lanti_gah" WHERE entry = 9990;
  729. -- Plundering the Plunderers
  730. UPDATE creature_template SET ScriptName = "npc_wrenix_gizmotronic_apparatus" WHERE entry = 7166;
  731. -- Hypercapacitor Gizmo
  732. UPDATE creature_template SET ScriptName = "npc_enraged_panther" WHERE entry = 10992;
  733. UPDATE gameobject_template SET ScriptName = "go_panther_cage" WHERE entry = 176195;
  734. -- Decoy
  735. UPDATE quest_template SET ReqCreatureOrGOId1 = 15554, ReqCreatureOrGOCount1 = 1 WHERE entry = 8606;
  736. DELETE FROM gameobject WHERE id = 180660 ;
  737. INSERT INTO gameobject (guid,id,map,position_x,position_y,position_z,orientation,rotation0,rotation1,rotation2,rotation3,spawntimesecs,animprogress,state ) VALUES
  738. (NULL, 180660, 1, 5087.36, -5113.17, 930.594, 4.75205, 0, 0, 0.692947, -0.720988, 300, 0, 1) ;
  739. UPDATE event_scripts SET datalong = 15553, x = 5043, y = -5146, z = 944, o = 0.71 WHERE id = 9527;
  740. UPDATE creature_template SET ScriptName = "npc_weavil_flying_machine" WHERE entry = 15553;
  741. DELETE FROM script_texts WHERE entry BETWEEN -1500099 AND -1500095;
  742. INSERT INTO script_texts (entry,content_default,sound,type,language,emote,comment) VALUES
  743. (-1500095, 'No hello for your old friend, Narain? Who were you expecting?', 0, 0, 0, 0, ''),
  744. (-1500096, 'eyes you suspiciously', 0, 2, 0, 0, ''),
  745. (-1500097, 'So... You thought you could fool me, did you? The greatest criminal mastermind Azeroth has ever known?', 0, 0, 0, 0, ''),
  746. (-1500098, 'I see right through your disguise, <race>. Number Two! Number Two kill!', 0, 0, 0, 0, ''),
  747. (-1500099, 'KILL!!', 0, 0, 0, 0, '');
  748. -- The scent of Lar'kowi
  749. DELETE FROM scripted_areatrigger WHERE entry IN(1726,1727,1728,1729,1730,1731,1732,1733,1734,1735,1736,1737,1738,1739,1740);
  750. INSERT INTO `scripted_areatrigger` (`entry`, `ScriptName`) VALUES
  751. (1726, 'at_scent_larkorwi'),
  752. (1727, 'at_scent_larkorwi'),
  753. (1728, 'at_scent_larkorwi'),
  754. (1729, 'at_scent_larkorwi'),
  755. (1730, 'at_scent_larkorwi'),
  756. (1731, 'at_scent_larkorwi'),
  757. (1732, 'at_scent_larkorwi'),
  758. (1733, 'at_scent_larkorwi'),
  759. (1734, 'at_scent_larkorwi'),
  760. (1735, 'at_scent_larkorwi'),
  761. (1736, 'at_scent_larkorwi'),
  762. (1737, 'at_scent_larkorwi'),
  763. (1738, 'at_scent_larkorwi'),
  764. (1739, 'at_scent_larkorwi'),
  765. (1740, 'at_scent_larkorwi');
  766. -- Scholomance
  767. DELETE FROM areatrigger_teleport WHERE id IN(2547, 2548, 2549);
  768. INSERT INTO `areatrigger_teleport` (`id`, `name`, `required_level`, `required_item`, `required_item2`, `required_quest_done`, `required_failed_text`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
  769. (2547, 'Scholomance - Kirtonos Balcony', 0, 0, 0, 0, NULL, 0, 1453.92, -2570.72, 94.62, 3.17),
  770. (2548, 'Scholomance - Kirtonos Balcony', 0, 0, 0, 0, NULL, 0, 1453.92, -2570.72, 94.62, 3.17),
  771. (2549, 'Scholomance - Kirtonos Balcony', 0, 0, 0, 0, NULL, 0, 1453.92, -2570.72, 94.62, 3.17);
  772. -- Viewing room event
  773. UPDATE creature_template SET npcflag = 0 WHERE entry = 10433;
  774. -- Kormok
  775. DELETE FROM creature WHERE id = 16118;
  776. -- Postman Malown
  777. DELETE FROM script_texts WHERE entry IN(-1500100, -1500101);
  778. INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
  779. (-1500100, 'Prepare to be Malowned!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  780. (-1500101, 'You just got MALOWNED!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, '');
  781. UPDATE gameobject_template SET ScriptName = "go_stratholme_mailbox" WHERE entry IN(176346, 176349, 176350, 176351, 176352, 176353);
  782. UPDATE gameobject_template SET ScriptName = "go_blacksmithing_plans" WHERE entry IN(176325, 176327);
  783. -- Scarlet Cannons
  784. UPDATE gameobject_template SET ScriptName = "go_scarlet_cannon" WHERE entry IN(176216, 176216);
  785. UPDATE gameobject SET spawntimesecs = 360 WHERE id = 176211;
  786. -- Death Pact
  787. DELETE FROM spell_script_target WHERE entry = 17471;
  788. INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
  789. (17471, 1, 11197);
  790. -- Aurius's Reckoning
  791. DELETE FROM creature_questrelation WHERE quest = 5125;
  792. UPDATE quest_template SET SpecialFlags = 0, CompleteScript = 5125 WHERE entry = 5125;
  793. UPDATE creature_template SET ScriptName = "npc_aurius" WHERE entry = 10917;
  794. DELETE FROM script_texts WHERE entry IN(-1500120, -1500121);
  795. INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
  796. (-1500120, 'Rivendare! I come for you!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, ''),
  797. (-1500121, 'Argh!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, '');
  798. DELETE FROM db_script_string WHERE entry = 3000000000;
  799. INSERT INTO `db_script_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES
  800. (3000000000, 'Leave me. My wounds are great and I fear they will overtake me. Thank you, $n, I will die here, but because of you... I''ll die in peace.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
  801. DELETE FROM quest_end_scripts WHERE id = 5125;
  802. INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `comments`) VALUES
  803. (5125, 2, 0, 0, 0, 0, 0, 0, 2100000000, 0, 0, 0, 0, 0, 0, 0, '');
  804. DELETE FROM spell_target_position WHERE id IN(17475,17476,17477,17478,17479,17480);
  805. INSERT INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
  806. (17475, 329, 4017.403809, -3339.703369, 115.057655, 5.487860),
  807. (17476, 329, 4013.189209, -3351.808350, 115.052254, 0.134280),
  808. (17477, 329, 4017.738037, -3363.478016, 115.057274, 0.723313),
  809. (17478, 329, 4048.877197, -3363.223633, 115.054253, 3.627735),
  810. (17479, 329, 4051.777588, -3350.893311, 115.055351, 3.066176),
  811. (17480, 329, 4048.375977, -3339.966309, 115.055222, 2.457497);
  812. -- Merge ScriptDev2
  813. UPDATE gameobject_template SET ScriptName='go_service_gate' WHERE entry=175368;
  814. DELETE FROM script_texts WHERE entry BETWEEN -1329015 AND -1329008;
  815. INSERT INTO script_texts (entry,content_default,sound,type,language,emote,comment) VALUES
  816. (-1329008,'Intruders at the Service Gate! Lord Rivendare must be warned!',0,6,0,0,'barthilas SAY_WARN_BARON'),
  817. (-1329009,'Intruders! More pawns of the Argent Dawn, no doubt. I already count one of their number among my prisoners. Withdraw from my domain before she is executed!',0,6,0,0,'baron rivendare SAY_ANNOUNCE_RUN_START'),
  818. (-1329010,'You\'re still here? Your foolishness is amusing! The Argent Dawn wench needn\'t suffer in vain. Leave at once and she shall be spared!',0,6,0,0,'baron rivendare SAY_ANNOUNCE_RUN_10_MIN'),
  819. (-1329011,'I shall take great pleasure in taking this poor wretch\'s life! It\'s not too late, she needn\'t suffer in vain. Turn back and her death shall be merciful!',0,6,0,0,'baron rivendare SAY_ANNOUNCE_RUN_5_MIN'),
  820. (-1329012,'May this prisoner\'s death serve as a warning. None shall defy the Scourge and live!',0,6,0,0,'baron rivendare SAY_ANNOUNCE_RUN_FAIL'),
  821. (-1329013,'So you see fit to toy with the Lich King\'s creations? Ramstein, be sure to give the intruders a proper greeting.',0,6,0,0,'baron rivendare SAY_ANNOUNCE_RAMSTEIN'),
  822. (-1329014,'Time to take matters into my own hands. Come. Enter my domain and challenge the might of the Scourge!',0,6,0,0,'baron rivendare SAY_UNDEAD_DEFEAT'),
  823. (-1329015,'You did it... you\'ve slain Baron Rivendare! The Argent Dawn shall hear of your valiant deeds!',0,0,0,0,'ysida SAY_EPILOGUE');
  824. -- Dire Maul
  825. -- Pusillin
  826. DELETE FROM script_texts WHERE entry BETWEEN -1500144 AND -1500130;
  827. INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
  828. (-1500130, 'Do you want to play a game, stinky?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  829. (-1500131, 'A Game? Are you crazy?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  830. (-1500132, 'If you want the key, you''ll have to catch me!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  831. (-1500133, 'I hold the key to lands of free! Catch me and you''ll see!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  832. (-1500134, 'Why you little...', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  833. (-1500135, 'Chase me if you dare! I run without a care!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  834. (-1500136, 'Still alive? You do surprise. Watch me as I flee!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  835. (-1500137, 'Mark my words, I will catch you, imp. And when I do!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  836. (-1500138, 'Why would you ever want to harm me!? Come. Friends we can be!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  837. (-1500139, 'Turn that frown upside down!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  838. (-1500140, 'DIE!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  839. (-1500141, 'Die?! You make Pusillin cry!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  840. (-1500142, 'This is the end of the line, no friend of mine!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  841. (-1500143, 'Prepare to meet your maker.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  842. (-1500144, 'Say hello to my little friends!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, '');
  843. UPDATE creature_template SET ScriptName = "boss_pusillin" WHERE entry = 14354;
  844. DELETE FROM script_waypoint WHERE entry = 14354;
  845. INSERT INTO script_waypoint VALUES
  846. (14354, 0, -160.68, -199.37, -4.15, 0, ''),
  847. (14354, 1, -156.90, -279.90, -4.15, 0, ''),
  848. (14354, 2, -132.36, -350.44, -4.07, 0, ''),
  849. (14354, 3, 112.55, -358.67, -4.15, 0, ''),
  850. (14354, 4, 111.98, -468.78, -2.71, 0, ''),
  851. (14354, 5, 112.25, -484.98, -6.79, 0, ''),
  852. (14354, 6, 111.70, -514.82, -6.91, 0, ''),
  853. (14354, 7, 112.11, -529.99, -10.94, 0, ''),
  854. (14354, 8, 103.35, -543.82, -11.07, 0, ''),
  855. (14354, 9, 92.88, -544.70, -11.08, 0, ''),
  856. (14354, 10, 78.86, -545.87, -15.21, 0, ''),
  857. (14354, 11, 68.07, -548.15, -15.24, 0, ''),
  858. (14354, 12, 54.92, -556.36, -19.29, 0, ''),
  859. (14354, 13, 50.37, -565.67, -19.41, 0, ''),
  860. (14354, 14, 50.05, -587.18, -23.57, 0, ''),
  861. (14354, 15, 42.53, -615.96, -25.08, 0, ''),
  862. (14354, 16, 44.24, -682.40, -25.16, 0, ''),
  863. (14354, 17, 2.57, -695.90, -25.16, 0, ''),
  864. (14354, 18, 2.36, -671.94, -12.64, 0, ''),
  865. (14354, 19, 17.14, -672.51, -12.64, 0, ''),
  866. (14354, 20, 17.27, -690.07, -12.64, 0, '');
  867. -- Massive Geyser
  868. UPDATE creature_template SET unit_flags = 768 WHERE entry = 14122;
  869. -- From ScriptDev2
  870. UPDATE instance_template SET ScriptName='instance_dire_maul' WHERE map=429;
  871. DELETE FROM script_texts WHERE entry IN (-1429000, -1429001);
  872. INSERT INTO script_texts (entry,content_default,sound,type,language,emote,comment) VALUES
  873. (-1429000,'The demon is loose! Quickly we must restrain him!',0,6,0,0,'highborne summoner SAY_FREE_IMMOLTHAR'),
  874. (-1429001,'Who dares disrupt the sanctity of Eldre''Thalas? Face me, cowards!',0,6,0,0,'prince tortheldrin SAY_KILL_IMMOLTHAR');
  875. -- Haunted Locus
  876. DELETE FROM creature WHERE id IN(16101, 16102);
  877. -- Isalien
  878. DELETE FROM creature WHERE id = 16097;
  879. -- Elven legends
  880. UPDATE gameobject_template SET ScriptName = "go_skeletal_remains_of_kariel_winthalus" WHERE entry = 179544;
  881. -- Ice Lock
  882. DELETE FROM spell_script_target WHERE entry = 5249;
  883. INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
  884. (5249, 1, 14323);
  885. -- Objects
  886. DELETE FROM gameobject WHERE id IN(179675,176907,177220,177219,179545,179485,181346,176905,176906,177211,177212,177213,177215,177217,177221,177257,177258,177259,179502,179503,179504,179505,179506,179526,179528,179532,179533,179548,179550,179563) AND map = 429;
  887. INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  888. (NULL, 176905, 429, -21.1056, -392.466, -58.1027, -1.16064, 0, 0, 0, 1, 180, 255, 1),
  889. (NULL, 176906, 429, 4.30669, -441.621, -37.9976, -2.71398, 0, 0, 0, 1, 180, 255, 1),
  890. (NULL, 176907, 429, 131.286, -278.89, -56.5211, 3.14159, 0, 0, 0, 1, 180, 255, 1),
  891. (NULL, 179485, 429, 558.806, 550.065, -25.4008, 3.14159, 0, 0, 0, 1, 180, 255, 1),
  892. (NULL, 179502, 429, 277.695, -423.25, -120.04, -2.92342, 0, 0, 0, 1, 180, 255, 1),
  893. (NULL, 179503, 429, -38.9654, 813.709, -27.3178, 0, 0, 0, 0, 1, 180, 255, 1),
  894. (NULL, 179504, 429, 78.1384, 737.402, -24.6216, 0, 0, 0, 0, 1, 180, 255, 1),
  895. (NULL, 179505, 429, -155.434, 734.166, -24.6216, 0, 0, 0, 0, 1, 180, 255, 1),
  896. (NULL, 179506, 429, -38.7567, 812.587, -3.8761, 0, 0, 0, 0, 1, 180, 255, 1),
  897. (NULL, 177211, 429, -41.8255, 159.874, -3.44834, 0, 0, 0, 0, 1, 180, 255, 1),
  898. (NULL, 177212, 429, 10.7215, 159.459, -3.44834, 3.14159, 0, 0, 0, 1, 180, 255, 1),
  899. (NULL, 177213, 429, 10.5912, -154.998, -2.69379, 3.14159, 0, 0, 0, 1, 180, 255, 1),
  900. (NULL, 177215, 429, 255.408, 10.3792, -2.69381, 1.5708, 0, 0, 0, 1, 180, 255, 1),
  901. (NULL, 177217, 429, 491.204, 515.133, 29.4675, 1.54854, 0, 0, 0.699195, 0.714931, 180, 255, 1),
  902. (NULL, 177219, 429, 385.327, 374.232, -1.34314, 1.56512, 0, 0, 0.705098, 0.70911, 180, 255, 1),
  903. (NULL, 177220, 429, 252.327, -404.921, -120.62, 4.7124, 0, 0.711534, -0.702652, 1, 180, 255, 1),
  904. (NULL, 177221, 429, 50.5861, 501.941, -23.1499, 4.7124, 0, 0, 0, 1, 180, 255, 1),
  905. (NULL, 179545, 429, 116.135, 638.836, -48.467, -0.785397, 0, 0, 0, 1, 7200, 255, 1),
  906. (NULL, 179550, 429, 83.2549, 630.546, -24.6315, 5.64614, 0, 0, 0.299757, -0.954016, 180, 255, 1),
  907. (NULL, 177257, 429, -92.3458, 442.67, 28.547, 0.418879, 0, 0, 0, 1, 180, 255, 1),
  908. (NULL, 177258, 429, 121.222, 429.092, 28.4548, 0.418879, 0, 0, 0, 1, 180, 255, 1),
  909. (NULL, 177259, 429, 12.9412, 277.931, -8.93289, 0, 0, 0, 0, 1, 180, 255, 1),
  910. (NULL, 179563, 429, 116.105, 638.89, -48.467, -1.76278, 0, 0, 0, 1, 7200, 255, 1),
  911. (NULL, 179526, 429, -27.0036, -404.283, -58.614, 0.226892, 0, 0, 0, 1, 600, 255, 1),
  912. (NULL, 179526, 429, -131.851, -319.414, -56.7906, 0.244346, 0, 0, 0, 1, 600, 255, 1),
  913. (NULL, 179526, 429, -22.3061, -349.882, -4.07224, -2.02458, 0, 0, 0, 1, 600, 255, 1),
  914. (NULL, 179526, 429, -156.299, -321.1, -4.14717, 1.25664, 0, 0, 0, 1, 600, 255, 1),
  915. (NULL, 179526, 429, 31.0736, -681.584, -25.1616, 0, 0, 0, 0, 1, 600, 255, 1),
  916. (NULL, 179526, 429, 36.7152, -467.008, -4.24876, 1.58825, 0, 0, 0, 1, 600, 255, 1),
  917. (NULL, 179526, 429, -10.2151, -349.267, -53.8632, 2.05949, 0, 0, 0, 1, 600, 255, 1),
  918. (NULL, 179526, 429, -51.4662, -358.168, -4.13823, 1.81514, 0, 0, 0, 1, 600, 255, 1),
  919. (NULL, 179526, 429, 21.9326, -409.795, -58.6142, 0, 0, 0, 0, 1, 600, 255, 1),
  920. (NULL, 179526, 429, 117.148, -408.461, -3.27357, 2.32129, 0, 0, 0, 1, 600, 255, 1),
  921. (NULL, 179526, 429, 102.549, -246.011, -56.3647, 0.785397, 0, 0, 0, 1, 600, 255, 1),
  922. (NULL, 179526, 429, 263.393, -568.436, -111.976, -2.67035, 0, 0, 0, 1, 600, 255, 1),
  923. (NULL, 179526, 429, 477.125, 307.609, 2.85288, 1.74533, 0, 0, 0, 1, 600, 255, 1),
  924. (NULL, 179526, 429, 423.649, -94.0369, -3.88739, -0.453785, 0, 0, 0, 1, 600, 255, 1),
  925. (NULL, 179526, 429, 4.90084, -450.306, -58.6294, 0, 0, 0, 0, 1, 600, 255, 1),
  926. (NULL, 179526, 429, 71.7209, -409.745, -4.21656, 3.12412, 0, 0, 0, 1, 600, 255, 1),
  927. (NULL, 179526, 429, -27.7882, -388.435, -4.22943, 1.39626, 0, 0, 0, 1, 600, 255, 1),
  928. (NULL, 179526, 429, -42.6484, -341.5, -52.6547, 0.244346, 0, 0, 0, 1, 600, 255, 1),
  929. (NULL, 179526, 429, 34.9096, -365.079, -4.14052, 0.314158, 0, 0, 0, 1, 600, 255, 1),
  930. (NULL, 179526, 429, -114.736, -199.653, -4.1244, 0, 0, 0, 0, 1, 600, 255, 1),
  931. (NULL, 179526, 429, 101.961, -247.727, -4.01977, 2.84488, 0, 0, 0, 1, 600, 255, 1),
  932. (NULL, 179526, 429, 126.702, -248.335, -4.14639, -2.72271, 0, 0, 0, 1, 600, 255, 1),
  933. (NULL, 179526, 429, 66.2358, -633.758, -25.163, 3.05433, 0, 0, 0, 1, 600, 255, 1),
  934. (NULL, 179526, 429, -6.16094, -433.403, -4.22212, 0, 0, 0, 0, 1, 600, 255, 1),
  935. (NULL, 179526, 429, 2.64945, -210.379, -52.3845, -0.95993, 0, 0, 0, 1, 600, 255, 1),
  936. (NULL, 179526, 429, -168.655, -271.912, -4.12082, -0.750491, 0, 0, 0, 1, 600, 255, 1),
  937. (NULL, 179526, 429, 55.8777, -438.434, -58.5981, -0.855211, 0, 0, 0, 1, 600, 255, 1),
  938. (NULL, 179526, 429, 59.0393, -760.028, -25.0955, -1.23918, 0, 0, 0, 1, 600, 255, 1),
  939. (NULL, 179526, 429, 71.7946, -437.261, -58.5956, 0.872664, 0, 0, 0, 1, 600, 255, 1),
  940. (NULL, 179526, 429, -28.3324, -385.063, -58.6181, 1.95477, 0, 0, 0, 1, 600, 255, 1),
  941. (NULL, 179526, 429, 47.8125, -334.275, -52.0553, -0.506145, 0, 0, 0, 1, 600, 255, 1),
  942. (NULL, 179526, 429, 353.105, -447.005, -90.0577, 0, 0, 0, 0, 1, 600, 255, 1),
  943. (NULL, 179526, 429, 509.725, 523.927, -25.4027, -2.80997, 0, 0, 0, 1, 600, 255, 1),
  944. (NULL, 179526, 429, 456.691, -47.364, -3.88702, -1.76278, 0, 0, 0, 1, 600, 255, 1),
  945. (NULL, 179526, 429, 34.5069, -391.211, -58.6112, -2.16421, 0, 0, 0, 1, 600, 255, 1),
  946. (NULL, 179526, 429, -12.3063, -396.872, -4.22113, -0.593412, 0, 0, 0, 1, 600, 255, 1),
  947. (NULL, 179526, 429, 127.199, -272.801, -4.14639, -1.93732, 0, 0, 0, 1, 600, 255, 1),
  948. (NULL, 179526, 429, -94.2365, -406.708, -58.6073, 0, 0, 0, 0, 1, 600, 255, 1),
  949. (NULL, 179526, 429, -112.021, -258.887, -56.2501, 0, 0, 0, 0, 1, 600, 255, 1),
  950. (NULL, 179526, 429, 134.767, -262.46, -4.14639, -0.488691, 0, 0, 0, 1, 600, 255, 1),
  951. (NULL, 179526, 429, -148.661, -210.009, -4.1514, 0.418879, 0, 0, 0, 1, 600, 255, 1),
  952. (NULL, 179526, 429, 32.7576, -775.236, -25.1416, -1.309, 0, 0, 0, 1, 600, 255, 1),
  953. (NULL, 179526, 429, -109.888, -404.549, -4.21786, -2.07694, 0, 0, 0, 1, 600, 255, 1),
  954. (NULL, 179526, 429, -61.5861, -306.311, -55.7067, 2.33874, 0, 0, 0, 1, 600, 255, 1),
  955. (NULL, 179526, 429, -7.83484, -199.983, -4.12879, -0.453785, 0, 0, 0, 1, 600, 255, 1),
  956. (NULL, 179526, 429, 64.8074, -400.448, -58.6044, -0.628317, 0, 0, 0, 1, 600, 255, 1),
  957. (NULL, 179526, 429, 44.9141, -626.477, -25.1061, -2.47837, 0, 0, 0, 1, 600, 255, 1),
  958. (NULL, 179526, 429, 66.1826, -315.416, -54.2518, 0, 0, 0, 0, 1, 600, 255, 1),
  959. (NULL, 179526, 429, 242.178, -420.788, -119.962, -0.069812, 0, 0, 0, 1, 600, 255, 1),
  960. (NULL, 179526, 429, 490.501, 551.961, -25.381, -0.418879, 0, 0, 0, 1, 600, 255, 1),
  961. (NULL, 179526, 429, 468.448, 258.01, 6.34532, 1.02974, 0, 0, 0, 1, 600, 255, 1),
  962. (NULL, 179526, 429, -5.54965, -393.198, -58.6137, -0.209439, 0, 0, 0, 1, 600, 255, 1),
  963. (NULL, 179526, 429, -124.622, -234.072, -55.1133, -0.314158, 0, 0, 0, 1, 600, 255, 1),
  964. (NULL, 179526, 429, 119.36, -336.64, -4.14986, -1.44862, 0, 0, 0, 1, 600, 255, 1),
  965. (NULL, 179526, 429, -75.923, -358.893, -4.14481, 2.87979, 0, 0, 0, 1, 600, 255, 1),
  966. (NULL, 179526, 429, 41.8712, -744.931, -25.1339, 0.104719, 0, 0, 0, 1, 600, 255, 1),
  967. (NULL, 179526, 429, 36.7851, -402.629, -4.21849, -2.49582, 0, 0, 0, 1, 600, 255, 1),
  968. (NULL, 179526, 429, -14.44, -309.911, -52.1458, 0, 0, 0, 0, 1, 600, 255, 1),
  969. (NULL, 179526, 429, 126.758, -296.278, -4.14639, -1.95477, 0, 0, 0, 1, 600, 255, 1),
  970. (NULL, 179526, 429, -32.8264, -463.171, -58.6176, 0.488691, 0, 0, 0, 1, 600, 255, 1),
  971. (NULL, 179526, 429, 17.3334, -704.192, -12.6426, -2.19912, 0, 0, 0, 1, 600, 255, 1),
  972. (NULL, 179526, 429, 50.4484, -241.885, -53.2931, 1.8675, 0, 0, 0, 1, 600, 255, 1),
  973. (NULL, 179526, 429, 189.484, -482.115, -100.601, 1.93731, 0, 0, 0, 1, 600, 255, 1),
  974. (NULL, 179526, 429, 423.59, 262.49, 11.1475, 0, 0, 0, 0, 1, 600, 255, 1),
  975. (NULL, 179526, 429, 475.207, -104.252, -3.88595, -1.32645, 0, 0, 0, 1, 600, 255, 1),
  976. (NULL, 179528, 429, -27.0036, -404.283, -58.614, 0.226892, 0, 0, 0, 1, 600, 255, 1),
  977. (NULL, 179528, 429, -131.851, -319.414, -56.7906, 0.244346, 0, 0, 0, 1, 600, 255, 1),
  978. (NULL, 179528, 429, -22.3061, -349.882, -4.07224, -2.02458, 0, 0, 0, 1, 600, 255, 1),
  979. (NULL, 179528, 429, -156.299, -321.1, -4.14717, 1.25664, 0, 0, 0, 1, 600, 255, 1),
  980. (NULL, 179528, 429, 31.0736, -681.584, -25.1616, 0, 0, 0, 0, 1, 600, 255, 1),
  981. (NULL, 179528, 429, 36.7152, -467.008, -4.24876, 1.58825, 0, 0, 0, 1, 600, 255, 1),
  982. (NULL, 179528, 429, -10.2151, -349.267, -53.8632, 2.05949, 0, 0, 0, 1, 600, 255, 1),
  983. (NULL, 179528, 429, -51.4662, -358.168, -4.13823, 1.81514, 0, 0, 0, 1, 600, 255, 1),
  984. (NULL, 179528, 429, 21.9326, -409.795, -58.6142, 0, 0, 0, 0, 1, 600, 255, 1),
  985. (NULL, 179528, 429, 117.148, -408.461, -3.27357, 2.32129, 0, 0, 0, 1, 600, 255, 1),
  986. (NULL, 179528, 429, 102.549, -246.011, -56.3647, 0.785397, 0, 0, 0, 1, 600, 255, 1),
  987. (NULL, 179528, 429, 263.393, -568.436, -111.976, -2.67035, 0, 0, 0, 1, 600, 255, 1),
  988. (NULL, 179528, 429, 477.125, 307.609, 2.85288, 1.74533, 0, 0, 0, 1, 600, 255, 1),
  989. (NULL, 179528, 429, 423.649, -94.0369, -3.88739, -0.453785, 0, 0, 0, 1, 600, 255, 1),
  990. (NULL, 179528, 429, 4.90084, -450.306, -58.6294, 0, 0, 0, 0, 1, 600, 255, 1),
  991. (NULL, 179528, 429, 71.7209, -409.745, -4.21656, 3.12412, 0, 0, 0, 1, 600, 255, 1),
  992. (NULL, 179528, 429, -27.7882, -388.435, -4.22943, 1.39626, 0, 0, 0, 1, 600, 255, 1),
  993. (NULL, 179528, 429, -42.6484, -341.5, -52.6547, 0.244346, 0, 0, 0, 1, 600, 255, 1),
  994. (NULL, 179528, 429, 34.9096, -365.079, -4.14052, 0.314158, 0, 0, 0, 1, 600, 255, 1),
  995. (NULL, 179528, 429, -114.736, -199.653, -4.1244, 0, 0, 0, 0, 1, 600, 255, 1),
  996. (NULL, 179528, 429, 101.961, -247.727, -4.01977, 2.84488, 0, 0, 0, 1, 600, 255, 1),
  997. (NULL, 179528, 429, 126.702, -248.335, -4.14639, -2.72271, 0, 0, 0, 1, 600, 255, 1),
  998. (NULL, 179528, 429, 66.2358, -633.758, -25.163, 3.05433, 0, 0, 0, 1, 600, 255, 1),
  999. (NULL, 179528, 429, -6.16094, -433.403, -4.22212, 0, 0, 0, 0, 1, 600, 255, 1),
  1000. (NULL, 179528, 429, 2.64945, -210.379, -52.3845, -0.95993, 0, 0, 0, 1, 600, 255, 1),
  1001. (NULL, 179528, 429, -168.655, -271.912, -4.12082, -0.750491, 0, 0, 0, 1, 600, 255, 1),
  1002. (NULL, 179528, 429, 55.8777, -438.434, -58.5981, -0.855211, 0, 0, 0, 1, 600, 255, 1),
  1003. (NULL, 179528, 429, 59.0393, -760.028, -25.0955, -1.23918, 0, 0, 0, 1, 600, 255, 1),
  1004. (NULL, 179528, 429, 71.7946, -437.261, -58.5956, 0.872664, 0, 0, 0, 1, 600, 255, 1),
  1005. (NULL, 179528, 429, -28.3324, -385.063, -58.6181, 1.95477, 0, 0, 0, 1, 600, 255, 1),
  1006. (NULL, 179528, 429, 47.8125, -334.275, -52.0553, -0.506145, 0, 0, 0, 1, 600, 255, 1),
  1007. (NULL, 179528, 429, 353.105, -447.005, -90.0577, 0, 0, 0, 0, 1, 600, 255, 1),
  1008. (NULL, 179528, 429, 509.725, 523.927, -25.4027, -2.80997, 0, 0, 0, 1, 600, 255, 1),
  1009. (NULL, 179528, 429, 456.691, -47.364, -3.88702, -1.76278, 0, 0, 0, 1, 600, 255, 1),
  1010. (NULL, 179528, 429, 34.5069, -391.211, -58.6112, -2.16421, 0, 0, 0, 1, 600, 255, 1),
  1011. (NULL, 179528, 429, -12.3063, -396.872, -4.22113, -0.593412, 0, 0, 0, 1, 600, 255, 1),
  1012. (NULL, 179528, 429, 127.199, -272.801, -4.14639, -1.93732, 0, 0, 0, 1, 600, 255, 1),
  1013. (NULL, 179528, 429, -94.2365, -406.708, -58.6073, 0, 0, 0, 0, 1, 600, 255, 1),
  1014. (NULL, 179528, 429, -112.021, -258.887, -56.2501, 0, 0, 0, 0, 1, 600, 255, 1),
  1015. (NULL, 179528, 429, 134.767, -262.46, -4.14639, -0.488691, 0, 0, 0, 1, 600, 255, 1),
  1016. (NULL, 179528, 429, -148.661, -210.009, -4.1514, 0.418879, 0, 0, 0, 1, 600, 255, 1),
  1017. (NULL, 179528, 429, 32.7576, -775.236, -25.1416, -1.309, 0, 0, 0, 1, 600, 255, 1),
  1018. (NULL, 179528, 429, -109.888, -404.549, -4.21786, -2.07694, 0, 0, 0, 1, 600, 255, 1),
  1019. (NULL, 179528, 429, -61.5861, -306.311, -55.7067, 2.33874, 0, 0, 0, 1, 600, 255, 1),
  1020. (NULL, 179528, 429, -7.83484, -199.983, -4.12879, -0.453785, 0, 0, 0, 1, 600, 255, 1),
  1021. (NULL, 179528, 429, 64.8074, -400.448, -58.6044, -0.628317, 0, 0, 0, 1, 600, 255, 1),
  1022. (NULL, 179528, 429, 44.9141, -626.477, -25.1061, -2.47837, 0, 0, 0, 1, 600, 255, 1),
  1023. (NULL, 179528, 429, 66.1826, -315.416, -54.2518, 0, 0, 0, 0, 1, 600, 255, 1),
  1024. (NULL, 179528, 429, 242.178, -420.788, -119.962, -0.069812, 0, 0, 0, 1, 600, 255, 1),
  1025. (NULL, 179528, 429, 490.501, 551.961, -25.381, -0.418879, 0, 0, 0, 1, 600, 255, 1),
  1026. (NULL, 179528, 429, 468.448, 258.01, 6.34532, 1.02974, 0, 0, 0, 1, 600, 255, 1),
  1027. (NULL, 179528, 429, -5.54965, -393.198, -58.6137, -0.209439, 0, 0, 0, 1, 600, 255, 1),
  1028. (NULL, 179528, 429, -124.622, -234.072, -55.1133, -0.314158, 0, 0, 0, 1, 600, 255, 1),
  1029. (NULL, 179528, 429, 119.36, -336.64, -4.14986, -1.44862, 0, 0, 0, 1, 600, 255, 1),
  1030. (NULL, 179528, 429, -75.923, -358.893, -4.14481, 2.87979, 0, 0, 0, 1, 600, 255, 1),
  1031. (NULL, 179528, 429, 41.8712, -744.931, -25.1339, 0.104719, 0, 0, 0, 1, 600, 255, 1),
  1032. (NULL, 179528, 429, 36.7851, -402.629, -4.21849, -2.49582, 0, 0, 0, 1, 600, 255, 1),
  1033. (NULL, 179528, 429, -14.44, -309.911, -52.1458, 0, 0, 0, 0, 1, 600, 255, 1),
  1034. (NULL, 179528, 429, 126.758, -296.278, -4.14639, -1.95477, 0, 0, 0, 1, 600, 255, 1),
  1035. (NULL, 179528, 429, -32.8264, -463.171, -58.6176, 0.488691, 0, 0, 0, 1, 600, 255, 1),
  1036. (NULL, 179528, 429, 17.3334, -704.192, -12.6426, -2.19912, 0, 0, 0, 1, 600, 255, 1),
  1037. (NULL, 179528, 429, 50.4484, -241.885, -53.2931, 1.8675, 0, 0, 0, 1, 600, 255, 1),
  1038. (NULL, 179528, 429, 189.484, -482.115, -100.601, 1.93731, 0, 0, 0, 1, 600, 255, 1),
  1039. (NULL, 179528, 429, 423.59, 262.49, 11.1475, 0, 0, 0, 0, 1, 600, 255, 1),
  1040. (NULL, 179528, 429, 475.207, -104.252, -3.88595, -1.32645, 0, 0, 0, 1, 600, 255, 1),
  1041. (NULL, 179532, 429, -27.0036, -404.283, -58.614, 0.226892, 0, 0, 0, 1, 600, 255, 1),
  1042. (NULL, 179532, 429, -131.851, -319.414, -56.7906, 0.244346, 0, 0, 0, 1, 600, 255, 1),
  1043. (NULL, 179532, 429, -22.3061, -349.882, -4.07224, -2.02458, 0, 0, 0, 1, 600, 255, 1),
  1044. (NULL, 179532, 429, -156.299, -321.1, -4.14717, 1.25664, 0, 0, 0, 1, 600, 255, 1),
  1045. (NULL, 179532, 429, 31.0736, -681.584, -25.1616, 0, 0, 0, 0, 1, 600, 255, 1),
  1046. (NULL, 179532, 429, 36.7152, -467.008, -4.24876, 1.58825, 0, 0, 0, 1, 600, 255, 1),
  1047. (NULL, 179532, 429, -10.2151, -349.267, -53.8632, 2.05949, 0, 0, 0, 1, 600, 255, 1),
  1048. (NULL, 179532, 429, -51.4662, -358.168, -4.13823, 1.81514, 0, 0, 0, 1, 600, 255, 1),
  1049. (NULL, 179532, 429, 21.9326, -409.795, -58.6142, 0, 0, 0, 0, 1, 600, 255, 1),
  1050. (NULL, 179532, 429, 117.148, -408.461, -3.27357, 2.32129, 0, 0, 0, 1, 600, 255, 1),
  1051. (NULL, 179532, 429, 102.549, -246.011, -56.3647, 0.785397, 0, 0, 0, 1, 600, 255, 1),
  1052. (NULL, 179532, 429, 263.393, -568.436, -111.976, -2.67035, 0, 0, 0, 1, 600, 255, 1),
  1053. (NULL, 179532, 429, 477.125, 307.609, 2.85288, 1.74533, 0, 0, 0, 1, 600, 255, 1),
  1054. (NULL, 179532, 429, 423.649, -94.0369, -3.88739, -0.453785, 0, 0, 0, 1, 600, 255, 1),
  1055. (NULL, 179532, 429, 4.90084, -450.306, -58.6294, 0, 0, 0, 0, 1, 600, 255, 1),
  1056. (NULL, 179532, 429, 71.7209, -409.745, -4.21656, 3.12412, 0, 0, 0, 1, 600, 255, 1),
  1057. (NULL, 179532, 429, -27.7882, -388.435, -4.22943, 1.39626, 0, 0, 0, 1, 600, 255, 1),
  1058. (NULL, 179532, 429, -42.6484, -341.5, -52.6547, 0.244346, 0, 0, 0, 1, 600, 255, 1),
  1059. (NULL, 179532, 429, 34.9096, -365.079, -4.14052, 0.314158, 0, 0, 0, 1, 600, 255, 1),
  1060. (NULL, 179532, 429, -114.736, -199.653, -4.1244, 0, 0, 0, 0, 1, 600, 255, 1),
  1061. (NULL, 179532, 429, 101.961, -247.727, -4.01977, 2.84488, 0, 0, 0, 1, 600, 255, 1),
  1062. (NULL, 179532, 429, 126.702, -248.335, -4.14639, -2.72271, 0, 0, 0, 1, 600, 255, 1),
  1063. (NULL, 179532, 429, 66.2358, -633.758, -25.163, 3.05433, 0, 0, 0, 1, 600, 255, 1),
  1064. (NULL, 179532, 429, -6.16094, -433.403, -4.22212, 0, 0, 0, 0, 1, 600, 255, 1),
  1065. (NULL, 179532, 429, 2.64945, -210.379, -52.3845, -0.95993, 0, 0, 0, 1, 600, 255, 1),
  1066. (NULL, 179532, 429, -168.655, -271.912, -4.12082, -0.750491, 0, 0, 0, 1, 600, 255, 1),
  1067. (NULL, 179532, 429, 55.8777, -438.434, -58.5981, -0.855211, 0, 0, 0, 1, 600, 255, 1),
  1068. (NULL, 179532, 429, 59.0393, -760.028, -25.0955, -1.23918, 0, 0, 0, 1, 600, 255, 1),
  1069. (NULL, 179532, 429, 71.7946, -437.261, -58.5956, 0.872664, 0, 0, 0, 1, 600, 255, 1),
  1070. (NULL, 179532, 429, -28.3324, -385.063, -58.6181, 1.95477, 0, 0, 0, 1, 600, 255, 1),
  1071. (NULL, 179532, 429, 47.8125, -334.275, -52.0553, -0.506145, 0, 0, 0, 1, 600, 255, 1),
  1072. (NULL, 179532, 429, 353.105, -447.005, -90.0577, 0, 0, 0, 0, 1, 600, 255, 1),
  1073. (NULL, 179532, 429, 509.725, 523.927, -25.4027, -2.80997, 0, 0, 0, 1, 600, 255, 1),
  1074. (NULL, 179532, 429, 456.691, -47.364, -3.88702, -1.76278, 0, 0, 0, 1, 600, 255, 1),
  1075. (NULL, 179532, 429, 34.5069, -391.211, -58.6112, -2.16421, 0, 0, 0, 1, 600, 255, 1),
  1076. (NULL, 179532, 429, -12.3063, -396.872, -4.22113, -0.593412, 0, 0, 0, 1, 600, 255, 1),
  1077. (NULL, 179532, 429, 127.199, -272.801, -4.14639, -1.93732, 0, 0, 0, 1, 600, 255, 1),
  1078. (NULL, 179532, 429, -94.2365, -406.708, -58.6073, 0, 0, 0, 0, 1, 600, 255, 1),
  1079. (NULL, 179532, 429, -112.021, -258.887, -56.2501, 0, 0, 0, 0, 1, 600, 255, 1),
  1080. (NULL, 179532, 429, 134.767, -262.46, -4.14639, -0.488691, 0, 0, 0, 1, 600, 255, 1),
  1081. (NULL, 179532, 429, -148.661, -210.009, -4.1514, 0.418879, 0, 0, 0, 1, 600, 255, 1),
  1082. (NULL, 179532, 429, 32.7576, -775.236, -25.1416, -1.309, 0, 0, 0, 1, 600, 255, 1),
  1083. (NULL, 179532, 429, -109.888, -404.549, -4.21786, -2.07694, 0, 0, 0, 1, 600, 255, 1),
  1084. (NULL, 179532, 429, -61.5861, -306.311, -55.7067, 2.33874, 0, 0, 0, 1, 600, 255, 1),
  1085. (NULL, 179532, 429, -7.83484, -199.983, -4.12879, -0.453785, 0, 0, 0, 1, 600, 255, 1),
  1086. (NULL, 179532, 429, 64.8074, -400.448, -58.6044, -0.628317, 0, 0, 0, 1, 600, 255, 1),
  1087. (NULL, 179532, 429, 44.9141, -626.477, -25.1061, -2.47837, 0, 0, 0, 1, 600, 255, 1),
  1088. (NULL, 179532, 429, 66.1826, -315.416, -54.2518, 0, 0, 0, 0, 1, 600, 255, 1),
  1089. (NULL, 179532, 429, 242.178, -420.788, -119.962, -0.069812, 0, 0, 0, 1, 600, 255, 1),
  1090. (NULL, 179532, 429, 490.501, 551.961, -25.381, -0.418879, 0, 0, 0, 1, 600, 255, 1),
  1091. (NULL, 179532, 429, 468.448, 258.01, 6.34532, 1.02974, 0, 0, 0, 1, 600, 255, 1),
  1092. (NULL, 179532, 429, -5.54965, -393.198, -58.6137, -0.209439, 0, 0, 0, 1, 600, 255, 1),
  1093. (NULL, 179532, 429, -124.622, -234.072, -55.1133, -0.314158, 0, 0, 0, 1, 600, 255, 1),
  1094. (NULL, 179532, 429, 119.36, -336.64, -4.14986, -1.44862, 0, 0, 0, 1, 600, 255, 1),
  1095. (NULL, 179532, 429, -75.923, -358.893, -4.14481, 2.87979, 0, 0, 0, 1, 600, 255, 1),
  1096. (NULL, 179532, 429, 41.8712, -744.931, -25.1339, 0.104719, 0, 0, 0, 1, 600, 255, 1),
  1097. (NULL, 179532, 429, 36.7851, -402.629, -4.21849, -2.49582, 0, 0, 0, 1, 600, 255, 1),
  1098. (NULL, 179532, 429, -14.44, -309.911, -52.1458, 0, 0, 0, 0, 1, 600, 255, 1),
  1099. (NULL, 179532, 429, 126.758, -296.278, -4.14639, -1.95477, 0, 0, 0, 1, 600, 255, 1),
  1100. (NULL, 179532, 429, -32.8264, -463.171, -58.6176, 0.488691, 0, 0, 0, 1, 600, 255, 1),
  1101. (NULL, 179532, 429, 17.3334, -704.192, -12.6426, -2.19912, 0, 0, 0, 1, 600, 255, 1),
  1102. (NULL, 179532, 429, 50.4484, -241.885, -53.2931, 1.8675, 0, 0, 0, 1, 600, 255, 1),
  1103. (NULL, 179532, 429, 189.484, -482.115, -100.601, 1.93731, 0, 0, 0, 1, 600, 255, 1),
  1104. (NULL, 179532, 429, 423.59, 262.49, 11.1475, 0, 0, 0, 0, 1, 600, 255, 1),
  1105. (NULL, 179532, 429, 475.207, -104.252, -3.88595, -1.32645, 0, 0, 0, 1, 600, 255, 1),
  1106. (NULL, 179533, 429, -27.0036, -404.283, -58.614, 0.226892, 0, 0, 0, 1, 600, 255, 1),
  1107. (NULL, 179533, 429, -131.851, -319.414, -56.7906, 0.244346, 0, 0, 0, 1, 600, 255, 1),
  1108. (NULL, 179533, 429, -22.3061, -349.882, -4.07224, -2.02458, 0, 0, 0, 1, 600, 255, 1),
  1109. (NULL, 179533, 429, -156.299, -321.1, -4.14717, 1.25664, 0, 0, 0, 1, 600, 255, 1),
  1110. (NULL, 179533, 429, 31.0736, -681.584, -25.1616, 0, 0, 0, 0, 1, 600, 255, 1),
  1111. (NULL, 179533, 429, 36.7152, -467.008, -4.24876, 1.58825, 0, 0, 0, 1, 600, 255, 1),
  1112. (NULL, 179533, 429, -10.2151, -349.267, -53.8632, 2.05949, 0, 0, 0, 1, 600, 255, 1),
  1113. (NULL, 179533, 429, -51.4662, -358.168, -4.13823, 1.81514, 0, 0, 0, 1, 600, 255, 1),
  1114. (NULL, 179533, 429, 21.9326, -409.795, -58.6142, 0, 0, 0, 0, 1, 600, 255, 1),
  1115. (NULL, 179533, 429, 117.148, -408.461, -3.27357, 2.32129, 0, 0, 0, 1, 600, 255, 1),
  1116. (NULL, 179533, 429, 102.549, -246.011, -56.3647, 0.785397, 0, 0, 0, 1, 600, 255, 1),
  1117. (NULL, 179533, 429, 263.393, -568.436, -111.976, -2.67035, 0, 0, 0, 1, 600, 255, 1),
  1118. (NULL, 179533, 429, 477.125, 307.609, 2.85288, 1.74533, 0, 0, 0, 1, 600, 255, 1),
  1119. (NULL, 179533, 429, 423.649, -94.0369, -3.88739, -0.453785, 0, 0, 0, 1, 600, 255, 1),
  1120. (NULL, 179533, 429, 4.90084, -450.306, -58.6294, 0, 0, 0, 0, 1, 600, 255, 1),
  1121. (NULL, 179533, 429, 71.7209, -409.745, -4.21656, 3.12412, 0, 0, 0, 1, 600, 255, 1),
  1122. (NULL, 179533, 429, -27.7882, -388.435, -4.22943, 1.39626, 0, 0, 0, 1, 600, 255, 1),
  1123. (NULL, 179533, 429, -42.6484, -341.5, -52.6547, 0.244346, 0, 0, 0, 1, 600, 255, 1),
  1124. (NULL, 179533, 429, 34.9096, -365.079, -4.14052, 0.314158, 0, 0, 0, 1, 600, 255, 1),
  1125. (NULL, 179533, 429, -114.736, -199.653, -4.1244, 0, 0, 0, 0, 1, 600, 255, 1),
  1126. (NULL, 179533, 429, 101.961, -247.727, -4.01977, 2.84488, 0, 0, 0, 1, 600, 255, 1),
  1127. (NULL, 179533, 429, 126.702, -248.335, -4.14639, -2.72271, 0, 0, 0, 1, 600, 255, 1),
  1128. (NULL, 179533, 429, 66.2358, -633.758, -25.163, 3.05433, 0, 0, 0, 1, 600, 255, 1),
  1129. (NULL, 179533, 429, -6.16094, -433.403, -4.22212, 0, 0, 0, 0, 1, 600, 255, 1),
  1130. (NULL, 179533, 429, 2.64945, -210.379, -52.3845, -0.95993, 0, 0, 0, 1, 600, 255, 1),
  1131. (NULL, 179533, 429, -168.655, -271.912, -4.12082, -0.750491, 0, 0, 0, 1, 600, 255, 1),
  1132. (NULL, 179533, 429, 55.8777, -438.434, -58.5981, -0.855211, 0, 0, 0, 1, 600, 255, 1),
  1133. (NULL, 179533, 429, 59.0393, -760.028, -25.0955, -1.23918, 0, 0, 0, 1, 600, 255, 1),
  1134. (NULL, 179533, 429, 71.7946, -437.261, -58.5956, 0.872664, 0, 0, 0, 1, 600, 255, 1),
  1135. (NULL, 179533, 429, -28.3324, -385.063, -58.6181, 1.95477, 0, 0, 0, 1, 600, 255, 1),
  1136. (NULL, 179533, 429, 47.8125, -334.275, -52.0553, -0.506145, 0, 0, 0, 1, 600, 255, 1),
  1137. (NULL, 179533, 429, 353.105, -447.005, -90.0577, 0, 0, 0, 0, 1, 600, 255, 1),
  1138. (NULL, 179533, 429, 509.725, 523.927, -25.4027, -2.80997, 0, 0, 0, 1, 600, 255, 1),
  1139. (NULL, 179533, 429, 456.691, -47.364, -3.88702, -1.76278, 0, 0, 0, 1, 600, 255, 1),
  1140. (NULL, 179533, 429, 34.5069, -391.211, -58.6112, -2.16421, 0, 0, 0, 1, 600, 255, 1),
  1141. (NULL, 179533, 429, -12.3063, -396.872, -4.22113, -0.593412, 0, 0, 0, 1, 600, 255, 1),
  1142. (NULL, 179533, 429, 127.199, -272.801, -4.14639, -1.93732, 0, 0, 0, 1, 600, 255, 1),
  1143. (NULL, 179533, 429, -94.2365, -406.708, -58.6073, 0, 0, 0, 0, 1, 600, 255, 1),
  1144. (NULL, 179533, 429, -112.021, -258.887, -56.2501, 0, 0, 0, 0, 1, 600, 255, 1),
  1145. (NULL, 179533, 429, 134.767, -262.46, -4.14639, -0.488691, 0, 0, 0, 1, 600, 255, 1),
  1146. (NULL, 179533, 429, -148.661, -210.009, -4.1514, 0.418879, 0, 0, 0, 1, 600, 255, 1),
  1147. (NULL, 179533, 429, 32.7576, -775.236, -25.1416, -1.309, 0, 0, 0, 1, 600, 255, 1),
  1148. (NULL, 179533, 429, -109.888, -404.549, -4.21786, -2.07694, 0, 0, 0, 1, 600, 255, 1),
  1149. (NULL, 179533, 429, -61.5861, -306.311, -55.7067, 2.33874, 0, 0, 0, 1, 600, 255, 1),
  1150. (NULL, 179533, 429, -7.83484, -199.983, -4.12879, -0.453785, 0, 0, 0, 1, 600, 255, 1),
  1151. (NULL, 179533, 429, 64.8074, -400.448, -58.6044, -0.628317, 0, 0, 0, 1, 600, 255, 1),
  1152. (NULL, 179533, 429, 44.9141, -626.477, -25.1061, -2.47837, 0, 0, 0, 1, 600, 255, 1),
  1153. (NULL, 179533, 429, 66.1826, -315.416, -54.2518, 0, 0, 0, 0, 1, 600, 255, 1),
  1154. (NULL, 179533, 429, 242.178, -420.788, -119.962, -0.069812, 0, 0, 0, 1, 600, 255, 1),
  1155. (NULL, 179533, 429, 490.501, 551.961, -25.381, -0.418879, 0, 0, 0, 1, 600, 255, 1),
  1156. (NULL, 179533, 429, 468.448, 258.01, 6.34532, 1.02974, 0, 0, 0, 1, 600, 255, 1),
  1157. (NULL, 179533, 429, -5.54965, -393.198, -58.6137, -0.209439, 0, 0, 0, 1, 600, 255, 1),
  1158. (NULL, 179533, 429, -124.622, -234.072, -55.1133, -0.314158, 0, 0, 0, 1, 600, 255, 1),
  1159. (NULL, 179533, 429, 119.36, -336.64, -4.14986, -1.44862, 0, 0, 0, 1, 600, 255, 1),
  1160. (NULL, 179533, 429, -75.923, -358.893, -4.14481, 2.87979, 0, 0, 0, 1, 600, 255, 1),
  1161. (NULL, 179533, 429, 41.8712, -744.931, -25.1339, 0.104719, 0, 0, 0, 1, 600, 255, 1),
  1162. (NULL, 179533, 429, 36.7851, -402.629, -4.21849, -2.49582, 0, 0, 0, 1, 600, 255, 1),
  1163. (NULL, 179533, 429, -14.44, -309.911, -52.1458, 0, 0, 0, 0, 1, 600, 255, 1),
  1164. (NULL, 179533, 429, 126.758, -296.278, -4.14639, -1.95477, 0, 0, 0, 1, 600, 255, 1),
  1165. (NULL, 179533, 429, -32.8264, -463.171, -58.6176, 0.488691, 0, 0, 0, 1, 600, 255, 1),
  1166. (NULL, 179533, 429, 17.3334, -704.192, -12.6426, -2.19912, 0, 0, 0, 1, 600, 255, 1),
  1167. (NULL, 179533, 429, 50.4484, -241.885, -53.2931, 1.8675, 0, 0, 0, 1, 600, 255, 1),
  1168. (NULL, 179533, 429, 189.484, -482.115, -100.601, 1.93731, 0, 0, 0, 1, 600, 255, 1),
  1169. (NULL, 179533, 429, 423.59, 262.49, 11.1475, 0, 0, 0, 0, 1, 600, 255, 1),
  1170. (NULL, 179533, 429, 475.207, -104.252, -3.88595, -1.32645, 0, 0, 0, 1, 600, 255, 1);
  1171. UPDATE gameobject_template SET size = 1.48 WHERE entry = 177217;
  1172. UPDATE gameobject_template SET size = 0.465763 WHERE entry = 177221;
  1173. -- Captain Kromcrush
  1174. UPDATE creature_template SET ScriptName = "boss_captain_kromcrush", AIName = "", npcflag = 3 WHERE entry = 14325;
  1175. DELETE FROM script_texts WHERE entry BETWEEN -1500154 AND -1500150;
  1176. INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
  1177. (-1500150, 'Help me crush these punys!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, ''),
  1178. (-1500151, 'Hey, who Fengus callin'' a gnoll lover?! Take da prisoners to da king; you smart to bring them with their weapons and show da king that they a threat. I''ll go see if Fengus talk smack when I give him da beatdown! HAR!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, ''),
  1179. (-1500152, 'OK Fengus, where you at?! You come call me a gnoll lover while I give you da hammer upside da head!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, ''),
  1180. (-1500153, 'Captain Kromcrush begins to retaliate all attacks against him!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, ''),
  1181. (-1500154, 'No one get past me and threaten da king! Ungh, take it!!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, '14325');
  1182. DELETE FROM spell_target_position WHERE id = 22860;
  1183. INSERT INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
  1184. (22860, 429, 611.87, 481.84, 29.63, 3.06);
  1185. -- Ironbark
  1186. UPDATE creature_template SET ScriptName = "npc_ironbark_redeemed" WHERE entry IN(14241, 11491);
  1187. UPDATE creature_template SET faction_A = 35, faction_H = 35, npcflag = 1 WHERE entry = 14241;
  1188. DELETE FROM script_texts WHERE entry IN (-1500160, -1500161, -1500162);
  1189. INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
  1190. (-1500160, 'As you wish...', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  1191. (-1500161, 'My strength wanes, mortal. I have done as promised, the way is clear. I now return to whence I came.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, ''),
  1192. (-1500162, 'At last... Freed from his cursed grasp!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, '');
  1193. DELETE FROM script_waypoint WHERE entry = 14241;
  1194. INSERT INTO script_waypoint VALUES
  1195. (14241, 0, 14.34, -289.34, -52.24, 0, ''),
  1196. (14241, 1, 51.27, -270.40, -52.99, 0, ''),
  1197. (14241, 2, 126.74, -278.80, -55.88, 10000, ''),
  1198. (14241, 3, 51.27, -270.40, -52.99, 0, ''),
  1199. (14241, 4, 14.34, -289.34, -52.24, 0, ''),
  1200. (14241, 5, -56.59, -269.11, -57.86, 0, '');
  1201. -- Quest Knot
  1202. UPDATE quest_template set PrevQuestId = 5518 WHERE entry = 5519;
  1203. DELETE FROM creature_questrelation WHERE quest = 1318;
  1204. DELETE FROM creature_involvedrelation WHERE quest = 1318;
  1205. -- Gordok factions
  1206. UPDATE creature_template SET faction_A = 45, faction_H = 45 WHERE entry IN(11445, 11450, 14351, 11441, 11448, 11444, 11446);
  1207. --
  1208. DELETE FROM creature WHERE id IN(11480, 11483);
  1209. INSERT INTO `creature` (`guid`, `id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
  1210. (NULL, 11480, 429, 0, 0, 0.18435, 277.584, -8.35593, 3.03687, 7200, 0, 0, 7107, 9476, 0, 0),
  1211. (NULL, 11480, 429, 0, 0, 22.2903, 268.93, -7.75637, 5.61996, 7200, 0, 0, 7107, 9476, 0, 0),
  1212. (NULL, 11480, 429, 0, 0, 13.7393, 290.024, -8.81422, 1.43117, 7200, 0, 0, 7107, 9476, 0, 0),
  1213. (NULL, 11480, 429, 0, 0, 109.187, 432.731, 28.6844, 2.93215, 7200, 0, 0, 7107, 9476, 0, 0),
  1214. (NULL, 11480, 429, 0, 0, 116.239, 417.468, 28.6844, 4.41568, 7200, 0, 0, 7107, 9476, 0, 0),
  1215. (NULL, 11480, 429, 0, 0, 126.612, 440.825, 28.6844, 1.18682, 7200, 0, 0, 7107, 9476, 0, 0),
  1216. (NULL, 11480, 429, 0, 0, -79.4082, 437.517, 28.6859, 5.61996, 7200, 0, 0, 7107, 9476, 0, 0),
  1217. (NULL, 11480, 429, 0, 0, -86.4111, 454.612, 28.6864, 1.18682, 7200, 0, 0, 7107, 9476, 0, 0),
  1218. (NULL, 11480, 429, 0, 0, -98.4999, 429.365, 28.6854, 4.20624, 7200, 0, 0, 7107, 9476, 0, 0),
  1219. (NULL, 11480, 429, 0, 0, 78.1069, 724.323, -24.4956, 4.67748, 7200, 0, 0, 7107, 9476, 0, 0),
  1220. (NULL, 11480, 429, 0, 0, 89.8462, 745.194, -24.497, 0.715585, 7200, 0, 0, 7107, 9476, 0, 0),
  1221. (NULL, 11480, 429, 0, 0, 64.6404, 736.824, -24.497, 3.33358, 7200, 0, 0, 7107, 9476, 0, 0),
  1222. (NULL, 11480, 429, 0, 0, -154.641, 721.118, -24.4952, 4.64258, 7200, 0, 0, 7107, 9476, 0, 0),
  1223. (NULL, 11480, 429, 0, 0, -142.956, 743.886, -24.497, 0.715585, 7200, 0, 0, 7107, 9476, 0, 0),
  1224. (NULL, 11480, 429, 0, 0, -170.839, 735.324, -24.497, 3.14159, 7200, 0, 0, 7107, 9476, 0, 0),
  1225. (NULL, 11480, 429, 0, 0, 133.537, 434.405, 28.6844, 0.471239, 7200, 0, 0, 7107, 9476, 0, 0),
  1226. (NULL, 11483, 429, 0, 0, 4.51283, 268.919, -8.03384, 3.83972, 7200, 0, 0, 6681, 8964, 0, 0),
  1227. (NULL, 11483, 429, 0, 0, 13.3353, 265.504, -7.47873, 4.85202, 7200, 0, 0, 6681, 8964, 0, 0),
  1228. (NULL, 11483, 429, 0, 0, 24.4087, 277.987, -8.40844, 6.0912, 7200, 0, 0, 6681, 8964, 0, 0),
  1229. (NULL, 11483, 429, 0, 0, 22.2632, 286.032, -8.67728, 0.855211, 7200, 0, 0, 6681, 8964, 0, 0),
  1230. (NULL, 11483, 429, 0, 0, 4.86775, 286.17, -8.49644, 2.51327, 7200, 0, 0, 6681, 8964, 0, 0),
  1231. (NULL, 11483, 429, 0, 0, 116.572, 441.026, 28.6844, 1.90241, 7200, 0, 0, 6681, 8964, 0, 0),
  1232. (NULL, 11483, 429, 0, 0, 109.499, 423.1, 28.6844, 3.31613, 7200, 0, 0, 6681, 8964, 0, 0),
  1233. (NULL, 11483, 429, 0, 0, 126.092, 416.945, 28.6844, 4.99164, 7200, 0, 0, 6681, 8964, 0, 0),
  1234. (NULL, 11483, 429, 0, 0, 133.068, 423.411, 28.6844, 5.93412, 7200, 0, 0, 6681, 8964, 0, 0),
  1235. (NULL, 11483, 429, 0, 0, -86.7868, 430.229, 28.6855, 4.83456, 7200, 0, 0, 6681, 8964, 0, 0),
  1236. (NULL, 11483, 429, 0, 0, -79.6795, 447.35, 28.6859, 0.401426, 7200, 0, 0, 6681, 8964, 0, 0),
  1237. (NULL, 11483, 429, 0, 0, -97.6146, 454.302, 28.6873, 2.21657, 7200, 0, 0, 6681, 8964, 0, 0),
  1238. (NULL, 11483, 429, 0, 0, -104.249, 447.252, 28.6878, 2.75762, 7200, 0, 0, 6681, 8964, 0, 0),
  1239. (NULL, 11483, 429, 0, 0, -104.42, 436.883, 28.6865, 3.36848, 7200, 0, 0, 6681, 8964, 0, 0),
  1240. (NULL, 11483, 429, 0, 0, 87.2501, 727.643, -24.497, 5.16617, 7200, 0, 0, 6681, 8964, 0, 0),
  1241. (NULL, 11483, 429, 0, 0, 91.785, 737.786, -24.497, 0, 7200, 0, 0, 6681, 8964, 0, 0),
  1242. (NULL, 11483, 429, 0, 0, 78.097, 749.842, -24.497, 1.41372, 7200, 0, 0, 6681, 8964, 0, 0),
  1243. (NULL, 11483, 429, 0, 0, 68.7335, 747.766, -24.497, 2.33874, 7200, 0, 0, 6681, 8964, 0, 0),
  1244. (NULL, 11483, 429, 0, 0, 68.4746, 728.471, -24.4956, 3.9619, 7200, 0, 0, 6681, 8964, 0, 0),
  1245. (NULL, 11483, 429, 0, 0, -146.109, 724.521, -24.4951, 5.48033, 7200, 0, 0, 6681, 8964, 0, 0),
  1246. (NULL, 11483, 429, 0, 0, -140.277, 734.367, -24.4966, 6.07375, 7200, 0, 0, 6681, 8964, 0, 0),
  1247. (NULL, 11483, 429, 0, 0, -154.064, 748.169, -24.497, 1.50098, 7200, 0, 0, 6681, 8964, 0, 0),
  1248. (NULL, 11483, 429, 0, 0, -165.33, 746.258, -24.497, 2.19912, 7200, 0, 0, 6681, 8964, 0, 0),
  1249. (NULL, 11483, 429, 0, 0, -164.966, 724.302, -24.4968, 3.78736, 7200, 0, 0, 6681, 8964, 0, 0);
  1250. -- Dreadsteed quest
  1251. DELETE FROM creature WHERE id IN(14504, 14506, 14483);
  1252. -- Broken Trap
  1253. UPDATE quest_template SET SpecialFlags = 1 WHERE entry = 1193;
  1254. -- Somper Kreeg
  1255. UPDATE creature_template SET gossip_menu_id = 5721, npcflag = 7 WHERE entry = 14322;
  1256. DELETE FROM gossip_menu WHERE entry = 5721;
  1257. INSERT INTO `gossip_menu` (`entry`, `text_id`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`) VALUES
  1258. (5721, 6894, 0, 0, 0, 0, 0, 0);
  1259. DELETE FROM gossip_menu_option WHERE menu_id = 5721;
  1260. INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`) VALUES
  1261. (5721, 0, 1, 'What do you mean, buy?! I''m the king now... and it''s good to be the king!', 3, 1, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0);
  1262. DELETE FROM npc_vendor WHERE entry = 14322;
  1263. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`) VALUES
  1264. (14322, 9260, 6, 3600),
  1265. (14322, 18269, 0, 0),
  1266. (14322, 18284, 0, 0),
  1267. (14322, 18287, 0, 0),
  1268. (14322, 18288, 0, 0);
  1269. -- Extinguishing the Idol
  1270. DELETE FROM creature_involvedrelation WHERE quest = 3525;
  1271. DELETE FROM gameobject_involvedrelation WHERE quest = 3525;
  1272. INSERT INTO `gameobject_involvedrelation` (`id`, `quest`) VALUES
  1273. (152097, 3525);
  1274. UPDATE creature_template SET ScriptName = "npc_belnistrasz", npcflag = 3 WHERE entry = 8516;
  1275. DELETE FROM script_waypoint WHERE entry = 8516;
  1276. INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES
  1277. (8516, 1, 2600.49, 722.83, 54.91, 0, ''),
  1278. (8516, 2, 2575.11, 746.38, 54.74, 0, ''),
  1279. (8516, 3, 2556.99, 750.08, 54.00, 0, ''),
  1280. (8516, 4, 2526.12, 800.92, 44.55, 0, ''),
  1281. (8516, 5, 2495.28, 788.29, 39.45, 0, ''),
  1282. (8516, 6, 2487.60, 802.35, 42.98, 0, ''),
  1283. (8516, 7, 2486.73, 829.02, 43.80, 0, ''),
  1284. (8516, 8, 2506.81, 846.82, 47.58, 0, ''),
  1285. (8516, 9, 2549.92, 891.66, 47.81, 0, ''),
  1286. (8516, 10, 2546.34, 906.28, 46.37, 0, ''),
  1287. (8516, 11, 2517.24, 925.71, 46.59, 0, ''),
  1288. (8516, 12, 2541.47, 976.85, 53.43, 0, ''),
  1289. (8516, 13, 2561.12, 967.83, 50.90, 0, ''),
  1290. (8516, 14, 2578.61, 945.70, 53.31, 0, '');
  1291. DELETE FROM gameobject WHERE id = 152097;
  1292. INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  1293. (NULL, 152097, 129, 2581.21, 943.311, 53.6058, 2.21456, 0, 0, 0.894485, 0.447097, -250, 100, 1);
  1294. -- Gong Event
  1295. DELETE FROM scripted_event_id WHERE id = 3130;
  1296. INSERT INTO `scripted_event_id` (`id`, `ScriptName`) VALUES
  1297. (3130, 'event_go_gong_razorfen_downs');
  1298. UPDATE `creature_template` SET `ScriptName`='npc_tomb_creature' WHERE `entry` IN (7351,7349);
  1299. UPDATE `instance_template` SET `ScriptName`='instance_razorfen_downs' WHERE `map`=129;
  1300. UPDATE creature SET SpawnTimeSecs = 300 WHERE id = 8516;
  1301. -- Zul'farak 10082, 10081, 10080 not spawned
  1302. DELETE FROM creature_template_addon WHERE entry = 7785;
  1303. INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `b2_0_sheath`, `b2_1_flags`, `emote`, `moveflags`, `auras`) VALUES
  1304. (7785, 0, 0, 0, 0, 0, 0, '11087');
  1305. UPDATE gameobject_template SET ScriptName = "go_shallow_grave" WHERE entry = 128403;
  1306. DELETE FROM creature_movement_template WHERE entry IN(7789, 7787, 8876, 7788, 8877);
  1307. INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES
  1308. (7789, 1, 1884.87, 1228.62, 9.7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  1309. (7789, 2, 1887.53, 1263, 41.52, 0, 778900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  1310. INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES
  1311. (7787, 1, 1884.87, 1228.62, 9.7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  1312. (7787, 2, 1887.53, 1263, 41.52, 0, 778700, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  1313. INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES
  1314. (8876, 1, 1884.87, 1228.62, 9.7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  1315. (8876, 2, 1887.53, 1263, 41.52, 0, 887600, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  1316. INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES
  1317. (8877, 1, 1884.87, 1228.62, 9.7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  1318. (8877, 2, 1887.53, 1263, 41.52, 0, 887700, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  1319. INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES
  1320. (7788, 1, 1884.87, 1228.62, 9.7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  1321. (7788, 2, 1887.53, 1263, 41.52, 0, 778800, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  1322. DELETE FROM creature_movement_scripts WHERE id IN(778900,778700,887600,887700,778800);
  1323. INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `comments`) VALUES
  1324. ('778900', '0', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ''),
  1325. ('778700', '0', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ''),
  1326. ('887600', '0', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ''),
  1327. ('887700', '0', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ''),
  1328. ('778800', '0', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
  1329. UPDATE gameobject_template SET ScriptName = "go_troll_cage" WHERE entry IN(141070, 141071, 141072, 141073, 141074);
  1330. DELETE FROM script_texts WHERE entry IN(-1209000, -1209001, -1209002, -1209003);
  1331. INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
  1332. (-1209003, 'Placeholder 2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'Sergeant Bly SAY_2'),
  1333. (-1209002, 'Placeholder 1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'Sergeant Bly SAY_1'),
  1334. (-1209001, 'OK. Here I go.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'Weegli Blastfuse SAY_WEEGLI_OK_I_GO'),
  1335. (-1209000, 'Oh no! Here they come!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'Weegli Blastfuse SAY_WEEGLI_OHNO');
  1336. DELETE FROM event_scripts WHERE id = 2609;
  1337. -- Blackrock Spire
  1338. -- 9596, 10263, 9219, 9217, 9218, 10376 spawned should be rare
  1339. -- 9718, 10509, not spawned
  1340. DELETE FROM creature WHERE id IN(10584, 10601, 10602, 10268, 10264);
  1341. DELETE FROM gameobject WHERE id IN(175621, 175584, 175589);
  1342. INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  1343. (99791, 175621, 229, -14.4649, -378.24, 48.5308, 5.36282, 0, 0, 0.444111, -0.895972, 180, 0, 1),
  1344. (NULL, 175584, 229, -14.4649, -378.24, 48.5308, 5.36282, 0, 0, 0.444111, -0.895972, -180, 0, 1),
  1345. (NULL, 175589, 229, -14.4649, -378.24, 48.5308, 5.36282, 0, 0, 0.444111, -0.895972, 180, 0, 1);
  1346. -- Haunted Locus
  1347. DELETE FROM creature WHERE id = 16080;
  1348. DELETE FROM gameobject WHERE id = 300064;
  1349. INSERT INTO gameobject (guid,id,map,position_x,position_y,position_z,orientation,rotation0,rotation1,rotation2,rotation3,spawntimesecs,animprogress,state ) VALUES
  1350. (NULL, 300064, 289, -24.898, 141.242, 84.0468, 4.75205, 0, 0, 0.692947, -0.720988, 300, 0, 1),
  1351. (NULL, 300064, 429, 262.97, -442.55, -119.96, 4.75205, 0, 0, 0.692947, -0.720988, 300, 0, 1),
  1352. (NULL, 300064, 329, 3423.47, -3055.73, 136.581, 1.15192, 0, 0, 0.692947, -0.720988, 300, 0, 1),
  1353. (NULL, 300064, 229, -15.9034, -455.282, -18.6442, 1.15192, 0, 0, 0.692947, -0.720988, 300, 0, 1),
  1354. (NULL, 300064, 229, 44.7101, -536.049, 110.936, 1.15192, 0, 0, 0.692947, -0.720988, 300, 0, 1);
  1355. UPDATE gameobject_template SET ScriptName = "go_father_flame" WHERE entry = 175245;
  1356. -- Door
  1357. UPDATE gameobject SET state = 0, animprogress = 0 WHERE id = 175705;
  1358. -- Creature AI Scripts : 9736,
  1359. DELETE FROM scripted_event_id WHERE id = 4845;
  1360. INSERT INTO `scripted_event_id` (`id`, `ScriptName`) VALUES
  1361. (4845, 'event_go_challenge_to_urok');
  1362. DELETE FROM scripted_event_id WHERE id = 4884;
  1363. INSERT INTO `scripted_event_id` (`id`, `ScriptName`) VALUES
  1364. (4884, 'event_spell_emberseer_start');
  1365. DELETE FROM gameobject_template WHERE entry = 175622;
  1366. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `faction`, `flags`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `mingold`, `maxgold`, `ScriptName`) VALUES
  1367. ('175622', '5', '0', 'Rookery Whelp Spawner', '14', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
  1368. DELETE FROM spell_proc_event WHERE entry = 16468;
  1369. INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
  1370. (16468, 0, 0, 0, 262092, 0, 0, 10, 10);
  1371. DELETE FROM creature_ai_scripts WHERE creature_id IN(16048,16044,16045,16046,16047);
  1372. UPDATE creature_template SET ScriptName = "spell_dummy_npc", AIName = "" WHERE entry IN(16048,16044,16045,16046,16047);
  1373. DELETE FROM spell_script_target WHERE entry IN(27202,27184,27190,27191,27201,27203,15281,15746,13489);
  1374. INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
  1375. (27202, 1, 16048),
  1376. (27184, 1, 16044),
  1377. (27190, 1, 16045),
  1378. (27191, 1, 16046),
  1379. (27201, 1, 16047),
  1380. (27203, 1, 16048),
  1381. (27203, 1, 16044),
  1382. (27203, 1, 16045),
  1383. (27203, 1, 16046),
  1384. (27203, 1, 16047),
  1385. (15281, 1, 9816),
  1386. (15746, 0, 175124),
  1387. (13489, 1, 9156);
  1388. UPDATE creature_template SET ScriptName = "boss_mor_grayhoof" WHERE entry = 16080;
  1389. UPDATE creature_template SET ScriptName = "mob_rookery_hatcher" WHERE entry = 10683;
  1390. DELETE FROM creature_ai_scripts WHERE creature_id = 10316;
  1391. INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES
  1392. (1031601, 10316, 11, 0, 100, 2, 0, 0, 0, 0, 11, 15281, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Blackhand Incarcerator - Encage Emberseer on spawn'),
  1393. (1031602, 10316, 0, 0, 100, 3, 2000, 12100, 7900, 21900, 11, 15580, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Blackhand Incarcerator - Strike'),
  1394. (1031603, 10316, 0, 0, 100, 3, 10000, 20000, 30000, 35000, 11, 16045, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Blackhand Incarcerator - Encage'),
  1395. (1031604, 10316, 2, 0, 100, 2, 15, 0, 0, 0, 25, 0, 0, 0, 1, -47, 0, 0, 0, 0, 0, 0, 'Blackhand Incarcerator - Flee at 15% HP');
  1396. -- Blackrock Depth
  1397. -- 9547 : EAI
  1398. -- 9042, 9041 : rare spawned
  1399. -- 8923 : not spawned
  1400. -- Ribbly Screwspigot event
  1401. UPDATE creature_template SET resistance2 = 300 WHERE entry = 9156;
  1402. DELETE FROM creature_ai_scripts WHERE creature_id = 8982;
  1403. UPDATE creature_template SET ScriptName = "boss_moira_bronzebeard" WHERE entry = 10076;
  1404. UPDATE gameobject_template SET ScriptName = "go_relic_coffer_door" WHERE entry IN(174566, 174564, 174563, 174562, 174561, 174560, 174559, 174558, 174557, 174556, 174555, 174554);
  1405. UPDATE gameobject_template SET ScriptName = "go_dark_coffer" WHERE entry = 174565;
  1406. UPDATE gameobject_template SET ScriptName = "go_dark_keeper_portrait" WHERE entry IN(161456, 161457, 161458, 161459, 164818, 164819);
  1407. UPDATE creature_template SET ScriptName = "npc_ribbly_screwspigot" WHERE entry = 9543;
  1408. DELETE FROM gameobject WHERE id = 164911;
  1409. INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  1410. (NULL, 164911, 230, 914.763, -146.862, -49.7579, 3.64769, 0, 0, 0.968154, -0.250355, 43200, 100, 1),
  1411. (NULL, 164911, 230, 918.736, -153.958, -49.758, 3.71367, 0, 0, 0.959369, -0.282155, 43200, 100, 1),
  1412. (NULL, 164911, 230, 916.727, -150.147, -49.7584, 3.70111, 0, 0, 0.961123, -0.276121, 43200, 100, 1),
  1413. (NULL, 164911, 230, 915.073, -171.621, -49.7603, 2.2002, 0, 0, 0.891253, 0.453506, 43200, 100, 1),
  1414. (NULL, 164911, 230, 911.813, -173.995, -49.761, 2.2002, 0, 0, 0.891253, 0.453506, 43200, 100, 1);
  1415. UPDATE gameobject_template SET ScriptName = "go_thunderbrew_lagger_keg" WHERE entry = 164911;
  1416. DELETE FROM creature_ai_scripts WHERE creature_id = 9319;
  1417. INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES
  1418. (931901, 9319, 0, 0, 100, 1, 3000, 6000, 25000, 35000, 11, 13730, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Houndmaster Grebmar - Cast Demoralizing Shout'),
  1419. (931902, 9319, 0, 0, 100, 1, 6000, 9000, 6000, 9000, 11, 15615, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Houndmaster Grebmar - Cast Pummel'),
  1420. (931903, 9319, 16, 0, 100, 1, 21049, 10, 15000, 18000, 11, 21049, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Houndmaster Grebmar - Cast Bloodlust');
  1421. DELETE FROM creature_ai_scripts WHERE creature_id = 9554;
  1422. INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES
  1423. (955401, 9554, 4, 0, 100, 1, 0, 0, 0, 0, 39, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Hammered Patron - Call for help on aggro'),
  1424. (955402, 9554, 0, 0, 100, 1, 3000, 6000, 8000, 11000, 11, 6253, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Hammered Patron - Cast Backhand');
  1425. DELETE FROM creature_ai_scripts WHERE creature_id = 9537;
  1426. INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES
  1427. (953701, 9537, 4, 0, 100, 1, 0, 0, 0, 0, 39, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Hurley Blackbreath - Call for help on aggro'),
  1428. (953702, 9537, 0, 0, 100, 1, 3000, 6000, 8000, 12000, 11, 9573, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Hurley Blackbreath - Cast Flame Breath'),
  1429. (953703, 9537, 0, 0, 100, 1, 15000, 20000, 25000, 40000, 11, 14872, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Hurley Blackbreath - Cast Drunken Rage');
  1430. DELETE FROM creature_ai_scripts WHERE creature_id = 9541;
  1431. INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES
  1432. (954101, 9541, 0, 0, 100, 1, 3000, 6000, 25000, 35000, 11, 15583, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Blackbreath Crony - Cast Rupture'),
  1433. (954102, 9541, 0, 0, 100, 1, 6000, 9000, 6000, 9000, 11, 15581, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Blackbreath Crony - Cast Sinister Strike');
  1434. DELETE FROM creature_ai_scripts WHERE creature_id = 10043;
  1435. INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES
  1436. (1004301, 10043, 0, 0, 100, 1, 3000, 6000, 25000, 35000, 11, 15692, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Ribbly''s Crony - Cast Eviscerate'),
  1437. (1004302, 10043, 0, 0, 100, 1, 6000, 9000, 6000, 9000, 11, 15581, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Ribbly''s Crony - Cast Sinister Strike');
  1438. DELETE FROM creature_ai_scripts WHERE creature_id = 8894;
  1439. INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES
  1440. (889401, 8894, 14, 0, 100, 1, 1200, 40, 16000, 19000, 11, 15588, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Anvilrage Medic - Cast Heal'),
  1441. (889402, 8894, 0, 0, 100, 1, 2000, 8000, 8000, 12000, 11, 15587, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Anvilrage Medic - Cast Mind Blast'),
  1442. (889403, 8894, 14, 0, 100, 1, 2000, 40, 22000, 25000, 11, 15585, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Anvilrage Medic - Cast Prayer Of Healing'),
  1443. (889404, 8894, 16, 0, 100, 0, 13864, 8, 0, 0, 11, 13864, 6, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Anvilrage Medic - Cast Power Word: Fortitude'),
  1444. (889405, 8894, 2, 0, 100, 0, 15, 0, 0, 0, 25, 0, 0, 0, 1, -47, 0, 0, 0, 0, 0, 0, 'Anvilrage Medic - Flee at 15% HP');
  1445. DELETE FROM creature_ai_scripts WHERE creature_id = 9499;
  1446. INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES
  1447. (949901, 9499, 1, 0, 100, 0, 0, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Plugger Spazzring - Prevent Combat Movement on Spawn'),
  1448. (949902, 9499, 1, 0, 100, 1, 1000, 1000, 1800000, 1800000, 11, 13787, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Plugger Spazzring - Cast Demon Armor on Spawn'),
  1449. (949903, 9499, 4, 0, 100, 0, 0, 0, 0, 0, 11, 12739, 1, 0, 23, 1, 0, 0, 0, 0, 0, 0, 'Plugger Spazzring - Cast Shadow Bolt and Set Phase 1 on Aggro'),
  1450. (949904, 9499, 9, 5, 100, 1, 0, 40, 3300, 6100, 11, 12739, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Plugger Spazzring - Cast Shadow Bolt (Phase 1)'),
  1451. (949905, 9499, 9, 5, 100, 1, 0, 40, 18000, 22000, 11, 12742, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Plugger Spazzring - Cast Immolate (Phase 1)'),
  1452. (949906, 9499, 9, 5, 100, 1, 0, 40, 20000, 25000, 11, 8994, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Plugger Spazzring - Cast Banish (Phase 1)'),
  1453. (949907, 9499, 9, 5, 100, 1, 0, 40, 12000, 18000, 11, 13338, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Plugger Spazzring - Cast Curse of Tongues (Phase 1)'),
  1454. (949908, 9499, 3, 5, 100, 0, 15, 0, 0, 0, 21, 1, 0, 0, 23, 1, 0, 0, 0, 0, 0, 0, 'Plugger Spazzring - Start Combat Movement and Set Phase 2 when Mana is at 15% (Phase 1)'),
  1455. (949909, 9499, 9, 5, 100, 0, 35, 80, 0, 0, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Plugger Spazzring - Start Combat Movement at 35 Yards (Phase 1)'),
  1456. (949910, 9499, 9, 5, 100, 0, 5, 15, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Plugger Spazzring - Prevent Combat Movement at 15 Yards (Phase 1)'),
  1457. (949911, 9499, 9, 5, 100, 0, 0, 5, 0, 0, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Plugger Spazzring - Start Combat Movement Below 5 Yards'),
  1458. (949912, 9499, 3, 3, 100, 1, 100, 30, 100, 100, 23, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Plugger Spazzring - Set Phase 1 when Mana is above 30% (Phase 2)'),
  1459. (949913, 9499, 27, 0, 100, 1, 12544, 1, 15000, 30000, 11, 13787, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Plugger Spazzring - Cast Demon Armor on Missing Buff'),
  1460. (949914, 9499, 7, 0, 100, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Plugger Spazzring - Set Phase to 0 on Evade');
  1461. DELETE FROM creature_ai_scripts WHERE creature_id = 9547;
  1462. INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES
  1463. (954701, 9547, 1, 0, 100, 0, 0, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Guzzling Patron - Prevent Combat Movement on Spawn'),
  1464. (954702, 9547, 4, 0, 100, 0, 0, 0, 0, 0, 39, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Guzzling Patron - Random Aggro Say'),
  1465. (954703, 9547, 4, 0, 100, 0, 0, 0, 0, 0, 11, 20825, 1, 0, 23, 1, 0, 0, 0, 0, 0, 0, 'Guzzling Patron - Cast Shadow Bolt and Set Phase 1 on Aggro'),
  1466. (954704, 9547, 9, 5, 100, 1, 0, 40, 3300, 6100, 11, 20825, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Guzzling Patron - Cast Shadow Bolt (Phase 1)'),
  1467. (954705, 9547, 9, 5, 100, 1, 0, 40, 20000, 25000, 11, 14868, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Guzzling Patron - Cast Curse of Agony (Phase 1)'),
  1468. (954706, 9547, 3, 5, 100, 0, 15, 0, 0, 0, 21, 1, 0, 0, 23, 1, 0, 0, 0, 0, 0, 0, 'Guzzling Patron - Start Combat Movement and Set Phase 2 when Mana is at 15% (Phase 1)'),
  1469. (954707, 9547, 9, 5, 100, 0, 35, 80, 0, 0, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Guzzling Patron - Start Combat Movement at 35 Yards (Phase 1)'),
  1470. (954708, 9547, 9, 5, 100, 0, 5, 15, 0, 0, 21, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Guzzling Patron - Prevent Combat Movement at 15 Yards (Phase 1)'),
  1471. (954709, 9547, 9, 5, 100, 0, 0, 5, 0, 0, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Guzzling Patron - Start Combat Movement Below 5 Yards'),
  1472. (954710, 9547, 3, 3, 100, 1, 100, 30, 100, 100, 23, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Guzzling Patron - Set Phase 1 when Mana is above 30% (Phase 2)'),
  1473. (954711, 9547, 7, 0, 100, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Guzzling Patron - Set Phase to 0 on Evade');
  1474. UPDATE creature_template SET AIName = "EventAI" WHERE entry IN(9319, 9554, 9537, 9541, 10043, 8894, 9499, 9547);
  1475. -- Baron Geddon
  1476. UPDATE creature_template SET minmana = 0, maxmana = 0, mindmg = 1904, maxdmg = 2330, attackpower = 977 WHERE entry = 12056;
  1477. -- Golemagg
  1478. DELETE FROM spell_script_target WHERE entry = 20553;
  1479. INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
  1480. (20553, 1, 11672);
  1481. -- Majordomo
  1482. DELETE FROM spell_script_target WHERE entry = 20619;
  1483. INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
  1484. (20619, 1, 12018),
  1485. (20619, 1, 11664),
  1486. (20619, 1, 11663);
  1487. DELETE FROM spell_script_target WHERE entry = 21075;
  1488. INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
  1489. (21075, 1, 12018),
  1490. (21075, 1, 11664),
  1491. (21075, 1, 11663);
  1492. DELETE FROM spell_target_position WHERE id = 20618;
  1493. INSERT INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
  1494. (20618, 409, 736.29, -1176.52, -119.02, 0);
  1495. DELETE FROM gameobject WHERE id = 178164;
  1496. INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  1497. (NULL, 178164, 409, 736.663, -1176.57, -119.798, 3.14159, 0, 0, 1, 0, 600, 100, 1);
  1498. UPDATE gameobject_template SET ScriptName = "go_molten_core_rune" WHERE entry IN(176956,176957,176955,176953,176952,176954,176951);
  1499. -- Ragnaros
  1500. DELETE FROM gameobject WHERE id IN(178107, 178108);
  1501. INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  1502. (NULL, 178107, 409, 838.951, -830.383, -230.206, 0.837757, 0, 0, 0, 1, 604800, 100, 1),
  1503. (NULL, 178108, 409, 839.279, -831.058, -230.202, -1.37881, 0, 0, 0, 1, 604800, 100, 1);
  1504. UPDATE creature_template SET MovementType = 0 WHERE entry IN(11663, 11664, 12018, 11502);
  1505. -- Onyxia
  1506. UPDATE instance_template SET ScriptName = "instance_onyxias_lair" WHERE map = 249;
  1507. DELETE FROM gameobject_template WHERE entry = 176510;
  1508. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `faction`, `flags`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES
  1509. (176510, 5, 11686, 'Onyxia Whelp Spawner', 14, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
  1510. UPDATE creature_template SET minLevel = 60, maxLevel = 60 WHERE entry = 12999;
  1511. UPDATE creature_template SET flags_extra = 1 WHERE entry = 10184;
  1512. -- SPELL_BREATH_EAST_TO_WEST
  1513. DELETE FROM spell_target_position WHERE id IN (18576, 18578, 18579, 18580, 18581, 18582, 18583);
  1514. INSERT INTO spell_target_position VALUES (18576, 249, -37.743851, -243.667923, -88.217651, 1.416);
  1515. INSERT INTO spell_target_position VALUES (18578, 249, -35.805332, -232.028900, -87.749153, 1.416);
  1516. INSERT INTO spell_target_position VALUES (18579, 249, -34.045738, -224.714661, -85.529465, 1.416);
  1517. INSERT INTO spell_target_position VALUES (18580, 249, -32.081570, -214.916962, -88.327438, 1.416);
  1518. INSERT INTO spell_target_position VALUES (18581, 249, -36.611721, -202.684677, -85.653786, 1.416);
  1519. INSERT INTO spell_target_position VALUES (18582, 249, -37.067261, -195.758652, -87.745834, 1.416);
  1520. INSERT INTO spell_target_position VALUES (18583, 249, -37.728523, -188.616806, -88.074898, 1.416);
  1521. -- SPELL_BREATH_WEST_TO_EAST
  1522. DELETE FROM spell_target_position WHERE id IN (18609, 18611, 18612, 18613, 18614, 18615, 18616);
  1523. INSERT INTO spell_target_position VALUES (18609, 249, -37.728523, -188.616806, -88.074898, 4.526);
  1524. INSERT INTO spell_target_position VALUES (18611, 249, -37.067261, -195.758652, -87.745834, 4.526);
  1525. INSERT INTO spell_target_position VALUES (18612, 249, -36.611721, -202.684677, -85.653786, 4.526);
  1526. INSERT INTO spell_target_position VALUES (18613, 249, -32.081570, -214.916962, -88.327438, 4.526);
  1527. INSERT INTO spell_target_position VALUES (18614, 249, -34.045738, -224.714661, -85.529465, 4.526);
  1528. INSERT INTO spell_target_position VALUES (18615, 249, -35.805332, -232.028900, -87.749153, 4.526);
  1529. INSERT INTO spell_target_position VALUES (18616, 249, -37.743851, -243.667923, -88.217651, 4.526);
  1530. -- SPELL_BREATH_NW_TO_SE
  1531. DELETE FROM spell_target_position WHERE id IN (18584, 18585, 18586, 18587, 18588, 18589, 18590, 18591, 18592, 18593, 18594, 18595);
  1532. INSERT INTO spell_target_position VALUES (18584, 249, 6.016711, -181.305771, -85.654648, 3.776);
  1533. INSERT INTO spell_target_position VALUES (18585, 249, 3.860220, -183.227249, -86.375381, 3.776);
  1534. INSERT INTO spell_target_position VALUES (18586, 249, -2.529650, -188.690491, -87.172859, 3.776);
  1535. INSERT INTO spell_target_position VALUES (18587, 249, -8.449303, -193.957962, -87.564957, 3.776);
  1536. INSERT INTO spell_target_position VALUES (18588, 249, -14.321238, -199.462219, -87.922478, 3.776);
  1537. INSERT INTO spell_target_position VALUES (18589, 249, -15.602085, -216.893936, -88.403183, 3.776);
  1538. INSERT INTO spell_target_position VALUES (18590, 249, -23.650263, -221.969086, -89.172699, 3.776);
  1539. INSERT INTO spell_target_position VALUES (18591, 249, -29.495876, -213.014359, -88.910423, 3.776);
  1540. INSERT INTO spell_target_position VALUES (18592, 249, -35.439922, -217.260284, -87.336311, 3.776);
  1541. INSERT INTO spell_target_position VALUES (18593, 249, -41.762104, -221.896545, -86.114113, 3.776);
  1542. INSERT INTO spell_target_position VALUES (18594, 249, -51.067528, -228.909988, -85.765556, 3.776);
  1543. INSERT INTO spell_target_position VALUES (18595, 249, -56.559654, -241.223923, -85.423607, 3.776);
  1544. -- SPELL_BREATH_SE_TO_NW
  1545. DELETE FROM spell_target_position WHERE id IN (18564, 18565, 18566, 18567, 18568, 18569, 18570, 18571, 18572, 18573, 18574, 18575);
  1546. INSERT INTO spell_target_position VALUES (18564, 249, -56.559654, -241.223923, -85.423607, 0.666);
  1547. INSERT INTO spell_target_position VALUES (18565, 249, -51.067528, -228.909988, -85.765556, 0.666);
  1548. INSERT INTO spell_target_position VALUES (18566, 249, -41.762104, -221.896545, -86.114113, 0.666);
  1549. INSERT INTO spell_target_position VALUES (18567, 249, -35.439922, -217.260284, -87.336311, 0.666);
  1550. INSERT INTO spell_target_position VALUES (18568, 249, -29.495876, -213.014359, -88.910423, 0.666);
  1551. INSERT INTO spell_target_position VALUES (18569, 249, -23.650263, -221.969086, -89.172699, 0.666);
  1552. INSERT INTO spell_target_position VALUES (18570, 249, -15.602085, -216.893936, -88.403183, 0.666);
  1553. INSERT INTO spell_target_position VALUES (18571, 249, -14.321238, -199.462219, -87.922478, 0.666);
  1554. INSERT INTO spell_target_position VALUES (18572, 249, -8.449303, -193.957962, -87.564957, 0.666);
  1555. INSERT INTO spell_target_position VALUES (18573, 249, -2.529650, -188.690491, -87.172859, 0.666);
  1556. INSERT INTO spell_target_position VALUES (18574, 249, 3.860220, -183.227249, -86.375381, 0.666);
  1557. INSERT INTO spell_target_position VALUES (18575, 249, 6.016711, -181.305771, -85.654648, 0.666);
  1558. -- SPELL_BREATH_SW_TO_NE
  1559. DELETE FROM spell_target_position WHERE id IN (18596, 18597, 18598, 18599, 18600, 18601, 18602, 18603, 18604, 18605, 18606, 18607);
  1560. INSERT INTO spell_target_position VALUES (18596, 249, -58.250900, -189.020004, -85.292267, 5.587);
  1561. INSERT INTO spell_target_position VALUES (18597, 249, -52.006271, -193.796570, -85.808769, 5.587);
  1562. INSERT INTO spell_target_position VALUES (18598, 249, -46.135464, -198.548553, -85.901764, 5.587);
  1563. INSERT INTO spell_target_position VALUES (18599, 249, -40.500187, -203.001053, -85.555107, 5.587);
  1564. INSERT INTO spell_target_position VALUES (18600, 249, -30.907579, -211.058197, -88.592125, 5.587);
  1565. INSERT INTO spell_target_position VALUES (18601, 249, -20.098139, -218.681427, -88.937088, 5.587);
  1566. INSERT INTO spell_target_position VALUES (18602, 249, -12.223192, -224.666168, -87.856300, 5.587);
  1567. INSERT INTO spell_target_position VALUES (18603, 249, -6.475297, -229.098724, -87.076401, 5.587);
  1568. INSERT INTO spell_target_position VALUES (18604, 249, -2.010256, -232.541992, -86.995140, 5.587);
  1569. INSERT INTO spell_target_position VALUES (18605, 249, 2.736300, -236.202347, -86.790367, 5.587);
  1570. INSERT INTO spell_target_position VALUES (18606, 249, 7.197779, -239.642868, -86.307297, 5.587);
  1571. INSERT INTO spell_target_position VALUES (18607, 249, 12.120926, -243.439407, -85.874260, 5.587);
  1572. -- SPELL_BREATH_NE_TO_SW
  1573. DELETE FROM spell_target_position WHERE id IN (18617, 18619, 18620, 18621, 18622, 18623, 18624, 18625, 18626, 18627, 18628, 18618);
  1574. INSERT INTO spell_target_position VALUES (18617, 249, 12.120926, -243.439407, -85.874260, 2.428);
  1575. INSERT INTO spell_target_position VALUES (18619, 249, 7.197779, -239.642868, -86.307297, 2.428);
  1576. INSERT INTO spell_target_position VALUES (18620, 249, 2.736300, -236.202347, -86.790367, 2.428);
  1577. INSERT INTO spell_target_position VALUES (18621, 249, -2.010256, -232.541992, -86.995140, 2.428);
  1578. INSERT INTO spell_target_position VALUES (18622, 249, -6.475297, -229.098724, -87.076401, 2.428);
  1579. INSERT INTO spell_target_position VALUES (18623, 249, -12.223192, -224.666168, -87.856300, 2.428);
  1580. INSERT INTO spell_target_position VALUES (18624, 249, -20.098139, -218.681427, -88.937088, 2.428);
  1581. INSERT INTO spell_target_position VALUES (18625, 249, -30.907579, -211.058197, -88.592125, 2.428);
  1582. INSERT INTO spell_target_position VALUES (18626, 249, -40.500187, -203.001053, -85.555107, 2.428);
  1583. INSERT INTO spell_target_position VALUES (18627, 249, -46.135464, -198.548553, -85.901764, 2.428);
  1584. INSERT INTO spell_target_position VALUES (18628, 249, -52.006271, -193.796570, -85.808769, 2.428);
  1585. INSERT INTO spell_target_position VALUES (18618, 249, -58.250900, -189.020004, -85.292267, 2.428);
  1586.  
  1587. -- Below is not needed for current script
  1588. -- SPELL_BREATH_SOUTH_TO_NORTH
  1589. DELETE FROM spell_target_position WHERE id IN (18351, 18352, 18353, 18354, 18355, 18356, 18357, 18358, 18359, 18360, 18361);
  1590. INSERT INTO spell_target_position VALUES (18351, 249, -68.834236, -215.036163, -84.018875, 6.280);
  1591. INSERT INTO spell_target_position VALUES (18352, 249, -61.834255, -215.051910, -84.673416, 6.280);
  1592. INSERT INTO spell_target_position VALUES (18353, 249, -53.343277, -215.071014, -85.597191, 6.280);
  1593. INSERT INTO spell_target_position VALUES (18354, 249, -42.619305, -215.095139, -86.663605, 6.280);
  1594. INSERT INTO spell_target_position VALUES (18355, 249, -35.899323, -215.110245, -87.196548, 6.280);
  1595. INSERT INTO spell_target_position VALUES (18356, 249, -28.248341, -215.127457, -89.191750, 6.280);
  1596. INSERT INTO spell_target_position VALUES (18357, 249, -20.324360, -215.145279, -88.963997, 6.280);
  1597. INSERT INTO spell_target_position VALUES (18358, 249, -11.189384, -215.165833, -87.817093, 6.280);
  1598. INSERT INTO spell_target_position VALUES (18359, 249, -2.047405, -215.186386, -86.279655, 6.280);
  1599. INSERT INTO spell_target_position VALUES (18360, 249, 7.479571, -215.207809, -86.075531, 6.280);
  1600. INSERT INTO spell_target_position VALUES (18361, 249, 20.730539, -215.237610, -85.254387, 6.280);
  1601. -- SPELL_BREATH_NORTH_TO_SOUTH
  1602. DELETE FROM spell_target_position WHERE id IN (17086, 17087, 17088, 17089, 17090, 17091, 17092, 17093, 17094, 17095, 17097, 22267, 22268, 21132, 21133, 21135, 21136, 21137, 21138, 21139);
  1603. INSERT INTO spell_target_position VALUES (17086, 249, 20.730539, -215.237610, -85.254387, 3.142);
  1604. INSERT INTO spell_target_position VALUES (17087, 249, 7.479571, -215.207809, -86.075531, 3.142);
  1605. INSERT INTO spell_target_position VALUES (17088, 249, -2.047405, -215.186386, -86.279655, 3.142);
  1606. INSERT INTO spell_target_position VALUES (17089, 249, -11.189384, -215.165833, -87.817093, 3.142);
  1607. INSERT INTO spell_target_position VALUES (17090, 249, -20.324360, -215.145279, -88.963997, 3.142);
  1608. INSERT INTO spell_target_position VALUES (17091, 249, -28.248341, -215.127457, -89.191750, 3.142);
  1609. INSERT INTO spell_target_position VALUES (17092, 249, -35.899323, -215.110245, -87.196548, 3.142);
  1610. INSERT INTO spell_target_position VALUES (17093, 249, -42.619305, -215.095139, -86.663605, 3.142);
  1611. INSERT INTO spell_target_position VALUES (17094, 249, -53.343277, -215.071014, -85.597191, 3.142);
  1612. INSERT INTO spell_target_position VALUES (17095, 249, -61.834255, -215.051910, -84.673416, 3.142);
  1613. INSERT INTO spell_target_position VALUES (17097, 249, -68.834236, -215.036163, -84.018875, 3.142);
  1614. INSERT INTO spell_target_position VALUES (22267, 249, -75.736046, -214.984970, -83.394188, 3.142);
  1615. INSERT INTO spell_target_position VALUES (22268, 249, -84.087578, -214.857834, -82.640053, 3.142);
  1616. INSERT INTO spell_target_position VALUES (21132, 249, -90.424416, -214.601974, -82.482697, 3.142);
  1617. INSERT INTO spell_target_position VALUES (21133, 249, -96.572411, -214.353745, -82.239967, 3.142);
  1618. INSERT INTO spell_target_position VALUES (21135, 249, -102.069931, -214.131775, -80.571190, 3.142);
  1619. INSERT INTO spell_target_position VALUES (21136, 249, -107.385597, -213.917145, -77.447037, 3.142);
  1620. INSERT INTO spell_target_position VALUES (21137, 249, -114.281258, -213.866486, -73.851128, 3.142);
  1621. INSERT INTO spell_target_position VALUES (21138, 249, -123.328560, -213.607910, -71.559921, 3.142);
  1622. INSERT INTO spell_target_position VALUES (21139, 249, -130.788300, -213.424026, -70.751007, 3.142);
  1623.  
  1624. -- Sunken Temple
  1625. DELETE FROM creature WHERE id = 8580;
  1626. UPDATE quest_template SET SpecialFlags = 2 WHERE entry = 3447;
  1627. UPDATE gameobject_template SET ScriptName = "go_altar_of_hakkar" WHERE entry = 148836;
  1628. -- L'elixir de Videre
  1629. DELETE FROM event_scripts WHERE id = 3718;
  1630. INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`, `comments`) VALUES
  1631. (3718, 2, 11, 17428, 180000, 0, 0, 0, 0, 0, '');
  1632. -- Ahn Qiraj
  1633. DELETE FROM spell_target_position WHERE id = 23414;
  1634. INSERT INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
  1635. (23414, 409, 736.29, -1176.52, -119.02, 0);
  1636. UPDATE creature_template SET ScriptName = "boss_rajaxx" WHERE entry = 15341;
  1637. UPDATE creature_template SET ScriptName = "npc_lieutenant_general_andorov" WHERE entry = 15471;
  1638. DELETE FROM creature WHERE id = 15471;
  1639. INSERT INTO `creature` (`guid`, `id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
  1640. (NULL, 15471, 509, 0, 0, -8876.97, 1651.96, 21.57, 5.52, 6000, 0, 0, 17605, 37290, 0, 0);
  1641. DELETE FROM creature WHERE id = 15473;
  1642. INSERT INTO `creature` (`guid`, `id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
  1643. (NULL, 15473, 509, 0, 0, -8875.47, 1653.51, 21.57, 5.32, 6000, 0, 0, 9156, 0, 0, 0),
  1644. (NULL, 15473, 509, 0, 0, -8873.96, 1655.06, 21.57, 5.13, 6000, 0, 0, 9156, 0, 0, 0),
  1645. (NULL, 15473, 509, 0, 0, -8878.26, 1650.63, 21.57, 5.7, 6000, 0, 0, 9156, 0, 0, 0),
  1646. (NULL, 15473, 509, 0, 0, -8879.46, 1649.39, 21.57, 5.85, 6000, 0, 0, 9156, 0, 0, 0);
  1647. DELETE FROM `script_texts` WHERE entry BETWEEN -1509017 AND -1509003;
  1648. INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
  1649. (-1509017, 'Soon you will know the price of your meddling, mortals... The master is nearly whole... And when he rises, your world will be cease!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 6, 0, 0, 'rajaxx SAY_COMPLETE_QUEST'),
  1650. (-1509016, 'Breath your last!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8604, 6, 0, 0, 'rajaxx SAY_KILLS_ANDOROV'),
  1651. (-1509015, 'You are not worth my time $N!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8614, 6, 0, 0, 'rajaxx SAY_DEAGGRO'),
  1652. (-1509014, 'Warriors! Captains! Continue the fight!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8613, 6, 0, 0, 'rajaxx SAY_UNK4'),
  1653. (-1509013, 'Do not hesitate! Destroy them!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8606, 6, 0, 0, 'rajaxx SAY_UNK3'),
  1654. (-1509012, 'Crush them! Drive them out!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8605, 6, 0, 0, 'rajaxx SAY_UNK2'),
  1655. (-1509011, 'Attack and make them pay dearly!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8603, 6, 0, 0, 'rajaxx SAY_UNK1'),
  1656. (-1509010, 'Impudent fool! I will kill you myself!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8609, 6, 0, 0, 'rajaxx SAY_INTRO'),
  1657. (-1509009, 'Fandral! Your time has come! Go and hide in the Emerald Dream and pray we never find you!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8607, 6, 0, 0, 'rajaxx SAY_WAVE7'),
  1658. (-1509008, 'Staghelm will whimper and beg for his life, just as his whelp of a son did! One thousand years of injustice will end this day!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8611, 6, 0, 0, 'rajaxx SAY_WAVE6'),
  1659. (-1509007, 'Fear is for the enemy! Fear and death!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8608, 6, 0, 0, 'rajaxx SAY_WAVE5'),
  1660. (-1509006, 'No longer will we wait behind barred doors and walls of stone! No longer will our vengeance be denied! The dragons themselves will tremble before our wrath!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8610, 6, 0, 0, 'rajaxx SAY_WAVE4'),
  1661. (-1509005, 'The time of our retribution is at hand! Let darkness reign in the hearts of our enemies!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8612, 6, 0, 0, 'rajaxx SAY_WAVE3'),
  1662. (-1509004, 'Remember, Rajaxx, when I said I''d kill you last? I lied...', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 6, 0, 0, 'andorov SAY_ANDOROV_ATTACK'),
  1663. (-1509003, 'They come now. Try not to get yourself killed, young blood.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 6, 0, 0, 'andorov SAY_ANDOROV_INTRO');
  1664. DELETE FROM creature WHERE id IN(15385,15388,15386,15390,15389,15392,15391,15344,15387);
  1665. INSERT INTO `creature` (`guid`, `id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
  1666. (NULL, 15391, 509, 0, 0, -8998.71, 1550.72, 22.10, 0.0, 60000, 0, 0, 0, 0, 0, 0),
  1667. (NULL, 15344, 509, 0, 0, -9003.89, 1547.48, 21.56, 0.0, 60000, 0, 0, 0, 0, 0, 0),
  1668. (NULL, 15344, 509, 0, 0, -9008.93, 1553.30, 21.42, 0.0, 60000, 0, 0, 0, 0, 0, 0),
  1669. (NULL, 15387, 509, 0, 0, -9003.19, 1557.77, 21.87, 0.0, 60000, 0, 0, 0, 0, 0, 0),
  1670. (NULL, 15387, 509, 0, 0, -8994.86, 1554.47, 21.92, 0.0, 60000, 0, 0, 0, 0, 0, 0),
  1671. (NULL, 15387, 509, 0, 0, -8995.51, 1549.05, 21.99, 0.0, 60000, 0, 0, 0, 0, 0, 0),
  1672. (NULL, 15387, 509, 0, 0, -8995.59, 1544.71, 21.80, 0.0, 60000, 0, 0, 0, 0, 0, 0),
  1673. (NULL, 15392, 509, 0, 0, -9010.32, 1501.57, 21.54, 0.83, 60000, 0, 0, 0, 0, 0, 0),
  1674. (NULL, 15344, 509, 0, 0, -9013.89, 1498.09, 21.96, 0.83, 60000, 0, 0, 0, 0, 0, 0),
  1675. (NULL, 15344, 509, 0, 0, -9020.23, 1501.78, 21.69, 0.83, 60000, 0, 0, 0, 0, 0, 0),
  1676. (NULL, 15344, 509, 0, 0, -9014.20, 1507.43, 21.41, 0.83, 60000, 0, 0, 0, 0, 0, 0),
  1677. (NULL, 15387, 509, 0, 0, -9005.06, 1504.16, 21.39, 0.83, 60000, 0, 0, 0, 0, 0, 0),
  1678. (NULL, 15387, 509, 0, 0, -8999.57, 1498.87, 22.22, 0.83, 60000, 0, 0, 0, 0, 0, 0),
  1679. (NULL, 15387, 509, 0, 0, -9004.64, 1489.33, 22.81, 0.83, 60000, 0, 0, 0, 0, 0, 0),
  1680. (NULL, 15389, 509, 0, 0, -9018.54, 1599.89, 21.43, 5.65, 60000, 0, 0, 0, 0, 0, 0),
  1681. (NULL, 15344, 509, 0, 0, -9011.94, 1595.04, 21.38, 5.65, 60000, 0, 0, 0, 0, 0, 0),
  1682. (NULL, 15344, 509, 0, 0, -9015.04, 1590.55, 21.38, 5.65, 60000, 0, 0, 0, 0, 0, 0),
  1683. (NULL, 15344, 509, 0, 0, -9024.38, 1595.39, 21.38, 5.65, 60000, 0, 0, 0, 0, 0, 0),
  1684. (NULL, 15344, 509, 0, 0, -9017.74, 1606.75, 22.61, 5.65, 60000, 0, 0, 0, 0, 0, 0),
  1685. (NULL, 15344, 509, 0, 0, -9011.65, 1602.15, 22.52, 5.65, 60000, 0, 0, 0, 0, 0, 0),
  1686. (NULL, 15387, 509, 0, 0, -9009.95, 1595.34, 21.67, 5.65, 60000, 0, 0, 0, 0, 0, 0),
  1687. (NULL, 15390, 509, 0, 0, -9065.33, 1510.14, 21.39, 0.17, 60000, 0, 0, 0, 0, 0, 0),
  1688. (NULL, 15344, 509, 0, 0, -9060.05, 1511.55, 21.39, 0.17, 60000, 0, 0, 0, 0, 0, 0),
  1689. (NULL, 15344, 509, 0, 0, -9058.33, 1505.20, 21.46, 0.17, 60000, 0, 0, 0, 0, 0, 0),
  1690. (NULL, 15344, 509, 0, 0, -9066.88, 1500.96, 21.66, 0.17, 60000, 0, 0, 0, 0, 0, 0),
  1691. (NULL, 15387, 509, 0, 0, -9070.86, 1506.42, 21.41, 0.17, 60000, 0, 0, 0, 0, 0, 0),
  1692. (NULL, 15387, 509, 0, 0, -9069.50, 1514.89, 21.38, 0.17, 60000, 0, 0, 0, 0, 0, 0),
  1693. (NULL, 15387, 509, 0, 0, -9062.36, 1517.58, 21.38, 0.17, 60000, 0, 0, 0, 0, 0, 0),
  1694. (NULL, 15386, 509, 0, 0, -9043.43, 1642.71, 21.38, 5.67, 60000, 0, 0, 0, 0, 0, 0),
  1695. (NULL, 15344, 509, 0, 0, -9034.63, 1638.58, 22.29, 5.67, 60000, 0, 0, 0, 0, 0, 0),
  1696. (NULL, 15344, 509, 0, 0, -9038.85, 1635.12, 21.42, 5.67, 60000, 0, 0, 0, 0, 0, 0),
  1697. (NULL, 15344, 509, 0, 0, -9043.21, 1631.84, 21.38, 5.67, 60000, 0, 0, 0, 0, 0, 0),
  1698. (NULL, 15344, 509, 0, 0, -9047.27, 1640.38, 21.38, 5.67, 60000, 0, 0, 0, 0, 0, 0),
  1699. (NULL, 15387, 509, 0, 0, -9041.23, 1642.67, 21.50, 5.67, 60000, 0, 0, 0, 0, 0, 0),
  1700. (NULL, 15387, 509, 0, 0, -9039.25, 1647.99, 22.37, 5.67, 60000, 0, 0, 0, 0, 0, 0),
  1701. (NULL, 15388, 509, 0, 0, -9115.36, 1531.64, 21.39, 0.0, 60000, 0, 0, 0, 0, 0, 0),
  1702. (NULL, 15344, 509, 0, 0, -9107.74, 1531.53, 21.93, 0.0, 60000, 0, 0, 0, 0, 0, 0),
  1703. (NULL, 15344, 509, 0, 0, -9107.63, 1525.27, 21.40, 0.0, 60000, 0, 0, 0, 0, 0, 0),
  1704. (NULL, 15387, 509, 0, 0, -9116.94, 1523.61, 22.38, 0.0, 60000, 0, 0, 0, 0, 0, 0),
  1705. (NULL, 15387, 509, 0, 0, -9122.12, 1529.23, 22.71, 0.0, 60000, 0, 0, 0, 0, 0, 0),
  1706. (NULL, 15387, 509, 0, 0, -9117.28, 1536.62, 22.40, 0.0, 60000, 0, 0, 0, 0, 0, 0),
  1707. (NULL, 15387, 509, 0, 0, -9109.44, 1536.10, 21.93, 0.0, 60000, 0, 0, 0, 0, 0, 0),
  1708. (NULL, 15385, 509, 0, 0, -9076.32, 1601.77, 21.38, 0.0, 60000, 0, 0, 0, 0, 0, 0),
  1709. (NULL, 15344, 509, 0, 0, -9068.35, 1601.27, 21.38, 0.0, 60000, 0, 0, 0, 0, 0, 0),
  1710. (NULL, 15344, 509, 0, 0, -9068.83, 1593.59, 21.38, 0.0, 60000, 0, 0, 0, 0, 0, 0),
  1711. (NULL, 15344, 509, 0, 0, -9078.83, 1594.92, 21.38, 0.0, 60000, 0, 0, 0, 0, 0, 0),
  1712. (NULL, 15387, 509, 0, 0, -9081.43, 1606.36, 21.38, 0.0, 60000, 0, 0, 0, 0, 0, 0),
  1713. (NULL, 15387, 509, 0, 0, -9074.95, 1606.93, 21.38, 0.0, 60000, 0, 0, 0, 0, 0, 0),
  1714. (NULL, 15387, 509, 0, 0, -9066.34, 1602.52, 21.38, 0.0, 60000, 0, 0, 0, 0, 0, 0);
  1715. -- Blackwing Lair
  1716. UPDATE creature_template SET spell1 = 19873, spell2 = 19872, spell3 = 22425, spell4 = 0 WHERE entry = 12435;
  1717. UPDATE gameobject_template SET ScriptName = "go_back_dragon_egg" WHERE entry = 177807;
  1718. UPDATE gameobject_template SET ScriptName = "go_orb_of_domination" WHERE entry = 177808;
  1719. DELETE FROM script_texts WHERE entry IN(-1469022,-1469023,-1469024,-1469025,-1469026,-1469027,-1469028,-1469029,-1469030,-1000001,-1469003,-1000002,-1469000,-1469001,-1469004,-1469005,-1469006,-1469007,-1469008,-1469009,-1469010,-1469011,-1469012,-1469013,-1469014,-1469015,-1469016,-1469017,-1469018,-1469019,-1469020,-1469021);
  1720. INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
  1721. (-1000002, '%s goes into a frenzy!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, 0, 0, 'EMOTE_GENERIC_FRENZY'),
  1722. (-1000001, '%s goes into a killing frenzy!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, 0, 0, 'EMOTE_GENERIC_FRENZY_KILL'),
  1723. (-1469001, 'Clever Mortals but I am not so easily lured away from my sanctum!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8287, 1, 0, 0, 'broodlord SAY_LEASH'),
  1724. (-1469000, 'None of your kind should be here! You''ve doomed only yourselves!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8286, 1, 0, 0, 'broodlord SAY_AGGRO'),
  1725. (-1469025, 'If I fall into the abyss I''ll take all of you mortals with me...', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8278, 1, 0, 0, 'razorgore SAY_DEATH'),
  1726. (-1469024, 'No! Not another one! I''ll have your heads for this atrocity.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8277, 1, 0, 0, 'razorgore SAY_EGGS_BROKEN3'),
  1727. (-1469023, 'Fools! These eggs are more precious than you know.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8276, 1, 0, 0, 'razorgore SAY_EGGS_BROKEN2'),
  1728. (-1469022, 'You''ll pay for forcing me to do this.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8275, 1, 0, 0, 'razorgore SAY_EGGS_BROKEN1'),
  1729. (-1469030, 'Forgive me $N, your death only adds to my failure.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8284, 1, 0, 0, 'vaelastrasz SAY_KILLTARGET'),
  1730. (-1469029, 'Nefarius'' hate has made me stronger than ever before. You should have fled, while you could, mortals! The fury of Blackrock courses through my veins!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8285, 1, 0, 0, 'vaelastrasz SAY_HALFLIFE'),
  1731. (-1469028, 'FLAME! DEATH! DESTRUCTION! COWER MORTALS BEFORE THE WRATH OF LORD....NO! I MUST FIGHT THIS!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8283, 1, 0, 0, 'vaelastrasz SAY_LINE3'),
  1732. (-1469027, 'I beg you Mortals, flee! Flee before I lose all control. The Black Fire rages within my heart. I must release it!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8282, 1, 0, 0, 'vaelastrasz SAY_LINE2'),
  1733. (-1469026, 'Too late...friends. Nefarius'' corruption has taken hold. I cannot...control myself.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8281, 1, 0, 0, 'vaelastrasz SAY_LINE1'),
  1734. (-1469003, 'flinches as its skin shimmers.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, 0, 0, 'chromaggus EMOTE_SHIMMER'),
  1735. (-1469006, 'Ah, the heroes. You are persistent, aren''t you. Your allied attempted to match his power against mine, and had to pay the price. Now he shall serve me, by slaughtering you. Get up little red wyrm and destroy them!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8279, 1, 0, 0, 'victor_nefarius SAY_VAEL_INTRO'),
  1736. (-1469005, 'Let the games begin!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8280, 1, 0, 0, 'victor_nefarius SAY_GAMESBEGIN_2'),
  1737. (-1469004, 'In this world where time is your enemy, it is my greatest ally. This grand game of life that you think you play in fact plays you. To that I say...', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'victor_nefarius SAY_GAMESBEGIN_1'),
  1738. (-1469021, 'Rogues? Stop hiding and face me!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 'nefarian SAY_ROGUE'),
  1739. (-1469020, 'Hunters and your annoying pea-shooters!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 'nefarian SAY_HUNTER'),
  1740. (-1469019, 'Warlocks, you shouldn''t be playing with magic you don''t understand. See what happens?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 'nefarian SAY_WARLOCK'),
  1741. (-1469018, 'Shamans, show me what your totems can do!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 'nefarian SAY_SHAMAN'),
  1742. (-1469017, 'Paladins, I''ve heard you have many lives. Show me.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 'nefarian SAY_PALADIN'),
  1743. (-1469016, 'Priests! If you''re going to keep healing like that, we might as well make it a little more interesting!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 'nefarian SAY_PRIEST'),
  1744. (-1469015, 'Druids and your silly shapeshifting. Let''s see it in action!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 'nefarian SAY_DRUID'),
  1745. (-1469014, 'Warriors, I know you can hit harder than that! Let''s see it!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 'nefarian SAY_WARRIOR'),
  1746. (-1469013, 'Mages too? You should be more careful when you play with magic...', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 'nefarian SAY_MAGE'),
  1747. (-1469012, 'This cannot be! I am the Master here! You mortals are nothing to my kind! DO YOU HEAR? NOTHING!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8292, 1, 0, 0, 'nefarian SAY_DEATH'),
  1748. (-1469011, 'Worthless $N! Your friends will join you soon enough!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8293, 1, 0, 0, 'nefarian SAY_SLAY'),
  1749. (-1469010, 'Impossible! Rise my minions! Serve your master once more!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8291, 1, 0, 0, 'nefarian SAY_RAISE_SKELETONS'),
  1750. (-1469009, 'Burn, you wretches! Burn!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8290, 1, 0, 0, 'nefarian SAY_SHADOWFLAME'),
  1751. (-1469008, 'Enough! Now you vermin shall feel the force of my birthright, the fury of the earth itself.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8289, 1, 0, 0, 'nefarian SAY_XHEALTH'),
  1752. (-1469007, 'Well done, my minions. The mortals'' courage begins to wane! Now, let''s see how they contend with the true Lord of Blackrock Spire!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8288, 1, 0, 0, 'nefarian SAY_AGGRO');
  1753. UPDATE creature SET spawntimesecs = 30 WHERE id IN(14022, 14023, 14025, 14024);
  1754. UPDATE creature SET spawntimesecs = 1200 WHERE id = 12465;
  1755. DELETE FROM spell_script_target WHERE entry = 23168;
  1756. INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
  1757. (23168, 1, 14020);
  1758. -- Zul'gurub
  1759. DELETE FROM creature_template WHERE entry = 14967;
  1760. INSERT INTO `creature_template` (`entry`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `name`, `subname`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Civilian`, `RacialLeader`, `RegenHealth`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES
  1761. (14967, 0, 0, 15226, 0, 'High Priestess Mar''li Transform Visual', NULL, 0, 63, 63, 314480, 314480, 13100, 13100, 3795, 28, 28, 0, 1.32, 1.14286, 0, 3, 1460, 1785, 0, 749, 1, 2000, 0, 2, 32832, 0, 0, 0, 0, 0, 0, 600, 825, 100, 7, 76, 14510, 0, 0, 0, 0, 0, 0, 0, 0, 24099, 24300, 24109, 24110, 0, 327734, 400563, '', 1, 1, 0, 0, 1, 1453, 0, 0, 617299803, 1, 'boss_marli');
  1762. DELETE FROM creature_template WHERE entry = 14941;
  1763. INSERT INTO `creature_template` (`entry`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `name`, `subname`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Civilian`, `RacialLeader`, `RegenHealth`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES
  1764. (14941, 0, 0, 15191, 0, 'High Priestess Jeklik Transform Visual', NULL, 0, 63, 63, 330361, 330361, 26200, 26200, 0, 28, 28, 0, 1.32, 1.14286, 0, 3, 1225, 1505, 0, 630, 1, 2000, 0, 2, 32832, 0, 0, 0, 0, 0, 0, 640, 880, 100, 7, 76, 14517, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 333374, 407457, '', 1, 1, 0, 0, 1, 1297, 0, 0, 617299803, 1, 'boss_jeklik');
  1765. UPDATE gameobject_template SET data2 = 2 WHERE entry = 180125;
  1766. DELETE FROM creature_template WHERE entry = 14877;
  1767. INSERT INTO `creature_template` (`entry`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `name`, `subname`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Civilian`, `RacialLeader`, `RegenHealth`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES
  1768. (14877, 0, 0, 15102, 0, 'High Priest Venoxis Transform Visual', NULL, 0, 63, 63, 211822, 211822, 26200, 26200, 3795, 28, 28, 0, 1.32, 1.14286, 0, 3, 1460, 1785, 0, 749, 1, 2000, 0, 2, 32832, 0, 0, 0, 0, 0, 0, 620, 852.5, 100, 7, 76, 14507, 0, 0, 0, 0, 0, 0, 0, 0, 23858, 23859, 23860, 23895, 0, 342504, 418616, '', 1, 1, 0, 0, 1, 1852, 0, 0, 617299803, 1, 'boss_venoxis');
  1769. DELETE FROM spell_script_target WHERE entry = 24083;
  1770. INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
  1771. (24083, 0, 179985);
  1772. -- Silithus
  1773. DELETE FROM creature_template WHERE entry IN(15411, 15413, 15412);
  1774. INSERT INTO `creature_template` (`entry`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `name`, `subname`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Civilian`, `RacialLeader`, `RegenHealth`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES
  1775. (15411, 0, 0, 15413, 0, 'Arygos Dragon Form', NULL, 0, 63, 63, 384000, 384000, 78600, 78600, 3795, 14, 14, 2, 1.1, 1.14286, 0, 3, 3127, 3822, 0, 1604, 1, 1300, 1500, 0, 0, 0, 0, 0, 0, 0, 0, 220.81, 320.77, 100, 2, 0, 0, 0, 100001, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 1, 0, 0, 0, 617299803, 3, '');
  1776. INSERT INTO `creature_template` (`entry`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `name`, `subname`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Civilian`, `RacialLeader`, `RegenHealth`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES
  1777. (15413, 0, 0, 15412, 0, 'Merithra of the Dream Dragon Form', NULL, 0, 63, 63, 346200, 346200, 78600, 78600, 0, 14, 14, 2, 1.1, 1.14286, 0, 3, 1297, 1542, 0, 655, 1, 1300, 1500, 0, 0, 0, 0, 0, 0, 0, 0, 220.81, 320.77, 100, 2, 0, 0, 0, 100001, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 1, 0, 0, 0, 617299803, 3, '');
  1778. INSERT INTO `creature_template` (`entry`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `name`, `subname`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Civilian`, `RacialLeader`, `RegenHealth`, `equipment_id`, `trainer_id`, `vendor_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES
  1779. (15412, 0, 0, 15414, 0, 'Caelestrasz Dragon Form', NULL, 0, 63, 63, 365000, 365000, 78600, 78600, 0, 14, 14, 2, 1.1, 1.14286, 0, 3, 1403, 1599, 0, 693, 1, 1300, 1500, 0, 0, 0, 0, 0, 0, 0, 0, 220.81, 320.77, 100, 2, 0, 0, 0, 100001, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 0, 1, 0, 0, 0, 617299803, 3, '');
  1780. -- Idol of Hakkar
  1781. DELETE FROM gameobject WHERE id = 148838;
  1782. INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  1783. (NULL, 148838, 109, -497.789, 95.1423, -189.73, 0.306738, 0, 0, 0, 0, -43200, 0, 1);
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!