Files
moonwell-core-vanilla/sql/migrations/20241212104611_world.sql
2024-12-12 13:38:08 +02:00

347 lines
32 KiB
SQL

DROP PROCEDURE IF EXISTS add_migration;
DELIMITER ??
CREATE PROCEDURE `add_migration`()
BEGIN
DECLARE v INT DEFAULT 1;
SET v = (SELECT COUNT(*) FROM `migrations` WHERE `id`='20241212104611');
IF v = 0 THEN
INSERT INTO `migrations` VALUES ('20241212104611');
-- Add your query below.
-- Remove wrong Campfire spawns.
DELETE FROM `gameobject` WHERE `guid` IN (3998307, 3998308, 3998309, 3998310);
-- Fire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2402, 176428, 229, -63.2568, -581.483, 29.2934, 3.14169, 0.0295649, -0.0015707, -0.999561, 0, 180, 180, 100, 1, 0, 10); -- Blackrock Spire
-- Fire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2403, 176429, 229, -37.6863, -551.822, 16.2163, 3.14159, 0, 0, -1, 0, 180, 180, 100, 1, 0, 10); -- Blackrock Spire
-- Fire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2409, 176430, 229, -25.3349, -478.438, 17.2504, 3.14159, 0, 0, -1, 0, 180, 180, 100, 1, 0, 10); -- Blackrock Spire
-- Fire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2410, 176431, 229, -46.3865, -448.61, -18.5644, 3.14159, 0, 0, -1, 0, 180, 180, 100, 1, 0, 10); -- Blackrock Spire
-- Fire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2411, 176432, 229, -2.64242, -579.144, -18.7609, 3.14159, 0, 0, -1, 0, 180, 180, 100, 1, 0, 10); -- Blackrock Spire
-- Fire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2412, 176433, 229, 26.982, -583.365, -18.5153, 3.14159, 0, 0, -1, 0, 180, 180, 100, 1, 0, 10); -- Blackrock Spire
-- Fire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2413, 176434, 229, 35.6424, -550.73, -18.411, 3.14159, 0, 0, -1, 0, 180, 180, 100, 1, 0, 10); -- Blackrock Spire
-- Fire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2414, 176435, 229, 33.1643, -471.047, -18.5059, 3.14159, 0, 0, -1, 0, 180, 180, 100, 1, 0, 10); -- Blackrock Spire
-- Bonfire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2417, 176436, 229, 31.9839, -495.349, -18.8984, 3.14444, 0.00822973, -0.0190172, -0.999784, 0.00126859, 180, 180, 100, 1, 0, 10); -- Blackrock Spire
-- Fire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2418, 176437, 229, -39.3852, -424.878, -18.8471, 3.14159, 0, 0, -1, 0, 180, 180, 100, 1, 0, 10); -- Blackrock Spire
-- Bonfire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2419, 176439, 229, -76.0975, -418.801, -18.9234, 4.45059, 0, 0, -0.793352, 0.608763, 180, 180, 100, 1, 0, 10); -- Blackrock Spire
-- Fire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2421, 176440, 229, -59.9712, -409.641, -18.8443, 3.14159, 0, 0, -1, 0, 180, 180, 100, 1, 0, 10); -- Blackrock Spire
-- Fire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2423, 176441, 229, -79.5309, -453.927, -18.8332, 3.14159, 0, 0, -1, 0, 180, 180, 100, 1, 0, 10); -- Blackrock Spire
-- Bonfire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2424, 176442, 229, -15.4378, -368.781, 49.4936, 3.14085, -0.0333757, -0.0110826, 0.999381, 0, 180, 180, 100, 1, 0, 10); -- Blackrock Spire
-- Fire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2425, 176443, 229, -121.137, -296.445, 71.0397, 3.14159, 0, 0, -1, 0, 180, 180, 100, 1, 0, 10); -- Blackrock Spire
-- Bonfire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2426, 176444, 229, -137.264, -305.605, 70.9606, 4.45059, 0, 0, -0.793352, 0.608763, 180, 180, 100, 1, 0, 10); -- Blackrock Spire
-- Bonfire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2427, 176445, 229, -59.1198, -339.829, 70.9606, 4.45059, 0, 0, -0.793352, 0.608763, 180, 180, 100, 1, 0, 10); -- Blackrock Spire
-- Fire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2429, 176446, 229, -87.3357, -348.37, 71.0397, 3.14159, 0, 0, -1, 0, 180, 180, 100, 1, 0, 10); -- Blackrock Spire
-- Meat Rack
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2430, 176456, 229, -60.6476, -584.383, 29.1115, 3.14159, 0, 0, -1, 0, 180, 180, 100, 1, 0, 10); -- Blackrock Spire
-- Fire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2431, 176457, 229, -115.273, -428.518, -18.701, 3.14159, 0, 0, -1, 0, 180, 180, 100, 1, 0, 10); -- Blackrock Spire
-- Meat Rack
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2433, 176458, 229, -114.982, -421.897, -18.9179, 3.14159, 0, 0, -1, 0, 180, 180, 100, 1, 0, 10); -- Blackrock Spire
-- Eva Remains Ablaze
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2643, 176546, 289, 196.846, -73.9371, 85.2284, 2.56563, 0, 0, 0.958819, 0.284016, -18, -18, 100, 1, 0, 10); -- Scholomance (SPAWN)
DELETE FROM `event_scripts` WHERE `id`=5439;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(5439, 0, 9, 2643, 18, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Remains of Eva Sarkhoff: Respawn GameObject Eva Remains Ablaze');
-- Lucien Remains Ablaze
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2644, 176547, 289, 165.337, -81.144, 85.2284, 3.03684, 0, 0, 0.998629, 0.0523532, -18, -18, 100, 1, 0, 10); -- Scholomance (SPAWN)
DELETE FROM `event_scripts` WHERE `id`=5438;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(5438, 0, 9, 2644, 18, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Remains of Lucien Sarkhoff: Respawn GameObject Lucien Remains Ablaze');
-- Alliance Bell
-- Event 78: Hourly Bells
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2648, 176573, 529, 1307.12, 1320.6, -2.68807, 0.785397, 0, 0, 0.382683, 0.92388, 180, 180, 100, 1, 0, 10); -- Arathi Basin
UPDATE `gameobject` SET `position_x`=-8585.28, `position_y`=808.048, `position_z`=106.519, `orientation`=3.73501, `rotation0`=0, `rotation1`=0, `rotation2`=-0.956305, `rotation3`=0.292372 WHERE `guid`=18901;
UPDATE `gameobject` SET `position_x`=-8760.2, `position_y`=1117.5, `position_z`=110.842, `orientation`=2.47837, `rotation0`=0, `rotation1`=0, `rotation2`=0.945518, `rotation3`=0.325568 WHERE `guid`=42905;
-- Dreamfoil
-- Pool 4291: Herbs in Dire Maul
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2650, 176584, 429, -36.5852, -319.271, -51.7758, 0.244346, 0, 0, 0.121869, 0.992546, 604800, 604800, 100, 1, 1, 10), -- Dire Maul
(2651, 176584, 429, -76.5402, -246.546, -56.9004, 4.7473, 0, 0, -0.694658, 0.71934, 604800, 604800, 100, 1, 1, 10); -- Dire Maul
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `chance`, `description`, `flags`, `patch_min`, `patch_max`) VALUES
(2650, 4291, 0, 'Dreamfoil', 0, 1, 10),
(2651, 4291, 0, 'Dreamfoil', 0, 1, 10);
-- Smoldering Brazier
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2671, 176905, 429, -21.1058, -392.466, -58.1027, 5.12254, 0, 0, -0.548293, 0.836286, 180, 180, 100, 1, 0, 10); -- Dire Maul
DELETE FROM `gameobject` WHERE `guid`=3997173;
-- Smoldering Brazier
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2672, 176906, 429, 4.30648, -441.621, -37.9976, 3.5692, 0, 0, -0.977231, 0.212178, 180, 180, 100, 1, 0, 10); -- Dire Maul
-- Door
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2673, 177211, 429, -41.8254, 159.874, -3.44834, 0, 0, 0, 0, 1, 25, 25, 100, 1, 1, 10); -- Dire Maul
-- Door
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2675, 177212, 429, 10.7216, 159.459, -3.44834, 3.14159, 0, 0, -1, 0, 180, 180, 100, 1, 0, 10); -- Dire Maul
-- Door
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2676, 177213, 429, 10.5911, -154.998, -2.69379, 3.14159, 0, 0, -1, 0, 180, 180, 100, 1, 0, 10); -- Dire Maul
-- Door
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2677, 177215, 429, 255.408, 10.3791, -2.69381, 1.5708, 0, 0, 0.707107, 0.707107, 180, 180, 100, 1, 0, 10); -- Dire Maul
-- Gordok Inner Door
UPDATE `gameobject` SET `position_x`=491.204, `position_y`=515.133, `position_z`=29.4675, `orientation`=1.5708, `rotation0`=0, `rotation1`=0, `rotation2`=0.707107, `rotation3`=0.707107 WHERE `guid`=240540;
-- Gordok Courtyard Door
UPDATE `gameobject` SET `position_x`=385.327, `position_y`=374.232, `position_z`=-1.34314, `orientation`=1.5708, `rotation0`=0, `rotation1`=0, `rotation2`=0.707107, `rotation3`=0.707107 WHERE `guid`=240359;
-- Door
UPDATE `gameobject` SET `id`=177221, `position_x`=50.5863, `position_y`=501.94, `position_z`=-23.1499, `orientation`=4.71239, `rotation0`=0, `rotation1`=0, `rotation2`=-0.707107, `rotation3`=0.707107 WHERE `guid`=397125;
-- Troll Drum Sound Object
UPDATE `gameobject` SET `position_x`=7313.22, `position_y`=-1490.33, `position_z`=155.965, `orientation`=5.49779, `rotation0`=0, `rotation1`=0, `rotation2`=-0.382683, `rotation3`=0.92388 WHERE `guid`=50453;
-- Remove custom spawns of Arcane Aberration and Mana Remnant and replace with spawns from sniffs.
DELETE FROM `creature` WHERE `id` IN (11480, 11483);
INSERT INTO `creature` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `wander_distance`, `movement_type`, `spawntimesecsmin`, `spawntimesecsmax`, `patch_min`, `patch_max`) VALUES
(84210, 11483, 429, 13.3353, 265.504, -7.47873, 4.85202, 0, 0, 7200, 7200, 1, 10),
(84211, 11483, 429, 0.18435, 277.584, -8.35593, 3.03687, 0, 0, 7200, 7200, 1, 10),
(84212, 11480, 429, 4.51283, 268.919, -8.03384, 3.83972, 0, 0, 7200, 7200, 1, 10),
(84213, 11480, 429, 22.2903, 268.93, -7.75637, 5.61996, 0, 0, 7200, 7200, 1, 10),
(84214, 11483, 429, 24.4087, 277.987, -8.40844, 6.0912, 0, 0, 7200, 7200, 1, 10),
(84215, 11483, 429, 22.2632, 286.032, -8.67728, 0.855211, 0, 0, 7200, 7200, 1, 10),
(84216, 11483, 429, 13.7393, 290.024, -8.81422, 1.43117, 0, 0, 7200, 7200, 1, 10),
(84218, 11480, 429, 4.86775, 286.17, -8.49644, 2.51327, 0, 0, 7200, 7200, 1, 10),
(84219, 11483, 429, 116.572, 441.026, 28.6844, 1.90241, 0, 0, 7200, 7200, 1, 10),
(84220, 11480, 429, 109.187, 432.731, 28.6844, 2.93215, 0, 0, 7200, 7200, 1, 10),
(84221, 11483, 429, 109.499, 423.1, 28.6844, 3.31613, 0, 0, 7200, 7200, 1, 10),
(84222, 11480, 429, 116.239, 417.468, 28.6844, 4.41568, 0, 0, 7200, 7200, 1, 10),
(84223, 11483, 429, -86.7868, 430.229, 28.6855, 4.83456, 0, 0, 7200, 7200, 1, 10),
(84224, 11480, 429, -79.4082, 437.517, 28.6859, 5.61996, 0, 0, 7200, 7200, 1, 10),
(84225, 11483, 429, -79.6795, 447.35, 28.6859, 0.401426, 0, 0, 7200, 7200, 1, 10),
(84227, 11480, 429, -86.4111, 454.612, 28.6864, 1.18682, 0, 0, 7200, 7200, 1, 10),
(84230, 11483, 429, -97.6146, 454.302, 28.6873, 2.21657, 0, 0, 7200, 7200, 1, 10),
(84231, 11483, 429, -104.249, 447.252, 28.6878, 2.75762, 0, 0, 7200, 7200, 1, 10),
(84234, 11483, 429, -104.42, 436.883, 28.6865, 3.36849, 0, 0, 7200, 7200, 1, 10),
(84235, 11480, 429, -98.4999, 429.365, 28.6854, 4.20624, 0, 0, 7200, 7200, 1, 10),
(84239, 11483, 429, 126.092, 416.945, 28.6844, 4.99164, 0, 0, 7200, 7200, 1, 10),
(84240, 11483, 429, 133.068, 423.411, 28.6844, 5.93412, 0, 0, 7200, 7200, 1, 10),
(84241, 11480, 429, 126.612, 440.825, 28.6844, 1.18682, 0, 0, 7200, 7200, 1, 10),
(84242, 11483, 429, 133.537, 434.405, 28.6844, 0.471239, 0, 0, 7200, 7200, 1, 10),
(84245, 11483, 429, 78.1069, 724.323, -24.4956, 4.67748, 0, 0, 7200, 7200, 1, 10),
(84246, 11480, 429, 87.2501, 727.643, -24.497, 5.16617, 0, 0, 7200, 7200, 1, 10),
(84247, 11483, 429, 91.785, 737.786, -24.497, 0, 0, 0, 7200, 7200, 1, 10),
(84257, 11480, 429, 89.8462, 745.194, -24.497, 0.715585, 0, 0, 7200, 7200, 1, 10),
(84258, 11483, 429, 78.097, 749.842, -24.497, 1.41372, 0, 0, 7200, 7200, 1, 10),
(84259, 11483, 429, 68.7335, 747.766, -24.497, 2.33874, 0, 0, 7200, 7200, 1, 10),
(84260, 11483, 429, 64.6404, 736.824, -24.497, 3.33358, 0, 0, 7200, 7200, 1, 10),
(84261, 11480, 429, 68.4746, 728.471, -24.4956, 3.9619, 0, 0, 7200, 7200, 1, 10),
(84262, 11480, 429, -154.641, 721.118, -24.4952, 4.64258, 0, 0, 7200, 7200, 1, 10),
(84264, 11483, 429, -146.109, 724.521, -24.4951, 5.48033, 0, 0, 7200, 7200, 1, 10),
(84265, 11483, 429, -140.277, 734.367, -24.4966, 6.07375, 0, 0, 7200, 7200, 1, 10),
(84266, 11480, 429, -142.956, 743.886, -24.497, 0.715585, 0, 0, 7200, 7200, 1, 10),
(84267, 11483, 429, -164.966, 724.302, -24.4968, 3.78736, 0, 0, 7200, 7200, 1, 10);
-- Doodad_DireMaulCrystalGenerator02
UPDATE `gameobject` SET `position_x`=-92.3456, `position_y`=442.67, `position_z`=28.547, `orientation`=0.418879, `rotation0`=0, `rotation1`=0, `rotation2`=0.207911, `rotation3`=0.978148 WHERE `guid`=261762;
-- Doodad_DireMaulCrystalGenerator03
UPDATE `gameobject` SET `position_x`=121.222, `position_y`=429.092, `position_z`=28.4548, `orientation`=0.418879, `rotation0`=0, `rotation1`=0, `rotation2`=0.207911, `rotation3`=0.978148 WHERE `guid`=262113;
-- Doodad_DireMaulCrystalGenerator01
UPDATE `gameobject` SET `position_x`=12.9414, `position_y`=277.931, `position_z`=-8.93289, `orientation`=0, `rotation0`=0, `rotation1`=0, `rotation2`=0, `rotation3`=1 WHERE `guid`=261760;
-- Moonwell
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2690, 177278, 1, 9554.63, 1655.24, 1298.83, 2.53945, 0, 0, 0.95502, 0.296542, 900, 900, 100, 1, 0, 10); -- Teldrassil
-- Campfire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2691, 177324, 30, -375.018, -523.71, 84.0771, 3.14159, 0, 0, -1, 0, 180, 180, 100, 1, 0, 10); -- Alterac Valley
-- Campfire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2694, 177325, 30, -413.51, -521.414, 84.0771, 2.05949, 0, 0, 0.857167, 0.515038, 180, 180, 100, 1, 0, 10); -- Alterac Valley
-- Campfire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2695, 177326, 30, -487.402, -526.486, 82.5708, 5.47161, 0, 0, -0.394744, 0.918791, 180, 180, 100, 1, 0, 10); -- Alterac Valley
-- Campfire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2696, 177327, 30, -251.556, -562.061, 68.1725, 6.11738, 0, 0, -0.0828075, 0.996566, 180, 180, 100, 1, 0, 10); -- Alterac Valley
-- Demon Portal
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(32664, 177367, 1, -2002.06, 1866.33, 52.4633, 3.194, 0, 0, -0.999657, 0.0262016, 900, 900, 100, 1, 0, 10), -- Desolace (SPAWN)
(32665, 177368, 1, -2067.9, 1844.89, 60.4518, 2.87979, 0, 0, 0.991445, 0.130528, 900, 900, 100, 1, 0, 10); -- Desolace (SPAWN)
UPDATE `gameobject_template` SET `data5`=0, `data10`=0 WHERE `entry` IN (177367, 177368);
INSERT INTO `gameobject_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(32664, 900, 82, 32664, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Demon Portal - Load to Map'),
(32664, 2, 41, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Demon Portal - Delete Self on Use'),
(32664, 0, 10, 11937, 60000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 'Demon Portal - Summon Demon Portal Guardian'),
(32665, 900, 82, 32665, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Demon Portal - Load to Map'),
(32665, 2, 41, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Demon Portal - Delete Self on Use'),
(32665, 0, 10, 11937, 60000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 'Demon Portal - Summon Demon Portal Guardian');
-- Cauldron
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2700, 177396, 30, 12.8251, -120.211, 41.6669, 3.14159, 0, 0, -1, 0, 180, 180, 100, 1, 0, 10); -- Alterac Valley
-- Campfire
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2734, 177425, 30, -353.118, 37.0957, 65.8904, 3.14159, 0, 0, -1, 0, 180, 180, 100, 1, 0, 10); -- Alterac Valley
-- Atal'ai Statue
UPDATE `gameobject` SET `position_x`=-491.396, `position_y`=53.5787, `position_z`=-148.74, `orientation`=5.81195, `rotation0`=0, `rotation1`=0, `rotation2`=-0.233445, `rotation3`=0.97237 WHERE `guid`=315030;
UPDATE `gameobject` SET `position_x`=-490.969, `position_y`=135.714, `position_z`=-148.74, `orientation`=0.226892, `rotation0`=0, `rotation1`=0, `rotation2`=0.113203, `rotation3`=0.993572 WHERE `guid`=315027;
UPDATE `gameobject` SET `position_x`=-515.046, `position_y`=95.1471, `position_z`=-148.74, `orientation`=2.74016, `rotation0`=0, `rotation1`=0, `rotation2`=0.979924, `rotation3`=0.19937 WHERE `guid`=315021;
UPDATE `gameobject` SET `position_x`=-420.155, `position_y`=94.3731, `position_z`=-148.74, `orientation`=3.9619, `rotation0`=0, `rotation1`=0, `rotation2`=-0.91706, `rotation3`=0.39875 WHERE `guid`=315024;
UPDATE `gameobject` SET `position_x`=-444.448, `position_y`=136.106, `position_z`=-148.74, `orientation`=0.331611, `rotation0`=0, `rotation1`=0, `rotation2`=0.165047, `rotation3`=0.986286 WHERE `guid`=315033;
UPDATE `gameobject` SET `position_x`=-443.55, `position_y`=53.9243, `position_z`=-148.74, `orientation`=0.90757, `rotation0`=0, `rotation1`=0, `rotation2`=0.438371, `rotation3`=0.898794 WHERE `guid`=315036;
-- Atal'ai Statue
UPDATE `gameobject` SET `position_x`=-444.448, `position_y`=136.106, `position_z`=-148.74, `orientation`=0.331611, `rotation0`=0, `rotation1`=0, `rotation2`=0.165047, `rotation3`=0.986286 WHERE `guid`=315034;
UPDATE `gameobject` SET `position_x`=-443.55, `position_y`=53.9243, `position_z`=-148.74, `orientation`=0.90757, `rotation0`=0, `rotation1`=0, `rotation2`=0.438371, `rotation3`=0.898794 WHERE `guid`=315037;
UPDATE `gameobject` SET `position_x`=-491.396, `position_y`=53.5787, `position_z`=-148.74, `orientation`=5.81195, `rotation0`=0, `rotation1`=0, `rotation2`=-0.233445, `rotation3`=0.97237 WHERE `guid`=315031;
UPDATE `gameobject` SET `position_x`=-490.969, `position_y`=135.714, `position_z`=-148.74, `orientation`=0.226892, `rotation0`=0, `rotation1`=0, `rotation2`=0.113203, `rotation3`=0.993572 WHERE `guid`=315028;
UPDATE `gameobject` SET `position_x`=-515.046, `position_y`=95.1471, `position_z`=-148.74, `orientation`=2.74016, `rotation0`=0, `rotation1`=0, `rotation2`=0.979924, `rotation3`=0.19937 WHERE `guid`=315022;
UPDATE `gameobject` SET `position_x`=-420.155, `position_y`=94.3731, `position_z`=-148.74, `orientation`=3.9619, `rotation0`=0, `rotation1`=0, `rotation2`=-0.91706, `rotation3`=0.39875 WHERE `guid`=315025;
-- Moonkin Stone Aura
UPDATE `gameobject` SET `spawntimesecsmin`=-120, `spawntimesecsmax`=-120 WHERE `guid`=15727;
-- Script when using item 15710 spell 19138.
DELETE FROM `event_scripts` WHERE `id`=6028;
INSERT INTO `event_scripts` (`id`, `delay`, `priority`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(6028, 0, 0, 9, 15727, 120, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Cenarion Lunardust: Respawn GameObject Moonkin Stone Aura'),
(6028, 0, 0, 10, 12138, 120000, 0, 0, 0, 0, 0, 0, 1, 1213801, -1, 1, -2445.6, -1646.02, 92.8553, 1.11701, 0, 'Cenarion Lunardust: Summon Creature Lunaclaw');
DELETE FROM `generic_scripts` WHERE `id`=1213801;
INSERT INTO `generic_scripts` (`id`, `delay`, `priority`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(1213801, 0, 0, 60, 3, 0, 1000, 0, 0, 0, 0, 0, 0, 1213801, 0, 0, 0, 0, 0, 0, 0, 'Cenarion Lunardust: Lunaclaw - Start Waypoints');
INSERT INTO `creature_movement_special` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
(1213801, 1, -2444.711914, -1642.662109, 92.690582, 100.000000, 0, 0.000000, 0),
(1213801, 2, -2446.711914, -1631.662109, 92.190582, 100.000000, 0, 0.000000, 0),
(1213801, 3, -2452.721924, -1625.327637, 92.110733, 100.000000, 0, 0.000000, 0),
(1213801, 4, -2472.471924, -1628.077637, 91.860733, 100.000000, 0, 0.000000, 0),
(1213801, 5, -2498.009033, -1631.718384, 91.791679, 100.000000, 0, 0.000000, 0),
(1213801, 6, -2497.068115, -1631.025391, 91.791679, 100.000000, 4000, 0.000000, 0),
(1213801, 7, -2497.068115, -1631.025391, 91.791679, 100.000000, 0, 0.000000, 2);
-- Moonkin Stone Aura
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(15742, 177644, 1, 6326.01, 92.7007, 21.9577, 4.08407, 0, 0, -0.891006, 0.453991, -120, -120, 100, 1, 0, 10); -- Darkshore
-- Script when using item 15208 spell 18974.
DELETE FROM `event_scripts` WHERE `id`=5991;
INSERT INTO `event_scripts` (`id`, `delay`, `priority`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(5991, 0, 0, 10, 12138, 120000, 0, 0, 0, 0, 0, 0, 1, 1213802, -1, 1, 6366.34, 140.382, 24.2587, 3.68264, 0, 'Cenarion Moondust: Summon Creature Lunaclaw'),
(5991, 1, 0, 9, 15742, 120, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Cenarion Moondust: Respawn GameObject Moonkin Stone Aura');
DELETE FROM `generic_scripts` WHERE `id`=1213802;
INSERT INTO `generic_scripts` (`id`, `delay`, `priority`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES
(1213802, 0, 0, 60, 3, 0, 1000, 0, 0, 0, 0, 0, 0, 1213802, 0, 0, 0, 0, 0, 0, 0, 'Cenarion Moondust: Lunaclaw - Start Waypoints');
INSERT INTO `creature_movement_special` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
(1213802, 1, 6365.421875, 139.798553, 24.188501, 100.000000, 0, 0.000000, 0),
(1213802, 2, 6356.171875, 133.298553, 22.938501, 100.000000, 0, 0.000000, 0),
(1213802, 3, 6349.310059, 125.077438, 22.138916, 100.000000, 0, 0.000000, 0),
(1213802, 4, 6345.013184, 122.000290, 22.793526, 100.000000, 0, 0.000000, 0),
(1213802, 5, 6341.763184, 117.250290, 22.793526, 100.000000, 0, 0.000000, 0),
(1213802, 6, 6339.005859, 113.137695, 21.242620, 100.000000, 0, 0.000000, 0),
(1213802, 7, 6335.020020, 107.050438, 21.803505, 100.000000, 0, 0.000000, 0),
(1213802, 8, 6333.560059, 104.820793, 22.023548, 100.000000, 0, 0.000000, 0),
(1213802, 9, 6330.335938, 100.653168, 21.263285, 100.000000, 0, 0.000000, 0),
(1213802, 10, 6325.043945, 94.151260, 22.016369, 100.000000, 0, 0.000000, 0),
(1213802, 11, 6323.289551, 93.937569, 22.318190, 100.000000, 0, 0.000000, 2);
UPDATE `creature_template` SET `spawn_spell_id`=10389 WHERE `entry`=12138;
-- Plaguewood Fire (Small)
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2780, 177669, 0, 2797.07, -3756.1, 146.486, 4.88692, 0, 0, -0.642787, 0.766045, -12, -12, 100, 1, 0, 10), -- Eastern Plaguelands
(2781, 177669, 0, 2821.02, -3767.79, 126.122, 5.60251, 0, 0, -0.333807, 0.942641, -12, -12, 100, 1, 0, 10), -- Eastern Plaguelands
(2782, 177669, 0, 2790.2, -3772.12, 125.424, 1.37881, 0, 0, 0.636078, 0.771625, -12, -12, 100, 1, 0, 10); -- Eastern Plaguelands
-- Plaguewood Fire (Large)
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2783, 177670, 0, 2814.97, -3755.91, 146.494, 0.942477, 0, 0, 0.45399, 0.891007, -12, -12, 100, 1, 0, 10), -- Eastern Plaguelands
(2784, 177670, 0, 2779.1, -3769.18, 133.583, 5.91667, 0, 0, -0.182235, 0.983255, -12, -12, 100, 1, 0, 10), -- Eastern Plaguelands
(2787, 177670, 0, 2796.34, -3778.98, 125.424, 3.12412, 0, 0, 0.999962, 0.00873464, -12, -12, 100, 1, 0, 10), -- Eastern Plaguelands
(2790, 177670, 0, 2816.53, -3774.73, 125.424, 3.78737, 0, 0, -0.948323, 0.317306, -12, -12, 100, 1, 0, 10); -- Eastern Plaguelands
-- Plaguewood Smoke
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2791, 177671, 0, 2803.39, -3750.83, 150.657, 4.81711, 0, 0, -0.66913, 0.743145, -12, -12, 100, 1, 0, 10), -- Eastern Plaguelands
(2792, 177671, 0, 2823.36, -3754.3, 130.373, 0.506145, 0, 0, 0.25038, 0.968148, -12, -12, 100, 1, 0, 10), -- Eastern Plaguelands
(2793, 177671, 0, 2779.57, -3773.03, 125.424, 3.03684, 0, 0, 0.998629, 0.0523532, -12, -12, 100, 1, 0, 10); -- Eastern Plaguelands
-- Shallow Grave
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `patch_min`, `patch_max`) VALUES
(2796, 177677, 0, 3377.68, -4896.83, 159.627, 2.19911, 0, 0, 0.891006, 0.453991, 900, 900, 100, 1, 0, 10); -- Eastern Plaguelands
-- End of migration.
END IF;
END??
DELIMITER ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;