DB: Fix "The Maiden's Fancy" spawns

1 files changed, 18 insertions, 0 deletions

diff --git a/sql/updates/world/master/2018_06_24_00_world.sql b/sql/updates/world/master/2018_06_24_00_world.sql
new file mode 100644
index 00000000000..8ec5114f1f6
--- /dev/null
+++ b/sql/updates/world/master/2018_06_24_00_world.sql
@@ -0,0 +1,18 @@
+DELETE FROM `creature` WHERE `id` IN (25098,25096,25111,25097,25095,25094,25093,25089,25082,25078) AND `map`!=593;
+DELETE FROM `creature` WHERE `guid` IN (252246,252274);
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(252246, 25098, 593, 0, 0, 1, 169, 0, 0, 0, 12.02558, 10.74244, 6.469477, 3.209558, 120, 0, 0, 0, 0, 0, 0, 0, 0, 26365), 
+(252274, 25096, 593, 0, 0, 1, 169, 0, 0, 0, 18.07795, 0.47081, 12.1682, 3.162424, 120, 0, 0, 0, 0, 0, 0, 0, 0, 26365);
+
+SET @OGUID:=212121;
+DELETE FROM `gameobject` WHERE `guid` IN (200869,200887,216585,200861,200862,200863,200864,200865,200866,200867,200868,200888,200889,200890,200891,200892,200893,200894,200895,216591,216589,216588,216587,216586,216584,216583,216590);
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(200869,164766, 593, 0, 0, 1, 169, 0,11.014957, 3.468046,  6.098227, 4.918738, 0, 0, 0, 0, 120, 255, 1, 26365), 
+(200887,164765, 593, 0, 0, 1, 169, 0,11.207127, 0.436674,  6.098358, 1.676508, 0, 0, 0, 0, 120, 255, 1, 26365), 
+(200861,164761, 593, 0, 0, 1, 169, 0,12.461191, -2.160433, 6.098638, 0.749739, 0, 0, 0, 0, 120, 255, 1, 26365), 
+(200862,164762, 593, 0, 0, 1, 169, 0,14.479989, -0.220173, 6.098638, 4.020924, 0, 0, 0, 0, 120, 255, 1, 26365), 
+(200863,164759, 593, 0, 0, 1, 169, 0,16.790424, -1.003041, 6.098638, 0.859231, 0, 0, 0, 0, 120, 255, 1, 26365), 
+(200864,164764, 593, 0, 0, 1, 169, 0,18.923201, 0.897370,  6.097238, 4.040749, 0, 0, 0, 0, 120, 255, 1, 26365), 
+(200865,164760, 593, 0, 0, 1, 169, 0,39.210423, -2.831899, 6.092134, 2.615713, 0, 0, 0, 0, 120, 255, 1, 26365), 
+(200866,164763, 593, 0, 0, 1, 169, 0,6.0341630, 11.194729, 6.096959, 4.109780, 0, 0, 0, 0, 120, 255, 1, 26365), 
+(200867,164767, 593, 0, 0, 1, 169, 0,3.9419030, 9.328756,  6.097664, 0.795733, 0, 0, 0, 0, 120, 255, 1, 26365);