ratkosrb
4bad44863a
Why did you use Season of Mastery data, Nicky? I explicitly warned you multiple times to be careful not to use 1.14 data, because new herb and ore spawns have been added. Yet this migration adds spawns seen only in 1.14 sniffs, not seen a single time in 1.13 and 2.5 sniffs, despite the dungeon being cleared multiple times in those sniffs, meaning those are Season of Mastery exclusive spawns.
23 lines
3.4 KiB
SQL
23 lines
3.4 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`='20230618081042');
|
|
IF v=0 THEN
|
|
INSERT INTO `migrations` VALUES ('20230618081042');
|
|
-- Add your query below.
|
|
|
|
|
|
-- Remove Custom Spawns
|
|
DELETE FROM `gameobject` WHERE `guid` IN (12217, 12219, 12224, 12227, 12233, 12235, 12236, 12242, 12243, 12248, 12262, 12263, 12268, 12291, 12300, 12304, 12317, 12319, 12322, 12325, 12332, 12333, 12579, 13233, 1374, 1384, 1396, 1456, 1467, 1491, 1497, 15156, 1537, 15789, 15812, 15821, 15841, 15842, 15845, 15870, 15873, 15889, 15896, 15918, 15939, 15940, 16089, 1612, 16136, 16178, 16191, 16194, 16202, 16254, 16256, 16289, 16326, 16332, 16333, 16337, 16343, 16358, 16393, 16411, 16415, 16416, 16417, 16418, 16419, 16420, 16421, 16422, 16423, 16424, 16425, 16426, 16429, 16431, 16433, 16437, 16438, 16442, 16443, 16445, 16447, 16448, 16521, 1686, 1690, 1740, 18952, 18961, 18974, 19023, 19026, 19032, 19081, 19133, 19202, 1949, 19522, 19667, 19706, 19725, 19737, 19758, 19816, 1999, 2093, 2197, 2221, 2255, 2279, 2370, 2376, 2398, 2402, 2521, 2532, 2563, 2596, 2656, 2710, 27441, 2761, 2769, 27714, 2799, 2851, 29160, 29188, 2919, 2984, 3004, 30459, 3051, 3057, 3120, 3181, 32294, 3269, 32894, 3343, 3345, 3401, 34113, 3457, 3522, 3541, 3561, 3571, 3687, 3689, 3698, 374472, 3748, 3800, 4009, 40521, 42048, 4224, 4269, 4281, 4289, 429022, 429023, 429024, 429025, 429026, 429027, 429028, 429029, 4294, 4302, 4325, 4327, 43382, 4353, 4372, 4373, 4376, 4399, 4401, 4415, 4420, 4496, 45847, 46567, 50003, 52650, 55500, 56133, 56192, 57743, 57796, 57818, 7517, 7650, 7727, 7819, 7840, 7842, 7874, 7946, 8019, 8024, 8050, 8056, 8058, 8222, 8247, 8342, 8465, 8522, 8533, 8648, 8689, 8797, 8886, 8917, 9154, 9157, 9185, 997);
|
|
DELETE FROM `pool_gameobject` WHERE `guid` IN (12217, 12219, 12224, 12227, 12233, 12235, 12236, 12242, 12243, 12248, 12262, 12263, 12268, 12291, 12300, 12304, 12317, 12319, 12322, 12325, 12332, 12333, 12579, 13233, 1374, 1384, 1396, 1456, 1467, 1491, 1497, 15156, 1537, 15789, 15812, 15821, 15841, 15842, 15845, 15870, 15873, 15889, 15896, 15918, 15939, 15940, 16089, 1612, 16136, 16178, 16191, 16194, 16202, 16254, 16256, 16289, 16326, 16332, 16333, 16337, 16343, 16358, 16393, 16411, 16415, 16416, 16417, 16418, 16419, 16420, 16421, 16422, 16423, 16424, 16425, 16426, 16429, 16431, 16433, 16437, 16438, 16442, 16443, 16445, 16447, 16448, 16521, 1686, 1690, 1740, 18952, 18961, 18974, 19023, 19026, 19032, 19081, 19133, 19202, 1949, 19522, 19667, 19706, 19725, 19737, 19758, 19816, 1999, 2093, 2197, 2221, 2255, 2279, 2370, 2376, 2398, 2402, 2521, 2532, 2563, 2596, 2656, 2710, 27441, 2761, 2769, 27714, 2799, 2851, 29160, 29188, 2919, 2984, 3004, 30459, 3051, 3057, 3120, 3181, 32294, 3269, 32894, 3343, 3345, 3401, 34113, 3457, 3522, 3541, 3561, 3571, 3687, 3689, 3698, 374472, 3748, 3800, 4009, 40521, 42048, 4224, 4269, 4281, 4289, 429022, 429023, 429024, 429025, 429026, 429027, 429028, 429029, 4294, 4302, 4325, 4327, 43382, 4353, 4372, 4373, 4376, 4399, 4401, 4415, 4420, 4496, 45847, 46567, 50003, 52650, 55500, 56133, 56192, 57743, 57796, 57818, 7517, 7650, 7727, 7819, 7840, 7842, 7874, 7946, 8019, 8024, 8050, 8056, 8058, 8222, 8247, 8342, 8465, 8522, 8533, 8648, 8689, 8797, 8886, 8917, 9154, 9157, 9185, 997);
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
delimiter ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|