DB/Creature: Longsnout

1 files changed, 12 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2018_10_09_07_world_335.sql b/sql/updates/world/3.3.5/2018_10_09_07_world_335.sql
new file mode 100644
index 00000000000..89c83c57518
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_10_09_07_world_335.sql
@@ -0,0 +1,12 @@
+-- 
+DELETE FROM `creature` WHERE `guid` BETWEEN 86814 AND 86822;
+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
+(86814, 119, 0, 1, 1, 0, 0, -9843.1, 651.014, 39.3611, 4.07857, 300, 5, 0, 0, 0, 1),
+(86815, 119, 0, 1, 1, 0, 0, -9785.64, 643.257, 35.1311, 4.80168, 300, 5, 0, 0, 0, 1),
+(86816, 119, 0, 1, 1, 0, 0, -9901.67, 667.235, 34.8295, 1.14046, 300, 5, 0, 0, 0, 1),
+(86817, 119, 0, 1, 1, 0, 0, -9952.16, 679.772, 31.2477, 6.24638, 300, 5, 0, 0, 0, 1),
+(86818, 119, 0, 1, 1, 0, 0, -9877.96, 690.876, 35.7078, 4.33007, 300, 5, 0, 0, 0, 1),
+(86819, 119, 0, 1, 1, 0, 0, -9844.819, 618.593, 40.1722, 3.05164, 300, 5, 0, 0, 0, 1),
+(86820, 119, 0, 1, 1, 0, 0, -9852.791, 692.708, 35.2851, 3.54315, 300, 5, 0, 0, 0, 1),
+(86821, 119, 0, 1, 1, 0, 0, -9987.842, 683.121, 31.7943, 5.18233, 300, 5, 0, 0, 0, 1),
+(86822, 119, 0, 1, 1, 0, 0, -9925.52, 668.817, 33.1967, 4.8634, 300, 5, 0, 0, 0, 1);