sindoring/moonwell-core-vanilla
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Files
development
moonwell-core-vanilla/sql/migrations/20251209233625_world.sql
T
ratkosrb 79c1e87b3a Fix new startup errors.
2026-01-01 12:23:34 +02:00

481 lines
28 KiB
SQL
Raw Permalink Blame History

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`='20251209233625');
IF v = 0 THEN
INSERT INTO `migrations` VALUES ('20251209233625');
-- Add your query below.
-- Spawn 5 missing NPCs on IF mountain
INSERT INTO `creature` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `wander_distance`, `movement_type`, `spawntimesecsmin`, `spawntimesecsmax`) VALUES
-- Coldridge explorer
(3952, 13096, 0, -4868.14404296875, -666.720703125, 624.2823486328125, 0.279252678155899047, 0, 0, 300, 480),
-- Seasoned Coldmine Explorer
(3953, 13546, 0, -4868.6044921875, -663.77691650390625, 624.19671630859375, 5.969026088714599609, 0, 0, 300, 480),
-- Frostmane Headhunter at mountain cave
(3954, 1123, 0, -4628.3369140625, -786.67181396484375, 644.5216064453125, 5.8817596435546875, 0, 0, 300, 480),
-- Frostmane Shadowcaster at mountain cave
(3955, 1124, 0, -4625.97119140625, -787.70379638671875, 644.12432861328125, 2.932153224945068359, 0, 0, 300, 480),
-- Frostmane Snowstrider with waypoints at mountain cave
(3956, 1121, 0, -4615.202, -830.73157, 640.74457, 5.435677051544189453, 0, 0, 300, 480);
-- Coldridge explorer mining emote_state
INSERT INTO `creature_addon` (`guid`, `emote_state`) VALUES (3952, 28);
-- Seasoned Coldmine Explorer talking emote_state
INSERT INTO `creature_addon` (`guid`, `emote_state`) VALUES (3953, 1);
-- Frostmane Headhunter talking emote_state
INSERT INTO `creature_addon` (`guid`, `emote_state`) VALUES (3954, 1);
-- Frostmane Shadowcaster talking emote_state
INSERT INTO `creature_addon` (`guid`, `emote_state`) VALUES (3955, 1);
-- Frostmane Snowstrider should be mounted on a white wolf
INSERT INTO `creature_addon` (`guid`, `mount_display_id`) VALUES (3956, 1166);
-- Pathing for Frostmane Snowstrider Entry: 1121
SET @GUID := 3956;
UPDATE `creature` SET `wander_distance`=0, `movement_type`=2, `position_x`=-4615.202, `position_y`=-830.73157, `position_z`=640.74457 WHERE `guid`=@GUID;
DELETE FROM `creature_movement` WHERE `id`=@GUID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@GUID, 1, -4615.202, -830.73157, 640.74457, 100, 0, 0, 0),
(@GUID, 2, -4613.473, -830.1477, 641.1335, 100, 0, 0, 0),
(@GUID, 3, -4611.788, -829.9047, 641.5081, 100, 0, 0, 0),
(@GUID, 4, -4608.1616, -825.8204, 641.48004, 100, 0, 0, 0),
(@GUID, 5, -4604.353, -820.35925, 641.19104, 100, 0, 0, 0),
(@GUID, 6, -4604.4517, -815.06366, 639.7352, 100, 0, 0, 0),
(@GUID, 7, -4610.8525, -809.5583, 641.4144, 100, 0, 0, 0),
(@GUID, 8, -4616.9595, -808.1388, 642.3761, 100, 0, 0, 0),
(@GUID, 9, -4623.2397, -800.37195, 643.9852, 100, 0, 0, 0),
(@GUID, 10, -4624.028, -789.1372, 643.6385, 100, 0, 0, 0),
(@GUID, 11, -4627.421, -778.0575, 644.28815, 100, 0, 0, 0),
(@GUID, 12, -4633.0776, -767.71204, 644.9991, 100, 0, 0, 0),
(@GUID, 13, -4636.065, -757.84393, 645.20624, 100, 0, 0, 0),
(@GUID, 14, -4645.1704, -747.57275, 647.14545, 100, 0, 0, 0),
(@GUID, 15, -4654.752, -738.30237, 649.61566, 100, 0, 0, 0),
(@GUID, 16, -4662.7837, -733.31525, 651.588, 100, 0, 0, 0),
(@GUID, 17, -4654.752, -738.30237, 649.61566, 100, 0, 0, 0),
(@GUID, 18, -4645.1704, -747.57275, 647.14545, 100, 0, 0, 0),
(@GUID, 19, -4636.065, -757.84393, 645.20624, 100, 0, 0, 0),
(@GUID, 20, -4633.0776, -767.71204, 644.9991, 100, 0, 0, 0),
(@GUID, 21, -4627.421, -778.0575, 644.28815, 100, 0, 0, 0),
(@GUID, 22, -4624.028, -789.1372, 643.6385, 100, 0, 0, 0),
(@GUID, 23, -4623.2397, -800.37195, 643.9852, 100, 0, 0, 0),
(@GUID, 24, -4616.9595, -808.1388, 642.3761, 100, 0, 0, 0),
(@GUID, 25, -4610.8525, -809.5583, 641.4144, 100, 0, 0, 0),
(@GUID, 26, -4604.4517, -815.06366, 639.7352, 100, 0, 0, 0),
(@GUID, 27, -4604.353, -820.35925, 641.19104, 100, 0, 0, 0),
(@GUID, 28, -4608.1616, -825.8204, 641.48004, 100, 0, 0, 0),
(@GUID, 29, -4611.788, -829.9047, 641.5081, 100, 0, 0, 0),
(@GUID, 30, -4613.473, -830.1477, 641.1335, 100, 0, 0, 0);
-- Full: 0x2045FC000001184000000D0003D96BC7 | Low: 64580551
-- .go xyz -4615.202 -830.73157 640.74457
-- Pathing for Ironforge Guard Entry: 5595
SET @GUID := 190247;
UPDATE `creature` SET `wander_distance`=0, `movement_type`=2, `position_x`=-4801.888, `position_y`=-996.84375, `position_z`=893.2265 WHERE `guid`=@GUID;
DELETE FROM `creature_movement` WHERE `id`=@GUID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@GUID, 1, -4801.888, -996.84375, 893.2265, 100, 0, 0, 0),
(@GUID, 2, -4808.791, -991.8394, 890.75214, 100, 0, 0, 0),
(@GUID, 3, -4825.008, -988.94196, 880.40765, 100, 0, 0, 0),
(@GUID, 4, -4833.0835, -986.98926, 873.28973, 100, 0, 0, 0),
(@GUID, 5, -4845.493, -988.7001, 858.1719, 100, 0, 0, 0),
(@GUID, 6, -4852.991, -981.2694, 848.6763, 100, 0, 0, 0),
(@GUID, 7, -4852.965, -950.44183, 845.39453, 100, 0, 0, 0),
(@GUID, 8, -4841.64, -924.486, 844.2806, 100, 0, 0, 0),
(@GUID, 9, -4824.6865, -910.1261, 830.9742, 100, 0, 0, 0),
(@GUID, 10, -4804.5757, -902.56226, 829.05255, 100, 0, 0, 0),
(@GUID, 11, -4777.106, -899.6929, 814.4335, 100, 0, 0, 0),
(@GUID, 12, -4756.9194, -896.874, 801.36066, 100, 0, 0, 0),
(@GUID, 13, -4736.275, -907.2883, 797.55206, 100, 0, 0, 0),
(@GUID, 14, -4709.4478, -932.53546, 794.318, 100, 0, 0, 0),
(@GUID, 15, -4693.6045, -938.3761, 788.2069, 100, 0, 0, 0),
(@GUID, 16, -4671.4, -939.439, 777.1056, 100, 0, 0, 0),
(@GUID, 17, -4653.0566, -931.1431, 758.7995, 100, 0, 0, 0),
(@GUID, 18, -4635.155, -928.66516, 738.53265, 100, 0, 0, 0),
(@GUID, 19, -4610.8203, -917.36115, 706.52185, 100, 0, 0, 0),
(@GUID, 20, -4589.9937, -901.8464, 676.8065, 100, 0, 0, 0),
(@GUID, 21, -4571.6274, -896.23755, 651.8381, 100, 0, 0, 0),
(@GUID, 22, -4552.3877, -896.7822, 628.45575, 100, 0, 0, 0),
(@GUID, 23, -4536.9478, -902.57904, 610.99786, 100, 0, 0, 0),
(@GUID, 24, -4529.6235, -901.6709, 601.4431, 100, 0, 0, 0),
(@GUID, 25, -4536.9478, -902.57904, 610.99786, 100, 0, 0, 0),
(@GUID, 26, -4552.3877, -896.7822, 628.45575, 100, 0, 0, 0),
(@GUID, 27, -4571.6274, -896.23755, 651.8381, 100, 0, 0, 0),
(@GUID, 28, -4589.9937, -901.8464, 676.8065, 100, 0, 0, 0),
(@GUID, 29, -4610.8203, -917.36115, 706.52185, 100, 0, 0, 0),
(@GUID, 30, -4635.155, -928.66516, 738.53265, 100, 0, 0, 0),
(@GUID, 31, -4653.0566, -931.1431, 758.7995, 100, 0, 0, 0),
(@GUID, 32, -4671.4, -939.439, 777.1056, 100, 0, 0, 0),
(@GUID, 33, -4693.6045, -938.3761, 788.2069, 100, 0, 0, 0),
(@GUID, 34, -4709.4478, -932.53546, 794.318, 100, 0, 0, 0),
(@GUID, 35, -4736.275, -907.2883, 797.55206, 100, 0, 0, 0),
(@GUID, 36, -4756.9194, -896.874, 801.36066, 100, 0, 0, 0),
(@GUID, 37, -4777.106, -899.6929, 814.4335, 100, 0, 0, 0),
(@GUID, 38, -4804.5757, -902.56226, 829.05255, 100, 0, 0, 0),
(@GUID, 39, -4824.6865, -910.1261, 830.9742, 100, 0, 0, 0),
(@GUID, 40, -4841.64, -924.486, 844.2806, 100, 0, 0, 0),
(@GUID, 41, -4852.965, -950.44183, 845.39453, 100, 0, 0, 0),
(@GUID, 42, -4852.991, -981.2694, 848.6763, 100, 0, 0, 0),
(@GUID, 43, -4845.493, -988.7001, 858.1719, 100, 0, 0, 0),
(@GUID, 44, -4833.0835, -986.98926, 873.28973, 100, 0, 0, 0),
(@GUID, 45, -4825.008, -988.94196, 880.40765, 100, 0, 0, 0),
(@GUID, 46, -4808.791, -991.8394, 890.75214, 100, 0, 0, 0);
-- Full: 0x2045FC00000576C000000D0002596BC7 | Low: 39414727
-- .go xyz -4801.888 -996.84375 893.2265
-- Pathing for Ironforge Mountaineer Entry: 727
SET @GUID := 190197;
UPDATE `creature` SET `wander_distance`=0, `movement_type`=2, `position_x`=-4746.222, `position_y`=-1648.0065, `position_z`=503.449 WHERE `guid`=@GUID;
DELETE FROM `creature_movement` WHERE `id`=@GUID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@GUID, 1, -4746.222, -1648.0065, 503.449, 100, 0, 0, 11),
(@GUID, 2, -4722.9995, -1651.5371, 503.77844, 100, 0, 0, 0),
(@GUID, 3, -4698.264, -1650.2405, 503.5403, 100, 0, 0, 0),
(@GUID, 4, -4671.6104, -1650.7289, 503.7488, 100, 0, 0, 0),
(@GUID, 5, -4653.098, -1650.5233, 504.13358, 100, 0, 0, 0),
(@GUID, 6, -4626.28, -1651.3014, 504.2564, 100, 0, 0, 0),
(@GUID, 7, -4611.0566, -1648.4032, 503.5677, 100, 0, 0, 0),
(@GUID, 8, -4599.7915, -1641.667, 503.43652, 100, 0, 0, 0),
(@GUID, 9, -4585.3545, -1633.8992, 503.43652, 100, 0, 0, 0),
(@GUID, 10, -4573.834, -1631.8954, 503.44086, 100, 0, 0, 0),
(@GUID, 11, -4562.141, -1632.0316, 503.62018, 100, 1000, 0, 0),
(@GUID, 12, -4573.834, -1631.8954, 503.44086, 100, 0, 0, 0),
(@GUID, 13, -4585.3545, -1633.8992, 503.43652, 100, 0, 0, 0),
(@GUID, 14, -4599.7915, -1641.667, 503.43652, 100, 0, 0, 0),
(@GUID, 15, -4611.0566, -1648.4032, 503.5677, 100, 0, 0, 0),
(@GUID, 16, -4626.28, -1651.3014, 504.2564, 100, 0, 0, 0),
(@GUID, 17, -4653.098, -1650.5233, 504.13358, 100, 0, 0, 0),
(@GUID, 18, -4671.6104, -1650.7289, 503.7488, 100, 0, 0, 0),
(@GUID, 19, -4698.264, -1650.2405, 503.5403, 100, 0, 0, 0),
(@GUID, 20, -4722.9995, -1651.5371, 503.77844, 100, 0, 0, 0);
-- Full: 0x2045FC000000B5C000000D000CD96BC7 | Low: 215575495
-- .go xyz -4746.222 -1648.0065 503.449
-- Pathing for Mounted Ironforge Mountaineer Entry: 12996
SET @GUID := 190235;
UPDATE `creature` SET `wander_distance`=0, `movement_type`=2, `position_x`=-4517.0854, `position_y`=-1704.9795, `position_z`=507.90448 WHERE `guid`=@GUID;
DELETE FROM `creature_movement` WHERE `id`=@GUID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@GUID, 1, -4517.0854, -1704.9795, 507.90448, 100, 0, 0, 0),
(@GUID, 2, -4522.7417, -1694.5902, 506.67007, 100, 0, 0, 0),
(@GUID, 3, -4527.538, -1678.833, 504.65884, 100, 0, 0, 0),
(@GUID, 4, -4522.3916, -1665.2448, 504.68622, 100, 0, 0, 0),
(@GUID, 5, -4509.4995, -1639.0359, 504.9057, 100, 0, 0, 0),
(@GUID, 6, -4495.5674, -1632.1979, 503.39417, 100, 0, 0, 0),
(@GUID, 7, -4481.349, -1624.5381, 498.87976, 100, 0, 0, 0),
(@GUID, 8, -4476.082, -1615.9696, 496.0509, 100, 0, 0, 0),
(@GUID, 9, -4471.422, -1606.7076, 493.3136, 100, 0, 0, 0),
(@GUID, 10, -4460.7876, -1594.3225, 489.94305, 100, 0, 0, 0),
(@GUID, 11, -4451.252, -1580.1163, 487.96478, 100, 0, 0, 0),
(@GUID, 12, -4438.871, -1565.6957, 483.90176, 100, 0, 0, 0),
(@GUID, 13, -4425.0005, -1556.5118, 479.42496, 100, 0, 0, 0),
(@GUID, 14, -4414.128, -1543.6952, 477.4777, 100, 0, 0, 0),
(@GUID, 15, -4408.401, -1528.4232, 477.8348, 100, 0, 0, 0),
(@GUID, 16, -4404.4478, -1517.2662, 479.73032, 100, 0, 0, 0),
(@GUID, 17, -4398.0923, -1508.6329, 479.38885, 100, 0, 0, 0),
(@GUID, 18, -4389.336, -1515.6909, 470.41132, 100, 0, 0, 0),
(@GUID, 19, -4398.0923, -1508.6329, 479.38885, 100, 0, 0, 0),
(@GUID, 20, -4404.4478, -1517.2662, 479.73032, 100, 0, 0, 0),
(@GUID, 21, -4408.401, -1528.4232, 477.8348, 100, 0, 0, 0),
(@GUID, 22, -4414.128, -1543.6952, 477.4777, 100, 0, 0, 0),
(@GUID, 23, -4425.0005, -1556.5118, 479.42496, 100, 0, 0, 0),
(@GUID, 24, -4438.871, -1565.6957, 483.90176, 100, 0, 0, 0),
(@GUID, 25, -4451.252, -1580.1163, 487.96478, 100, 0, 0, 0),
(@GUID, 26, -4460.7876, -1594.3225, 489.94305, 100, 0, 0, 0),
(@GUID, 27, -4471.422, -1606.7076, 493.3136, 100, 0, 0, 0),
(@GUID, 28, -4476.082, -1615.9696, 496.0509, 100, 0, 0, 0),
(@GUID, 29, -4481.349, -1624.5381, 498.87976, 100, 0, 0, 0),
(@GUID, 30, -4495.5674, -1632.1979, 503.39417, 100, 0, 0, 0),
(@GUID, 31, -4509.4995, -1639.0359, 504.9057, 100, 0, 0, 0),
(@GUID, 32, -4522.3916, -1665.2448, 504.68622, 100, 0, 0, 0),
(@GUID, 33, -4527.538, -1678.833, 504.65884, 100, 0, 0, 0),
(@GUID, 34, -4522.7417, -1694.5902, 506.67007, 100, 0, 0, 0);
-- Full: 0x2045FC00000CB10000000D0000596BC5 | Low: 5860293
-- .go xyz -4517.0854 -1704.9795 507.90448
-- Pathing for Mounted Ironforge Mountaineer Entry: 12996
SET @GUID := 190234;
UPDATE `creature` SET `wander_distance`=0, `movement_type`=2, `position_x`=-4791.7056, `position_y`=-1669.0256, `position_z`=503.39114 WHERE `guid`=@GUID;
DELETE FROM `creature_movement` WHERE `id`=@GUID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@GUID, 1, -4791.7056, -1669.0256, 503.39114, 100, 0, 0, 0),
(@GUID, 2, -4791.8384, -1658.4664, 504.4534, 100, 0, 0, 0),
(@GUID, 3, -4785.26, -1648.2551, 505.05814, 100, 0, 0, 0),
(@GUID, 4, -4777.6704, -1640.8522, 503.96463, 100, 0, 0, 0),
(@GUID, 5, -4765.7026, -1633.3943, 503.574, 100, 0, 0, 0),
(@GUID, 6, -4758.079, -1632.1838, 503.6323, 100, 0, 0, 0),
(@GUID, 7, -4745.5903, -1631.477, 504.00266, 100, 0, 0, 0),
(@GUID, 8, -4733.1113, -1631.4094, 503.79114, 100, 0, 0, 0),
(@GUID, 9, -4720.28, -1632.5443, 503.21204, 100, 0, 0, 0),
(@GUID, 10, -4707.013, -1631.7886, 503.46204, 100, 0, 0, 0),
(@GUID, 11, -4694.465, -1633.2122, 503.61975, 100, 0, 0, 0),
(@GUID, 12, -4671.1294, -1631.6708, 503.50696, 100, 0, 0, 0),
(@GUID, 13, -4652.4507, -1631.3882, 503.46365, 100, 0, 0, 0),
(@GUID, 14, -4632.746, -1633.525, 503.44684, 100, 0, 0, 0),
(@GUID, 15, -4612.1104, -1631.7704, 503.59195, 100, 0, 0, 0),
(@GUID, 16, -4586.936, -1630.1913, 503.31586, 100, 0, 0, 0),
(@GUID, 17, -4575.1353, -1625.4163, 503.44086, 100, 0, 0, 0),
(@GUID, 18, -4561.0615, -1619.1696, 504.11212, 100, 0, 0, 0),
(@GUID, 19, -4547.2485, -1607.7008, 503.53082, 100, 0, 0, 0),
(@GUID, 20, -4533.7383, -1600.0537, 504.16534, 100, 0, 0, 0),
(@GUID, 21, -4521.9673, -1601.77, 503.92667, 100, 0, 0, 0),
(@GUID, 22, -4518.5933, -1613.9573, 504.41397, 100, 0, 0, 0),
(@GUID, 23, -4519.5913, -1625.0092, 504.67667, 100, 0, 0, 0),
(@GUID, 24, -4527.1553, -1634.5603, 504.57806, 100, 0, 0, 0),
(@GUID, 25, -4537.003, -1633.5338, 504.48758, 100, 0, 0, 0),
(@GUID, 26, -4544.92, -1630.1848, 505.3416, 100, 0, 0, 0),
(@GUID, 27, -4552.1396, -1627.6139, 505.13702, 100, 0, 0, 0),
(@GUID, 28, -4558.0576, -1630.4052, 503.9405, 100, 0, 0, 0),
(@GUID, 29, -4563.645, -1636.717, 503.449, 100, 0, 0, 0),
(@GUID, 30, -4568.632, -1642.6063, 503.43652, 100, 0, 0, 0),
(@GUID, 31, -4573.396, -1648.3518, 503.43164, 100, 0, 0, 0),
(@GUID, 32, -4584.8384, -1650.1096, 503.9629, 100, 0, 0, 0),
(@GUID, 33, -4604.9595, -1652.2645, 504.2403, 100, 0, 0, 0),
(@GUID, 34, -4627.976, -1649.7075, 503.87653, 100, 0, 0, 0),
(@GUID, 35, -4652.8916, -1650.0426, 504.0513, 100, 0, 0, 0),
(@GUID, 36, -4673.2, -1652.7721, 504.14236, 100, 0, 0, 0),
(@GUID, 37, -4684.272, -1651.4781, 503.689, 100, 0, 0, 0),
(@GUID, 38, -4707.2056, -1649.0565, 503.4806, 100, 0, 0, 0),
(@GUID, 39, -4719.713, -1652.2222, 504.19006, 100, 0, 0, 0),
(@GUID, 40, -4736.4233, -1656.2098, 504.25662, 100, 0, 0, 0),
(@GUID, 41, -4748.8604, -1658.7986, 504.5674, 100, 0, 0, 0),
(@GUID, 42, -4754.4253, -1665.556, 503.9805, 100, 0, 0, 0),
(@GUID, 43, -4766.01, -1673.6823, 503.449, 100, 0, 0, 0),
(@GUID, 44, -4780.7007, -1676.232, 503.449, 100, 0, 0, 0);
-- Full: 0x2045FC00000CB10000000D0000596BC7 | Low: 5860295
-- .go xyz -4791.7056 -1669.0256 503.39114
-- Pathing for Mounted Ironforge Mountaineer Entry: 12996
SET @GUID := 190233;
UPDATE `creature` SET `wander_distance`=0, `movement_type`=2, `position_x`=-4886.575, `position_y`=-1688.2369, `position_z`=503.77567 WHERE `guid`=@GUID;
DELETE FROM `creature_movement` WHERE `id`=@GUID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@GUID, 1, -4886.575, -1688.2369, 503.77567, 100, 0, 0, 0),
(@GUID, 2, -4895.2847, -1691.3798, 503.67093, 100, 0, 0, 0),
(@GUID, 3, -4900.525, -1693.0093, 503.94342, 100, 0, 0, 0),
(@GUID, 4, -4905.663, -1696.631, 504.0003, 100, 0, 0, 0),
(@GUID, 5, -4912.0586, -1702.1334, 503.82117, 100, 0, 0, 0),
(@GUID, 6, -4917.932, -1708.7216, 503.44836, 100, 0, 0, 0),
(@GUID, 7, -4923.633, -1712.2252, 503.44836, 100, 0, 0, 0),
(@GUID, 8, -4932.1885, -1713.2589, 503.44836, 100, 0, 0, 0),
(@GUID, 9, -4939.7876, -1713.402, 503.40686, 100, 0, 0, 0),
(@GUID, 10, -4950.5913, -1717.0509, 503.40686, 100, 0, 0, 0),
(@GUID, 11, -4956.384, -1721.3456, 503.6095, 100, 0, 0, 0),
(@GUID, 12, -4957.8125, -1728.5419, 504.6444, 100, 0, 0, 0),
(@GUID, 13, -4955.4688, -1733.1228, 504.0631, 100, 0, 0, 0),
(@GUID, 14, -4935.846, -1734.2883, 503.41135, 100, 0, 0, 0),
(@GUID, 15, -4929.563, -1727.6782, 503.44836, 100, 0, 0, 0),
(@GUID, 16, -4922.609, -1724.9127, 503.44836, 100, 0, 0, 0),
(@GUID, 17, -4918.151, -1723.7677, 503.44836, 100, 0, 0, 0),
(@GUID, 18, -4915.067, -1719.8855, 503.44836, 100, 0, 0, 0),
(@GUID, 19, -4915.3984, -1714.6189, 503.44836, 100, 0, 0, 0),
(@GUID, 20, -4913.983, -1709.0002, 503.44836, 100, 0, 0, 0),
(@GUID, 21, -4909.814, -1703.061, 503.51868, 100, 0, 0, 0),
(@GUID, 22, -4905.7153, -1699.8053, 503.6275, 100, 0, 0, 0),
(@GUID, 23, -4900.6807, -1696.2528, 503.66656, 100, 0, 0, 0),
(@GUID, 24, -4895.9434, -1693.8094, 503.699, 100, 0, 0, 0),
(@GUID, 25, -4889.807, -1692.1844, 503.699, 100, 0, 0, 0),
(@GUID, 26, -4881.852, -1690.4843, 503.58377, 100, 0, 0, 0),
(@GUID, 27, -4876.6304, -1690.9202, 503.449, 100, 0, 0, 0),
(@GUID, 28, -4868.3325, -1691.2535, 503.449, 100, 0, 0, 0),
(@GUID, 29, -4862.183, -1693.449, 503.449, 100, 0, 0, 0),
(@GUID, 30, -4851.4126, -1695.7855, 503.574, 100, 0, 0, 0),
(@GUID, 31, -4845.246, -1697.9027, 504.1348, 100, 0, 0, 0),
(@GUID, 32, -4834.723, -1695.1228, 504.07205, 100, 0, 0, 0),
(@GUID, 33, -4825.3, -1693.4718, 504.0342, 100, 0, 0, 0),
(@GUID, 34, -4818.1006, -1690.8444, 503.66287, 100, 0, 0, 0),
(@GUID, 35, -4809.7954, -1689.1387, 503.58304, 100, 0, 0, 0),
(@GUID, 36, -4802.6587, -1689.3082, 503.4556, 100, 0, 0, 0),
(@GUID, 37, -4794.06, -1689.9512, 503.449, 100, 0, 0, 0),
(@GUID, 38, -4786.557, -1694.3698, 503.449, 100, 0, 0, 0),
(@GUID, 39, -4781.2056, -1693.0009, 503.449, 100, 0, 0, 0),
(@GUID, 40, -4774.9517, -1689.5743, 503.449, 100, 0, 0, 0),
(@GUID, 41, -4769.3975, -1682.3502, 503.449, 100, 0, 0, 0),
(@GUID, 42, -4769.3896, -1673.9938, 503.449, 100, 0, 0, 0),
(@GUID, 43, -4769.9478, -1665.94, 503.449, 100, 0, 0, 0),
(@GUID, 44, -4775.4424, -1661.9603, 503.449, 100, 0, 0, 0),
(@GUID, 45, -4783.3696, -1664.945, 503.449, 100, 0, 0, 0),
(@GUID, 46, -4784.3335, -1672.2015, 503.449, 100, 0, 0, 0),
(@GUID, 47, -4782.6416, -1679.4795, 503.449, 100, 0, 0, 0),
(@GUID, 48, -4780.944, -1684.7219, 503.449, 100, 0, 0, 0),
(@GUID, 49, -4782.4995, -1690.1699, 503.449, 100, 0, 0, 0),
(@GUID, 50, -4788.104, -1689.9176, 503.449, 100, 0, 0, 0),
(@GUID, 51, -4793.462, -1688.0452, 503.449, 100, 0, 0, 0),
(@GUID, 52, -4801.9204, -1686.4275, 503.449, 100, 0, 0, 0),
(@GUID, 53, -4809.6475, -1687.0825, 503.449, 100, 0, 0, 0),
(@GUID, 54, -4818.291, -1688.4606, 503.449, 100, 0, 0, 0),
(@GUID, 55, -4825.6484, -1691.3611, 503.72488, 100, 0, 0, 0),
(@GUID, 56, -4832.9233, -1693.7402, 503.88528, 100, 0, 0, 0),
(@GUID, 57, -4841.5596, -1694.594, 503.86282, 100, 0, 0, 0),
(@GUID, 58, -4852.1797, -1692.0907, 503.3633, 100, 0, 0, 0),
(@GUID, 59, -4863.2793, -1689.2721, 503.449, 100, 0, 0, 0),
(@GUID, 60, -4868.1016, -1686.0604, 503.449, 100, 0, 0, 0),
(@GUID, 61, -4878.333, -1686.8193, 503.4683, 100, 0, 0, 0);
-- Full: 0x2045FC00000CB10000000D0000596BC6 | Low: 5860294
-- .go xyz -4886.575 -1688.2369 503.77567
-- Pathing for Mounted Ironforge Mountaineer Entry: 12996
SET @GUID := 190232;
UPDATE `creature` SET `wander_distance`=0, `movement_type`=2, `position_x`=-5000.774, `position_y`=-1658.2255, `position_z`=499.60397 WHERE `guid`=@GUID;
DELETE FROM `creature_movement` WHERE `id`=@GUID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@GUID, 1, -5000.774, -1658.2255, 499.60397, 100, 0, 0, 0),
(@GUID, 2, -5011.652, -1653.6976, 499.43967, 100, 0, 0, 0),
(@GUID, 3, -5025.504, -1655.161, 498.8508, 100, 0, 0, 0),
(@GUID, 4, -5034.333, -1660.293, 498.36526, 100, 0, 0, 0),
(@GUID, 5, -5045.923, -1664.1525, 498.3445, 100, 0, 0, 0),
(@GUID, 6, -5055.5835, -1668.751, 498.08572, 100, 0, 0, 0),
(@GUID, 7, -5067.2817, -1672.7701, 497.96072, 100, 0, 0, 0),
(@GUID, 8, -5075.994, -1672.7192, 497.96072, 100, 0, 0, 0),
(@GUID, 9, -5083.4844, -1668.7458, 497.96072, 100, 0, 0, 0),
(@GUID, 10, -5089.7744, -1660.9008, 498.13434, 100, 0, 0, 0),
(@GUID, 11, -5093.73, -1655.1252, 498.39655, 100, 0, 0, 0),
(@GUID, 12, -5101.2324, -1649.3091, 498.83978, 100, 0, 0, 0),
(@GUID, 13, -5111.6084, -1647.223, 498.67572, 100, 0, 0, 0),
(@GUID, 14, -5121.757, -1646.9531, 498.13422, 100, 0, 0, 0),
(@GUID, 15, -5126.9766, -1645.0563, 498.28998, 100, 0, 0, 0),
(@GUID, 16, -5137.2905, -1640.9326, 498.3105, 100, 0, 0, 0),
(@GUID, 17, -5141.6816, -1638.9453, 498.52338, 100, 0, 0, 0),
(@GUID, 18, -5146.857, -1633.4591, 500.216, 100, 0, 0, 0),
(@GUID, 19, -5153.517, -1627.9819, 501.88852, 100, 0, 0, 0),
(@GUID, 20, -5162.238, -1628.0187, 500.26376, 100, 0, 0, 0),
(@GUID, 21, -5171.2397, -1627.81, 498.9489, 100, 0, 0, 0),
(@GUID, 22, -5178.266, -1630.9082, 498.13422, 100, 0, 0, 0),
(@GUID, 23, -5188.62, -1631.1412, 498.00922, 100, 0, 0, 0),
(@GUID, 24, -5196.3257, -1628.08, 497.9521, 100, 0, 0, 0),
(@GUID, 25, -5204.547, -1622.2366, 498.22977, 100, 0, 0, 0),
(@GUID, 26, -5211.098, -1617.5515, 498.06644, 100, 0, 0, 0),
(@GUID, 27, -5215.8423, -1609.7766, 498.08572, 100, 0, 0, 0),
(@GUID, 28, -5219.153, -1602.7004, 497.96072, 100, 0, 0, 0),
(@GUID, 29, -5219.643, -1593.7451, 497.96072, 100, 0, 0, 0),
(@GUID, 30, -5225.533, -1583.7825, 497.96072, 100, 0, 0, 0),
(@GUID, 31, -5235.7646, -1578.4218, 497.96072, 100, 0, 0, 0),
(@GUID, 32, -5249.0503, -1585.1711, 497.96072, 100, 0, 0, 0),
(@GUID, 33, -5257.9087, -1605.7554, 497.96072, 100, 0, 0, 0),
(@GUID, 34, -5252.2686, -1622.0353, 497.96072, 100, 0, 0, 0),
(@GUID, 35, -5239.319, -1625.1411, 497.96072, 100, 0, 0, 0),
(@GUID, 36, -5223.315, -1625.0021, 497.96072, 100, 0, 0, 0),
(@GUID, 37, -5212.882, -1625.822, 497.96072, 100, 0, 0, 0),
(@GUID, 38, -5203.069, -1631.6147, 497.96072, 100, 0, 0, 0),
(@GUID, 39, -5187.9395, -1637.4498, 497.96072, 100, 0, 0, 0),
(@GUID, 40, -5177.231, -1638.8013, 497.96072, 100, 0, 0, 0),
(@GUID, 41, -5172.986, -1636.4067, 497.96072, 100, 0, 0, 0),
(@GUID, 42, -5165.975, -1634.8881, 498.25995, 100, 0, 0, 0),
(@GUID, 43, -5157.221, -1636.243, 498.41864, 100, 0, 0, 0),
(@GUID, 44, -5149.7256, -1639.0653, 498.38397, 100, 0, 0, 0),
(@GUID, 45, -5141.638, -1645.116, 497.9079, 100, 0, 0, 0),
(@GUID, 46, -5131.433, -1652.4907, 498.00922, 100, 0, 0, 0),
(@GUID, 47, -5115.699, -1656.448, 498.00922, 100, 0, 0, 0),
(@GUID, 48, -5107.9834, -1655.2192, 498.00922, 100, 0, 0, 0),
(@GUID, 49, -5097.3066, -1662.7745, 498.00934, 100, 0, 0, 0),
(@GUID, 50, -5090.0547, -1671.844, 497.96072, 100, 0, 0, 0),
(@GUID, 51, -5078.694, -1679.289, 497.96072, 100, 0, 0, 0),
(@GUID, 52, -5065.5034, -1681.8934, 497.96072, 100, 0, 0, 0),
(@GUID, 53, -5048.594, -1679.6709, 497.96072, 100, 0, 0, 0),
(@GUID, 54, -5023.8833, -1680.4602, 497.96072, 100, 0, 0, 0),
(@GUID, 55, -5016.0073, -1691.1522, 497.96072, 100, 0, 0, 0),
(@GUID, 56, -5012.4985, -1704.1886, 497.96072, 100, 0, 0, 0),
(@GUID, 57, -5003.6646, -1710.2974, 498.62723, 100, 0, 0, 0),
(@GUID, 58, -4995.862, -1710.013, 501.79874, 100, 0, 0, 0),
(@GUID, 59, -4992.3774, -1705.6025, 502.1857, 100, 0, 0, 0),
(@GUID, 60, -4991.9326, -1697.2467, 501.11905, 100, 0, 0, 0),
(@GUID, 61, -4996.673, -1688.3728, 500.11954, 100, 0, 0, 0),
(@GUID, 62, -4996.809, -1678.7013, 499.99503, 100, 0, 0, 0),
(@GUID, 63, -4997.324, -1667.16, 499.4274, 100, 0, 0, 0);
-- Full: 0x2045FC00000CB10000000D0000D96BC5 | Low: 14248901
-- .go xyz -5000.774 -1658.2255 499.60397
-- Pathing for Ironforge Guard Entry: 5595
SET @GUID := 190191;
UPDATE `creature` SET `wander_distance`=0, `movement_type`=2, `position_x`=-4833.3306, `position_y`=-1694.9738, `position_z`=504.03348 WHERE `guid`=@GUID;
DELETE FROM `creature_movement` WHERE `id`=@GUID;
INSERT INTO `creature_movement` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`waittime`,`wander_distance`,`script_id`) VALUES
(@GUID, 1, -4833.3306, -1694.9738, 504.03348, 100, 0, 0, 0),
(@GUID, 2, -4850.2505, -1694.5311, 503.574, 100, 0, 0, 0),
(@GUID, 3, -4865.31, -1688.7905, 503.449, 100, 0, 0, 0),
(@GUID, 4, -4863.746, -1675.9377, 503.449, 100, 0, 0, 0),
(@GUID, 5, -4865.35, -1659.2902, 503.47476, 100, 0, 0, 0),
(@GUID, 6, -4867.9556, -1629.7809, 503.47983, 100, 0, 0, 0),
(@GUID, 7, -4868.466, -1615.3053, 504.27377, 100, 0, 0, 0),
(@GUID, 8, -4867.9556, -1629.7809, 503.47983, 100, 0, 0, 0),
(@GUID, 9, -4865.35, -1659.2902, 503.47476, 100, 0, 0, 0),
(@GUID, 10, -4863.746, -1675.9377, 503.449, 100, 0, 0, 0),
(@GUID, 11, -4865.31, -1688.7905, 503.449, 100, 0, 0, 0),
(@GUID, 12, -4879.9453, -1688.1132, 503.46902, 100, 0, 0, 0),
(@GUID, 13, -4899.7397, -1695.0011, 503.61136, 100, 0, 0, 0),
(@GUID, 14, -4922.209, -1715.6864, 503.44836, 100, 0, 0, 0),
(@GUID, 15, -4936.632, -1737.9797, 503.41135, 100, 0, 0, 0),
(@GUID, 16, -4922.209, -1715.6864, 503.44836, 100, 0, 0, 0),
(@GUID, 17, -4899.7397, -1695.0011, 503.61136, 100, 0, 0, 0),
(@GUID, 18, -4879.9453, -1688.1132, 503.46902, 100, 0, 0, 0),
(@GUID, 19, -4865.31, -1688.7905, 503.449, 100, 0, 0, 0),
(@GUID, 20, -4850.2505, -1694.5311, 503.574, 100, 0, 0, 0),
(@GUID, 21, -4833.3306, -1694.9738, 504.03348, 100, 0, 0, 0),
(@GUID, 22, -4820.9697, -1691.262, 503.71292, 100, 0, 0, 0),
(@GUID, 23, -4806.56, -1688.021, 503.449, 100, 0, 0, 0),
(@GUID, 24, -4798.2925, -1686.9425, 503.449, 100, 0, 0, 0),
(@GUID, 25, -4790.1025, -1689.7168, 503.449, 100, 0, 0, 0),
(@GUID, 26, -4798.2925, -1686.9425, 503.449, 100, 0, 0, 0),
(@GUID, 27, -4806.56, -1688.021, 503.449, 100, 0, 0, 0),
(@GUID, 28, -4820.9697, -1691.262, 503.71292, 100, 0, 0, 0);
-- Full: 0x2045FC00000576C000000D0003D96BC7 | Low: 64580551
-- .go xyz -4833.3306 -1694.9738 504.03348
-- Ironforge Mountaineer and Ironforge Guard should share spawns in Ironforge Airport
UPDATE `creature` SET `id2` = 727 WHERE `guid` IN (190204, 190203, 190202, 190207, 190205, 190208, 190206, 190210, 190211, 190212, 190213);
UPDATE `creature` SET `id2` = 5595 WHERE `guid` IN (190189, 190190, 190192, 190195, 190196, 190194, 190198, 190193, 190191, 190200, 190201, 190199, 190209);
-- Delete duplicate rabbit
DELETE FROM `creature` WHERE `guid`=190186;
-- Correct emote for Ironforge Mountainer
UPDATE `creature_addon` SET `emote_state`=28 WHERE `guid`=190201;
-- Delete emote waypoints for Ironforge Guard
DELETE FROM `creature_movement` WHERE `id`=190209;
DELETE FROM `creature_movement_scripts` WHERE `id`=21;
UPDATE `creature` SET `wander_distance`=0, `movement_type`=0 WHERE `guid`=190209;
-- Emote 1 for Gnome Engineer
DELETE FROM `creature_movement` WHERE `id`=190241;
DELETE FROM `creature_movement_scripts` WHERE `id`=22;
INSERT INTO `creature_addon` (`guid`,`emote_state`) VALUES (190241, 1);
UPDATE `creature` SET `wander_distance`=0, `movement_type`=0 WHERE `guid`=190241;
-- Emote 4 for Holdout Warrior
DELETE FROM `creature_movement` WHERE `id`=190229;
DELETE FROM `creature_movement_scripts` WHERE `id`=23;
INSERT INTO `creature_addon` (`guid`,`emote_state`) VALUES (190229, 4);
UPDATE `creature` SET `wander_distance`=0, `movement_type`=0 WHERE `guid`=190229;
-- Emote 21 for Peria Lamenur
DELETE FROM `creature_movement` WHERE `id`=190228;
DELETE FROM `creature_movement_scripts` WHERE `id`=24;
INSERT INTO `creature_addon` (`guid`,`emote_state`) VALUES (190228, 21);
UPDATE `creature` SET `wander_distance`=0, `movement_type`=0 WHERE `guid`=190228;
-- Delete custom troll spawns
DELETE FROM `creature` WHERE `guid` IN (190225, 190227, 190226, 190223, 190224, 190222);
DELETE FROM `creature_linking` WHERE `guid` IN (190225, 190227, 190226, 190223, 190224, 190222);
DELETE FROM `creature_groups` WHERE `member_guid` IN (190225, 190227, 190226, 190223, 190224, 190222);
-- Delete custom troll waypoints
DELETE FROM `creature_movement` WHERE `id`=190222;
-- Add random movement to two of the three mountain bears
UPDATE `creature` SET `wander_distance` = 3, `movement_type` = 1 WHERE `guid` IN (190245, 190246);
-- End of migration.
END IF;
END??
DELIMITER ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;
Reference in New Issue View Git Blame Copy Permalink