ratkosrb
934 lines
94 KiB
SQL
934 lines
94 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`='20220918154102');
|
|
IF v=0 THEN
|
|
INSERT INTO `migrations` VALUES ('20220918154102');
|
|
-- Add your query below.
|
|
|
|
|
|
-- Add Missing Quest Related Gameobjects
|
|
SET @OGUID = 54950;
|
|
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, 140971, 1, -8960.19, -3519.93, 17.8637, 2.04204, 0, 0, 0.85264, 0.522499, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+2, 140971, 1, -8051.12, -2983.68, 53.5337, 4.24115, 0, 0, -0.85264, 0.522499, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+3, 37099, 109, -590.275, 53.4409, -69.3528, 3.76991, 0, 0, -0.951056, 0.309017, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+4, 37099, 109, -534.249, 99.083, -148.744, 2.23402, 0, 0, 0.898793, 0.438373, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+5, 37099, 109, -503.777, 150.692, -148.744, 4.34587, 0, 0, -0.824126, 0.566406, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+6, 375, 0, 2304.09, 1477.7, 33.4333, 1.8675, 0, 0, 0.803857, 0.594823, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+7, 375, 0, 2331.66, 1451.8, 33.4333, 5.14872, 0, 0, -0.537299, 0.843392, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+8, 375, 0, 2338.48, 1446.01, 33.4333, 4.01426, 0, 0, -0.906307, 0.422619, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+9, 375, 0, 2350.65, 1405.2, 33.3189, 0.209439, 0, 0, 0.104528, 0.994522, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+10, 375, 0, 2360.94, 1400.59, 33.1768, 1.58825, 0, 0, 0.71325, 0.70091, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+11, 175334, 229, -121.016, -419.94, -18.935, 5.42797, 0, 0, -0.414693, 0.909961, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+12, 175334, 229, -77.3365, -403.739, -18.935, 5.25344, 0, 0, -0.492423, 0.870356, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+13, 175334, 229, -71.1755, -460.103, -18.935, 2.11185, 0, 0, 0.870356, 0.492424, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+14, 175334, 229, -28.901, -433.178, -18.935, 1.95477, 0, 0, 0.829038, 0.559193, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+15, 175334, 229, -8.94373, -462.763, -18.6443, 3.12412, 0, 0, 0.999962, 0.00873464, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+16, 175334, 229, 35.3153, -518.408, -18.6015, 3.45576, 0, 0, -0.987688, 0.156436, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+17, 175334, 229, 36.3325, -445.572, -18.7313, 2.65289, 0, 0, 0.970295, 0.241925, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+18, 2087, 0, -14612.1, 334.378, 2.46723, 4.5204, 0, 0, -0.771625, 0.636078, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+19, 176753, 0, 2534.43, 525.187, 16.6412, 2.32129, 0, 0, 0.91706, 0.39875, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+20, 176753, 0, 2538.27, 555.509, 16.0011, 2.26893, 0, 0, 0.906307, 0.422619, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+21, 176753, 0, 2549.78, 523.822, 15.3514, 3.7001, 0, 0, -0.961261, 0.27564, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+22, 176753, 0, 2566.46, 539.654, 15.6006, 5.68977, 0, 0, -0.292372, 0.956305, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+23, 176753, 0, 2567.25, 562.777, 14.0358, 0.418879, 0, 0, 0.207911, 0.978148, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+24, 176753, 0, 2571.08, 521.522, 14.5084, 5.00909, 0, 0, -0.594823, 0.803857, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+25, 176753, 0, 2574.08, 398.103, 33.1812, 3.12412, 0, 0, 0.999962, 0.00873464, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+26, 176753, 0, 2579.67, 417.986, 32.7585, 0.942477, 0, 0, 0.45399, 0.891007, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+27, 176753, 0, 2584.16, 406.246, 34.2144, 5.41052, 0, 0, -0.422618, 0.906308, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+28, 176753, 0, 2587.31, 534.87, 14.7259, 5.86431, 0, 0, -0.207911, 0.978148, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+29, 176753, 0, 2591.56, 508.857, 21.1091, 0.680677, 0, 0, 0.333806, 0.942642, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+30, 176753, 0, 2596.32, 396.81, 35.748, 2.91469, 0, 0, 0.993571, 0.113208, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+31, 176753, 0, 2597.35, 529.111, 16.1089, 0.122173, 0, 0, 0.0610485, 0.998135, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+32, 176753, 0, 2606.75, 485.595, 22.2602, 5.88176, 0, 0, -0.199368, 0.979925, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+33, 176753, 0, 2616.82, 507.319, 18.9587, 3.83973, 0, 0, -0.939692, 0.34202, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+34, 176753, 0, 2620.75, 523.178, 19.8624, 2.89725, 0, 0, 0.992546, 0.12187, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+35, 176753, 0, 2633.08, 518.507, 18.415, 5.49779, 0, 0, -0.382683, 0.92388, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+36, 176753, 0, 2635.63, 503.067, 16.7584, 0.104719, 0, 0, 0.0523357, 0.99863, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+37, 176753, 0, 2661.83, 553.988, 15.7135, 4.85202, 0, 0, -0.656058, 0.75471, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+38, 176753, 0, 2666.21, 510.634, 13.6812, 0.191985, 0, 0, 0.0958452, 0.995396, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+39, 176753, 0, 2669.85, 500.801, 14.9761, 0.0174525, 0, 0, 0.00872612, 0.999962, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+40, 176753, 0, 2670.74, 545.28, 14.0465, 1.13446, 0, 0, 0.537299, 0.843392, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+41, 176753, 0, 2677.42, 395.308, 26.8201, 4.79966, 0, 0, -0.67559, 0.737278, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+42, 175566, 0, 2025.03, 881.479, 34.3452, 3.42085, 0, 0, -0.990268, 0.139175, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+43, 175566, 0, 2056.82, 702.233, 40.8026, 3.61284, 0, 0, -0.972369, 0.233448, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+44, 175566, 0, 2061.49, 737.939, 37.4144, 5.39307, 0, 0, -0.430511, 0.902586, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+45, 175566, 0, 2068.2, 778.964, 37.0121, 3.05433, 0, 0, 0.999048, 0.0436193, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+46, 175566, 0, 2071.39, 598.644, 34.1636, 6.12611, 0, 0, -0.0784588, 0.996917, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+47, 175566, 0, 2089.86, 930.135, 37.6736, 3.29869, 0, 0, -0.996917, 0.0784664, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+48, 175566, 0, 2100.14, 476.564, 60.7574, 1.41372, 0, 0, 0.649447, 0.760406, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+49, 175566, 0, 2108.76, 613.144, 35.0265, 4.88692, 0, 0, -0.642787, 0.766045, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+50, 175566, 0, 2110.01, 1025.17, 32.7202, 2.51327, 0, 0, 0.951056, 0.309017, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+51, 175566, 0, 2145.43, 985.034, 30.369, 3.68265, 0, 0, -0.96363, 0.267241, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+52, 175566, 0, 2147.61, 1179.32, 43.0177, 0.90757, 0, 0, 0.438371, 0.898794, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+53, 175566, 0, 2156.37, 1114.61, 35.3472, 2.60054, 0, 0, 0.96363, 0.267241, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+54, 175566, 0, 2170.57, 480.299, 66.9702, 1.67551, 0, 0, 0.743144, 0.669131, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+55, 175566, 0, 2174.56, 589.332, 43.559, 2.02458, 0, 0, 0.848047, 0.529921, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+56, 175566, 0, 2193.01, 652.462, 32.8342, 0.471238, 0, 0, 0.233445, 0.97237, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+57, 175566, 0, 2194.7, 1155.29, 33.7973, 1.18682, 0, 0, 0.559193, 0.829038, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+58, 175566, 0, 2204.13, 1120.06, 34.8163, 4.01426, 0, 0, -0.906307, 0.422619, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+59, 175566, 0, 2215.82, 763.169, 35.9284, 2.11185, 0, 0, 0.870356, 0.492424, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+60, 175566, 0, 2216.82, 699.65, 35.4347, 1.06465, 0, 0, 0.507538, 0.861629, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+61, 175566, 0, 2222.67, 1082.27, 31.9708, 5.84685, 0, 0, -0.216439, 0.976296, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+62, 175566, 0, 2234.12, 565.686, 33.5866, 3.31614, 0, 0, -0.996194, 0.087165, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+63, 175566, 0, 2236.18, 1132.24, 35.7463, 3.42085, 0, 0, -0.990268, 0.139175, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+64, 175566, 0, 2242.29, 676.938, 37.7281, 0.994837, 0, 0, 0.477159, 0.878817, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+65, 175566, 0, 2262.6, 1097.4, 33.4581, 0.925024, 0, 0, 0.446198, 0.894935, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+66, 175566, 0, 2296.36, 575.073, 33.1947, 5.58505, 0, 0, -0.34202, 0.939693, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+67, 175566, 0, 2306.28, 494.127, 35.7492, 5.49779, 0, 0, -0.382683, 0.92388, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+68, 175566, 0, 2321.08, 967.793, 57.685, 2.04204, 0, 0, 0.85264, 0.522499, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+69, 175566, 0, 2323.93, 607.756, 33.0141, 4.86947, 0, 0, -0.649447, 0.760406, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+70, 175566, 0, 2345, 1134.46, 40.815, 2.21657, 0, 0, 0.894934, 0.446199, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+71, 2743, 0, -6269.86, -2948.81, 222.229, 4.90438, 0, 0, -0.636078, 0.771625, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+72, 2743, 0, -6205.72, -3033.94, 219.777, 5.81195, 0, 0, -0.233445, 0.97237, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+73, 2743, 0, -6189.68, -3063.99, 219.376, 4.59022, 0, 0, -0.748956, 0.66262, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+74, 2743, 0, -6187.48, -2906.25, 214.346, 2.1293, 0, 0, 0.874619, 0.48481, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+75, 2910, 1, -1813.99, -258.482, -9.40541, 0.0174525, 0, 0, 0.00872612, 0.999962, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+76, 3240, 1, -1521.45, -5293.96, 7.16192, 1.69297, 0, 0, 0.748956, 0.66262, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+77, 3240, 1, -1327.68, -5497.04, 5.53991, 1.93731, 0, 0, 0.824125, 0.566408, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+78, 3240, 1, -1255.07, -5582.06, 7.63737, 4.62512, 0, 0, -0.737277, 0.675591, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+79, 3240, 1, -1034.59, -5516.6, 8.34008, 4.39823, 0, 0, -0.809016, 0.587786, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+80, 3240, 1, -817.123, -5594.52, 4.14982, 0, 0, 0, 0, 1, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+81, 3240, 1, -695.059, -5676.29, 6.18738, 0.663223, 0, 0, 0.325567, 0.945519, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+82, 3240, 1, -695.051, -5608.49, 27.4265, 4.41568, 0, 0, -0.803857, 0.594823, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+83, 3240, 1, -653.769, -5548.13, 3.9396, 3.29869, 0, 0, -0.996917, 0.0784664, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+84, 3290, 1, 619.143, -4575.81, 6.97232, 3.49067, 0, 0, -0.984807, 0.173652, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+85, 3290, 1, 631.613, -4464.76, 14.2747, 3.45576, 0, 0, -0.987688, 0.156436, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+86, 3290, 1, 679.162, -4507.65, 16.3531, 6.0912, 0, 0, -0.0958452, 0.995396, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+87, 3290, 1, 914.8, -4634.19, 19.087, 3.29869, 0, 0, -0.996917, 0.0784664, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+88, 3290, 1, 1036.63, -4590.97, 19.9847, 4.72984, 0, 0, -0.700909, 0.713251, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+89, 20920, 47, 2044.94, 1765.88, 59.6994, 4.42896, 0, 0, -0.799891, 0.600146, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+90, 20920, 47, 2046.39, 1706.29, 59.5589, 4.93285, 0, 0, -0.625028, 0.780603, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+91, 20920, 47, 2063.41, 1649.33, 61.1799, 4.599, 0, 0, -0.746038, 0.665903, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+92, 20920, 47, 2065.79, 1618.62, 63.6112, 1.16058, 0, 0, 0.548265, 0.836304, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+93, 20920, 47, 2072.73, 1778.92, 56.0082, 3.95101, 0, 0, -0.919217, 0.393751, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+94, 20920, 47, 2072.87, 1778.76, 55.9931, 3.73354, 0, 0, -0.956519, 0.29167, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+95, 20920, 47, 2072.94, 1778.64, 55.9876, 3.6001, 0, 0, -0.973836, 0.227252, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+96, 20920, 47, 2076.21, 1702.24, 57.1493, 0.00849726, 0, 0, 0.00424862, 0.999991, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+97, 20920, 47, 2079.49, 1669.47, 61.3327, 0.695396, 0, 0, 0.340734, 0.94016, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+98, 20920, 47, 2096.47, 1788.98, 51.0372, 3.66105, 0, 0, -0.966459, 0.25682, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+99, 20920, 47, 2100.35, 1674.17, 59.2608, 4.68805, 0, 0, -0.71566, 0.698449, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+100, 20920, 47, 2100.88, 1718.25, 54.4839, 6.24492, 0, 0, -0.0191336, 0.999817, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+101, 20920, 47, 2104.42, 1853.76, 49.3604, 3.30897, 0, 0, -0.9965, 0.0835924, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+102, 20920, 47, 2115.48, 1799.49, 47.5996, 3.41593, 0, 0, -0.990607, 0.136738, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+103, 20920, 47, 2117.32, 1669.78, 59.3417, 5.9392, 0, 0, -0.171147, 0.985245, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+104, 20920, 47, 2119.12, 1669.95, 59.2502, 3.67137, 0, 0, -0.965121, 0.261803, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+105, 20920, 47, 2119.21, 1669.73, 59.248, 3.43777, 0, 0, -0.989055, 0.147549, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+106, 20920, 47, 2119.22, 1669.68, 59.2488, 3.38093, 0, 0, -0.992848, 0.119382, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+107, 20920, 47, 2128.41, 1737.44, 52.3674, 0.428854, 0, 0, 0.212788, 0.977098, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+108, 20920, 47, 2130.78, 1844.22, 48.0524, 3.71329, 0, 0, -0.959422, 0.281974, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+109, 20920, 47, 2130.92, 1843.9, 48.0198, 3.36445, 0, 0, -0.993798, 0.111198, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+110, 20920, 47, 2130.94, 1843.77, 48.0061, 3.23093, 0, 0, -0.999002, 0.044655, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+111, 20920, 47, 2134.99, 1826.58, 46.6136, 4.26495, 0, 0, -0.846363, 0.532606, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+112, 20920, 47, 2141.52, 1677.37, 58.1502, 4.76284, 0, 0, -0.689046, 0.724718, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+113, 20920, 47, 2142.05, 1677.24, 58.1266, 4.20783, 0, 0, -0.861225, 0.508224, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+114, 20920, 47, 2156.99, 1721.46, 52.2289, 6.06913, 0, 0, -0.106826, 0.994278, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+115, 20920, 47, 2157.07, 1721.69, 52.2129, 5.82312, 0, 0, -0.228009, 0.973659, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+116, 20920, 47, 2163.1, 1707.08, 54.3258, 5.44586, 0, 0, -0.406538, 0.913634, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+117, 20920, 47, 2163.83, 1707.34, 54.3322, 4.6478, 0, 0, -0.72957, 0.683906, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+118, 20920, 47, 2164.25, 1690.15, 57.1036, 3.41611, 0, 0, -0.990595, 0.136828, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+119, 20920, 47, 2171.02, 1849.58, 57.7634, 2.70508, 0, 0, 0.976276, 0.216528, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+120, 20920, 47, 2189.71, 1834.96, 60.1657, 2.57446, 0, 0, 0.960064, 0.279781, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+121, 20920, 47, 2190.94, 1816.09, 62.6802, 4.98443, 0, 0, -0.60469, 0.796461, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+122, 20920, 47, 2191.21, 1814.13, 62.6528, 1.57267, 0, 0, 0.707767, 0.706445, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+123, 22246, 1, -2423.62, 2408.19, 76.04, 0.244346, 0, 0, 0.121869, 0.992546, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+124, 22246, 1, -2283.86, 2504.07, 74.2575, 0.488691, 0, 0, 0.241921, 0.970296, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+125, 153123, 1, 4329.32, -6169.11, 127.45, 0.244346, 0, 0, 0.121869, 0.992546, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+126, 153123, 1, 4335.05, -6130.74, 126.549, 1.20428, 0, 0, 0.566406, 0.824126, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+127, 153123, 1, 4340.8, -6153.5, 127.366, 3.64774, 0, 0, -0.968147, 0.250381, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+128, 153123, 1, 4354.1, -6248, 96.4802, 5.53269, 0, 0, -0.366501, 0.930418, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+129, 153123, 1, 4360.25, -6212.37, 94.3982, 5.46288, 0, 0, -0.398748, 0.91706, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+130, 153123, 1, 4370.38, -6145.63, 124.947, 2.44346, 0, 0, 0.939692, 0.34202, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+131, 153123, 1, 4462.26, -6251.27, 100.032, 1.25664, 0, 0, 0.587785, 0.809017, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+132, 157936, 1, -7408.57, -2290.08, -267.817, 0.994837, 0, 0, 0.477159, 0.878817, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+133, 157936, 1, -7310.97, -1840.55, -269.26, 2.32129, 0, 0, 0.91706, 0.39875, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+134, 157936, 1, -6766.64, -2133.35, -270.394, 0.244346, 0, 0, 0.121869, 0.992546, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+135, 164662, 0, 1898.26, 1551.14, 88.9613, 0.0349062, 0, 0, 0.0174522, 0.999848, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+136, 164958, 1, -6938.39, -2124.61, -271.871, 0.95993, 0, 0, 0.461748, 0.887011, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+137, 164958, 1, -6472.49, -1859.82, -269.151, 3.28124, 0, 0, -0.997563, 0.0697661, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+138, 171938, 1, -315.668, -4443.73, 58.4251, 4.10153, 0, 0, -0.887011, 0.461749, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+139, 175324, 1, 5210.61, -4883.14, 695.762, 1.51844, 0, 0, 0.688354, 0.725374, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+140, 175324, 1, 5362.16, -4515.79, 715.315, 2.77507, 0, 0, 0.983254, 0.182238, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+141, 175384, 1, -5162.74, -906.036, -5.38093, 5.48033, 0, 0, -0.390731, 0.920505, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+142, 175384, 1, -5128.44, -878.431, -5.20136, 6.07375, 0, 0, -0.104528, 0.994522, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+143, 175708, 1, -238.936, -3337.52, 91.6852, 1.06465, 0, 0, 0.507538, 0.861629, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+144, 175708, 1, -134.408, -3309.68, 91.6667, 5.37562, 0, 0, -0.438371, 0.898794, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+145, 176630, 0, -1720.33, -1529, 55.8142, 0.331611, 0, 0, 0.165047, 0.986286, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+146, 176630, 0, -1710.98, -1614.04, 60.307, 0.680677, 0, 0, 0.333806, 0.942642, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+147, 176630, 0, -1687.98, -1921.14, 86.7267, 0.383971, 0, 0, 0.190808, 0.981627, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+148, 176630, 0, -1680.13, -1562.57, 56.2585, 4.29351, 0, 0, -0.83867, 0.54464, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+149, 178186, 1, 4249.85, 708.708, -27.9947, 3.3685, 0, 0, -0.993571, 0.113208, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+150, 178186, 1, 4256.58, 741.201, -23.1426, 4.50295, 0, 0, -0.777145, 0.629321, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+151, 178186, 1, 4298.83, 901.486, -10.9594, 2.32129, 0, 0, 0.91706, 0.39875, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+152, 178186, 1, 4299, 853.137, -11.923, 2.11185, 0, 0, 0.870356, 0.492424, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+153, 178186, 1, 4249.85, 708.708, -27.9947, 3.3685, 0, 0, -0.993571, 0.113208, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+154, 178186, 1, 4256.58, 741.201, -23.1426, 4.50295, 0, 0, -0.777145, 0.629321, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+155, 178186, 1, 4298.83, 901.486, -10.9594, 2.32129, 0, 0, 0.91706, 0.39875, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+156, 178186, 1, 4299, 853.137, -11.923, 2.11185, 0, 0, 0.870356, 0.492424, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+157, 179922, 0, -596.266, -4169.08, 238.353, 4.79966, 0, 0, -0.67559, 0.737278, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+158, 179922, 0, -579.326, -4129.8, 238.428, 4.62512, 0, 0, -0.737277, 0.675591, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+159, 179922, 0, -524.139, -4162.01, 215.847, 4.81711, 0, 0, -0.66913, 0.743145, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+160, 179922, 0, -482.062, -4118.51, 195.34, 2.56563, 0, 0, 0.958819, 0.284016, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+161, 179922, 0, -479.329, -4089.07, 195.065, 0.715585, 0, 0, 0.350207, 0.936672, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+162, 179922, 0, -454.969, -4201.28, 195.584, 5.07891, 0, 0, -0.566406, 0.824126, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+163, 179922, 0, -443.47, -4032.53, 195.981, 1.58825, 0, 0, 0.71325, 0.70091, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+164, 179922, 0, -420.406, -4125.77, 174.108, 0.139624, 0, 0, 0.0697556, 0.997564, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+165, 179922, 0, -410.667, -4192.75, 174.073, 4.59022, 0, 0, -0.748956, 0.66262, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+166, 179922, 0, -403.392, -3821.2, 238.351, 1.13446, 0, 0, 0.537299, 0.843392, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+167, 179922, 0, -397.883, -3931.51, 215.861, 5.49779, 0, 0, -0.382683, 0.92388, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+168, 179922, 0, -386.635, -4045.72, 174.073, 1.23918, 0, 0, 0.580703, 0.814116, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+169, 179922, 0, -381.563, -3820.9, 238.414, 3.17653, 0, 0, -0.999847, 0.0174693, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+170, 179922, 0, -376.369, -4114.17, 174.411, 0.994837, 0, 0, 0.477159, 0.878817, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+171, 179922, 0, -371.539, -3976.63, 195.137, 5.39307, 0, 0, -0.430511, 0.902586, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+172, 179922, 0, -366.252, -4075.86, 174.261, 2.21657, 0, 0, 0.894934, 0.446199, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+173, 179922, 0, -360.483, -3779.5, 238.447, 4.62512, 0, 0, -0.737277, 0.675591, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+174, 179922, 0, -352.116, -4139.54, 152.513, 4.85202, 0, 0, -0.656058, 0.75471, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+175, 179922, 0, -338.893, -4219.06, 152.012, 3.45576, 0, 0, -0.987688, 0.156436, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+176, 179922, 0, -315.62, -4073.82, 153.07, 6.17847, 0, 0, -0.0523357, 0.99863, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+177, 179922, 0, -304.407, -3970.66, 195.114, 0.436332, 0, 0, 0.216439, 0.976296, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+178, 179922, 0, -303.057, -4173.79, 136.437, 3.6652, 0, 0, -0.965925, 0.258821, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+179, 179922, 0, -283.102, -4013.48, 175.278, 0.453785, 0, 0, 0.224951, 0.97437, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+180, 179922, 0, -260.693, -3835.28, 238.351, 4.10153, 0, 0, -0.887011, 0.461749, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+181, 179922, 0, -243.064, -4053.7, 174.295, 4.90438, 0, 0, -0.636078, 0.771625, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+182, 179922, 0, -225.57, -3825.01, 238.452, 2.9496, 0, 0, 0.995396, 0.0958512, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+183, 181287, 533, 2453.56, -2977.35, 244.228, 0.785397, 0, 0, 0.382683, 0.92388, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+184, 181287, 533, 2535.11, -3585.44, 271.079, 1.5708, 0, 0, 0.707107, 0.707107, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+185, 181287, 533, 2577.11, -3596.2, 270.465, 4.72984, 0, 0, -0.700909, 0.713251, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+186, 181287, 533, 2585.93, -3064.6, 243.442, 0.837757, 0, 0, 0.406736, 0.913546, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+187, 181287, 533, 2602.19, -2935.06, 243.96, 3.927, 0, 0, -0.923879, 0.382686, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+188, 181287, 533, 2611.22, -3763.56, 297.585, 2.33874, 0, 0, 0.920505, 0.390732, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+189, 181287, 533, 2626.5, -3544.66, 262.862, 1.58825, 0, 0, 0.71325, 0.70091, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+190, 181287, 533, 2634.06, -3366.51, 270.017, 0, 0, 0, 0, 1, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+191, 181287, 533, 2637.66, -3851.02, 297.7, 2.40855, 0, 0, 0.93358, 0.358368, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+192, 181287, 533, 2645.26, -3858.63, 296.864, 5.46288, 0, 0, -0.398748, 0.91706, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+193, 181287, 533, 2652.49, -3433.82, 270.61, 1.39626, 0, 0, 0.642787, 0.766045, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+194, 181287, 533, 2702.76, -3434.9, 270.325, 1.6057, 0, 0, 0.719339, 0.694659, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+195, 181287, 533, 2722.43, -3455.17, 263.251, 4.72984, 0, 0, -0.700909, 0.713251, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+196, 181287, 533, 2731.38, -3706.87, 275.052, 0.802851, 0, 0, 0.390731, 0.920505, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+197, 181287, 533, 2734.94, -3660.31, 275.164, 5.48033, 0, 0, -0.390731, 0.920505, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+198, 181287, 533, 2749.92, -3409.18, 269.94, 3.10665, 0, 0, 0.999847, 0.0174693, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+199, 181287, 533, 2756, -3131.44, 270.288, 1.18682, 0, 0, 0.559193, 0.829038, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+200, 181287, 533, 2756.09, -3067.31, 270.317, 5.11382, 0, 0, -0.551936, 0.833886, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+201, 181287, 533, 2770.86, -3064.53, 270.256, 4.66003, 0, 0, -0.725374, 0.688355, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+202, 181287, 533, 2784.2, -3067.59, 270.159, 4.27606, 0, 0, -0.843391, 0.5373, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+203, 181287, 533, 2813.58, -3703.97, 275.578, 2.49582, 0, 0, 0.948323, 0.317306, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+204, 181287, 533, 2853.87, -3904.02, 270.793, 0, 0, 0, 0, 1, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+205, 181287, 533, 2869.52, -4020.8, 275.707, 0.541051, 0, 0, 0.267238, 0.963631, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+206, 181287, 533, 2893.35, -4041.45, 274.809, 1.22173, 0, 0, 0.573576, 0.819152, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+207, 181287, 533, 2948.74, -4021.67, 275.741, 2.56563, 0, 0, 0.958819, 0.284016, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+208, 181287, 533, 3166.87, -3860.77, 271.062, 0, 0, 0, 0, 1, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+209, 181287, 533, 3190.91, -3281.38, 295.762, 6.26573, 0, 0, -0.00872612, 0.999962, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+210, 181287, 533, 3271.49, -3421.56, 288.343, 4.95674, 0, 0, -0.615661, 0.788011, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+211, 181287, 533, 3294.19, -3098.07, 300.411, 5.11382, 0, 0, -0.551936, 0.833886, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+212, 181287, 533, 3333.69, -3462.84, 288.247, 4.67748, 0, 0, -0.719339, 0.694659, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+213, 181287, 533, 3334.26, -3040.61, 298.125, 2.37364, 0, 0, 0.927183, 0.374608, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+214, 181287, 533, 3349.23, -3115.05, 299.882, 3.94445, 0, 0, -0.920505, 0.390732, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+215, 181287, 533, 3431.5, -3272.49, 270.195, 1.5708, 0, 0, 0.707107, 0.707107, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+216, 181287, 533, 3442.84, -3903.16, 309.609, 0.226892, 0, 0, 0.113203, 0.993572, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+217, 181287, 533, 3475.76, -3585.5, 270.247, 1.53589, 0, 0, 0.694658, 0.71934, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+218, 181287, 533, 3475.9, -3184.91, 297.691, 1.5708, 0, 0, 0.707107, 0.707107, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+219, 181098, 0, -7897.03, -1491.1, 140.689, 3.6652, 0, 0, -0.965925, 0.258821, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+220, 181098, 0, -7758.8, -2528.35, 140.149, 0.401425, 0, 0, 0.199368, 0.979925, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+221, 153556, 0, -7768.99, -2384.25, 134.236, 3.68265, 0, 0, -0.96363, 0.267241, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+222, 153556, 0, -7759.26, -1889.66, 133.439, 0.436332, 0, 0, 0.216439, 0.976296, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+223, 153556, 0, -7680.68, -2203.66, 150.445, 3.97935, 0, 0, -0.913545, 0.406738, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+224, 2554, 0, -14912.9, 83.4848, 2.1396, 2.60054, 0, 0, 0.96363, 0.267241, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+225, 17282, 1, 3726.4, -95.8715, -1.13148, 5.42797, 0, 0, -0.414693, 0.909961, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+226, 17282, 1, 3767.12, -109.303, 0.316303, 4.72984, 0, 0, -0.700909, 0.713251, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+227, 17282, 1, 3782.52, -177.971, 4.07483, 2.51327, 0, 0, 0.951056, 0.309017, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+228, 17282, 1, 3791.12, -137.186, 0.584901, 2.46091, 0, 0, 0.942641, 0.333808, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+229, 17282, 1, 3825.75, -135.128, -1.29767, 5.48033, 0, 0, -0.390731, 0.920505, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+230, 17282, 1, 3838.51, -111.628, 1.98953, 2.9845, 0, 0, 0.996917, 0.0784664, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+231, 17282, 1, 3853.51, -252.526, 7.92101, 2.61799, 0, 0, 0.965925, 0.258821, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+232, 17282, 1, 3856.65, -123.118, 4.6654, 1.48353, 0, 0, 0.67559, 0.737278, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+233, 17282, 1, 3867.13, -215.073, 5.48538, 2.96704, 0, 0, 0.996194, 0.087165, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+234, 143980, 1, -3985.01, -175.641, 139.972, 0.191985, 0, 0, 0.0958452, 0.995396, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+235, 143980, 1, -3978.67, -72.4312, 152.078, 5.70723, 0, 0, -0.284015, 0.95882, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+236, 1673, 1, 9192.66, 1279.21, 1317.2, 3.33359, 0, 0, -0.995396, 0.0958512, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+237, 1673, 1, 9230.61, 1116.75, 1314.75, 6.16101, 0, 0, -0.0610485, 0.998135, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+238, 1673, 1, 9283.52, 983.153, 1309.06, 1.0821, 0, 0, 0.515038, 0.857168, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+239, 1673, 1, 9294.38, 1139.13, 1255.72, 2.72271, 0, 0, 0.978148, 0.207912, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+240, 1673, 1, 9358.01, 920.896, 1291.44, 3.194, 0, 0, -0.999657, 0.0262016, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+242, 3685, 1, -3204.72, -1848.01, 93.7397, 2.09439, 0, 0, 0.866025, 0.500001, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+243, 3685, 1, -3201.16, -1729.31, 96.1353, 1.0472, 0, 0, 0.5, 0.866025, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+244, 3685, 1, -3144.85, -1785.78, 96.2349, 0.0698117, 0, 0, 0.0348988, 0.999391, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+245, 3685, 1, -3111.52, -2283.34, 95.0335, 5.86431, 0, 0, -0.207911, 0.978148, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+246, 3685, 1, -3107, -2301.07, 94.0722, 1.67551, 0, 0, 0.743144, 0.669131, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+247, 3685, 1, -3094.91, -1693.75, 94.696, 5.53269, 0, 0, -0.366501, 0.930418, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+248, 3685, 1, -3094.76, -1684.87, 94.9089, 2.32129, 0, 0, 0.91706, 0.39875, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+249, 3685, 1, -3091.74, -1726.71, 93.3487, 2.9845, 0, 0, 0.996917, 0.0784664, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+250, 3685, 1, -3085.06, -1943, 95.9858, 2.44346, 0, 0, 0.939692, 0.34202, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+251, 175928, 1, -5028.41, -2000.75, -53.1136, 5.37562, 0, 0, -0.438371, 0.898794, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+252, 2724, 0, -11385.9, 1782.51, 8.20595, 3.9619, 0, 0, -0.91706, 0.39875, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+253, 2724, 0, -11248.7, 1163.33, 89.0312, 2.51327, 0, 0, 0.951056, 0.309017, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+254, 2724, 0, -11093.3, 1918.23, 33.3913, 0.401425, 0, 0, 0.199368, 0.979925, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+255, 2724, 0, -11073.3, 1537.62, 43.3983, 5.93412, 0, 0, -0.173648, 0.984808, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+256, 2724, 0, -11041.1, 1042.28, 36.8841, 1.32645, 0, 0, 0.615661, 0.788011, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+257, 2724, 0, -10997.1, 1470.89, 43.2017, 4.27606, 0, 0, -0.843391, 0.5373, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+258, 2724, 0, -10931.8, 1984.77, 33.5807, 3.89209, 0, 0, -0.930417, 0.366502, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+259, 2724, 0, -10723.8, 1730.3, 41.7724, 6.07375, 0, 0, -0.104528, 0.994522, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+260, 2724, 0, -10659.6, 1785.06, 35.9907, 4.72984, 0, 0, -0.700909, 0.713251, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+261, 2724, 0, -10655.6, 1733.91, 39.5011, 3.99681, 0, 0, -0.909961, 0.414694, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+262, 2724, 0, -10624.6, 1675.8, 41.5907, 4.41568, 0, 0, -0.803857, 0.594823, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+263, 2724, 0, -10616.9, 1952.01, 37.6884, 0.95993, 0, 0, 0.461748, 0.887011, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+264, 2724, 0, -10355.6, 1560.15, 41.9347, 4.71239, 0, 0, -0.707107, 0.707107, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+265, 2724, 0, -10346.6, 1560.35, 41.5322, 5.65487, 0, 0, -0.309016, 0.951057, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+266, 2724, 0, -10334, 1591.3, 40.6408, 4.36332, 0, 0, -0.819152, 0.573577, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+267, 2724, 0, -10316.1, 1402.16, 41.3236, 4.29351, 0, 0, -0.83867, 0.54464, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+268, 2724, 0, -10314.7, 1409.5, 40.3503, 5.68977, 0, 0, -0.292372, 0.956305, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+269, 2724, 0, -10310.8, 1618.76, 44.3931, 4.5204, 0, 0, -0.771625, 0.636078, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+270, 2724, 0, -10306, 1409.56, 40.1466, 1.8675, 0, 0, 0.803857, 0.594823, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+271, 2724, 0, -10295.7, 1412.82, 40.8534, 1.36136, 0, 0, 0.62932, 0.777146, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+272, 2724, 0, -10273.9, 1380.45, 40.2871, 1.50098, 0, 0, 0.681998, 0.731354, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+273, 2724, 0, -10268.7, 1511.84, 39.2982, 2.11185, 0, 0, 0.870356, 0.492424, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+274, 2724, 0, -10218.9, 1479.22, 41.2841, 1.09956, 0, 0, 0.522498, 0.85264, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+275, 2724, 0, -10202.8, 1175.77, 37.4101, 0.471238, 0, 0, 0.233445, 0.97237, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+276, 2724, 0, -10197.3, 1302.97, 37.0113, 1.18682, 0, 0, 0.559193, 0.829038, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+277, 2724, 0, -10191.1, 1901.71, 36.3493, 4.4855, 0, 0, -0.782608, 0.622515, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+278, 2724, 0, -10167.8, 1403.56, 38.7498, 5.28835, 0, 0, -0.477159, 0.878817, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+279, 2724, 0, -10164.2, 1323.94, 38.2371, 5.16618, 0, 0, -0.529919, 0.848048, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+280, 2724, 0, -10154.9, 1201.21, 36.2941, 1.39626, 0, 0, 0.642787, 0.766045, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+281, 2724, 0, -10144.4, 1215.62, 36.8305, 0.680677, 0, 0, 0.333806, 0.942642, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+282, 2724, 0, -10138, 1441.31, 39.8493, 2.3911, 0, 0, 0.930417, 0.366502, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+283, 2724, 0, -10111.7, 1190.27, 35.9977, 5.68977, 0, 0, -0.292372, 0.956305, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+284, 2724, 0, -10104.5, 1051.58, 36.5203, 2.33874, 0, 0, 0.920505, 0.390732, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+285, 2724, 0, -10076.1, 1153.29, 36.4695, 2.07694, 0, 0, 0.861629, 0.507539, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+286, 2724, 0, -10042.9, 1084.58, 39.2036, 2.23402, 0, 0, 0.898793, 0.438373, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+287, 2724, 0, -10035.3, 1243.05, 42.6959, 2.60054, 0, 0, 0.96363, 0.267241, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+288, 2724, 0, -10030.4, 1824.73, 37.2337, 4.45059, 0, 0, -0.793353, 0.608762, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+289, 2724, 0, -9989.48, 1448.95, 41.7675, 3.4034, 0, 0, -0.991445, 0.130528, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+290, 2724, 0, -9987.42, 1244.5, 41.0107, 2.84488, 0, 0, 0.989016, 0.147811, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+291, 2724, 0, -9984.65, 1120.58, 42.7291, 4.41568, 0, 0, -0.803857, 0.594823, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+292, 2724, 0, -9884.78, 1291.89, 41.6949, 3.68265, 0, 0, -0.96363, 0.267241, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+293, 2724, 0, -9881.16, 1306.93, 42.2289, 4.69494, 0, 0, -0.71325, 0.70091, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+294, 2724, 0, -9880.67, 1318.79, 42.9694, 1.22173, 0, 0, 0.573576, 0.819152, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+295, 2724, 0, -9847.82, 1205.27, 41.1716, 0.226892, 0, 0, 0.113203, 0.993572, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+296, 2724, 0, -9843.05, 1278.22, 41.0869, 0.104719, 0, 0, 0.0523357, 0.99863, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+297, 2724, 0, -9838.97, 1008.29, 29.2233, 4.81711, 0, 0, -0.66913, 0.743145, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+298, 2724, 0, -9834.38, 1259.81, 41.1793, 3.33359, 0, 0, -0.995396, 0.0958512, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+299, 2724, 0, -9817.12, 1290.56, 40.4487, 0.087266, 0, 0, 0.0436192, 0.999048, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+300, 2724, 0, -9814.8, 1050.07, 30.2684, 3.47321, 0, 0, -0.986285, 0.16505, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+301, 2724, 0, -9771.92, 970.624, 29.2082, 4.46804, 0, 0, -0.788011, 0.615662, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+302, 2724, 0, -9747.07, 1186.08, 41.0141, 4.53786, 0, 0, -0.766044, 0.642789, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+303, 2724, 0, -9742.93, 1189.54, 40.9789, 4.7473, 0, 0, -0.694658, 0.71934, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+304, 2724, 0, -9737.15, 1205.05, 41.1943, 4.31097, 0, 0, -0.833885, 0.551938, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+305, 2724, 0, -9715.97, 1441.35, 45.0081, 2.96704, 0, 0, 0.996194, 0.087165, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+306, 2724, 0, -9711.33, 989.168, 35.0397, 6.05629, 0, 0, -0.113203, 0.993572, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+307, 2724, 0, -9698.25, 1039.98, 35.9208, 2.53072, 0, 0, 0.953716, 0.300708, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+308, 13360, 1, 7244.34, -955.567, 37.629, 1.22173, 0, 0, 0.573576, 0.819152, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+309, 13360, 1, 7394.09, -816.888, 14.4734, 4.90438, 0, 0, -0.636078, 0.771625, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+310, 13360, 1, 7615.8, -1068.99, 39.3911, 0.174532, 0, 0, 0.0871553, 0.996195, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+311, 13360, 1, 7646.15, -1002.09, 38.1283, 6.21337, 0, 0, -0.0348988, 0.999391, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+312, 12654, 1, 7269.42, -825.411, 25.8866, 3.90954, 0, 0, -0.927183, 0.374608, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+313, 12654, 1, 7382.8, -925.178, 32.2543, 1.67551, 0, 0, 0.743144, 0.669131, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+314, 12654, 1, 7623.01, -969.113, 33.0155, 3.03684, 0, 0, 0.998629, 0.0523532, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+315, 12654, 1, 7650.7, -945.462, 26.58, 5.20108, 0, 0, -0.515038, 0.857168, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+316, 13872, 1, 7378.67, -827.524, 17.3307, 1.78023, 0, 0, 0.777145, 0.629321, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+317, 13872, 1, 7395.16, -1123.29, 41.135, 0.802851, 0, 0, 0.390731, 0.920505, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+318, 28604, 0, -9952.99, -3599.49, 22.7174, 2.9845, 0, 0, 0.996917, 0.0784664, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+319, 86492, 1, 6356.49, 722.518, -13.6417, 4.34587, 0, 0, -0.824126, 0.566406, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+320, 86492, 1, 6435.49, 815.086, -19.5959, 3.56047, 0, 0, -0.978148, 0.207912, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+321, 86492, 1, 6441.63, 884, -54.4092, 0.95993, 0, 0, 0.461748, 0.887011, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+322, 89634, 0, -4101.69, -710.65, -13.1221, 2.40855, 0, 0, 0.93358, 0.358368, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+323, 89635, 1, -4874.06, -911.738, -5.33178, 3.17653, 0, 0, -0.999847, 0.0174693, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+324, 148516, 1, 3221.44, -5345.56, 88.89, 0.087266, 0, 0, 0.0436192, 0.999048, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+325, 148516, 1, 3248.51, -5161.04, 90.2828, 5.49779, 0, 0, -0.382683, 0.92388, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+326, 148516, 1, 3299.3, -5139.79, 88.2029, 5.34071, 0, 0, -0.45399, 0.891007, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+327, 148516, 1, 3471.27, -5018.48, 89.4183, 4.85202, 0, 0, -0.656058, 0.75471, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+328, 148516, 1, 3739.93, -5216.88, 87.6198, 3.31614, 0, 0, -0.996194, 0.087165, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+329, 148513, 1, 3154, -5506.02, 96.7798, 1.85005, 0, 0, 0.798635, 0.601815, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+330, 148513, 1, 3179.1, -5481.11, 95.948, 1.72787, 0, 0, 0.760406, 0.649449, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+331, 148513, 1, 3315.52, -5004.58, 94.6178, 4.17134, 0, 0, -0.870356, 0.492424, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+332, 148513, 1, 3429.11, -5277.22, 92.5397, 0.523598, 0, 0, 0.258819, 0.965926, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+333, 148513, 1, 3437.05, -5196.88, 83.5082, 1.65806, 0, 0, 0.737277, 0.675591, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+334, 148514, 1, 3342.92, -5096.74, 89.8286, 5.41052, 0, 0, -0.422618, 0.906308, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+335, 148514, 1, 3348.71, -5268.47, 87.4248, 0.95993, 0, 0, 0.461748, 0.887011, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+336, 148514, 1, 3384.4, -5007.48, 89.3352, 4.41568, 0, 0, -0.803857, 0.594823, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+337, 148514, 1, 3391.15, -5158.34, 83.7713, 0.90757, 0, 0, 0.438371, 0.898794, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+338, 148514, 1, 3399.35, -5091.93, 82.0291, 1.74533, 0, 0, 0.766044, 0.642789, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+339, 148514, 1, 3809.11, -5268.6, 93.8907, 1.90241, 0, 0, 0.814116, 0.580703, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+340, 148515, 1, 3158.7, -5258.93, 90.9112, 5.18363, 0, 0, -0.522498, 0.85264, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+341, 148515, 1, 3203.66, -5328.38, 85.7456, 2.96704, 0, 0, 0.996194, 0.087165, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+342, 148515, 1, 3502.9, -5112.54, 83.9106, 0.558504, 0, 0, 0.275637, 0.961262, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+343, 152094, 1, 10304.6, 1031.92, 1343.54, 6.24828, 0, 0, -0.0174522, 0.999848, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+344, 152094, 1, 10343.3, 1010.95, 1336.19, 0.174532, 0, 0, 0.0871553, 0.996195, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+345, 152094, 1, 10345.7, 1041.5, 1339.75, 2.63544, 0, 0, 0.968147, 0.250381, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+346, 152094, 1, 10369.1, 1029.92, 1339.69, 6.00393, 0, 0, -0.139173, 0.990268, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+347, 152094, 1, 10404.1, 516.125, 1330.17, 4.4855, 0, 0, -0.782608, 0.622515, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+348, 152094, 1, 10456.2, 637.049, 1323.81, 2.61799, 0, 0, 0.965925, 0.258821, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+349, 152631, 1, 2283.25, -6079.93, 108.183, 1.5708, 0, 0, 0.707107, 0.707107, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+350, 152631, 1, 2294.57, -6258.64, 114.547, 1.16937, 0, 0, 0.551936, 0.833886, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+351, 152631, 1, 2340.54, -6138.33, 118.632, 4.50295, 0, 0, -0.777145, 0.629321, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+352, 152631, 1, 2399.99, -6180.49, 100.596, 4.46804, 0, 0, -0.788011, 0.615662, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+353, 152631, 1, 2406.26, -6077.89, 113.126, 6.17847, 0, 0, -0.0523357, 0.99863, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+354, 152631, 1, 2414.94, -6326.1, 93.5893, 5.95157, 0, 0, -0.165047, 0.986286, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+355, 152631, 1, 2415.41, -6055.81, 109.944, 5.84685, 0, 0, -0.216439, 0.976296, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+356, 152631, 1, 2471.95, -6287.08, 109.967, 2.33874, 0, 0, 0.920505, 0.390732, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+357, 152631, 1, 2475.44, -6418.02, 105.61, 0.418879, 0, 0, 0.207911, 0.978148, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+358, 152631, 1, 2477.72, -5963.47, 96.5236, 4.38078, 0, 0, -0.814116, 0.580703, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+359, 152631, 1, 2481.12, -5603.33, 110.155, 1.01229, 0, 0, 0.484809, 0.87462, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+360, 152631, 1, 2484.5, -6458.48, 95.1752, 5.39307, 0, 0, -0.430511, 0.902586, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+361, 152631, 1, 2508.9, -6205.66, 107.223, 6.10865, 0, 0, -0.0871553, 0.996195, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+362, 152631, 1, 2524.26, -6327.23, 107.581, 1.81514, 0, 0, 0.788011, 0.615662, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+363, 152631, 1, 2525.83, -6122.32, 106.806, 2.70526, 0, 0, 0.976295, 0.216442, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+364, 152631, 1, 2529.03, -5704.89, 101.329, 3.24635, 0, 0, -0.998629, 0.0523532, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+365, 152631, 1, 2568.2, -6044.43, 101.809, 0.59341, 0, 0, 0.292371, 0.956305, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+366, 152631, 1, 2586.29, -5831.84, 99.388, 1.76278, 0, 0, 0.771625, 0.636078, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+367, 152631, 1, 2615.67, -6183.5, 97.4634, 4.72984, 0, 0, -0.700909, 0.713251, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+368, 152631, 1, 2749.44, -5906.21, 100.456, 1.79769, 0, 0, 0.782608, 0.622515, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+369, 152631, 1, 2753.01, -6214.48, 103.042, 0.890117, 0, 0, 0.430511, 0.902586, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+370, 152631, 1, 2761.8, -5752.32, 120.954, 3.75246, 0, 0, -0.953716, 0.300708, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+371, 152631, 1, 2763, -5667.07, 134.022, 4.36332, 0, 0, -0.819152, 0.573577, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+372, 152631, 1, 2825.23, -5993.45, 105.692, 5.65487, 0, 0, -0.309016, 0.951057, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+373, 152631, 1, 2851.58, -6082.01, 112.405, 1.53589, 0, 0, 0.694658, 0.71934, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+374, 152631, 1, 2939.59, -5614.15, 143.493, 0.994837, 0, 0, 0.477159, 0.878817, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+375, 152631, 1, 2973.12, -5816.2, 133.852, 3.35105, 0, 0, -0.994521, 0.104536, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+376, 152622, 1, 2300.2, -6302.26, 108.121, 3.26377, 0, 0, -0.998135, 0.0610518, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+377, 152622, 1, 2319.23, -6376.81, 109.028, 0.157079, 0, 0, 0.0784588, 0.996917, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+378, 152622, 1, 2383.39, -6434.48, 100.164, 1.81514, 0, 0, 0.788011, 0.615662, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+379, 152622, 1, 2418.17, -6549.97, 123.278, 2.87979, 0, 0, 0.991445, 0.130528, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+380, 152622, 1, 2475.44, -6418.02, 105.61, 0.418879, 0, 0, 0.207911, 0.978148, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+381, 152622, 1, 2475.58, -6308.31, 104.605, 1.85005, 0, 0, 0.798635, 0.601815, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+382, 152622, 1, 2489.1, -5912.39, 105.033, 1.309, 0, 0, 0.608761, 0.793354, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+383, 152622, 1, 2508.9, -6205.66, 107.223, 6.10865, 0, 0, -0.0871553, 0.996195, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+384, 152622, 1, 2525.48, -5860.44, 101.533, 4.99164, 0, 0, -0.601814, 0.798636, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+385, 152622, 1, 2615.67, -6183.5, 97.4634, 4.72984, 0, 0, -0.700909, 0.713251, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+386, 152622, 1, 2633.52, -5833.2, 97.2349, 1.13446, 0, 0, 0.537299, 0.843392, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+387, 152622, 1, 2655.94, -5737.8, 112.926, 1.83259, 0, 0, 0.793353, 0.608762, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+388, 152622, 1, 2673.61, -6006.06, 99.1625, 0.558504, 0, 0, 0.275637, 0.961262, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+389, 152622, 1, 2703.98, -5637.23, 136.082, 4.79966, 0, 0, -0.67559, 0.737278, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+390, 152622, 1, 2720.12, -5567.12, 121.735, 5.3058, 0, 0, -0.469471, 0.882948, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+391, 152622, 1, 2824.23, -5866.91, 84.2374, 0.680677, 0, 0, 0.333806, 0.942642, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+392, 152622, 1, 2910.19, -5680.45, 127.089, 3.64774, 0, 0, -0.968147, 0.250381, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+393, 152622, 1, 2966.12, -5732.62, 127.249, 4.4855, 0, 0, -0.782608, 0.622515, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+394, 152620, 1, 2690.67, -5991.23, 94.2196, 2.46091, 0, 0, 0.942641, 0.333808, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+395, 176213, 0, 1158.58, -2524.99, 60.7516, 5.68977, 0, 0, -0.292372, 0.956305, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+396, 176213, 0, 1206.12, -2316.5, 57.1717, 4.04917, 0, 0, -0.898793, 0.438373, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+397, 176213, 0, 1286.1, -3159.03, 189.162, 4.67748, 0, 0, -0.719339, 0.694659, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+398, 176213, 0, 1374.47, -1289.64, 57.5279, 1.309, 0, 0, 0.608761, 0.793354, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+399, 176213, 0, 1410.82, -1443.88, 55.8154, 4.95674, 0, 0, -0.615661, 0.788011, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+400, 176213, 0, 1412.57, -1703.56, 69.7742, 5.2709, 0, 0, -0.484809, 0.87462, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+401, 176213, 0, 1460.28, -2069.74, 51.2048, 2.68781, 0, 0, 0.97437, 0.224951, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+402, 176213, 0, 1502.38, -1486.16, 57.1851, 6.19592, 0, 0, -0.0436192, 0.999048, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+403, 176213, 0, 1549.22, -1884.01, 57.7618, 0.401425, 0, 0, 0.199368, 0.979925, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+404, 176213, 0, 1673.18, -2301.81, 58.9883, 3.82227, 0, 0, -0.942641, 0.333808, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+405, 176213, 0, 1678.45, -5024.95, 82.3823, 1.5708, 0, 0, 0.707107, 0.707107, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+406, 176213, 0, 1692.87, -2252.25, 58.9754, 5.07891, 0, 0, -0.566406, 0.824126, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+407, 176213, 0, 1710.78, -2340.36, 59.8974, 1.78023, 0, 0, 0.777145, 0.629321, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+408, 176213, 0, 1723.99, -1128.48, 61.8334, 0.837757, 0, 0, 0.406736, 0.913546, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+409, 176213, 0, 1725.43, -2290.44, 58.8914, 0.471238, 0, 0, 0.233445, 0.97237, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+410, 176213, 0, 1742.08, -3792.19, 127.144, 3.90954, 0, 0, -0.927183, 0.374608, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+411, 176213, 0, 1780.12, -5134.4, 74.6278, 0.191985, 0, 0, 0.0958452, 0.995396, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+412, 176213, 0, 1859.87, -4938.02, 74.9392, 3.24635, 0, 0, -0.998629, 0.0523532, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+413, 176213, 0, 1870, -3988.17, 118.568, 0.174532, 0, 0, 0.0871553, 0.996195, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+414, 176213, 0, 1954.77, -4858.18, 105.06, 2.87979, 0, 0, 0.991445, 0.130528, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+415, 176213, 0, 1974.9, -3975.16, 122.678, 5.75959, 0, 0, -0.258819, 0.965926, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+416, 176213, 0, 1980.37, -4824.86, 93.1408, 0.157079, 0, 0, 0.0784588, 0.996917, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+417, 176213, 0, 2063.55, -5230.85, 83.8689, 5.35816, 0, 0, -0.446198, 0.894935, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+418, 176213, 0, 2075.37, -2980.35, 92.3482, 0.279252, 0, 0, 0.139173, 0.990268, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+419, 176213, 0, 2368.44, -2023.45, 136.933, 5.13127, 0, 0, -0.544639, 0.838671, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+420, 176213, 0, 2395.57, -2495.6, 73.2811, 0.942477, 0, 0, 0.45399, 0.891007, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+421, 176213, 0, 2948.66, -3924.85, 111.359, 5.14872, 0, 0, -0.537299, 0.843392, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+422, 176213, 0, 3111.05, -3684.29, 135.595, 3.927, 0, 0, -0.923879, 0.382686, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+423, 176150, 0, 1360.85, -1458.26, 56.969, 0.645772, 0, 0, 0.317305, 0.948324, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+424, 2560, 0, -14516.9, 126.196, 0.021187, 3.49067, 0, 0, -0.984807, 0.173652, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+425, 2560, 0, -14400.2, 58.3149, 0.486712, 1.65806, 0, 0, 0.737277, 0.675591, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+426, 2560, 0, -14096.1, -142.106, 2.25741, 1.48353, 0, 0, 0.67559, 0.737278, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+427, 2560, 0, -13747.6, -353.419, 0.344131, 5.18363, 0, 0, -0.522498, 0.85264, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+428, 144050, 1, -4012.68, -185.409, 140.527, 0.855211, 0, 0, 0.414693, 0.909961, 900, 900, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+429, 144050, 1, -4010.25, -188.122, 139.341, 0.942477, 0, 0, 0.45399, 0.891007, 900, 900, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+430, 144050, 1, -3994.46, -232.395, 141.62, 0.157079, 0, 0, 0.0784588, 0.996917, 900, 900, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+431, 144050, 1, -3992.21, 52.3467, 101.114, 3.59538, 0, 0, -0.97437, 0.224951, 900, 900, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+432, 144050, 1, -3985.15, -223.901, 137.384, 1.16937, 0, 0, 0.551936, 0.833886, 900, 900, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+433, 144050, 1, -3984.1, 55.572, 102.223, 2.86234, 0, 0, 0.990268, 0.139175, 900, 900, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+434, 144050, 1, -3983.68, -77.4557, 151.38, 2.44346, 0, 0, 0.939692, 0.34202, 900, 900, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+435, 144050, 1, -3977.5, -74.2258, 152.03, 5.09636, 0, 0, -0.559193, 0.829038, 900, 900, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+436, 144050, 1, -3966.25, 136.179, 110.137, 5.28835, 0, 0, -0.477159, 0.878817, 900, 900, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+437, 144050, 1, -3961.26, -154.646, 140.856, 6.0912, 0, 0, -0.0958452, 0.995396, 900, 900, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+438, 144050, 1, -3956.31, -146.737, 140.281, 4.69494, 0, 0, -0.71325, 0.70091, 900, 900, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+439, 144050, 1, -3947.85, -151.51, 141.169, 2.19911, 0, 0, 0.891006, 0.453991, 900, 900, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+440, 144050, 1, -3945, -155.801, 143.6, 3.97935, 0, 0, -0.913545, 0.406738, 900, 900, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+441, 144050, 1, -3934.75, 105.367, 136.715, 1.69297, 0, 0, 0.748956, 0.66262, 900, 900, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+442, 144050, 1, -3750.16, 105.696, 141.447, 1.44862, 0, 0, 0.66262, 0.748956, 900, 900, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+443, 144050, 1, -3742.37, 98.3343, 142.409, 0.401425, 0, 0, 0.199368, 0.979925, 900, 900, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+444, 144050, 1, -3738.9, 93.5071, 142.745, 5.20108, 0, 0, -0.515038, 0.857168, 900, 900, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+445, 144050, 1, -3738.2, 113.304, 138.784, 1.44862, 0, 0, 0.66262, 0.748956, 900, 900, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+446, 144050, 1, -3735.6, 101.586, 142.494, 5.25344, 0, 0, -0.492423, 0.870356, 900, 900, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+447, 144050, 1, -3712.52, 281.385, 139.117, 5.91667, 0, 0, -0.182235, 0.983255, 900, 900, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+448, 144050, 1, -3710.53, 273.882, 137.15, 2.25147, 0, 0, 0.902585, 0.430512, 900, 900, 100, 1, 0, 0, 0, 10),
|
|
(@OGUID+449, 144050, 1, -3709.13, 160.119, 135.977, 1.36136, 0, 0, 0.62932, 0.777146, 900, 900, 100, 1, 0, 0, 0, 10);
|
|
|
|
-- Sync New Data With Existing
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 60, `spawntimesecsmax` = 60 WHERE `id` = 176150;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 7200, `spawntimesecsmax` = 7200, `spawn_flags` = 0 WHERE `id` = 176213;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 180, `spawntimesecsmax` = 180 WHERE `id` IN (152631, 152622, 152620);
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 300, `spawntimesecsmax` = 300, `spawn_flags` = 0 WHERE `id` = 152094;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 180, `spawntimesecsmax` = 180 WHERE `id` = 148515;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 180, `spawntimesecsmax` = 180 WHERE `id` = 148514;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 180, `spawntimesecsmax` = 180 WHERE `id` = 148513;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 180, `spawntimesecsmax` = 180 WHERE `id` = 148516;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 180, `spawntimesecsmax` = 180 WHERE `id` = 89635;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 180, `spawntimesecsmax` = 180, `spawn_flags` = 0 WHERE `id` = 89634;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 180, `spawntimesecsmax` = 180, `spawn_flags` = 0, `animprogress` = 100 WHERE `id` = 86492;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 600, `spawntimesecsmax` = 600 WHERE `id` = 28604;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 180, `spawntimesecsmax` = 300, `spawn_flags` = 0 WHERE `id` IN (13360, 12654, 13872);
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 30, `spawntimesecsmax` = 30 WHERE `id` = 175928;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 180, `spawntimesecsmax` = 180, `spawn_flags` = 0 WHERE `id` = 3640;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 2, `spawntimesecsmax` = 2 WHERE `id` = 143980;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 180, `spawntimesecsmax` = 180 WHERE `id` = 17282;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 180, `spawntimesecsmax` = 180 WHERE `id` = 153556;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 180, `spawntimesecsmax` = 180, `patch_min` = 8 WHERE `id` = 181098;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 604800, `spawntimesecsmax` = 604800, `patch_min` = 9 WHERE `id` = 181287;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 180, `spawntimesecsmax` = 180, `patch_min` = 3 WHERE `id` = 179922;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 300, `spawntimesecsmax` = 300, `spawn_flags` = 0 WHERE `id` IN (178184, 178185, 178186);
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 2, `spawntimesecsmax` = 2 WHERE `id` = 176630;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 2, `spawntimesecsmax` = 2 WHERE `id` = 175708;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 45, `spawntimesecsmax` = 45, `spawn_flags` = 0 WHERE `id` = 175384;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 180, `spawntimesecsmax` = 180 WHERE `id` = 175324;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 60, `spawntimesecsmax` = 60, `spawn_flags` = 0 WHERE `id` = 171938;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 180, `spawntimesecsmax` = 180 WHERE `id` = 164958;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 164662, `spawntimesecsmax` = 164662 WHERE `id` = 157936;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 180, `spawntimesecsmax` = 180 WHERE `id` = 157936;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 180, `spawntimesecsmax` = 180 WHERE `id` = 153123;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = -43200, `spawntimesecsmax` = -43200 WHERE `id` = 20920;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 180, `spawntimesecsmax` = 180 WHERE `id` = 22246;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 300, `spawntimesecsmax` = 300, `spawn_flags` = 0 WHERE `id` = 3290;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 300, `spawntimesecsmax` = 300, `spawn_flags` = 0 WHERE `id` = 3240;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 120, `spawntimesecsmax` = 120, `spawn_flags` = 0 WHERE `id` = 2910;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 300, `spawntimesecsmax` = 300 WHERE `id` = 2743;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 900, `spawntimesecsmax` = 900 WHERE `id` = 175566;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 120, `spawntimesecsmax` = 120 WHERE `id` = 2087;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 25, `spawntimesecsmax` = 25 WHERE `id` = 175334;
|
|
UPDATE `gameobject` SET `spawn_flags` = 0, `spawntimesecsmin` = 120, `spawntimesecsmax` = 120 WHERE `id` = 375;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 600, `spawntimesecsmax` = 600 WHERE `id` = 37099;
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 180, `spawntimesecsmax` = 180 WHERE `id` = 140971;
|
|
UPDATE `gameobject` SET `animprogress` = 100, `state` = 1, `spawn_flags` = 0 WHERE `id` IN ( 140971, 37099, 375, 175334, 2087, 176753, 175566, 2743, 2910, 3240, 3290, 20920, 22246, 153123, 157936, 164662, 164958, 171938, 175324, 175384, 175708, 176630, 178186, 179922, 181287, 181098, 2554, 153556, 17282, 143980, 1673, 3640, 3685, 175928, 2724, 13360, 12654, 13872, 28604, 86492, 89634, 89635, 148516, 148513, 148514, 148515, 152094, 152631, 152622, 152620, 176213, 176150, 2560);
|
|
|
|
-- ---------------------------------------------------------------------------------------------------------------------------
|
|
-- Deepmoss Eggs
|
|
SET @DEEPMOS_EGGS_OGUID = 180;
|
|
SET @DEEPMOS_EGGS_POOL_TEMPLATE = 1550;
|
|
|
|
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
|
|
(@DEEPMOS_EGGS_OGUID, 19541, 1, 1163.37, -414.925, 17.3143, 3.61284, 0, 0, -0.972369, 0.233448, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@DEEPMOS_EGGS_OGUID+1, 19541, 1, 1469.62, 896.44, 135.356, 0.95993, 0, 0, 0.461748, 0.887011, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@DEEPMOS_EGGS_OGUID+2, 19542, 1, 1163.37, -414.925, 17.3143, 3.61284, 0, 0, -0.972369, 0.233448, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@DEEPMOS_EGGS_OGUID+3, 19542, 1, 1469.62, 896.44, 135.356, 0.95993, 0, 0, 0.461748, 0.887011, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@DEEPMOS_EGGS_OGUID+4, 19543, 1, 1163.37, -414.925, 17.3143, 3.61284, 0, 0, -0.972369, 0.233448, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@DEEPMOS_EGGS_OGUID+5, 19543, 1, 1469.62, 896.44, 135.356, 0.95993, 0, 0, 0.461748, 0.887011, 300, 300, 100, 1, 0, 0, 0, 10);
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 180, `spawntimesecsmax` = 360 WHERE `id` IN (19541, 19542, 19543);
|
|
|
|
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_max`) VALUES
|
|
(@DEEPMOS_EGGS_POOL_TEMPLATE, 1, 'Stonetalon Mountains - Deepmoss Eggs', 10),
|
|
(@DEEPMOS_EGGS_POOL_TEMPLATE+1, 1, 'Stonetalon Mountains - Deepmoss Eggs', 10);
|
|
|
|
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_max`) VALUES
|
|
(@DEEPMOS_EGGS_OGUID, @DEEPMOS_EGGS_POOL_TEMPLATE, 'Stonetalon Mountains - Deepmoss Eggs', 10),
|
|
(@DEEPMOS_EGGS_OGUID+1, @DEEPMOS_EGGS_POOL_TEMPLATE+1, 'Stonetalon Mountains - Deepmoss Eggs', 10),
|
|
(@DEEPMOS_EGGS_OGUID+2, @DEEPMOS_EGGS_POOL_TEMPLATE, 'Stonetalon Mountains - Deepmoss Eggs', 10),
|
|
(@DEEPMOS_EGGS_OGUID+3, @DEEPMOS_EGGS_POOL_TEMPLATE+1, 'Stonetalon Mountains - Deepmoss Eggs', 10);
|
|
|
|
-- ---------------------------------------------------------------------------------------------------------------------------
|
|
-- Atal'ai Artifact
|
|
SET @ATAL_ARTIFACT_OGUID = 210;
|
|
SET @ATAL_ARTIFACT_POOL_TEMPLATE = 1583;
|
|
|
|
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
|
|
(@ATAL_ARTIFACT_OGUID+1, 30854, 0, -10528.7, -3820.75, -18.8854, 5.41052, 0, 0, -0.422618, 0.906308, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@ATAL_ARTIFACT_OGUID+2, 30854, 0, -10505.5, -3780.27, -20.4266, 1.25664, 0, 0, 0.587785, 0.809017, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@ATAL_ARTIFACT_OGUID+3, 30854, 0, -10376.8, -3699.82, 12.7557, 6.02139, 0, 0, -0.130526, 0.991445, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@ATAL_ARTIFACT_OGUID+4, 30854, 0, -10343.7, -3804.86, -18.4887, 2.33874, 0, 0, 0.920505, 0.390732, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@ATAL_ARTIFACT_OGUID+5, 30855, 0, -10528.7, -3820.75, -18.8854, 5.41052, 0, 0, -0.422618, 0.906308, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@ATAL_ARTIFACT_OGUID+6, 30855, 0, -10505.5, -3780.27, -20.4266, 1.25664, 0, 0, 0.587785, 0.809017, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@ATAL_ARTIFACT_OGUID+7, 30855, 0, -10376.8, -3699.82, 12.7557, 6.02139, 0, 0, -0.130526, 0.991445, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@ATAL_ARTIFACT_OGUID+8, 30855, 0, -10343.7, -3804.86, -18.4887, 2.33874, 0, 0, 0.920505, 0.390732, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@ATAL_ARTIFACT_OGUID+9, 30856, 0, -10528.7, -3820.75, -18.8854, 5.41052, 0, 0, -0.422618, 0.906308, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@ATAL_ARTIFACT_OGUID+10, 30856, 0, -10505.5, -3780.27, -20.4266, 1.25664, 0, 0, 0.587785, 0.809017, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@ATAL_ARTIFACT_OGUID+11, 30856, 0, -10376.8, -3699.82, 12.7557, 6.02139, 0, 0, -0.130526, 0.991445, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@ATAL_ARTIFACT_OGUID+12, 30856, 0, -10343.7, -3804.86, -18.4887, 2.33874, 0, 0, 0.920505, 0.390732, 300, 300, 100, 1, 0, 0, 0, 10);
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 600, `spawntimesecsmax` = 600, `spawn_flags` = 0 WHERE `id` IN (30854, 30855, 30856);
|
|
|
|
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_max`) VALUES
|
|
(@ATAL_ARTIFACT_POOL_TEMPLATE+1, 1, 'Swamp of Sorrows - Atal\'ai Artifact', 10),
|
|
(@ATAL_ARTIFACT_POOL_TEMPLATE+2, 1, 'Swamp of Sorrows - Atal\'ai Artifact', 10),
|
|
(@ATAL_ARTIFACT_POOL_TEMPLATE+3, 1, 'Swamp of Sorrows - Atal\'ai Artifact', 10),
|
|
(@ATAL_ARTIFACT_POOL_TEMPLATE+4, 1, 'Swamp of Sorrows - Atal\'ai Artifact', 10);
|
|
|
|
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_max`) VALUES
|
|
(@ATAL_ARTIFACT_OGUID+1, @ATAL_ARTIFACT_POOL_TEMPLATE+1, 'Swamp of Sorrows - Atal\'ai Artifact', 10),
|
|
(@ATAL_ARTIFACT_OGUID+2, @ATAL_ARTIFACT_POOL_TEMPLATE+2, 'Swamp of Sorrows - Atal\'ai Artifact', 10),
|
|
(@ATAL_ARTIFACT_OGUID+3, @ATAL_ARTIFACT_POOL_TEMPLATE+3, 'Swamp of Sorrows - Atal\'ai Artifact', 10),
|
|
(@ATAL_ARTIFACT_OGUID+4, @ATAL_ARTIFACT_POOL_TEMPLATE+4, 'Swamp of Sorrows - Atal\'ai Artifact', 10),
|
|
(@ATAL_ARTIFACT_OGUID+5, @ATAL_ARTIFACT_POOL_TEMPLATE+1, 'Swamp of Sorrows - Atal\'ai Artifact', 10),
|
|
(@ATAL_ARTIFACT_OGUID+6, @ATAL_ARTIFACT_POOL_TEMPLATE+2, 'Swamp of Sorrows - Atal\'ai Artifact', 10),
|
|
(@ATAL_ARTIFACT_OGUID+7, @ATAL_ARTIFACT_POOL_TEMPLATE+3, 'Swamp of Sorrows - Atal\'ai Artifact', 10),
|
|
(@ATAL_ARTIFACT_OGUID+8, @ATAL_ARTIFACT_POOL_TEMPLATE+4, 'Swamp of Sorrows - Atal\'ai Artifact', 10),
|
|
(@ATAL_ARTIFACT_OGUID+9, @ATAL_ARTIFACT_POOL_TEMPLATE+1, 'Swamp of Sorrows - Atal\'ai Artifact', 10),
|
|
(@ATAL_ARTIFACT_OGUID+10, @ATAL_ARTIFACT_POOL_TEMPLATE+2, 'Swamp of Sorrows - Atal\'ai Artifact', 10),
|
|
(@ATAL_ARTIFACT_OGUID+11, @ATAL_ARTIFACT_POOL_TEMPLATE+3, 'Swamp of Sorrows - Atal\'ai Artifact', 10),
|
|
(@ATAL_ARTIFACT_OGUID+12, @ATAL_ARTIFACT_POOL_TEMPLATE+4, 'Swamp of Sorrows - Atal\'ai Artifact', 10);
|
|
|
|
-- ---------------------------------------------------------------------------------------------------------------------------
|
|
-- Twilight Tablet Fragments
|
|
SET @TWILIGHT_TABLET_OGUID = 245;
|
|
SET @TWILIGHT_TABLET_POOL_TEMPLATE = 1763;
|
|
|
|
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
|
|
(@TWILIGHT_TABLET_OGUID+1, 180501, 1, -6268.7, 1767.91, 6.55819, 4.18879, 0, 0, -0.866025, 0.500001, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@TWILIGHT_TABLET_OGUID+2, 180501, 1, -6446.85, 1861.94, 5.63745, 2.32129, 0, 0, 0.91706, 0.39875, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@TWILIGHT_TABLET_OGUID+3, 180501, 1, -6355.86, 1727.92, 15.1053, 5.84685, 0, 0, -0.216439, 0.976296, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@TWILIGHT_TABLET_OGUID+4, 180501, 1, -6446.85, 1861.94, 5.63745, 2.32129, 0, 0, 0.91706, 0.39875, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@TWILIGHT_TABLET_OGUID+5, 180501, 1, -6355.86, 1727.92, 15.1053, 5.84685, 0, 0, -0.216439, 0.976296, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@TWILIGHT_TABLET_OGUID+6, 180501, 1, -6268.7, 1767.91, 6.55819, 4.18879, 0, 0, -0.866025, 0.500001, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@TWILIGHT_TABLET_OGUID+7, 180436, 1, -6268.7, 1767.91, 6.55819, 4.18879, 0, 0, -0.866025, 0.500001, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@TWILIGHT_TABLET_OGUID+8, 180436, 1, -6446.85, 1861.94, 5.63745, 2.32129, 0, 0, 0.91706, 0.39875, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@TWILIGHT_TABLET_OGUID+9, 180436, 1, -6355.86, 1727.92, 15.1053, 5.84685, 0, 0, -0.216439, 0.976296, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@TWILIGHT_TABLET_OGUID+10, 180436, 1, -6446.85, 1861.94, 5.63745, 2.32129, 0, 0, 0.91706, 0.39875, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@TWILIGHT_TABLET_OGUID+11, 180436, 1, -6355.86, 1727.92, 15.1053, 5.84685, 0, 0, -0.216439, 0.976296, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@TWILIGHT_TABLET_OGUID+12, 180436, 1, -6268.7, 1767.91, 6.55819, 4.18879, 0, 0, -0.866025, 0.500001, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@TWILIGHT_TABLET_OGUID+13, 180583, 1, -6268.7, 1767.91, 6.55819, 4.18879, 0, 0, -0.866025, 0.500001, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@TWILIGHT_TABLET_OGUID+14, 180583, 1, -6446.85, 1861.94, 5.63745, 2.32129, 0, 0, 0.91706, 0.39875, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@TWILIGHT_TABLET_OGUID+15, 180583, 1, -6355.86, 1727.92, 15.1053, 5.84685, 0, 0, -0.216439, 0.976296, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@TWILIGHT_TABLET_OGUID+16, 180583, 1, -6446.85, 1861.94, 5.63745, 2.32129, 0, 0, 0.91706, 0.39875, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@TWILIGHT_TABLET_OGUID+17, 180583, 1, -6355.86, 1727.92, 15.1053, 5.84685, 0, 0, -0.216439, 0.976296, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@TWILIGHT_TABLET_OGUID+18, 180583, 1, -6268.7, 1767.91, 6.55819, 4.18879, 0, 0, -0.866025, 0.500001, 300, 300, 100, 1, 0, 0, 0, 10);
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 180, `spawntimesecsmax` = 300 , `patch_min` = 6 WHERE `id` IN (180501, 180436, 180583);
|
|
|
|
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_min`, `patch_max`) VALUES
|
|
(@TWILIGHT_TABLET_POOL_TEMPLATE+1, 1, 'Silithus - Twilight Tablet Fragment', 6, 10),
|
|
(@TWILIGHT_TABLET_POOL_TEMPLATE+2, 1, 'Silithus - Twilight Tablet Fragment', 6, 10),
|
|
(@TWILIGHT_TABLET_POOL_TEMPLATE+3, 1, 'Silithus - Twilight Tablet Fragment', 6, 10),
|
|
(@TWILIGHT_TABLET_POOL_TEMPLATE+4, 1, 'Silithus - Twilight Tablet Fragment', 6, 10),
|
|
(@TWILIGHT_TABLET_POOL_TEMPLATE+5, 1, 'Silithus - Twilight Tablet Fragment', 6, 10),
|
|
(@TWILIGHT_TABLET_POOL_TEMPLATE+6, 1, 'Silithus - Twilight Tablet Fragment', 6, 10);
|
|
|
|
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_min`, `patch_max`) VALUES
|
|
(@TWILIGHT_TABLET_OGUID+1, @TWILIGHT_TABLET_POOL_TEMPLATE+1, 'Silithus - Twilight Tablet Fragment', 6, 10),
|
|
(@TWILIGHT_TABLET_OGUID+2, @TWILIGHT_TABLET_POOL_TEMPLATE+2, 'Silithus - Twilight Tablet Fragment', 6, 10),
|
|
(@TWILIGHT_TABLET_OGUID+3, @TWILIGHT_TABLET_POOL_TEMPLATE+3, 'Silithus - Twilight Tablet Fragment', 6, 10),
|
|
(@TWILIGHT_TABLET_OGUID+4, @TWILIGHT_TABLET_POOL_TEMPLATE+4, 'Silithus - Twilight Tablet Fragment', 6, 10),
|
|
(@TWILIGHT_TABLET_OGUID+5, @TWILIGHT_TABLET_POOL_TEMPLATE+5, 'Silithus - Twilight Tablet Fragment', 6, 10),
|
|
(@TWILIGHT_TABLET_OGUID+6, @TWILIGHT_TABLET_POOL_TEMPLATE+6, 'Silithus - Twilight Tablet Fragment', 6, 10),
|
|
(@TWILIGHT_TABLET_OGUID+7, @TWILIGHT_TABLET_POOL_TEMPLATE+1, 'Silithus - Twilight Tablet Fragment', 6, 10),
|
|
(@TWILIGHT_TABLET_OGUID+8, @TWILIGHT_TABLET_POOL_TEMPLATE+2, 'Silithus - Twilight Tablet Fragment', 6, 10),
|
|
(@TWILIGHT_TABLET_OGUID+9, @TWILIGHT_TABLET_POOL_TEMPLATE+3, 'Silithus - Twilight Tablet Fragment', 6, 10),
|
|
(@TWILIGHT_TABLET_OGUID+10, @TWILIGHT_TABLET_POOL_TEMPLATE+4, 'Silithus - Twilight Tablet Fragment', 6, 10),
|
|
(@TWILIGHT_TABLET_OGUID+11, @TWILIGHT_TABLET_POOL_TEMPLATE+5, 'Silithus - Twilight Tablet Fragment', 6, 10),
|
|
(@TWILIGHT_TABLET_OGUID+12, @TWILIGHT_TABLET_POOL_TEMPLATE+6, 'Silithus - Twilight Tablet Fragment', 6, 10);
|
|
|
|
-- ---------------------------------------------------------------------------------------------------------------------------
|
|
-- Supply Crate
|
|
SET @SUPPLY_CRATE_OGUID = 4893;
|
|
SET @SUPPLY_CRATE_POOL_TEMPLATE = 2218;
|
|
|
|
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
|
|
(@SUPPLY_CRATE_OGUID+1, 176224, 329, 3454.34, -3363.78, 141.026, 6.07375, 0, 0, -0.104528, 0.994522, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+2, 176224, 329, 3524.34, -3296.48, 132.186, 6.05629, 0, 0, -0.113203, 0.993572, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+3, 176224, 329, 3528.21, -3351.28, 132.597, 5.91667, 0, 0, -0.182235, 0.983255, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+4, 176224, 329, 3569.1, -3357.61, 131.154, 2.26893, 0, 0, 0.906307, 0.422619, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+5, 176224, 329, 3640.21, -3496.79, 136.441, 1.97222, 0, 0, 0.833885, 0.551938, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+6, 176224, 329, 3678.94, -3478.72, 136.502, 4.57276, 0, 0, -0.754709, 0.656059, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+7, 176224, 329, 3696.97, -3298.02, 128.992, 2.79252, 0, 0, 0.984807, 0.173652, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+8, 176224, 329, 3734.02, -3251.49, 129.542, 4.18879, 0, 0, -0.866025, 0.500001, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+9, 176224, 329, 3830.18, -3577.71, 144.922, 5.63741, 0, 0, -0.317305, 0.948324, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+10, 176224, 329, 3981.9, -3359.74, 119.357, 0.890117, 0, 0, 0.430511, 0.902586, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+11, 176304, 329, 3454.34, -3363.78, 141.026, 6.07375, 0, 0, -0.104528, 0.994522, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+12, 176304, 329, 3524.34, -3296.48, 132.186, 6.05629, 0, 0, -0.113203, 0.993572, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+13, 176304, 329, 3528.21, -3351.28, 132.597, 5.91667, 0, 0, -0.182235, 0.983255, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+14, 176304, 329, 3569.1, -3357.61, 131.154, 2.26893, 0, 0, 0.906307, 0.422619, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+15, 176304, 329, 3640.21, -3496.79, 136.441, 1.97222, 0, 0, 0.833885, 0.551938, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+16, 176304, 329, 3678.94, -3478.72, 136.502, 4.57276, 0, 0, -0.754709, 0.656059, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+17, 176304, 329, 3696.97, -3298.02, 128.992, 2.79252, 0, 0, 0.984807, 0.173652, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+18, 176304, 329, 3734.02, -3251.49, 129.542, 4.18879, 0, 0, -0.866025, 0.500001, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+19, 176304, 329, 3830.18, -3577.71, 144.922, 5.63741, 0, 0, -0.317305, 0.948324, 300, 300, 100, 1, 0, 0, 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+20, 176304, 329, 3981.9, -3359.74, 119.357, 0.890117, 0, 0, 0.430511, 0.902586, 300, 300, 100, 1, 0, 0, 0, 10);
|
|
UPDATE `gameobject` SET `spawntimesecsmin` = 10800, `spawntimesecsmax` = 10800 WHERE `id` IN (176224, 176304);
|
|
|
|
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_min`, `patch_max`) VALUES
|
|
(@SUPPLY_CRATE_POOL_TEMPLATE+1, 1, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_POOL_TEMPLATE+2, 1, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_POOL_TEMPLATE+3, 1, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_POOL_TEMPLATE+4, 1, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_POOL_TEMPLATE+5, 1, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_POOL_TEMPLATE+6, 1, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_POOL_TEMPLATE+7, 1, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_POOL_TEMPLATE+8, 1, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_POOL_TEMPLATE+9, 1, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_POOL_TEMPLATE+10, 1, 'Stratholme - Supply Crate', 0, 10);
|
|
|
|
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_min`, `patch_max`) VALUES
|
|
(@SUPPLY_CRATE_OGUID+1, @SUPPLY_CRATE_POOL_TEMPLATE+1, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+2, @SUPPLY_CRATE_POOL_TEMPLATE+2, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+3, @SUPPLY_CRATE_POOL_TEMPLATE+3, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+4, @SUPPLY_CRATE_POOL_TEMPLATE+4, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+5, @SUPPLY_CRATE_POOL_TEMPLATE+5, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+6, @SUPPLY_CRATE_POOL_TEMPLATE+6, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+7, @SUPPLY_CRATE_POOL_TEMPLATE+7, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+8, @SUPPLY_CRATE_POOL_TEMPLATE+8, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+9, @SUPPLY_CRATE_POOL_TEMPLATE+9, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+10, @SUPPLY_CRATE_POOL_TEMPLATE+10, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+11, @SUPPLY_CRATE_POOL_TEMPLATE+1, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+12, @SUPPLY_CRATE_POOL_TEMPLATE+2, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+13, @SUPPLY_CRATE_POOL_TEMPLATE+3, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+14, @SUPPLY_CRATE_POOL_TEMPLATE+4, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+15, @SUPPLY_CRATE_POOL_TEMPLATE+5, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+16, @SUPPLY_CRATE_POOL_TEMPLATE+6, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+17, @SUPPLY_CRATE_POOL_TEMPLATE+7, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+18, @SUPPLY_CRATE_POOL_TEMPLATE+8, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+19, @SUPPLY_CRATE_POOL_TEMPLATE+9, 'Stratholme - Supply Crate', 0, 10),
|
|
(@SUPPLY_CRATE_OGUID+20, @SUPPLY_CRATE_POOL_TEMPLATE+10, 'Stratholme - Supply Crate', 0, 10);
|
|
|
|
UPDATE `pool_template` SET `description` = 'Stratholme - Supply Crate' WHERE `description` LIKE 'Strat : Supply Crate';
|
|
UPDATE `pool_gameobject` SET `description` = 'Stratholme - Supply Crate' WHERE `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` IN (176224, 176304));
|
|
|
|
-- Remove Custom Objects
|
|
DELETE FROM `gameobject` WHERE `guid` IN (25689, 25690, 25691, 25692, 25693, 25694, 25695, 25696, 25697);
|
|
|
|
-- ---------------------------------------------------------------------------------------------------------------------------
|
|
-- Blood of Heroes Traps
|
|
DELETE FROM `gameobject` WHERE `id` = 176214;
|
|
SET @BLOOD_OGUID = 25343;
|
|
|
|
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
|
|
(@BLOOD_OGUID+1, 176214, 0, 1158.57, -2524.99, 60.7516, 5.68977, 0, 0, -0.292372, 0.956305, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+2, 176214, 0, 1255.61, -2542.98, 91.9354, 4.38078, 0, 0, -0.814116, 0.580703, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+3, 176214, 0, 1272.58, -1328.58, 61.8975, 1.43117, 0, 0, 0.656058, 0.75471, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+4, 176214, 0, 1291.94, -2565.15, 111.522, 5.65487, 0, 0, -0.309016, 0.951057, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+5, 176214, 0, 1316.47, -1556.38, 59.4179, 3.59538, 0, 0, -0.97437, 0.224951, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+6, 176214, 0, 1342.56, -1382.57, 46.8919, 2.77507, 0, 0, 0.983254, 0.182238, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+7, 176214, 0, 1347.86, -1459.98, 55.7871, 1.78023, 0, 0, 0.777145, 0.629321, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+8, 176214, 0, 1362.11, -1630.07, 59.961, 2.16421, 0, 0, 0.882947, 0.469473, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+9, 176214, 0, 1439.4, -1602.93, 69.5607, 4.53786, 0, 0, -0.766044, 0.642789, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+10, 176214, 0, 1519.32, -3125.21, 94.4552, 4.7473, 0, 0, -0.694658, 0.71934, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+11, 176214, 0, 1523.33, -1864.1, 59.6097, 4.20625, 0, 0, -0.861628, 0.507539, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+12, 176214, 0, 1529.1, -1427.07, 65.4905, 3.28124, 0, 0, -0.997563, 0.0697661, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+13, 176214, 0, 1585.51, -1368.17, 61.8439, 2.79252, 0, 0, 0.984807, 0.173652, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+14, 176214, 0, 1645.17, -710.922, 55.3111, 0.471238, 0, 0, 0.233445, 0.97237, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+15, 176214, 0, 1645.77, -1603.47, 60.6001, 3.64774, 0, 0, -0.968147, 0.250381, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+16, 176214, 0, 1647.9, -4851.16, 83.1653, 1.22173, 0, 0, 0.573576, 0.819152, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+17, 176214, 0, 1682.93, -715.297, 57.6902, 2.44346, 0, 0, 0.939692, 0.342021, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+18, 176214, 0, 1685.58, -4392.08, 85.6462, 3.9619, 0, 0, -0.91706, 0.39875, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+19, 176214, 0, 1704.41, -2287.1, 58.9413, 5.044, 0, 0, -0.580703, 0.814116, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+20, 176214, 0, 1705.87, -4690.14, 48.9742, 3.194, 0, 0, -0.999657, 0.0262017, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+21, 176214, 0, 1712.2, -4920.21, 88.717, 5.32326, 0, 0, -0.461748, 0.887011, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+22, 176214, 0, 1715.69, -4480.84, 67.4628, 5.91667, 0, 0, -0.182235, 0.983255, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+23, 176214, 0, 1717.72, -4847.89, 92.5366, 2.9845, 0, 0, 0.996917, 0.0784664, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+24, 176214, 0, 1728.41, -3505.18, 127.253, 4.39823, 0, 0, -0.809016, 0.587786, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+25, 176214, 0, 1735.69, -4043.83, 116.128, 4.24115, 0, 0, -0.85264, 0.522499, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+26, 176214, 0, 1743.36, -4438.29, 75.404, 4.60767, 0, 0, -0.743144, 0.669132, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+27, 176214, 0, 1748.16, -4453.13, 74.2627, 4.2237, 0, 0, -0.857167, 0.515038, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+28, 176214, 0, 1752.84, -1230.89, 59.5544, 0.383971, 0, 0, 0.190808, 0.981627, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+29, 176214, 0, 1767.21, -3318.95, 102.464, 1.88495, 0, 0, 0.809016, 0.587786, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+30, 176214, 0, 1774.23, -4839.8, 91.5816, 2.53072, 0, 0, 0.953716, 0.300708, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+31, 176214, 0, 1775.12, -4981.49, 81.9896, 4.34587, 0, 0, -0.824126, 0.566406, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+32, 176214, 0, 1805.73, -4136.94, 94.758, 6.05629, 0, 0, -0.113203, 0.993572, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+33, 176214, 0, 1810.65, -5022.19, 87.7992, 0.977383, 0, 0, 0.469471, 0.882948, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+34, 176214, 0, 1817.98, -3521.61, 115.267, 0.767944, 0, 0, 0.374606, 0.927184, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+35, 176214, 0, 1819.29, -5033.22, 88.9647, 1.78023, 0, 0, 0.777145, 0.629321, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+36, 176214, 0, 1823.8, -2462.23, 70.696, 5.88176, 0, 0, -0.199367, 0.979925, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+37, 176214, 0, 1827.28, -1151.05, 60.2813, 4.25861, 0, 0, -0.848047, 0.529921, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+38, 176214, 0, 1832.8, -4419.21, 82.5971, 0.802851, 0, 0, 0.390731, 0.920505, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+39, 176214, 0, 1832.91, -4374.04, 98.3339, 5.75959, 0, 0, -0.258819, 0.965926, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+40, 176214, 0, 1836.91, -4485.1, 74.0769, 4.83456, 0, 0, -0.66262, 0.748956, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+41, 176214, 0, 1837.05, -1499.49, 59.576, 3.22886, 0, 0, -0.999048, 0.0436193, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+42, 176214, 0, 1843.96, -3573.16, 113.492, 3.4383, 0, 0, -0.989016, 0.147811, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+43, 176214, 0, 1846.79, -3825.26, 135.516, 1.83259, 0, 0, 0.793353, 0.608762, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+44, 176214, 0, 1851.85, -3232.37, 120.889, 0.418879, 0, 0, 0.207912, 0.978148, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+45, 176214, 0, 1870.01, -3988.17, 118.568, 0.174532, 0, 0, 0.0871553, 0.996195, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+46, 176214, 0, 1876.01, -4825.2, 110.012, 4.06662, 0, 0, -0.894934, 0.446199, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+47, 176214, 0, 1893.23, -3021.16, 75.1837, 4.13643, 0, 0, -0.878817, 0.47716, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+48, 176214, 0, 1904.08, -1558.72, 59.0984, 0.157079, 0, 0, 0.0784588, 0.996917, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+49, 176214, 0, 1926.66, -5152.06, 73.8904, 3.90954, 0, 0, -0.927183, 0.374608, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+50, 176214, 0, 1945.21, -4410.99, 73.8827, 1.29154, 0, 0, 0.601814, 0.798636, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+51, 176214, 0, 1958.33, -2538.91, 60.0859, 5.21854, 0, 0, -0.507538, 0.861629, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+52, 176214, 0, 1966.18, -3421.72, 102.484, 5.67232, 0, 0, -0.300705, 0.953717, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+53, 176214, 0, 1968.91, -2337.35, 59.4301, 2.74016, 0, 0, 0.979924, 0.19937, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+54, 176214, 0, 1975.99, -3610.4, 123.424, 1.41372, 0, 0, 0.649447, 0.760406, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+55, 176214, 0, 1980.38, -4824.86, 93.1408, 0.157079, 0, 0, 0.0784588, 0.996917, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+56, 176214, 0, 1987.43, -4193.23, 11.9173, 2.11185, 0, 0, 0.870356, 0.492424, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+57, 176214, 0, 1990.55, -4574.74, 73.6202, 3.73501, 0, 0, -0.956305, 0.292372, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+58, 176214, 0, 2006.68, -3222.05, 87.8593, 5.37562, 0, 0, -0.438371, 0.898794, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+59, 176214, 0, 2009.14, -4917.6, 75.2411, 3.21142, 0, 0, -0.999391, 0.0349061, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+60, 176214, 0, 2037.1, -3642.15, 129.079, 1.67551, 0, 0, 0.743144, 0.669132, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+61, 176214, 0, 2051.18, -3508.75, 118.566, 2.67035, 0, 0, 0.972369, 0.233448, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+62, 176214, 0, 2056.86, -4507.48, 75.1407, 1.32645, 0, 0, 0.615661, 0.788011, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+63, 176214, 0, 2073.66, -4801.67, 75.0358, 1.93731, 0, 0, 0.824125, 0.566408, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+64, 176214, 0, 2075.36, -2980.35, 92.3482, 0.279252, 0, 0, 0.139173, 0.990268, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+65, 176214, 0, 2105.13, -3619.1, 154.126, 2.11185, 0, 0, 0.870356, 0.492424, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+66, 176214, 0, 2107.76, -3381.77, 128.112, 5.09636, 0, 0, -0.559193, 0.829038, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+67, 176214, 0, 2125.75, -4448.22, 79.7199, 1.88495, 0, 0, 0.809016, 0.587786, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+68, 176214, 0, 2127.15, -2736.77, 75.9159, 4.60767, 0, 0, -0.743144, 0.669132, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+69, 176214, 0, 2151.04, -4364.23, 74.3176, 5.2709, 0, 0, -0.484809, 0.87462, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+70, 176214, 0, 2160.74, -5239.59, 87.3113, 3.14159, 0, 0, -1, 0, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+71, 176214, 0, 2280.91, -5077.04, 60.3079, 3.45576, 0, 0, -0.987688, 0.156436, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+72, 176214, 0, 2286.68, -4329.51, 74.6104, 0.628317, 0, 0, 0.309016, 0.951057, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+73, 176214, 0, 2318.73, -5221.68, 84.4021, 5.41052, 0, 0, -0.422618, 0.906308, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+74, 176214, 0, 2373.09, -5115.45, 77.1424, 4.85202, 0, 0, -0.656058, 0.75471, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+75, 176214, 0, 2407.17, -3680.37, 179.74, 5.14872, 0, 0, -0.537299, 0.843392, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+76, 176214, 0, 2484.38, -5041.04, 74.0957, 1.81514, 0, 0, 0.788011, 0.615662, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+77, 176214, 0, 2489.19, -4253.27, 77.3425, 4.71239, 0, 0, -0.707107, 0.707107, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+78, 176214, 0, 2494.31, -5134.04, 75.2775, 3.9619, 0, 0, -0.91706, 0.39875, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+79, 176214, 0, 3112.6, -3688.04, 134.408, 3.194, 0, 0, -0.999657, 0.0262017, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+80, 176214, 0, 3131.49, -3521.91, 154.185, 5.21854, 0, 0, -0.507538, 0.861629, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+81, 176214, 0, 2412.71, -1721.56, 107.006, 2.89725, 0, 0, 0.992546, 0.121869, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+82, 176214, 0, 1791.37, -1834.49, 61.1652, 3.14159, 0, 0, 1, 0, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+83, 176214, 0, 2192.74, -4479.21, 87.66, 3.03687, 0, 0, 0.99863, 0.052336, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+84, 176214, 0, 2958.04, -3485.06, 146.222, -3.00197, 0, 0, 0.997564, -0.069756, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+85, 176214, 0, 2144.03, -3241.36, 112.884, -1.74533, 0, 0, 0.766044, -0.642788, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+86, 176214, 0, 2888.38, -4086.29, 101.381, -2.19912, 0, 0, 0.891007, -0.45399, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+87, 176214, 0, 1873.27, -3189.56, 128.554, 0.15708, 0, 0, 0.078459, 0.996917, 7200, 7200, 100, 1, 12, 0, 0, 10),
|
|
(@BLOOD_OGUID+88, 176214, 0, 2115.7, -4691.12, 74.3362, 1.15192, 0, 0, 0.544639, 0.838671, 7200, 7200, 100, 1, 12, 0, 0, 10);
|
|
UPDATE `gameobject` SET `spawn_flags` = 0 WHERE `id` IN (176213, 176214);
|
|
|
|
-- ---------------------------------------------------------------------------------------------------------------------------
|
|
-- Correct max limit for pool 1090
|
|
UPDATE `pool_template` SET `max_limit` = 24 WHERE `entry` = 1090;
|
|
|
|
-- ---------------------------------------------------------------------------------------------------------------------------
|
|
-- Update Pool Description
|
|
UPDATE `pool_pool` SET `description` = 'Arathi Highlands - Tin Vein / Silver Vein' WHERE `pool_id` = 21664;
|
|
|
|
-- ---------------------------------------------------------------------------------------------------------------------------
|
|
-- Pool Laden Mushrooms Correctly
|
|
DELETE FROM `pool_template` WHERE `entry` = 1615;
|
|
DELETE FROM `pool_gameobject_template` WHERE `pool_entry` = 1615;
|
|
|
|
-- Lushwater Oasis
|
|
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_max`) VALUES
|
|
(299, 9, 'The Barrens - Lushwater Oasis - Laden Mushroom', 10);
|
|
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_max`) VALUES
|
|
(13191, 299, 'The Barrens - Lushwater Oasis - Laden Mushroom', 10),
|
|
(13192, 299, 'The Barrens - Lushwater Oasis - Laden Mushroom', 10),
|
|
(13198, 299, 'The Barrens - Lushwater Oasis - Laden Mushroom', 10),
|
|
(13200, 299, 'The Barrens - Lushwater Oasis - Laden Mushroom', 10),
|
|
(13204, 299, 'The Barrens - Lushwater Oasis - Laden Mushroom', 10),
|
|
(13205, 299, 'The Barrens - Lushwater Oasis - Laden Mushroom', 10),
|
|
(13235, 299, 'The Barrens - Lushwater Oasis - Laden Mushroom', 10),
|
|
(13236, 299, 'The Barrens - Lushwater Oasis - Laden Mushroom', 10),
|
|
(25611, 299, 'The Barrens - Lushwater Oasis - Laden Mushroom', 10),
|
|
(25613, 299, 'The Barrens - Lushwater Oasis - Laden Mushroom', 10),
|
|
(25615, 299, 'The Barrens - Lushwater Oasis - Laden Mushroom', 10),
|
|
(25618, 299, 'The Barrens - Lushwater Oasis - Laden Mushroom', 10),
|
|
(25622, 299, 'The Barrens - Lushwater Oasis - Laden Mushroom', 10),
|
|
(25623, 299, 'The Barrens - Lushwater Oasis - Laden Mushroom', 10),
|
|
(25625, 299, 'The Barrens - Lushwater Oasis - Laden Mushroom', 10),
|
|
(25626, 299, 'The Barrens - Lushwater Oasis - Laden Mushroom', 10),
|
|
(25627, 299, 'The Barrens - Lushwater Oasis - Laden Mushroom', 10),
|
|
(25628, 299, 'The Barrens - Lushwater Oasis - Laden Mushroom', 10);
|
|
|
|
-- Stagnant Oasis
|
|
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_max`) VALUES
|
|
(324, 7, 'The Barrens - Stagnant Oasis - Laden Mushroom', 10);
|
|
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_max`) VALUES
|
|
(13194, 324, 'The Barrens - Stagnant Oasis - Laden Mushroom', 10),
|
|
(13196, 324, 'The Barrens - Stagnant Oasis - Laden Mushroom', 10),
|
|
(13206, 324, 'The Barrens - Stagnant Oasis - Laden Mushroom', 10),
|
|
(13207, 324, 'The Barrens - Stagnant Oasis - Laden Mushroom', 10),
|
|
(13241, 324, 'The Barrens - Stagnant Oasis - Laden Mushroom', 10),
|
|
(13242, 324, 'The Barrens - Stagnant Oasis - Laden Mushroom', 10),
|
|
(25612, 324, 'The Barrens - Stagnant Oasis - Laden Mushroom', 10),
|
|
(25614, 324, 'The Barrens - Stagnant Oasis - Laden Mushroom', 10),
|
|
(25629, 324, 'The Barrens - Stagnant Oasis - Laden Mushroom', 10),
|
|
(25631, 324, 'The Barrens - Stagnant Oasis - Laden Mushroom', 10),
|
|
(25632, 324, 'The Barrens - Stagnant Oasis - Laden Mushroom', 10),
|
|
(25633, 324, 'The Barrens - Stagnant Oasis - Laden Mushroom', 10),
|
|
(25634, 324, 'The Barrens - Stagnant Oasis - Laden Mushroom', 10);
|
|
|
|
-- Forgotten Pools
|
|
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_max`) VALUES
|
|
(327, 7, 'The Barrens - Forgoten Pools - Laden Mushroom', 10);
|
|
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
|
|
(127, 3640, 1, 21.8035, -1891.34, 88.906, 1.91986, 0, 0, 0.819152, 0.573577, 300, 300, 100, 1, 0, 0, 0, 10);
|
|
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_max`) VALUES
|
|
(13201, 327, 'The Barrens - Forgoten Pools - Laden Mushroom', 10),
|
|
(13202, 327, 'The Barrens - Forgoten Pools - Laden Mushroom', 10),
|
|
(13237, 327, 'The Barrens - Forgoten Pools - Laden Mushroom', 10),
|
|
(13243, 327, 'The Barrens - Forgoten Pools - Laden Mushroom', 10),
|
|
(13244, 327, 'The Barrens - Forgoten Pools - Laden Mushroom', 10),
|
|
(13251, 327, 'The Barrens - Forgoten Pools - Laden Mushroom', 10),
|
|
(25616, 327, 'The Barrens - Forgoten Pools - Laden Mushroom', 10),
|
|
(25617, 327, 'The Barrens - Forgoten Pools - Laden Mushroom', 10),
|
|
(25619, 327, 'The Barrens - Forgoten Pools - Laden Mushroom', 10),
|
|
(25620, 327, 'The Barrens - Forgoten Pools - Laden Mushroom', 10),
|
|
(25621, 327, 'The Barrens - Forgoten Pools - Laden Mushroom', 10),
|
|
(25624, 327, 'The Barrens - Forgoten Pools - Laden Mushroom', 10),
|
|
(25630, 327, 'The Barrens - Forgoten Pools - Laden Mushroom', 10),
|
|
(127, 327, 'The Barrens - Forgoten Pools - Laden Mushroom', 10);
|
|
|
|
-- ---------------------------------------------------------------------------------------------------------------------------
|
|
|
|
-- Pool Cortello's Riddle Correctly
|
|
DELETE FROM `pool_template` WHERE `entry` = 1336;
|
|
DELETE FROM `pool_gameobject_template` WHERE `pool_entry` = 1336;
|
|
|
|
-- Ship 1
|
|
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
|
|
(129, 2554, 0, -14938, 351.788, 7.5324, 5.39307, 0, 0, -0.430511, 0.902586, 300, 300, 100, 1, 0, 0, 0, 10);
|
|
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_max`) VALUES
|
|
(332, 1, 'Stranglethorn Vale - Ship 1 - Cortello\'s Riddle', 10);
|
|
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_max`) VALUES
|
|
(11133, 332, 'Stranglethorn Vale - Ship 1 - Cortello\'s Riddle', 10),
|
|
(26044, 332, 'Stranglethorn Vale - Ship 1 - Cortello\'s Riddle', 10),
|
|
(26045, 332, 'Stranglethorn Vale - Ship 1 - Cortello\'s Riddle', 10),
|
|
(129, 332, 'Stranglethorn Vale - Ship 1 - Cortello\'s Riddle', 10);
|
|
|
|
-- Ship 2
|
|
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_max`) VALUES
|
|
(335, 1, 'Stranglethorn Vale - Ship 2 - Cortello\'s Riddle', 10);
|
|
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_max`) VALUES
|
|
(12172, 335, 'Stranglethorn Vale - Ship 2 - Cortello\'s Riddle', 10),
|
|
(26042, 335, 'Stranglethorn Vale - Ship 2 - Cortello\'s Riddle', 10),
|
|
(26043, 335, 'Stranglethorn Vale - Ship 2 - Cortello\'s Riddle', 10);
|
|
|
|
-- Ship 3
|
|
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`, `patch_max`) VALUES
|
|
(398, 1, 'Stranglethorn Vale - Ship 3 - Cortello\'s Riddle', 10);
|
|
INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `description`, `patch_max`) VALUES
|
|
(11652, 398, 'Stranglethorn Vale - Ship 3 - Cortello\'s Riddle', 10),
|
|
(26046, 398, 'Stranglethorn Vale - Ship 3 - Cortello\'s Riddle', 10),
|
|
(26047, 398, 'Stranglethorn Vale - Ship 3 - Cortello\'s Riddle', 10);
|
|
|
|
-- ---------------------------------------------------------------------------------------------------------------------------
|
|
|
|
-- Corrections to Dunemaul Compound
|
|
UPDATE `creature` SET `id` = 5472, `id2` = 5474 WHERE `id` = 5474;
|
|
UPDATE `creature` SET `id` = 5472, `id2` = 5474 WHERE `id` = 5472;
|
|
UPDATE `creature` SET `id` = 5472, `id2` = 5474, `movement_type` = 1, `wander_distance` = 2 WHERE `guid` IN (
|
|
23193,
|
|
23156,
|
|
23196,
|
|
23157,
|
|
23194,
|
|
23182,
|
|
23172,
|
|
23154,
|
|
23153,
|
|
23183,
|
|
23184,
|
|
23137,
|
|
23186,
|
|
23141,
|
|
23170,
|
|
23177,
|
|
23147,
|
|
23169,
|
|
23143,
|
|
23175,
|
|
23146,
|
|
23144,
|
|
23151,
|
|
23145,
|
|
23149,
|
|
23148);
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
delimiter ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|