aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2021-05-29 15:29:02 +0300
committerShauren <shauren.trinity@gmail.com>2022-03-10 22:56:20 +0100
commit5635625e3ad1e5a79115d3dedfe9da546d3d9b35 (patch)
tree6373c2772f51926846a3d60a605c0073defd4702 /sql
parent7beaa6c93812118866a6db1e6ac5e50c06208694 (diff)
DB/GameObject: Add herbs & veins to Bloodmyst Isle
Closes #21657 Source of some new spawns: CMaNGOS (cherry picked from commit ab9a0024b11b8ef5364fa25cca032d7a9cb9c116)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2022_03_10_26_world_2021_05_29_00_world.sql606
1 files changed, 606 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_10_26_world_2021_05_29_00_world.sql b/sql/updates/world/master/2022_03_10_26_world_2021_05_29_00_world.sql
new file mode 100644
index 00000000000..0ee7f2f7325
--- /dev/null
+++ b/sql/updates/world/master/2022_03_10_26_world_2021_05_29_00_world.sql
@@ -0,0 +1,606 @@
+--
+SET @OGUID := 92329; -- 263
+SET @POOL := 827; -- 17
+
+-- Old spawns
+DELETE FROM `gameobject` WHERE `guid` IN (86179,86192,87058) AND `id` = 1617;
+DELETE FROM `gameobject` WHERE `guid` IN (86213) AND `id` = 1618;
+DELETE FROM `gameobject` WHERE `guid` IN (86237) AND `id` = 1619;
+DELETE FROM `gameobject` WHERE `guid` IN (86252) AND `id` = 1620;
+DELETE FROM `gameobject` WHERE `guid` IN (86267) AND `id` = 1621;
+DELETE FROM `gameobject` WHERE `guid` IN (86931) AND `id` = 2045;
+
+DELETE FROM `gameobject` WHERE `guid` IN (120324,120325,120363) AND `id` = 1731;
+
+DELETE FROM `spawn_group` WHERE `spawnId` IN (86179,86192,87058,86213,86237,86252,86267,86931,120324,120325,120363) AND `spawnType` = 1;
+
+-- All herbs are inside one big pool(this may be not correct)
+-- Tin and Silver veins share spawn points(this is correct) and are inside big pool with Copper(this too may be not correct)
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+000 AND @OGUID+262;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `ScriptName`, `VerifiedBuild`) VALUES
+-- Silverleaf
+(@OGUID+000,1617,530,0,0,'0',0,-2699.71,-11346.4,12.928,5.51524,0,0,-0.374606,0.927184,60,255,1,'',15595),
+(@OGUID+001,1617,530,0,0,'0',0,-2696.29,-11493.1,17.9947,1.0472,0,0,0.5,0.866025,60,255,1,'',23420),
+(@OGUID+002,1617,530,0,0,'0',0,-2684.94,-12056.9,13.9258,4.60767,0,0,-0.743144,0.669131,60,255,1,'',15595),
+(@OGUID+003,1617,530,0,0,'0',0,-2675.34,-11634.8,15.7757,6.0912,0,0,-0.0958452,0.995396,60,255,1,'',15595),
+(@OGUID+004,1617,530,0,0,'0',0,-2645.56,-11931.9,14.5141,2.61799,0,0,0.965925,0.258821,60,255,1,'',23420),
+(@OGUID+005,1617,530,0,0,'0',0,-2617.8,-12219.6,15.9916,0.122173,0,0,0.0610485,0.998135,60,255,1,'',15595),
+(@OGUID+006,1617,530,0,0,'0',0,-2580.38,-11245,27.1669,1.23918,0,0,0.580703,0.814116,60,255,1,'',15354),
+(@OGUID+007,1617,530,0,0,'0',0,-2546.22,-11685,14.4306,4.60767,0,0,-0.743144,0.669131,60,255,1,'',15354),
+(@OGUID+008,1617,530,0,0,'0',0,-2523.98,-12000.2,26.2587,1.93731,0,0,0.824125,0.566408,60,255,1,'',15595),
+(@OGUID+009,1617,530,0,0,'0',0,-2446.58,-12154.5,33.0611,2.86234,0,0,0.990268,0.139175,60,255,1,'',15595),
+(@OGUID+010,1617,530,0,0,'0',0,-2441.68,-11796.7,17.4486,0.994837,0,0,0.477158,0.878817,60,255,1,'',0), -- Old
+(@OGUID+011,1617,530,0,0,'0',0,-2427.84,-12362.4,17.0107,0.314158,0,0,0.156434,0.987688,60,255,1,'',23420),
+(@OGUID+012,1617,530,0,0,'0',0,-2423.83,-12068.6,32.706,2.87979,0,0,0.991445,0.130528,60,255,1,'',15595),
+(@OGUID+013,1617,530,0,0,'0',0,-2415.86,-11326.8,29.5279,5.5676,0,0,-0.350207,0.936672,60,255,1,'',15595),
+(@OGUID+014,1617,530,0,0,'0',0,-2391.87,-11672.8,17.054,3.73501,0,0,-0.956305,0.292372,60,255,1,'',23420),
+(@OGUID+015,1617,530,0,0,'0',0,-2321.52,-11147.6,13.9421,3.56047,0,0,-0.978148,0.207912,60,255,1,'',23420),
+(@OGUID+016,1617,530,0,0,'0',0,-2252.96,-11818.6,32.141,2.00713,0,0,0.843391,0.5373,60,255,1,'',15595),
+(@OGUID+017,1617,530,0,0,'0',0,-2200.83,-12371.6,43.2402,3.21142,0,0,-0.999391,0.0349061,60,255,1,'',15595),
+(@OGUID+018,1617,530,0,0,'0',0,-2166.06,-11983.6,33.1277,4.29351,0,0,-0.83867,0.54464,60,255,1,'',15595),
+(@OGUID+019,1617,530,0,0,'0',0,-2134.85,-12246.9,36.6871,0.209439,0,0,0.104528,0.994522,60,255,1,'',15050),
+(@OGUID+020,1617,530,0,0,'0',0,-2122.72,-10776.4,67.9924,4.55531,0,0,-0.760406,0.649449,60,255,1,'',15595),
+(@OGUID+021,1617,530,0,0,'0',0,-2022.36,-11468.8,59.0985,4.29351,0,0,-0.83867,0.54464,60,255,1,'',15595),
+(@OGUID+022,1617,530,0,0,'0',0,-2018.78,-12215.1,28.9882,2.53072,0,0,0.953716,0.300708,60,255,1,'',23420),
+(@OGUID+023,1617,530,0,0,'0',0,-2002.78,-10915.1,59.5212,3.82227,0,0,-0.942641,0.333808,60,255,1,'',15595),
+(@OGUID+024,1617,530,0,0,'0',0,-1980.92,-12133.5,20.3163,3.03684,0,0,0.998629,0.0523532,60,255,1,'',15354),
+(@OGUID+025,1617,530,0,0,'0',0,-1959.89,-11030,58.5355,5.81195,0,0,-0.233445,0.97237,60,255,1,'',15595),
+(@OGUID+026,1617,530,0,0,'0',0,-1944.92,-11243.5,67.0487,2.96704,0,0,0.996194,0.087165,60,255,1,'',15595),
+(@OGUID+027,1617,530,0,0,'0',0,-1862.02,-10891.4,66.8597,3.78737,0,0,-0.948323,0.317306,60,255,1,'',15595),
+(@OGUID+028,1617,530,0,0,'0',0,-1815.82,-11638.7,35.1727,3.83973,0,0,-0.939692,0.342021,60,255,1,'',23420),
+(@OGUID+029,1617,530,0,0,'0',0,-1809.92,-11544.1,34.5465,1.09956,0,0,0.522498,0.85264,60,255,1,'',15354),
+(@OGUID+030,1617,530,0,0,'0',0,-1748.07,-11659.3,32.9697,3.68265,0,0,-0.96363,0.267241,60,255,1,'',15595),
+(@OGUID+031,1617,530,0,0,'0',0,-1656.17,-10801.8,56.6357,5.68977,0,0,-0.292372,0.956305,60,255,1,'',15595),
+(@OGUID+032,1617,530,0,0,'0',0,-1647.26,-11027.3,69.5511,2.32129,0,0,0.91706,0.39875,60,255,1,'',15595),
+(@OGUID+033,1617,530,0,0,'0',0,-1642.36,-11419.6,46.5991,0.349065,0,0,0.173648,0.984808,60,255,1,'',15595),
+(@OGUID+034,1617,530,0,0,'0',0,-1624.99,-11785.5,25.1514,4.67748,0,0,-0.719339,0.694659,60,255,1,'',15595),
+(@OGUID+035,1617,530,0,0,'0',0,-1611.04,-11171.6,72.9195,1.44862,0,0,0.66262,0.748956,60,255,1,'',23420),
+(@OGUID+036,1617,530,0,0,'0',0,-1529.48,-11852.1,23.2169,0.820303,0,0,0.398748,0.91706,60,255,1,'',15595),
+(@OGUID+037,1617,530,0,0,'0',0,-1520.08,-11947.7,19.0502,4.11898,0,0,-0.882947,0.469473,60,255,1,'',15595),
+(@OGUID+038,1617,530,0,0,'0',0,-1493.51,-10987.9,62.9779,5.044,0,0,-0.580703,0.814116,60,255,1,'',15595),
+(@OGUID+039,1617,530,0,0,'0',0,-1469.07,-11514.1,49.4985,5.60251,0,0,-0.333807,0.942641,60,255,1,'',15595),
+(@OGUID+040,1617,530,0,0,'0',0,-1467.16,-11473.4,68.5504,4.41568,0,0,-0.803857,0.594823,60,255,1,'',15595),
+(@OGUID+041,1617,530,0,0,'0',0,-1425.88,-12470.5,7.34532,1.98967,0,0,0.83867,0.54464,60,255,1,'',15595),
+(@OGUID+042,1617,530,0,0,'0',0,-1372.92,-11625.4,12.2141,3.61284,0,0,-0.972369,0.233448,60,255,1,'',15354),
+(@OGUID+043,1617,530,0,0,'0',0,-1363.64,-12303.8,11.1449,3.35105,0,0,-0.994521,0.104536,60,255,1,'',15595),
+(@OGUID+044,1617,530,0,0,'0',0,-1291.66,-11363.1,19.9527,1.37881,0,0,0.636078,0.771625,60,255,1,'',15595),
+(@OGUID+045,1617,530,0,0,'0',0,-1016.62,-12415.8,9.81749,3.3685,0,0,-0.993571,0.113208,60,255,1,'',15354),
+-- Peacebloom
+(@OGUID+046,1618,530,0,0,'0',0,-2735.03,-11418.5,15.9594,6.07375,0,0,-0.104528,0.994522,60,255,1,'',15595),
+(@OGUID+047,1618,530,0,0,'0',0,-2696.16,-11546.6,13.2771,2.65289,0,0,0.970295,0.241925,60,255,1,'',23420),
+(@OGUID+048,1618,530,0,0,'0',0,-2679.62,-11961.2,11.4456,1.97222,0,0,0.833885,0.551938,60,255,1,'',15595),
+(@OGUID+049,1618,530,0,0,'0',0,-2626.66,-11229,17.78,4.50295,0,0,-0.777145,0.629321,60,255,1,'',15595),
+(@OGUID+050,1618,530,0,0,'0',0,-2585.57,-11713.1,10.875,4.46804,0,0,-0.788011,0.615662,60,255,1,'',15354),
+(@OGUID+051,1618,530,0,0,'0',0,-2491.9,-12385.2,14.5525,1.18682,0,0,0.559193,0.829038,60,255,1,'',23420),
+(@OGUID+052,1618,530,0,0,'0',0,-2478.92,-12199,31.572,2.60054,0,0,0.96363,0.267241,60,255,1,'',15595),
+(@OGUID+053,1618,530,0,0,'0',0,-2322.26,-12202,28.4463,3.97936,0,0,-0.913545,0.406738,60,255,1,'',23420),
+(@OGUID+054,1618,530,0,0,'0',0,-2301.35,-11574.3,24.207,4.86947,0,0,-0.649447,0.760406,60,255,1,'',15595),
+(@OGUID+055,1618,530,0,0,'0',0,-2125.26,-11984.9,33.3093,-2.74016,0,0,-0.979924,0.199371,60,255,1,'',0), -- Old
+(@OGUID+056,1618,530,0,0,'0',0,-2090.27,-10941.8,67.0977,5.14872,0,0,-0.537299,0.843392,60,255,1,'',15595),
+(@OGUID+057,1618,530,0,0,'0',0,-2082.74,-11586.2,47.8181,4.90438,0,0,-0.636078,0.771625,60,255,1,'',15595),
+(@OGUID+058,1618,530,0,0,'0',0,-2029.44,-12140.7,28.5895,1.02974,0,0,0.492423,0.870356,60,255,1,'',23420),
+(@OGUID+059,1618,530,0,0,'0',0,-1987.83,-11514.4,59.7899,3.71755,0,0,-0.958819,0.284016,60,255,1,'',15595),
+(@OGUID+060,1618,530,0,0,'0',0,-1949.53,-11678.1,38.3223,4.60767,0,0,-0.743144,0.669131,60,255,1,'',15354),
+(@OGUID+061,1618,530,0,0,'0',0,-1948.22,-11114.4,58.1355,1.309,0,0,0.608761,0.793354,60,255,1,'',15595),
+(@OGUID+062,1618,530,0,0,'0',0,-1856.68,-11387.6,50.0463,3.97935,0,0,-0.913545,0.406738,60,255,1,'',15595),
+(@OGUID+063,1618,530,0,0,'0',0,-1844.49,-11194.5,60.5953,2.80997,0,0,0.986285,0.16505,60,255,1,'',23420),
+(@OGUID+064,1618,530,0,0,'0',0,-1843.19,-11000.7,66.2526,2.72271,0,0,0.978148,0.207912,60,255,1,'',15595),
+(@OGUID+065,1618,530,0,0,'0',0,-1831.75,-11977.8,16.4136,5.88176,0,0,-0.199368,0.979925,60,255,1,'',15354),
+(@OGUID+066,1618,530,0,0,'0',0,-1778.22,-12185,11.6519,1.6057,0,0,0.719339,0.694659,60,255,1,'',23420),
+(@OGUID+067,1618,530,0,0,'0',0,-1764.8,-11885.1,16.9838,4.39823,0,0,-0.809016,0.587786,60,255,1,'',15595),
+(@OGUID+068,1618,530,0,0,'0',0,-1720.33,-11262.5,60.9996,1.22173,0,0,0.573576,0.819152,60,255,1,'',15595),
+(@OGUID+069,1618,530,0,0,'0',0,-1586.02,-11259.2,68.5185,1.81514,0,0,0.788011,0.615662,60,255,1,'',15595),
+(@OGUID+070,1618,530,0,0,'0',0,-1581.88,-11471.6,53.2475,1.72787,0,0,0.760406,0.649449,60,255,1,'',15595),
+(@OGUID+071,1618,530,0,0,'0',0,-1533.91,-10933,60.8792,1.95477,0,0,0.829038,0.559193,60,255,1,'',23420),
+(@OGUID+072,1618,530,0,0,'0',0,-1503.15,-11082.7,75.8964,3.28124,0,0,-0.997563,0.0697661,60,255,1,'',23420),
+(@OGUID+073,1618,530,0,0,'0',0,-1471.55,-11424.1,68.5332,4.36332,0,0,-0.819152,0.573577,60,255,1,'',15595),
+(@OGUID+074,1618,530,0,0,'0',0,-1449.41,-11761.8,20.8245,1.95477,0,0,0.829038,0.559193,60,255,1,'',15595),
+(@OGUID+075,1618,530,0,0,'0',0,-1410.44,-11294.2,11.8678,1.3439,0,0,0.622514,0.782609,60,255,1,'',15354),
+(@OGUID+076,1618,530,0,0,'0',0,-1323.51,-12276.3,13.9101,4.31097,0,0,-0.833885,0.551938,60,255,1,'',15595),
+(@OGUID+077,1618,530,0,0,'0',0,-1296.78,-11536.9,8.1757,4.18879,0,0,-0.866025,0.500001,60,255,1,'',15354),
+(@OGUID+078,1618,530,0,0,'0',0,-1273.2,-11915.5,10.9974,2.37364,0,0,0.927183,0.374608,60,255,1,'',23420),
+(@OGUID+079,1618,530,0,0,'0',0,-1214.45,-12592,9.5534,2.61799,0,0,0.965925,0.258821,60,255,1,'',15595),
+-- Earthroot
+(@OGUID+080,1619,530,0,0,'0',0,-2695.23,-11903.5,10.8037,1.83259,0,0,0.793353,0.608762,60,255,1,'',23420),
+(@OGUID+081,1619,530,0,0,'0',0,-2654.27,-11355.7,20.8014,2.02458,0,0,0.848047,0.529921,60,255,1,'',15595),
+(@OGUID+082,1619,530,0,0,'0',0,-2592.02,-11616.2,21.8234,4.20625,0,0,-0.861628,0.507539,60,255,1,'',23420),
+(@OGUID+083,1619,530,0,0,'0',0,-2559.16,-11296,43.7225,1.55334,0,0,0.700909,0.713251,60,255,1,'',23420),
+(@OGUID+084,1619,530,0,0,'0',0,-2540.3,-11824.2,19.3858,1.48353,0,0,0.67559,0.737277,60,255,1,'',0), -- Old
+(@OGUID+085,1619,530,0,0,'0',0,-2512.22,-12267.2,15.9818,1.01229,0,0,0.484809,0.87462,60,255,1,'',23420),
+(@OGUID+086,1619,530,0,0,'0',0,-2412.46,-11443.2,34.2144,6.14356,0,0,-0.0697556,0.997564,60,255,1,'',15595),
+(@OGUID+087,1619,530,0,0,'0',0,-2331.32,-11236.6,35.3493,5.67232,0,0,-0.300706,0.953717,60,255,1,'',23420),
+(@OGUID+088,1619,530,0,0,'0',0,-2271.71,-11823,24.9026,0.59341,0,0,0.292371,0.956305,60,255,1,'',15595),
+(@OGUID+089,1619,530,0,0,'0',0,-2220.26,-12375.8,48.2671,2.84488,0,0,0.989016,0.147811,60,255,1,'',15595),
+(@OGUID+090,1619,530,0,0,'0',0,-2154,-11375.8,59.8357,2.67035,0,0,0.972369,0.233448,60,255,1,'',15595),
+(@OGUID+091,1619,530,0,0,'0',0,-2058.5,-11007.1,66.4187,0.122173,0,0,0.0610485,0.998135,60,255,1,'',15595),
+(@OGUID+092,1619,530,0,0,'0',0,-1928.46,-11042.8,67.2471,4.57276,0,0,-0.754709,0.656059,60,255,1,'',15595),
+(@OGUID+093,1619,530,0,0,'0',0,-1852.43,-12051.8,40.9457,2.79252,0,0,0.984807,0.173652,60,255,1,'',15354),
+(@OGUID+094,1619,530,0,0,'0',0,-1759.91,-11391.6,57.9349,3.76991,0,0,-0.951056,0.309017,60,255,1,'',15354),
+(@OGUID+095,1619,530,0,0,'0',0,-1759.49,-12047.2,36.6137,5.49779,0,0,-0.382683,0.92388,60,255,1,'',15595),
+(@OGUID+096,1619,530,0,0,'0',0,-1711.11,-12019.7,18.2238,6.0912,0,0,-0.0958452,0.995396,60,255,1,'',15595),
+(@OGUID+097,1619,530,0,0,'0',0,-1641.72,-11850.3,19.4328,5.53269,0,0,-0.366501,0.930418,60,255,1,'',15595),
+(@OGUID+098,1619,530,0,0,'0',0,-1636.8,-10800.2,64.2572,0.209439,0,0,0.104528,0.994522,60,255,1,'',15354),
+(@OGUID+099,1619,530,0,0,'0',0,-1606.35,-11718,38.0013,0.139624,0,0,0.0697556,0.997564,60,255,1,'',15595),
+(@OGUID+100,1619,530,0,0,'0',0,-1603.28,-10697.8,135.453,3.9619,0,0,-0.91706,0.39875,60,255,1,'',15595),
+(@OGUID+101,1619,530,0,0,'0',0,-1484.31,-11895.9,24.6969,4.90438,0,0,-0.636078,0.771625,60,255,1,'',23420),
+(@OGUID+102,1619,530,0,0,'0',0,-1466.08,-11272.9,16.1648,2.93214,0,0,0.994521,0.104536,60,255,1,'',15354),
+(@OGUID+103,1619,530,0,0,'0',0,-1391.12,-10708.7,82.7563,2.42601,0,0,0.936672,0.350207,60,255,1,'',15595),
+(@OGUID+104,1619,530,0,0,'0',0,-1339.43,-11412.9,20.7981,1.41372,0,0,0.649447,0.760406,60,255,1,'',23420),
+-- Mageroyal
+(@OGUID+105,1620,530,0,0,'0',0,-2516.52,-12175.1,28.0866,-2.14675,0,0,-0.878816,0.477161,60,255,1,'',0), -- Old
+(@OGUID+106,1620,530,0,0,'0',0,-2345.84,-11301.5,28.8769,0.506145,0,0,0.25038,0.968148,60,255,1,'',23420),
+(@OGUID+107,1620,530,0,0,'0',0,-2299.87,-11333.8,33.8944,3.3685,0,0,-0.993571,0.113208,60,255,1,'',15595),
+(@OGUID+108,1620,530,0,0,'0',0,-2254.9,-11471.1,32.9848,4.50295,0,0,-0.777145,0.629321,60,255,1,'',23420),
+(@OGUID+109,1620,530,0,0,'0',0,-2138.1,-12351.8,21.9268,5.42797,0,0,-0.414693,0.909961,60,255,1,'',15595),
+(@OGUID+110,1620,530,0,0,'0',0,-1882.93,-10831.7,66.4228,1.37881,0,0,0.636078,0.771625,60,255,1,'',15595),
+(@OGUID+111,1620,530,0,0,'0',0,-1878.84,-12001.9,19.1418,3.89209,0,0,-0.930417,0.366502,60,255,1,'',15354),
+(@OGUID+112,1620,530,0,0,'0',0,-1813.92,-12164.2,14.5448,1.71042,0,0,0.754709,0.656059,60,255,1,'',15354),
+(@OGUID+113,1620,530,0,0,'0',0,-1766.51,-11435.3,45.29,5.25344,0,0,-0.492423,0.870356,60,255,1,'',15595),
+(@OGUID+114,1620,530,0,0,'0',0,-1699.82,-10779.6,61.9589,3.45576,0,0,-0.987688,0.156436,60,255,1,'',15595),
+(@OGUID+115,1620,530,0,0,'0',0,-1653.94,-11066.5,74.5673,0.750491,0,0,0.366501,0.930418,60,255,1,'',15595),
+(@OGUID+116,1620,530,0,0,'0',0,-1485.23,-10958.5,61.9453,0.122173,0,0,0.0610485,0.998135,60,255,1,'',23420),
+(@OGUID+117,1620,530,0,0,'0',0,-1466.48,-11258.5,11.789,3.01941,0,0,0.998135,0.0610518,60,255,1,'',15595),
+(@OGUID+118,1620,530,0,0,'0',0,-1398.05,-11509.8,14.8946,2.32129,0,0,0.91706,0.39875,60,255,1,'',15354),
+(@OGUID+119,1620,530,0,0,'0',0,-1283.47,-12357,27.4307,4.92183,0,0,-0.62932,0.777146,60,255,1,'',23420),
+(@OGUID+120,1620,530,0,0,'0',0,-1212.31,-12353.2,22.3029,2.46091,0,0,0.942641,0.333808,60,255,1,'',23420),
+(@OGUID+121,1620,530,0,0,'0',0,-1166.7,-12579.2,7.81908,1.41372,0,0,0.649447,0.760406,60,255,1,'',15354),
+(@OGUID+122,1620,530,0,0,'0',0,-1123.42,-12503.2,22.1624,2.65289,0,0,0.970295,0.241925,60,255,1,'',15595),
+(@OGUID+123,1620,530,0,0,'0',0,-1116.09,-12429.9,29.4141,3.14159,0,0,-1,0,60,255,1,'',15595),
+-- Briarthorn
+(@OGUID+124,1621,530,0,0,'0',0,-2638.05,-12250.8,13.4452,-1.55334,0,0,-0.700908,0.713252,60,255,1,'',0), -- Old
+(@OGUID+125,1621,530,0,0,'0',0,-2613.78,-11599.6,20.3261,0.767944,0,0,0.374606,0.927184,60,255,1,'',15595),
+(@OGUID+126,1621,530,0,0,'0',0,-2580.99,-11183.6,16.307,5.89921,0,0,-0.190808,0.981627,60,255,1,'',23420),
+(@OGUID+127,1621,530,0,0,'0',0,-2526.78,-12322,13.2532,1.72787,0,0,0.760406,0.649449,60,255,1,'',15595),
+(@OGUID+128,1621,530,0,0,'0',0,-2518.32,-11743.4,12.3661,4.90438,0,0,-0.636078,0.771625,60,255,1,'',15354),
+(@OGUID+129,1621,530,0,0,'0',0,-2479.73,-11866.4,18.649,-0.296705,0,0,-0.147809,0.989016,60,255,1,'',10505),
+(@OGUID+130,1621,530,0,0,'0',0,-2405.39,-12260.1,28.3805,2.56563,0,0,0.958819,0.284016,60,255,1,'',15354),
+(@OGUID+131,1621,530,0,0,'0',0,-2353.39,-11232.4,29.4921,2.56563,0,0,0.958819,0.284016,60,255,1,'',15595),
+(@OGUID+132,1621,530,0,0,'0',0,-2346.91,-11915.3,21.3509,4.36332,0,0,-0.819152,0.573577,60,255,1,'',24461),
+(@OGUID+133,1621,530,0,0,'0',0,-2326.95,-11815.1,16.3598,1.23918,0,0,0.580703,0.814116,60,255,1,'',15050),
+(@OGUID+134,1621,530,0,0,'0',0,-2322.43,-12138.3,33.9351,0.925024,0,0,0.446198,0.894935,60,255,1,'',15050),
+(@OGUID+135,1621,530,0,0,'0',0,-2228.01,-11577.1,24.536,5.91667,0,0,-0.182235,0.983255,60,255,1,'',15354),
+(@OGUID+136,1621,530,0,0,'0',0,-2143.84,-11457.6,87.26,3.85718,0,0,-0.936671,0.35021,60,255,1,'',23420),
+(@OGUID+137,1621,530,0,0,'0',0,-2134.52,-11653.9,44.1797,4.03171,0,0,-0.902585,0.430512,60,255,1,'',15595),
+(@OGUID+138,1621,530,0,0,'0',0,-2112.67,-12285.4,30.9981,1.74533,0,0,0.766044,0.642789,60,255,1,'',15595),
+(@OGUID+139,1621,530,0,0,'0',0,-2033.11,-11142.6,56.1243,2.42601,0,0,0.936672,0.350207,60,255,1,'',15354),
+(@OGUID+140,1621,530,0,0,'0',0,-1973.46,-11027.4,58.6742,5.53269,0,0,-0.366501,0.930418,60,255,1,'',23420),
+(@OGUID+141,1621,530,0,0,'0',0,-1949.91,-11079.7,56.546,3.49067,0,0,-0.984807,0.173652,60,255,1,'',15595),
+(@OGUID+142,1621,530,0,0,'0',0,-1926.83,-11346.8,64.5465,5.09636,0,0,-0.559193,0.829038,60,255,1,'',15595),
+(@OGUID+143,1621,530,0,0,'0',0,-1843.93,-11711.4,31.9192,2.70526,0,0,0.976295,0.216442,60,255,1,'',23420),
+(@OGUID+144,1621,530,0,0,'0',0,-1693.39,-11172.4,68.5771,2.47837,0,0,0.945518,0.325568,60,255,1,'',15595),
+(@OGUID+145,1621,530,0,0,'0',0,-1684.44,-11452.1,43.7865,5.67232,0,0,-0.300706,0.953717,60,255,1,'',15595),
+(@OGUID+146,1621,530,0,0,'0',0,-1505.58,-11580.7,25.8857,5.63741,0,0,-0.317305,0.948324,60,255,1,'',15595),
+(@OGUID+147,1621,530,0,0,'0',0,-1447.91,-12032.9,7.49894,5.58505,0,0,-0.34202,0.939693,60,255,1,'',23420),
+(@OGUID+148,1621,530,0,0,'0',0,-1370.06,-11938.5,15.5451,5.02655,0,0,-0.587785,0.809017,60,255,1,'',15354),
+(@OGUID+149,1621,530,0,0,'0',0,-1229.22,-11825.7,6.8922,1.37881,0,0,0.636078,0.771625,60,255,1,'',15595),
+-- Bruiseweed
+(@OGUID+150,1622,530,0,0,'0',0,-2039.25,-11229.8,84.0067,5.93412,0,0,-0.173648,0.984808,60,255,1,'',23420),
+(@OGUID+151,1622,530,0,0,'0',0,-2007.29,-11378.3,73.2018,6.21337,0,0,-0.0348988,0.999391,60,255,1,'',15595),
+(@OGUID+152,1622,530,0,0,'0',0,-1931.04,-10733.1,111.037,5.02655,0,0,-0.587785,0.809017,60,255,1,'',15595),
+(@OGUID+153,1622,530,0,0,'0',0,-1885.2,-10524.8,176.968,1.01229,0,0,0.484809,0.87462,60,255,1,'',15354),
+(@OGUID+154,1622,530,0,0,'0',0,-1842.84,-10634.3,149.047,4.92183,0,0,-0.62932,0.777146,60,255,1,'',23420),
+(@OGUID+155,1622,530,0,0,'0',0,-1698.02,-10664.9,103.709,4.04917,0,0,-0.898793,0.438373,60,255,1,'',15595),
+(@OGUID+156,1622,530,0,0,'0',0,-1581.32,-10789.3,56.3988,0.942477,0,0,0.45399,0.891007,60,255,1,'',23420),
+(@OGUID+157,1622,530,0,0,'0',0,-1497.94,-10674.3,135.758,2.9845,0,0,0.996917,0.0784664,60,255,1,'',15595),
+(@OGUID+158,1622,530,0,0,'0',0,-1424.98,-11463.1,73.9774,0.383971,0,0,0.190808,0.981627,60,255,1,'',15595),
+(@OGUID+159,1622,530,0,0,'0',0,-1387.71,-11420.9,75.5893,6.16101,0,0,-0.0610485,0.998135,60,255,1,'',15595),
+(@OGUID+160,1622,530,0,0,'0',0,-1387.68,-10678.7,86.0905,4.45059,0,0,-0.793353,0.608762,60,255,1,'',23420),
+(@OGUID+161,1622,530,0,0,'0',0,-1152.73,-12380.7,30.9022,0.733038,0,0,0.358368,0.93358,60,255,1,'',15595),
+(@OGUID+162,1622,530,0,0,'0',0,-1028.4,-12564.1,13.9575,2.80997,0,0,0.986285,0.16505,60,255,1,'',23420),
+-- Stranglekelp
+(@OGUID+163,2045,530,0,0,'0',0,-2906,-11578.5,-13.3495,0.855211,0,0,0.414693,0.909961,60,255,1,'',15595),
+(@OGUID+164,2045,530,0,0,'0',0,-2862.34,-11784.7,-16.0519,2.96704,0,0,0.996194,0.087165,60,255,1,'',15595),
+(@OGUID+165,2045,530,0,0,'0',0,-2060.9,-12521.1,-1.65293,6.05629,0,0,-0.113203,0.993572,60,255,1,'',15354),
+(@OGUID+166,2045,530,0,0,'0',0,-1904.71,-12292,-1.84962,4.57276,0,0,-0.754709,0.656059,60,255,1,'',15354),
+(@OGUID+167,2045,530,0,0,'0',0,-1821.05,-12355.2,-16.1252,3.63029,0,0,-0.970295,0.241925,60,255,1,'',23420),
+(@OGUID+168,2045,530,0,0,'0',0,-1623.93,-12289.5,-16.1185,0.663223,0,0,0.325567,0.945519,60,255,1,'',23420),
+(@OGUID+169,2045,530,0,0,'0',0,-1554.45,-12652.5,-16.1372,6.24828,0,0,-0.0174522,0.999848,60,255,1,'',15595),
+(@OGUID+170,2045,530,0,0,'0',0,-1299.91,-12736.6,-24.296,2.82743,0,0,0.987688,0.156436,60,255,1,'',15595),
+(@OGUID+171,2045,530,0,0,'0',0,-1282.99,-11119.6,-16.0728,4.11898,0,0,-0.882947,0.469473,60,255,1,'',15354),
+(@OGUID+172,2045,530,0,0,'0',0,-1207.55,-11273.7,-16.1352,2.77507,0,0,0.983254,0.182238,60,255,1,'',15354),
+(@OGUID+173,2045,530,0,0,'0',0,-1181.31,-11474.7,-2.33605,3.82227,0,0,-0.942641,0.333808,60,255,1,'',15354),
+(@OGUID+174,2045,530,0,0,'0',0,-1168.65,-11336.7,-16.1209,6.26573,0,0,-0.00872612,0.999962,60,255,1,'',23420),
+(@OGUID+175,2045,530,0,0,'0',0,-1157.55,-11582.9,-15.3173,2.05949,0,0,0.857167,0.515038,60,255,1,'',15595),
+(@OGUID+176,2045,530,0,0,'0',0,-1146.56,-11405.5,-7.91089,0.837757,0,0,0.406736,0.913546,60,255,1,'',15595),
+(@OGUID+177,2045,530,0,0,'0',0,-1125.42,-11326.9,-17.4314,3.57793,0,0,-0.976295,0.216442,60,255,1,'',15595),
+(@OGUID+178,2045,530,0,0,'0',0,-1090.76,-11142.6,-79.9655,1.48353,0,0,0.67559,0.737278,60,255,1,'',23420),
+(@OGUID+179,2045,530,0,0,'0',0,-899.027,-12720.1,-16.0832,0.575957,0,0,0.284015,0.95882,60,255,1,'',15595),
+
+
+-- Copper Vein
+(@OGUID+180,1731,530,0,0,'0',0,-2685.47,-11424.9,20.4827,2.79252,0,0,0.984807,0.173652,60,255,1,'',15595),
+(@OGUID+181,1731,530,0,0,'0',0,-2643.85,-11896,10.2886,1.43117,0,0,0.656058,0.75471,60,255,1,'',15595),
+(@OGUID+182,1731,530,0,0,'0',0,-2623.13,-11772.2,9.2479,2.60054,0,0,0.96363,0.267241,60,255,1,'',15595),
+(@OGUID+183,1731,530,0,0,'0',0,-2614.69,-12192.1,28.0703,5.67232,0,0,-0.300706,0.953717,60,255,1,'',15595),
+(@OGUID+184,1731,530,0,0,'0',0,-2594.86,-11575.2,25.9237,3.57793,0,0,-0.976295,0.216442,60,255,1,'',15354),
+(@OGUID+185,1731,530,0,0,'0',0,-2576.53,-11217.2,21.185,5.2709,0,0,-0.484809,0.87462,60,255,1,'',15595),
+(@OGUID+186,1731,530,0,0,'0',0,-2545.76,-11210.7,19.4963,3.07177,0,0,0.999391,0.0349061,60,255,1,'',15595),
+(@OGUID+187,1731,530,0,0,'0',0,-2542.84,-11916.8,22.3775,3.49067,0,0,-0.984807,0.173652,60,255,1,'',15595),
+(@OGUID+188,1731,530,0,0,'0',0,-2541.53,-11418.4,42.6807,1.29154,0,0,0.601814,0.798636,60,255,1,'',15354),
+(@OGUID+189,1731,530,0,0,'0',0,-2471.95,-12317.5,17.2924,-1.53589,0,0,-0.694658,0.71934,60,255,1,'',10505),
+(@OGUID+190,1731,530,0,0,'0',0,-2418.98,-12138.9,34.5263,2.72271,0,0,0.978148,0.207912,60,255,1,'',15595),
+(@OGUID+191,1731,530,0,0,'0',0,-2411.3,-11965,13.399,0.90757,0,0,0.438371,0.898794,60,255,1,'',23420),
+(@OGUID+192,1731,530,0,0,'0',0,-2289.64,-12051.1,28.0396,5.79449,0,0,-0.241921,0.970296,60,255,1,'',15595),
+(@OGUID+193,1731,530,0,0,'0',0,-2265.47,-11780.8,22.0951,0.925024,0,0,0.446198,0.894935,60,255,1,'',15595),
+(@OGUID+194,1731,530,0,0,'0',0,-2173.48,-12289.1,54.1866,5.2709,0,0,-0.484809,0.87462,60,255,1,'',15595),
+(@OGUID+195,1731,530,0,0,'0',0,-2152.71,-11646.9,51.2173,3.3685,0,0,-0.993571,0.113208,60,255,1,'',15595),
+(@OGUID+196,1731,530,0,0,'0',0,-2140.47,-12364.4,28.3548,6.10865,0,0,-0.0871553,0.996195,60,255,1,'',15050),
+(@OGUID+197,1731,530,0,0,'0',0,-2112.99,-10905.2,70.771,2.49582,0,0,0.948323,0.317306,60,255,1,'',15595),
+(@OGUID+198,1731,530,0,0,'0',0,-2109.84,-10869.6,73.4465,3.00195,0,0,0.997563,0.0697661,60,255,1,'',15595),
+(@OGUID+199,1731,530,0,0,'0',0,-2072.26,-11040.2,62.8454,0.279252,0,0,0.139173,0.990268,60,255,1,'',15595),
+(@OGUID+200,1731,530,0,0,'0',0,-2053.76,-11059.8,61.5851,4.93928,0,0,-0.622514,0.782609,60,255,1,'',15595),
+(@OGUID+201,1731,530,0,0,'0',0,-2048.96,-11240.9,80.2398,4.76475,0,0,-0.688354,0.725374,60,255,1,'',15595),
+(@OGUID+202,1731,530,0,0,'0',0,-2027.21,-10754.8,93.7322,0.890117,0,0,0.430511,0.902586,60,255,1,'',15595),
+(@OGUID+203,1731,530,0,0,'0',0,-1994.36,-10557,179.827,3.26377,0,0,-0.998135,0.0610518,60,255,1,'',23420),
+(@OGUID+204,1731,530,0,0,'0',0,-1985.4,-12204.8,20.8141,2.1293,0,0,0.874619,0.48481,60,255,1,'',23420),
+(@OGUID+205,1731,530,0,0,'0',0,-1964.12,-11013.6,61.4401,3.38594,0,0,-0.992546,0.12187,60,255,1,'',15595),
+(@OGUID+206,1731,530,0,0,'0',0,-1913.38,-11289.2,67.8717,2.21657,0,0,0.894934,0.446199,60,255,1,'',15354),
+(@OGUID+207,1731,530,0,0,'0',0,-1909.89,-11218.6,60.7134,5.11382,0,0,-0.551936,0.833886,60,255,1,'',23420),
+(@OGUID+208,1731,530,0,0,'0',0,-1900.81,-11665.8,42.0966,2.09439,0,0,0.866025,0.500001,60,255,1,'',15595),
+(@OGUID+209,1731,530,0,0,'0',0,-1898.74,-11405.3,59.9944,3.99681,0,0,-0.909961,0.414694,60,255,1,'',15595),
+(@OGUID+210,1731,530,0,0,'0',0,-1896.27,-10573.2,180.814,4.03171,0,0,-0.902585,0.430512,60,255,1,'',15595),
+(@OGUID+211,1731,530,0,0,'0',0,-1885.38,-12097.3,27.475,3.31614,0,0,-0.996194,0.087165,60,255,1,'',15595),
+(@OGUID+212,1731,530,0,0,'0',0,-1876.94,-11380.1,56.0344,0.104719,0,0,0.0523357,0.99863,60,255,1,'',15595),
+(@OGUID+213,1731,530,0,0,'0',0,-1843.67,-10657.3,146.69,4.79966,0,0,-0.67559,0.737278,60,255,1,'',15354),
+(@OGUID+214,1731,530,0,0,'0',0,-1841.7,-11053.8,68.1118,4.90438,0,0,-0.636078,0.771625,60,255,1,'',15595),
+(@OGUID+215,1731,530,0,0,'0',0,-1815.01,-12126,36.3084,3.76991,0,0,-0.951056,0.309017,60,255,1,'',15595),
+(@OGUID+216,1731,530,0,0,'0',0,-1777.46,-11511.6,47.7927,5.13127,0,0,-0.544639,0.838671,60,255,1,'',15595),
+(@OGUID+217,1731,530,0,0,'0',0,-1754,-11459.6,46.4546,1.71042,0,0,0.754709,0.656059,60,255,1,'',15595),
+(@OGUID+218,1731,530,0,0,'0',0,-1726.25,-11707.7,40.3382,2.72271,0,0,0.978148,0.207912,60,255,1,'',15595),
+(@OGUID+219,1731,530,0,0,'0',0,-1704.56,-12053.3,15.6751,5.14872,0,0,-0.537299,0.843392,60,255,1,'',15354),
+(@OGUID+220,1731,530,0,0,'0',0,-1694.13,-10809.1,64.4304,5.60251,0,0,-0.333807,0.942641,60,255,1,'',15595),
+(@OGUID+221,1731,530,0,0,'0',0,-1659.19,-11741.2,37.2818,5.44543,0,0,-0.406736,0.913546,60,255,1,'',15595),
+(@OGUID+222,1731,530,0,0,'0',0,-1631.7,-11081.6,70.732,5.23599,0,0,-0.5,0.866025,60,255,1,'',15595),
+(@OGUID+223,1731,530,0,0,'0',0,-1565.04,-11195.2,67.5026,5.98648,0,0,-0.147809,0.989016,60,255,1,'',15595),
+(@OGUID+224,1731,530,0,0,'0',0,-1517.39,-11126.4,81.4214,1.02974,0,0,0.492423,0.870356,60,255,1,'',15595),
+(@OGUID+225,1731,530,0,0,'0',0,-1515.29,-11244.3,69.3824,0.209439,0,0,0.104528,0.994522,60,255,1,'',15595),
+(@OGUID+226,1731,530,0,0,'0',0,-1499.51,-11709,36.9778,0,0,0,0,1,60,255,1,'',15595),
+(@OGUID+227,1731,530,0,0,'0',0,-1494.69,-10635.2,136.429,0.383971,0,0,0.190808,0.981627,60,255,1,'',15595),
+(@OGUID+228,1731,530,0,0,'0',0,-1458.79,-11546.4,36.1454,0.802851,0,0,0.390731,0.920505,60,255,1,'',15354),
+(@OGUID+229,1731,530,0,0,'0',0,-1410.65,-10725,82.9872,1.90241,0,0,0.814116,0.580703,60,255,1,'',15595),
+(@OGUID+230,1731,530,0,0,'0',0,-1338.76,-11608.5,10.1375,4.7822,0,0,-0.681998,0.731354,60,255,1,'',15595),
+(@OGUID+231,1731,530,0,0,'0',0,-1283.94,-12504.9,55.863,4.57276,0,0,-0.754709,0.656059,60,255,1,'',15595),
+(@OGUID+232,1731,530,0,0,'0',0,-1194.38,-12082,5.91151,2.54818,0,0,0.956305,0.292372,60,255,1,'',15595),
+-- Tin Vein
+(@OGUID+233,1732,530,0,0,'0',0,-2158.18,-10677.6,50.2055,3.63029,0,0,-0.970295,0.241925,60,255,1,'',15595),
+(@OGUID+234,1732,530,0,0,'0',0,-2002.94,-11337.5,63.3471,0.802851,0,0,0.390731,0.920505,60,255,1,'',15595),
+(@OGUID+235,1732,530,0,0,'0',0,-1988.84,-10829.3,72.2179,5.74214,0,0,-0.267238,0.963631,60,255,1,'',15595),
+(@OGUID+236,1732,530,0,0,'0',0,-1981.27,-10713.2,120.864,3.82227,0,0,-0.942641,0.333808,60,255,1,'',15595),
+(@OGUID+237,1732,530,0,0,'0',0,-1797.96,-10603.9,151.031,3.05433,0,0,0.999048,0.0436193,60,255,1,'',15354),
+(@OGUID+238,1732,530,0,0,'0',0,-1757.56,-12110.3,35.5177,1.69297,0,0,0.748956,0.66262,60,255,1,'',15595),
+(@OGUID+239,1732,530,0,0,'0',0,-1598.21,-10706.3,136.368,1.3439,0,0,0.622514,0.782609,60,255,1,'',15595),
+(@OGUID+240,1732,530,0,0,'0',0,-1539.4,-10827.8,68.0123,5.79449,0,0,-0.241921,0.970296,60,255,1,'',23420),
+(@OGUID+241,1732,530,0,0,'0',0,-1459.68,-11478.7,71.9725,3.07177,0,0,0.999391,0.0349061,60,255,1,'',23420),
+(@OGUID+242,1732,530,0,0,'0',0,-1376.32,-11351,28.0821,1.50098,0,0,0.681998,0.731354,60,255,1,'',15595),
+(@OGUID+243,1732,530,0,0,'0',0,-1314.52,-11749.6,9.20331,1.41372,0,0,0.649447,0.760406,60,255,1,'',15595),
+(@OGUID+244,1732,530,0,0,'0',0,-1241.19,-11653.1,7.98605,4.34587,0,0,-0.824126,0.566406,60,255,1,'',15595),
+(@OGUID+245,1732,530,0,0,'0',0,-1201.69,-12492.1,96.6035,6.02139,0,0,-0.130526,0.991445,60,255,1,'',15595),
+(@OGUID+246,1732,530,0,0,'0',0,-1200.17,-12420.5,96.7011,0.698131,0,0,0.34202,0.939693,60,255,1,'',15354),
+(@OGUID+247,1732,530,0,0,'0',0,-1051.83,-12545.4,19.4085,2.32129,0,0,0.91706,0.39875,60,255,1,'',15595),
+-- Silver Vein
+(@OGUID+248,1733,530,0,0,'0',0,-2158.18,-10677.6,50.2055,3.63029,0,0,-0.970295,0.241925,60,255,1,'',15595),
+(@OGUID+249,1733,530,0,0,'0',0,-2002.94,-11337.5,63.3471,0.802851,0,0,0.390731,0.920505,60,255,1,'',15595),
+(@OGUID+250,1733,530,0,0,'0',0,-1988.84,-10829.3,72.2179,5.74214,0,0,-0.267238,0.963631,60,255,1,'',15595),
+(@OGUID+251,1733,530,0,0,'0',0,-1981.27,-10713.2,120.864,3.82227,0,0,-0.942641,0.333808,60,255,1,'',15595),
+(@OGUID+252,1733,530,0,0,'0',0,-1797.96,-10603.9,151.031,3.05433,0,0,0.999048,0.0436193,60,255,1,'',15354),
+(@OGUID+253,1733,530,0,0,'0',0,-1757.56,-12110.3,35.5177,1.69297,0,0,0.748956,0.66262,60,255,1,'',15595),
+(@OGUID+254,1733,530,0,0,'0',0,-1598.21,-10706.3,136.368,1.3439,0,0,0.622514,0.782609,60,255,1,'',15595),
+(@OGUID+255,1733,530,0,0,'0',0,-1539.4,-10827.8,68.0123,5.79449,0,0,-0.241921,0.970296,60,255,1,'',23420),
+(@OGUID+256,1733,530,0,0,'0',0,-1459.68,-11478.7,71.9725,3.07177,0,0,0.999391,0.0349061,60,255,1,'',23420),
+(@OGUID+257,1733,530,0,0,'0',0,-1376.32,-11351,28.0821,1.50098,0,0,0.681998,0.731354,60,255,1,'',15595),
+(@OGUID+258,1733,530,0,0,'0',0,-1314.52,-11749.6,9.20331,1.41372,0,0,0.649447,0.760406,60,255,1,'',15595),
+(@OGUID+259,1733,530,0,0,'0',0,-1241.19,-11653.1,7.98605,4.34587,0,0,-0.824126,0.566406,60,255,1,'',15595),
+(@OGUID+260,1733,530,0,0,'0',0,-1201.69,-12492.1,96.6035,6.02139,0,0,-0.130526,0.991445,60,255,1,'',15595),
+(@OGUID+261,1733,530,0,0,'0',0,-1200.17,-12420.5,96.7011,0.698131,0,0,0.34202,0.939693,60,255,1,'',15354),
+(@OGUID+262,1733,530,0,0,'0',0,-1051.83,-12545.4,19.4085,2.32129,0,0,0.91706,0.39875,60,255,1,'',15595);
+
+DELETE FROM `pool_template` WHERE `entry` BETWEEN @POOL+000 AND @POOL+016;
+INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
+(@POOL+000, 40, "Bloodmyst Isle - Herbs"),
+(@POOL+001, 30, "Bloodmyst Isle - Veins"),
+(@POOL+002, 1, "Bloodmyst Isle - Tin Vein / Silver Vein"),
+(@POOL+003, 1, "Bloodmyst Isle - Tin Vein / Silver Vein"),
+(@POOL+004, 1, "Bloodmyst Isle - Tin Vein / Silver Vein"),
+(@POOL+005, 1, "Bloodmyst Isle - Tin Vein / Silver Vein"),
+(@POOL+006, 1, "Bloodmyst Isle - Tin Vein / Silver Vein"),
+(@POOL+007, 1, "Bloodmyst Isle - Tin Vein / Silver Vein"),
+(@POOL+008, 1, "Bloodmyst Isle - Tin Vein / Silver Vein"),
+(@POOL+009, 1, "Bloodmyst Isle - Tin Vein / Silver Vein"),
+(@POOL+010, 1, "Bloodmyst Isle - Tin Vein / Silver Vein"),
+(@POOL+011, 1, "Bloodmyst Isle - Tin Vein / Silver Vein"),
+(@POOL+012, 1, "Bloodmyst Isle - Tin Vein / Silver Vein"),
+(@POOL+013, 1, "Bloodmyst Isle - Tin Vein / Silver Vein"),
+(@POOL+014, 1, "Bloodmyst Isle - Tin Vein / Silver Vein"),
+(@POOL+015, 1, "Bloodmyst Isle - Tin Vein / Silver Vein"),
+(@POOL+016, 1, "Bloodmyst Isle - Tin Vein / Silver Vein");
+
+DELETE FROM `pool_members` WHERE `type` IN (1,2) AND `poolSpawnId` BETWEEN @POOL+000 AND @POOL+016;
+INSERT INTO `pool_members` (`type`, `spawnId`, `poolSpawnId`, `chance`, `description`) VALUES
+(1, @OGUID+000, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+001, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+002, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+003, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+004, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+005, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+006, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+007, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+008, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+009, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+010, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+011, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+012, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+013, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+014, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+015, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+016, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+017, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+018, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+019, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+020, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+021, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+022, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+023, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+024, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+025, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+026, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+027, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+028, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+029, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+030, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+031, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+032, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+033, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+034, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+035, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+036, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+037, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+038, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+039, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+040, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+041, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+042, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+043, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+044, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+(1, @OGUID+045, @POOL+000, 0, "Bloodmyst Isle - Silverleaf"),
+
+(1, @OGUID+046, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+047, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+048, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+049, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+050, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+051, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+052, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+053, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+054, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+055, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+056, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+057, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+058, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+059, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+060, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+061, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+062, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+063, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+064, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+065, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+066, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+067, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+068, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+069, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+070, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+071, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+072, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+073, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+074, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+075, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+076, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+077, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+078, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+(1, @OGUID+079, @POOL+000, 0, "Bloodmyst Isle - Peacebloom"),
+
+(1, @OGUID+080, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+081, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+082, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+083, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+084, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+085, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+086, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+087, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+088, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+089, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+090, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+091, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+092, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+093, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+094, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+095, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+096, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+097, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+098, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+099, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+100, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+101, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+102, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+103, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+(1, @OGUID+104, @POOL+000, 0, "Bloodmyst Isle - Earthroot"),
+
+(1, @OGUID+105, @POOL+000, 0, "Bloodmyst Isle - Mageroyal"),
+(1, @OGUID+106, @POOL+000, 0, "Bloodmyst Isle - Mageroyal"),
+(1, @OGUID+107, @POOL+000, 0, "Bloodmyst Isle - Mageroyal"),
+(1, @OGUID+108, @POOL+000, 0, "Bloodmyst Isle - Mageroyal"),
+(1, @OGUID+109, @POOL+000, 0, "Bloodmyst Isle - Mageroyal"),
+(1, @OGUID+110, @POOL+000, 0, "Bloodmyst Isle - Mageroyal"),
+(1, @OGUID+111, @POOL+000, 0, "Bloodmyst Isle - Mageroyal"),
+(1, @OGUID+112, @POOL+000, 0, "Bloodmyst Isle - Mageroyal"),
+(1, @OGUID+113, @POOL+000, 0, "Bloodmyst Isle - Mageroyal"),
+(1, @OGUID+114, @POOL+000, 0, "Bloodmyst Isle - Mageroyal"),
+(1, @OGUID+115, @POOL+000, 0, "Bloodmyst Isle - Mageroyal"),
+(1, @OGUID+116, @POOL+000, 0, "Bloodmyst Isle - Mageroyal"),
+(1, @OGUID+117, @POOL+000, 0, "Bloodmyst Isle - Mageroyal"),
+(1, @OGUID+118, @POOL+000, 0, "Bloodmyst Isle - Mageroyal"),
+(1, @OGUID+119, @POOL+000, 0, "Bloodmyst Isle - Mageroyal"),
+(1, @OGUID+120, @POOL+000, 0, "Bloodmyst Isle - Mageroyal"),
+(1, @OGUID+121, @POOL+000, 0, "Bloodmyst Isle - Mageroyal"),
+(1, @OGUID+122, @POOL+000, 0, "Bloodmyst Isle - Mageroyal"),
+(1, @OGUID+123, @POOL+000, 0, "Bloodmyst Isle - Mageroyal"),
+
+(1, @OGUID+124, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+125, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+126, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+127, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+128, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+129, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+130, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+131, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+132, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+133, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+134, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+135, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+136, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+137, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+138, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+139, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+140, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+141, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+142, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+143, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+144, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+145, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+146, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+147, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+148, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+(1, @OGUID+149, @POOL+000, 0, "Bloodmyst Isle - Briarthorn"),
+
+(1, @OGUID+150, @POOL+000, 0, "Bloodmyst Isle - Bruiseweed"),
+(1, @OGUID+151, @POOL+000, 0, "Bloodmyst Isle - Bruiseweed"),
+(1, @OGUID+152, @POOL+000, 0, "Bloodmyst Isle - Bruiseweed"),
+(1, @OGUID+153, @POOL+000, 0, "Bloodmyst Isle - Bruiseweed"),
+(1, @OGUID+154, @POOL+000, 0, "Bloodmyst Isle - Bruiseweed"),
+(1, @OGUID+155, @POOL+000, 0, "Bloodmyst Isle - Bruiseweed"),
+(1, @OGUID+156, @POOL+000, 0, "Bloodmyst Isle - Bruiseweed"),
+(1, @OGUID+157, @POOL+000, 0, "Bloodmyst Isle - Bruiseweed"),
+(1, @OGUID+158, @POOL+000, 0, "Bloodmyst Isle - Bruiseweed"),
+(1, @OGUID+159, @POOL+000, 0, "Bloodmyst Isle - Bruiseweed"),
+(1, @OGUID+160, @POOL+000, 0, "Bloodmyst Isle - Bruiseweed"),
+(1, @OGUID+161, @POOL+000, 0, "Bloodmyst Isle - Bruiseweed"),
+(1, @OGUID+162, @POOL+000, 0, "Bloodmyst Isle - Bruiseweed"),
+
+(1, @OGUID+163, @POOL+000, 0, "Bloodmyst Isle - Stranglekelp"),
+(1, @OGUID+164, @POOL+000, 0, "Bloodmyst Isle - Stranglekelp"),
+(1, @OGUID+165, @POOL+000, 0, "Bloodmyst Isle - Stranglekelp"),
+(1, @OGUID+166, @POOL+000, 0, "Bloodmyst Isle - Stranglekelp"),
+(1, @OGUID+167, @POOL+000, 0, "Bloodmyst Isle - Stranglekelp"),
+(1, @OGUID+168, @POOL+000, 0, "Bloodmyst Isle - Stranglekelp"),
+(1, @OGUID+169, @POOL+000, 0, "Bloodmyst Isle - Stranglekelp"),
+(1, @OGUID+170, @POOL+000, 0, "Bloodmyst Isle - Stranglekelp"),
+(1, @OGUID+171, @POOL+000, 0, "Bloodmyst Isle - Stranglekelp"),
+(1, @OGUID+172, @POOL+000, 0, "Bloodmyst Isle - Stranglekelp"),
+(1, @OGUID+173, @POOL+000, 0, "Bloodmyst Isle - Stranglekelp"),
+(1, @OGUID+174, @POOL+000, 0, "Bloodmyst Isle - Stranglekelp"),
+(1, @OGUID+175, @POOL+000, 0, "Bloodmyst Isle - Stranglekelp"),
+(1, @OGUID+176, @POOL+000, 0, "Bloodmyst Isle - Stranglekelp"),
+(1, @OGUID+177, @POOL+000, 0, "Bloodmyst Isle - Stranglekelp"),
+(1, @OGUID+178, @POOL+000, 0, "Bloodmyst Isle - Stranglekelp"),
+(1, @OGUID+179, @POOL+000, 0, "Bloodmyst Isle - Stranglekelp"),
+
+(1, @OGUID+180, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+181, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+182, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+183, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+184, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+185, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+186, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+187, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+188, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+189, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+190, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+191, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+192, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+193, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+194, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+195, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+196, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+197, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+198, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+199, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+200, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+201, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+202, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+203, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+204, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+205, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+206, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+207, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+208, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+209, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+210, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+211, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+212, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+213, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+214, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+215, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+216, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+217, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+218, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+219, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+220, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+221, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+222, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+223, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+224, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+225, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+226, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+227, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+228, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+229, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+230, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+231, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+(1, @OGUID+232, @POOL+001, 0, "Bloodmyst Isle - Copper Vein"),
+
+(1, @OGUID+233, @POOL+002, 90, "Bloodmyst Isle - Tin Vein / Silver Vein - Tin Vein"),
+(1, @OGUID+234, @POOL+003, 90, "Bloodmyst Isle - Tin Vein / Silver Vein - Tin Vein"),
+(1, @OGUID+235, @POOL+004, 90, "Bloodmyst Isle - Tin Vein / Silver Vein - Tin Vein"),
+(1, @OGUID+236, @POOL+005, 90, "Bloodmyst Isle - Tin Vein / Silver Vein - Tin Vein"),
+(1, @OGUID+237, @POOL+006, 90, "Bloodmyst Isle - Tin Vein / Silver Vein - Tin Vein"),
+(1, @OGUID+238, @POOL+007, 90, "Bloodmyst Isle - Tin Vein / Silver Vein - Tin Vein"),
+(1, @OGUID+239, @POOL+008, 90, "Bloodmyst Isle - Tin Vein / Silver Vein - Tin Vein"),
+(1, @OGUID+240, @POOL+009, 90, "Bloodmyst Isle - Tin Vein / Silver Vein - Tin Vein"),
+(1, @OGUID+241, @POOL+010, 90, "Bloodmyst Isle - Tin Vein / Silver Vein - Tin Vein"),
+(1, @OGUID+242, @POOL+011, 90, "Bloodmyst Isle - Tin Vein / Silver Vein - Tin Vein"),
+(1, @OGUID+243, @POOL+012, 90, "Bloodmyst Isle - Tin Vein / Silver Vein - Tin Vein"),
+(1, @OGUID+244, @POOL+013, 90, "Bloodmyst Isle - Tin Vein / Silver Vein - Tin Vein"),
+(1, @OGUID+245, @POOL+014, 90, "Bloodmyst Isle - Tin Vein / Silver Vein - Tin Vein"),
+(1, @OGUID+246, @POOL+015, 90, "Bloodmyst Isle - Tin Vein / Silver Vein - Tin Vein"),
+(1, @OGUID+247, @POOL+016, 90, "Bloodmyst Isle - Tin Vein / Silver Vein - Tin Vein"),
+
+(1, @OGUID+248, @POOL+002, 10, "Bloodmyst Isle - Tin Vein / Silver Vein - Silver Vein"),
+(1, @OGUID+249, @POOL+003, 10, "Bloodmyst Isle - Tin Vein / Silver Vein - Silver Vein"),
+(1, @OGUID+250, @POOL+004, 10, "Bloodmyst Isle - Tin Vein / Silver Vein - Silver Vein"),
+(1, @OGUID+251, @POOL+005, 10, "Bloodmyst Isle - Tin Vein / Silver Vein - Silver Vein"),
+(1, @OGUID+252, @POOL+006, 10, "Bloodmyst Isle - Tin Vein / Silver Vein - Silver Vein"),
+(1, @OGUID+253, @POOL+007, 10, "Bloodmyst Isle - Tin Vein / Silver Vein - Silver Vein"),
+(1, @OGUID+254, @POOL+008, 10, "Bloodmyst Isle - Tin Vein / Silver Vein - Silver Vein"),
+(1, @OGUID+255, @POOL+009, 10, "Bloodmyst Isle - Tin Vein / Silver Vein - Silver Vein"),
+(1, @OGUID+256, @POOL+010, 10, "Bloodmyst Isle - Tin Vein / Silver Vein - Silver Vein"),
+(1, @OGUID+257, @POOL+011, 10, "Bloodmyst Isle - Tin Vein / Silver Vein - Silver Vein"),
+(1, @OGUID+258, @POOL+012, 10, "Bloodmyst Isle - Tin Vein / Silver Vein - Silver Vein"),
+(1, @OGUID+259, @POOL+013, 10, "Bloodmyst Isle - Tin Vein / Silver Vein - Silver Vein"),
+(1, @OGUID+260, @POOL+014, 10, "Bloodmyst Isle - Tin Vein / Silver Vein - Silver Vein"),
+(1, @OGUID+261, @POOL+015, 10, "Bloodmyst Isle - Tin Vein / Silver Vein - Silver Vein"),
+(1, @OGUID+262, @POOL+016, 10, "Bloodmyst Isle - Tin Vein / Silver Vein - Silver Vein"),
+
+(2, @POOL+002, @POOL+001, 0, "Bloodmyst Isle - Tin Vein & Silver Vein - Master"),
+(2, @POOL+003, @POOL+001, 0, "Bloodmyst Isle - Tin Vein & Silver Vein - Master"),
+(2, @POOL+004, @POOL+001, 0, "Bloodmyst Isle - Tin Vein & Silver Vein - Master"),
+(2, @POOL+005, @POOL+001, 0, "Bloodmyst Isle - Tin Vein & Silver Vein - Master"),
+(2, @POOL+006, @POOL+001, 0, "Bloodmyst Isle - Tin Vein & Silver Vein - Master"),
+(2, @POOL+007, @POOL+001, 0, "Bloodmyst Isle - Tin Vein & Silver Vein - Master"),
+(2, @POOL+008, @POOL+001, 0, "Bloodmyst Isle - Tin Vein & Silver Vein - Master"),
+(2, @POOL+009, @POOL+001, 0, "Bloodmyst Isle - Tin Vein & Silver Vein - Master"),
+(2, @POOL+010, @POOL+001, 0, "Bloodmyst Isle - Tin Vein & Silver Vein - Master"),
+(2, @POOL+011, @POOL+001, 0, "Bloodmyst Isle - Tin Vein & Silver Vein - Master"),
+(2, @POOL+012, @POOL+001, 0, "Bloodmyst Isle - Tin Vein & Silver Vein - Master"),
+(2, @POOL+013, @POOL+001, 0, "Bloodmyst Isle - Tin Vein & Silver Vein - Master"),
+(2, @POOL+014, @POOL+001, 0, "Bloodmyst Isle - Tin Vein & Silver Vein - Master"),
+(2, @POOL+015, @POOL+001, 0, "Bloodmyst Isle - Tin Vein & Silver Vein - Master"),
+(2, @POOL+016, @POOL+001, 0, "Bloodmyst Isle - Tin Vein & Silver Vein - Master");