sindoring/moonwell-core-vanilla
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Files
development
moonwell-core-vanilla/sql/migrations/20230716203252_world.sql
T
NickTyrer 94e65d2261 Correctly Pool Serpentbloom (#2095)
2025-01-11 16:36:32 +00:00

510 lines
39 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`='20230716203252');
IF v=0 THEN
INSERT INTO `migrations` VALUES ('20230716203252');
-- Add your query below.
SET @OGUID = 90447;
SET @PTEMPLATE = 4840;
DELETE FROM `gameobject` WHERE `id` IN (19535, 13891);
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, 19535, 1, -790.112, -2090.43, 75.3776, 5.75959, 0, 0, -0.258819, 0.965926, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+2, 19535, 1, -772.675, -2010.88, 76.9099, 3.99681, 0, 0, -0.909961, 0.414694, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+3, 19535, 1, -764.515, -2031.62, 74.7618, 0.174532, 0, 0, 0.0871553, 0.996195, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+4, 19535, 1, -735.047, -2128.06, 66.7948, 1.62316, 0, 0, 0.725374, 0.688355, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+5, 19535, 1, -733.289, -2059.56, 69.5646, 2.9845, 0, 0, 0.996917, 0.0784664, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+6, 19535, 1, -726.483, -2271.12, 15.2271, 0.90757, 0, 0, 0.438371, 0.898794, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+7, 19535, 1, -717.178, -2105.74, 65.7452, 3.05433, 0, 0, 0.999048, 0.0436193, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+8, 19535, 1, -714.765, -2196.67, 23.1311, 3.61284, 0, 0, -0.972369, 0.233448, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+9, 19535, 1, -712.644, -2100.71, 65.5757, 3.52557, 0, 0, -0.981627, 0.190812, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+10, 19535, 1, -711.709, -2059.59, 67.1504, 0.663223, 0, 0, 0.325567, 0.945519, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+11, 19535, 1, -705.331, -2249.41, 16.4384, 2.18166, 0, 0, 0.887011, 0.461749, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+12, 19535, 1, -701.884, -2218.17, 20.8294, 2.86233, 0, 0, 0.990268, 0.139175, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+13, 19535, 1, -697.014, -2289.91, 18.8826, 2.02458, 0, 0, 0.848047, 0.529921, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+14, 19535, 1, -695.57, -2347.8, 19.9718, 1.78023, 0, 0, 0.777145, 0.629321, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+15, 19535, 1, -684.335, -2025.38, 65.8255, 5.88176, 0, 0, -0.199367, 0.979925, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+16, 19535, 1, -682.942, -2177.61, 33.2036, 4.97419, 0, 0, -0.608761, 0.793354, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+17, 19535, 1, -682.722, -2254.79, 18.7693, 1.53589, 0, 0, 0.694658, 0.71934, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+18, 19535, 1, -674.612, -2202.58, 25.4651, 0.750491, 0, 0, 0.366501, 0.930418, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+19, 19535, 1, -673.19, -2303.09, 17.4874, 0.733038, 0, 0, 0.358368, 0.933581, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+20, 19535, 1, -672.65, -2006.37, 64.6799, 5.74214, 0, 0, -0.267238, 0.963631, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+21, 19535, 1, -668.704, -2345.26, 19.2826, 0.523598, 0, 0, 0.258819, 0.965926, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+22, 19535, 1, -665.233, -2180.84, 38.0531, 4.08407, 0, 0, -0.891007, 0.453991, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+23, 19535, 1, -652.025, -2002.88, 61.538, 1.78023, 0, 0, 0.777145, 0.629321, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+24, 19535, 1, -651.604, -2012.53, 61.4689, 2.46091, 0, 0, 0.942641, 0.333808, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+25, 19535, 1, -651.434, -2350.74, 20.8452, 0.942477, 0, 0, 0.45399, 0.891007, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+26, 19535, 1, -638.849, -2386.47, 26.1388, 1.90241, 0, 0, 0.814116, 0.580703, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+27, 19535, 1, -638.661, -2194, 47.1215, 5.34071, 0, 0, -0.45399, 0.891007, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+28, 19535, 1, -627.042, -2030.84, 64.4065, 4.31097, 0, 0, -0.833885, 0.551938, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+29, 19535, 1, -617.797, -2341.75, 24.9618, 5.65487, 0, 0, -0.309016, 0.951057, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+30, 19535, 1, -611.487, -2189.51, 50.5219, 4.55531, 0, 0, -0.760405, 0.649449, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+31, 19535, 1, -599.772, -2044.96, 57.1683, 3.82227, 0, 0, -0.942641, 0.333808, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+32, 19535, 1, -598.61, -2130.15, 50.8574, 3.33359, 0, 0, -0.995396, 0.0958512, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+33, 19535, 1, -594.864, -2313.16, 29.4314, 5.98648, 0, 0, -0.147809, 0.989016, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+34, 19535, 1, -594.464, -2243.1, 41.6844, 4.72984, 0, 0, -0.700909, 0.713251, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+35, 19535, 1, -593.929, -2212.07, 44.7419, 5.39307, 0, 0, -0.43051, 0.902586, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+36, 19535, 1, -593.693, -2027.24, 58.0042, 3.17653, 0, 0, -0.999847, 0.0174693, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+37, 19535, 1, -592.358, -2379.54, 27.225, 2.33874, 0, 0, 0.920505, 0.390732, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+38, 19535, 1, -591.51, -2164.19, 52.2478, 0.59341, 0, 0, 0.292371, 0.956305, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+39, 19535, 1, -587.601, -2340.45, 25.5701, 0.523598, 0, 0, 0.258819, 0.965926, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+40, 19535, 1, -584.853, -2083.25, 54.9603, 1.93731, 0, 0, 0.824125, 0.566408, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+41, 19535, 1, -583.244, -2190.81, 46.6335, 0.942477, 0, 0, 0.45399, 0.891007, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+42, 19535, 1, -579.235, -2280.78, 35.023, 2.58308, 0, 0, 0.961261, 0.27564, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+43, 19535, 1, -577.169, -2250.14, 40.0093, 0.541051, 0, 0, 0.267238, 0.963631, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+44, 19535, 1, -573.982, -2237.65, 40.8063, 4.17134, 0, 0, -0.870356, 0.492424, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+45, 19535, 1, -571.874, -2311.13, 27.9957, 0.244346, 0, 0, 0.121869, 0.992546, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+46, 19535, 1, -569.083, -2060.46, 55.7272, 0.331611, 0, 0, 0.165047, 0.986286, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+47, 19535, 1, -566.237, -2327.57, 26.3198, 1.81514, 0, 0, 0.788011, 0.615662, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+48, 19535, 1, -564.216, -2206.49, 49.0798, 5.39307, 0, 0, -0.43051, 0.902586, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+49, 19535, 1, -549.292, -2273.09, 40.9208, 3.63029, 0, 0, -0.970295, 0.241925, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+50, 19535, 1, -542.759, -2296.61, 39.7582, 0.90757, 0, 0, 0.438371, 0.898794, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+51, 19535, 1, -542.541, -2247.05, 43.3624, 3.75246, 0, 0, -0.953716, 0.300708, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+52, 19535, 1, -703.291, -2313.56, 19.4716, 5.89921, 0, 0, -0.190808, 0.981627, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+53, 13891, 1, -790.112, -2090.43, 75.3776, 5.75959, 0, 0, -0.258819, 0.965926, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+54, 13891, 1, -772.675, -2010.88, 76.9099, 3.99681, 0, 0, -0.909961, 0.414694, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+55, 13891, 1, -764.515, -2031.62, 74.7618, 0.174532, 0, 0, 0.0871553, 0.996195, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+56, 13891, 1, -735.047, -2128.06, 66.7948, 1.62316, 0, 0, 0.725374, 0.688355, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+57, 13891, 1, -733.289, -2059.56, 69.5646, 2.9845, 0, 0, 0.996917, 0.0784664, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+58, 13891, 1, -726.483, -2271.12, 15.2271, 0.90757, 0, 0, 0.438371, 0.898794, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+59, 13891, 1, -717.178, -2105.74, 65.7452, 3.05433, 0, 0, 0.999048, 0.0436193, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+60, 13891, 1, -714.765, -2196.67, 23.1311, 3.61284, 0, 0, -0.972369, 0.233448, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+61, 13891, 1, -712.644, -2100.71, 65.5757, 3.52557, 0, 0, -0.981627, 0.190812, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+62, 13891, 1, -711.709, -2059.59, 67.1504, 0.663223, 0, 0, 0.325567, 0.945519, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+63, 13891, 1, -705.331, -2249.41, 16.4384, 2.18166, 0, 0, 0.887011, 0.461749, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+64, 13891, 1, -701.884, -2218.17, 20.8294, 2.86233, 0, 0, 0.990268, 0.139175, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+65, 13891, 1, -697.014, -2289.91, 18.8826, 2.02458, 0, 0, 0.848047, 0.529921, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+66, 13891, 1, -695.57, -2347.8, 19.9718, 1.78023, 0, 0, 0.777145, 0.629321, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+67, 13891, 1, -684.335, -2025.38, 65.8255, 5.88176, 0, 0, -0.199367, 0.979925, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+68, 13891, 1, -682.942, -2177.61, 33.2036, 4.97419, 0, 0, -0.608761, 0.793354, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+69, 13891, 1, -682.722, -2254.79, 18.7693, 1.53589, 0, 0, 0.694658, 0.71934, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+70, 13891, 1, -674.612, -2202.58, 25.4651, 0.750491, 0, 0, 0.366501, 0.930418, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+71, 13891, 1, -673.19, -2303.09, 17.4874, 0.733038, 0, 0, 0.358368, 0.933581, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+72, 13891, 1, -672.65, -2006.37, 64.6799, 5.74214, 0, 0, -0.267238, 0.963631, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+73, 13891, 1, -668.704, -2345.26, 19.2826, 0.523598, 0, 0, 0.258819, 0.965926, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+74, 13891, 1, -665.233, -2180.84, 38.0531, 4.08407, 0, 0, -0.891007, 0.453991, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+75, 13891, 1, -652.025, -2002.88, 61.538, 1.78023, 0, 0, 0.777145, 0.629321, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+76, 13891, 1, -651.604, -2012.53, 61.4689, 2.46091, 0, 0, 0.942641, 0.333808, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+77, 13891, 1, -651.434, -2350.74, 20.8452, 0.942477, 0, 0, 0.45399, 0.891007, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+78, 13891, 1, -638.849, -2386.47, 26.1388, 1.90241, 0, 0, 0.814116, 0.580703, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+79, 13891, 1, -638.661, -2194, 47.1215, 5.34071, 0, 0, -0.45399, 0.891007, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+80, 13891, 1, -627.042, -2030.84, 64.4065, 4.31097, 0, 0, -0.833885, 0.551938, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+81, 13891, 1, -617.797, -2341.75, 24.9618, 5.65487, 0, 0, -0.309016, 0.951057, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+82, 13891, 1, -611.487, -2189.51, 50.5219, 4.55531, 0, 0, -0.760405, 0.649449, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+83, 13891, 1, -599.772, -2044.96, 57.1683, 3.82227, 0, 0, -0.942641, 0.333808, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+84, 13891, 1, -598.61, -2130.15, 50.8574, 3.33359, 0, 0, -0.995396, 0.0958512, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+85, 13891, 1, -594.864, -2313.16, 29.4314, 5.98648, 0, 0, -0.147809, 0.989016, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+86, 13891, 1, -594.464, -2243.1, 41.6844, 4.72984, 0, 0, -0.700909, 0.713251, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+87, 13891, 1, -593.929, -2212.07, 44.7419, 5.39307, 0, 0, -0.43051, 0.902586, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+88, 13891, 1, -593.693, -2027.24, 58.0042, 3.17653, 0, 0, -0.999847, 0.0174693, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+89, 13891, 1, -592.358, -2379.54, 27.225, 2.33874, 0, 0, 0.920505, 0.390732, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+90, 13891, 1, -591.51, -2164.19, 52.2478, 0.59341, 0, 0, 0.292371, 0.956305, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+91, 13891, 1, -587.601, -2340.45, 25.5701, 0.523598, 0, 0, 0.258819, 0.965926, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+92, 13891, 1, -584.853, -2083.25, 54.9603, 1.93731, 0, 0, 0.824125, 0.566408, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+93, 13891, 1, -583.244, -2190.81, 46.6335, 0.942477, 0, 0, 0.45399, 0.891007, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+94, 13891, 1, -579.235, -2280.78, 35.023, 2.58308, 0, 0, 0.961261, 0.27564, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+95, 13891, 1, -577.169, -2250.14, 40.0093, 0.541051, 0, 0, 0.267238, 0.963631, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+96, 13891, 1, -573.982, -2237.65, 40.8063, 4.17134, 0, 0, -0.870356, 0.492424, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+97, 13891, 1, -571.874, -2311.13, 27.9957, 0.244346, 0, 0, 0.121869, 0.992546, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+98, 13891, 1, -569.083, -2060.46, 55.7272, 0.331611, 0, 0, 0.165047, 0.986286, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+99, 13891, 1, -566.237, -2327.57, 26.3198, 1.81514, 0, 0, 0.788011, 0.615662, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+100, 13891, 1, -564.216, -2206.49, 49.0798, 5.39307, 0, 0, -0.43051, 0.902586, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+101, 13891, 1, -549.292, -2273.09, 40.9208, 3.63029, 0, 0, -0.970295, 0.241925, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+102, 13891, 1, -542.759, -2296.61, 39.7582, 0.90757, 0, 0, 0.438371, 0.898794, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+103, 13891, 1, -542.541, -2247.05, 43.3624, 3.75246, 0, 0, -0.953716, 0.300708, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+104, 13891, 1, -703.291, -2313.56, 19.4716, 5.89921, 0, 0, -0.190808, 0.981627, 300, 300, 100, 1, 0, 0, 0, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_max`) VALUES
(@PTEMPLATE+1, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+2, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+3, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+4, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+5, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+6, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+7, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+8, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+9, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+10, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+11, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+12, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+13, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+14, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+15, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+16, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+17, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+18, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+19, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+20, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+21, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+22, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+23, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+24, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+25, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+26, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+27, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+28, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+29, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+30, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+31, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+32, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+33, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+34, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+35, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+36, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+37, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+38, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+39, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+40, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+41, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+42, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+43, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+44, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+45, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+46, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+47, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+48, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+49, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+50, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+51, 2, 'Barrens - Serpentbloom', 10),
(@PTEMPLATE+52, 2, 'Barrens - Serpentbloom', 10);
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_max`, `chance`) VALUES
(@OGUID+1, @PTEMPLATE+1, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+2, @PTEMPLATE+2, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+3, @PTEMPLATE+3, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+4, @PTEMPLATE+4, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+5, @PTEMPLATE+5, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+6, @PTEMPLATE+6, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+7, @PTEMPLATE+7, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+8, @PTEMPLATE+8, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+9, @PTEMPLATE+9, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+10, @PTEMPLATE+10, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+11, @PTEMPLATE+11, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+12, @PTEMPLATE+12, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+13, @PTEMPLATE+13, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+14, @PTEMPLATE+14, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+15, @PTEMPLATE+15, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+16, @PTEMPLATE+16, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+17, @PTEMPLATE+17, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+18, @PTEMPLATE+18, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+19, @PTEMPLATE+19, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+20, @PTEMPLATE+20, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+21, @PTEMPLATE+21, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+22, @PTEMPLATE+22, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+23, @PTEMPLATE+23, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+24, @PTEMPLATE+24, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+25, @PTEMPLATE+25, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+26, @PTEMPLATE+26, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+27, @PTEMPLATE+27, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+28, @PTEMPLATE+28, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+29, @PTEMPLATE+29, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+30, @PTEMPLATE+30, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+31, @PTEMPLATE+31, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+32, @PTEMPLATE+32, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+33, @PTEMPLATE+33, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+34, @PTEMPLATE+34, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+35, @PTEMPLATE+35, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+36, @PTEMPLATE+36, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+37, @PTEMPLATE+37, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+38, @PTEMPLATE+38, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+39, @PTEMPLATE+39, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+40, @PTEMPLATE+40, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+41, @PTEMPLATE+41, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+42, @PTEMPLATE+42, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+43, @PTEMPLATE+43, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+44, @PTEMPLATE+44, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+45, @PTEMPLATE+45, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+46, @PTEMPLATE+46, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+47, @PTEMPLATE+47, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+48, @PTEMPLATE+48, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+49, @PTEMPLATE+49, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+50, @PTEMPLATE+50, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+51, @PTEMPLATE+51, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+52, @PTEMPLATE+52, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+53, @PTEMPLATE+1, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+54, @PTEMPLATE+2, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+55, @PTEMPLATE+3, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+56, @PTEMPLATE+4, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+57, @PTEMPLATE+5, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+58, @PTEMPLATE+6, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+59, @PTEMPLATE+7, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+60, @PTEMPLATE+8, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+61, @PTEMPLATE+9, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+62, @PTEMPLATE+10, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+63, @PTEMPLATE+11, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+64, @PTEMPLATE+12, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+65, @PTEMPLATE+13, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+66, @PTEMPLATE+14, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+67, @PTEMPLATE+15, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+68, @PTEMPLATE+16, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+69, @PTEMPLATE+17, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+70, @PTEMPLATE+18, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+71, @PTEMPLATE+19, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+72, @PTEMPLATE+20, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+73, @PTEMPLATE+21, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+74, @PTEMPLATE+22, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+75, @PTEMPLATE+23, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+76, @PTEMPLATE+24, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+77, @PTEMPLATE+25, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+78, @PTEMPLATE+26, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+79, @PTEMPLATE+27, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+80, @PTEMPLATE+28, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+81, @PTEMPLATE+29, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+82, @PTEMPLATE+30, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+83, @PTEMPLATE+31, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+84, @PTEMPLATE+32, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+85, @PTEMPLATE+33, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+86, @PTEMPLATE+34, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+87, @PTEMPLATE+35, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+88, @PTEMPLATE+36, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+89, @PTEMPLATE+37, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+90, @PTEMPLATE+38, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+91, @PTEMPLATE+39, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+92, @PTEMPLATE+40, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+93, @PTEMPLATE+41, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+94, @PTEMPLATE+42, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+95, @PTEMPLATE+43, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+96, @PTEMPLATE+44, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+97, @PTEMPLATE+45, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+98, @PTEMPLATE+46, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+99, @PTEMPLATE+47, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+100, @PTEMPLATE+48, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+101, @PTEMPLATE+49, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+102, @PTEMPLATE+50, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+103, @PTEMPLATE+51, 'Barrens - Serpentbloom', 10, 100),
(@OGUID+104, @PTEMPLATE+52, 'Barrens - Serpentbloom', 10, 100);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+53, 8, 'Barrens - Serpentbloom (Master Pool)', 0, 0, 0, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(@PTEMPLATE+1, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+2, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+3, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+4, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+5, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+6, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+7, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+8, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+9, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+10, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+11, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+12, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+13, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+14, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+15, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+16, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+17, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+18, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+19, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+20, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+21, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+22, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+23, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+24, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+25, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+26, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+27, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+28, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+29, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+30, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+31, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+32, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+33, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+34, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+35, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+36, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+37, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+38, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+39, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+40, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+41, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+42, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+43, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+44, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+45, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+46, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+47, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+48, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+49, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+50, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+51, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0),
(@PTEMPLATE+52, @PTEMPLATE+53, 0, 'Barrens - Serpentbloom', 0);
-- Instance Serpentbloom
SET @OGUID = 93886;
SET @PTEMPLATE = 7123;
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, 19535, 43, -31.3704, 268.373, -103.759, 3.4383, 0, 0, -0.989016, 0.147811, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+2, 19535, 43, 28.4734, 146.89, -90.4116, 4.50295, 0, 0, -0.777145, 0.629321, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+3, 19535, 43, 45.9468, 275.327, -89.1026, 4.06662, 0, 0, -0.894934, 0.446199, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+4, 19535, 43, 3.27935, 411.871, -65.9418, 4.11898, 0, 0, -0.882947, 0.469473, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+5, 19535, 43, -35.8711, 463.283, -54.8242, 3.35105, 0, 0, -0.994521, 0.104535, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+6, 19535, 43, 60.8215, 459.733, -63.9568, 3.6652, 0, 0, -0.965925, 0.258821, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+7, 19535, 43, -46.0182, 63.2591, -85.9721, 2.16421, 0, 0, 0.882947, 0.469473, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+8, 19535, 43, -64.4431, 62.0624, -28.4545, 3.927, 0, 0, -0.923879, 0.382686, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+9, 19535, 43, -196.059, 29.3717, -50.2278, 0.645772, 0, 0, 0.317305, 0.948324, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+10, 19535, 43, -223.392, -50.9034, -102.96, 3.49067, 0, 0, -0.984807, 0.173652, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+11, 19535, 43, -178.29, -101.693, -65.8531, 3.49067, 0, 0, -0.984807, 0.173652, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+12, 19535, 43, -360.631, 43.2781, -100.909, 4.45059, 0, 0, -0.793353, 0.608762, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+13, 19535, 43, -111.872, -38.7467, -28.4545, 3.24635, 0, 0, -0.998629, 0.0523532, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+14, 19535, 43, -147.206, -146.156, -66.9507, 4.71239, 0, 0, -0.707107, 0.707107, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+15, 19535, 43, -232.344, -148.216, -62.7499, 4.20625, 0, 0, -0.861628, 0.507539, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+16, 19535, 43, -0.314322, -42.1754, -65.0227, 6.05629, 0, 0, -0.113203, 0.993572, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+17, 19535, 43, -169.717, -224.064, -55.6624, 2.18166, 0, 0, 0.887011, 0.461749, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+18, 19535, 43, -94.1341, -264.677, -55.5865, 1.06465, 0, 0, 0.507538, 0.861629, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+19, 19535, 43, -36.2995, -281.637, -66.5813, 5.3058, 0, 0, -0.469471, 0.882948, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+20, 19535, 43, 48.0354, -165.494, -81.7236, 0.767944, 0, 0, 0.374606, 0.927184, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+21, 19535, 43, -164.128, -337.607, -68.9215, 0.95993, 0, 0, 0.461748, 0.887011, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+22, 19535, 43, -293.322, -319.377, -68.2288, 5.39307, 0, 0, -0.43051, 0.902586, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+23, 19535, 43, -382.755, -100.201, -64.46, 4.39823, 0, 0, -0.809016, 0.587786, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+24, 19535, 43, -95.8325, 423.05, -106.731, 2.84488, 0, 0, 0.989016, 0.147811, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+25, 19535, 43, 60.8216, 459.733, -63.9568, 3.6652, 0, 0, -0.965925, 0.258821, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+26, 13891, 43, -31.3704, 268.373, -103.759, 3.4383, 0, 0, -0.989016, 0.147811, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+27, 13891, 43, 28.4734, 146.89, -90.4116, 4.50295, 0, 0, -0.777145, 0.629321, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+28, 13891, 43, 45.9468, 275.327, -89.1026, 4.06662, 0, 0, -0.894934, 0.446199, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+29, 13891, 43, 3.27935, 411.871, -65.9418, 4.11898, 0, 0, -0.882947, 0.469473, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+30, 13891, 43, -35.8711, 463.283, -54.8242, 3.35105, 0, 0, -0.994521, 0.104535, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+31, 13891, 43, 60.8215, 459.733, -63.9568, 3.6652, 0, 0, -0.965925, 0.258821, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+32, 13891, 43, -46.0182, 63.2591, -85.9721, 2.16421, 0, 0, 0.882947, 0.469473, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+33, 13891, 43, -64.4431, 62.0624, -28.4545, 3.927, 0, 0, -0.923879, 0.382686, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+34, 13891, 43, -196.059, 29.3717, -50.2278, 0.645772, 0, 0, 0.317305, 0.948324, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+35, 13891, 43, -223.392, -50.9034, -102.96, 3.49067, 0, 0, -0.984807, 0.173652, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+36, 13891, 43, -178.29, -101.693, -65.8531, 3.49067, 0, 0, -0.984807, 0.173652, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+37, 13891, 43, -360.631, 43.2781, -100.909, 4.45059, 0, 0, -0.793353, 0.608762, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+38, 13891, 43, -111.872, -38.7467, -28.4545, 3.24635, 0, 0, -0.998629, 0.0523532, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+39, 13891, 43, -147.206, -146.156, -66.9507, 4.71239, 0, 0, -0.707107, 0.707107, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+40, 13891, 43, -232.344, -148.216, -62.7499, 4.20625, 0, 0, -0.861628, 0.507539, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+41, 13891, 43, -0.314322, -42.1754, -65.0227, 6.05629, 0, 0, -0.113203, 0.993572, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+42, 13891, 43, -169.717, -224.064, -55.6624, 2.18166, 0, 0, 0.887011, 0.461749, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+43, 13891, 43, -94.1341, -264.677, -55.5865, 1.06465, 0, 0, 0.507538, 0.861629, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+44, 13891, 43, -36.2995, -281.637, -66.5813, 5.3058, 0, 0, -0.469471, 0.882948, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+45, 13891, 43, 48.0354, -165.494, -81.7236, 0.767944, 0, 0, 0.374606, 0.927184, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+46, 13891, 43, -164.128, -337.607, -68.9215, 0.95993, 0, 0, 0.461748, 0.887011, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+47, 13891, 43, -293.322, -319.377, -68.2288, 5.39307, 0, 0, -0.43051, 0.902586, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+48, 13891, 43, -382.755, -100.201, -64.46, 4.39823, 0, 0, -0.809016, 0.587786, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+49, 13891, 43, -95.8325, 423.05, -106.731, 2.84488, 0, 0, 0.989016, 0.147811, 604800, 604800, 100, 1, 0, 0, 0, 10),
(@OGUID+50, 13891, 43, 60.8216, 459.733, -63.9568, 3.6652, 0, 0, -0.965925, 0.258821, 604800, 604800, 100, 1, 0, 0, 0, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_max`) VALUES
(@PTEMPLATE+1, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+2, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+3, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+4, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+5, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+6, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+7, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+8, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+9, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+10, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+11, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+12, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+13, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+14, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+15, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+16, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+17, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+18, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+19, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+20, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+21, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+22, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+23, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+24, 2, 'Wailing Caverns - Serpentbloom', 10),
(@PTEMPLATE+25, 2, 'Wailing Caverns - Serpentbloom', 10);
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_max`, `chance`) VALUES
(@OGUID+1, @PTEMPLATE+1, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+2, @PTEMPLATE+2, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+3, @PTEMPLATE+3, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+4, @PTEMPLATE+4, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+5, @PTEMPLATE+5, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+6, @PTEMPLATE+6, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+7, @PTEMPLATE+7, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+8, @PTEMPLATE+8, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+9, @PTEMPLATE+9, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+10, @PTEMPLATE+10, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+11, @PTEMPLATE+11, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+12, @PTEMPLATE+12, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+13, @PTEMPLATE+13, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+14, @PTEMPLATE+14, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+15, @PTEMPLATE+15, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+16, @PTEMPLATE+16, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+17, @PTEMPLATE+17, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+18, @PTEMPLATE+18, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+19, @PTEMPLATE+19, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+20, @PTEMPLATE+20, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+21, @PTEMPLATE+21, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+22, @PTEMPLATE+22, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+23, @PTEMPLATE+23, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+24, @PTEMPLATE+24, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+25, @PTEMPLATE+25, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+26, @PTEMPLATE+1, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+27, @PTEMPLATE+2, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+28, @PTEMPLATE+3, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+29, @PTEMPLATE+4, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+30, @PTEMPLATE+5, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+31, @PTEMPLATE+6, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+32, @PTEMPLATE+7, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+33, @PTEMPLATE+8, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+34, @PTEMPLATE+9, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+35, @PTEMPLATE+10, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+36, @PTEMPLATE+11, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+37, @PTEMPLATE+12, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+38, @PTEMPLATE+13, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+39, @PTEMPLATE+14, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+40, @PTEMPLATE+15, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+41, @PTEMPLATE+16, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+42, @PTEMPLATE+17, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+43, @PTEMPLATE+18, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+44, @PTEMPLATE+19, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+45, @PTEMPLATE+20, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+46, @PTEMPLATE+21, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+47, @PTEMPLATE+22, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+48, @PTEMPLATE+23, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+49, @PTEMPLATE+24, 'Wailing Caverns - Serpentbloom', 10, 100),
(@OGUID+50, @PTEMPLATE+25, 'Wailing Caverns - Serpentbloom', 10, 100);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(@PTEMPLATE+26, 8, 'Wailing Caverns - Serpentbloom (Master Pool)', 0, 0, 0, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(@PTEMPLATE+1, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+2, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+3, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+4, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+5, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+6, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+7, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+8, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+9, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+10, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+11, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+12, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+13, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+14, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+15, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+16, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+17, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+18, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+19, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+20, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+21, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+22, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+23, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+24, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 0),
(@PTEMPLATE+25, @PTEMPLATE+26, 0, 'Wailing Caverns - Serpentbloom', 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