sindoring/moonwell-core-vanilla
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Files
development
moonwell-core-vanilla/sql/migrations/20230626160803_world.sql
T
NickTyrer 446d595dd6 Add Missing Fish Pools - Darkshore (#1984)
2023-06-29 16:03:59 +01:00

320 lines
30 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`='20230626160803');
IF v=0 THEN
INSERT INTO `migrations` VALUES ('20230626160803');
-- Add your query below.
SET @OGUID = 33019;
SET @PTEMPLATE = 3339;
-- Darkshore
DELETE FROM `gameobject` WHERE `guid` IN (916, 5121, 5123, 5178, 5179, 5181, 5182, 5183, 5190, 5192, 5322, 5328, 5340, 5435, 5439, 5441, 5442, 5465, 5476, 6808, 6843, 6844, 6856, 6864, 10951, 10963, 10966, 10967, 10969, 14085, 14086, 14087, 14088, 14089, 14096, 14097, 15110, 15111, 15199, 15200, 15203, 15204, 15420, 15476, 15497, 15505, 15633, 15634, 15763, 15764, 15771, 15775, 15776, 15777, 15779, 15783, 16548, 18141, 18142, 18145, 48525, 48539, 48541, 48556, 48638, 48646, 48647, 48648, 48650, 48658, 48663, 48667, 50269, 50270, 50271, 50272, 50273, 50274, 50275, 50280, 50281, 50286, 50287, 50288, 50289, 50290, 50291, 50292, 50294, 50295, 50299, 50304, 50306);
DELETE FROM `pool_gameobject` WHERE `guid` IN (916, 5121, 5123, 5178, 5179, 5181, 5182, 5183, 5190, 5192, 5322, 5328, 5340, 5435, 5439, 5441, 5442, 5465, 5476, 6808, 6843, 6844, 6856, 6864, 10951, 10963, 10966, 10967, 10969, 14085, 14086, 14087, 14088, 14089, 14096, 14097, 15110, 15111, 15199, 15200, 15203, 15204, 15420, 15476, 15497, 15505, 15633, 15634, 15763, 15764, 15771, 15775, 15776, 15777, 15779, 15783, 16548, 18141, 18142, 18145, 48525, 48539, 48541, 48556, 48638, 48646, 48647, 48648, 48650, 48658, 48663, 48667, 50269, 50270, 50271, 50272, 50273, 50274, 50275, 50280, 50281, 50286, 50287, 50288, 50289, 50290, 50291, 50292, 50294, 50295, 50299, 50304, 50306);
DELETE FROM `pool_template` WHERE `entry` IN (SELECT `pool_entry` FROM `pool_gameobject` WHERE `guid` IN (916, 5121, 5123, 5178, 5179, 5181, 5182, 5183, 5190, 5192, 5322, 5328, 5340, 5435, 5439, 5441, 5442, 5465, 5476, 6808, 6843, 6844, 6856, 6864, 10951, 10963, 10966, 10967, 10969, 14085, 14086, 14087, 14088, 14089, 14096, 14097, 15110, 15111, 15199, 15200, 15203, 15204, 15420, 15476, 15497, 15505, 15633, 15634, 15763, 15764, 15771, 15775, 15776, 15777, 15779, 15783, 16548, 18141, 18142, 18145, 48525, 48539, 48541, 48556, 48638, 48646, 48647, 48648, 48650, 48658, 48663, 48667, 50269, 50270, 50271, 50272, 50273, 50274, 50275, 50280, 50281, 50286, 50287, 50288, 50289, 50290, 50291, 50292, 50294, 50295, 50299, 50304, 50306));
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, 180582, 1, 4674.38, 843.767, 0, -2.09439, 0, 0, 0.866025, -0.5, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+2, 180582, 1, 4723.29, 727.582, 0, -0.506145, 0, 0, 0.25038, -0.968148, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+3, 180582, 1, 4737.25, 851.432, -0.790674, 2.56563, 0, 0, 0.95882, 0.284015, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+4, 180582, 1, 4754.92, 781.582, 0, 1.88496, 0, 0, 0.809017, 0.587785, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+5, 180582, 1, 4838.6, 703.922, 0, -1.97222, 0, 0, 0.833886, -0.551937, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+6, 180582, 1, 4969.75, 598.72, 0, 0.017453, 0, 0, 0.008727, 0.999962, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+7, 180582, 1, 5098.13, 591.153, -0.757871, 1.74533, 0, 0, 0.766044, 0.642788, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+8, 180582, 1, 5205.42, 646.524, 0, 0.401426, 0, 0, 0.199368, 0.979925, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+9, 180582, 1, 5286.93, 587.093, 0, -1.51844, 0, 0, 0.688354, -0.725374, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+10, 180582, 1, 5391.52, 547.168, 0, 0.20944, 0, 0, 0.104528, 0.994522, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+11, 180582, 1, 5530.88, 568.461, 0, 1.20428, 0, 0, 0.566406, 0.824126, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+12, 180582, 1, 5632.19, 551.868, 0, 2.80998, 0, 0, 0.986286, 0.165048, 3600, 3600, 100, 1, 0, 0, 7, 10),
(@OGUID+13, 180582, 1, 5721.1, 592.505, 0, -3.05433, 0, 0, 0.999048, -0.043619, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+14, 180582, 1, 5837.96, 548.35, 0, -0.977384, 0, 0, 0.469472, -0.882948, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+15, 180582, 1, 5881.34, 595.47, 0, -2.51327, 0, 0, 0.951057, -0.309017, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+16, 180582, 1, 6083.96, 587.658, 0, 0.488692, 0, 0, 0.241922, 0.970296, 900, 900, 100, 1, 0, 0, 7, 10),
(@OGUID+17, 180582, 1, 6293.92, 590.357, 0, -0.418879, 0, 0, 0.207912, -0.978148, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+18, 180582, 1, 6431.71, 667.197, 0, 1.44862, 0, 0, 0.66262, 0.748956, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+19, 180582, 1, 6485.99, 679.739, 0, 1.81514, 0, 0, 0.788011, 0.615662, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+20, 180582, 1, 6486.94, 822.047, 0, 0.994838, 0, 0, 0.477159, 0.878817, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+21, 180582, 1, 6502.51, 881.164, 0, -0.034907, 0, 0, 0.017452, -0.999848, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+22, 180582, 1, 6511.13, 757.642, 0, -1.44862, 0, 0, 0.66262, -0.748956, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+23, 180582, 1, 6528.03, 813.211, 0, 1.95477, 0, 0, 0.829038, 0.559193, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+24, 180582, 1, 6648.43, 540.152, 0, 0.802851, 0, 0, 0.390731, 0.920505, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+25, 180582, 1, 6756.7, 515.737, -0.700236, 2.80998, 0, 0, 0.986286, 0.165048, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+26, 180582, 1, 6845.35, 479.494, 0, 1.71042, 0, 0, 0.75471, 0.656059, 900, 900, 100, 1, 0, 0, 7, 10),
(@OGUID+27, 180582, 1, 6965.09, 434.654, 0, -1.43117, 0, 0, 0.656059, -0.75471, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+28, 180582, 1, 6967.07, 182.5, -0.538619, 1.25664, 0, 0, 0.587785, 0.809017, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+29, 180582, 1, 6981.46, 323.755, 0, -0.872665, 0, 0, 0.422618, -0.906308, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+30, 180582, 1, 7304.01, 224.661, -0.667236, 1.32645, 0, 0, 0.615662, 0.788011, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+31, 180582, 1, 7448.34, -246.666, 0, 3.03687, 0, 0, 0.99863, 0.052336, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+32, 180582, 1, 5919.53, 551.414, 0, 6.12611, 0, 0, -0.0784588, 0.996917, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+33, 180582, 1, 5991.17, 550.198, -0.871065, 6.14356, 0, 0, -0.0697556, 0.997564, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+34, 180582, 1, 6200.13, 598.76, 0, 4.88692, 0, 0, -0.642787, 0.766045, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+35, 180582, 1, 7039.38, 211.546, 0, 3.3685, 0, 0, -0.993571, 0.113208, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+36, 180582, 1, 7102.92, 193.859, -0.631198, 3.87463, 0, 0, -0.93358, 0.358368, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+37, 180582, 1, 7171.02, 214.456, 0, 3.82227, 0, 0, -0.942641, 0.333808, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+38, 180582, 1, 7230.74, 224.249, 0, 4.04917, 0, 0, -0.898793, 0.438373, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+39, 180582, 1, 7399.99, 198.394, 0, 1.48353, 0, 0, 0.67559, 0.737278, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+40, 180582, 1, 7432.24, 178.167, 0, 1.78023, 0, 0, 0.777145, 0.629321, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+41, 180582, 1, 7432.66, -10.8868, -0.53997, 0.0523589, 0, 0, 0.0261765, 0.999657, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+42, 180582, 1, 7433.85, -326.411, -0.82227, 0.925024, 0, 0, 0.446198, 0.894935, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+43, 180582, 1, 7434.31, -455.418, -0.653612, 3.78737, 0, 0, -0.948323, 0.317306, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+44, 180582, 1, 7454.41, 95.944, 0, 1.97222, 0, 0, 0.833885, 0.551938, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+45, 180582, 1, 7460.47, -178.365, 0, 0.558504, 0, 0, 0.275637, 0.961262, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+46, 180582, 1, 7460.98, -77.1211, 0, 2.89725, 0, 0, 0.992546, 0.12187, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+47, 180655, 1, 4674.38, 843.767, 0, -2.09439, 0, 0, 0.866025, -0.5, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+48, 180655, 1, 4723.29, 727.582, 0, -0.506145, 0, 0, 0.25038, -0.968148, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+49, 180655, 1, 4737.25, 851.432, -0.790674, 2.56563, 0, 0, 0.95882, 0.284015, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+50, 180655, 1, 4754.92, 781.582, 0, 1.88496, 0, 0, 0.809017, 0.587785, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+51, 180655, 1, 4838.6, 703.922, 0, -1.97222, 0, 0, 0.833886, -0.551937, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+52, 180655, 1, 4969.75, 598.72, 0, 0.017453, 0, 0, 0.008727, 0.999962, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+53, 180655, 1, 5098.13, 591.153, -0.757871, 1.74533, 0, 0, 0.766044, 0.642788, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+54, 180655, 1, 5205.42, 646.524, 0, 0.401426, 0, 0, 0.199368, 0.979925, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+55, 180655, 1, 5286.93, 587.093, 0, -1.51844, 0, 0, 0.688354, -0.725374, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+56, 180655, 1, 5391.52, 547.168, 0, 0.20944, 0, 0, 0.104528, 0.994522, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+57, 180655, 1, 5530.88, 568.461, 0, 1.20428, 0, 0, 0.566406, 0.824126, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+58, 180655, 1, 5632.19, 551.868, 0, 2.80998, 0, 0, 0.986286, 0.165048, 3600, 3600, 100, 1, 0, 0, 7, 10),
(@OGUID+59, 180655, 1, 5721.1, 592.505, 0, -3.05433, 0, 0, 0.999048, -0.043619, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+60, 180655, 1, 5837.96, 548.35, 0, -0.977384, 0, 0, 0.469472, -0.882948, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+61, 180655, 1, 5881.34, 595.47, 0, -2.51327, 0, 0, 0.951057, -0.309017, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+62, 180655, 1, 6083.96, 587.658, 0, 0.488692, 0, 0, 0.241922, 0.970296, 900, 900, 100, 1, 0, 0, 7, 10),
(@OGUID+63, 180655, 1, 6293.92, 590.357, 0, -0.418879, 0, 0, 0.207912, -0.978148, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+64, 180655, 1, 6431.71, 667.197, 0, 1.44862, 0, 0, 0.66262, 0.748956, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+65, 180655, 1, 6485.99, 679.739, 0, 1.81514, 0, 0, 0.788011, 0.615662, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+66, 180655, 1, 6486.94, 822.047, 0, 0.994838, 0, 0, 0.477159, 0.878817, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+67, 180655, 1, 6502.51, 881.164, 0, -0.034907, 0, 0, 0.017452, -0.999848, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+68, 180655, 1, 6511.13, 757.642, 0, -1.44862, 0, 0, 0.66262, -0.748956, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+69, 180655, 1, 6528.03, 813.211, 0, 1.95477, 0, 0, 0.829038, 0.559193, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+70, 180655, 1, 6648.43, 540.152, 0, 0.802851, 0, 0, 0.390731, 0.920505, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+71, 180655, 1, 6756.7, 515.737, -0.700236, 2.80998, 0, 0, 0.986286, 0.165048, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+72, 180655, 1, 6845.35, 479.494, 0, 1.71042, 0, 0, 0.75471, 0.656059, 900, 900, 100, 1, 0, 0, 7, 10),
(@OGUID+73, 180655, 1, 6965.09, 434.654, 0, -1.43117, 0, 0, 0.656059, -0.75471, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+74, 180655, 1, 6967.07, 182.5, -0.538619, 1.25664, 0, 0, 0.587785, 0.809017, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+75, 180655, 1, 6981.46, 323.755, 0, -0.872665, 0, 0, 0.422618, -0.906308, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+76, 180655, 1, 7304.01, 224.661, -0.667236, 1.32645, 0, 0, 0.615662, 0.788011, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+77, 180655, 1, 7448.34, -246.666, 0, 3.03687, 0, 0, 0.99863, 0.052336, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+78, 180655, 1, 5919.53, 551.414, 0, 6.12611, 0, 0, -0.0784588, 0.996917, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+79, 180655, 1, 5991.17, 550.198, -0.871065, 6.14356, 0, 0, -0.0697556, 0.997564, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+80, 180655, 1, 6200.13, 598.76, 0, 4.88692, 0, 0, -0.642787, 0.766045, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+81, 180655, 1, 7039.38, 211.546, 0, 3.3685, 0, 0, -0.993571, 0.113208, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+82, 180655, 1, 7102.92, 193.859, -0.631198, 3.87463, 0, 0, -0.93358, 0.358368, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+83, 180655, 1, 7171.02, 214.456, 0, 3.82227, 0, 0, -0.942641, 0.333808, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+84, 180655, 1, 7230.74, 224.249, 0, 4.04917, 0, 0, -0.898793, 0.438373, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+85, 180655, 1, 7399.99, 198.394, 0, 1.48353, 0, 0, 0.67559, 0.737278, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+86, 180655, 1, 7432.24, 178.167, 0, 1.78023, 0, 0, 0.777145, 0.629321, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+87, 180655, 1, 7432.66, -10.8868, -0.53997, 0.0523589, 0, 0, 0.0261765, 0.999657, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+88, 180655, 1, 7433.85, -326.411, -0.82227, 0.925024, 0, 0, 0.446198, 0.894935, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+89, 180655, 1, 7434.31, -455.418, -0.653612, 3.78737, 0, 0, -0.948323, 0.317306, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+90, 180655, 1, 7454.41, 95.944, 0, 1.97222, 0, 0, 0.833885, 0.551938, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+91, 180655, 1, 7460.47, -178.365, 0, 0.558504, 0, 0, 0.275637, 0.961262, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+92, 180655, 1, 7460.98, -77.1211, 0, 2.89725, 0, 0, 0.992546, 0.12187, 180, 180, 100, 1, 0, 0, 7, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+1, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+2, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+3, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+4, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+5, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+6, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+7, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+8, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+9, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+10, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+11, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+12, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+13, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+14, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+15, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+16, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+17, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+18, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+19, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+20, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+21, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+22, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+23, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+24, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+25, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+26, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+27, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+28, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+29, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+30, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+31, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+32, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+33, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+34, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+35, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+36, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+37, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+38, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+39, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+40, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+41, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+42, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+43, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+44, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+45, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@PTEMPLATE+46, 1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10);
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_min`, `patch_max`) VALUES
(@OGUID+1, @PTEMPLATE+1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+2, @PTEMPLATE+2, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+3, @PTEMPLATE+3, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+4, @PTEMPLATE+4, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+5, @PTEMPLATE+5, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+6, @PTEMPLATE+6, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+7, @PTEMPLATE+7, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+8, @PTEMPLATE+8, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+9, @PTEMPLATE+9, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+10, @PTEMPLATE+10, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+11, @PTEMPLATE+11, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+12, @PTEMPLATE+12, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+13, @PTEMPLATE+13, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+14, @PTEMPLATE+14, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+15, @PTEMPLATE+15, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+16, @PTEMPLATE+16, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+17, @PTEMPLATE+17, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+18, @PTEMPLATE+18, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+19, @PTEMPLATE+19, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+20, @PTEMPLATE+20, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+21, @PTEMPLATE+21, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+22, @PTEMPLATE+22, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+23, @PTEMPLATE+23, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+24, @PTEMPLATE+24, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+25, @PTEMPLATE+25, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+26, @PTEMPLATE+26, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+27, @PTEMPLATE+27, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+28, @PTEMPLATE+28, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+29, @PTEMPLATE+29, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+30, @PTEMPLATE+30, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+31, @PTEMPLATE+31, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+32, @PTEMPLATE+32, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+33, @PTEMPLATE+33, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+34, @PTEMPLATE+34, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+35, @PTEMPLATE+35, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+36, @PTEMPLATE+36, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+37, @PTEMPLATE+37, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+38, @PTEMPLATE+38, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+39, @PTEMPLATE+39, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+40, @PTEMPLATE+40, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+41, @PTEMPLATE+41, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+42, @PTEMPLATE+42, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+43, @PTEMPLATE+43, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+44, @PTEMPLATE+44, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+45, @PTEMPLATE+45, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+46, @PTEMPLATE+46, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+47, @PTEMPLATE+1, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+48, @PTEMPLATE+2, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+49, @PTEMPLATE+3, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+50, @PTEMPLATE+4, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+51, @PTEMPLATE+5, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+52, @PTEMPLATE+6, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+53, @PTEMPLATE+7, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+54, @PTEMPLATE+8, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+55, @PTEMPLATE+9, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+56, @PTEMPLATE+10, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+57, @PTEMPLATE+11, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+58, @PTEMPLATE+12, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+59, @PTEMPLATE+13, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+60, @PTEMPLATE+14, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+61, @PTEMPLATE+15, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+62, @PTEMPLATE+16, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+63, @PTEMPLATE+17, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+64, @PTEMPLATE+18, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+65, @PTEMPLATE+19, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+66, @PTEMPLATE+20, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+67, @PTEMPLATE+21, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+68, @PTEMPLATE+22, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+69, @PTEMPLATE+23, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+70, @PTEMPLATE+24, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+71, @PTEMPLATE+25, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+72, @PTEMPLATE+26, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+73, @PTEMPLATE+27, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+74, @PTEMPLATE+28, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+75, @PTEMPLATE+29, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+76, @PTEMPLATE+30, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+77, @PTEMPLATE+31, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+78, @PTEMPLATE+32, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+79, @PTEMPLATE+33, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+80, @PTEMPLATE+34, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+81, @PTEMPLATE+35, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+82, @PTEMPLATE+36, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+83, @PTEMPLATE+37, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+84, @PTEMPLATE+38, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+85, @PTEMPLATE+39, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+86, @PTEMPLATE+40, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+87, @PTEMPLATE+41, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+88, @PTEMPLATE+42, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+89, @PTEMPLATE+43, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+90, @PTEMPLATE+44, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+91, @PTEMPLATE+45, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10),
(@OGUID+92, @PTEMPLATE+46, 'Oily Blackmouth School / Floating Debris - Darkshore', 7, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+47, 21, 'Darkshore - Oily Blackmouth School / Floating Debris (Master Pool)', 0, 0, 7, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(@PTEMPLATE+1, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+2, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+3, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+4, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+5, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+6, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+7, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+8, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+9, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+10, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+11, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+12, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+13, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+14, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+15, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+16, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+17, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+18, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+19, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+20, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+21, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+22, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+23, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+24, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+25, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+26, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+27, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+28, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+29, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+30, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+31, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+32, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+33, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+34, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+35, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+36, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+37, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+38, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+39, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+40, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+41, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+42, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+43, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+44, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+45, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0),
(@PTEMPLATE+46, @PTEMPLATE+47, 0, 'Oily Blackmouth School / Floating Debris - Darkshore', 0);
UPDATE `pool_gameobject` SET `chance` = 80 WHERE `description` = "Oily Blackmouth School / Floating Debris - Darkshore" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 180582);
UPDATE `pool_gameobject` SET `chance` = 20 WHERE `description` = "Oily Blackmouth School / Floating Debris - Darkshore" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 180655);
-- Correct position of Oily Blackmouth School in Darkshore (position is off by 1.12163 yards).
UPDATE `gameobject` SET `position_x`=4838.6, `position_y`=703.922, `position_z`=-1.12163, `orientation`=4.31097, `rotation0`=0, `rotation1`=0, `rotation2`=-0.833885, `rotation3`=0.551938 WHERE `guid` IN (33024, 33070);
-- 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