DB/Creature: Orgrimmar Grunt

phaseMask 64 for 3.3.5 only

1 files changed, 68 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_12_01_01_world_335.sql b/sql/updates/world/3.3.5/2019_12_01_01_world_335.sql
new file mode 100644
index 00000000000..2112a898f6d
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_12_01_01_world_335.sql
@@ -0,0 +1,68 @@
+-- 
+UPDATE `creature` SET `phaseMask`=1 WHERE `id`=3296;
+DELETE FROM `creature` WHERE `guid` IN (119403, 119404, 119407, 119408, 119409, 119410, 119411, 119412, 119413, 119414, 119415, 119429, 119430, 119431, 119432, 119433, 119434, 119436, 119437, 119438, 119439, 119440, 119441, 119442, 119443, 119444, 119447, 119451, 119452, 119455, 119456, 119460, 119461, 119462, 119465, 119466, 119468, 119469, 119474, 119475, 119476, 119485, 119486, 119487, 119488, 119489, 119490, 119491, 119492, 119493, 119494, 119495, 119496, 119497, 119498, 119499, 119500, 119501, 119502, 119503, 119535, 119542, 119550, 119554);
+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
+(119403, 31416, 1, 1, 64, 0, 1, 1620.45, -4252.84, 47.5273, 3.7001, 300, 0, 0, 16050, 0, 0),
+(119404, 31416, 1, 1, 64, 0, 1, 1552.41, -4324.75, 21.8029, 5.51524, 300, 0, 0, 16050, 0, 0),
+(119407, 31416, 1, 1, 64, 0, 1, 1628.89, -4274.76, 24.0855, 5.13127, 300, 0, 0, 16050, 0, 0),
+(119408, 31416, 1, 1, 64, 0, 1, 1889.53, -4485.08, 21.3103, 1.44862, 300, 0, 0, 16050, 0, 0),
+(119409, 31416, 1, 1, 64, 0, 1, 1952.53, -4368.57, 22.659, 3.68265, 300, 0, 0, 16050, 0, 0),
+(119410, 31416, 1, 1, 64, 0, 1, 1817.08, -4357.14, -9.81641, 2.30383, 300, 0, 0, 16050, 0, 0),
+(119411, 31416, 1, 1, 64, 0, 1, 1921.7, -4375.67, 22.5724, 5.84685, 300, 0, 0, 16050, 0, 0),
+(119412, 31416, 1, 1, 64, 0, 1, 1741.42, -4217.94, 44.3144, 3.38795, 300, 5, 0, 16050, 0, 1),
+(119413, 31416, 1, 1, 64, 0, 1, 1845.49, -4395.95, 5.19264, 3.80482, 300, 0, 0, 16050, 0, 0),
+(119414, 31416, 1, 1, 64, 0, 1, 1672.28, -4473.2, 20.1537, 1.44862, 300, 0, 0, 16050, 0, 0),
+(119415, 31416, 1, 1, 64, 0, 1, 1953.01, -4431.15, 25.1469, 3.31613, 300, 0, 0, 16050, 0, 0),
+(119429, 31416, 1, 1, 64, 0, 1, 1523.92, -4429.44, 16.7349, 0.506145, 300, 0, 0, 16050, 0, 0),
+(119430, 31416, 1, 1, 64, 0, 1, 1688.53, -4474.58, 20.1537, 1.95477, 300, 0, 0, 16050, 0, 0),
+(119431, 31416, 1, 1, 64, 0, 1, 1896.44, -4603.17, 33.8937, 3.75642, 300, 0, 0, 16050, 0, 0),
+(119432, 31416, 1, 1, 64, 0, 1, 1751.45, -4208.82, 42.7326, 5.34071, 300, 0, 0, 16050, 0, 0),
+(119433, 31416, 1, 1, 64, 0, 1, 1906.25, -4564.21, 33.9758, 0.628319, 300, 0, 0, 16050, 0, 0),
+(119434, 31416, 1, 1, 64, 0, 1, 2015.69, -4719.41, 24.5092, 2.53025, 300, 5, 0, 16050, 0, 1),
+(119436, 31416, 1, 1, 64, 0, 1, 1629.47, -4400.14, 13.8212, 0.107557, 300, 0, 0, 16050, 0, 0),
+(119437, 31416, 1, 1, 64, 0, 1, 2126.41, -4738.09, 50.4491, 2.74017, 300, 0, 0, 16050, 0, 0),
+(119438, 31416, 1, 1, 64, 0, 1, 1416.9, -4365.66, 25.2354, 3.25185, 300, 5, 0, 16050, 0, 1),
+(119439, 31416, 1, 1, 64, 0, 1, 1518.15, -4425.35, 18.7986, 1.27409, 300, 0, 0, 16050, 0, 0),
+(119440, 31416, 1, 1, 64, 0, 1, 1950.89, -4374.69, 22.043, 2.70526, 300, 0, 0, 16050, 0, 0),
+(119441, 31416, 1, 1, 64, 0, 1, 1929.52, -4300.46, 24.1794, 4.6942, 300, 0, 0, 16050, 0, 0),
+(119442, 31416, 1, 1, 64, 0, 1, 1596.65, -4388.67, 9.98323, 5.98648, 300, 0, 0, 16050, 0, 0),
+(119443, 31416, 1, 1, 64, 0, 1, 1668.56, -4323.66, 61.3295, 5.96903, 300, 0, 0, 16050, 0, 0),
+(119444, 31416, 1, 1, 64, 0, 1, 1690.52, -4262.62, 53.7757, 2.61799, 300, 0, 0, 16050, 0, 0),
+(119447, 31416, 1, 1, 64, 0, 1, 1775.07, -4319.91, -7.87855, 5.60251, 300, 0, 0, 16050, 0, 0),
+(119451, 31416, 1, 1, 64, 0, 1, 1759.03, -4301.89, 7.01614, 5.46288, 300, 0, 0, 16050, 0, 0),
+(119452, 31416, 1, 1, 64, 0, 1, 1603.48, -4449.95, 8.1165, 2.3911, 300, 0, 0, 16050, 0, 0),
+(119455, 31416, 1, 1, 64, 0, 1, 1902.63, -4628.79, 33.9763, 0.593412, 300, 0, 0, 16050, 0, 0),
+(119456, 31416, 1, 1, 64, 0, 1, 1615.63, -4376.11, 12.4018, 4.24115, 300, 0, 0, 16050, 0, 0),
+(119460, 31416, 1, 1, 64, 0, 1, 1479.39, -4406.25, 25.3187, 0.017453, 300, 0, 0, 16050, 0, 0),
+(119461, 31416, 1, 1, 64, 0, 1, 1387.28, -4379.89, 27.0983, 3.29867, 300, 0, 0, 16050, 0, 0),
+(119462, 31416, 1, 1, 64, 0, 1, 1886.46, -4415.86, 11.7157, 3.76991, 300, 0, 0, 16050, 0, 0),
+(119465, 31416, 1, 1, 64, 0, 1, 1673.2, -4250, 51.8765, 5.044, 300, 0, 0, 16050, 0, 0),
+(119466, 31416, 1, 1, 64, 0, 1, 1623.15, -4279.64, 22.5694, 6.16101, 300, 0, 0, 16050, 0, 0),
+(119468, 31416, 1, 1, 64, 0, 1, 1537.41, -4380.75, 16.7599, 3.42085, 300, 0, 0, 16050, 0, 0),
+(119469, 31416, 1, 1, 64, 0, 1, 1923.98, -4447.8, 44.9684, 0.715585, 300, 0, 0, 16050, 0, 0),
+(119474, 31416, 1, 1, 64, 0, 1, 2079.58, -4710.36, 38.8957, 6.0586, 300, 5, 0, 16050, 0, 1),
+(119475, 31416, 1, 1, 64, 0, 1, 1481.77, -4427.79, 25.3187, 0.191986, 300, 0, 0, 16050, 0, 0),
+(119476, 31416, 1, 1, 64, 0, 1, 1689.99, -4279.85, 32.1304, 4.11898, 300, 0, 0, 16050, 0, 0),
+(119485, 31416, 1, 1, 64, 0, 1, 1557.74, -4364.25, 1.07971, 0.226893, 300, 0, 0, 16050, 0, 0),
+(119486, 31416, 1, 1, 64, 0, 1, 1900.53, -4481.11, 20.727, 3.35369, 300, 0, 0, 16050, 0, 0),
+(119487, 31416, 1, 1, 64, 0, 1, 1561.79, -4360.5, 1.19455, 4.85202, 300, 0, 0, 16050, 0, 0),
+(119488, 31416, 1, 1, 64, 0, 1, 2096.59, -4668.5, 44.7122, 4.66795, 300, 5, 0, 16050, 0, 1),
+(119489, 31416, 1, 1, 64, 0, 1, 1696.02, -4463.71, 20.1522, 2.3911, 300, 0, 0, 16050, 0, 0),
+(119490, 31416, 1, 1, 64, 0, 1, 1572.83, -4318.32, 21.7125, 0.590477, 300, 5, 0, 16050, 0, 1),
+(119491, 31416, 1, 1, 64, 0, 1, 1384.62, -4358.56, 27.0983, 3.38594, 300, 0, 0, 16050, 0, 0),
+(119492, 31416, 1, 1, 64, 0, 1, 2131.15, -4729.88, 50.4302, 2.60054, 300, 0, 0, 16050, 0, 0),
+(119493, 31416, 1, 1, 64, 0, 1, 1748.53, -4260.13, 27.0722, 2.33874, 300, 0, 0, 16050, 0, 0),
+(119494, 31416, 1, 1, 64, 0, 1, 1928.32, -4424.41, 23.7505, 0.558505, 300, 0, 0, 16050, 0, 0),
+(119495, 31416, 1, 1, 64, 0, 1, 1920.62, -4365.93, 22.804, 0.296706, 300, 0, 0, 16050, 0, 0),
+(119496, 31416, 1, 1, 64, 0, 1, 1566.22, -4194.07, 42.6709, 0.15708, 300, 0, 0, 16050, 0, 0),
+(119497, 31416, 1, 1, 64, 0, 1, 1576.2, -4394.43, 6.55505, 4.57276, 300, 0, 0, 16050, 0, 0),
+(119498, 31416, 1, 1, 64, 0, 1, 1902.14, -4275.21, 31.7987, 4.17134, 300, 0, 0, 16050, 0, 0),
+(119499, 31416, 1, 1, 64, 0, 1, 1879.63, -4526.83, 26.4142, 3.65011, 300, 0, 0, 16050, 0, 0),
+(119500, 31416, 1, 1, 64, 0, 1, 1762.71, -4496.99, 44.6195, 2.13173, 300, 5, 0, 16050, 0, 1),
+(119501, 31416, 1, 1, 64, 0, 1, 1913.71, -4559.36, 33.9759, 3.71755, 300, 0, 0, 16050, 0, 0),
+(119502, 31416, 1, 1, 64, 0, 1, 1882.15, -4483.99, 20.6388, 2.09439, 300, 0, 0, 16050, 0, 0),
+(119503, 31416, 1, 1, 64, 0, 1, 1910.24, -4623.92, 33.9762, 3.735, 300, 0, 0, 16050, 0, 0),
+(119535, 31416, 1, 1, 64, 0, 1, 1963.01, -4730.91, 48.9608, 2.49582, 300, 0, 0, 16050, 0, 0),
+(119542, 31416, 1, 1, 64, 0, 1, 2004.18, -4719.8, 26.2996, 0.959931, 300, 0, 0, 16050, 0, 0),
+(119550, 31416, 1, 1, 64, 0, 1, 1886.2, -4546.68, 28.5148, 1.09956, 300, 0, 0, 16050, 0, 0),
+(119554, 31416, 1, 1, 64, 0, 1, 1829.26, -4507.27, 21.4564, 4.95674, 300, 0, 0, 16050, 0, 0);