NickTyrer
280 lines
25 KiB
SQL
280 lines
25 KiB
SQL
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`='20250205172158');
|
|
IF v = 0 THEN
|
|
INSERT INTO `migrations` VALUES ('20250205172158');
|
|
-- Add your query below.
|
|
|
|
|
|
-- Duskwood
|
|
UPDATE `pool_template` SET `description` = 'Copper Veins - Duskwood (Master Pool)' WHERE `entry` = 1119;
|
|
|
|
-- Silver Vein / Gold Vein / Iron Deposit
|
|
SET @OGUID = 98643;
|
|
SET @PTEMPLATE = 6329;
|
|
|
|
DELETE FROM `gameobject` WHERE `guid` IN (25288, 85056, 85057, 85058, 230871, 230872, 230873, 230874, 230875, 230876, 230877, 230878, 230879, 230880, 230881, 230882, 230883, 230884, 230885, 230886, 2225, 2226, 25252, 25253, 25254, 25255, 25256, 25257, 25258, 25259, 25260, 25261, 25262, 25263, 25264, 25265, 25266, 25267, 25268, 25269, 25270, 25271, 25272, 25273, 25274, 25275, 25276, 25277, 25278, 25279, 25280, 25281, 25282, 25283, 25284, 25285, 25286, 25287, 34782, 34783, 34784, 34785, 427154, 427155, 427156, 427157, 427158, 427159, 427160, 427161);
|
|
DELETE FROM `pool_gameobject` WHERE `guid` IN (25288, 85056, 85057, 85058, 230871, 230872, 230873, 230874, 230875, 230876, 230877, 230878, 230879, 230880, 230881, 230882, 230883, 230884, 230885, 230886, 2225, 2226, 25252, 25253, 25254, 25255, 25256, 25257, 25258, 25259, 25260, 25261, 25262, 25263, 25264, 25265, 25266, 25267, 25268, 25269, 25270, 25271, 25272, 25273, 25274, 25275, 25276, 25277, 25278, 25279, 25280, 25281, 25282, 25283, 25284, 25285, 25286, 25287, 34782, 34783, 34784, 34785, 427154, 427155, 427156, 427157, 427158, 427159, 427160, 427161);
|
|
DELETE FROM `pool_template` WHERE `entry` IN (1120, 18830, 18821, 18822, 18823, 18824, 23045, 2555, 2556, 2557, 2558, 2559, 2560, 2561, 2562, 2563, 2564, 2565, 2566, 2567, 2568, 2569, 2570, 2571, 2572, 17058, 17059, 17060, 17061, 34916, 34917);
|
|
DELETE FROM `pool_pool` WHERE `mother_pool` IN (1120, 18830);
|
|
|
|
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, 1733, 0, -11137.5, -1174.14, 43.9296, 2.47837, 0, 0, 0.945518, 0.325568, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+2, 1733, 0, -11044.9, -53.2847, 18.2922, 4.85202, 0, 0, -0.656058, 0.75471, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+3, 1733, 0, -11010, -989.044, 69.0113, 4.93928, 0, 0, -0.622514, 0.782609, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+4, 1733, 0, -10678.7, -908.818, 68.4815, 2.65289, 0, 0, 0.970295, 0.241925, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+5, 1733, 0, -10600.1, -1520.67, 92.0927, 5.96903, 0, 0, -0.156434, 0.987688, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+6, 1733, 0, -10563.4, -1486.63, 95.4168, 0.0349062, 0, 0, 0.0174522, 0.999848, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+7, 1733, 0, -10559.6, -724.451, 76.4627, 5.49779, 0, 0, -0.382683, 0.92388, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+8, 1733, 0, -10446.1, -1312.74, 63.4724, 5.86431, 0, 0, -0.207911, 0.978148, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+9, 1733, 0, -10415.6, -1253.79, 52.5802, 3.49067, 0, 0, -0.984807, 0.173652, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+10, 1733, 0, -10395.8, 113.076, 34.8874, 1.81514, 0, 0, 0.788011, 0.615662, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+11, 1733, 0, -10329.5, 134.72, 35.5812, 2.54818, 0, 0, 0.956305, 0.292372, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+12, 1733, 0, -10301.6, -1467.02, 90.2184, 5.91667, 0, 0, -0.182235, 0.983255, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+13, 1733, 0, -11212.6, -174.63, 4.63508, -0.366519, 0, 0, 0.182236, -0.983255, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+14, 1733, 0, -11210.8, -846.305, 78.2837, -0.575959, 0, 0, 0.284015, -0.95882, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+15, 1733, 0, -11183.7, -135.158, 8.11372, 2.09439, 0, 0, 0.866025, 0.500001, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+16, 1733, 0, -11116, -937.882, 66.9419, 1.6057, 0, 0, 0.719339, 0.694659, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+17, 1733, 0, -11099.1, -1155.73, 42.4535, 0.331611, 0, 0, 0.165047, 0.986286, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+18, 1733, 0, -10436.5, -780.711, 58.56, -0.244346, 0, 0, 0.121869, -0.992546, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+19, 1733, 0, -11152.4, -150.115, 10.1164, 2.70526, 0, 0, 0.976295, 0.216442, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+20, 1733, 0, -10283.3, -709.007, 55.0537, 4.15388, 0, 0, -0.874619, 0.48481, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+21, 1733, 0, -11160.1, -1168.44, 44.7962, 0.785397, 0, 0, 0.382683, 0.92388, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+22, 1733, 0, -11141.6, -866.69, 73.6912, 2.51327, 0, 0, 0.951056, 0.309017, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+23, 1733, 0, -11105.3, -138.255, 14.2671, 5.51524, 0, 0, -0.374606, 0.927184, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+24, 1733, 0, -10395.6, -748.918, 72.097, 5.18363, 0, 0, -0.522498, 0.85264, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+25, 1733, 0, -11080.6, -1109.6, 45.5113, -1.51844, 0, 0, 0.688354, -0.725374, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+26, 1733, 0, -10662.4, -894.27, 58.8167, 0.994837, 0, 0, 0.477159, 0.878817, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+27, 1733, 0, -10362.5, -1404.4, 81.8085, 1.22173, 0, 0, 0.573576, 0.819152, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+28, 1733, 0, -10237.8, -1291.58, 46.9721, 5.06146, 0, 0, -0.573576, 0.819152, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+29, 1733, 0, -10233.3, -1358.39, 83.4799, 2.30383, 0, 0, 0.913545, 0.406738, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+30, 1734, 0, -11137.5, -1174.14, 43.9296, 2.47837, 0, 0, 0.945518, 0.325568, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+31, 1734, 0, -11044.9, -53.2847, 18.2922, 4.85202, 0, 0, -0.656058, 0.75471, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+32, 1734, 0, -11010, -989.044, 69.0113, 4.93928, 0, 0, -0.622514, 0.782609, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+33, 1734, 0, -10678.7, -908.818, 68.4815, 2.65289, 0, 0, 0.970295, 0.241925, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+34, 1734, 0, -10600.1, -1520.67, 92.0927, 5.96903, 0, 0, -0.156434, 0.987688, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+35, 1734, 0, -10563.4, -1486.63, 95.4168, 0.0349062, 0, 0, 0.0174522, 0.999848, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+36, 1734, 0, -10559.6, -724.451, 76.4627, 5.49779, 0, 0, -0.382683, 0.92388, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+37, 1734, 0, -10446.1, -1312.74, 63.4724, 5.86431, 0, 0, -0.207911, 0.978148, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+38, 1734, 0, -10415.6, -1253.79, 52.5802, 3.49067, 0, 0, -0.984807, 0.173652, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+39, 1734, 0, -10395.8, 113.076, 34.8874, 1.81514, 0, 0, 0.788011, 0.615662, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+40, 1734, 0, -10329.5, 134.72, 35.5812, 2.54818, 0, 0, 0.956305, 0.292372, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+41, 1734, 0, -10301.6, -1467.02, 90.2184, 5.91667, 0, 0, -0.182235, 0.983255, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+42, 1734, 0, -11212.6, -174.63, 4.63508, -0.366519, 0, 0, 0.182236, -0.983255, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+43, 1734, 0, -11210.8, -846.305, 78.2837, -0.575959, 0, 0, 0.284015, -0.95882, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+44, 1734, 0, -11183.7, -135.158, 8.11372, 2.09439, 0, 0, 0.866025, 0.500001, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+45, 1734, 0, -11116, -937.882, 66.9419, 1.6057, 0, 0, 0.719339, 0.694659, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+46, 1734, 0, -11099.1, -1155.73, 42.4535, 0.331611, 0, 0, 0.165047, 0.986286, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+47, 1734, 0, -10436.5, -780.711, 58.56, -0.244346, 0, 0, 0.121869, -0.992546, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+48, 1734, 0, -11152.4, -150.115, 10.1164, 2.70526, 0, 0, 0.976295, 0.216442, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+49, 1734, 0, -10283.3, -709.007, 55.0537, 4.15388, 0, 0, -0.874619, 0.48481, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+50, 1734, 0, -11160.1, -1168.44, 44.7962, 0.785397, 0, 0, 0.382683, 0.92388, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+51, 1734, 0, -11141.6, -866.69, 73.6912, 2.51327, 0, 0, 0.951056, 0.309017, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+52, 1734, 0, -11105.3, -138.255, 14.2671, 5.51524, 0, 0, -0.374606, 0.927184, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+53, 1734, 0, -10395.6, -748.918, 72.097, 5.18363, 0, 0, -0.522498, 0.85264, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+54, 1734, 0, -11080.6, -1109.6, 45.5113, -1.51844, 0, 0, 0.688354, -0.725374, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+55, 1734, 0, -10662.4, -894.27, 58.8167, 0.994837, 0, 0, 0.477159, 0.878817, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+56, 1734, 0, -10362.5, -1404.4, 81.8085, 1.22173, 0, 0, 0.573576, 0.819152, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+57, 1734, 0, -10237.8, -1291.58, 46.9721, 5.06146, 0, 0, -0.573576, 0.819152, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+58, 1734, 0, -10233.3, -1358.39, 83.4799, 2.30383, 0, 0, 0.913545, 0.406738, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+59, 1735, 0, -11137.5, -1174.14, 43.9296, 2.47837, 0, 0, 0.945518, 0.325568, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+60, 1735, 0, -11044.9, -53.2847, 18.2922, 4.85202, 0, 0, -0.656058, 0.75471, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+61, 1735, 0, -11010, -989.044, 69.0113, 4.93928, 0, 0, -0.622514, 0.782609, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+62, 1735, 0, -10678.7, -908.818, 68.4815, 2.65289, 0, 0, 0.970295, 0.241925, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+63, 1735, 0, -10600.1, -1520.67, 92.0927, 5.96903, 0, 0, -0.156434, 0.987688, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+64, 1735, 0, -10563.4, -1486.63, 95.4168, 0.0349062, 0, 0, 0.0174522, 0.999848, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+65, 1735, 0, -10559.6, -724.451, 76.4627, 5.49779, 0, 0, -0.382683, 0.92388, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+66, 1735, 0, -10446.1, -1312.74, 63.4724, 5.86431, 0, 0, -0.207911, 0.978148, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+67, 1735, 0, -10415.6, -1253.79, 52.5802, 3.49067, 0, 0, -0.984807, 0.173652, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+68, 1735, 0, -10395.8, 113.076, 34.8874, 1.81514, 0, 0, 0.788011, 0.615662, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+69, 1735, 0, -10329.5, 134.72, 35.5812, 2.54818, 0, 0, 0.956305, 0.292372, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+70, 1735, 0, -10301.6, -1467.02, 90.2184, 5.91667, 0, 0, -0.182235, 0.983255, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+71, 1735, 0, -11212.6, -174.63, 4.63508, -0.366519, 0, 0, 0.182236, -0.983255, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+72, 1735, 0, -11210.8, -846.305, 78.2837, -0.575959, 0, 0, 0.284015, -0.95882, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+73, 1735, 0, -11183.7, -135.158, 8.11372, 2.09439, 0, 0, 0.866025, 0.500001, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+74, 1735, 0, -11116, -937.882, 66.9419, 1.6057, 0, 0, 0.719339, 0.694659, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+75, 1735, 0, -11099.1, -1155.73, 42.4535, 0.331611, 0, 0, 0.165047, 0.986286, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+76, 1735, 0, -10436.5, -780.711, 58.56, -0.244346, 0, 0, 0.121869, -0.992546, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+77, 1735, 0, -11152.4, -150.115, 10.1164, 2.70526, 0, 0, 0.976295, 0.216442, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+78, 1735, 0, -10283.3, -709.007, 55.0537, 4.15388, 0, 0, -0.874619, 0.48481, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+79, 1735, 0, -11160.1, -1168.44, 44.7962, 0.785397, 0, 0, 0.382683, 0.92388, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+80, 1735, 0, -11141.6, -866.69, 73.6912, 2.51327, 0, 0, 0.951056, 0.309017, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+81, 1735, 0, -11105.3, -138.255, 14.2671, 5.51524, 0, 0, -0.374606, 0.927184, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+82, 1735, 0, -10395.6, -748.918, 72.097, 5.18363, 0, 0, -0.522498, 0.85264, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+83, 1735, 0, -11080.6, -1109.6, 45.5113, -1.51844, 0, 0, 0.688354, -0.725374, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+84, 1735, 0, -10662.4, -894.27, 58.8167, 0.994837, 0, 0, 0.477159, 0.878817, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+85, 1735, 0, -10362.5, -1404.4, 81.8085, 1.22173, 0, 0, 0.573576, 0.819152, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+86, 1735, 0, -10237.8, -1291.58, 46.9721, 5.06146, 0, 0, -0.573576, 0.819152, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+87, 1735, 0, -10233.3, -1358.39, 83.4799, 2.30383, 0, 0, 0.913545, 0.406738, 300, 300, 100, 1, 0, 0, 0, 10);
|
|
|
|
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_max`) VALUES
|
|
(@PTEMPLATE+1, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+2, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+3, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+4, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+5, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+6, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+7, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+8, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+9, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+10, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+11, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+12, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+13, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+14, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+15, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+16, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+17, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+18, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+19, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+20, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+21, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+22, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+23, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+24, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+25, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+26, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+27, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+28, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@PTEMPLATE+29, 1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10);
|
|
|
|
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_max`) VALUES
|
|
(@OGUID+1, @PTEMPLATE+1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+2, @PTEMPLATE+2, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+3, @PTEMPLATE+3, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+4, @PTEMPLATE+4, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+5, @PTEMPLATE+5, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+6, @PTEMPLATE+6, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+7, @PTEMPLATE+7, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+8, @PTEMPLATE+8, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+9, @PTEMPLATE+9, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+10, @PTEMPLATE+10, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+11, @PTEMPLATE+11, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+12, @PTEMPLATE+12, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+13, @PTEMPLATE+13, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+14, @PTEMPLATE+14, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+15, @PTEMPLATE+15, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+16, @PTEMPLATE+16, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+17, @PTEMPLATE+17, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+18, @PTEMPLATE+18, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+19, @PTEMPLATE+19, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+20, @PTEMPLATE+20, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+21, @PTEMPLATE+21, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+22, @PTEMPLATE+22, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+23, @PTEMPLATE+23, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+24, @PTEMPLATE+24, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+25, @PTEMPLATE+25, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+26, @PTEMPLATE+26, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+27, @PTEMPLATE+27, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+28, @PTEMPLATE+28, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+29, @PTEMPLATE+29, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+30, @PTEMPLATE+1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+31, @PTEMPLATE+2, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+32, @PTEMPLATE+3, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+33, @PTEMPLATE+4, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+34, @PTEMPLATE+5, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+35, @PTEMPLATE+6, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+36, @PTEMPLATE+7, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+37, @PTEMPLATE+8, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+38, @PTEMPLATE+9, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+39, @PTEMPLATE+10, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+40, @PTEMPLATE+11, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+41, @PTEMPLATE+12, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+42, @PTEMPLATE+13, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+43, @PTEMPLATE+14, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+44, @PTEMPLATE+15, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+45, @PTEMPLATE+16, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+46, @PTEMPLATE+17, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+47, @PTEMPLATE+18, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+48, @PTEMPLATE+19, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+49, @PTEMPLATE+20, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+50, @PTEMPLATE+21, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+51, @PTEMPLATE+22, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+52, @PTEMPLATE+23, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+53, @PTEMPLATE+24, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+54, @PTEMPLATE+25, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+55, @PTEMPLATE+26, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+56, @PTEMPLATE+27, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+57, @PTEMPLATE+28, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+58, @PTEMPLATE+29, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+59, @PTEMPLATE+1, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+60, @PTEMPLATE+2, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+61, @PTEMPLATE+3, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+62, @PTEMPLATE+4, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+63, @PTEMPLATE+5, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+64, @PTEMPLATE+6, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+65, @PTEMPLATE+7, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+66, @PTEMPLATE+8, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+67, @PTEMPLATE+9, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+68, @PTEMPLATE+10, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+69, @PTEMPLATE+11, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+70, @PTEMPLATE+12, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+71, @PTEMPLATE+13, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+72, @PTEMPLATE+14, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+73, @PTEMPLATE+15, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+74, @PTEMPLATE+16, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+75, @PTEMPLATE+17, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+76, @PTEMPLATE+18, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+77, @PTEMPLATE+19, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+78, @PTEMPLATE+20, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+79, @PTEMPLATE+21, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+80, @PTEMPLATE+22, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+81, @PTEMPLATE+23, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+82, @PTEMPLATE+24, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+83, @PTEMPLATE+25, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+84, @PTEMPLATE+26, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+85, @PTEMPLATE+27, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+86, @PTEMPLATE+28, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10),
|
|
(@OGUID+87, @PTEMPLATE+29, 'Silver Vein / Gold Vein / Iron Deposit - Duskwood', 10);
|
|
|
|
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
|
|
(1120, 6, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit (Master Pool)', 0, 0, 0, 10);
|
|
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
|
|
(@PTEMPLATE+1, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+2, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+3, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+4, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+5, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+6, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+7, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+8, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+9, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+10, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+11, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+12, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+13, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+14, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+15, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+16, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+17, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+18, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+19, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+20, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+21, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+22, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+23, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+24, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+25, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+26, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+27, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+28, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+29, 1120, 0, 'Duskwood - Silver Vein / Gold Vein / Iron Deposit', 0);
|
|
|
|
-- Add Chance
|
|
UPDATE `pool_gameobject` SET `chance` = 5 WHERE `description` = "Silver Vein / Gold Vein / Iron Deposit - Duskwood" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 1733);
|
|
UPDATE `pool_gameobject` SET `chance` = 5 WHERE `description` = "Silver Vein / Gold Vein / Iron Deposit - Duskwood" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 1734);
|
|
UPDATE `pool_gameobject` SET `chance` = 90 WHERE `description` = "Silver Vein / Gold Vein / Iron Deposit - Duskwood" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 1735);
|
|
UPDATE `pool_gameobject` SET `chance` = 95 WHERE `description` = "Tin Vein / Silver Vein - Duskwood" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 1732);
|
|
UPDATE `pool_gameobject` SET `chance` = 5 WHERE `description` = "Tin Vein / Silver Vein - Duskwood" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 1733);
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
DELIMITER ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|