sindoring/moonwell-core-vanilla
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Files
development
moonwell-core-vanilla/sql/migrations/20230625113607_world.sql
T
NickTyrer 5a883aeca5 Add Missing Fish Pools - Wetlands (#1972)
2023-06-28 15:46:24 +01:00

249 lines
27 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`='20230625113607');
IF v=0 THEN
INSERT INTO `migrations` VALUES ('20230625113607');
-- Add your query below.
SET @OGUID = 35163;
SET @PTEMPLATE = 1944;
-- Wetlands
DELETE FROM `gameobject` WHERE `guid` IN (808, 811, 822, 823, 898, 961, 964, 965, 973, 977, 985, 986, 988, 989, 1012, 4679, 4773, 4775, 4860, 4993, 5012, 5021, 5032, 5033, 5071, 5074, 5097, 5119, 10705, 10949, 14625, 14626, 14627, 14722, 14852, 14902, 14903, 16616, 16716, 16734, 16744, 16766, 16773, 18157, 18165, 18169, 18172, 20337, 47369, 47372, 47373, 47382, 47391, 47393, 47394, 47395, 47396, 47398, 47403, 47404, 47517, 47518, 47519, 47526, 50323, 50324, 50325, 50326, 50332);
DELETE FROM `pool_gameobject` WHERE `guid` IN (808, 811, 822, 823, 898, 961, 964, 965, 973, 977, 985, 986, 988, 989, 1012, 4679, 4773, 4775, 4860, 4993, 5012, 5021, 5032, 5033, 5071, 5074, 5097, 5119, 10705, 10949, 14625, 14626, 14627, 14722, 14852, 14902, 14903, 16616, 16716, 16734, 16744, 16766, 16773, 18157, 18165, 18169, 18172, 20337, 47369, 47372, 47373, 47382, 47391, 47393, 47394, 47395, 47396, 47398, 47403, 47404, 47517, 47518, 47519, 47526, 50323, 50324, 50325, 50326, 50332);
DELETE FROM `pool_template` WHERE `entry` IN (SELECT `pool_entry` FROM `pool_gameobject` WHERE `guid` IN (808, 811, 822, 823, 898, 961, 964, 965, 973, 977, 985, 986, 988, 989, 1012, 4679, 4773, 4775, 4860, 4993, 5012, 5021, 5032, 5033, 5071, 5074, 5097, 5119, 10705, 10949, 14625, 14626, 14627, 14722, 14852, 14902, 14903, 16616, 16716, 16734, 16744, 16766, 16773, 18157, 18165, 18169, 18172, 20337, 47369, 47372, 47373, 47382, 47391, 47393, 47394, 47395, 47396, 47398, 47403, 47404, 47517, 47518, 47519, 47526, 50323, 50324, 50325, 50326, 50332));
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `animprogress`, `state`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
(@OGUID+1, 180664, 0, -3887.51, -837.013, 0, 2.32129, 0, 0, 0.91706, 0.398749, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+2, 180664, 0, -3884.81, -712.804, 0, -0.10472, 0, 0, 0.052336, -0.99863, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+3, 180664, 0, -3873.45, -634.351, 0, -0.837758, 0, 0, 0.406737, -0.913545, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+4, 180664, 0, -3843.22, -918.727, 0, -2.89725, 0, 0, 0.992546, -0.121869, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+5, 180664, 0, -3758.88, -608.091, 0, 2.56563, 0, 0, 0.95882, 0.284015, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+6, 180664, 0, -3710.44, -673.205, 0, 2.51327, 0, 0, 0.951057, 0.309017, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+7, 180664, 0, -3707.95, -631.876, 0, -0.925024, 0, 0, 0.446198, -0.894934, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+8, 180664, 0, -3649.69, -665.087, 0, 0.191986, 0, 0, 0.095846, 0.995396, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+9, 180664, 0, -3353.9, -975.253, 0, -0.349066, 0, 0, 0.173648, -0.984808, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+10, 180664, 0, -3262.99, -889.309, 0, -0.610865, 0, 0, 0.300706, -0.953717, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+11, 180664, 0, -3142.66, -901.367, 0, -2.79253, 0, 0, 0.984808, -0.173648, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+12, 180664, 0, -3070.82, -916.696, 0, -0.715585, 0, 0, 0.350207, -0.936672, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+13, 180664, 0, -3018.44, -941.133, 0, 2.51327, 0, 0, 0.951057, 0.309017, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+14, 180664, 0, -2904.7, -1007.43, 0, -0.418879, 0, 0, 0.207912, -0.978148, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+15, 180664, 0, -2869.85, -1038.07, 0, 1.62316, 0, 0, 0.725374, 0.688355, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+16, 180664, 0, -2755.3, -1128.21, 0, 2.56563, 0, 0, 0.95882, 0.284015, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+17, 180664, 0, -2721.1, -1163.18, 0, 1.97222, 0, 0, 0.833886, 0.551937, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+18, 180664, 0, -2704.53, -1210.83, 0, 2.14675, 0, 0, 0.878817, 0.477159, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+19, 180664, 0, -2681.61, -1279.36, 0, -2.46091, 0, 0, 0.942641, -0.333807, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+20, 180664, 0, -2672.18, -1451.32, 0, 1.81514, 0, 0, 0.788011, 0.615662, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+21, 180664, 0, -2625.05, -1536.17, 0, -3.12414, 0, 0, 0.999962, -0.008727, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+22, 180664, 0, -2576.34, -1586.48, 0, -1.72788, 0, 0, 0.760406, -0.649448, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+23, 180664, 0, -2460.01, -1757.19, 0, 2.51327, 0, 0, 0.951057, 0.309017, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+24, 180664, 0, -3359.63, -893.433, 0, 2.1293, 0, 0, 0.874619, 0.48481, 180, 180, 100, 0, 0, 0, 7, 10),
(@OGUID+25, 180664, 0, -3211.8, -891.612, 0, 2.74016, 0, 0, 0.979924, 0.19937, 180, 180, 100, 0, 0, 0, 7, 10),
(@OGUID+26, 180664, 0, -2489.85, -1712.92, 0, 2.40855, 0, 0, 0.93358, 0.358368, 180, 180, 100, 0, 0, 0, 7, 10),
(@OGUID+27, 180657, 0, -3887.51, -837.013, 0, 2.32129, 0, 0, 0.91706, 0.398749, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+28, 180657, 0, -3884.81, -712.804, 0, -0.10472, 0, 0, 0.052336, -0.99863, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+29, 180657, 0, -3873.45, -634.351, 0, -0.837758, 0, 0, 0.406737, -0.913545, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+30, 180657, 0, -3843.22, -918.727, 0, -2.89725, 0, 0, 0.992546, -0.121869, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+31, 180657, 0, -3758.88, -608.091, 0, 2.56563, 0, 0, 0.95882, 0.284015, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+32, 180657, 0, -3710.44, -673.205, 0, 2.51327, 0, 0, 0.951057, 0.309017, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+33, 180657, 0, -3707.95, -631.876, 0, -0.925024, 0, 0, 0.446198, -0.894934, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+34, 180657, 0, -3649.69, -665.087, 0, 0.191986, 0, 0, 0.095846, 0.995396, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+35, 180657, 0, -3353.9, -975.253, 0, -0.349066, 0, 0, 0.173648, -0.984808, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+36, 180657, 0, -3262.99, -889.309, 0, -0.610865, 0, 0, 0.300706, -0.953717, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+37, 180657, 0, -3142.66, -901.367, 0, -2.79253, 0, 0, 0.984808, -0.173648, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+38, 180657, 0, -3070.82, -916.696, 0, -0.715585, 0, 0, 0.350207, -0.936672, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+39, 180657, 0, -3018.44, -941.133, 0, 2.51327, 0, 0, 0.951057, 0.309017, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+40, 180657, 0, -2904.7, -1007.43, 0, -0.418879, 0, 0, 0.207912, -0.978148, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+41, 180657, 0, -2869.85, -1038.07, 0, 1.62316, 0, 0, 0.725374, 0.688355, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+42, 180657, 0, -2755.3, -1128.21, 0, 2.56563, 0, 0, 0.95882, 0.284015, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+43, 180657, 0, -2721.1, -1163.18, 0, 1.97222, 0, 0, 0.833886, 0.551937, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+44, 180657, 0, -2704.53, -1210.83, 0, 2.14675, 0, 0, 0.878817, 0.477159, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+45, 180657, 0, -2681.61, -1279.36, 0, -2.46091, 0, 0, 0.942641, -0.333807, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+46, 180657, 0, -2672.18, -1451.32, 0, 1.81514, 0, 0, 0.788011, 0.615662, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+47, 180657, 0, -2625.05, -1536.17, 0, -3.12414, 0, 0, 0.999962, -0.008727, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+48, 180657, 0, -2576.34, -1586.48, 0, -1.72788, 0, 0, 0.760406, -0.649448, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+49, 180657, 0, -2460.01, -1757.19, 0, 2.51327, 0, 0, 0.951057, 0.309017, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+50, 180657, 0, -3359.63, -893.433, 0, 2.1293, 0, 0, 0.874619, 0.48481, 180, 180, 100, 0, 0, 0, 7, 10),
(@OGUID+51, 180657, 0, -3211.8, -891.612, 0, 2.74016, 0, 0, 0.979924, 0.19937, 180, 180, 100, 0, 0, 0, 7, 10),
(@OGUID+52, 180657, 0, -2489.85, -1712.92, 0, 2.40855, 0, 0, 0.93358, 0.358368, 180, 180, 100, 0, 0, 0, 7, 10),
(@OGUID+53, 180662, 0, -3887.51, -837.013, 0, 2.32129, 0, 0, 0.91706, 0.398749, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+54, 180662, 0, -3884.81, -712.804, 0, -0.10472, 0, 0, 0.052336, -0.99863, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+55, 180662, 0, -3873.45, -634.351, 0, -0.837758, 0, 0, 0.406737, -0.913545, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+56, 180662, 0, -3843.22, -918.727, 0, -2.89725, 0, 0, 0.992546, -0.121869, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+57, 180662, 0, -3758.88, -608.091, 0, 2.56563, 0, 0, 0.95882, 0.284015, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+58, 180662, 0, -3710.44, -673.205, 0, 2.51327, 0, 0, 0.951057, 0.309017, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+59, 180662, 0, -3707.95, -631.876, 0, -0.925024, 0, 0, 0.446198, -0.894934, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+60, 180662, 0, -3649.69, -665.087, 0, 0.191986, 0, 0, 0.095846, 0.995396, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+61, 180662, 0, -3353.9, -975.253, 0, -0.349066, 0, 0, 0.173648, -0.984808, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+62, 180662, 0, -3262.99, -889.309, 0, -0.610865, 0, 0, 0.300706, -0.953717, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+63, 180662, 0, -3142.66, -901.367, 0, -2.79253, 0, 0, 0.984808, -0.173648, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+64, 180662, 0, -3070.82, -916.696, 0, -0.715585, 0, 0, 0.350207, -0.936672, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+65, 180662, 0, -3018.44, -941.133, 0, 2.51327, 0, 0, 0.951057, 0.309017, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+66, 180662, 0, -2904.7, -1007.43, 0, -0.418879, 0, 0, 0.207912, -0.978148, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+67, 180662, 0, -2869.85, -1038.07, 0, 1.62316, 0, 0, 0.725374, 0.688355, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+68, 180662, 0, -2755.3, -1128.21, 0, 2.56563, 0, 0, 0.95882, 0.284015, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+69, 180662, 0, -2721.1, -1163.18, 0, 1.97222, 0, 0, 0.833886, 0.551937, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+70, 180662, 0, -2704.53, -1210.83, 0, 2.14675, 0, 0, 0.878817, 0.477159, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+71, 180662, 0, -2681.61, -1279.36, 0, -2.46091, 0, 0, 0.942641, -0.333807, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+72, 180662, 0, -2672.18, -1451.32, 0, 1.81514, 0, 0, 0.788011, 0.615662, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+73, 180662, 0, -2625.05, -1536.17, 0, -3.12414, 0, 0, 0.999962, -0.008727, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+74, 180662, 0, -2576.34, -1586.48, 0, -1.72788, 0, 0, 0.760406, -0.649448, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+75, 180662, 0, -2460.01, -1757.19, 0, 2.51327, 0, 0, 0.951057, 0.309017, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+76, 180662, 0, -3359.63, -893.433, 0, 2.1293, 0, 0, 0.874619, 0.48481, 180, 180, 100, 0, 0, 0, 7, 10),
(@OGUID+77, 180662, 0, -3211.8, -891.612, 0, 2.74016, 0, 0, 0.979924, 0.19937, 180, 180, 100, 0, 0, 0, 7, 10),
(@OGUID+78, 180662, 0, -2489.85, -1712.92, 0, 2.40855, 0, 0, 0.93358, 0.358368, 180, 180, 100, 0, 0, 0, 7, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+1, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+2, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+3, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+4, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+5, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+6, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+7, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+8, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+9, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+10, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+11, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+12, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+13, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+14, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+15, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+16, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+17, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+18, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+19, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+20, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+21, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+22, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+23, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+24, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+25, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@PTEMPLATE+26, 1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10);
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_min`, `patch_max`) VALUES
(@OGUID+1, @PTEMPLATE+1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+2, @PTEMPLATE+2, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+3, @PTEMPLATE+3, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+4, @PTEMPLATE+4, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+5, @PTEMPLATE+5, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+6, @PTEMPLATE+6, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+7, @PTEMPLATE+7, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+8, @PTEMPLATE+8, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+9, @PTEMPLATE+9, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+10, @PTEMPLATE+10, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+11, @PTEMPLATE+11, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+12, @PTEMPLATE+12, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+13, @PTEMPLATE+13, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+14, @PTEMPLATE+14, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+15, @PTEMPLATE+15, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+16, @PTEMPLATE+16, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+17, @PTEMPLATE+17, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+18, @PTEMPLATE+18, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+19, @PTEMPLATE+19, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+20, @PTEMPLATE+20, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+21, @PTEMPLATE+21, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+22, @PTEMPLATE+22, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+23, @PTEMPLATE+23, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+24, @PTEMPLATE+24, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+25, @PTEMPLATE+25, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+26, @PTEMPLATE+26, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+27, @PTEMPLATE+1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+28, @PTEMPLATE+2, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+29, @PTEMPLATE+3, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+30, @PTEMPLATE+4, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+31, @PTEMPLATE+5, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+32, @PTEMPLATE+6, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+33, @PTEMPLATE+7, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+34, @PTEMPLATE+8, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+35, @PTEMPLATE+9, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+36, @PTEMPLATE+10, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+37, @PTEMPLATE+11, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+38, @PTEMPLATE+12, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+39, @PTEMPLATE+13, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+40, @PTEMPLATE+14, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+41, @PTEMPLATE+15, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+42, @PTEMPLATE+16, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+43, @PTEMPLATE+17, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+44, @PTEMPLATE+18, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+45, @PTEMPLATE+19, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+46, @PTEMPLATE+20, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+47, @PTEMPLATE+21, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+48, @PTEMPLATE+22, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+49, @PTEMPLATE+23, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+50, @PTEMPLATE+24, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+51, @PTEMPLATE+25, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+52, @PTEMPLATE+26, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+53, @PTEMPLATE+1, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+54, @PTEMPLATE+2, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+55, @PTEMPLATE+3, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+56, @PTEMPLATE+4, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+57, @PTEMPLATE+5, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+58, @PTEMPLATE+6, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+59, @PTEMPLATE+7, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+60, @PTEMPLATE+8, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+61, @PTEMPLATE+9, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+62, @PTEMPLATE+10, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+63, @PTEMPLATE+11, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+64, @PTEMPLATE+12, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+65, @PTEMPLATE+13, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+66, @PTEMPLATE+14, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+67, @PTEMPLATE+15, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+68, @PTEMPLATE+16, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+69, @PTEMPLATE+17, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+70, @PTEMPLATE+18, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+71, @PTEMPLATE+19, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+72, @PTEMPLATE+20, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+73, @PTEMPLATE+21, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+74, @PTEMPLATE+22, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+75, @PTEMPLATE+23, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+76, @PTEMPLATE+24, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+77, @PTEMPLATE+25, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10),
(@OGUID+78, @PTEMPLATE+26, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 7, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+27, 11, 'Wetlands - Oily Blackmouth School / Firefin Snapper School / Floating Wreckage (Master Pool)', 0, 0, 7, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(@PTEMPLATE+1, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+2, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+3, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+4, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+5, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+6, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+7, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+8, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+9, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+10, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+11, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+12, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+13, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+14, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+15, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+16, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+17, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+18, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+19, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+20, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+21, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+22, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+23, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+24, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+25, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0),
(@PTEMPLATE+26, @PTEMPLATE+27, 0, 'Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands', 0);
UPDATE `pool_gameobject` SET `chance` = 60 WHERE `description` = "Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 180657);
UPDATE `pool_gameobject` SET `chance` = 20 WHERE `description` = "Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 180662);
UPDATE `pool_gameobject` SET `chance` = 20 WHERE `description` = "Oily Blackmouth School / Firefin Snapper School / Floating Wreckage - Wetlands" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 180664);
-- 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