DB/Creature: Creeping Ooze & Creeping Oozeling

1 files changed, 98 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_04_14_05_world.sql b/sql/updates/world/3.3.5/2019_04_14_05_world.sql
new file mode 100644
index 00000000000..aa2216de34b
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_04_14_05_world.sql
@@ -0,0 +1,98 @@
+-- 
+DELETE FROM `creature` WHERE `guid` IN (62804, 62805, 62806, 62807, 62808, 62809, 62810, 62811, 62812, 62813, 62814, 62815, 62816, 62817, 62818, 62819, 62820, 62821, 62822, 62823, 62824, 62825, 62826, 62827, 62828, 62829, 62830, 62831, 62832, 62833);
+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
+(62804, 17356, 540, 3, 1, 0, 0, 164.527, 167.377, -42.3287, 5.64026, 7200, 5, 0, 19607, 0, 1),
+(62805, 17356, 540, 3, 1, 0, 0, 147.748, 180.457, -44.6035, 5.6756, 7200, 5, 0, 19607, 0, 1),
+(62806, 17356, 540, 3, 1, 0, 0, 192.355, 160.229, -42.3595, 2.96205, 7200, 5, 0, 19607, 0, 1),
+(62807, 17356, 540, 3, 1, 0, 0, 128.986, 198.313, -48.4405, 2.02743, 7200, 5, 0, 19607, 0, 1),
+(62808, 17356, 540, 3, 1, 0, 0, 123.383, 240.069, -45.6787, 4.69948, 7200, 5, 0, 19607, 0, 1),
+(62809, 17357, 540, 3, 1, 0, 0, 145.813, 183.696, -45.3024, 1.13286, 7200, 3, 0, 3380, 0, 1),
+(62810, 17357, 540, 3, 1, 0, 0, 147.923, 176.672, -44.2566, 2.80576, 7200, 3, 0, 3380, 0, 1),
+(62811, 17357, 540, 3, 1, 0, 0, 149.566, 182.556, -44.5859, 2.8089, 7200, 3, 0, 3380, 0, 1),
+(62812, 17357, 540, 3, 1, 0, 0, 161.157, 169.442, -42.5693, 2.23163, 7200, 3, 0, 3380, 0, 1),
+(62813, 17357, 540, 3, 1, 0, 0, 166.764, 166.645, -42.3317, 2.94242, 7200, 3, 0, 3380, 0, 1),
+(62814, 17357, 540, 3, 1, 0, 0, 169.641, 168.944, -42.0859, 2.87959, 7200, 3, 0, 3380, 0, 1),
+(62815, 17357, 540, 3, 1, 0, 0, 164.487, 172.445, -42.0653, 1.52478, 7200, 3, 0, 3380, 0, 1),
+(62816, 17357, 540, 3, 1, 0, 0, 161.756, 165.91, -42.3366, 2.67538, 7200, 3, 0, 3380, 0, 1),
+(62817, 17357, 540, 3, 1, 0, 0, 168.019, 163.597, -42.3366, 3.03667, 7200, 3, 0, 3380, 0, 1),
+(62818, 17357, 540, 3, 1, 0, 0, 187.192, 164.573, -42.3438, 2.64789, 7200, 3, 0, 3380, 0, 1),
+(62819, 17357, 540, 3, 1, 0, 0, 189.497, 159.973, -42.3528, 2.69502, 7200, 3, 0, 3380, 0, 1),
+(62820, 17357, 540, 3, 1, 0, 0, 198.036, 157.678, -42.2974, 2.75392, 7200, 0, 0, 3380, 0, 2),
+(62821, 17357, 540, 3, 1, 0, 0, 193.653, 164.139, -42.3619, 4.25796, 7200, 3, 0, 3380, 0, 1),
+(62822, 17357, 540, 3, 1, 0, 0, 193.572, 155.134, -42.3721, 1.92533, 7200, 3, 0, 3380, 0, 1),
+(62823, 17357, 540, 3, 1, 0, 0, 149.637, 186.838, -45.089, 4.10167, 7200, 0, 0, 3380, 0, 2),
+(62824, 17357, 540, 3, 1, 0, 0, 143.106, 179.351, -45.1497, 3.92495, 7200, 3, 0, 3380, 0, 1),
+(62825, 17357, 540, 3, 1, 0, 0, 133.347, 194.904, -48.2549, 2.18529, 7200, 0, 0, 3380, 0, 2),
+(62826, 17357, 540, 3, 1, 0, 0, 130.655, 199.467, -48.5642, 1.49022, 7200, 3, 0, 3380, 0, 1),
+(62827, 17357, 540, 3, 1, 0, 0, 135.268, 197.541, -48.3497, 4.08988, 7200, 3, 0, 3380, 0, 1),
+(62828, 17357, 540, 3, 1, 0, 0, 128.724, 193.428, -48.2922, 3.68148, 7200, 3, 0, 3380, 0, 1),
+(62829, 17357, 540, 3, 1, 0, 0, 124.871, 234.628, -46.3901, 1.22711, 7200, 3, 0, 3380, 0, 1),
+(62830, 17357, 540, 3, 1, 0, 0, 126.529, 239.262, -45.7962, 2.53401, 7200, 3, 0, 3380, 0, 1),
+(62831, 17357, 540, 3, 1, 0, 0, 119.878, 237.925, -45.9583, 6.02903, 7200, 3, 0, 3380, 0, 1),
+(62832, 17357, 540, 3, 1, 0, 0, 121.297, 245.288, -45.1604, 4.4818, 7200, 0, 0, 3380, 0, 2),
+(62833, 17357, 540, 3, 1, 0, 0, 122.714, 238.025, -45.7783, 4.98838, 7200, 3, 0, 3380, 0, 1);
+
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=17357;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=17357 AND `source_type`=0;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(17357,0,0,0,0,0,100,6,500,900,3800,6500,0,11,30494,0,0,0,0,0,2,0,0,0,0,0,0,0,"Creeping Oozeling - In Combat - Cast 'Sticky Ooze'");
+
+DELETE FROM `creature_addon` WHERE `guid` IN (62820,62823,62825,62832);
+INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES
+(62820, 628200),
+(62823, 628230),
+(62825, 628250),
+(62832, 628320);
+
+DELETE FROM `waypoint_data` WHERE `id` IN (628200, 628230, 628250, 628320);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `action_chance`) VALUES
+(628200, 1, 198.615, 157.614, -42.3834, 100),
+(628200, 2, 185.118, 155.313, -42.3426,100),
+(628200, 3, 176.564, 163.042, -42.338,100),
+(628200, 4, 167.383, 171.69, -41.9294,100),
+(628200, 5, 155.106, 170.074, -43.2278,100),
+(628200, 6, 146.471, 174.701, -44.2615,100),
+(628200, 7, 140.919, 183.822, -45.9111,100),
+(628200, 8, 151.716, 180.896, -44.171,100),
+(628200, 9, 158.101, 174.361, -43.1655,100),
+(628200, 10, 167.358, 164.408, -42.3366,100),
+(628200, 11, 178.187, 157.525, -42.3366,100),
+(628230, 1, 149.884, 187.102, -45.0783,100),
+(628230, 2, 142.166, 187.29, -46.2169,100),
+(628230, 3, 125.878, 194.369, -48.3731,100),
+(628230, 4, 125.729, 203.997, -48.6775,100),
+(628230, 5, 126.691, 217.359, -48.2435,100),
+(628230, 6, 120.192, 226.472, -47.3994,100),
+(628230, 7, 119.192, 218.702, -48.2062,100),
+(628230, 8, 122.088, 208.999, -48.9367,100),
+(628230, 9, 127.577, 197.247, -48.4326,100),
+(628230, 10, 132.913, 187.359, -47.2611,100),
+(628230, 11, 144.33, 175.906, -44.629,100),
+(628230, 12, 153.574, 168.431, -43.2902,100),
+(628230, 13, 166.266, 168.204, -42.2234,100),
+(628230, 14, 160.589, 176.802, -42.8859,100),
+(628250, 1, 133.602, 194.664, -48.1936,100),
+(628250, 2, 129.002, 203.274, -48.7373,100),
+(628250, 3, 128.128, 215.627, -48.611,100),
+(628250, 4, 130.512, 228.544, -47.1717,100),
+(628250, 5, 129.479, 238.716, -45.8807,100),
+(628250, 6, 124.789, 247.457, -45.1769,100),
+(628250, 7, 119.184, 243.505, -45.266,100),
+(628250, 8, 126.941, 233.355, -46.5612,100),
+(628250, 9, 119.879, 221.707, -47.8989,100),
+(628250, 10, 117.816, 207.412, -49.1574,100),
+(628250, 11, 127.834, 203.772, -48.7237,100),
+(628250, 12, 138.802, 196.532, -48.0115,100),
+(628320, 1, 121.371, 245.812, -45.1655,100),
+(628320, 2, 119.423, 231.379, -46.8037,100),
+(628320, 3, 122.247, 215.963, -48.3692,100),
+(628320, 4, 125.06, 201.835, -48.6219,100),
+(628320, 5, 131.31, 193.326, -48.2006,100),
+(628320, 6, 139.72, 185.85, -46.2863,100),
+(628320, 7, 148.625, 177.986, -44.2739,100),
+(628320, 8, 141.919, 185.946, -46.0242,100),
+(628320, 9, 137.237, 194.587, -47.8444,100),
+(628320, 10, 132.304, 204.593, -48.8844,100),
+(628320, 11, 128.145, 214.493, -48.7674,100),
+(628320, 12, 127.524, 226.089, -47.4134,100),
+(628320, 13, 127.665, 235.922, -46.2351,100);