DB: Update "The Maiden's Fancy" gameobjects with the correct rotation

1 files changed, 12 insertions, 0 deletions

diff --git a/sql/updates/world/master/2018_06_24_01_world.sql b/sql/updates/world/master/2018_06_24_01_world.sql
new file mode 100644
index 00000000000..cb2f6fd8c9d
--- /dev/null
+++ b/sql/updates/world/master/2018_06_24_01_world.sql
@@ -0,0 +1,12 @@
+-- 
+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,164760, 593, 0, 0, 1, 169, 0,18.34792, 0.59001, 6.063879, 0.2322455, 0, 0, -0.9304171, 0.3665025, 120, 255, 1, 26365), 
+(200887,164759, 593, 0, 0, 1, 169, 0,17.01325, -0.629518, 6.063879, 3.29529, 0, 0, 0.3296909, 0.9440889,  120, 255, 1, 26365), 
+(200861,164762, 593, 0, 0, 1, 169, 0,12.8419, -1.879445, 6.09668, 3.2952960, 0, 0, 0.3296909, 0.9440889,  120, 255, 1, 26365), 
+(200862,164765, 593, 0, 0, 1, 169, 0,5.511603, 10.92695, 6.099214, 0.232245, 0, 0, -0.9304171, 0.3665025, 120, 255, 1, 26365), 
+(200863,164767, 593, 0, 0, 1, 169, 0,39.21275, -2.40047, 6.098139, 5.302423, 0, 0, 0.9733791, 0.2292009,  120, 255, 1, 26365), 
+(200864,164761, 593, 0, 0, 1, 169, 0,14.22247, -0.64533, 6.09668, 0.2322455, 0, 0, -0.9304171, 0.3665025, 120, 255, 1, 26365), 
+(200865,164763, 593, 0, 0, 1, 169, 0,11.21061, 2.858814, 6.096821, 1.113635, 0, 0, -0.6851826, 0.7283714, 120, 255, 1, 26365), 
+(200866,164766, 593, 0, 0, 1, 169, 0,4.394278, 9.889936, 6.099214, 3.295296, 0, 0, 0.3296909, 0.9440889,  120, 255, 1, 26365), 
+(200867,164764, 593, 0, 0, 1, 169, 0,11.28877, 1.079107, 6.096821, 4.176688, 0, 0, 0.7009096, 0.7132501,  120, 255, 1, 26365);