sindoring/moonwell-core-vanilla
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Files
development
moonwell-core-vanilla/sql/migrations/20230627153910_world.sql
T
NickTyrer 3374aa131f Add Missing Fish Pools - Tanaris (#1990)
2023-06-29 16:07:47 +01:00

382 lines
45 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`='20230627153910');
IF v=0 THEN
INSERT INTO `migrations` VALUES ('20230627153910');
-- Add your query below.
SET @OGUID = 46710;
SET @PTEMPLATE = 4352;
-- Tanaris
DELETE FROM `gameobject` WHERE `guid` IN (17241, 17242, 17245, 17246, 17247, 17250, 17251, 17466, 17467, 17468, 17469, 17470, 18069, 18070, 18085, 18119, 18120, 18127, 18128, 18232, 18629, 18631, 50262, 50266, 50277, 50298, 50303);
DELETE FROM `pool_gameobject` WHERE `guid` IN (17241, 17242, 17245, 17246, 17247, 17250, 17251, 17466, 17467, 17468, 17469, 17470, 18069, 18070, 18085, 18119, 18120, 18127, 18128, 18232, 18629, 18631, 50262, 50266, 50277, 50298, 50303);
DELETE FROM `pool_template` WHERE `entry` IN (SELECT `pool_entry` FROM `pool_gameobject` WHERE `guid` IN (17241, 17242, 17245, 17246, 17247, 17250, 17251, 17466, 17467, 17468, 17469, 17470, 18069, 18070, 18085, 18119, 18120, 18127, 18128, 18232, 18629, 18631, 50262, 50266, 50277, 50298, 50303));
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, 180712, 1, -8460.64, -5041.87, 0, -0.942478, 0, 0, 0.453991, -0.891006, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+2, 180712, 1, -8240.89, -5266.22, 0, -2.30383, 0, 0, 0.913545, -0.406737, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+3, 180712, 1, -7906.06, -5256.7, 0, -2.77507, 0, 0, 0.983255, -0.182235, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+4, 180712, 1, -7764.8, -5141.1, 0, 2.35619, 0, 0, 0.92388, 0.382683, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+5, 180712, 1, -7727.08, -5125.11, 0, 1.41372, 0, 0, 0.649448, 0.760406, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+6, 180712, 1, -7691.51, -4923.28, 0, -0.663225, 0, 0, 0.325568, -0.945519, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+7, 180712, 1, -7663.48, -4878.64, 0, -0.907571, 0, 0, 0.438371, -0.898794, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+8, 180712, 1, -7569.51, -4913.58, 0, -0.296706, 0, 0, 0.147809, -0.989016, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+9, 180712, 1, -7518.89, -4886.82, 0, -2.14675, 0, 0, 0.878817, -0.477159, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+10, 180712, 1, -7230.44, -4919.24, 0, 2.07694, 0, 0, 0.861629, 0.507538, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+11, 180712, 1, -7175.57, -4915.66, 0, 0.20944, 0, 0, 0.104528, 0.994522, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+12, 180712, 1, -7055.77, -4876.62, 0, -1.64061, 0, 0, 0.731354, -0.681998, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+13, 180712, 1, -7020.72, -4871.83, 0, 4.71239, 0, 0, 0.707107, -0.707107, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+14, 180712, 1, -6951.29, -4907.06, 0, -2.89725, 0, 0, 0.992546, -0.121869, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+15, 180712, 1, -6932.98, -4950.85, 0, -1.25664, 0, 0, 0.587785, -0.809017, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+16, 180712, 1, -6839.84, -4888.99, 0, -1.25664, 0, 0, 0.587785, -0.809017, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+17, 180712, 1, -6765.14, -4867.56, 0, -2.19912, 0, 0, 0.891007, -0.45399, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+18, 180712, 1, -6710.04, -4814.66, 0, -1.09956, 0, 0, 0.522499, -0.85264, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+19, 180712, 1, -8190.47, -5306.45, 0, 3.80482, 0, 0, -0.945518, 0.325568, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+20, 180712, 1, -8128.53, -5371.78, 0, 2.3911, 0, 0, 0.930417, 0.366502, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+21, 180712, 1, -7892.33, -5235.03, 0, 0, 0, 0, 0, 1, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+22, 180712, 1, -7849.1, -5190.41, 0, 0.087266, 0, 0, 0.0436192, 0.999048, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+23, 180712, 1, -7795.85, -5143.96, 0, 3.9619, 0, 0, -0.91706, 0.39875, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+24, 180712, 1, -7614.26, -4877.65, 0, 1.0821, 0, 0, 0.515038, 0.857168, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+25, 180712, 1, -7467.02, -4942.85, 0, 2.9845, 0, 0, 0.996917, 0.0784664, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+26, 180712, 1, -7124.77, -4901.12, 0, 3.54302, 0, 0, -0.979924, 0.19937, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+27, 180712, 1, -6912.69, -4902.32, 0, 1.27409, 0, 0, 0.594822, 0.803857, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+28, 180712, 1, -8689.85, -4709.58, 0, 1.13446, 0, 0, 0.537299, 0.843392, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+29, 180712, 1, -8647.87, -4785.49, 0, 2.30383, 0, 0, 0.913545, 0.406738, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+30, 180712, 1, -8645.18, -4734.6, 0, 0.855211, 0, 0, 0.414693, 0.909961, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+31, 180712, 1, -8158.17, -5332.1, 0, 4.71239, 0, 0, -0.707107, 0.707107, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+32, 180712, 1, -8040.62, -5427.37, 0, 5.8294, 0, 0, -0.224951, 0.97437, 180, 180, 100, 1, 0, 0, 9, 10),
(@OGUID+33, 180750, 1, -8460.64, -5041.87, 0, -0.942478, 0, 0, 0.453991, -0.891006, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+34, 180750, 1, -8240.89, -5266.22, 0, -2.30383, 0, 0, 0.913545, -0.406737, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+35, 180750, 1, -7906.06, -5256.7, 0, -2.77507, 0, 0, 0.983255, -0.182235, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+36, 180750, 1, -7764.8, -5141.1, 0, 2.35619, 0, 0, 0.92388, 0.382683, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+37, 180750, 1, -7727.08, -5125.11, 0, 1.41372, 0, 0, 0.649448, 0.760406, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+38, 180750, 1, -7691.51, -4923.28, 0, -0.663225, 0, 0, 0.325568, -0.945519, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+39, 180750, 1, -7663.48, -4878.64, 0, -0.907571, 0, 0, 0.438371, -0.898794, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+40, 180750, 1, -7569.51, -4913.58, 0, -0.296706, 0, 0, 0.147809, -0.989016, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+41, 180750, 1, -7518.89, -4886.82, 0, -2.14675, 0, 0, 0.878817, -0.477159, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+42, 180750, 1, -7230.44, -4919.24, 0, 2.07694, 0, 0, 0.861629, 0.507538, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+43, 180750, 1, -7175.57, -4915.66, 0, 0.20944, 0, 0, 0.104528, 0.994522, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+44, 180750, 1, -7055.77, -4876.62, 0, -1.64061, 0, 0, 0.731354, -0.681998, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+45, 180750, 1, -7020.72, -4871.83, 0, 4.71239, 0, 0, 0.707107, -0.707107, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+46, 180750, 1, -6951.29, -4907.06, 0, -2.89725, 0, 0, 0.992546, -0.121869, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+47, 180750, 1, -6932.98, -4950.85, 0, -1.25664, 0, 0, 0.587785, -0.809017, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+48, 180750, 1, -6839.84, -4888.99, 0, -1.25664, 0, 0, 0.587785, -0.809017, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+49, 180750, 1, -6765.14, -4867.56, 0, -2.19912, 0, 0, 0.891007, -0.45399, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+50, 180750, 1, -6710.04, -4814.66, 0, -1.09956, 0, 0, 0.522499, -0.85264, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+51, 180750, 1, -8190.47, -5306.45, 0, 3.80482, 0, 0, -0.945518, 0.325568, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+52, 180750, 1, -8128.53, -5371.78, 0, 2.3911, 0, 0, 0.930417, 0.366502, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+53, 180750, 1, -7892.33, -5235.03, 0, 0, 0, 0, 0, 1, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+54, 180750, 1, -7849.1, -5190.41, 0, 0.087266, 0, 0, 0.0436192, 0.999048, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+55, 180750, 1, -7795.85, -5143.96, 0, 3.9619, 0, 0, -0.91706, 0.39875, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+56, 180750, 1, -7614.26, -4877.65, 0, 1.0821, 0, 0, 0.515038, 0.857168, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+57, 180750, 1, -7467.02, -4942.85, 0, 2.9845, 0, 0, 0.996917, 0.0784664, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+58, 180750, 1, -7124.77, -4901.12, 0, 3.54302, 0, 0, -0.979924, 0.19937, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+59, 180750, 1, -6912.69, -4902.32, 0, 1.27409, 0, 0, 0.594822, 0.803857, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+60, 180750, 1, -8689.85, -4709.58, 0, 1.13446, 0, 0, 0.537299, 0.843392, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+61, 180750, 1, -8647.87, -4785.49, 0, 2.30383, 0, 0, 0.913545, 0.406738, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+62, 180750, 1, -8645.18, -4734.6, 0, 0.855211, 0, 0, 0.414693, 0.909961, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+63, 180750, 1, -8158.17, -5332.1, 0, 4.71239, 0, 0, -0.707107, 0.707107, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+64, 180750, 1, -8040.62, -5427.37, 0, 5.8294, 0, 0, -0.224951, 0.97437, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+65, 180751, 1, -8460.64, -5041.87, 0, -0.942478, 0, 0, 0.453991, -0.891006, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+66, 180751, 1, -8240.89, -5266.22, 0, -2.30383, 0, 0, 0.913545, -0.406737, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+67, 180751, 1, -7906.06, -5256.7, 0, -2.77507, 0, 0, 0.983255, -0.182235, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+68, 180751, 1, -7764.8, -5141.1, 0, 2.35619, 0, 0, 0.92388, 0.382683, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+69, 180751, 1, -7727.08, -5125.11, 0, 1.41372, 0, 0, 0.649448, 0.760406, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+70, 180751, 1, -7691.51, -4923.28, 0, -0.663225, 0, 0, 0.325568, -0.945519, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+71, 180751, 1, -7663.48, -4878.64, 0, -0.907571, 0, 0, 0.438371, -0.898794, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+72, 180751, 1, -7569.51, -4913.58, 0, -0.296706, 0, 0, 0.147809, -0.989016, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+73, 180751, 1, -7518.89, -4886.82, 0, -2.14675, 0, 0, 0.878817, -0.477159, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+74, 180751, 1, -7230.44, -4919.24, 0, 2.07694, 0, 0, 0.861629, 0.507538, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+75, 180751, 1, -7175.57, -4915.66, 0, 0.20944, 0, 0, 0.104528, 0.994522, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+76, 180751, 1, -7055.77, -4876.62, 0, -1.64061, 0, 0, 0.731354, -0.681998, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+77, 180751, 1, -7020.72, -4871.83, 0, 4.71239, 0, 0, 0.707107, -0.707107, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+78, 180751, 1, -6951.29, -4907.06, 0, -2.89725, 0, 0, 0.992546, -0.121869, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+79, 180751, 1, -6932.98, -4950.85, 0, -1.25664, 0, 0, 0.587785, -0.809017, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+80, 180751, 1, -6839.84, -4888.99, 0, -1.25664, 0, 0, 0.587785, -0.809017, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+81, 180751, 1, -6765.14, -4867.56, 0, -2.19912, 0, 0, 0.891007, -0.45399, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+82, 180751, 1, -6710.04, -4814.66, 0, -1.09956, 0, 0, 0.522499, -0.85264, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+83, 180751, 1, -8190.47, -5306.45, 0, 3.80482, 0, 0, -0.945518, 0.325568, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+84, 180751, 1, -8128.53, -5371.78, 0, 2.3911, 0, 0, 0.930417, 0.366502, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+85, 180751, 1, -7892.33, -5235.03, 0, 0, 0, 0, 0, 1, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+86, 180751, 1, -7849.1, -5190.41, 0, 0.087266, 0, 0, 0.0436192, 0.999048, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+87, 180751, 1, -7795.85, -5143.96, 0, 3.9619, 0, 0, -0.91706, 0.39875, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+88, 180751, 1, -7614.26, -4877.65, 0, 1.0821, 0, 0, 0.515038, 0.857168, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+89, 180751, 1, -7467.02, -4942.85, 0, 2.9845, 0, 0, 0.996917, 0.0784664, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+90, 180751, 1, -7124.77, -4901.12, 0, 3.54302, 0, 0, -0.979924, 0.19937, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+91, 180751, 1, -6912.69, -4902.32, 0, 1.27409, 0, 0, 0.594822, 0.803857, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+92, 180751, 1, -8689.85, -4709.58, 0, 1.13446, 0, 0, 0.537299, 0.843392, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+93, 180751, 1, -8647.87, -4785.49, 0, 2.30383, 0, 0, 0.913545, 0.406738, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+94, 180751, 1, -8645.18, -4734.6, 0, 0.855211, 0, 0, 0.414693, 0.909961, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+95, 180751, 1, -8158.17, -5332.1, 0, 4.71239, 0, 0, -0.707107, 0.707107, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+96, 180751, 1, -8040.62, -5427.37, 0, 5.8294, 0, 0, -0.224951, 0.97437, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+97, 180752, 1, -8460.64, -5041.87, 0, -0.942478, 0, 0, 0.453991, -0.891006, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+98, 180752, 1, -8240.89, -5266.22, 0, -2.30383, 0, 0, 0.913545, -0.406737, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+99, 180752, 1, -7906.06, -5256.7, 0, -2.77507, 0, 0, 0.983255, -0.182235, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+100, 180752, 1, -7764.8, -5141.1, 0, 2.35619, 0, 0, 0.92388, 0.382683, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+101, 180752, 1, -7727.08, -5125.11, 0, 1.41372, 0, 0, 0.649448, 0.760406, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+102, 180752, 1, -7691.51, -4923.28, 0, -0.663225, 0, 0, 0.325568, -0.945519, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+103, 180752, 1, -7663.48, -4878.64, 0, -0.907571, 0, 0, 0.438371, -0.898794, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+104, 180752, 1, -7569.51, -4913.58, 0, -0.296706, 0, 0, 0.147809, -0.989016, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+105, 180752, 1, -7518.89, -4886.82, 0, -2.14675, 0, 0, 0.878817, -0.477159, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+106, 180752, 1, -7230.44, -4919.24, 0, 2.07694, 0, 0, 0.861629, 0.507538, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+107, 180752, 1, -7175.57, -4915.66, 0, 0.20944, 0, 0, 0.104528, 0.994522, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+108, 180752, 1, -7055.77, -4876.62, 0, -1.64061, 0, 0, 0.731354, -0.681998, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+109, 180752, 1, -7020.72, -4871.83, 0, 4.71239, 0, 0, 0.707107, -0.707107, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+110, 180752, 1, -6951.29, -4907.06, 0, -2.89725, 0, 0, 0.992546, -0.121869, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+111, 180752, 1, -6932.98, -4950.85, 0, -1.25664, 0, 0, 0.587785, -0.809017, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+112, 180752, 1, -6839.84, -4888.99, 0, -1.25664, 0, 0, 0.587785, -0.809017, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+113, 180752, 1, -6765.14, -4867.56, 0, -2.19912, 0, 0, 0.891007, -0.45399, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+114, 180752, 1, -6710.04, -4814.66, 0, -1.09956, 0, 0, 0.522499, -0.85264, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+115, 180752, 1, -8190.47, -5306.45, 0, 3.80482, 0, 0, -0.945518, 0.325568, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+116, 180752, 1, -8128.53, -5371.78, 0, 2.3911, 0, 0, 0.930417, 0.366502, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+117, 180752, 1, -7892.33, -5235.03, 0, 0, 0, 0, 0, 1, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+118, 180752, 1, -7849.1, -5190.41, 0, 0.087266, 0, 0, 0.0436192, 0.999048, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+119, 180752, 1, -7795.85, -5143.96, 0, 3.9619, 0, 0, -0.91706, 0.39875, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+120, 180752, 1, -7614.26, -4877.65, 0, 1.0821, 0, 0, 0.515038, 0.857168, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+121, 180752, 1, -7467.02, -4942.85, 0, 2.9845, 0, 0, 0.996917, 0.0784664, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+122, 180752, 1, -7124.77, -4901.12, 0, 3.54302, 0, 0, -0.979924, 0.19937, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+123, 180752, 1, -6912.69, -4902.32, 0, 1.27409, 0, 0, 0.594822, 0.803857, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+124, 180752, 1, -8689.85, -4709.58, 0, 1.13446, 0, 0, 0.537299, 0.843392, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+125, 180752, 1, -8647.87, -4785.49, 0, 2.30383, 0, 0, 0.913545, 0.406738, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+126, 180752, 1, -8645.18, -4734.6, 0, 0.855211, 0, 0, 0.414693, 0.909961, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+127, 180752, 1, -8158.17, -5332.1, 0, 4.71239, 0, 0, -0.707107, 0.707107, 180, 180, 100, 1, 0, 0, 7, 10),
(@OGUID+128, 180752, 1, -8040.62, -5427.37, 0, 5.8294, 0, 0, -0.224951, 0.97437, 180, 180, 100, 1, 0, 0, 7, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+1, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+2, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+3, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+4, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+5, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+6, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+7, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+8, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+9, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+10, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+11, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+12, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+13, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+14, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+15, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+16, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+17, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+18, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+19, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+20, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+21, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+22, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+23, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+24, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+25, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+26, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+27, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+28, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+29, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+30, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+31, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@PTEMPLATE+32, 1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10);
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_min`, `patch_max`) VALUES
(@OGUID+1, @PTEMPLATE+1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+2, @PTEMPLATE+2, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+3, @PTEMPLATE+3, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+4, @PTEMPLATE+4, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+5, @PTEMPLATE+5, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+6, @PTEMPLATE+6, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+7, @PTEMPLATE+7, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+8, @PTEMPLATE+8, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+9, @PTEMPLATE+9, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+10, @PTEMPLATE+10, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+11, @PTEMPLATE+11, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+12, @PTEMPLATE+12, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+13, @PTEMPLATE+13, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+14, @PTEMPLATE+14, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+15, @PTEMPLATE+15, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+16, @PTEMPLATE+16, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+17, @PTEMPLATE+17, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+18, @PTEMPLATE+18, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+19, @PTEMPLATE+19, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+20, @PTEMPLATE+20, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+21, @PTEMPLATE+21, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+22, @PTEMPLATE+22, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+23, @PTEMPLATE+23, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+24, @PTEMPLATE+24, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+25, @PTEMPLATE+25, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+26, @PTEMPLATE+26, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+27, @PTEMPLATE+27, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+28, @PTEMPLATE+28, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+29, @PTEMPLATE+29, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+30, @PTEMPLATE+30, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+31, @PTEMPLATE+31, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+32, @PTEMPLATE+32, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 9, 10),
(@OGUID+33, @PTEMPLATE+1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+34, @PTEMPLATE+2, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+35, @PTEMPLATE+3, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+36, @PTEMPLATE+4, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+37, @PTEMPLATE+5, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+38, @PTEMPLATE+6, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+39, @PTEMPLATE+7, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+40, @PTEMPLATE+8, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+41, @PTEMPLATE+9, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+42, @PTEMPLATE+10, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+43, @PTEMPLATE+11, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+44, @PTEMPLATE+12, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+45, @PTEMPLATE+13, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+46, @PTEMPLATE+14, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+47, @PTEMPLATE+15, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+48, @PTEMPLATE+16, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+49, @PTEMPLATE+17, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+50, @PTEMPLATE+18, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+51, @PTEMPLATE+19, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+52, @PTEMPLATE+20, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+53, @PTEMPLATE+21, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+54, @PTEMPLATE+22, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+55, @PTEMPLATE+23, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+56, @PTEMPLATE+24, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+57, @PTEMPLATE+25, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+58, @PTEMPLATE+26, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+59, @PTEMPLATE+27, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+60, @PTEMPLATE+28, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+61, @PTEMPLATE+29, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+62, @PTEMPLATE+30, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+63, @PTEMPLATE+31, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+64, @PTEMPLATE+32, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+65, @PTEMPLATE+1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+66, @PTEMPLATE+2, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+67, @PTEMPLATE+3, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+68, @PTEMPLATE+4, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+69, @PTEMPLATE+5, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+70, @PTEMPLATE+6, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+71, @PTEMPLATE+7, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+72, @PTEMPLATE+8, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+73, @PTEMPLATE+9, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+74, @PTEMPLATE+10, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+75, @PTEMPLATE+11, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+76, @PTEMPLATE+12, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+77, @PTEMPLATE+13, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+78, @PTEMPLATE+14, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+79, @PTEMPLATE+15, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+80, @PTEMPLATE+16, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+81, @PTEMPLATE+17, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+82, @PTEMPLATE+18, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+83, @PTEMPLATE+19, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+84, @PTEMPLATE+20, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+85, @PTEMPLATE+21, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+86, @PTEMPLATE+22, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+87, @PTEMPLATE+23, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+88, @PTEMPLATE+24, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+89, @PTEMPLATE+25, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+90, @PTEMPLATE+26, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+91, @PTEMPLATE+27, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+92, @PTEMPLATE+28, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+93, @PTEMPLATE+29, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+94, @PTEMPLATE+30, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+95, @PTEMPLATE+31, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+96, @PTEMPLATE+32, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+97, @PTEMPLATE+1, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+98, @PTEMPLATE+2, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+99, @PTEMPLATE+3, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+100, @PTEMPLATE+4, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+101, @PTEMPLATE+5, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+102, @PTEMPLATE+6, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+103, @PTEMPLATE+7, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+104, @PTEMPLATE+8, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+105, @PTEMPLATE+9, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+106, @PTEMPLATE+10, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+107, @PTEMPLATE+11, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+108, @PTEMPLATE+12, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+109, @PTEMPLATE+13, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+110, @PTEMPLATE+14, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+111, @PTEMPLATE+15, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+112, @PTEMPLATE+16, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+113, @PTEMPLATE+17, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+114, @PTEMPLATE+18, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+115, @PTEMPLATE+19, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+116, @PTEMPLATE+20, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+117, @PTEMPLATE+21, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+118, @PTEMPLATE+22, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+119, @PTEMPLATE+23, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+120, @PTEMPLATE+24, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+121, @PTEMPLATE+25, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+122, @PTEMPLATE+26, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+123, @PTEMPLATE+27, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+124, @PTEMPLATE+28, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+125, @PTEMPLATE+29, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+126, @PTEMPLATE+30, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+127, @PTEMPLATE+31, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10),
(@OGUID+128, @PTEMPLATE+32, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 7, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+33, 14, 'Wetlands - Firefin Snapper School / Floating Wreckage / Oily Blackmouth School (Master Pool)', 0, 0, 7, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(@PTEMPLATE+1, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+2, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+3, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+4, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+5, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+6, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+7, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+8, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+9, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+10, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+11, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+12, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+13, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+14, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+15, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+16, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+17, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+18, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+19, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+20, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+21, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+22, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+23, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+24, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+25, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+26, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+27, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+28, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+29, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+30, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+31, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0),
(@PTEMPLATE+32, @PTEMPLATE+33, 0, 'Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris', 0);
UPDATE `pool_gameobject` SET `chance` = 20 WHERE `description` = "Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 180712);
UPDATE `pool_gameobject` SET `chance` = 20 WHERE `description` = "Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 180750);
UPDATE `pool_gameobject` SET `chance` = 20 WHERE `description` = "Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 180751);
UPDATE `pool_gameobject` SET `chance` = 40 WHERE `description` = "Stonescale Eel Swarm / Oily Blackmouth School / Floating Wreckage / Firefin Snapper School - Tanaris" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 180752);
-- Tidy
SET @OGUID = 227;
-- Muddy Churning Waters
INSERT INTO `gameobject` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecsmin`, `spawntimesecsmax`, `state`, `animprogress`, `patch_min`, `patch_max`) VALUES
(@OGUID+1, 180369, 309, -11890.2, -1714.73, 10.4603, 2.96704, 0, 0, 0.996194, 0.087165, 600, 600, 1, 100, 5, 10),
(@OGUID+2, 180369, 309, -11887.7, -1643.9, 10.4603, 3.87463, 0, 0, -0.93358, 0.358368, 600, 600, 1, 100, 5, 10),
(@OGUID+3, 180369, 309, -11700.5, -1746.49, 10.4603, 3.56047, 0, 0, -0.978148, 0.207912, 600, 600, 1, 100, 5, 10),
(@OGUID+4, 180184, 0, -8306.6, -334.969, 143.974, 1.25664, 0, 0, 0.587785, 0.809017, 180, 180, 1, 100, 7, 10);
-- Remove Redundant Pool Objects
DELETE FROM `pool_gameobject` WHERE `guid`=18086;
DELETE FROM `pool_gameobject` WHERE `guid`=18284;
UPDATE `gameobject` SET `position_x`=-232.452, `position_y`=-1103.82, `position_z`=37.087, `orientation`=5.41052, `rotation0`=0, `rotation1`=0, `rotation2`=-0.422618, `rotation3`=0.906308 WHERE `guid`=38820;
UPDATE `gameobject` SET `position_x`=-619.02, `position_y`=-769.87, `position_z`=6.30651, `orientation`=3.28124, `rotation0`=0, `rotation1`=0, `rotation2`=-0.997563, `rotation3`=0.0697661 WHERE `guid`=38811;
UPDATE `gameobject` SET `position_x`=2509.32, `position_y`=-2855.59, `position_z`=150.072, `orientation`=3.89209, `rotation0`=0, `rotation1`=0, `rotation2`=-0.930417, `rotation3`=0.366502 WHERE `guid`=18162;
UPDATE `gameobject` SET `position_x`=-9801.39, `position_y`=1766.6, `position_z`=0, `orientation`=6.19592, `rotation0`=0, `rotation1`=0, `rotation2`=-0.0436192, `rotation3`=0.999048 WHERE `guid`=24548;
UPDATE `gameobject` SET `position_x`=-9801.39, `position_y`=1766.6, `position_z`=0, `orientation`=6.19592, `rotation0`=0, `rotation1`=0, `rotation2`=-0.0436192, `rotation3`=0.999048 WHERE `guid`=24570;
-- 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