sindoring/moonwell-core-vanilla
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Files
development
moonwell-core-vanilla/sql/migrations/20230704172809_world.sql
T
NickTyrer 89f087b5e4 Water Barrel / Food Crate - Elwynn Forest (#2034)
2023-07-07 07:20:45 +01:00

259 lines
22 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`='20230704172809');
IF v=0 THEN
INSERT INTO `migrations` VALUES ('20230704172809');
-- Add your query below.
SET @OGUID = 28844;
SET @PTEMPLATE = 3386;
-- 12 Elwynn Forest 3658 / 3719 / Water Barrel / Food Crate
DELETE FROM `pool_template` WHERE `entry` IN (SELECT `pool_entry` FROM `pool_gameobject` WHERE `guid` IN (26782, 26851, 26862, 26877, 26888, 26898, 26962, 26983, 26994, 26998, 27052, 27084, 29275, 29276, 29578, 30677, 30685, 30687, 30748, 30751, 30758, 30839, 30846, 30971, 31104, 32313, 32752, 32754, 32825, 33491, 34031, 34822, 88014, 88015, 88016, 88017, 88018, 88019, 88020, 88021, 88022, 88023, 88024, 88025, 88026, 88027, 88028, 88029, 88030, 88031, 88032, 88033, 88034, 88035, 88036, 88037));
DELETE FROM `gameobject` WHERE `guid` IN (26782, 26851, 26862, 26877, 26888, 26898, 26962, 26983, 26994, 26998, 27052, 27084, 29275, 29276, 29578, 30677, 30685, 30687, 30748, 30751, 30758, 30839, 30846, 30971, 31104, 32313, 32752, 32754, 32825, 33491, 34031, 34822, 88014, 88015, 88016, 88017, 88018, 88019, 88020, 88021, 88022, 88023, 88024, 88025, 88026, 88027, 88028, 88029, 88030, 88031, 88032, 88033, 88034, 88035, 88036, 88037);
DELETE FROM `pool_gameobject` WHERE `guid` IN (26782, 26851, 26862, 26877, 26888, 26898, 26962, 26983, 26994, 26998, 27052, 27084, 29275, 29276, 29578, 30677, 30685, 30687, 30748, 30751, 30758, 30839, 30846, 30971, 31104, 32313, 32752, 32754, 32825, 33491, 34031, 34822, 88014, 88015, 88016, 88017, 88018, 88019, 88020, 88021, 88022, 88023, 88024, 88025, 88026, 88027, 88028, 88029, 88030, 88031, 88032, 88033, 88034, 88035, 88036, 88037);
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, 3658, 0, -10063.4, 622.68, 39.2654, -0.523599, 0, 0, 0.258819, -0.965926, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+2, 3658, 0, -10009.8, 38.8972, 35.1709, 2.26893, 0, 0, 0.906308, 0.422618, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+3, 3658, 0, -10004.2, 668.569, 35.7438, 1.48353, 0, 0, 0.67559, 0.737277, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+4, 3658, 0, -9947.94, 625.232, 37.2732, 1.0821, 0, 0, 0.515038, 0.857167, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+5, 3658, 0, -9940.45, -1108.79, 22.2839, 0.785398, 0, 0, 0.382683, 0.92388, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+6, 3658, 0, -9930.38, 582.718, 37.709, -0.436333, 0, 0, 0.21644, -0.976296, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+7, 3658, 0, -9909.52, 26.2754, 32.0256, 0.401426, 0, 0, 0.199368, 0.979925, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+8, 3658, 0, -9862.25, -230.512, 35.5091, -1.29154, 0, 0, 0.601815, -0.798635, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+9, 3658, 0, -9853.07, 366.57, 36.4383, -0.418879, 0, 0, 0.207912, -0.978148, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+10, 3658, 0, -9851.94, 173.276, 21.2732, -1.72788, 0, 0, 0.760406, -0.649448, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+11, 3658, 0, -9809.68, 718.15, 33.1179, 1.02974, 0, 0, 0.492424, 0.870356, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+12, 3658, 0, -9789.66, -1399.88, 62.8007, 1.58825, 0, 0, 0.71325, 0.700909, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+13, 3658, 0, -9729.42, 656.299, 31.8338, 2.35619, 0, 0, 0.92388, 0.382683, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+14, 3658, 0, -9630.97, -53.8834, 44.6324, 1.64061, 0, 0, 0.731354, 0.681998, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+15, 3658, 0, -9605.92, 674.789, 38.6522, 1.50098, 0, 0, 0.681998, 0.731354, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+16, 3658, 0, -9572.89, -718.307, 64.7386, 3.07178, 0, 0, 0.999391, 0.034899, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+17, 3658, 0, -9555.29, -718.836, 99.0869, -2.84489, 0, 0, 0.989016, -0.147809, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+18, 3658, 0, -9538.32, -1406.06, 55.6784, 2.79253, 0, 0, 0.984808, 0.173648, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+19, 3658, 0, -9500.53, 81.368, 57.4601, 0.017453, 0, 0, 0.008727, 0.999962, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+20, 3658, 0, -9458.53, 8.58518, 56.9626, 2.98451, 0, 0, 0.996917, 0.078459, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+21, 3658, 0, -9439.13, 485.315, 53.1871, -1.90241, 0, 0, 0.814116, -0.580703, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+22, 3658, 0, -9379.27, -115.021, 58.7317, -0.139626, 0, 0, 0.069756, -0.997564, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+23, 3658, 0, -9316.71, 290.286, 70.5393, -0.959931, 0, 0, 0.461749, -0.887011, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+24, 3658, 0, -9307.25, -291.366, 70.4318, 2.26893, 0, 0, 0.906308, 0.422618, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+25, 3658, 0, -9258.88, 355.379, 76.693, 1.36136, 0, 0, 0.62932, 0.777146, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+26, 3658, 0, -8981.32, -815.302, 70.3834, -1.50098, 0, 0, 0.681998, -0.731354, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+27, 3658, 0, -8900.41, -770.323, 69.5532, -2.42601, 0, 0, 0.936672, -0.350207, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+28, 3658, 0, -8823.07, -872.418, 74.7945, 2.98451, 0, 0, 0.996917, 0.078459, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+29, 3658, 0, -9977, 370.333, 35.638, 4.31097, 0, 0, -0.833885, 0.551938, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+30, 3658, 0, -9974.25, -138.968, 24.2588, 0.331611, 0, 0, 0.165047, 0.986286, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+31, 3658, 0, -9892.97, 323.535, 36.9396, 0.453785, 0, 0, 0.224951, 0.97437, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+32, 3658, 0, -9842.3, -1117.75, 28.0964, 4.4855, 0, 0, -0.782608, 0.622515, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+33, 3658, 0, -9541.03, -1218.72, 48.1501, 3.00195, 0, 0, 0.997563, 0.0697661, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+34, 3658, 0, -9433.64, -1399.79, 46.6621, 0.157079, 0, 0, 0.0784588, 0.996917, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+35, 3658, 0, -9235.93, -709.886, 62.8566, 2.65289, 0, 0, 0.970295, 0.241925, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+36, 3658, 0, -8959.95, -1192.86, 72.1396, 4.2237, 0, 0, -0.857167, 0.515038, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+37, 3658, 0, -8860.11, -826.68, 71.9097, 2.21657, 0, 0, 0.894934, 0.446199, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+38, 3719, 0, -10063.4, 622.68, 39.2654, -0.523599, 0, 0, 0.258819, -0.965926, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+39, 3719, 0, -10009.8, 38.8972, 35.1709, 2.26893, 0, 0, 0.906308, 0.422618, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+40, 3719, 0, -10004.2, 668.569, 35.7438, 1.48353, 0, 0, 0.67559, 0.737277, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+41, 3719, 0, -9947.94, 625.232, 37.2732, 1.0821, 0, 0, 0.515038, 0.857167, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+42, 3719, 0, -9940.45, -1108.79, 22.2839, 0.785398, 0, 0, 0.382683, 0.92388, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+43, 3719, 0, -9930.38, 582.718, 37.709, -0.436333, 0, 0, 0.21644, -0.976296, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+44, 3719, 0, -9909.52, 26.2754, 32.0256, 0.401426, 0, 0, 0.199368, 0.979925, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+45, 3719, 0, -9862.25, -230.512, 35.5091, -1.29154, 0, 0, 0.601815, -0.798635, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+46, 3719, 0, -9853.07, 366.57, 36.4383, -0.418879, 0, 0, 0.207912, -0.978148, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+47, 3719, 0, -9851.94, 173.276, 21.2732, -1.72788, 0, 0, 0.760406, -0.649448, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+48, 3719, 0, -9809.68, 718.15, 33.1179, 1.02974, 0, 0, 0.492424, 0.870356, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+49, 3719, 0, -9789.66, -1399.88, 62.8007, 1.58825, 0, 0, 0.71325, 0.700909, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+50, 3719, 0, -9729.42, 656.299, 31.8338, 2.35619, 0, 0, 0.92388, 0.382683, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+51, 3719, 0, -9630.97, -53.8834, 44.6324, 1.64061, 0, 0, 0.731354, 0.681998, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+52, 3719, 0, -9605.92, 674.789, 38.6522, 1.50098, 0, 0, 0.681998, 0.731354, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+53, 3719, 0, -9572.89, -718.307, 64.7386, 3.07178, 0, 0, 0.999391, 0.034899, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+54, 3719, 0, -9555.29, -718.836, 99.0869, -2.84489, 0, 0, 0.989016, -0.147809, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+55, 3719, 0, -9538.32, -1406.06, 55.6784, 2.79253, 0, 0, 0.984808, 0.173648, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+56, 3719, 0, -9500.53, 81.368, 57.4601, 0.017453, 0, 0, 0.008727, 0.999962, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+57, 3719, 0, -9458.53, 8.58518, 56.9626, 2.98451, 0, 0, 0.996917, 0.078459, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+58, 3719, 0, -9439.13, 485.315, 53.1871, -1.90241, 0, 0, 0.814116, -0.580703, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+59, 3719, 0, -9379.27, -115.021, 58.7317, -0.139626, 0, 0, 0.069756, -0.997564, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+60, 3719, 0, -9316.71, 290.286, 70.5393, -0.959931, 0, 0, 0.461749, -0.887011, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+61, 3719, 0, -9307.25, -291.366, 70.4318, 2.26893, 0, 0, 0.906308, 0.422618, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+62, 3719, 0, -9258.88, 355.379, 76.693, 1.36136, 0, 0, 0.62932, 0.777146, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+63, 3719, 0, -8981.32, -815.302, 70.3834, -1.50098, 0, 0, 0.681998, -0.731354, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+64, 3719, 0, -8900.41, -770.323, 69.5532, -2.42601, 0, 0, 0.936672, -0.350207, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+65, 3719, 0, -8823.07, -872.418, 74.7945, 2.98451, 0, 0, 0.996917, 0.078459, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+66, 3719, 0, -9977, 370.333, 35.638, 4.31097, 0, 0, -0.833885, 0.551938, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+67, 3719, 0, -9974.25, -138.968, 24.2588, 0.331611, 0, 0, 0.165047, 0.986286, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+68, 3719, 0, -9892.97, 323.535, 36.9396, 0.453785, 0, 0, 0.224951, 0.97437, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+69, 3719, 0, -9842.3, -1117.75, 28.0964, 4.4855, 0, 0, -0.782608, 0.622515, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+70, 3719, 0, -9541.03, -1218.72, 48.1501, 3.00195, 0, 0, 0.997563, 0.0697661, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+71, 3719, 0, -9433.64, -1399.79, 46.6621, 0.157079, 0, 0, 0.0784588, 0.996917, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+72, 3719, 0, -9235.93, -709.886, 62.8566, 2.65289, 0, 0, 0.970295, 0.241925, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+73, 3719, 0, -8959.95, -1192.86, 72.1396, 4.2237, 0, 0, -0.857167, 0.515038, 180, 180, 100, 1, 0, 0, 0, 10),
(@OGUID+74, 3719, 0, -8860.11, -826.68, 71.9097, 2.21657, 0, 0, 0.894934, 0.446199, 180, 180, 100, 1, 0, 0, 0, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+1, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+2, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+3, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+4, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+5, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+6, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+7, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+8, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+9, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+10, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+11, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+12, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+13, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+14, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+15, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+16, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+17, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+18, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+19, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+20, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+21, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+22, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+23, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+24, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+25, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+26, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+27, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+28, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+29, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+30, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+31, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+32, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+33, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+34, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+35, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+36, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@PTEMPLATE+37, 1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10);
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_min`, `patch_max`) VALUES
(@OGUID+1, @PTEMPLATE+1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+2, @PTEMPLATE+2, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+3, @PTEMPLATE+3, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+4, @PTEMPLATE+4, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+5, @PTEMPLATE+5, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+6, @PTEMPLATE+6, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+7, @PTEMPLATE+7, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+8, @PTEMPLATE+8, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+9, @PTEMPLATE+9, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+10, @PTEMPLATE+10, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+11, @PTEMPLATE+11, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+12, @PTEMPLATE+12, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+13, @PTEMPLATE+13, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+14, @PTEMPLATE+14, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+15, @PTEMPLATE+15, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+16, @PTEMPLATE+16, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+17, @PTEMPLATE+17, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+18, @PTEMPLATE+18, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+19, @PTEMPLATE+19, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+20, @PTEMPLATE+20, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+21, @PTEMPLATE+21, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+22, @PTEMPLATE+22, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+23, @PTEMPLATE+23, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+24, @PTEMPLATE+24, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+25, @PTEMPLATE+25, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+26, @PTEMPLATE+26, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+27, @PTEMPLATE+27, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+28, @PTEMPLATE+28, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+29, @PTEMPLATE+29, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+30, @PTEMPLATE+30, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+31, @PTEMPLATE+31, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+32, @PTEMPLATE+32, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+33, @PTEMPLATE+33, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+34, @PTEMPLATE+34, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+35, @PTEMPLATE+35, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+36, @PTEMPLATE+36, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+37, @PTEMPLATE+37, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+38, @PTEMPLATE+1, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+39, @PTEMPLATE+2, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+40, @PTEMPLATE+3, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+41, @PTEMPLATE+4, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+42, @PTEMPLATE+5, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+43, @PTEMPLATE+6, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+44, @PTEMPLATE+7, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+45, @PTEMPLATE+8, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+46, @PTEMPLATE+9, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+47, @PTEMPLATE+10, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+48, @PTEMPLATE+11, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+49, @PTEMPLATE+12, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+50, @PTEMPLATE+13, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+51, @PTEMPLATE+14, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+52, @PTEMPLATE+15, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+53, @PTEMPLATE+16, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+54, @PTEMPLATE+17, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+55, @PTEMPLATE+18, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+56, @PTEMPLATE+19, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+57, @PTEMPLATE+20, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+58, @PTEMPLATE+21, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+59, @PTEMPLATE+22, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+60, @PTEMPLATE+23, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+61, @PTEMPLATE+24, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+62, @PTEMPLATE+25, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+63, @PTEMPLATE+26, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+64, @PTEMPLATE+27, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+65, @PTEMPLATE+28, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+66, @PTEMPLATE+29, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+67, @PTEMPLATE+30, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+68, @PTEMPLATE+31, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+69, @PTEMPLATE+32, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+70, @PTEMPLATE+33, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+71, @PTEMPLATE+34, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+72, @PTEMPLATE+35, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+73, @PTEMPLATE+36, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10),
(@OGUID+74, @PTEMPLATE+37, 'Water Barrel / Food Crate - Elwynn Forest', 0, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+38, 17, 'Elwynn Forest - Water Barrel / Food Crate (Master Pool)', 0, 0, 0, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(@PTEMPLATE+1, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+2, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+3, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+4, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+5, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+6, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+7, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+8, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+9, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+10, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+11, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+12, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+13, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+14, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+15, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+16, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+17, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+18, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+19, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+20, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+21, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+22, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+23, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+24, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+25, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+26, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+27, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+28, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+29, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+30, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+31, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+32, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+33, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+34, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+35, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+36, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0),
(@PTEMPLATE+37, @PTEMPLATE+38, 0, 'Water Barrel / Food Crate - Elwynn Forest', 0);
-- 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