sindoring/moonwell-core-vanilla
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Files
development
moonwell-core-vanilla/sql/migrations/20250123162441_world.sql
T
NickTyrer 2958b5fbdc Create 20250123162441_world.sql (#2876)
2025-01-27 17:39:39 +00:00

299 lines
25 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`='20250123162441');
IF v = 0 THEN
INSERT INTO `migrations` VALUES ('20250123162441');
-- Add your query below.
SET @OGUID = 325600;
SET @PTEMPLATE = 9700;
DELETE FROM `pool_gameobject` WHERE `guid` IN (5505, 5584, 5625, 6892, 9697, 16839, 16840, 16909, 35442, 35450, 35454, 35463, 35478, 35486, 35491, 35492, 35502, 35550, 35553, 35570, 35589, 35593, 35594, 35598, 35600, 35606, 35612, 42066, 42074, 42098, 251519, 251520, 251521, 251522, 251523, 251524, 251525, 251526, 251527, 251528, 251529, 251531, 251532);
DELETE FROM `gameobject` WHERE `guid` IN (5505, 5584, 5625, 6892, 9697, 16839, 16840, 16909, 35442, 35450, 35454, 35463, 35478, 35486, 35491, 35492, 35502, 35550, 35553, 35570, 35589, 35593, 35594, 35598, 35600, 35606, 35612, 42066, 42074, 42098, 251519, 251520, 251521, 251522, 251523, 251524, 251525, 251526, 251527, 251528, 251529, 251531, 251532);
DELETE FROM `pool_template` WHERE `entry` = 1045;
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, 1732, 0, 77.5, 1519.55, 126.13, -2.82743, 0, 0, 0.987688, -0.156434, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+2, 1732, 0, -42, 931.599, 71.19, 2.967, 0, 0, 0.996195, 0.087156, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+3, 1732, 0, -49, 683.216, 78.239, 1.361, 0, 0, 0.62932, 0.777146, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+4, 1732, 0, 15.2126, 803.973, 77.9227, 3.75246, 0, 0, -0.953716, 0.300708, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+5, 1732, 0, 215.092, 1457.74, 121.133, 4.03171, 0, 0, -0.902585, 0.430512, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+6, 1732, 0, 106.171, 753.906, 70.6382, 2.21657, 0, 0, 0.894934, 0.446199, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+7, 1732, 0, 5.39084, 1143.41, 69.7921, 4.92183, 0, 0, -0.62932, 0.777146, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+8 , 1732, 0, -354.726, 908.392, 133.978, -2.82743, 0, 0, 0.987688, -0.156434, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+9, 1732, 0, -270.097, 1766.84, -4.27097, -0.2618, 0, 0, 0.130526, -0.991445, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+10, 1732, 0, 458.781, 996.065, 131.991, -3.03687, 0, 0, 0.99863, -0.052336, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+11, 1732, 0, 1216.14, 718.324, 19.585, 1.72788, 0, 0, 0.760406, 0.649448, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+12, 1732, 0, 209.418, 1682.83, 164.493, 0.20944, 0, 0, 0.104528, 0.994522, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+13, 1732, 0, -320.98, 1055.17, 118.64, 1.69297, 0, 0, 0.748956, 0.66262, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+14, 1732, 0, 486.859, 773.352, 47.7917, 1.53589, 0, 0, 0.694658, 0.71934, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+15, 1732, 0, -282.336, 1030.5, 115.62, 3.54302, 0, 0, -0.979924, 0.19937, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+16, 1732, 0, 1458.34, 845.418, 70.6578, -2.87979, 0, 0, 0.991445, -0.130526, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+17, 1732, 0, 727.299, 1432.06, 70.8502, -2.04204, 0, 0, 0.85264, -0.522498, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+18, 1732, 0, -548.759, 1018.47, 105.532, 5.79449, 0, 0, -0.241921, 0.970296, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+19, 1732, 0, -329.648, 1024.6, 118.751, 4.31097, 0, 0, -0.833885, 0.551938, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+20, 1732, 0, -330.949, 975.041, 131.206, 5.21854, 0, 0, -0.507538, 0.861629, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+21, 1732, 0, -298.773, 958.085, 132.695, 5.28835, 0, 0, -0.477159, 0.878817, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+22, 1732, 0, 1020.51, 1438.16, 46.4768, 2.87979, 0, 0, 0.991445, 0.130528, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+23, 1732, 0, 392.47, 707.618, 45.5647, 3.24635, 0, 0, -0.998629, 0.0523532, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+24, 1732, 0, -353.392, 992.701, 128.054, 4.53786, 0, 0, -0.766044, 0.642789, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+25, 1732, 0, 625.231, 874.41, 37.9086, 1.48353, 0, 0, 0.67559, 0.737278, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+26, 1732, 0, 1221.43, 1728.9, 34.2743, 1.79769, 0, 0, 0.782608, 0.622515, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+27, 1732, 0, -312.241, 1036.87, 115.711, 1.41372, 0, 0, 0.649447, 0.760406, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+28, 1732, 0, 1003.41, 96.0792, 18.3702, 1.309, 0, 0, 0.608761, 0.793353, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+29, 1732, 0, 415.897, 996.533, 109.065, 5.00909, 0, 0, -0.594823, 0.803857, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+30, 1732, 0, 642.53, 266.969, 22.9494, 3.89209, 0, 0, -0.930417, 0.366502, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+31, 1732, 0, -378.764, 769.298, 95.0073, 3.56047, 0, 0, -0.978148, 0.207912, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+32, 1732, 0, -350.898, 954.154, 129.027, 4.53786, 0, 0, -0.766044, 0.642789, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+33, 1732, 0, -345.379, 1029.21, 120.191, 5.95157, 0, 0, -0.165047, 0.986286, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+34, 1732, 0, -334.676, 770.501, 107.438, 3.97935, 0, 0, -0.913545, 0.406738, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+35, 1732, 0, -324.499, 927.473, 131.106, 6.21337, 0, 0, -0.0348988, 0.999391, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+36, 1732, 0, -317.895, 855.736, 90.625, 2.23402, 0, 0, 0.898793, 0.438373, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+37, 1732, 0, -309.482, 971.346, 133.761, 3.927, 0, 0, -0.923879, 0.382686, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+38, 1732, 0, -305.998, 1099.13, 75.9756, 1.51844, 0, 0, 0.688354, 0.725374, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+39, 1732, 0, -293.892, 1008, 113.602, 5.95157, 0, 0, -0.165047, 0.986286, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+40, 1732, 0, -30.8879, 1023, 74.69, 6.24828, 0, 0, -0.0174522, 0.999848, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+41, 1732, 0, 380.065, 1130.56, 108.131, 5.98648, 0, 0, -0.147809, 0.989016, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+42, 1732, 0, 756.192, 1784.68, 30.1367, 0.122173, 0, 0, 0.0610485, 0.998135, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+43, 1732, 0, 1075.68, 860.883, 18.6506, 1.11701, 0, 0, 0.529919, 0.848048, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+44, 1733, 0, 77.5, 1519.55, 126.13, -2.82743, 0, 0, 0.987688, -0.156434, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+45, 1733, 0, -42, 931.599, 71.19, 2.967, 0, 0, 0.996195, 0.087156, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+46, 1733, 0, -49, 683.216, 78.239, 1.361, 0, 0, 0.62932, 0.777146, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+47, 1733, 0, 15.2126, 803.973, 77.9227, 3.75246, 0, 0, -0.953716, 0.300708, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+48, 1733, 0, 215.092, 1457.74, 121.133, 4.03171, 0, 0, -0.902585, 0.430512, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+49, 1733, 0, 106.171, 753.906, 70.6382, 2.21657, 0, 0, 0.894934, 0.446199, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+50, 1733, 0, 5.39084, 1143.41, 69.7921, 4.92183, 0, 0, -0.62932, 0.777146, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+51, 1733, 0, -354.726, 908.392, 133.978, -2.82743, 0, 0, 0.987688, -0.156434, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+52, 1733, 0, -270.097, 1766.84, -4.27097, -0.2618, 0, 0, 0.130526, -0.991445, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+53, 1733, 0, 458.781, 996.065, 131.991, -3.03687, 0, 0, 0.99863, -0.052336, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+54, 1733, 0, 1216.14, 718.324, 19.585, 1.72788, 0, 0, 0.760406, 0.649448, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+55, 1733, 0, 209.418, 1682.83, 164.493, 0.20944, 0, 0, 0.104528, 0.994522, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+56, 1733, 0, -320.98, 1055.17, 118.64, 1.69297, 0, 0, 0.748956, 0.66262, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+57, 1733, 0, 486.859, 773.352, 47.7917, 1.53589, 0, 0, 0.694658, 0.71934, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+58, 1733, 0, -282.336, 1030.5, 115.62, 3.54302, 0, 0, -0.979924, 0.19937, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+59, 1733, 0, 1458.34, 845.418, 70.6578, -2.87979, 0, 0, 0.991445, -0.130526, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+60, 1733, 0, 727.299, 1432.06, 70.8502, -2.04204, 0, 0, 0.85264, -0.522498, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+61, 1733, 0, -548.759, 1018.47, 105.532, 5.79449, 0, 0, -0.241921, 0.970296, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+62, 1733, 0, -329.648, 1024.6, 118.751, 4.31097, 0, 0, -0.833885, 0.551938, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+63, 1733, 0, -330.949, 975.041, 131.206, 5.21854, 0, 0, -0.507538, 0.861629, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+64, 1733, 0, -298.773, 958.085, 132.695, 5.28835, 0, 0, -0.477159, 0.878817, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+65, 1733, 0, 1020.51, 1438.16, 46.4768, 2.87979, 0, 0, 0.991445, 0.130528, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+66, 1733, 0, 392.47, 707.618, 45.5647, 3.24635, 0, 0, -0.998629, 0.0523532, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+67, 1733, 0, -353.392, 992.701, 128.054, 4.53786, 0, 0, -0.766044, 0.642789, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+68, 1733, 0, 625.231, 874.41, 37.9086, 1.48353, 0, 0, 0.67559, 0.737278, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+69, 1733, 0, 1221.43, 1728.9, 34.2743, 1.79769, 0, 0, 0.782608, 0.622515, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+70, 1733, 0, -312.241, 1036.87, 115.711, 1.41372, 0, 0, 0.649447, 0.760406, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+71, 1733, 0, 1003.41, 96.0792, 18.3702, 1.309, 0, 0, 0.608761, 0.793353, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+72, 1733, 0, 415.897, 996.533, 109.065, 5.00909, 0, 0, -0.594823, 0.803857, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+73, 1733, 0, 642.53, 266.969, 22.9494, 3.89209, 0, 0, -0.930417, 0.366502, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+74, 1733, 0, -378.764, 769.298, 95.0073, 3.56047, 0, 0, -0.978148, 0.207912, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+75, 1733, 0, -350.898, 954.154, 129.027, 4.53786, 0, 0, -0.766044, 0.642789, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+76, 1733, 0, -345.379, 1029.21, 120.191, 5.95157, 0, 0, -0.165047, 0.986286, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+77, 1733, 0, -334.676, 770.501, 107.438, 3.97935, 0, 0, -0.913545, 0.406738, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+78, 1733, 0, -324.499, 927.473, 131.106, 6.21337, 0, 0, -0.0348988, 0.999391, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+79, 1733, 0, -317.895, 855.736, 90.625, 2.23402, 0, 0, 0.898793, 0.438373, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+80, 1733, 0, -309.482, 971.346, 133.761, 3.927, 0, 0, -0.923879, 0.382686, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+81, 1733, 0, -305.998, 1099.13, 75.9756, 1.51844, 0, 0, 0.688354, 0.725374, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+82, 1733, 0, -293.892, 1008, 113.602, 5.95157, 0, 0, -0.165047, 0.986286, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+83, 1733, 0, -30.8879, 1023, 74.69, 6.24828, 0, 0, -0.0174522, 0.999848, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+84, 1733, 0, 380.065, 1130.56, 108.131, 5.98648, 0, 0, -0.147809, 0.989016, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+85, 1733, 0, 756.192, 1784.68, 30.1367, 0.122173, 0, 0, 0.0610485, 0.998135, 300, 300, 100, 1, 0, 0, 0, 10),
(@OGUID+86, 1733, 0, 1075.68, 860.883, 18.6506, 1.11701, 0, 0, 0.529919, 0.848048, 300, 300, 100, 1, 0, 0, 0, 10);
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_max`) VALUES
(@PTEMPLATE+1, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+2, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+3, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+4, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+5, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+6, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+7, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+8, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+9, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+10, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+11, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+12, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+13, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+14, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+15, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+16, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+17, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+18, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+19, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+20, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+21, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+22, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+23, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+24, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+25, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+26, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+27, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+28, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+29, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+30, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+31, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+32, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+33, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+34, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+35, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+36, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+37, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+38, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+39, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+40, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+41, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+42, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@PTEMPLATE+43, 1, 'Tin Vein / Silver Vein - Silverpine Forest', 10);
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_max`) VALUES
(@OGUID+1, @PTEMPLATE+1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+2, @PTEMPLATE+2, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+3, @PTEMPLATE+3, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+4, @PTEMPLATE+4, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+5, @PTEMPLATE+5, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+6, @PTEMPLATE+6, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+7, @PTEMPLATE+7, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+8, @PTEMPLATE+8, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+9, @PTEMPLATE+9, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+10, @PTEMPLATE+10, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+11, @PTEMPLATE+11, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+12, @PTEMPLATE+12, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+13, @PTEMPLATE+13, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+14, @PTEMPLATE+14, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+15, @PTEMPLATE+15, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+16, @PTEMPLATE+16, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+17, @PTEMPLATE+17, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+18, @PTEMPLATE+18, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+19, @PTEMPLATE+19, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+20, @PTEMPLATE+20, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+21, @PTEMPLATE+21, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+22, @PTEMPLATE+22, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+23, @PTEMPLATE+23, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+24, @PTEMPLATE+24, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+25, @PTEMPLATE+25, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+26, @PTEMPLATE+26, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+27, @PTEMPLATE+27, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+28, @PTEMPLATE+28, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+29, @PTEMPLATE+29, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+30, @PTEMPLATE+30, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+31, @PTEMPLATE+31, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+32, @PTEMPLATE+32, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+33, @PTEMPLATE+33, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+34, @PTEMPLATE+34, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+35, @PTEMPLATE+35, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+36, @PTEMPLATE+36, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+37, @PTEMPLATE+37, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+38, @PTEMPLATE+38, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+39, @PTEMPLATE+39, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+40, @PTEMPLATE+40, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+41, @PTEMPLATE+41, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+42, @PTEMPLATE+42, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+43, @PTEMPLATE+43, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+44, @PTEMPLATE+1, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+45, @PTEMPLATE+2, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+46, @PTEMPLATE+3, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+47, @PTEMPLATE+4, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+48, @PTEMPLATE+5, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+49, @PTEMPLATE+6, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+50, @PTEMPLATE+7, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+51, @PTEMPLATE+8, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+52, @PTEMPLATE+9, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+53, @PTEMPLATE+10, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+54, @PTEMPLATE+11, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+55, @PTEMPLATE+12, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+56, @PTEMPLATE+13, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+57, @PTEMPLATE+14, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+58, @PTEMPLATE+15, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+59, @PTEMPLATE+16, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+60, @PTEMPLATE+17, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+61, @PTEMPLATE+18, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+62, @PTEMPLATE+19, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+63, @PTEMPLATE+20, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+64, @PTEMPLATE+21, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+65, @PTEMPLATE+22, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+66, @PTEMPLATE+23, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+67, @PTEMPLATE+24, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+68, @PTEMPLATE+25, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+69, @PTEMPLATE+26, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+70, @PTEMPLATE+27, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+71, @PTEMPLATE+28, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+72, @PTEMPLATE+29, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+73, @PTEMPLATE+30, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+74, @PTEMPLATE+31, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+75, @PTEMPLATE+32, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+76, @PTEMPLATE+33, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+77, @PTEMPLATE+34, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+78, @PTEMPLATE+35, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+79, @PTEMPLATE+36, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+80, @PTEMPLATE+37, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+81, @PTEMPLATE+38, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+82, @PTEMPLATE+39, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+83, @PTEMPLATE+40, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+84, @PTEMPLATE+41, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+85, @PTEMPLATE+42, 'Tin Vein / Silver Vein - Silverpine Forest', 10),
(@OGUID+86, @PTEMPLATE+43, 'Tin Vein / Silver Vein - Silverpine Forest', 10);
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
(@PTEMPLATE+1, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+2, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+3, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+4, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+5, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+6, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+7, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+8, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+9, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+10, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+11, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+12, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+13, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+14, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+15, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+16, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+17, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+18, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+19, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+20, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+21, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+22, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+23, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+24, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+25, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+26, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+27, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+28, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+29, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+30, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+31, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+32, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+33, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+34, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+35, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+36, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+37, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+38, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+39, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+40, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+41, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+42, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0),
(@PTEMPLATE+43, 1354, 0, 'Silverpine Forest - Tin Vein / Silver Vein', 0);
UPDATE `pool_gameobject` SET `chance` = 95 WHERE `description` = "Tin Vein / Silver Vein - Silverpine Forest" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 1732);
UPDATE `pool_gameobject` SET `chance` = 5 WHERE `description` = "Tin Vein / Silver Vein - Silverpine Forest" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 1733);
UPDATE `pool_gameobject` SET `description` = 'Copper Vein - Silverpine Forest' WHERE `guid` IN (35596, 4848, 4677);
UPDATE `pool_template` SET `description` = 'Copper Veins - Silverpine Forest (Master Pool)' WHERE `entry` = 1044;
UPDATE `pool_template` SET `max_limit` = 10 WHERE `entry` = 1354;
-- 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