From f6ae286d600563e89db0c0e68656c0dcdfda3e14 Mon Sep 17 00:00:00 2001 From: Killyana Date: Sat, 31 Dec 2016 11:16:18 +0100 Subject: DB/Creature: Add missing spawns to Elune's Blessing and the Moonspray --- sql/updates/world/3.3.5/2016_12_30_17_world_335.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/3.3.5/2016_12_30_17_world_335.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2016_12_30_17_world_335.sql b/sql/updates/world/3.3.5/2016_12_30_17_world_335.sql new file mode 100644 index 00000000000..ca11c4d316c --- /dev/null +++ b/sql/updates/world/3.3.5/2016_12_30_17_world_335.sql @@ -0,0 +1,7 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (56954,56955,62014,77758); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(56954, 3681, 582, 1, 1, 29.50126, 0.000602, 24.44553, 0.03490658, 120, 0, 0), -- 3681 (Area: 452) +(56955, 24998, 582, 1, 1, 4.989703, -1.72901, 5.419243, 3.261605, 120, 0, 0), -- 24998 (Area: 452) +(62014, 3681, 586, 1, 1, -48.46594, 0.112139, 8.758898, 3.455752, 120, 0, 0), -- 3681 (Area: 452) +(77758, 25053, 586, 1, 1, -36.79112, -0.04812, 5.976357, 2.775074, 120, 0, 0); -- 25053 (Area: 452) -- cgit v1.2.3