DB/GameObjects: Respawn Serpentshrine Cavern gameobjets properly

1 files changed, 71 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2020_02_17_01_world.sql b/sql/updates/world/3.3.5/2020_02_17_01_world.sql
new file mode 100644
index 00000000000..52888edb6e2
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_02_17_01_world.sql
@@ -0,0 +1,71 @@
+-- 
+DELETE FROM `gameobject` WHERE guid IN (14540,  13487,  47482,  47483,  47484,  47485,  16818,  29765,  29766,  29767,  29768,  29769,  29770,  29771,  29774, 4720, 4752, 9322, 9324, 9325, 9326, 9327, 9330, 9331, 9333, 9335, 9336, 9339, 9341, 9342, 9344, 9348, 9350, 9352, 9354, 9356, 9358, 9359, 9360, 9361, 9363, 9366, 9367, 9368, 9369, 9371, 9372, 9374);
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(4720, 184571, 548, 3607, 0, 1, 1, 141.5569, -353.0748, 29.93848, 0, -1, 0, 0, 0, 7200, 255, 1, 15595), -- 184571 (Area: 0 - Difficulty: 0)
+(4752, 183490, 548, 3607, 0, 1, 1, -59.13499, -98.79662, -52.93419, 3.141593, 0, 0, -1, 0, 7200, 255, 1, 15595), -- 0 (Area: 0 - Difficulty: 0)
+(9322, 184915, 548, 3607, 0, 1, 1, -45.51904, -244.8646, -39.93894, 0.5689191, 0.03683853, 0.007964134, 0.2805367, 0.959103, 7200, 255, 1, 15595), -- 184915 (Area: 0 - Difficulty: 0)
+(9324, 184569, 548, 3607, 0, 1, 1, -57.2842, -370.5138, 29.93848, 0, -1, 0, 0, 0, 7200, 255, 1, 15595), -- 184569 (Area: 0 - Difficulty: 0)
+(9325, 185051, 548, 3607, 0, 1, 1, 50.11681, -944.26, 44.2385, 0.7500172, 0, 0, 0.3662806, 0.9305044, 7200, 255, 1, 15595), -- 185051 (Area: 0 - Difficulty: 0)
+(9326, 184699, 548, 3607, 0, 1, 1, -266.8159, -359.0749, 10.32863, 4.507039, -0.1998358, 0.7089205, -0.242569, 0.6313935, 7200, 255, 1, 15595), -- 184699 (Area: 0 - Difficulty: 0)
+(9327, 184698, 548, 3607, 0, 1, 1, -213.7573, -374.0034, 6.425076, 1.55436, -0.6505156, -0.1883984, 0.6777172, 0.2864174, 7200, 255, 1, 15595), -- 184698 (Area: 0 - Difficulty: 0)
+(9330, 184921, 548, 3607, 0, 1, 1, 127.8488, -278.5111, -39.93894, 0.5689191, 0.03683853, 0.007964134, 0.2805367, 0.959103, 7200, 255, 1, 15595), -- 184921 (Area: 0 - Difficulty: 0)
+(9331, 185054, 548, 3607, 0, 1, 1, 9.143904, -944.26, 44.2385, 0.7500172, 0, 0, 0.3662806, 0.9305044, 7200, 255, 1, 15595), -- 185054 (Area: 0 - Difficulty: 0)
+(9333, 185053, 548, 3607, 0, 1, 1, 9.1439, -903.2713, 44.2385, 0.7500172, 0, 0, 0.3662806, 0.9305044, 7200, 255, 1, 15595), -- 185053 (Area: 0 - Difficulty: 0)
+(9335, 184920, 548, 3607, 0, 1, 1, -108.7091, -445.593, -39.93894, 0.5689191, 0.03683853, 0.007964134, 0.2805367, 0.959103, 7200, 255, 1, 15595), -- 184920 (Area: 0 - Difficulty: 0)
+(9336, 184204, 548, 3607, 0, 1, 1, 26.32847, -654.4946, 15.47422, 3.141593, 0, 0, -1, 0, 7200, 255, 1, 15595), -- 184204 (Area: 0 - Difficulty: 0) -- 
+(9339, 184917, 548, 3607, 0, 1, 1, -230.1264, -140.2151, -40.93506, 0.5689191, 0.03683853, 0.007964134, 0.2805367, 0.959103, 7200, 255, 1, 15595), -- 184917 (Area: 0 - Difficulty: 0)
+(9341, 184570, 548, 3607, 0, 1, 1, 42.01682, -304.0735, 29.93848, 0, -1, 0, 0, 0, 7200, 255, 1, 15595), -- 184570 (Area: 0 - Difficulty: 0)
+(9342, 183407, 548, 3607, 0, 1, 1, 50.0234, -0.00007662681, 820.2599, 3.141593, 0, 0, -1, 0, 7200, 255, 1, 15595), -- 0 (Area: 0 - Difficulty: 0)
+(9344, 184919, 548, 3607, 0, 1, 1, -229.7251, -445.593, -39.93894, 0.5689191, 0.03683853, 0.007964134, 0.2805367, 0.959103, 7200, 255, 1, 15595), -- 184919 (Area: 0 - Difficulty: 0)
+(9348, 184572, 548, 3607, 0, 1, 1, 141.557, -509.7885, 29.93848, 0, -1, 0, 0, 0, 7200, 255, 1, 15595), -- 184572 (Area: 0 - Difficulty: 0)
+(9350, 184205, 548, 3607, 0, 1, 1, 26.32847, -654.4946, 15.47422, 3.141593, 0, 0, -1, 0, 7200, 255, 1, 15595), -- 184205 (Area: 0 - Difficulty: 0) --
+(9352, 184573, 548, 3607, 0, 1, 1, 41.54227, -554.9265, 29.93848, 0, -1, 0, 0, 0, 7200, 255, 1, 15595), -- 184573 (Area: 0 - Difficulty: 0)
+(9354, 184918, 548, 3607, 0, 1, 1, -255.6166, -187.4016, -39.93894, 0.5689191, 0.03683853, 0.007964134, 0.2805367, 0.959103, 7200, 255, 1, 15595), -- 184918 (Area: 0 - Difficulty: 0)
+(9356, 184914, 548, 3607, 0, 1, 1, -108.7092, -265.369, -47.78902, 0.5689191, 0.03683853, 0.007964134, 0.2805367, 0.959103, 7200, 255, 1, 15595), -- 184914 (Area: 0 - Difficulty: 0)
+(9358, 184916, 548, 3607, 0, 1, 1, -193.6823, -140.2151, -40.93506, 0.5689191, 0.03683853, 0.007964134, 0.2805367, 0.959103, 7200, 255, 1, 15595), -- 184916 (Area: 0 - Difficulty: 0)
+(9359, 184203, 548, 3607, 0, 1, 1, 26.32847, -654.4946, 15.47422, 3.141593, 0, 0, -1, 0, 7200, 255, 1, 15595), -- 184203 (Area: 0 - Difficulty: 0)
+(9360, 184913, 548, 3607, 0, 1, 1, -148.1119, -296.5949, -39.93894, 0.5689191, 0.03683853, 0.007964134, 0.2805367, 0.959103, 7200, 255, 1, 15595), -- 184913 (Area: 0 - Difficulty: 0)
+(9361, 184568, 548, 3607, 0, 1, 1, 47.75674, -581.8289, 4.655592, 3.141593, 0, 0, -1, 0, 7200, 255, 1, 15595), -- 184568 (Area: 0 - Difficulty: 0) --
+(9363, 184574, 548, 3607, 0, 1, 1, -56.74874, -482.8741, 29.93848, 0, -1, 0, 0, 0, 7200, 255, 1, 15595), -- 184574 (Area: 0 - Difficulty: 0)
+(9366, 185052, 548, 3607, 0, 1, 1, 50.1168, -903.2713, 44.2385, 0.7500172, 0, 0, 0.3662806, 0.9305044, 7200, 255, 1, 15595), -- 185052 (Area: 0 - Difficulty: 0)
+(9367, 184697, 548, 3607, 0, 1, 1, -228.0119, -332.929, 40.45307, 4.363324, 0, 0, -0.8191519, 0.5735767, 7200, 255, 1, 15595), -- 184697 (Area: 0 - Difficulty: 0)
+(9368, 185117, 548, 3607, 0, 1, 1, -245.7294, -381.393, -0.187039, 2.879789, 0, 0, 0.9914446, 0.1305283, 7200, 255, 1, 15595), -- 185117 (Area: 0 - Difficulty: 0)
+(9369, 185118, 548, 3607, 0, 1, 1, 123.2582, -432.3567, -1.196554, 4.799657, 0, 0, -0.6755896, 0.7372779, 7200, 255, 1, 15595), -- 185118 (Area: 0 - Difficulty: 0)
+(9371, 185115, 548, 3607, 0, 1, 1, 373.1394, -465.1063, 30.71642, 3.228859, 0, 0, -0.9990482, 0.04361926, 7200, 255, 1, 15595), -- 185115 (Area: 0 - Difficulty: 0)
+(9372, 185474, 548, 3607, 0, 1, 1, 451.2623, -544.8354, -7.546607, 4.834563, 0, 0, -0.6626196, 0.7489561, 7200, 255, 1, 15595), -- 185474 (Area: 0 - Difficulty: 0)
+(9374, 185114, 548, 3607, 0, 1, 1, 457.4108, -555.2696, -6.996453, 1.832595, 0, 0, 0.7933531, 0.6087617, 7200, 255, 1, 15595); -- 185114 (Area: 0 - Difficulty: 0)
+
+DELETE FROM `gameobject_addon` WHERE guid IN (14540,  13487,  47482,  47483,  47484,  47485,  16818,  29765,  29766,  29767,  29768,  29769,  29770,  29771,  29774, 4720, 4752, 9322, 9324, 9325, 9326, 9327, 9330, 9331, 9333, 9335, 9336, 9339, 9341, 9342, 9344, 9348, 9350, 9352, 9354, 9356, 9358, 9359, 9360, 9361, 9363, 9366, 9367, 9368, 9369, 9371, 9372, 9374);
+INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`) VALUES
+(4720, 0, 0, 1, -0.00000004371139), -- 184571
+(4752, 0, 0, 1, -0.00000004371139), -- 0
+(9322, 0, 0, 1, -0.00000004371139), -- 184915
+(9324, 0, 0, 1, -0.00000004371139), -- 184569
+(9325, 0, 0, 1, -0.00000004371139), -- 185051
+(9326, 0, 0, 1, -0.00000004371139), -- 184699
+(9327, 0, 0, 1, -0.00000004371139), -- 184698
+(9330, 0, 0, 1, -0.00000004371139), -- 184921
+(9331, 0, 0, 1, -0.00000004371139), -- 185054
+(9333, 0, 0, 1, -0.00000004371139), -- 185053
+(9335, 0, 0, 1, -0.00000004371139), -- 184920
+(9336, 0, 0, 1, -0.00000004371139), -- 184204
+(9339, 0, 0, 1, -0.00000004371139), -- 184917
+(9341, 0, 0, 1, -0.00000004371139), -- 184570
+(9342, 0, 0, 1, -0.00000004371139), -- 0
+(9344, 0, 0, 1, -0.00000004371139), -- 184919
+(9348, 0, 0, 1, -0.00000004371139), -- 184572
+(9350, 0, 0, 1, -0.00000004371139), -- 184205
+(9352, 0, 0, 1, -0.00000004371139), -- 184573
+(9354, 0, 0, 1, -0.00000004371139), -- 184918
+(9356, 0, 0, 1, -0.00000004371139), -- 184914
+(9358, 0, 0, 1, -0.00000004371139), -- 184916
+(9359, 0, 0, 1, -0.00000004371139), -- 184203
+(9360, 0, 0, 1, -0.00000004371139), -- 184913
+(9361, 0, 0, 1, -0.00000004371139), -- 184568
+(9363, 0, 0, 1, -0.00000004371139), -- 184574
+(9366, 0, 0, 1, -0.00000004371139), -- 185052
+(9367, 0, 0, 1, -0.00000004371139), -- 184697
+(9368, 0, 0, 1, -0.00000004371139), -- 185117
+(9369, 0, 0, 1, -0.00000004371139), -- 185118
+(9371, 0, 0, 1, -0.00000004371139), -- 185115
+(9374, 0, 0, 1, -0.00000004371139); -- 185114