DB/Creature: Add some missing spawns in Sholazar Basin

1 files changed, 11 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2017_06_18_00_world .sql b/sql/updates/world/3.3.5/2017_06_18_00_world .sql
new file mode 100644
index 00000000000..b691583f3b3
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_06_18_00_world .sql
@@ -0,0 +1,11 @@
+-- 
+DELETE FROM `creature` WHERE `guid` IN (80410,80411,80413,80414,80416,80417,80420,80421,114575,114578,114584);
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(80410, 29124, 571, 0, 0, 1, 1, 0, 0, 5566.938, 4112.677, 40.348, 2.269064, 300, 5, 0, 0, 0, 1, 0, 0, 0, -1), 
+(80411, 29124, 571, 0, 0, 1, 1, 0, 0, 5594.8916, 3885.3424, -97.15444, 3.00348, 300, 5, 0, 0, 0, 1, 0, 0, 0, -1), 
+(80413, 28101, 571, 0, 0, 1, 1, 0, 0, 5606.3583, 3898.4746, -95.45957, 3.00348, 300, 5, 0, 0, 0, 1, 0, 0, 0, -1),
+(80414, 29124, 571, 0, 0, 1, 1, 0, 0, 5537.5039, 3966.5637, -40.84126, 0.04116, 300, 5, 0, 0, 0, 1, 0, 0, 0, -1),
+(80416, 29124, 571, 0, 0, 1, 1, 0, 0, 5594.546, 3808.950, -14.236, 1.580546, 300, 5, 0, 0, 0, 1, 0, 0, 0, -1),
+(80417, 29124, 571, 0, 0, 1, 1, 0, 0, 5623.9321, 3776.0725, -5.8515, 0.5161, 300, 5, 0, 0, 0, 1, 0, 0, 0, -1),
+(80420, 28108, 571, 0, 0, 1, 1, 0, 0, 5594.884, 3784.661, -106.930, 2.118348, 300, 0, 0, 0, 0, 0, 0, 0, 0, -1),
+(80421, 28113, 571, 0, 0, 1, 1, 0, 0, 5622.8334, 3875.159, -98.7706, 2.295847, 300, 0, 0, 0, 0, 0, 0, 0, 0, -1);