From 4e5b7d8a0b8ea21ccfd06f37e5d7abe1d86e69df Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Mon, 5 Jun 2017 21:40:30 +0200
Subject: DB/Creature: Add some missing Beryl Mage Hunter

(cherry picked from commit 17c3374d1fabb8a22e5d28b7eea528e0d0b2974d)
---
 .../world/master/2020_07_17_01_world_2017_06_05_02_world.sql      | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 sql/updates/world/master/2020_07_17_01_world_2017_06_05_02_world.sql

(limited to 'sql/updates')

diff --git a/sql/updates/world/master/2020_07_17_01_world_2017_06_05_02_world.sql b/sql/updates/world/master/2020_07_17_01_world_2017_06_05_02_world.sql
new file mode 100644
index 00000000000..b58c1ecebe7
--- /dev/null
+++ b/sql/updates/world/master/2020_07_17_01_world_2017_06_05_02_world.sql
@@ -0,0 +1,8 @@
+--
+DELETE FROM `creature` WHERE `guid` IN (80379,80380,80382,80407,80408);
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(80379, 25585, 571, 0, 0, '0', 0, 0, 0, 0, 0, 3379.032, 6157.035, 79.831, 1.675516, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1),
+(80380, 25585, 571, 0, 0, '0', 0, 0, 0, 0, 0, 3442.108, 6205.982, 73.805, 1.675516, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1),
+(80382, 25585, 571, 0, 0, '0', 0, 0, 0, 0, 0, 3506.431, 6148.332, 66.530, 1.675516, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1),
+(80407, 25585, 571, 0, 0, '0', 0, 0, 0, 0, 0, 3490.342, 6110.152, 70.966, 1.675516, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1),
+(80408, 25585, 571, 0, 0, '0', 0, 0, 0, 0, 0, 3408.131, 6242.156, 75.513, 1.675516, 300, 10, 0, 1, 0, 1, 0, 0, 0, -1);
-- 
cgit v1.2.3