656 lines
65 KiB
SQL
656 lines
65 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`='20250208210356');
|
|
IF v = 0 THEN
|
|
INSERT INTO `migrations` VALUES ('20250208210356');
|
|
-- Add your query below.
|
|
|
|
|
|
-- Thousand Needles
|
|
UPDATE `pool_template` SET `description` = 'Copper Veins - Thousand Needles (Master Pool)' WHERE `entry` = 2585;
|
|
|
|
-- Silver Vein / Gold Vein / Iron Deposit
|
|
SET @OGUID = 94700;
|
|
SET @PTEMPLATE = 5771;
|
|
|
|
DELETE FROM `gameobject` WHERE `guid` IN (23564, 23566, 23567, 27905, 27906, 27907, 27908, 27909, 27910, 27911, 27912, 27913, 27914, 27915, 27916, 27917, 27918, 27919, 27920, 27921, 27922, 27923, 27924, 27925, 27926, 27927, 27928, 27929, 27930, 27931, 27932, 27933, 27934, 27935, 27936, 27937, 27938, 27939, 27940, 27941, 27942, 27943, 27944, 27945, 27946, 27947, 27948, 27949, 27950, 27951, 27952, 27953, 27954, 27955, 27956, 27957, 27958, 27959, 27960, 27961, 27962, 27963, 27964, 27965, 27966, 27967, 27968, 27969, 27970, 27971, 27972, 27973, 27974, 27975, 27976, 27977, 27978, 27979, 27980, 27981, 27982, 27983, 27984, 27985, 27986, 27987, 27988, 27989, 27990, 27991, 27992, 27993, 27994, 27995, 27996, 27997, 27998, 27999, 28000, 28001, 28002, 28003, 28004, 28005, 28006, 28007, 28008, 28009, 28010, 28011, 28012, 28013, 28014, 28015, 28016, 28017, 28018, 28019, 28020, 251706, 427066, 427078, 427079, 427269, 427270, 427271, 427272, 427273, 427274, 427275, 427276, 427277, 427278, 427279, 427280, 427307, 3996274);
|
|
DELETE FROM `pool_gameobject` WHERE `guid` IN (23564, 23566, 23567, 27905, 27906, 27907, 27908, 27909, 27910, 27911, 27912, 27913, 27914, 27915, 27916, 27917, 27918, 27919, 27920, 27921, 27922, 27923, 27924, 27925, 27926, 27927, 27928, 27929, 27930, 27931, 27932, 27933, 27934, 27935, 27936, 27937, 27938, 27939, 27940, 27941, 27942, 27943, 27944, 27945, 27946, 27947, 27948, 27949, 27950, 27951, 27952, 27953, 27954, 27955, 27956, 27957, 27958, 27959, 27960, 27961, 27962, 27963, 27964, 27965, 27966, 27967, 27968, 27969, 27970, 27971, 27972, 27973, 27974, 27975, 27976, 27977, 27978, 27979, 27980, 27981, 27982, 27983, 27984, 27985, 27986, 27987, 27988, 27989, 27990, 27991, 27992, 27993, 27994, 27995, 27996, 27997, 27998, 27999, 28000, 28001, 28002, 28003, 28004, 28005, 28006, 28007, 28008, 28009, 28010, 28011, 28012, 28013, 28014, 28015, 28016, 28017, 28018, 28019, 28020, 251706, 427066, 427078, 427079, 427269, 427270, 427271, 427272, 427273, 427274, 427275, 427276, 427277, 427278, 427279, 427280, 427307, 3996274);
|
|
DELETE FROM `pool_template` WHERE `entry` IN (1132, 3201, 3202, 3203, 3204, 3205, 3206, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3216, 3217, 3218, 3219, 3220, 3221, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3231, 3232, 3233, 3234, 3235, 3236, 3237, 3238, 3239, 3240, 3241, 3242, 3243, 3244, 3245, 3246, 3247, 3248, 3249, 3250, 3251, 3252, 3253, 3254, 3255, 3256, 3257, 3258, 17054, 17103, 17104, 17105, 17106, 17107, 17108);
|
|
DELETE FROM `pool_pool` WHERE `mother_pool` IN (1132);
|
|
|
|
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, 1, -6532.55, -4128.76, -55.495, 1.83259, 0, 0, 0.793353, 0.608762, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+2, 1733, 1, -6442.12, -4242.3, -54.6349, 5.11382, 0, 0, -0.551936, 0.833886, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+3, 1733, 1, -6252.91, -3443.52, -56.3055, 5.89921, 0, 0, -0.190808, 0.981627, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+4, 1733, 1, -5997.79, -3502.85, -55.509, 0.541051, 0, 0, 0.267238, 0.963631, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+5, 1733, 1, -5844.58, -3851.99, -65.3664, 2.75761, 0, 0, 0.981627, 0.190812, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+6, 1733, 1, -5788.96, -3886.07, -94.2955, 4.60767, 0, 0, -0.743144, 0.669131, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+7, 1733, 1, -5776.24, -3844.42, -76.4322, 1.95477, 0, 0, 0.829038, 0.559193, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+8, 1733, 1, -5745.73, -3374.91, -36.3462, 2.14675, 0, 0, 0.878817, 0.47716, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+9, 1733, 1, -5673.35, -3048.78, -44.674, 5.14872, 0, 0, -0.537299, 0.843392, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+10 , 1733, 1, -5640.35, -2641.38, -53.4689, 3.68265, 0, 0, -0.96363, 0.267241, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+11 , 1733, 1, -5588.24, -1607.68, 15.5705, 2.35619, 0, 0, 0.92388, 0.382683, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+12 , 1733, 1, -5587.33, -1566.82, 11.8091, 4.25861, 0, 0, -0.848047, 0.529921, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+13 , 1733, 1, -5567.1, -1626.25, 21.2436, 5.70723, 0, 0, -0.284015, 0.95882, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+14 , 1733, 1, -5548.84, -1636.24, 24.4084, 5.61996, 0, 0, -0.325567, 0.945519, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+15 , 1733, 1, -5532.84, -1944.92, -58.501, 3.87463, 0, 0, -0.93358, 0.358368, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+16 , 1733, 1, -5489.34, -1611.09, 28.4255, 1.93731, 0, 0, 0.824125, 0.566408, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+17 , 1733, 1, -5486.36, -3329.63, -27.7709, 2.87979, 0, 0, 0.991445, 0.130528, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+18 , 1733, 1, -5469.75, -1886.91, -48.3739, 5.51524, 0, 0, -0.374606, 0.927184, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+19 , 1733, 1, -5466.35, -2869.42, -44.2802, 6.17847, 0, 0, -0.0523357, 0.99863, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+20 , 1733, 1, -5454.53, -2033.24, -61.5043, 0.698131, 0, 0, 0.34202, 0.939693, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+21 , 1733, 1, -5418.67, -3033.57, -33.8258, 0.0174525, 0, 0, 0.00872612, 0.999962, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+22 , 1733, 1, -5404.91, -1701.34, -40.4254, 3.00195, 0, 0, 0.997563, 0.0697661, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+23 , 1733, 1, -5326.44, -2796.01, -47.6895, 1.71042, 0, 0, 0.754709, 0.656059, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+24 , 1733, 1, -5312.22, -1758.25, -48.4673, 0.191985, 0, 0, 0.0958452, 0.995396, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+25 , 1733, 1, -5145.4, -2558.24, -46.5695, 4.10153, 0, 0, -0.887011, 0.461749, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+26 , 1733, 1, -5127.78, -2299.17, -52.9948, 5.75959, 0, 0, -0.258819, 0.965926, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+27 , 1733, 1, -5061.47, -2103.62, -37.6556, 5.79449, 0, 0, -0.241921, 0.970296, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+28 , 1733, 1, -5039.4, -2408.02, -56.0424, 0.715585, 0, 0, 0.350207, 0.936672, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+29 , 1733, 1, -5033.33, -2374.65, -54.6469, 1.36136, 0, 0, 0.62932, 0.777146, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+30 , 1733, 1, -5024.05, -1225.72, -43.9318, 5.89921, 0, 0, -0.190808, 0.981627, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+31 , 1733, 1, -4992.01, -2287.35, -61.6907, 3.75246, 0, 0, -0.953716, 0.300708, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+32 , 1733, 1, -4988.54, -1004.27, -3.79234, 1.37881, 0, 0, 0.636078, 0.771625, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+33 , 1733, 1, -4986.4, -2329.07, -55.3801, 2.75761, 0, 0, 0.981627, 0.190812, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+34 , 1733, 1, -4974.84, -1079.21, -37.8522, 3.26377, 0, 0, -0.998135, 0.0610518, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+35 , 1733, 1, -4950.58, -2380.18, -55.297, 5.75959, 0, 0, -0.258819, 0.965926, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+36 , 1733, 1, -4948.33, -1362.02, -47.0395, 5.65487, 0, 0, -0.309016, 0.951057, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+37 , 1733, 1, -4947.92, -2297.38, -67.5671, 5.49779, 0, 0, -0.382683, 0.92388, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+38 , 1733, 1, -4936.44, -2339.09, -70.7542, 1.39626, 0, 0, 0.642787, 0.766045, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+39 , 1733, 1, -4870.65, -891.578, -3.81378, 2.1293, 0, 0, 0.874619, 0.48481, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+40 , 1733, 1, -4810.13, -1983.76, -53.1975, 2.56563, 0, 0, 0.958819, 0.284016, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+41 , 1733, 1, -4789.91, -1668.89, -41.3834, 3.7001, 0, 0, -0.961261, 0.27564, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+42 , 1733, 1, -4774.29, -1954.05, -48.3147, 5.96903, 0, 0, -0.156434, 0.987688, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+43 , 1733, 1, -4682.48, -1486.84, -48.1071, 1.50098, 0, 0, 0.681998, 0.731354, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+44 , 1733, 1, -6669.38, -3510.05, -55.2365, 0.104719, 0, 0, 0.0523357, 0.99863, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+45 , 1733, 1, -5828.66, -3958.22, -71.9373, 4.4855, 0, 0, -0.782608, 0.622515, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+46 , 1733, 1, -5733.67, -2366.92, -52.8921, 1.29154, 0, 0, 0.601815, 0.798636, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+47 , 1733, 1, -5612.46, -1614.09, 16.0412, -2.05949, 0, 0, 0.857167, -0.515038, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+48 , 1733, 1, -5506.93, -1633.27, 25.4443, 1.72787, 0, 0, 0.760406, 0.649449, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+49 , 1733, 1, -5461.61, -3746.99, -56.6769, 1.41372, 0, 0, 0.649448, 0.760406, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+50 , 1733, 1, -5370.03, -3160.29, -25.9727, -1.22173, 0, 0, 0.573576, -0.819152, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+51 , 1733, 1, -5167.42, -1163.57, 52.6308, 1.8675, 0, 0, 0.803857, 0.594823, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+52 , 1733, 1, -5148.01, -1103.74, 50.1736, 2.89725, 0, 0, 0.992546, 0.121869, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+53 , 1733, 1, -5112.55, -2418.23, -49.4608, 5.34071, 0, 0, -0.45399, 0.891007, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+54 , 1733, 1, -5072.24, -2388.78, -53.4579, 2.21656, 0, 0, 0.894934, 0.446199, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+55 , 1733, 1, -4996.56, -856.463, -4.48619, 2.53072, 0, 0, 0.953716, 0.300708, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+56 , 1733, 1, -4933.02, -2261.19, -65.3333, 2.61799, 0, 0, 0.965925, 0.258821, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+57 , 1733, 1, -4877.07, -2306.67, -55.4266, 2.70526, 0, 0, 0.976296, 0.21644, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+58 , 1733, 1, -4521.09, -1129.81, -52.7595, 6.03884, 0, 0, -0.121869, 0.992546, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+59 , 1733, 1, -4928.64, -2353.08, -48.7368, 2.23402, 0, 0, 0.898793, 0.438373, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+60 , 1733, 1, -5520.2, -4100.96, -55.0269, 3.54302, 0, 0, -0.979924, 0.19937, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+61 , 1733, 1, -5492.38, -3416.5, -37.0193, 2.30383, 0, 0, 0.913545, 0.406738, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+62 , 1733, 1, -5345.78, -1597.08, -53.6225, 1.43117, 0, 0, 0.656058, 0.75471, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+63 , 1733, 1, -5174.3, -1392.93, -49.6103, 5.72468, 0, 0, -0.275637, 0.961262, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+64 , 1733, 1, -5075.88, -1345.86, -44.2591, 3.07177, 0, 0, 0.999391, 0.0349061, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+65 , 1733, 1, -5049.19, -1018.44, -3.38531, 0.453785, 0, 0, 0.224951, 0.97437, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+66 , 1734, 1, -6532.55, -4128.76, -55.495, 1.83259, 0, 0, 0.793353, 0.608762, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+67 , 1734, 1, -6442.12, -4242.3, -54.6349, 5.11382, 0, 0, -0.551936, 0.833886, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+68 , 1734, 1, -6252.91, -3443.52, -56.3055, 5.89921, 0, 0, -0.190808, 0.981627, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+69 , 1734, 1, -5997.79, -3502.85, -55.509, 0.541051, 0, 0, 0.267238, 0.963631, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+70 , 1734, 1, -5844.58, -3851.99, -65.3664, 2.75761, 0, 0, 0.981627, 0.190812, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+71 , 1734, 1, -5788.96, -3886.07, -94.2955, 4.60767, 0, 0, -0.743144, 0.669131, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+72 , 1734, 1, -5776.24, -3844.42, -76.4322, 1.95477, 0, 0, 0.829038, 0.559193, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+73 , 1734, 1, -5745.73, -3374.91, -36.3462, 2.14675, 0, 0, 0.878817, 0.47716, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+74 , 1734, 1, -5673.35, -3048.78, -44.674, 5.14872, 0, 0, -0.537299, 0.843392, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+75 , 1734, 1, -5640.35, -2641.38, -53.4689, 3.68265, 0, 0, -0.96363, 0.267241, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+76 , 1734, 1, -5588.24, -1607.68, 15.5705, 2.35619, 0, 0, 0.92388, 0.382683, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+77 , 1734, 1, -5587.33, -1566.82, 11.8091, 4.25861, 0, 0, -0.848047, 0.529921, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+78 , 1734, 1, -5567.1, -1626.25, 21.2436, 5.70723, 0, 0, -0.284015, 0.95882, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+79 , 1734, 1, -5548.84, -1636.24, 24.4084, 5.61996, 0, 0, -0.325567, 0.945519, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+80 , 1734, 1, -5532.84, -1944.92, -58.501, 3.87463, 0, 0, -0.93358, 0.358368, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+81 , 1734, 1, -5489.34, -1611.09, 28.4255, 1.93731, 0, 0, 0.824125, 0.566408, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+82 , 1734, 1, -5486.36, -3329.63, -27.7709, 2.87979, 0, 0, 0.991445, 0.130528, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+83 , 1734, 1, -5469.75, -1886.91, -48.3739, 5.51524, 0, 0, -0.374606, 0.927184, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+84 , 1734, 1, -5466.35, -2869.42, -44.2802, 6.17847, 0, 0, -0.0523357, 0.99863, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+85 , 1734, 1, -5454.53, -2033.24, -61.5043, 0.698131, 0, 0, 0.34202, 0.939693, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+86 , 1734, 1, -5418.67, -3033.57, -33.8258, 0.0174525, 0, 0, 0.00872612, 0.999962, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+87 , 1734, 1, -5404.91, -1701.34, -40.4254, 3.00195, 0, 0, 0.997563, 0.0697661, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+88 , 1734, 1, -5326.44, -2796.01, -47.6895, 1.71042, 0, 0, 0.754709, 0.656059, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+89 , 1734, 1, -5312.22, -1758.25, -48.4673, 0.191985, 0, 0, 0.0958452, 0.995396, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+90 , 1734, 1, -5145.4, -2558.24, -46.5695, 4.10153, 0, 0, -0.887011, 0.461749, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+91 , 1734, 1, -5127.78, -2299.17, -52.9948, 5.75959, 0, 0, -0.258819, 0.965926, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+92 , 1734, 1, -5061.47, -2103.62, -37.6556, 5.79449, 0, 0, -0.241921, 0.970296, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+93 , 1734, 1, -5039.4, -2408.02, -56.0424, 0.715585, 0, 0, 0.350207, 0.936672, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+94 , 1734, 1, -5033.33, -2374.65, -54.6469, 1.36136, 0, 0, 0.62932, 0.777146, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+95 , 1734, 1, -5024.05, -1225.72, -43.9318, 5.89921, 0, 0, -0.190808, 0.981627, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+96 , 1734, 1, -4992.01, -2287.35, -61.6907, 3.75246, 0, 0, -0.953716, 0.300708, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+97 , 1734, 1, -4988.54, -1004.27, -3.79234, 1.37881, 0, 0, 0.636078, 0.771625, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+98 , 1734, 1, -4986.4, -2329.07, -55.3801, 2.75761, 0, 0, 0.981627, 0.190812, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+99 , 1734, 1, -4974.84, -1079.21, -37.8522, 3.26377, 0, 0, -0.998135, 0.0610518, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+100, 1734, 1, -4950.58, -2380.18, -55.297, 5.75959, 0, 0, -0.258819, 0.965926, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+101, 1734, 1, -4948.33, -1362.02, -47.0395, 5.65487, 0, 0, -0.309016, 0.951057, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+102, 1734, 1, -4947.92, -2297.38, -67.5671, 5.49779, 0, 0, -0.382683, 0.92388, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+103, 1734, 1, -4936.44, -2339.09, -70.7542, 1.39626, 0, 0, 0.642787, 0.766045, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+104, 1734, 1, -4870.65, -891.578, -3.81378, 2.1293, 0, 0, 0.874619, 0.48481, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+105, 1734, 1, -4810.13, -1983.76, -53.1975, 2.56563, 0, 0, 0.958819, 0.284016, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+106, 1734, 1, -4789.91, -1668.89, -41.3834, 3.7001, 0, 0, -0.961261, 0.27564, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+107, 1734, 1, -4774.29, -1954.05, -48.3147, 5.96903, 0, 0, -0.156434, 0.987688, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+108, 1734, 1, -4682.48, -1486.84, -48.1071, 1.50098, 0, 0, 0.681998, 0.731354, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+109, 1734, 1, -6669.38, -3510.05, -55.2365, 0.104719, 0, 0, 0.0523357, 0.99863, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+110, 1734, 1, -5828.66, -3958.22, -71.9373, 4.4855, 0, 0, -0.782608, 0.622515, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+111, 1734, 1, -5733.67, -2366.92, -52.8921, 1.29154, 0, 0, 0.601815, 0.798636, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+112, 1734, 1, -5612.46, -1614.09, 16.0412, -2.05949, 0, 0, 0.857167, -0.515038, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+113, 1734, 1, -5506.93, -1633.27, 25.4443, 1.72787, 0, 0, 0.760406, 0.649449, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+114, 1734, 1, -5461.61, -3746.99, -56.6769, 1.41372, 0, 0, 0.649448, 0.760406, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+115, 1734, 1, -5370.03, -3160.29, -25.9727, -1.22173, 0, 0, 0.573576, -0.819152, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+116, 1734, 1, -5167.42, -1163.57, 52.6308, 1.8675, 0, 0, 0.803857, 0.594823, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+117, 1734, 1, -5148.01, -1103.74, 50.1736, 2.89725, 0, 0, 0.992546, 0.121869, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+118, 1734, 1, -5112.55, -2418.23, -49.4608, 5.34071, 0, 0, -0.45399, 0.891007, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+119, 1734, 1, -5072.24, -2388.78, -53.4579, 2.21656, 0, 0, 0.894934, 0.446199, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+120, 1734, 1, -4996.56, -856.463, -4.48619, 2.53072, 0, 0, 0.953716, 0.300708, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+121, 1734, 1, -4933.02, -2261.19, -65.3333, 2.61799, 0, 0, 0.965925, 0.258821, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+122, 1734, 1, -4877.07, -2306.67, -55.4266, 2.70526, 0, 0, 0.976296, 0.21644, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+123, 1734, 1, -4521.09, -1129.81, -52.7595, 6.03884, 0, 0, -0.121869, 0.992546, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+124, 1734, 1, -4928.64, -2353.08, -48.7368, 2.23402, 0, 0, 0.898793, 0.438373, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+125, 1734, 1, -5520.2, -4100.96, -55.0269, 3.54302, 0, 0, -0.979924, 0.19937, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+126, 1734, 1, -5492.38, -3416.5, -37.0193, 2.30383, 0, 0, 0.913545, 0.406738, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+127, 1734, 1, -5345.78, -1597.08, -53.6225, 1.43117, 0, 0, 0.656058, 0.75471, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+128, 1734, 1, -5174.3, -1392.93, -49.6103, 5.72468, 0, 0, -0.275637, 0.961262, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+129, 1734, 1, -5075.88, -1345.86, -44.2591, 3.07177, 0, 0, 0.999391, 0.0349061, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+130, 1734, 1, -5049.19, -1018.44, -3.38531, 0.453785, 0, 0, 0.224951, 0.97437, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+131, 1735, 1, -6532.55, -4128.76, -55.495, 1.83259, 0, 0, 0.793353, 0.608762, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+132, 1735, 1, -6442.12, -4242.3, -54.6349, 5.11382, 0, 0, -0.551936, 0.833886, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+133, 1735, 1, -6252.91, -3443.52, -56.3055, 5.89921, 0, 0, -0.190808, 0.981627, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+134, 1735, 1, -5997.79, -3502.85, -55.509, 0.541051, 0, 0, 0.267238, 0.963631, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+135, 1735, 1, -5844.58, -3851.99, -65.3664, 2.75761, 0, 0, 0.981627, 0.190812, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+136, 1735, 1, -5788.96, -3886.07, -94.2955, 4.60767, 0, 0, -0.743144, 0.669131, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+137, 1735, 1, -5776.24, -3844.42, -76.4322, 1.95477, 0, 0, 0.829038, 0.559193, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+138, 1735, 1, -5745.73, -3374.91, -36.3462, 2.14675, 0, 0, 0.878817, 0.47716, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+139, 1735, 1, -5673.35, -3048.78, -44.674, 5.14872, 0, 0, -0.537299, 0.843392, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+140, 1735, 1, -5640.35, -2641.38, -53.4689, 3.68265, 0, 0, -0.96363, 0.267241, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+141, 1735, 1, -5588.24, -1607.68, 15.5705, 2.35619, 0, 0, 0.92388, 0.382683, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+142, 1735, 1, -5587.33, -1566.82, 11.8091, 4.25861, 0, 0, -0.848047, 0.529921, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+143, 1735, 1, -5567.1, -1626.25, 21.2436, 5.70723, 0, 0, -0.284015, 0.95882, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+144, 1735, 1, -5548.84, -1636.24, 24.4084, 5.61996, 0, 0, -0.325567, 0.945519, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+145, 1735, 1, -5532.84, -1944.92, -58.501, 3.87463, 0, 0, -0.93358, 0.358368, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+146, 1735, 1, -5489.34, -1611.09, 28.4255, 1.93731, 0, 0, 0.824125, 0.566408, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+147, 1735, 1, -5486.36, -3329.63, -27.7709, 2.87979, 0, 0, 0.991445, 0.130528, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+148, 1735, 1, -5469.75, -1886.91, -48.3739, 5.51524, 0, 0, -0.374606, 0.927184, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+149, 1735, 1, -5466.35, -2869.42, -44.2802, 6.17847, 0, 0, -0.0523357, 0.99863, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+150, 1735, 1, -5454.53, -2033.24, -61.5043, 0.698131, 0, 0, 0.34202, 0.939693, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+151, 1735, 1, -5418.67, -3033.57, -33.8258, 0.0174525, 0, 0, 0.00872612, 0.999962, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+152, 1735, 1, -5404.91, -1701.34, -40.4254, 3.00195, 0, 0, 0.997563, 0.0697661, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+153, 1735, 1, -5326.44, -2796.01, -47.6895, 1.71042, 0, 0, 0.754709, 0.656059, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+154, 1735, 1, -5312.22, -1758.25, -48.4673, 0.191985, 0, 0, 0.0958452, 0.995396, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+155, 1735, 1, -5145.4, -2558.24, -46.5695, 4.10153, 0, 0, -0.887011, 0.461749, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+156, 1735, 1, -5127.78, -2299.17, -52.9948, 5.75959, 0, 0, -0.258819, 0.965926, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+157, 1735, 1, -5061.47, -2103.62, -37.6556, 5.79449, 0, 0, -0.241921, 0.970296, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+158, 1735, 1, -5039.4, -2408.02, -56.0424, 0.715585, 0, 0, 0.350207, 0.936672, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+159, 1735, 1, -5033.33, -2374.65, -54.6469, 1.36136, 0, 0, 0.62932, 0.777146, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+160, 1735, 1, -5024.05, -1225.72, -43.9318, 5.89921, 0, 0, -0.190808, 0.981627, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+161, 1735, 1, -4992.01, -2287.35, -61.6907, 3.75246, 0, 0, -0.953716, 0.300708, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+162, 1735, 1, -4988.54, -1004.27, -3.79234, 1.37881, 0, 0, 0.636078, 0.771625, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+163, 1735, 1, -4986.4, -2329.07, -55.3801, 2.75761, 0, 0, 0.981627, 0.190812, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+164, 1735, 1, -4974.84, -1079.21, -37.8522, 3.26377, 0, 0, -0.998135, 0.0610518, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+165, 1735, 1, -4950.58, -2380.18, -55.297, 5.75959, 0, 0, -0.258819, 0.965926, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+166, 1735, 1, -4948.33, -1362.02, -47.0395, 5.65487, 0, 0, -0.309016, 0.951057, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+167, 1735, 1, -4947.92, -2297.38, -67.5671, 5.49779, 0, 0, -0.382683, 0.92388, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+168, 1735, 1, -4936.44, -2339.09, -70.7542, 1.39626, 0, 0, 0.642787, 0.766045, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+169, 1735, 1, -4870.65, -891.578, -3.81378, 2.1293, 0, 0, 0.874619, 0.48481, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+170, 1735, 1, -4810.13, -1983.76, -53.1975, 2.56563, 0, 0, 0.958819, 0.284016, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+171, 1735, 1, -4789.91, -1668.89, -41.3834, 3.7001, 0, 0, -0.961261, 0.27564, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+172, 1735, 1, -4774.29, -1954.05, -48.3147, 5.96903, 0, 0, -0.156434, 0.987688, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+173, 1735, 1, -4682.48, -1486.84, -48.1071, 1.50098, 0, 0, 0.681998, 0.731354, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+174, 1735, 1, -6669.38, -3510.05, -55.2365, 0.104719, 0, 0, 0.0523357, 0.99863, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+175, 1735, 1, -5828.66, -3958.22, -71.9373, 4.4855, 0, 0, -0.782608, 0.622515, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+176, 1735, 1, -5733.67, -2366.92, -52.8921, 1.29154, 0, 0, 0.601815, 0.798636, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+177, 1735, 1, -5612.46, -1614.09, 16.0412, -2.05949, 0, 0, 0.857167, -0.515038, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+178, 1735, 1, -5506.93, -1633.27, 25.4443, 1.72787, 0, 0, 0.760406, 0.649449, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+179, 1735, 1, -5461.61, -3746.99, -56.6769, 1.41372, 0, 0, 0.649448, 0.760406, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+180, 1735, 1, -5370.03, -3160.29, -25.9727, -1.22173, 0, 0, 0.573576, -0.819152, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+181, 1735, 1, -5167.42, -1163.57, 52.6308, 1.8675, 0, 0, 0.803857, 0.594823, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+182, 1735, 1, -5148.01, -1103.74, 50.1736, 2.89725, 0, 0, 0.992546, 0.121869, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+183, 1735, 1, -5112.55, -2418.23, -49.4608, 5.34071, 0, 0, -0.45399, 0.891007, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+184, 1735, 1, -5072.24, -2388.78, -53.4579, 2.21656, 0, 0, 0.894934, 0.446199, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+185, 1735, 1, -4996.56, -856.463, -4.48619, 2.53072, 0, 0, 0.953716, 0.300708, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+186, 1735, 1, -4933.02, -2261.19, -65.3333, 2.61799, 0, 0, 0.965925, 0.258821, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+187, 1735, 1, -4877.07, -2306.67, -55.4266, 2.70526, 0, 0, 0.976296, 0.21644, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+188, 1735, 1, -4521.09, -1129.81, -52.7595, 6.03884, 0, 0, -0.121869, 0.992546, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+189, 1735, 1, -4928.64, -2353.08, -48.7368, 2.23402, 0, 0, 0.898793, 0.438373, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+190, 1735, 1, -5520.2, -4100.96, -55.0269, 3.54302, 0, 0, -0.979924, 0.19937, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+191, 1735, 1, -5492.38, -3416.5, -37.0193, 2.30383, 0, 0, 0.913545, 0.406738, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+192, 1735, 1, -5345.78, -1597.08, -53.6225, 1.43117, 0, 0, 0.656058, 0.75471, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+193, 1735, 1, -5174.3, -1392.93, -49.6103, 5.72468, 0, 0, -0.275637, 0.961262, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+194, 1735, 1, -5075.88, -1345.86, -44.2591, 3.07177, 0, 0, 0.999391, 0.0349061, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+195, 1735, 1, -5049.19, -1018.44, -3.38531, 0.453785, 0, 0, 0.224951, 0.97437, 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 - Thousand Needles', 10),
|
|
(@PTEMPLATE+2, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+3, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+4, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+5, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+6, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+7, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+8, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+9, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+10, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+11, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+12, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+13, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+14, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+15, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+16, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+17, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+18, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+19, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+20, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+21, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+22, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+23, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+24, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+25, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+26, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+27, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+28, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+29, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+30, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+31, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+32, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+33, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+34, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+35, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+36, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+37, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+38, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+39, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+40, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+41, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+42, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+43, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+44, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+45, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+46, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+47, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+48, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+49, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+50, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+51, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+52, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+53, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+54, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+55, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+56, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+57, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+58, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+59, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+60, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+61, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+62, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+63, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+64, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+65, 1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10);
|
|
|
|
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_max`) VALUES
|
|
(@OGUID+1, @PTEMPLATE+1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+2, @PTEMPLATE+2, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+3, @PTEMPLATE+3, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+4, @PTEMPLATE+4, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+5, @PTEMPLATE+5, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+6, @PTEMPLATE+6, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+7, @PTEMPLATE+7, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+8, @PTEMPLATE+8, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+9, @PTEMPLATE+9, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+10, @PTEMPLATE+10, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+11, @PTEMPLATE+11, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+12, @PTEMPLATE+12, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+13, @PTEMPLATE+13, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+14, @PTEMPLATE+14, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+15, @PTEMPLATE+15, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+16, @PTEMPLATE+16, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+17, @PTEMPLATE+17, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+18, @PTEMPLATE+18, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+19, @PTEMPLATE+19, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+20, @PTEMPLATE+20, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+21, @PTEMPLATE+21, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+22, @PTEMPLATE+22, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+23, @PTEMPLATE+23, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+24, @PTEMPLATE+24, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+25, @PTEMPLATE+25, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+26, @PTEMPLATE+26, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+27, @PTEMPLATE+27, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+28, @PTEMPLATE+28, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+29, @PTEMPLATE+29, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+30, @PTEMPLATE+30, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+31, @PTEMPLATE+31, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+32, @PTEMPLATE+32, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+33, @PTEMPLATE+33, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+34, @PTEMPLATE+34, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+35, @PTEMPLATE+35, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+36, @PTEMPLATE+36, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+37, @PTEMPLATE+37, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+38, @PTEMPLATE+38, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+39, @PTEMPLATE+39, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+40, @PTEMPLATE+40, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+41, @PTEMPLATE+41, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+42, @PTEMPLATE+42, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+43, @PTEMPLATE+43, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+44, @PTEMPLATE+44, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+45, @PTEMPLATE+45, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+46, @PTEMPLATE+46, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+47, @PTEMPLATE+47, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+48, @PTEMPLATE+48, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+49, @PTEMPLATE+49, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+50, @PTEMPLATE+50, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+51, @PTEMPLATE+51, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+52, @PTEMPLATE+52, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+53, @PTEMPLATE+53, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+54, @PTEMPLATE+54, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+55, @PTEMPLATE+55, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+56, @PTEMPLATE+56, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+57, @PTEMPLATE+57, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+58, @PTEMPLATE+58, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+59, @PTEMPLATE+59, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+60, @PTEMPLATE+60, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+61, @PTEMPLATE+61, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+62, @PTEMPLATE+62, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+63, @PTEMPLATE+63, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+64, @PTEMPLATE+64, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+65, @PTEMPLATE+65, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+66, @PTEMPLATE+1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+67, @PTEMPLATE+2, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+68, @PTEMPLATE+3, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+69, @PTEMPLATE+4, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+70, @PTEMPLATE+5, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+71, @PTEMPLATE+6, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+72, @PTEMPLATE+7, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+73, @PTEMPLATE+8, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+74, @PTEMPLATE+9, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+75, @PTEMPLATE+10, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+76, @PTEMPLATE+11, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+77, @PTEMPLATE+12, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+78, @PTEMPLATE+13, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+79, @PTEMPLATE+14, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+80, @PTEMPLATE+15, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+81, @PTEMPLATE+16, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+82, @PTEMPLATE+17, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+83, @PTEMPLATE+18, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+84, @PTEMPLATE+19, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+85, @PTEMPLATE+20, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+86, @PTEMPLATE+21, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+87, @PTEMPLATE+22, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+88, @PTEMPLATE+23, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+89, @PTEMPLATE+24, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+90, @PTEMPLATE+25, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+91, @PTEMPLATE+26, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+92, @PTEMPLATE+27, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+93, @PTEMPLATE+28, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+94, @PTEMPLATE+29, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+95, @PTEMPLATE+30, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+96, @PTEMPLATE+31, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+97, @PTEMPLATE+32, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+98, @PTEMPLATE+33, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+99, @PTEMPLATE+34, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+100, @PTEMPLATE+35, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+101, @PTEMPLATE+36, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+102, @PTEMPLATE+37, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+103, @PTEMPLATE+38, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+104, @PTEMPLATE+39, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+105, @PTEMPLATE+40, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+106, @PTEMPLATE+41, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+107, @PTEMPLATE+42, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+108, @PTEMPLATE+43, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+109, @PTEMPLATE+44, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+110, @PTEMPLATE+45, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+111, @PTEMPLATE+46, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+112, @PTEMPLATE+47, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+113, @PTEMPLATE+48, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+114, @PTEMPLATE+49, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+115, @PTEMPLATE+50, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+116, @PTEMPLATE+51, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+117, @PTEMPLATE+52, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+118, @PTEMPLATE+53, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+119, @PTEMPLATE+54, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+120, @PTEMPLATE+55, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+121, @PTEMPLATE+56, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+122, @PTEMPLATE+57, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+123, @PTEMPLATE+58, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+124, @PTEMPLATE+59, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+125, @PTEMPLATE+60, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+126, @PTEMPLATE+61, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+127, @PTEMPLATE+62, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+128, @PTEMPLATE+63, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+129, @PTEMPLATE+64, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+130, @PTEMPLATE+65, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+131, @PTEMPLATE+1, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+132, @PTEMPLATE+2, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+133, @PTEMPLATE+3, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+134, @PTEMPLATE+4, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+135, @PTEMPLATE+5, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+136, @PTEMPLATE+6, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+137, @PTEMPLATE+7, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+138, @PTEMPLATE+8, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+139, @PTEMPLATE+9, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+140, @PTEMPLATE+10, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+141, @PTEMPLATE+11, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+142, @PTEMPLATE+12, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+143, @PTEMPLATE+13, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+144, @PTEMPLATE+14, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+145, @PTEMPLATE+15, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+146, @PTEMPLATE+16, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+147, @PTEMPLATE+17, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+148, @PTEMPLATE+18, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+149, @PTEMPLATE+19, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+150, @PTEMPLATE+20, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+151, @PTEMPLATE+21, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+152, @PTEMPLATE+22, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+153, @PTEMPLATE+23, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+154, @PTEMPLATE+24, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+155, @PTEMPLATE+25, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+156, @PTEMPLATE+26, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+157, @PTEMPLATE+27, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+158, @PTEMPLATE+28, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+159, @PTEMPLATE+29, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+160, @PTEMPLATE+30, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+161, @PTEMPLATE+31, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+162, @PTEMPLATE+32, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+163, @PTEMPLATE+33, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+164, @PTEMPLATE+34, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+165, @PTEMPLATE+35, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+166, @PTEMPLATE+36, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+167, @PTEMPLATE+37, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+168, @PTEMPLATE+38, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+169, @PTEMPLATE+39, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+170, @PTEMPLATE+40, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+171, @PTEMPLATE+41, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+172, @PTEMPLATE+42, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+173, @PTEMPLATE+43, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+174, @PTEMPLATE+44, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+175, @PTEMPLATE+45, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+176, @PTEMPLATE+46, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+177, @PTEMPLATE+47, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+178, @PTEMPLATE+48, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+179, @PTEMPLATE+49, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+180, @PTEMPLATE+50, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+181, @PTEMPLATE+51, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+182, @PTEMPLATE+52, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+183, @PTEMPLATE+53, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+184, @PTEMPLATE+54, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+185, @PTEMPLATE+55, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+186, @PTEMPLATE+56, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+187, @PTEMPLATE+57, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+188, @PTEMPLATE+58, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+189, @PTEMPLATE+59, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+190, @PTEMPLATE+60, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+191, @PTEMPLATE+61, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+192, @PTEMPLATE+62, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+193, @PTEMPLATE+63, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+194, @PTEMPLATE+64, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10),
|
|
(@OGUID+195, @PTEMPLATE+65, 'Silver Vein / Gold Vein / Iron Deposit - Thousand Needles', 10);
|
|
|
|
INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`, `flags`) VALUES
|
|
(@PTEMPLATE+1, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+2, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+3, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+4, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+5, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+6, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+7, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+8, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+9, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+10, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+11, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+12, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+13, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+14, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+15, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+16, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+17, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+18, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+19, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+20, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+21, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+22, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+23, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+24, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+25, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+26, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+27, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+28, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+29, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+30, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+31, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+32, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+33, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+34, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+35, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+36, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+37, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+38, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+39, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+40, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+41, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+42, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+43, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+44, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+45, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+46, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+47, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+48, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+49, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+50, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+51, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+52, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+53, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+54, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+55, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+56, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+57, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+58, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+59, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+60, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+61, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+62, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+63, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+64, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0),
|
|
(@PTEMPLATE+65, 329, 0, 'Thousand Needles - Silver Vein / Gold Vein / Iron Deposit', 0);
|
|
|
|
UPDATE `pool_template` SET `max_limit` = 17 WHERE `entry` = 329;
|
|
|
|
-- Gold Vein / Mithril Deposit / Truesilver Deposit
|
|
SET @OGUID = 94895;
|
|
SET @PTEMPLATE = 3201;
|
|
|
|
DELETE FROM `gameobject` WHERE `guid` IN (22820, 22821, 22822, 22823, 22824, 220829, 220830, 220831);
|
|
DELETE FROM `pool_gameobject` WHERE `guid` IN (22820, 22821, 22822, 22823, 22824, 220829, 220830, 220831);
|
|
DELETE FROM `pool_template` WHERE `entry` IN (2586);
|
|
|
|
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, -5207.28, -1218.45, 49.2347, 1.13446, 0, 0, 0.537299, 0.843392, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+2, 1734, 1, -4912.88, -2400.77, -53.0078, 0.436332, 0, 0, 0.216439, 0.976296, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+3, 1734, 1, -4909.81, -920.933, -4.00124, 4.50295, 0, 0, -0.777145, 0.629321, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+4, 1734, 1, -4900.71, -2266.33, -70.389, 2.80998, 0, 0, 0.986285, 0.16505, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+5, 1734, 1, -4871.51, -2358.7, -53.7004, 4.31097, 0, 0, -0.833885, 0.551938, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+6, 1734, 1, -4949.52, -2293.53, -82.4419, 3.17653, 0, 0, -0.999847, 0.0174693, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+7, 1734, 1, -4941.11, -2333.84, -54.8899, 5.18363, 0, 0, -0.522498, 0.85264, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+8, 1734, 1, -4888.66, -2285.12, -59.6999, 5.37562, 0, 0, -0.438371, 0.898794, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+9, 2040, 1, -5207.28, -1218.45, 49.2347, 1.13446, 0, 0, 0.537299, 0.843392, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+10, 2040, 1, -4912.88, -2400.77, -53.0078, 0.436332, 0, 0, 0.216439, 0.976296, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+11, 2040, 1, -4909.81, -920.933, -4.00124, 4.50295, 0, 0, -0.777145, 0.629321, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+12, 2040, 1, -4900.71, -2266.33, -70.389, 2.80998, 0, 0, 0.986285, 0.16505, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+13, 2040, 1, -4871.51, -2358.7, -53.7004, 4.31097, 0, 0, -0.833885, 0.551938, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+14, 2040, 1, -4949.52, -2293.53, -82.4419, 3.17653, 0, 0, -0.999847, 0.0174693, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+15, 2040, 1, -4941.11, -2333.84, -54.8899, 5.18363, 0, 0, -0.522498, 0.85264, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+16, 2040, 1, -4888.66, -2285.12, -59.6999, 5.37562, 0, 0, -0.438371, 0.898794, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+17, 2047, 1, -5207.28, -1218.45, 49.2347, 1.13446, 0, 0, 0.537299, 0.843392, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+18, 2047, 1, -4912.88, -2400.77, -53.0078, 0.436332, 0, 0, 0.216439, 0.976296, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+19, 2047, 1, -4909.81, -920.933, -4.00124, 4.50295, 0, 0, -0.777145, 0.629321, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+20, 2047, 1, -4900.71, -2266.33, -70.389, 2.80998, 0, 0, 0.986285, 0.16505, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+21, 2047, 1, -4871.51, -2358.7, -53.7004, 4.31097, 0, 0, -0.833885, 0.551938, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+22, 2047, 1, -4949.52, -2293.53, -82.4419, 3.17653, 0, 0, -0.999847, 0.0174693, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+23, 2047, 1, -4941.11, -2333.84, -54.8899, 5.18363, 0, 0, -0.522498, 0.85264, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+24, 2047, 1, -4888.66, -2285.12, -59.6999, 5.37562, 0, 0, -0.438371, 0.898794, 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 - Thousand Needles', 10),
|
|
(@PTEMPLATE+2, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+3, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+4, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+5, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+6, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+7, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@PTEMPLATE+8, 1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10);
|
|
|
|
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_max`) VALUES
|
|
(@OGUID+1, @PTEMPLATE+1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+2, @PTEMPLATE+2, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+3, @PTEMPLATE+3, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+4, @PTEMPLATE+4, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+5, @PTEMPLATE+5, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+6, @PTEMPLATE+6, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+7, @PTEMPLATE+7, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+8, @PTEMPLATE+8, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+9, @PTEMPLATE+1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+10, @PTEMPLATE+2, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+11, @PTEMPLATE+3, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+12, @PTEMPLATE+4, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+13, @PTEMPLATE+5, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+14, @PTEMPLATE+6, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+15, @PTEMPLATE+7, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+16, @PTEMPLATE+8, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+17, @PTEMPLATE+1, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+18, @PTEMPLATE+2, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+19, @PTEMPLATE+3, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+20, @PTEMPLATE+4, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+21, @PTEMPLATE+5, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+22, @PTEMPLATE+6, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+23, @PTEMPLATE+7, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10),
|
|
(@OGUID+24, @PTEMPLATE+8, 'Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles', 10);
|
|
|
|
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `flags`, `instance`, `patch_min`, `patch_max`) VALUES
|
|
(1132, 2, 'Thousand Needles - 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, 1132, 0, 'Thousand Needles - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
|
|
(@PTEMPLATE+2, 1132, 0, 'Thousand Needles - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
|
|
(@PTEMPLATE+3, 1132, 0, 'Thousand Needles - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
|
|
(@PTEMPLATE+4, 1132, 0, 'Thousand Needles - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
|
|
(@PTEMPLATE+5, 1132, 0, 'Thousand Needles - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
|
|
(@PTEMPLATE+6, 1132, 0, 'Thousand Needles - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
|
|
(@PTEMPLATE+7, 1132, 0, 'Thousand Needles - Gold Vein / Mithril Deposit / Truesilver Deposit', 0),
|
|
(@PTEMPLATE+8, 1132, 0, 'Thousand Needles - Gold Vein / Mithril Deposit / Truesilver Deposit', 0);
|
|
|
|
-- Add Chance
|
|
UPDATE `pool_gameobject` SET `chance` = 5 WHERE `description` = "Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 1734);
|
|
UPDATE `pool_gameobject` SET `chance` = 90 WHERE `description` = "Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 2040);
|
|
UPDATE `pool_gameobject` SET `chance` = 5 WHERE `description` = "Gold Vein / Mithril Deposit / Truesilver Deposit - Thousand Needles" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 2047);
|
|
UPDATE `pool_gameobject` SET `chance` = 5 WHERE `description` = "Silver Vein / Gold Vein / Iron Deposit - Thousand Needles" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 1733);
|
|
UPDATE `pool_gameobject` SET `chance` = 5 WHERE `description` = "Silver Vein / Gold Vein / Iron Deposit - Thousand Needles" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 1734);
|
|
UPDATE `pool_gameobject` SET `chance` = 90 WHERE `description` = "Silver Vein / Gold Vein / Iron Deposit - Thousand Needles" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 1735);
|
|
UPDATE `pool_gameobject` SET `chance` = 5 WHERE `description` = "Ooze Covered Silver Vein / Ooze Covered Gold Vein / Ooze Covered Mithril Deposit - Thousand Needles" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 73940);
|
|
UPDATE `pool_gameobject` SET `chance` = 90 WHERE `description` = "Ooze Covered Silver Vein / Ooze Covered Gold Vein / Ooze Covered Mithril Deposit - Thousand Needles" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 123310);
|
|
UPDATE `pool_gameobject` SET `chance` = 5 WHERE `description` = "Ooze Covered Silver Vein / Ooze Covered Gold Vein / Ooze Covered Mithril Deposit - Thousand Needles" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 73941);
|
|
UPDATE `pool_gameobject` SET `chance` = 95 WHERE `description` = "Tin Vein / Silver Vein - Thousand Needles" && `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` = 1732);
|
|
UPDATE `pool_gameobject` SET `chance` = 5 WHERE `description` = "Tin Vein / Silver Vein - Thousand Needles" && `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;
|