DB/Creature: Add Naxxramas 25 difficulty spawns

1 files changed, 69 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_04_14_01_world.sql b/sql/updates/world/3.3.5/2019_04_14_01_world.sql
new file mode 100644
index 00000000000..63008e400d9
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_04_14_01_world.sql
@@ -0,0 +1,69 @@
+-- 
+UPDATE `creature` SET `spawnMask`=1 WHERE `guid` IN (128075,128084);
+UPDATE `creature_addon` SET `auras`=30110 WHERE `guid` IN (128177,128178,128179,128183);
+DELETE FROM `creature` WHERE `guid` IN (62030, 62031, 62032, 62033, 62034, 62035, 62036, 62037, 62038, 62039, 62040, 62041, 62228, 62242, 62244, 62273, 62743, 62744, 62745, 62746, 62747, 62748, 62749, 62750, 62751, 62752, 62753, 62754, 62755, 62756, 62757, 62758, 62759, 62760, 62761, 62762, 62763, 62764, 62765, 62766, 62767, 62768, 62769, 62770, 62771, 62772, 62773, 62774, 62775, 62776, 62777, 62778, 62779, 62780, 62781, 62782, 62783, 62784, 62785);
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`,`spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES
+(62030, 15975, 533, 2, 1, 0, 0, 3095.85, -3887.02, 267.593, 5.16572, 3600, 3, 0, 234594, 0, 1),
+(62031, 15974, 533, 2, 1, 0, 0, 3130.73, -3781.08, 273.947, 2.11204, 3600, 3, 0, 195495, 0, 1),
+(62032, 15974, 533, 2, 1, 0, 0, 3136.05, -3790.62, 273.945, 5.39422, 3600, 3, 0, 195495, 0, 1),
+(62033, 16017, 533, 2, 1, 0, 0, 3057.63, -3355.74, 298.318, 4.84215, 3600, 0, 0, 390990, 0, 0),
+(62034, 16017, 533, 2, 1, 0, 0, 3087.46, -3383.87, 298.318, 3.03101, 3600, 0, 0, 390990, 0, 0),
+(62035, 16018, 533, 2, 1, 0, 0, 3015.05, -3249.24, 294.064, 1.06451, 3600, 5, 0, 312792, 0, 1),
+(62036, 16017, 533, 2, 1, 0, 0, 3176.87, -3288.76, 294.613, 3.82912, 3600, 0, 0, 390990, 0, 0),
+(62037, 16017, 533, 2, 1, 0, 0, 3151.18, -3263.17, 294.557, 3.87467, 3600, 0, 0, 390990, 0, 0),
+(62038, 16018, 533, 2, 1, 0, 0, 3098.08, -3294.17, 294.513, 5.40384, 3600, 0, 0, 312792, 0, 0),
+(62039, 16018, 533, 2, 1, 0, 0, 3147.82, -3343.48, 294.51, 2.20334, 3600, 0, 0, 312792, 0, 0),
+(62040, 16018, 533, 2, 1, 0, 0, 2993.59, -3190.74, 294.064, 6.18138, 3600, 5, 0, 312792, 0, 1),
+(62041, 16020, 533, 2, 1, 0, 0, 3106.62, -3090.78, 294.076, 1.63392, 3600, 0, 0, 195495, 8162, 0),
+(62228, 16022, 533, 2, 1, 0, 0, 3108.89, -3089.7, 294.076, 2.55362, 3600, 0, 0, 88200, 19970, 0),
+(62242, 16020, 533, 2, 1, 0, 0, 3110.8, -3087.76, 294.077, 2.79317, 3600, 0, 0, 195495, 8162, 0),
+(62244, 16020, 533, 2, 1, 0, 0, 3023.93, -3146.8, 294.077, 1.45068, 3600, 0, 0, 195495, 8162, 0),
+(62273, 16022, 533, 2, 1, 0, 0, 3021.76, -3145.79, 294.078, 0.678631, 3600, 0, 0, 88200, 19970, 0),
+(62743, 16020, 533, 2, 1, 0, 0, 3029.79, -3135.51, 294.077, 3.95924, 3600, 0, 0, 195495, 8162, 0),
+(62744, 16020, 533, 2, 1, 0, 0, 2999.48, -3244.25, 294.064, 4.90094, 3600, 0, 0, 195495, 8162, 0),
+(62745, 16022, 533, 2, 1, 0, 0, 2997.56, -3245.05, 294.064, 5.446, 3600, 0, 0, 88200, 19970, 0),
+(62746, 16020, 533, 2, 1, 0, 0, 3005.48, -3251.53, 294.064, 2.44627, 3600, 0, 0, 195495, 8162, 0),
+(62747, 16025, 533, 2, 1, 0, 0, 3201.28, -3337.53, 292.595, 0.0107462, 3600, 0, 0, 539240, 0, 0),
+(62748, 15975, 533, 2, 1, 0, 0, 3074.66, -3555.23, 287.075, 4.38623, 3600, 3, 0, 234594, 0, 1),
+(62749, 15974, 533, 2, 1, 0, 0, 3060.29, -3538.29, 287.076, 3.34557, 3600, 3, 0, 195495, 0, 1),
+(62750, 15977, 533, 2, 1, 0, 0, 3090.58, -3572.9, 287.078, 4.64148, 3600, 3, 0, 65165, 0, 1),
+(62751, 15977, 533, 2, 1, 0, 0, 3102.77, -3580.94, 287.078, 5.65386, 3600, 3, 0, 65165, 0, 1),
+(62752, 15977, 533, 2, 1, 0, 0, 3117.38, -3487.72, 287.074, 1.55016, 3600, 3, 0, 65165, 0, 1),
+(62753, 15977, 533, 2, 1, 0, 0, 3109.68, -3484.55, 287.074, 2.66935, 3600, 3, 0, 65165, 0, 1),
+(62754, 15974, 533, 2, 1, 0, 0, 3158.04, -3544.16, 287.08, 0.29352, 3600, 3, 0, 195495, 0, 1),
+(62755, 15975, 533, 2, 1, 0, 0, 3158.86, -3525.38, 287.12, 1.11583, 3600, 3, 0, 234594, 0, 1),
+(62756, 15975, 533, 2, 1, 0, 0, 3172.64, -3472.76, 287.03, 2.25858, 3600, 3, 0, 234594, 0, 1),
+(62757, 15974, 533, 2, 1, 0, 0, 3189.55, -3483.31, 287.073, 5.91068, 3600, 3, 0, 195495, 0, 1),
+(62758, 15975, 533, 2, 1, 0, 0, 3160.08, -3644.04, 287.09, 0.907693, 3600, 0, 0, 234594, 0, 0),
+(62759, 15975, 533, 2, 1, 0, 0, 3176.79, -3647.41, 287.081, 1.56115, 3600, 0, 0, 234594, 0, 0),
+(62760, 15975, 533, 2, 1, 0, 0, 3202.5, -3586.17, 282.737, 3.88592, 3600, 0, 0, 234594, 0, 0),
+(62761, 15975, 533, 2, 1, 0, 0, 3210.6, -3597.22, 287.1, 4.12155, 3600, 0, 0, 234594, 0, 0),
+(62762, 15977, 533, 2, 1, 0, 0, 3293.95, -3706.6, 271.481, 0.630457, 3600, 0, 0, 65165, 0, 0),
+(62763, 15977, 533, 2, 1, 0, 0, 3306.74, -3700.85, 266.515, 0.838583, 3600, 0, 0, 65165, 0, 0),
+(62764, 15974, 533, 2, 1, 0, 0, 3090.93, -3881.53, 267.593, 6.24209, 3600, 3, 0, 195495, 0, 1),
+(62765, 15974, 533, 2, 1, 0, 0, 3303.5, -3890.77, 294.66, 5.27999, 3600, 3, 0, 195495, 0, 1),
+(62766, 15975, 533, 2, 1, 0, 0, 3301.06, -3880.95, 294.66, 3.70527, 3600, 3, 0, 234594, 0, 1),
+(62767, 15975, 533, 2, 1, 0, 0, 3399.68, -3837.23, 294.682, 0.222017, 3600, 3, 0, 234594, 0, 1),
+(62768, 15974, 533, 2, 1, 0, 0, 3408.49, -3816.95, 294.689, 4.47495, 3600, 3, 0, 195495, 0, 1),
+(62769, 15974, 533, 2, 1, 0, 0, 3460.21, -3744.45, 294.661, 3.14998, 3600, 3, 0, 195495, 0, 1),
+(62770, 15975, 533, 2, 1, 0, 0, 3456.8, -3733.01, 294.661, 4.19299, 3600, 3, 0, 234594, 0, 1),
+(62771, 15974, 533, 2, 1, 0, 0, 3459.31, -3523.3, 267.592, 4.02806, 3600, 3, 0, 195495, 0, 1),
+(62772, 15975, 533, 2, 1, 0, 0, 3449.77, -3520.5, 267.592, 5.03337, 3600, 3, 0, 234594, 0, 1),
+(62773, 16244, 533, 2, 1, 0, 0, 2934.23, -3512.93, 297.647, 1.84256, 3600, 0, 0, 390990, 0, 0),
+(62774, 16244, 533, 2, 1, 0, 0, 2875.62, -3549.17, 297.615, 0.475963, 3600, 0, 0, 390990, 0, 0),
+(62775, 16244, 533, 2, 1, 0, 0, 2897.68, -3480.89, 297.866, 3.6961, 3600, 0, 0, 390990, 0, 0),
+(62776, 16146, 533, 2, 1, 0, 1, 2897.7, -3320.73, 298.146, 3.0717, 3600, 0, 0, 312792, 0, 0),
+(62777, 16146, 533, 2, 1, 0, 1, 2842.4, -3128.89, 273.813, 1.41843, 3600, 0, 0, 312792, 0, 0),
+(62778, 16146, 533, 2, 1, 0, 1, 2849.48, -3121.01, 273.796, 3.59485, 3600, 0, 0, 312792, 0, 0),
+(62779, 16164, 533, 2, 1, 0, 0, 2781.04, -3267.39, 267.813, 2.43245, 3600, 0, 0, 234594, 0, 0),
+(62780, 16146, 533, 2, 1, 0, 1, 2793.1, -3392.52, 267.685, 2.40889, 3600, 0, 0, 312792, 0, 0),
+(62781, 16145, 533, 2, 1, 0, 1, 2787.12, -3399.17, 267.685, 2.40889, 3600, 0, 0, 390990, 0, 0),
+(62782, 16163, 533, 2, 1, 0, 1, 2907.67, -3166.58, 273.787, 3.09611, 3600, 0, 0, 390990, 20405, 0),
+(62783, 16163, 533, 2, 1, 0, 1, 2827.98, -3128.95, 273.824, 4.67476, 3600, 0, 0, 390990, 20405, 0),
+(62784, 16017, 533, 2, 1, 0, 0, 3108.83, -3284.13, 293.965, 5.42817, 3600, 0, 0, 390990, 0, 0),
+(62785, 16017, 533, 2, 1, 0, 0, 3157.82, -3332.81, 293.987, 2.29835, 3600, 0, 0, 390990, 0, 0);
+
+DELETE FROM `creature_formations` WHERE `leaderGUID` IN (127751,127753) AND `memberGUID` IN(62782,62783);
+INSERT `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
+(127751, 62783, 3, 270, 515, 2, 0),
+(127753, 62782, 3, 90, 515, 2, 0);