Files
moonwell-core-vanilla/sql/migrations/20250821132125_world.sql
2025-10-08 14:49:19 +03:00

160 lines
10 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`='20250821132125');
IF v = 0 THEN
INSERT INTO `migrations` VALUES ('20250821132125');
-- Add your query below.
DELETE FROM `creature_addon` WHERE `guid` IN (29601, 29602, 29607, 29611, 29614, 29616, 29630, 29631);
INSERT INTO `creature_addon` (`guid`, `patch`, `display_id`, `mount_display_id`, `equipment_id`, `stand_state`, `sheath_state`, `emote_state`, `auras`) VALUES
(29601, 0, 0, 0, -1, 0, 1, 233, NULL),
(29602, 0, 0, 0, -1, 0, 1, 233, NULL),
(29607, 0, 0, 0, -1, 0, 1, 233, NULL),
(29611, 0, 0, 0, -1, 0, 1, 233, NULL),
(29614, 0, 0, 0, -1, 0, 1, 233, NULL),
(29616, 0, 0, 0, -1, 0, 1, 233, NULL),
(29630, 0, 0, 0, -1, 0, 1, 233, NULL),
(29631, 0, 0, 0, -1, 0, 1, 233, NULL);
-- Windshear Overlord 4004
UPDATE `creature` SET `position_x` = 978.26074, `position_y` = -377.89606, `position_z` = 9.0254755, `movement_type` = 2, `wander_distance` = 0 WHERE `guid` = 29646;
UPDATE `creature` SET `position_x` = 872.80945, `position_y` = -292.8252, `position_z` = 17.80613, `movement_type` = 2, `wander_distance` = 0 WHERE `guid` = 29648;
UPDATE `creature` SET `position_x` = 987.2447, `position_y` = -328.64514, `position_z` = -0.28765878, `movement_type` = 2, `wander_distance` = 0 WHERE `guid` = 29660;
UPDATE `creature` SET `position_x` = 985.87915, `position_y` = -375.4854, `position_z` = 16.126184, `movement_type` = 2, `wander_distance` = 0 WHERE `guid` = 29661;
UPDATE `creature` SET `position_x` = 953.9792, `position_y` = -257.88293, `position_z` = -3.5109515, `movement_type` = 2, `wander_distance` = 0 WHERE `guid` = 29662;
UPDATE `creature` SET `position_x` = 909.07324, `position_y` = -334.2018, `position_z` = 18.525047, `movement_type` = 2, `wander_distance` = 0 WHERE `guid` = 29664;
UPDATE `creature` SET `position_x` = 961.505127, `position_y` = -354.267487, `position_z` = 16.958834, `movement_type` = 1, `wander_distance` = 3 WHERE `guid` = 29665;
DELETE FROM `creature_movement` WHERE `id` IN (29646, 29648, 29660, 29661, 29662, 29664);
-- 29646
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(29646,(@POINT := @POINT + 1),978.26074,-377.89606,9.0254755,100,500,0),
(29646,(@POINT := @POINT + 1),978.54114,-385.31088,8.227136,100,0,0),
(29646,(@POINT := @POINT + 1),971.53625,-387.9108,8.264367,100,0,0),
(29646,(@POINT := @POINT + 1),966.7669,-383.84634,8.013391,100,0,0),
(29646,(@POINT := @POINT + 1),965.7326,-375.6895,7.904025,100,0,0),
(29646,(@POINT := @POINT + 1),961.0283,-363.34268,5.3975625,100,0,0),
(29646,(@POINT := @POINT + 1),961.3163,-349.0778,2.343706,100,0,0),
(29646,(@POINT := @POINT + 1),968.81525,-340.1766,-1.0334809,100,0,0),
(29646,(@POINT := @POINT + 1),979.7723,-334.89594,-1.688632,100,500,0),
(29646,(@POINT := @POINT + 1),968.81525,-340.1766,-1.0334809,100,0,0),
(29646,(@POINT := @POINT + 1),961.3163,-349.0778,2.343706,100,0,0),
(29646,(@POINT := @POINT + 1),961.0283,-363.34268,5.3975625,100,0,0),
(29646,(@POINT := @POINT + 1),965.7326,-375.6895,7.904025,100,0,0),
(29646,(@POINT := @POINT + 1),966.7669,-383.84634,8.013391,100,0,0),
(29646,(@POINT := @POINT + 1),971.53625,-387.9108,8.264367,100,0,0),
(29646,(@POINT := @POINT + 1),978.54114,-385.31088,8.227136,100,0,0);
-- 29648
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(29648,(@POINT := @POINT + 1),872.80945,-292.8252,17.80613,100,500,0),
(29648,(@POINT := @POINT + 1),885.36285,-290.37933,19.17272,100,0,0),
(29648,(@POINT := @POINT + 1),897.8306,-285.32156,20.153763,100,0,0),
(29648,(@POINT := @POINT + 1),911.8462,-279.59897,21.566036,100,0,0),
(29648,(@POINT := @POINT + 1),923.16266,-270.354,22.029636,100,0,0),
(29648,(@POINT := @POINT + 1),927.9974,-274.91867,22.343903,100,0,0),
(29648,(@POINT := @POINT + 1),932.887,-281.16733,18.190046,100,0,0),
(29648,(@POINT := @POINT + 1),932.75543,-285.33365,17.774048,100,500,0),
(29648,(@POINT := @POINT + 1),932.887,-281.16733,18.190046,100,0,0),
(29648,(@POINT := @POINT + 1),927.9974,-274.91867,22.343903,100,0,0),
(29648,(@POINT := @POINT + 1),923.16266,-270.354,22.029636,100,0,0),
(29648,(@POINT := @POINT + 1),911.8462,-279.59897,21.566036,100,0,0),
(29648,(@POINT := @POINT + 1),897.8306,-285.32156,20.153763,100,0,0),
(29648,(@POINT := @POINT + 1),885.36285,-290.37933,19.17272,100,0,0);
-- 29660
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(29660,(@POINT := @POINT + 1),987.2447,-328.64514,-0.28765878,100,500,0),
(29660,(@POINT := @POINT + 1),987.5994,-317.40674,0.8982092,100,0,0),
(29660,(@POINT := @POINT + 1),980.0046,-304.04227,-1.3080362,100,0,0),
(29660,(@POINT := @POINT + 1),969.19714,-302.97385,-0.6509599,100,0,0),
(29660,(@POINT := @POINT + 1),961.9171,-300.102,-2.3842425,100,0,0),
(29660,(@POINT := @POINT + 1),954.6951,-305.87582,-1.8897942,100,0,0),
(29660,(@POINT := @POINT + 1),955.3952,-316.19125,-1.5026575,100,500,0),
(29660,(@POINT := @POINT + 1),954.6951,-305.87582,-1.8897942,100,0,0),
(29660,(@POINT := @POINT + 1),961.9171,-300.102,-2.3842425,100,0,0),
(29660,(@POINT := @POINT + 1),969.19714,-302.97385,-0.6509599,100,0,0),
(29660,(@POINT := @POINT + 1),980.0046,-304.04227,-1.3080362,100,0,0),
(29660,(@POINT := @POINT + 1),987.5994,-317.40674,0.8982092,100,0,0);
-- 29661
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(29661,(@POINT := @POINT + 1),985.87915,-375.4854,16.126184,100,500,0),
(29661,(@POINT := @POINT + 1),977.4711,-366.06494,16.481733,100,0,0),
(29661,(@POINT := @POINT + 1),980.44977,-359.77316,15.8730955,100,0,0),
(29661,(@POINT := @POINT + 1),987.0081,-353.62875,12.911339,100,0,0),
(29661,(@POINT := @POINT + 1),979.6847,-358.955,15.934146,100,0,0),
(29661,(@POINT := @POINT + 1),974.1008,-359.98465,15.90542,100,0,0),
(29661,(@POINT := @POINT + 1),967.81146,-355.42084,15.778783,100,0,0),
(29661,(@POINT := @POINT + 1),959.8864,-356.57254,16.263485,100,0,0),
(29661,(@POINT := @POINT + 1),952.05316,-358.53668,16.00057,100,0,0),
(29661,(@POINT := @POINT + 1),942.7303,-357.83762,15.760734,100,0,0),
(29661,(@POINT := @POINT + 1),937.1593,-346.72034,17.17706,100,500,0),
(29661,(@POINT := @POINT + 1),942.7303,-357.83762,15.760734,100,0,0),
(29661,(@POINT := @POINT + 1),952.05316,-358.53668,16.00057,100,0,0),
(29661,(@POINT := @POINT + 1),959.8864,-356.57254,16.263485,100,0,0),
(29661,(@POINT := @POINT + 1),967.81146,-355.42084,15.778783,100,0,0),
(29661,(@POINT := @POINT + 1),974.1008,-359.98465,15.90542,100,0,0),
(29661,(@POINT := @POINT + 1),979.6847,-358.955,15.934146,100,0,0),
(29661,(@POINT := @POINT + 1),987.0081,-353.62875,12.911339,100,0,0),
(29661,(@POINT := @POINT + 1),980.44977,-359.77316,15.8730955,100,0,0),
(29661,(@POINT := @POINT + 1),977.4711,-366.06494,16.481733,100,0,0);
-- 29662
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(29662,(@POINT := @POINT + 1),953.9792,-257.88293,-3.5109515,100,500,0),
(29662,(@POINT := @POINT + 1),943.3326,-255.42464,-2.5989857,100,0,0),
(29662,(@POINT := @POINT + 1),933.843,-259.72906,-2.1856833,100,0,0),
(29662,(@POINT := @POINT + 1),930.4224,-266.17487,-1.680638,100,0,0),
(29662,(@POINT := @POINT + 1),919.2319,-273.9211,-0.8711146,100,0,0),
(29662,(@POINT := @POINT + 1),913.40356,-280.15305,-1.6427773,100,0,0),
(29662,(@POINT := @POINT + 1),907.3419,-280.48596,-0.90467596,100,0,0),
(29662,(@POINT := @POINT + 1),913.14703,-289.98215,-0.97477597,100,0,0),
(29662,(@POINT := @POINT + 1),924.87524,-292.08328,-1.881798,100,0,0),
(29662,(@POINT := @POINT + 1),933.51715,-291.6391,-0.8050218,100,0,0),
(29662,(@POINT := @POINT + 1),940.4749,-294.35617,-1.6682853,100,0,0),
(29662,(@POINT := @POINT + 1),956.37683,-298.77066,-2.5723162,100,0,0),
(29662,(@POINT := @POINT + 1),966.77136,-302.1098,-0.9671719,100,500,0),
(29662,(@POINT := @POINT + 1),956.37683,-298.77066,-2.5723162,100,0,0),
(29662,(@POINT := @POINT + 1),940.4749,-294.35617,-1.6682853,100,0,0),
(29662,(@POINT := @POINT + 1),933.51715,-291.6391,-0.8050218,100,0,0),
(29662,(@POINT := @POINT + 1),924.87524,-292.08328,-1.881798,100,0,0),
(29662,(@POINT := @POINT + 1),913.14703,-289.98215,-0.97477597,100,0,0),
(29662,(@POINT := @POINT + 1),907.3419,-280.48596,-0.90467596,100,0,0),
(29662,(@POINT := @POINT + 1),913.40356,-280.15305,-1.6427773,100,0,0),
(29662,(@POINT := @POINT + 1),919.2319,-273.9211,-0.8711146,100,0,0),
(29662,(@POINT := @POINT + 1),930.4224,-266.17487,-1.680638,100,0,0),
(29662,(@POINT := @POINT + 1),933.843,-259.72906,-2.1856833,100,0,0),
(29662,(@POINT := @POINT + 1),943.3326,-255.42464,-2.5989857,100,0,0);
-- 29664
SET @POINT := 0;
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `script_id`) VALUES
(29664,(@POINT := @POINT + 1),909.07324,-334.2018,18.525047,100,500,0),
(29664,(@POINT := @POINT + 1),919.23285,-329.27045,19.036795,100,0,0),
(29664,(@POINT := @POINT + 1),923.80145,-320.73843,17.60006,100,0,0),
(29664,(@POINT := @POINT + 1),927.54785,-311.1471,17.877155,100,0,0),
(29664,(@POINT := @POINT + 1),938.6646,-295.839,18.20342,100,500,0),
(29664,(@POINT := @POINT + 1),927.54785,-311.1471,17.877155,100,0,0),
(29664,(@POINT := @POINT + 1),923.80145,-320.73843,17.60006,100,0,0),
(29664,(@POINT := @POINT + 1),919.23285,-329.27045,19.036795,100,0,0),
(29664,(@POINT := @POINT + 1),909.07324,-334.2018,18.525047,100,500,0);
-- misc
UPDATE `creature` SET `wander_distance`=3 WHERE `guid`=29647;
UPDATE `creature` SET `id`=4003, `mana_percent`=100 WHERE `guid`=29665;
UPDATE `creature` SET `id`=4004, `wander_distance` = 3 WHERE `guid`=29642;
DELETE FROM `creature` WHERE `guid` = 29663;
-- End of migration.
END IF;
END??
DELIMITER ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;