Files
moonwell-core-vanilla/sql/migrations/20250205172611_world.sql
2025-02-08 16:45:06 +00:00

334 lines
33 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`='20250205172611');
IF v = 0 THEN
INSERT INTO `migrations` VALUES ('20250205172611');
-- Add your query below.
-- Feralas
-- Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit
SET @OGUID = 94595;
SET @PTEMPLATE = 6358;
DELETE FROM `gameobject` WHERE `guid` IN (21280, 21281, 21282, 21283, 21329, 21330, 21331, 21332, 21333, 21334, 21335, 21336, 21337, 21338, 21339, 21340, 21341, 21342, 21343, 21344, 21345, 21346, 21347, 21348, 21349, 21350, 21351, 21352, 21353, 21354, 21355, 21356, 21357, 21358, 21359, 21360, 21361, 21362, 21363, 21364, 21365, 21366, 21367, 21368, 21369, 21370, 21371, 21372, 21373, 21374, 21375, 21376, 21377, 21378, 21379, 21380, 21381, 21382, 21383, 21384, 21385, 85027, 85046, 85047, 85048, 85049, 427536, 427537, 427538, 427539);
DELETE FROM `pool_gameobject` WHERE `guid` IN (21280, 21281, 21282, 21283, 21329, 21330, 21331, 21332, 21333, 21334, 21335, 21336, 21337, 21338, 21339, 21340, 21341, 21342, 21343, 21344, 21345, 21346, 21347, 21348, 21349, 21350, 21351, 21352, 21353, 21354, 21355, 21356, 21357, 21358, 21359, 21360, 21361, 21362, 21363, 21364, 21365, 21366, 21367, 21368, 21369, 21370, 21371, 21372, 21373, 21374, 21375, 21376, 21377, 21378, 21379, 21380, 21381, 21382, 21383, 21384, 21385, 85027, 85046, 85047, 85048, 85049, 427536, 427537, 427538, 427539);
DELETE FROM `pool_template` WHERE `entry` IN (1197, 1357, 16964, 16965, 17188, 17189, 23029, 23038, 23039, 23040, 23041, 42941, 42942, 42943, 42944, 42945, 42946, 42947, 42948, 42949, 42950, 42951, 42952, 42953, 42954, 42955, 42956, 42957, 42958, 42959, 42960, 42961, 42962, 42963, 42964, 42965, 42966);
DELETE FROM `pool_pool` WHERE `mother_pool` IN (1197, 1357);
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, 1734, 1, -3949.93, 1661.53, 134.607, 1.78024, 0, 0, 0.777146, 0.62932, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+2, 1734, 1, -3847.84, 1737.33, 143.018, 3.07177, 0, 0, 0.999391, 0.0349061, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+3, 1734, 1, -5801.94, 1311.5, 66.8884, 2.23402, 0, 0, 0.898793, 0.438373, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+4, 1734, 1, -5411.21, 1230.15, 38.2596, 2.54818, 0, 0, 0.956305, 0.292372, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+5, 1734, 1, -5218.19, 1814.82, 117.495, 5.07891, 0, 0, -0.566406, 0.824126, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+6, 1734, 1, -5071.27, 1955.98, 89.1049, 0.139624, 0, 0, 0.0697556, 0.997564, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+7, 1734, 1, -4982.98, 373.328, 21.9584, 6.02139, 0, 0, -0.130526, 0.991445, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+8, 1734, 1, -4780.32, 931.156, 148.734, 4.04917, 0, 0, -0.898793, 0.438373, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+9, 1734, 1, -4014.75, 1942.18, 104.728, 1.3439, 0, 0, 0.622514, 0.782609, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+10, 1734, 1, -3552.21, 2369.68, 79.8318, 2.23402, 0, 0, 0.898793, 0.438373, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+11, 1734, 1, -5749.9, 1684.3, 97.6473, 3.194, 0, 0, -0.999657, 0.0262016, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+12, 1734, 1, -5558.7, 3636.47, -14.6601, -1.6057, 0, 0, 0.71934, -0.694658, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+13, 1734, 1, -5534.18, 3500.93, 11.677, 0.122173, 0, 0, 0.061049, 0.998135, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+14, 1734, 1, -5512.19, 3464.31, -5.26021, -1.51844, 0, 0, 0.688354, -0.725374, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+15, 1734, 1, -5247.45, 635.118, 66.4176, 5.75959, 0, 0, -0.258819, 0.965926, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+16, 1734, 1, -5166.29, 1864.39, 107.349, 0.139626, 0, 0, 0.069756, 0.997564, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+17, 1734, 1, -5137.66, 1802.66, 94.1964, 1.48353, 0, 0, 0.67559, 0.737277, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+18, 1734, 1, -5095.32, 1861.92, 84.5127, 3.73501, 0, 0, -0.956305, 0.292372, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+19, 1734, 1, -4963.03, 619.299, 39.5716, 4.60767, 0, 0, -0.743144, 0.669131, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+20, 1734, 1, -4821.13, 446.714, 5.45126, 0.157079, 0, 0, 0.0784588, 0.996917, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+21, 1734, 1, -4542.68, 1448.89, 109.07, 2.23402, 0, 0, 0.898794, 0.438371, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+22, 1734, 1, -3924.87, 1589.83, 126.549, 2.28638, 0, 0, 0.909961, 0.414693, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+23, 1734, 1, -3891.48, 1624.96, 118.84, 0.802851, 0, 0, 0.390731, 0.920505, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+24, 1734, 1, -3888.16, 1568.54, 121.972, 3.78737, 0, 0, -0.948323, 0.317306, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+25, 1734, 1, -3782.9, 1914.12, 81.3752, 0.191985, 0, 0, 0.0958452, 0.995396, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+26, 1734, 1, -3517.99, 1857.62, 74.4841, 4.60767, 0, 0, -0.743144, 0.669131, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+27, 1734, 1, -3315.73, 2819.71, 81.5505, 0.418879, 0, 0, 0.207912, 0.978148, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+28, 1734, 1, -3127.18, 1822.67, 46.9297, 4.55531, 0, 0, -0.760406, 0.649449, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+29, 1734, 1, -5531.73, 3587.94, -12.624, 0.802851, 0, 0, 0.390731, 0.920505, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+30, 1734, 1, -5752.27, 3677.47, -8.37481, -0.750491, 0, 0, 0.366501, -0.930418, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+31, 1734, 1, -5585.74, 3546.6, -2.5983, -2.56563, 0, 0, 0.95882, -0.284015, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+32, 1734, 1, -5581.2, 3514.24, 19.1351, -2.49582, 0, 0, 0.948324, -0.317305, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+33, 1734, 1, -3119.27, 2513.86, 72.785, 3.05433, 0, 0, 0.999048, 0.0436195, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+34, 1734, 1, -3868.76, 1682.71, 141.231, 2.74016, 0, 0, 0.979924, 0.19937, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+35, 1734, 1, -3518.93, 2750.2, 97.9244, 3.17653, 0, 0, -0.999847, 0.0174693, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+36, 2040, 1, -3949.93, 1661.53, 134.607, 1.78024, 0, 0, 0.777146, 0.62932, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+37, 2040, 1, -3847.84, 1737.33, 143.018, 3.07177, 0, 0, 0.999391, 0.0349061, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+38, 2040, 1, -5801.94, 1311.5, 66.8884, 2.23402, 0, 0, 0.898793, 0.438373, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+39, 2040, 1, -5411.21, 1230.15, 38.2596, 2.54818, 0, 0, 0.956305, 0.292372, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+40, 2040, 1, -5218.19, 1814.82, 117.495, 5.07891, 0, 0, -0.566406, 0.824126, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+41, 2040, 1, -5071.27, 1955.98, 89.1049, 0.139624, 0, 0, 0.0697556, 0.997564, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+42, 2040, 1, -4982.98, 373.328, 21.9584, 6.02139, 0, 0, -0.130526, 0.991445, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+43, 2040, 1, -4780.32, 931.156, 148.734, 4.04917, 0, 0, -0.898793, 0.438373, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+44, 2040, 1, -4014.75, 1942.18, 104.728, 1.3439, 0, 0, 0.622514, 0.782609, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+45, 2040, 1, -3552.21, 2369.68, 79.8318, 2.23402, 0, 0, 0.898793, 0.438373, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+46, 2040, 1, -5749.9, 1684.3, 97.6473, 3.194, 0, 0, -0.999657, 0.0262016, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+47, 2040, 1, -5558.7, 3636.47, -14.6601, -1.6057, 0, 0, 0.71934, -0.694658, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+48, 2040, 1, -5534.18, 3500.93, 11.677, 0.122173, 0, 0, 0.061049, 0.998135, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+49, 2040, 1, -5512.19, 3464.31, -5.26021, -1.51844, 0, 0, 0.688354, -0.725374, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+50, 2040, 1, -5247.45, 635.118, 66.4176, 5.75959, 0, 0, -0.258819, 0.965926, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+51, 2040, 1, -5166.29, 1864.39, 107.349, 0.139626, 0, 0, 0.069756, 0.997564, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+52, 2040, 1, -5137.66, 1802.66, 94.1964, 1.48353, 0, 0, 0.67559, 0.737277, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+53, 2040, 1, -5095.32, 1861.92, 84.5127, 3.73501, 0, 0, -0.956305, 0.292372, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+54, 2040, 1, -4963.03, 619.299, 39.5716, 4.60767, 0, 0, -0.743144, 0.669131, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+55, 2040, 1, -4821.13, 446.714, 5.45126, 0.157079, 0, 0, 0.0784588, 0.996917, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+56, 2040, 1, -4542.68, 1448.89, 109.07, 2.23402, 0, 0, 0.898794, 0.438371, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+57, 2040, 1, -3924.87, 1589.83, 126.549, 2.28638, 0, 0, 0.909961, 0.414693, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+58, 2040, 1, -3891.48, 1624.96, 118.84, 0.802851, 0, 0, 0.390731, 0.920505, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+59, 2040, 1, -3888.16, 1568.54, 121.972, 3.78737, 0, 0, -0.948323, 0.317306, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+60, 2040, 1, -3782.9, 1914.12, 81.3752, 0.191985, 0, 0, 0.0958452, 0.995396, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+61, 2040, 1, -3517.99, 1857.62, 74.4841, 4.60767, 0, 0, -0.743144, 0.669131, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+62, 2040, 1, -3315.73, 2819.71, 81.5505, 0.418879, 0, 0, 0.207912, 0.978148, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+63, 2040, 1, -3127.18, 1822.67, 46.9297, 4.55531, 0, 0, -0.760406, 0.649449, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+64, 2040, 1, -5531.73, 3587.94, -12.624, 0.802851, 0, 0, 0.390731, 0.920505, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+65, 2040, 1, -5752.27, 3677.47, -8.37481, -0.750491, 0, 0, 0.366501, -0.930418, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+66, 2040, 1, -5585.74, 3546.6, -2.5983, -2.56563, 0, 0, 0.95882, -0.284015, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+67, 2040, 1, -5581.2, 3514.24, 19.1351, -2.49582, 0, 0, 0.948324, -0.317305, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+68, 2040, 1, -3119.27, 2513.86, 72.785, 3.05433, 0, 0, 0.999048, 0.0436195, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+69, 2040, 1, -3868.76, 1682.71, 141.231, 2.74016, 0, 0, 0.979924, 0.19937, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+70, 2040, 1, -3518.93, 2750.2, 97.9244, 3.17653, 0, 0, -0.999847, 0.0174693, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+71, 2047, 1, -3949.93, 1661.53, 134.607, 1.78024, 0, 0, 0.777146, 0.62932, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+72, 2047, 1, -3847.84, 1737.33, 143.018, 3.07177, 0, 0, 0.999391, 0.0349061, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+73, 2047, 1, -5801.94, 1311.5, 66.8884, 2.23402, 0, 0, 0.898793, 0.438373, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+74, 2047, 1, -5411.21, 1230.15, 38.2596, 2.54818, 0, 0, 0.956305, 0.292372, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+75, 2047, 1, -5218.19, 1814.82, 117.495, 5.07891, 0, 0, -0.566406, 0.824126, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+76, 2047, 1, -5071.27, 1955.98, 89.1049, 0.139624, 0, 0, 0.0697556, 0.997564, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+77, 2047, 1, -4982.98, 373.328, 21.9584, 6.02139, 0, 0, -0.130526, 0.991445, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+78, 2047, 1, -4780.32, 931.156, 148.734, 4.04917, 0, 0, -0.898793, 0.438373, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+79, 2047, 1, -4014.75, 1942.18, 104.728, 1.3439, 0, 0, 0.622514, 0.782609, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+80, 2047, 1, -3552.21, 2369.68, 79.8318, 2.23402, 0, 0, 0.898793, 0.438373, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+81, 2047, 1, -5749.9, 1684.3, 97.6473, 3.194, 0, 0, -0.999657, 0.0262016, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+82, 2047, 1, -5558.7, 3636.47, -14.6601, -1.6057, 0, 0, 0.71934, -0.694658, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+83, 2047, 1, -5534.18, 3500.93, 11.677, 0.122173, 0, 0, 0.061049, 0.998135, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+84, 2047, 1, -5512.19, 3464.31, -5.26021, -1.51844, 0, 0, 0.688354, -0.725374, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+85, 2047, 1, -5247.45, 635.118, 66.4176, 5.75959, 0, 0, -0.258819, 0.965926, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+86, 2047, 1, -5166.29, 1864.39, 107.349, 0.139626, 0, 0, 0.069756, 0.997564, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+87, 2047, 1, -5137.66, 1802.66, 94.1964, 1.48353, 0, 0, 0.67559, 0.737277, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+88, 2047, 1, -5095.32, 1861.92, 84.5127, 3.73501, 0, 0, -0.956305, 0.292372, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+89, 2047, 1, -4963.03, 619.299, 39.5716, 4.60767, 0, 0, -0.743144, 0.669131, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+90, 2047, 1, -4821.13, 446.714, 5.45126, 0.157079, 0, 0, 0.0784588, 0.996917, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+91, 2047, 1, -4542.68, 1448.89, 109.07, 2.23402, 0, 0, 0.898794, 0.438371, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+92, 2047, 1, -3924.87, 1589.83, 126.549, 2.28638, 0, 0, 0.909961, 0.414693, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+93, 2047, 1, -3891.48, 1624.96, 118.84, 0.802851, 0, 0, 0.390731, 0.920505, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+94, 2047, 1, -3888.16, 1568.54, 121.972, 3.78737, 0, 0, -0.948323, 0.317306, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+95, 2047, 1, -3782.9, 1914.12, 81.3752, 0.191985, 0, 0, 0.0958452, 0.995396, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+96, 2047, 1, -3517.99, 1857.62, 74.4841, 4.60767, 0, 0, -0.743144, 0.669131, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+97, 2047, 1, -3315.73, 2819.71, 81.5505, 0.418879, 0, 0, 0.207912, 0.978148, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+98, 2047, 1, -3127.18, 1822.67, 46.9297, 4.55531, 0, 0, -0.760406, 0.649449, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+99, 2047, 1, -5531.73, 3587.94, -12.624, 0.802851, 0, 0, 0.390731, 0.920505, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+100, 2047, 1, -5752.27, 3677.47, -8.37481, -0.750491, 0, 0, 0.366501, -0.930418, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+101, 2047, 1, -5585.74, 3546.6, -2.5983, -2.56563, 0, 0, 0.95882, -0.284015, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+102, 2047, 1, -5581.2, 3514.24, 19.1351, -2.49582, 0, 0, 0.948324, -0.317305, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+103, 2047, 1, -3119.27, 2513.86, 72.785, 3.05433, 0, 0, 0.999048, 0.0436195, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+104, 2047, 1, -3868.76, 1682.71, 141.231, 2.74016, 0, 0, 0.979924, 0.19937, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+105, 2047, 1, -3518.93, 2750.2, 97.9244, 3.17653, 0, 0, -0.999847, 0.0174693, 300, 300, 100, 1, 0, 0, 0, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_max`) VALUES
(@PTEMPLATE+1, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+2, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+3, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+4, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+5, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+6, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+7, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+8, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+9, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+10, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+11, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+12, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+13, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+14, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+15, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+16, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+17, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+18, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+19, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+20, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+21, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+22, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+23, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+24, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+25, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+26, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+27, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+28, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+29, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+30, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+31, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+32, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+33, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+34, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@PTEMPLATE+35, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10);
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_max`) VALUES
(@OGUID+1, @PTEMPLATE+1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+2, @PTEMPLATE+2, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+3, @PTEMPLATE+3, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+4, @PTEMPLATE+4, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+5, @PTEMPLATE+5, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+6, @PTEMPLATE+6, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+7, @PTEMPLATE+7, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+8, @PTEMPLATE+8, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+9, @PTEMPLATE+9, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+10, @PTEMPLATE+10, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+11, @PTEMPLATE+11, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+12, @PTEMPLATE+12, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+13, @PTEMPLATE+13, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+14, @PTEMPLATE+14, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+15, @PTEMPLATE+15, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+16, @PTEMPLATE+16, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+17, @PTEMPLATE+17, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+18, @PTEMPLATE+18, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+19, @PTEMPLATE+19, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+20, @PTEMPLATE+20, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+21, @PTEMPLATE+21, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+22, @PTEMPLATE+22, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+23, @PTEMPLATE+23, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+24, @PTEMPLATE+24, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+25, @PTEMPLATE+25, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+26, @PTEMPLATE+26, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+27, @PTEMPLATE+27, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+28, @PTEMPLATE+28, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+29, @PTEMPLATE+29, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+30, @PTEMPLATE+30, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+31, @PTEMPLATE+31, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+32, @PTEMPLATE+32, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+33, @PTEMPLATE+33, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+34, @PTEMPLATE+34, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+35, @PTEMPLATE+35, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+36, @PTEMPLATE+1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+37, @PTEMPLATE+2, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+38, @PTEMPLATE+3, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+39, @PTEMPLATE+4, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+40, @PTEMPLATE+5, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+41, @PTEMPLATE+6, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+42, @PTEMPLATE+7, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+43, @PTEMPLATE+8, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+44, @PTEMPLATE+9, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+45, @PTEMPLATE+10, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+46, @PTEMPLATE+11, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+47, @PTEMPLATE+12, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+48, @PTEMPLATE+13, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+49, @PTEMPLATE+14, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+50, @PTEMPLATE+15, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+51, @PTEMPLATE+16, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+52, @PTEMPLATE+17, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+53, @PTEMPLATE+18, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+54, @PTEMPLATE+19, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+55, @PTEMPLATE+20, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+56, @PTEMPLATE+21, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+57, @PTEMPLATE+22, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+58, @PTEMPLATE+23, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+59, @PTEMPLATE+24, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+60, @PTEMPLATE+25, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+61, @PTEMPLATE+26, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+62, @PTEMPLATE+27, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+63, @PTEMPLATE+28, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+64, @PTEMPLATE+29, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+65, @PTEMPLATE+30, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+66, @PTEMPLATE+31, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+67, @PTEMPLATE+32, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+68, @PTEMPLATE+33, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+69, @PTEMPLATE+34, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+70, @PTEMPLATE+35, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+71, @PTEMPLATE+1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+72, @PTEMPLATE+2, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+73, @PTEMPLATE+3, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+74, @PTEMPLATE+4, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+75, @PTEMPLATE+5, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+76, @PTEMPLATE+6, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+77, @PTEMPLATE+7, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+78, @PTEMPLATE+8, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+79, @PTEMPLATE+9, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+80, @PTEMPLATE+10, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+81, @PTEMPLATE+11, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+82, @PTEMPLATE+12, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+83, @PTEMPLATE+13, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+84, @PTEMPLATE+14, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+85, @PTEMPLATE+15, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+86, @PTEMPLATE+16, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+87, @PTEMPLATE+17, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+88, @PTEMPLATE+18, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+89, @PTEMPLATE+19, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+90, @PTEMPLATE+20, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+91, @PTEMPLATE+21, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+92, @PTEMPLATE+22, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+93, @PTEMPLATE+23, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+94, @PTEMPLATE+24, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+95, @PTEMPLATE+25, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+96, @PTEMPLATE+26, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+97, @PTEMPLATE+27, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+98, @PTEMPLATE+28, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+99, @PTEMPLATE+29, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+100, @PTEMPLATE+30, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+101, @PTEMPLATE+31, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+102, @PTEMPLATE+32, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+103, @PTEMPLATE+33, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+104, @PTEMPLATE+34, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10),
(@OGUID+105, @PTEMPLATE+35, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas', 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
(1197, 9, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit (Master Pool)', 0, 0, 0, 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(@PTEMPLATE+1, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+2, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+3, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+4, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+5, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+6, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+7, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+8, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+9, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+10, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+11, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+12, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+13, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+14, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+15, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+16, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+17, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+18, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+19, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+20, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+21, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+22, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+23, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+24, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+25, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+26, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+27, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+28, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+29, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+30, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+31, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+32, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+33, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+34, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
(@PTEMPLATE+35, 1197, 0, 'Feralas - Gold Vein / Mithril Deposit / Truesilver Deposit', 0);
-- Add Chance
UPDATE `pool_gameobject` SET `chance` = 5 WHERE `description` = "Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 1734);
UPDATE `pool_gameobject` SET `chance` = 90 WHERE `description` = "Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 2040);
UPDATE `pool_gameobject` SET `chance` = 5 WHERE `description` = "Gold Vein / Mithril Deposit / Truesilver Deposit - Feralas" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 2047);
UPDATE `pool_gameobject` SET `chance` = 5 WHERE `description` = "Silver Vein / Gold Vein / Iron Deposit - Feralas" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 1733);
UPDATE `pool_gameobject` SET `chance` = 5 WHERE `description` = "Silver Vein / Gold Vein / Iron Deposit - Feralas" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 1734);
UPDATE `pool_gameobject` SET `chance` = 90 WHERE `description` = "Silver Vein / Gold Vein / Iron Deposit - Feralas" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 1735);
UPDATE `pool_gameobject` SET `chance` = 95 WHERE `description` = "Truesilver Deposit / Small Thorium Vein - Feralas" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 324);
UPDATE `pool_gameobject` SET `chance` = 5 WHERE `description` = "Truesilver Deposit / Small Thorium Vein - Feralas" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 2047);
UPDATE `pool_gameobject` SET `chance` = 5 WHERE `description` = "Ooze Covered Gold Vein / Ooze Covered Mithril Deposit / Ooze Covered Truesilver Deposit - Feralas" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 73941);
UPDATE `pool_gameobject` SET `chance` = 90 WHERE `description` = "Ooze Covered Gold Vein / Ooze Covered Mithril Deposit / Ooze Covered Truesilver Deposit - Feralas" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 123310);
UPDATE `pool_gameobject` SET `chance` = 5 WHERE `description` = "Ooze Covered Gold Vein / Ooze Covered Mithril Deposit / Ooze Covered Truesilver Deposit - Feralas" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 123309);
UPDATE `pool_gameobject` SET `chance` = 95 WHERE `description` = "Ooze Covered Truesilver Deposit / Ooze Covered Thorium Vein - Feralas" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 123848);
UPDATE `pool_gameobject` SET `chance` = 5 WHERE `description` = "Ooze Covered Truesilver Deposit / Ooze Covered Thorium Vein - Feralas" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 123309);
-- End of migration.
END IF;
END??
DELIMITER ;
CALL add_migration();
DROP PROCEDURE IF EXISTS add_migration;