DB/Misc: Spawn several missing gameobjects and creatures in The Eye

- Several pack of mobs and triggers spawned
- Spawned doors at Kael's room
- Corrected spawn coords for Kael'thas and his advisors from sniffs
- Removed improper spawns of Ember of Alar

1 files changed, 95 insertions, 0 deletions

diff --git a/sql/updates/world/2015_07_06_00_world.sql b/sql/updates/world/2015_07_06_00_world.sql
new file mode 100644
index 00000000000..cfb6d75b954
--- /dev/null
+++ b/sql/updates/world/2015_07_06_00_world.sql
@@ -0,0 +1,95 @@
+SET @OGUID := 29829;
+SeT @CGUID := 144096;
+
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+8;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
+(@OGUID+0, 184325, 550, 1, 1, 676.5166, -44.52248, 48.28133, 2.530723, 0, 0, 1, -4.371139E-08, 7200, 255, 0), -- 184325 (Area: -1)
+(@OGUID+1, 184324, 550, 1, 1, 676.6985, 43.16431, 48.28136, 0.6108655, 0, 0, 1, -4.371139E-08, 7200, 255, 0), -- 184324 (Area: -1)
+(@OGUID+2, 184069, 550, 1, 1, 743.0566, 4.634431, 137.7959, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- 184069 (Area: -1)
+(@OGUID+3, 184597, 550, 1, 1, 744.0448, 42.35362, 46.661, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- 184597 (Area: -1)
+(@OGUID+4, 184329, 550, 1, 1, 544.6263, 141.888, 26.34531, 2.879789, 0, 0, 1, -4.371139E-08, 7200, 255, 0), -- 184329 (Area: -1)
+(@OGUID+5, 184327, 550, 1, 1, 544.538, -143.1392, 26.34531, 3.403396, 0, 0, 1, -4.371139E-08, 7200, 255, 0), -- 184327 (Area: -1)
+(@OGUID+6, 184328, 550, 1, 1, 654.1292, 75.33163, 48.19505, 0.6108655, 0, 0, 1, -4.371139E-08, 7200, 255, 0), -- 184328 (Area: -1)
+(@OGUID+7, 184326, 550, 3, 1, 654.1447, -76.82803, 48.19501, 2.530723, 0, 0, 1, -4.371139E-08, 7200, 255, 0), -- 184326 (Area: -1)
+(@OGUID+8, 184596, 550, 1, 1, 744.0446, -44.63448, 46.66097, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1); -- 184596 (Area: -1)
+
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+58;
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
+-- OLDWorld Trigger (DO NOT DELETE)
+(@CGUID+0, 15384, 550, 1, 1, 330.3438, -1.1002, 42.86049, 3.176499, 7200, 0, 0), -- 15384 (Area: -1)
+(@CGUID+1, 15384, 550, 1, 1, 335.6376, 59.48792, 17.93191, 1.832596, 7200, 0, 0), -- 15384 (Area: -1)
+(@CGUID+2, 15384, 550, 1, 1, 332.723, -61.15897, 17.97906, 3.647738, 7200, 0, 0), -- 15384 (Area: -1)
+(@CGUID+3, 15384, 550, 1, 1, 388.7913, -33.10595, 20.26358, 4.852015, 7200, 0, 0), -- 15384 (Area: -1)
+(@CGUID+4, 15384, 550, 1, 1, 388.7511, 31.73123, 20.26364, 4.625123, 7200, 0, 0), -- 15384 (Area: -1)
+(@CGUID+5, 15384, 550, 1, 1, 276.0723, -0.578703, 26.20747, 2.111848, 7200, 0, 0), -- 15384 (Area: -1)
+(@CGUID+6, 15384, 550, 1, 1, 259.2285, 35.87902, 20.26298, 5.009095, 7200, 0, 0), -- 15384 (Area: -1)
+(@CGUID+7, 15384, 550, 1, 1, 258.9592, -38.68707, 20.26289, 5.72468, 7200, 0, 0), -- 15384 (Area: -1)
+-- World Invisible Trigger
+(@CGUID+8, 12999, 550, 1, 1, 425.4077, -0.379617, 80.36799, 0.9250245, 7200, 0, 0), -- 12999 (Area: -1)
+-- Bloodwarder Marshal
+(@CGUID+9, 20035, 550, 1, 1, 639.83, 2.04339, 46.86218, 6.213372, 7200, 0, 0), -- 20035 (Area: -1)
+(@CGUID+10, 20035, 550, 1, 1, 728.8043, -43.12828, 46.86215, 3.769911, 7200, 0, 0), -- 20035 (Area: -1)
+(@CGUID+11, 20035, 550, 1, 1, 724.6683, 47.55159, 46.86216, 5.480334, 7200, 0, 0), -- 20035 (Area: -1)
+-- Crimson Hand Inquisitor
+(@CGUID+12, 20050, 550, 1, 1, 730.1712, 45.34771, 46.86216, 3.438299, 7200, 0, 0), -- 20050 (Area: -1)
+(@CGUID+13, 20050, 550, 1, 1, 639.6623, -3.341067, 46.86219, 0.05235988, 7200, 0, 0), -- 20050 (Area: -1)
+(@CGUID+14, 20050, 550, 1, 1, 727.4787, -46.94502, 46.86214, 2.111848, 7200, 0, 0), -- 20050 (Area: -1)
+-- World Trigger (Large AOI)
+(@CGUID+15, 22517, 550, 1, 1, 665.1088, -0.950598, 46.86217, 4.415683, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+16, 22517, 550, 1, 1, 701.9359, 66.05067, 46.86216, 3.124139, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+17, 22517, 550, 1, 1, 708.8086, -0.769152, 46.86216, 5.148721, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+18, 22517, 550, 1, 1, 699.306, -67.62751, 46.86217, 1.518436, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+19, 22517, 550, 1, 1, 732.9473, -0.566178, 46.86214, 3.612832, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+20, 22517, 550, 1, 1, 798.8123, 61.56698, 115.3441, 3.769911, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+21, 22517, 550, 1, 1, 785.4241, -52.29982, 134.9155, 4.712389, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+22, 22517, 550, 1, 1, 775.7325, -61.36944, 119.4992, 5.8294, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+23, 22517, 550, 1, 1, 799.8832, -39.79063, 86.04091, 3.316126, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+24, 22517, 550, 1, 1, 800.0196, -62.71717, 109.6165, 1.605703, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+25, 22517, 550, 1, 1, 799.4819, 38.38402, 84.18855, 3.839724, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+26, 22517, 550, 1, 1, 851.5966, 17.91289, 109.8992, 1.27409, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+27, 22517, 550, 1, 1, 847.8403, 14.67272, 64.72507, 3.787364, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+28, 22517, 550, 1, 1, 844.8558, 6.185529, 65.86212, 0.2443461, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+29, 22517, 550, 1, 1, 855.7502, -1.335043, 112.8265, 3.839724, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+30, 22517, 550, 1, 1, 849.4088, 37.11266, 77.68398, 4.921828, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+31, 22517, 550, 1, 1, 852.7165, -17.16145, 111.8991, 5.602507, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+32, 22517, 550, 1, 1, 844.8883, -7.439569, 66.13985, 0.2443461, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+33, 22517, 550, 1, 1, 846.6299, -37.76403, 84.40607, 2.617994, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+34, 22517, 550, 1, 1, 847.9123, -16.27052, 64.80233, 4.660029, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+35, 22517, 550, 1, 1, 848.437, 30.28408, 92.7951, 4.817109, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+36, 22517, 550, 1, 1, 847.2033, -31.35966, 99.57969, 0.8203048, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+37, 22517, 550, 1, 1, 766.7248, -0.726238, 50.13387, 0.1919862, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+38, 22517, 550, 1, 1, 778.8183, 56.69846, 126.9899, 2.513274, 7200, 0, 0), -- 22517 (Area: -1)
+(@CGUID+39, 22517, 550, 1, 1, 786.0614, 65.85825, 100.4249, 3.263766, 7200, 0, 0), -- 22517 (Area: -1)
+-- Crimson Hand Centurion
+(@CGUID+40, 20048, 550, 1, 1, 645.0178, -81.17285, 46.95522, 4.08407, 7200, 0, 0), -- 20048 (Area: -1)
+(@CGUID+41, 20048, 550, 1, 1, 651.8069, -89.19706, 46.88657, 3.769911, 7200, 0, 0), -- 20048 (Area: -1)
+(@CGUID+42, 20048, 550, 1, 1, 723.4222, -42.63152, 46.86216, 5.340707, 7200, 0, 0), -- 20048 (Area: -1)
+(@CGUID+43, 20048, 550, 1, 1, 642.194, -5.843318, 46.86219, 0.122173, 7200, 0, 0), -- 20048 (Area: -1)
+(@CGUID+44, 20048, 550, 1, 1, 596.6088, -116.1815, 39.08448, 3.560472, 7200, 0, 0), -- 20048 (Area: -1)
+(@CGUID+45, 20048, 550, 1, 1, 723.4005, 42.63834, 46.86216, 0.4363323, 7200, 0, 0), -- 20048 (Area: -1)
+(@CGUID+46, 20048, 550, 1, 1, 601.6668, -127.0311, 39.08003, 3.193953, 7200, 0, 0), -- 20048 (Area: -1)
+-- Crimson Hand Battle Mage
+(@CGUID+47, 20047, 550, 1, 1, 651.7038, -86.65275, 46.98884, 3.822271, 7200, 0, 0), -- 20047 (Area: -1)
+(@CGUID+48, 20047, 550, 1, 1, 641.1581, -80.68994, 46.88804, 4.18879, 7200, 0, 0), -- 20047 (Area: -1)
+(@CGUID+49, 20047, 550, 1, 1, 595.457, -133.0207, 36.76626, 2.984513, 7200, 0, 0), -- 20047 (Area: -1)
+(@CGUID+50, 20047, 550, 1, 1, 587.3175, -118.0383, 37.48773, 3.769911, 7200, 0, 0), -- 20047 (Area: -1)
+-- Crimson Hand Blood Knight
+(@CGUID+51, 20049, 550, 1, 1, 643.371, -78.52799, 46.8777, 4.153883, 7200, 0, 0), -- 20049 (Area: -1)
+(@CGUID+52, 20049, 550, 1, 1, 654.1863, -91.09548, 46.82586, 3.682645, 7200, 0, 0), -- 20049 (Area: -1)
+(@CGUID+53, 20049, 550, 1, 1, 722.7352, -47.12922, 46.86216, 0.4712389, 7200, 0, 0), -- 20049 (Area: -1)
+(@CGUID+54, 20049, 550, 1, 1, 642.2731, 4.882175, 46.86217, 6.161012, 7200, 0, 0), -- 20049 (Area: -1)
+(@CGUID+55, 20049, 550, 1, 1, 592.64, -116.0134, 38.14479, 3.665191, 7200, 0, 0), -- 20049 (Area: -1)
+(@CGUID+56, 20049, 550, 1, 1, 598.7542, -130.3867, 37.92725, 3.089233, 7200, 0, 0), -- 20049 (Area: -1)
+(@CGUID+57, 20049, 550, 1, 1, 728.1479, 39.56045, 46.86216, 1.692969, 7200, 0, 0), -- 20049 (Area: -1)
+-- World Trigger
+(@CGUID+58, 22515, 550, 1, 1, 810.1933, -0.727374, 50.13386, 3.141593, 7200, 0, 0); -- 22515 (Area: -1)
+
+-- Correct some spawn positions with sniffed values
+UPDATE `creature` SET `position_x` = 792.7254, `position_y` = 12.77545, `position_z` = 48.81183, `orientation` = 3.595378 WHERE `guid` = 12568 AND `id` = 20063; -- Telonicus
+UPDATE `creature` SET `position_x` = 785.8074, `position_y` = 19.48621, `position_z` = 48.81183, `orientation` = 3.979351 WHERE `guid` = 12567 AND `id` = 20064; -- Thaladred
+UPDATE `creature` SET `position_x` = 792.4081, `position_y` = -13.24149, `position_z` = 48.81179, `orientation` = 2.687807 WHERE `guid` = 12569 AND `id` = 20062; -- Capernian
+UPDATE `creature` SET `position_x` = 785.7821, `position_y` = -20.39954, `position_z` = 48.81179, `orientation` = 2.303835 WHERE `guid` = 12570 AND `id` = 20060; -- Sanguinar
+UPDATE `creature` SET `position_x` = 795.4078, `position_y` = -1.604753, `position_z` = 48.8118, `orientation` = 3.141593 WHERE `guid` = 7987 AND `id` = 19622; -- Kael
+
+-- Improper spawns of Ember of Alar
+DELETE FROM `creature` WHERE `guid` IN (12481, 12482, 12483) AND `id` = 19551;