diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2020_02_17_01_world.sql | 71 |
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 |