diff options
author | Killyana <morphone1@gmail.com> | 2018-06-13 15:31:12 +0200 |
---|---|---|
committer | Killyana <morphone1@gmail.com> | 2018-06-13 15:31:12 +0200 |
commit | 0a0ae6b88d270ec3ebd45d1c18500fe97e3f4417 (patch) | |
tree | 7a9d9ac87828b5be4d31e2f79a9055b159653f87 | |
parent | a6f91c9b81baf68ce246ff8bdce1a3a2c340cc02 (diff) |
DB/Misc: Move Acherus spawns to the correct range and fix some DB errors
-rw-r--r-- | sql/updates/world/master/2018_06_13_00_world.sql | 422 |
1 files changed, 422 insertions, 0 deletions
diff --git a/sql/updates/world/master/2018_06_13_00_world.sql b/sql/updates/world/master/2018_06_13_00_world.sql new file mode 100644 index 00000000000..fa769c0ee23 --- /dev/null +++ b/sql/updates/world/master/2018_06_13_00_world.sql @@ -0,0 +1,422 @@ +-- +DELETE FROM `gameobject` WHERE `guid` IN (63177, 63178, 63179, 63183, 63184, 63185, 63188, 63189, 63191, 63192, 63193, 66392, 66403, 66405, 151238,151236,66421, 66423, 66475, 66476, 1484); +INSERT INTO `gameobject` (`guid`, id, `map`, zoneId, areaId, PhaseId, spawnMask, position_x, position_y, position_z, orientation, rotation0, rotation1, rotation2, rotation3, spawntimesecs, animprogress, `state`, ScriptName, VerifiedBuild) VALUES +(63177, 191746, 0, 139, 4281, 389,1, 2493.37, -5642.43, 420.863, 2.16421, 0, 0, 0.882948, 0.469471, 180, 100, 0,"", 0), +(63178, 191747, 0, 139, 4281, 389,1, 2427.28, -5544.45, 420.863, -0.983229, 0, 0, -0.47205, 0.881572, 180, 100, 0,"", 0), +(63179, 191748, 0, 139, 4281, 389,1, 2509.31, -5560.39, 420.863, -2.55402, 0, 0, -0.957154, 0.289578, 180, 100, 0,"", 0), +(63183, 191506, 0, 139, 4281, 389,1, 2428.09, -5648.83, 420.632, -0.154183, 0, 0, -0.0770152, 0.99703, 180, 100, 0,"", 0), +(63184, 191507, 0, 139, 4281, 389,1, 2429.86, -5639.13, 420.674, -0.241448, 0, 0, -0.120431, 0.992722, 180, 100, 0,"", 0), +(63185, 191508, 0, 139, 4281, 389,1, 2438.34, -5655.61, 420.543, -1.67387, 0, 0, -0.742594, 0.669742, 180, 100, 0,"", 0), +(63188, 191540, 0, 139, 4281, 169,1, 2400.86, -5563.21, 420.702, 2.35874, 0, 0, 0.924366, 0.381507, 180, 100, 0,"", 0), +(63189, 191541, 0, 139, 4281, 169,1, 2404.43, -5559.71, 420.702, -1.95786, 0, 0, -0.829901, 0.557911, 180, 100, 0,"", 0), +(63191, 190557, 0, 139, 4281, 389,1, 2493.01, -5641.83, 420.644, 1.85005, 0, 0, 0.798636, 0.601815, 180, 100, 0,"", 0), +(63192, 190557, 0, 139, 4281, 389,1, 2508.75, -5560.79, 420.644, -1.09956, 0, 0, -0.5225, 0.852639, 180, 100, 0,"", 0), +(63193, 190557, 0, 139, 4281, 169,1, 2411.87, -5626.11, 420.644, 0.296705, 0, 0, 0.147809, 0.989016, 180, 100, 0,"", 0), +(66392, 191503, 0, 139, 4281, 389,1, 2471.9, -5651.71, 420.614, 2.55691, 0, 0, 0.957572, 0.288195, 180, 0, 1, "", 0), +(66403, 193052, 0, 139, 4281, 177,1, 2348.1, -5695.95, 382.241, 0.680677, 0, 0, 0.333806, 0.942642, 180, 0, 1, "", 0), +(66405, 193053, 0, 139, 4281, 177,1, 2324.41, -5659.86, 382.241, 0.645772, 0, 0, 0.317305, 0.948324, 180, 0, 1, "", 0), +(151238, 191538, 0, 139, 4281, 389,1, 2390.02, -5640.91, 377.093, 0.59341, 0, 0, 0.292371, 0.956305, 180, 0, 0,"", 0), +(151236, 191539, 0, 139, 4281, 389,1, 2383.65, -5645.2, 420.772, 0.59341, 0, 0, 0.292371, 0.956305, 180, 0, 0,"", 0), +(66421, 191540, 0, 139, 4281, 175,1, 2400.86, -5563.21, 420.702, 2.35874, 0, 0, 0.924366, 0.381507, 180, 0, 1, "", 0), +(66423, 191541, 0, 139, 4281, 175,1, 2404.43, -5559.71, 420.702, -1.95786, 0, 0, -0.829901, 0.557911, 180, 0, 1, "", 0), +(66475, 190557, 0, 139, 4281, 175,1, 2411.87, -5626.11, 420.644, 0.296705, 0, 0, 0.147809, 0.989016, 180, 0, 1, "", 0), +(66476, 190557, 0, 139, 4281, 389,1, 2427.61, -5544.96, 420.644, -2.30383, 0, 0, -0.913544, 0.406739, 180, 0, 1, "", 0), +(1484, 191206, 0, 139, 4281, 389,1, 2460.06, -5593.7, 367.394, 0.556369, 0, 0, 0.27461, 0.961556, 180, 255, 1, "", 0); + +DELETE FROM `gameobject_addon` WHERE `guid` IN (63177, 63178, 63179, 63183, 63184, 63185, 63188, 63189, 63191, 63192, 63193, 66392, 66403, 66405, 151238,151236,66421, 66423, 66475, 66476, 1484); +INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`, `invisibilityType`, `invisibilityValue`) VALUES +(63177, 0, 0, 0.292372, 0.956305, 0, 0), +(63178, 0, 0, 0.292372, 0.956305, 0, 0), +(63179, 0, 0, 0.292372, 0.956305, 0, 0), +(63183, 0, 0, 0.292372, 0.956305, 0, 0), +(63184, 0, 0, 0.292372, 0.956305, 0, 0), +(63185, 0, 0, 0.292372, 0.956305, 0, 0), +(63188, 0, 0, 0.292372, 0.956305, 0, 0), +(63189, 0, 0, 0.292372, 0.956305, 0, 0), +(66392, 0, 0, 0.292372, 0.956305, 0, 0), +(151238, 0, 0, 0.292372, 0.956305, 0, 0), +(151236, 0, 0, 0.292372, 0.956305, 0, 0), +(66421, 0, 0, 0.292372, 0.956305, 0, 0), +(66423, 0, 0, 0.292372, 0.956305, 0, 0); + +DELETE FROM `creature` WHERE `guid` IN (125641,125642,125651,125712,125713,125714,125715,125716,125717,125718,125719,125721,125722,125723,125724,125725,125726,125727,125728,125729,125730,125731,125732,125733,125734,125735,125736,125737,125738,125739,125740,125741,125742,125743,125744,125745,125746,125747,125748,125749,125750,125751,125752,125753,125754,125755,125756,125757,125758,125759,125760,125761,125762,125766,125767,125768,125769,125770,125771,125772,125773,125774,125775,125776,125777,125778,125779,125780,125781,125782,125783,125784,125785,125786,125787,125788,125789,125790,125791,125792,125793,125794,125795,125796,125797,125798,125799,125800,125801,125802,125803,125804,125805,125806,125807,125808,125809,125810,125811,125812,125813,125814,125815,125816,125817,125818,125819,125820,125821,125822,125823,125824,125825,125826,125827,125828,125829,125830,125831,125832,125833,125834,125835,125836,125837,125838,125839,125840,125841,125842,125843,125844,125845,125846,125847,125848,125849,125851,125852,125853,125854,125855,125856,125857,125858,125859,125860,125861,125862,125863,125864,125865,125866,125867,125868,125869,125870,125871,125872,130431,130432,130433,130468,130469,130470,130471,130472,130473,130474,130475,130476,130477,130478,130479,130480,130481,130482,130483,130484,130485,130486,130487,130488,130490,130491,130493,130494,130495,130496,130497,130498,130499,130500,130501,130502,130503,130504,130505,130506,130507,130508,130511,130512,130513,130515,130516,130517,130519,130521,130522,130524,130525,130526,130527,130528,130530,130531,130532,130535,130536,130537,130539,130542,130545,130546,99790); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `PhaseId`, `spawnMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES +(125641, 29194, 0, 139, 4281, 169, 1, 25468, 0, 2413.92, -5524.47, 377.125, 5.25344, 180, 0, 0, 126000, 0, 0, 0, 0, 0,"" , 0), +(125642, 29195, 0, 139, 4281, 169, 1, 25458, 1, 2506.22, -5663.2, 377.037, 2.23402, 180, 0, 0, 126000, 0, 0, 0, 0, 0,"", 0), +(125651, 29202, 0, 139, 4281, 169, 1, 26001, 1, 2413.87, -5612.36, 420.727, 0.383972, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125712, 29196, 0, 139, 4281, 169, 1, 25459, 0, 2527.73, -5549.21, 377.036, 3.735, 180, 0, 0, 126000, 0, 0, 0, 0, 0,"", 0), +(125713, 29202, 0, 139, 4281, 169, 1, 25999, 1, 2376.21, -5661.79, 382.455, 0.907571, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125714, 29202, 0, 139, 4281, 169, 1, 26000, 1, 2554.67, -5599.88, 444.212, 3.47321, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125715, 29202, 0, 139, 4281, 169, 1, 25998, 1, 2580.04, -5616.82, 444.751, 2.94961, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125716, 29202, 0, 139, 4281, 169, 1, 25998, 1, 2454.24, -5687.68, 444.212, 1.8326, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125717, 29202, 0, 139, 4281, 169, 1, 25998, 1, 2402.12, -5649.42, 377.179, 0.610865, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125718, 29202, 0, 139, 4281, 169, 1, 26000, 1, 2494.95, -5556.85, 420.727, 3.85718, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125719, 29202, 0, 139, 4281, 169, 1, 26001, 1, 2386.51, -5585.67, 376.874, 6.16101, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125721, 29202, 0, 139, 4281, 169, 1, 26001, 1, 2370.31, -5564.29, 444.21, 5.8294, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125722, 29202, 0, 139, 4281, 169, 1, 25998, 1, 2364.88, -5645.58, 382.454, 0.366519, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125723, 29202, 0, 139, 4281, 169, 1, 25999, 1, 2355.41, -5695.45, 382.324, 1.39626, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125724, 29202, 0, 139, 4281, 169, 1, 25998, 1, 2323.35, -5656.07, 383.241, 6.24828, 180, 5, 0, 32385, 21630, 1, 0, 0, 0,"", 0), +(125725, 29202, 0, 139, 4281, 169, 1, 25998, 1, 2346.29, -5691.39, 382.324, 0.733038, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125726, 29202, 0, 139, 4281, 169, 1, 25998, 1, 2325.73, -5663.41, 383.241, 0.383972, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125727, 29202, 0, 139, 4281, 169, 1, 26001, 1, 2388.92, -5573.38, 376.889, 5.98648, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125728, 29202, 0, 139, 4281, 169, 1, 25998, 1, 2455.59, -5656.23, 376.902, 3.11873, 180, 5, 0, 32385, 21630, 1, 0, 0, 0,"", 0), +(125729, 29202, 0, 139, 4281, 169, 1, 26001, 1, 2455.59, -5659.23, 376.903, 3.11851, 180, 5, 0, 32385, 21630, 1, 0, 0, 0,"", 0), +(125730, 29202, 0, 139, 4281, 169, 1, 25999, 1, 2452.52, -5667.42, 376.88, 1.58825, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125731, 29202, 0, 139, 4281, 169, 1, 25998, 1, 2483.65, -5473.94, 444.751, 4.55531, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125732, 29202, 0, 139, 4281, 169, 1, 25999, 1, 2466.96, -5499.02, 444.209, 5.0091, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125733, 29202, 0, 139, 4281, 169, 1, 26000, 1, 2468.4, -5519.7, 376.877, 4.59022, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125734, 29202, 0, 139, 4281, 169, 1, 26001, 1, 2365.64, -5587.08, 444.208, 0.296706, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125735, 29202, 0, 139, 4281, 169, 1, 26000, 1, 2549.99, -5622.68, 444.216, 2.74017, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125736, 29202, 0, 139, 4281, 169, 1, 26000, 1, 2437.19, -5713.14, 444.751, 1.37881, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125737, 29202, 0, 139, 4281, 169, 1, 26001, 1, 2506.97, -5574.87, 420.727, 3.50811, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125738, 29202, 0, 139, 4281, 169, 1, 26001, 1, 2532.16, -5613.79, 376.893, 2.87979, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125739, 29202, 0, 139, 4281, 169, 1, 26001, 1, 2489.26, -5503.9, 444.219, 4.17134, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125740, 29202, 0, 139, 4281, 169, 1, 25999, 1, 2430.6, -5683.61, 444.208, 0.959931, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125741, 29202, 0, 139, 4281, 169, 1, 25999, 1, 2461.97, -5587.04, 367.486, 4.53786, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125742, 29202, 0, 139, 4281, 169, 1, 25999, 1, 2425.64, -5630.19, 420.649, 0.802851, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125743, 29202, 0, 139, 4281, 169, 1, 25999, 1, 2440.06, -5665.12, 376.895, 1.43117, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125744, 29202, 0, 139, 4281, 169, 1, 25999, 1, 2424.12, -5559.07, 420.644, 5.49779, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125745, 29202, 0, 139, 4281, 169, 1, 26001, 1, 2496.69, -5627.6, 420.651, 2.37365, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125746, 29202, 0, 139, 4281, 169, 1, 25998, 1, 2475.51, -5568.69, 366.82, 2.74293, 180, 5, 0, 32385, 21630, 1, 0, 0, 0,"", 0), +(125747, 29202, 0, 139, 4281, 169, 1, 25998, 1, 2466.98, -5594.89, 367.486, 3.00197, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125748, 29202, 0, 139, 4281, 169, 1, 25999, 1, 2441.92, -5547.21, 420.651, 5.02655, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125749, 29202, 0, 139, 4281, 169, 1, 26001, 1, 2480.71, -5522.02, 376.877, 4.5204, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125750, 29202, 0, 139, 4281, 169, 1, 25998, 1, 2430.58, -5556.85, 420.642, 3.93526, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125751, 29202, 0, 139, 4281, 169, 1, 25998, 1, 2431.42, -5559.64, 420.64, 4.56953, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125752, 29202, 0, 139, 4281, 169, 1, 26000, 1, 2386.21, -5639.72, 420.934, 0.453786, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125753, 29202, 0, 139, 4281, 169, 1, 26001, 1, 2534.36, -5601.83, 376.87, 2.98451, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125754, 29202, 0, 139, 4281, 169, 1, 26000, 1, 2478.6, -5640.08, 420.643, 2.04204, 180, 5, 0, 32385, 21630, 1, 0, 0, 0,"", 0), +(125755, 29202, 0, 139, 4281, 169, 1, 25998, 1, 2389.45, -5645.32, 420.872, 0.767945, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125756, 29202, 0, 139, 4281, 169, 1, 25999, 1, 2340.86, -5570.33, 444.75, 6.12611, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125757, 29202, 0, 139, 4281, 169, 1, 26001, 1, 2386.18, -5626.86, 377.179, 0.645772, 180, 0, 0, 32385, 21630, 0, 0, 0, 0,"", 0), +(125758, 29203, 0, 139, 4281, 169, 1, 25997, 1, 2395.99, -5587.67, 420.733, 1.43117, 180, 0, 0, 1889, 5206, 0, 0, 0, 0,"", 0), +(125759, 29205, 0, 139, 4281, 169, 1, 7858, 0, 2445.88, -5552.93, 420.644, 3.30713, 180, 0, 0, 2699, 0, 0, 0, 0, 0,"", 0), +(125760, 29207, 0, 139, 4281, 169, 1, 4631, 0, 2387.36, -5579.47, 420.737, 0, 180, 0, 0, 2699, 0, 0, 0, 0, 0,"", 0), +(125761, 29208, 0, 139, 4281, 169, 1, 570, 0, 2404.74, -5564.18, 420.65, 5.21853, 180, 0, 0, 2699, 0, 0, 0, 0, 0,"", 0), +(125762, 27928, 0, 139, 4281, 169, 1, 24935, 1, 2379.41, -5648.53, 382.522, 3.735, 180, 0, 0, 252000, 79880, 0, 0, 0, 0,"", 0), +(125766, 29212, 0, 139, 4281, 169, 1, 26002, 0, 2522.64, -5598.56, 420.732, 5.72468, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125767, 29212, 0, 139, 4281, 169, 1, 26003, 0, 2446.43, -5566.67, 417.962, 0.887452, 180, 5, 0, 2215, 0, 1, 0, 0, 0,"", 0), +(125768, 29212, 0, 139, 4281, 169, 1, 26003, 0, 2511.5, -5616.82, 420.727, 4.60767, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125769, 29212, 0, 139, 4281, 169, 1, 829, 0, 2464.41, -5525.95, 420.727, 5.70723, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125770, 29212, 0, 139, 4281, 169, 1, 829, 0, 2518.15, -5593.53, 420.727, 4.31096, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125771, 29212, 0, 139, 4281, 169, 1, 829, 0, 2528.41, -5593.57, 420.727, 0, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125772, 29212, 0, 139, 4281, 169, 1, 829, 0, 2451.82, -5624.64, 420.202, 0.187337, 180, 5, 0, 2215, 0, 1, 0, 0, 0,"", 0), +(125773, 29212, 0, 139, 4281, 169, 1, 829, 0, 2484.62, -5535.42, 421.532, 1.74533, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125774, 29212, 0, 139, 4281, 169, 1, 26003, 0, 2406.26, -5597.76, 421.734, 1.22173, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125775, 29212, 0, 139, 4281, 169, 1, 26003, 0, 2456.27, -5538.81, 420.727, 1.01229, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125776, 29212, 0, 139, 4281, 169, 1, 26002, 0, 2524.09, -5591.04, 421.498, 0.610865, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125777, 29212, 0, 139, 4281, 169, 1, 26002, 0, 2496.43, -5620.53, 420.647, 1.79314, 180, 5, 0, 2215, 0, 1, 0, 0, 0,"", 0), +(125778, 29212, 0, 139, 4281, 169, 1, 829, 0, 2510.67, -5619, 420.649, 1.39626, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125779, 29212, 0, 139, 4281, 169, 1, 829, 0, 2470.56, -5527.15, 420.734, 3.7001, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125780, 29212, 0, 139, 4281, 169, 1, 829, 0, 2518.35, -5588.84, 420.727, 1.8675, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125781, 29212, 0, 139, 4281, 169, 1, 26002, 0, 2465.99, -5532.94, 420.732, 1.18682, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125782, 29212, 0, 139, 4281, 169, 1, 26003, 0, 2425.79, -5590.48, 420.287, 1.28811, 180, 5, 0, 2215, 0, 1, 0, 0, 0,"", 0), +(125783, 29212, 0, 139, 4281, 169, 1, 26003, 0, 2524.07, -5616.75, 420.651, 2.32019, 180, 5, 0, 2215, 0, 1, 0, 0, 0,"", 0), +(125784, 29212, 0, 139, 4281, 169, 1, 26003, 0, 2421.39, -5561.41, 420.727, 0.226893, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125785, 29212, 0, 139, 4281, 169, 1, 26003, 0, 2438.97, -5558.75, 420.3, 3.03014, 180, 5, 0, 2215, 0, 1, 0, 0, 0,"", 0), +(125786, 29212, 0, 139, 4281, 169, 1, 829, 0, 2489.54, -5545.52, 421.796, 4.2237, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125787, 29212, 0, 139, 4281, 169, 1, 26003, 0, 2523.71, -5606.05, 420.65, 2.73855, 180, 5, 0, 2215, 0, 1, 0, 0, 0,"", 0), +(125788, 29212, 0, 139, 4281, 169, 1, 26003, 0, 2515.32, -5580.13, 420.727, 1.01229, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125789, 29212, 0, 139, 4281, 169, 1, 26003, 0, 2511.68, -5588.41, 420.727, 3.21141, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125790, 29212, 0, 139, 4281, 169, 1, 829, 0, 2402.77, -5595.08, 420.727, 5.21853, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125791, 29212, 0, 139, 4281, 169, 1, 26002, 0, 2521.03, -5588.51, 420.727, 5.044, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125792, 29212, 0, 139, 4281, 169, 1, 829, 0, 2509.72, -5624.31, 420.727, 6.12611, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125793, 29212, 0, 139, 4281, 169, 1, 829, 0, 2513.61, -5598.08, 420.727, 0.575959, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125794, 29212, 0, 139, 4281, 169, 1, 26002, 0, 2450.15, -5536.75, 421.491, 1.97222, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125795, 29212, 0, 139, 4281, 169, 1, 26003, 0, 2461.3, -5536.88, 421.928, 3.80482, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125796, 29212, 0, 139, 4281, 169, 1, 26003, 0, 2526.53, -5584.29, 420.727, 3.05433, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125797, 29212, 0, 139, 4281, 169, 1, 829, 0, 2485.91, -5540.86, 420.727, 4.13643, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125798, 29212, 0, 139, 4281, 169, 1, 26002, 0, 2484.25, -5545.9, 420.727, 0.558505, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125799, 29212, 0, 139, 4281, 169, 1, 26002, 0, 2478.68, -5542.38, 420.727, 2.58309, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125800, 29212, 0, 139, 4281, 169, 1, 26003, 0, 2408.75, -5593.02, 420.727, 4.50295, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125801, 29212, 0, 139, 4281, 169, 1, 26002, 0, 2413.97, -5618.59, 420.727, 0, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125802, 29212, 0, 139, 4281, 169, 1, 26003, 0, 2477.57, -5519.21, 420.551, 1.14359, 180, 5, 0, 2215, 0, 1, 0, 0, 0,"", 0), +(125803, 29212, 0, 139, 4281, 169, 1, 829, 0, 2404.61, -5593.25, 420.727, 1.43117, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125804, 29212, 0, 139, 4281, 169, 1, 26002, 0, 2482.09, -5531.64, 421.734, 0.488692, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125805, 29212, 0, 139, 4281, 169, 1, 829, 0, 2527.19, -5613.14, 420.727, 1.58825, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125806, 29212, 0, 139, 4281, 169, 1, 26002, 0, 2434.46, -5645.8, 420.644, 3.52235, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125807, 29212, 0, 139, 4281, 169, 1, 829, 0, 2467.17, -5539.97, 420.727, 4.2237, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125808, 29212, 0, 139, 4281, 169, 1, 829, 0, 2522.95, -5595.36, 420.727, 5.39307, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125809, 29212, 0, 139, 4281, 169, 1, 829, 0, 2517.07, -5584.58, 421.574, 3.33358, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125810, 29212, 0, 139, 4281, 169, 1, 26003, 0, 2516.96, -5591.08, 420.727, 2.9147, 180, 0, 0, 2215, 0, 0, 0, 0, 0,"", 0), +(125811, 29212, 0, 139, 4281, 169, 1, 26002, 0, 2480.78, -5554.29, 420.644, 5.17473, 180, 5, 0, 2215, 0, 1, 0, 0, 0,"", 0), +(125812, 32542, 0, 139, 4281, 169, 1, 28047, 0, 2482.47, -5599.68, 415.741, 2.67035, 180, 0, 0, 1, 0, 0, 0, 0, 0,"", 0), +(125813, 32542, 0, 139, 4281, 169, 1, 28047, 0, 2483.28, -5594.87, 415.747, 3.14159, 180, 0, 0, 1, 0, 0, 0, 0, 0,"", 0), +(125814, 32542, 0, 139, 4281, 169, 1, 28047, 0, 2482.51, -5588.27, 415.747, 3.4383, 180, 0, 0, 1, 0, 0, 0, 0, 0,"", 0), +(125815, 32543, 0, 139, 4281, 169, 1, 16074, 0, 2457.97, -5616.42, 415.747, 1.5708, 180, 0, 0, 1, 0, 0, 0, 0, 0,"", 0), +(125816, 32543, 0, 139, 4281, 169, 1, 16074, 0, 2453.11, -5615.05, 415.747, 1.23918, 180, 0, 0, 1, 0, 0, 0, 0, 0,"", 0), +(125817, 32543, 0, 139, 4281, 169, 1, 16074, 0, 2444.11, -5609.52, 415.747, 0.750492, 180, 0, 0, 1, 0, 0, 0, 0, 0,"", 0), +(125818, 32545, 0, 139, 4281, 169, 1, 3019, 0, 2467.66, -5571.87, 415.747, 4.39823, 180, 0, 0, 1, 0, 0, 0, 0, 0,"", 0), +(125819, 32545, 0, 139, 4281, 169, 1, 3019, 0, 2471.24, -5573.34, 415.747, 4.20624, 180, 0, 0, 1, 0, 0, 0, 0, 0,"", 0), +(125820, 32545, 0, 139, 4281, 169, 1, 3019, 0, 2462.96, -5570.75, 415.747, 4.79965, 180, 0, 0, 1, 0, 0, 0, 0, 0,"", 0), +(125821, 32546, 0, 139, 4281, 169, 1, 28048, 0, 2437.42, -5597.99, 415.747, 0.244346, 180, 0, 0, 1, 0, 0, 0, 0, 0,"", 0), +(125822, 32546, 0, 139, 4281, 169, 1, 28048, 0, 2437.42, -5592.11, 415.747, 6.17846, 180, 0, 0, 1, 0, 0, 0, 0, 0,"", 0), +(125823, 32546, 0, 139, 4281, 169, 1, 28048, 0, 2438.15, -5586.98, 415.747, 5.95157, 180, 0, 0, 1, 0, 0, 0, 0, 0,"", 0), +(125824, 32547, 0, 139, 4281, 169, 1, 28049, 0, 2460.32, -5592.96, 414.205, 2.16421, 180, 0, 0, 26104482, 0, 0, 0, 0, 0,"", 0), +(125825, 29480, 0, 139, 4281, 169, 1, 10627, 0, 2348.63, -5669.29, 382.324, 0.645772, 180, 0, 0, 31905, 0, 0, 0, 0, 0,"", 0), +(125826, 29239, 0, 139, 4281, 169, 1, 25753, 0, 2440.61, -5639.99, 454.293, 4.46682, 180, 0, 0, 3191, 2289, 0, 0, 0, 0,"", 0), +(125827, 29239, 0, 139, 4281, 169, 1, 25753, 0, 2490.76, -5638.42, 445.051, 2.14675, 180, 0, 0, 3191, 2289, 0, 0, 0, 0,"", 0), +(125828, 29239, 0, 139, 4281, 169, 1, 25753, 0, 2391.41, -5567.29, 444.357, 5.48033, 180, 0, 0, 3191, 2289, 0, 0, 0, 0,"", 0), +(125829, 29239, 0, 139, 4281, 169, 1, 25753, 0, 2429.2, -5616.6, 465.364, 2.25362, 180, 0, 0, 3191, 2289, 0, 0, 0, 0,"", 0), +(125830, 29239, 0, 139, 4281, 169, 1, 25753, 0, 2416.44, -5572.44, 422.853, 1.46918, 180, 0, 0, 3191, 2289, 0, 0, 0, 0,"", 0), +(125831, 29239, 0, 139, 4281, 169, 1, 25753, 0, 2434.35, -5550.9, 445.937, 5.71892, 180, 0, 0, 3191, 2289, 0, 0, 0, 0,"", 0), +(125832, 29239, 0, 139, 4281, 169, 1, 25753, 0, 2502.82, -5567.13, 446.636, 4.188, 180, 0, 0, 3191, 2289, 0, 0, 0, 0,"", 0), +(125833, 29239, 0, 139, 4281, 169, 1, 25753, 0, 2473.97, -5618.2, 481.038, 0.602209, 180, 0, 0, 3191, 2289, 0, 0, 0, 0,"", 0), +(125834, 29246, 0, 139, 4281, 169, 1, 27153, 1, 2460.33, -5593.72, 367.476, 3.7001, 180, 0, 0, 11156000, 0, 0, 0, 0, 0,"", 0), +(125835, 28481, 0, 139, 4281, 169, 1, 11686, 0, 2509.34, -5560.41, 423.657, 4.24115, 180, 0, 0, 8982, 0, 0, 0, 0, 0,"", 0), +(125836, 28481, 0, 139, 4281, 169, 1, 11686, 0, 2427.14, -5544.37, 423.518, 3.28122, 180, 0, 0, 8982, 0, 0, 0, 0, 0,"", 0), +(125837, 28481, 0, 139, 4281, 169, 1, 11686, 0, 2493.41, -5642.39, 423.795, 0.296706, 180, 0, 0, 8982, 0, 0, 0, 0, 0,"", 0), +(125838, 28486, 0, 139, 4281, 169, 1, 25467, 0, 2383.75, -5649.5, 382.439, 4.24115, 180, 0, 0, 11770, 0, 0, 0, 0, 0,"", 0), +(125839, 28488, 0, 139, 4281, 169, 1, 26919, 0, 2406.48, -5543.84, 376.872, 0.366519, 180, 0, 0, 2091, 6351, 0, 0, 0, 0,"", 0), +(125840, 28488, 0, 139, 4281, 169, 1, 26919, 0, 2416.65, -5514.5, 377.027, 5.20108, 180, 0, 0, 2091, 6351, 0, 0, 0, 0,"", 0), +(125841, 28488, 0, 139, 4281, 169, 1, 26919, 0, 2435.75, -5525.17, 376.972, 3.87463, 180, 0, 0, 2091, 6351, 0, 0, 0, 0,"", 0), +(125842, 28488, 0, 139, 4281, 169, 1, 26919, 0, 2404.68, -5521.94, 377.001, 5.25344, 180, 0, 0, 2091, 6351, 0, 0, 0, 0,"", 0), +(125843, 28489, 0, 139, 4281, 169, 1, 25471, 0, 2522.35, -5553.9, 377.129, 0.733038, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125844, 28489, 0, 139, 4281, 169, 1, 25469, 0, 2519.86, -5549.73, 377.153, 0.10472, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125845, 28489, 0, 139, 4281, 169, 1, 25471, 0, 2518.74, -5554.06, 376.999, 0.488692, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125846, 28489, 0, 139, 4281, 169, 1, 25471, 0, 2521.03, -5552.17, 377.201, 0.575959, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125847, 28489, 0, 139, 4281, 169, 1, 25472, 0, 2524.19, -5556.05, 377.137, 0.820305, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125848, 28489, 0, 139, 4281, 169, 1, 25470, 0, 2517.61, -5551.75, 377.118, 0.366519, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125849, 28489, 0, 139, 4281, 169, 1, 25469, 0, 2522.06, -5558.47, 377.142, 1.309, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125851, 28490, 0, 139, 4281, 169, 1, 25477, 1, 2420.33, -5538.64, 377.116, 2.02458, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125852, 28490, 0, 139, 4281, 169, 1, 25476, 1, 2428.45, -5533.67, 377.134, 2.46091, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125853, 28490, 0, 139, 4281, 169, 1, 25475, 1, 2425.69, -5535.38, 377.122, 2.32129, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125854, 28490, 0, 139, 4281, 169, 1, 25478, 1, 2418.02, -5539.93, 377.136, 1.90241, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125855, 28490, 0, 139, 4281, 169, 1, 25477, 1, 2422.85, -5536.9, 377.163, 2.16421, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125856, 28490, 0, 139, 4281, 169, 1, 25475, 1, 2420.65, -5535.74, 377.032, 2.09439, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125857, 28490, 0, 139, 4281, 169, 1, 25476, 1, 2423.28, -5534.07, 377.04, 2.18166, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125858, 28490, 0, 139, 4281, 169, 1, 25478, 1, 2418, -5537.15, 377.023, 1.95477, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125859, 28490, 0, 139, 4281, 169, 1, 25476, 1, 2425.6, -5532.44, 377.048, 2.28638, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125860, 28491, 0, 139, 4281, 169, 1, 25481, 0, 2508.12, -5652.06, 377.101, 3.96772, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125861, 28491, 0, 139, 4281, 169, 1, 25480, 0, 2510.39, -5656.1, 377.108, 3.38594, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125862, 28491, 0, 139, 4281, 169, 1, 25482, 0, 2497.96, -5663.6, 377.145, 0.902047, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125863, 28491, 0, 139, 4281, 169, 1, 25480, 0, 2510.02, -5660.27, 377.117, 2.82743, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125864, 28491, 0, 139, 4281, 169, 1, 25482, 0, 2502.22, -5664.97, 377.133, 1.48353, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125865, 28491, 0, 139, 4281, 169, 1, 25479, 0, 2504.29, -5651.25, 377.107, 4.50295, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125866, 28491, 0, 139, 4281, 169, 1, 25481, 0, 2496.05, -5655.37, 377.047, 5.89921, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125867, 28491, 0, 139, 4281, 169, 1, 25482, 0, 2499.55, -5652.18, 377.034, 5.2709, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125868, 28491, 0, 139, 4281, 169, 1, 25480, 0, 2495.93, -5659.51, 377.054, 0.226893, 180, 0, 0, 2614, 0, 0, 0, 0, 0,"", 0), +(125869, 28500, 0, 139, 4281, 169, 1, 25498, 1, 2468.15, -5654.19, 420.647, 3.34705, 180, 0, 0, 126000, 0, 2, 0, 0, 0,"", 0), +(125870, 29587, 0, 139, 4281, 169, 1, 25496, 0, 2365.73, -5680.6, 382.321, 2.54818, 180, 0, 0, 126000, 0, 0, 0, 0, 0,"", 0), +(125871, 29588, 0, 139, 4281, 169, 1, 24719, 0, 2390, -5640.98, 377.196, 3.12414, 180, 0, 0, 8982, 0, 0, 0, 0, 0,"", 0), +(125872, 29589, 0, 139, 4281, 169, 1, 24719, 0, 2383.7, -5645.17, 420.884, 5.63741, 180, 0, 0, 8982, 0, 0, 0, 0, 0,"", 0), +(130431, 28481, 0, 139, 4281, 175, 1, 11686, 0, 2493.41, -5642.39, 423.795, 0.296706, 360, 0, 0, 8982, 0, 0, 0, 0, 0,"", 0), +(130432, 28481, 0, 139, 4281, 175, 1, 11686, 0, 2427.14, -5544.37, 423.518, 3.28122, 360, 0, 0, 8982, 0, 0, 0, 0, 0,"", 0), +(130433, 28481, 0, 139, 4281, 175, 1, 11686, 0, 2509.34, -5560.41, 423.657, 4.24115, 360, 0, 0, 8982, 0, 0, 0, 0, 0,"", 0), +(130468, 31084, 0, 139, 4281, 403, 1, 0, 1, 2375.38, -5650.72, 382.523, 0.575959, 360, 0, 0, 11156000, 2129000, 0, 0, 0, 0,"", 0), +(130469, 31088, 0, 139, 4281, 403, 1, 0, 1, 2377.61, -5654.39, 382.523, 0.610865, 360, 0, 0, 2489500, 0, 0, 0, 0, 0,"", 0), +(130470, 31089, 0, 139, 4281, 403, 1, 0, 1, 2373.14, -5647.37, 382.523, 0.680678, 360, 0, 0, 2489500, 0, 0, 0, 0, 0,"", 0), +(130471, 31094, 0, 139, 4281, 403, 1, 0, 1, 2422.44, -5624.99, 375.382, 5.42797, 360, 0, 0, 15955, 11445, 0, 0, 537166592, 32, "", 0), +(130472, 31094, 0, 139, 4281, 403, 1, 0, 1, 2441.8, -5612.99, 366.903, 3.82227, 360, 0, 0, 15955, 11445, 0, 0, 537166592, 32, "", 0), +(130473, 31094, 0, 139, 4281, 403, 1, 0, 1, 2483.05, -5577.48, 366.903, 1.15192, 360, 0, 0, 15955, 11445, 0, 0, 537166592, 32, "", 0), +(130474, 31094, 0, 139, 4281, 403, 1, 0, 1, 2403.64, -5642.05, 377.12, 4.93928, 360, 0, 0, 15955, 11445, 0, 0, 537166592, 32, "", 0), +(130475, 31094, 0, 139, 4281, 403, 1, 0, 1, 2394.61, -5628.72, 377.12, 1.41372, 360, 0, 0, 15955, 11445, 0, 0, 537166592, 32, "", 0), +(130476, 31094, 0, 139, 4281, 177, 1, 0, 1, 2469.21, -5586.86, 414.257, 2.07694, 360, 0, 0, 15955, 11445, 0, 0, 537166592, 32, "", 0), +(130477, 31094, 0, 139, 4281, 177, 1, 0, 1, 2449.59, -5586.74, 414.44, 5.58505, 360, 0, 0, 15955, 11445, 0, 0, 537166592, 32, "", 0), +(130478, 31094, 0, 139, 4281, 177, 1, 0, 1, 2449.49, -5593.03, 414.255, 2.94961, 360, 0, 0, 15955, 11445, 0, 0, 537166592, 32, "", 0), +(130479, 31094, 0, 139, 4281, 403, 1, 0, 1, 2474.94, -5618.47, 366.903, 4.4855, 360, 0, 0, 15955, 11445, 0, 0, 537166592, 32, "", 0), +(130480, 31094, 0, 139, 4281, 403, 1, 0, 1, 2435.77, -5581.91, 366.903, 5.28835, 360, 0, 0, 15955, 11445, 0, 0, 537166592, 32, "", 0), +(130481, 31094, 0, 139, 4281, 403, 1, 0, 1, 2425.26, -5542.57, 376.989, 2.58309, 360, 0, 0, 15955, 11445, 0, 0, 537166592, 32, "", 0), +(130482, 31094, 0, 139, 4281, 177, 1, 0, 1, 2462.85, -5605.92, 414.439, 5.72468, 360, 0, 0, 15955, 11445, 0, 0, 537166592, 32, "", 0), +(130483, 31094, 0, 139, 4281, 403, 1, 0, 1, 2409.92, -5624.33, 376.99, 0.575959, 360, 0, 0, 15955, 11445, 0, 0, 537166592, 32, "", 0), +(130484, 31094, 0, 139, 4281, 177, 1, 0, 1, 2471.42, -5600.35, 414.479, 0.191986, 360, 0, 0, 15955, 11445, 0, 0, 537166592, 32, "", 0), +(130485, 31094, 0, 139, 4281, 177, 1, 0, 1, 2412.25, -5624.19, 420.657, 0.639379, 360, 0, 0, 15955, 11445, 0, 0, 0, 0,"", 0), +(130486, 31094, 0, 139, 4281, 177, 1, 0, 1, 2416.74, -5629.35, 420.649, 0.628319, 360, 0, 0, 15955, 11445, 0, 0, 0, 0,"", 0), +(130487, 31094, 0, 139, 4281, 177, 1, 26000, 1, 2415.66, -5626.65, 420.65, 0.610865, 360, 0, 0, 15955, 11445, 0, 0, 0, 0,"", 0), +(130488, 31094, 0, 139, 4281, 177, 1, 26001, 1, 2411.52, -5620.9, 420.657, 0.593412, 360, 0, 0, 15955, 11445, 0, 0, 0, 0,"", 0), +(130490, 31095, 0, 139, 4281, 177, 1, 0, 0, 2493.88, -5620.74, 432.943, 0.287214, 360, 0, 0, 24852, 0, 2, 0, 0, 0,"", 0), +(130491, 31095, 0, 139, 4281, 177, 1, 0, 0, 2446.4, -5580.25, 427.061, 5.02554, 360, 0, 0, 24852, 0, 2, 0, 0, 0,"", 0), +(130493, 31095, 0, 139, 4281, 177, 1, 0, 0, 2430.56, -5565.45, 430.976, 0.731252, 360, 0, 0, 24852, 0, 2, 0, 0, 0,"", 0), +(130494, 31095, 0, 139, 4281, 177, 1, 0, 0, 2460.74, -5633.36, 432.797, 0.155296, 360, 0, 0, 24852, 0, 2, 0, 0, 0,"", 0), +(130495, 31096, 0, 139, 4281, 177, 1, 0, 0, 2494.64, -5557.88, 420.727, 4.11898, 360, 0, 0, 11952, 24340, 0, 0, 0, 0,"", 0), +(130496, 31096, 0, 139, 4281, 177, 1, 0, 0, 2505.21, -5575.11, 420.727, 3.26377, 360, 0, 0, 11952, 24340, 0, 0, 0, 0,"", 0), +(130497, 31096, 0, 139, 4281, 177, 1, 0, 0, 2478.43, -5638.82, 420.727, 1.8326, 360, 0, 0, 11952, 24340, 0, 0, 0, 0,"", 0), +(130498, 31096, 0, 139, 4281, 177, 1, 0, 0, 2441.48, -5548.26, 420.727, 4.72984, 360, 0, 0, 11952, 24340, 0, 0, 0, 0,"", 0), +(130499, 31096, 0, 139, 4281, 175, 1, 25351, 0, 2494.61, -5626.82, 420.727, 2.54818, 360, 0, 0, 11952, 24340, 0, 0, 0, 0,"", 0), +(130500, 31096, 0, 139, 4281, 177, 1, 0, 0, 2425.18, -5559.38, 420.727, 5.65487, 360, 0, 0, 11952, 24340, 0, 0, 0, 0,"", 0), +(130501, 31098, 0, 139, 4281, 403, 1, 0, 1, 2411.57, -5635.29, 376.986, 0.750492, 360, 0, 0, 11967, 0, 0, 0, 537166592, 32, "", 0), +(130502, 31098, 0, 139, 4281, 403, 1, 0, 1, 2395.26, -5620.84, 377.104, 5.32325, 360, 0, 0, 11967, 0, 0, 0, 537166592, 32, "", 0), +(130503, 31098, 0, 139, 4281, 403, 1, 0, 1, 2374.19, -5661.05, 382.463, 3.26377, 360, 0, 0, 11967, 0, 0, 0, 537166592, 32, "", 0), +(130504, 31098, 0, 139, 4281, 403, 1, 0, 1, 2434.47, -5605.34, 366.903, 4.74729, 360, 0, 0, 11967, 0, 0, 0, 537166592, 32, "", 0), +(130505, 31098, 0, 139, 4281, 177, 1, 0, 1, 2473.49, -5530.56, 420.649, 0.697148, 360, 10, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130506, 31098, 0, 139, 4281, 177, 1, 0, 1, 2490.78, -5560.57, 420.646, 4.34269, 360, 10, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130507, 31098, 0, 139, 4281, 177, 1, 0, 1, 2452.3, -5650.22, 420.646, 0.507009, 360, 10, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130508, 31098, 0, 139, 4281, 177, 1, 0, 1, 2484.53, -5579.09, 420.025, 1.68911, 360, 5, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130511, 31098, 0, 139, 4281, 177, 1, 0, 1, 2470.23, -5566.85, 420.065, 3.7499, 360, 5, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130512, 31098, 0, 139, 4281, 177, 1, 0, 1, 2460.01, -5545.7, 420.645, 1.74425, 360, 10, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130513, 31098, 0, 139, 4281, 177, 1, 0, 1, 2524.17, -5605.97, 420.651, 2.71238, 360, 10, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130515, 31098, 0, 139, 4281, 177, 1, 0, 1, 2450.21, -5552.55, 420.644, 4.92496, 360, 10, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130516, 31098, 0, 139, 4281, 177, 1, 0, 1, 2504.14, -5594.19, 420.644, 1.5583, 360, 10, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130517, 31098, 0, 139, 4281, 177, 1, 0, 1, 2434.05, -5558.52, 420.727, 3.71755, 360, 10, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130519, 31098, 0, 139, 4281, 177, 1, 0, 1, 2489.36, -5626.69, 420.727, 1.22173, 360, 10, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130521, 31098, 0, 139, 4281, 177, 1, 0, 1, 2445, -5570.61, 416.859, 0.680678, 360, 10, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130522, 31098, 0, 139, 4281, 177, 1, 0, 1, 2431.8, -5579.99, 420.19, 6.08151, 360, 5, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130524, 31098, 0, 139, 4281, 177, 1, 0, 1, 2501.68, -5618.51, 420.727, 3.7001, 360, 5, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130525, 31098, 0, 139, 4281, 177, 1, 0, 1, 2477.54, -5618.83, 417.632, 3.63029, 360, 10, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130526, 31098, 0, 139, 4281, 177, 1, 0, 1, 2417.49, -5587.98, 420.644, 4.78348, 360, 10, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130527, 31098, 0, 139, 4281, 177, 1, 0, 1, 2404.61, -5576, 420.648, 2.84747, 360, 10, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130528, 31098, 0, 139, 4281, 177, 1, 0, 1, 2499.96, -5576.15, 420.727, 5.044, 360, 10, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130530, 31098, 0, 139, 4281, 177, 1, 0, 1, 2416.66, -5575.52, 420.727, 1.98968, 360, 10, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130531, 31098, 0, 139, 4281, 177, 1, 0, 1, 2488.49, -5599.79, 420.136, 3.26377, 360, 5, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130532, 31098, 0, 139, 4281, 177, 1, 0, 1, 2437.3, -5614.33, 420.252, 3.21141, 360, 5, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130535, 31098, 0, 139, 4281, 177, 1, 0, 1, 2431.16, -5604.53, 420.26, 4.60767, 360, 5, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130536, 31098, 0, 139, 4281, 177, 1, 0, 1, 2444.79, -5630.57, 420.667, 3.49066, 360, 10, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130537, 31098, 0, 139, 4281, 177, 1, 0, 1, 2457, -5623.45, 420.206, 4.34587, 360, 5, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130539, 31098, 0, 139, 4281, 177, 1, 0, 1, 2473.43, -5631.25, 420.254, 1.16937, 360, 10, 0, 11967, 0, 1, 0, 0, 0,"", 0), +(130542, 31099, 0, 139, 4281, 177, 1, 0, 0, 2457.06, -5592.09, 414.122, 4.48475, 360, 5, 0, 276350, 0, 1, 0, 0, 0,"", 0), +(130545, 29588, 0, 139, 4281, 403, 1, 0, 0, 2390, -5640.98, 377.196, 3.12414, 360, 0, 0, 8982, 0, 0, 0, 0, 0,"", 0), +(130546, 29589, 0, 139, 4281, 403, 1, 24719, 0, 2383.7, -5645.17, 420.884, 5.63741, 360, 0, 0, 8982, 0, 0, 0, 0, 0,"", 0), +(99790, 6491, 0, 139, 4281, 169, 1, 0, 0, 2356.65, -5663.06, 382.257, 0.586577, 60, 0, 0, 4120, 0, 0, 0, 0, 0,"", 0); + +DELETE FROM `creature_addon` WHERE `guid` IN (125641,125642,125651,125712,125713,125714,125715,125716,125717,125718,125719,125721,125722,125723,125724,125725,125726,125727,125728,125729,125730,125731,125732,125733,125734,125735,125736,125737,125738,125739,125740,125741,125742,125743,125744,125745,125746,125747,125748,125749,125750,125751,125752,125753,125754,125755,125756,125757,125758,125759,125760,125761,125762,125766,125767,125768,125769,125770,125771,125772,125773,125774,125775,125776,125777,125778,125779,125780,125781,125782,125783,125784,125785,125786,125787,125788,125789,125790,125791,125792,125793,125794,125795,125796,125797,125798,125799,125800,125801,125802,125803,125804,125805,125806,125807,125808,125809,125810,125811,125812,125813,125814,125815,125816,125817,125818,125819,125820,125821,125822,125823,125824,125825,125826,125827,125828,125829,125830,125831,125832,125833,125834,125835,125836,125837,125838,125839,125840,125841,125842,125843,125844,125845,125846,125847,125848,125849,125851,125852,125853,125854,125855,125856,125857,125858,125859,125860,125861,125862,125863,125864,125865,125866,125867,125868,125869,125870,125871,125872,130431,130432,130433,130468,130469,130470,130471,130472,130473,130474,130475,130476,130477,130478,130479,130480,130481,130482,130483,130484,130485,130486,130487,130488,130490,130491,130493,130494,130495,130496,130497,130498,130499,130500,130501,130502,130503,130504,130505,130506,130507,130508,130511,130512,130513,130515,130516,130517,130519,130521,130522,130524,130525,130526,130527,130528,130530,130531,130532,130535,130536,130537,130539,130542,130545,130546,99790);; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(125712, 0, 0, 0, 1, 0, ""), +(125713, 0, 25280, 0, 1, 0, ""), +(125715, 0, 25280, 0, 1, 0, ""), +(125717, 0, 25280, 0, 1, 0, ""), +(125722, 0, 25280, 0, 1, 0, ""), +(125723, 0, 26303, 0, 1, 0, ""), +(125724, 0, 26303, 0, 1, 0, ""), +(125725, 0, 26303, 0, 1, 0, ""), +(125726, 0, 26303, 0, 1, 0, ""), +(125728, 0, 25280, 0, 1, 0, ""), +(125729, 0, 25280, 0, 1, 0, ""), +(125731, 0, 25280, 0, 1, 0, ""), +(125736, 0, 25280, 0, 1, 0, ""), +(125741, 0, 0, 8, 1, 0, ""), +(125746, 0, 25280, 0, 1, 0, ""), +(125747, 0, 0, 8, 1, 0, ""), +(125750, 0, 25280, 0, 1, 0, ""), +(125751, 0, 25280, 0, 1, 0, ""), +(125756, 0, 25280, 0, 1, 0, ""), +(125757, 0, 25280, 0, 1, 0, ""), +(125766, 0, 0, 7, 257, 0, ""), +(125767, 0, 0, 0, 257, 418, ""), +(125768, 0, 0, 7, 257, 0, ""), +(125769, 0, 0, 0, 257, 64, ""), +(125770, 0, 0, 7, 257, 0, ""), +(125771, 0, 0, 7, 257, 0, ""), +(125772, 0, 0, 0, 257, 0, ""), +(125773, 0, 0, 7, 257, 0, ""), +(125774, 0, 0, 7, 257, 0, ""), +(125775, 0, 0, 7, 257, 0, ""), +(125776, 0, 0, 7, 257, 0, ""), +(125777, 0, 0, 0, 257, 0, ""), +(125778, 0, 0, 0, 257, 64, ""), +(125779, 0, 0, 7, 257, 0, ""), +(125780, 0, 0, 7, 257, 0, ""), +(125781, 0, 0, 7, 257, 0, ""), +(125782, 0, 0, 0, 257, 0, ""), +(125783, 0, 0, 0, 257, 0, ""), +(125784, 0, 0, 7, 257, 0, ""), +(125785, 0, 0, 0, 257, 0, ""), +(125786, 0, 0, 7, 257, 0, ""), +(125787, 0, 0, 0, 257, 0, ""), +(125788, 0, 0, 7, 257, 0, ""), +(125789, 0, 0, 7, 257, 0, ""), +(125790, 0, 0, 7, 257, 0, ""), +(125791, 0, 0, 0, 257, 64, ""), +(125792, 0, 0, 7, 257, 0, ""), +(125793, 0, 0, 7, 257, 0, ""), +(125794, 0, 0, 7, 257, 0, ""), +(125795, 0, 0, 7, 257, 0, ""), +(125796, 0, 0, 7, 257, 0, ""), +(125797, 0, 0, 7, 257, 0, ""), +(125798, 0, 0, 0, 257, 64, ""), +(125799, 0, 0, 7, 257, 0, ""), +(125800, 0, 0, 7, 257, 0, ""), +(125801, 0, 0, 7, 257, 0, ""), +(125802, 0, 0, 0, 257, 0, ""), +(125803, 0, 0, 7, 257, 0, ""), +(125804, 0, 0, 7, 257, 0, ""), +(125805, 0, 0, 7, 257, 0, ""), +(125806, 0, 0, 0, 257, 418, ""), +(125807, 0, 0, 7, 257, 0, ""), +(125808, 0, 0, 7, 257, 0, ""), +(125809, 0, 0, 7, 257, 0, ""), +(125810, 0, 0, 7, 257, 0, ""), +(125811, 0, 0, 0, 257, 0, ""), +(125824, 0, 0, 0, 1, 0, ""), +(125825, 0, 0, 0, 257, 0, ""), +(125826, 0, 0, 9, 1, 0, ""), +(125827, 0, 0, 9, 1, 0, ""), +(125828, 0, 0, 0, 1, 0, ""), +(125829, 0, 0, 0, 1, 0, ""), +(125830, 0, 0, 0, 1, 0, ""), +(125831, 0, 0, 9, 1, 0, ""), +(125832, 0, 0, 9, 1, 0, ""), +(125833, 0, 0, 0, 1, 0, ""), +(125834, 0, 25279, 0, 1, 0, ""), +(125839, 0, 0, 0, 257, 0, ""), +(125840, 0, 0, 0, 257, 0, ""), +(125841, 0, 0, 0, 257, 0, ""), +(125842, 0, 0, 0, 257, 0, ""), +(125870, 0, 28108, 0, 1, 0, ""), +(130504, 0, 0, 0, 1, 0, "29266"), +(130503, 0, 0, 0, 1, 0, "29266"), +(130488, 0, 0, 0, 1, 0, ""), +(130487, 0, 0, 0, 1, 0, ""), +(130486, 0, 0, 0, 1, 0, ""), +(130485, 0, 0, 0, 1, 0, ""), +(130484, 0, 0, 0, 1, 0, "29266"), +(130483, 0, 0, 0, 1, 0, "29266"), +(130482, 0, 0, 0, 1, 0, "29266"), +(130481, 0, 0, 0, 1, 0, "29266"), +(130480, 0, 0, 0, 1, 0, "29266"), +(130468, 0, 25279, 0, 1, 0, ""), +(130469, 0, 0, 0, 1, 0, "53627"), +(130470, 0, 0, 0, 1, 0, "53627"), +(130479, 0, 0, 0, 1, 0, "29266"), +(130478, 0, 0, 0, 1, 0, "29266"), +(130477, 0, 0, 0, 1, 0, "29266"), +(130476, 0, 0, 0, 1, 0, "29266"), +(130475, 0, 0, 0, 1, 0, "29266"), +(130474, 0, 0, 0, 1, 0, "29266"), +(130473, 0, 0, 0, 1, 0, "29266"), +(130472, 0, 0, 0, 1, 0, "29266"), +(130471, 0, 0, 0, 1, 0, "29266"), +(130502, 0, 0, 0, 1, 0, "29266"), +(130501, 0, 0, 0, 1, 0, "29266"), +(130542, 0, 0, 0, 1, 0, ""), +(130490, 1304900, 0, 0, 0, 0, ""), +(130491, 1304910, 0, 0, 0, 0, ""), +(130493, 1304930, 0, 0, 0, 0, ""), +(130494, 1304940, 0, 0, 0, 0, ""); + +DELETE FROM `waypoint_data` WHERE `id` IN (1304900,1304910,1304930,1304940); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(1304900, 1, 2502.84, -5616.48, 432.943, 0, 0, 0, 0, 100, 0), +(1304900, 2, 2504.11, -5590.47, 432.905, 0, 0, 0, 0, 100, 0), +(1304900, 3, 2494.05, -5577.2, 433.731, 0, 0, 0, 0, 100, 0), +(1304900, 4, 2471.94, -5577.82, 433.117, 0, 0, 0, 0, 100, 0), +(1304900, 5, 2454.16, -5602.11, 434.512, 0, 0, 0, 0, 100, 0), +(1304900, 6, 2477.43, -5633.17, 434.415, 0, 0, 0, 0, 100, 0), +(1304910, 1, 2472.95, -5595.96, 427.061, 0, 0, 0, 0, 100, 0), +(1304910, 2, 2497.12, -5583.22, 427.061, 0, 0, 0, 0, 100, 0), +(1304910, 3, 2494.59, -5562.15, 426.705, 0, 0, 0, 0, 100, 0), +(1304910, 4, 2471.2, -5554.49, 426.149, 0, 0, 0, 0, 100, 0), +(1304910, 5, 2451.5, -5563.65, 427.061, 0, 0, 0, 0, 100, 0), +(1304910, 6, 2447.21, -5581.95, 427.061, 0, 0, 0, 0, 100, 0), +(1304930, 1, 2424.46, -5574.49, 430.977, 0, 0, 0, 0, 100, 0), +(1304930, 2, 2427.46, -5595.36, 430.977, 0, 0, 0, 0, 100, 0), +(1304930, 3, 2444.23, -5598.51, 430.977, 0, 0, 0, 0, 100, 0), +(1304930, 4, 2454.89, -5586.1, 430.977, 0, 0, 0, 0, 100, 0), +(1304930, 5, 2453.33, -5568.18, 430.977, 0, 0, 0, 0, 100, 0), +(1304930, 6, 2434.54, -5563.2, 430.977, 0, 0, 0, 0, 100, 0), +(1304940, 1, 2465.76, -5620, 434.171, 0, 0, 0, 0, 100, 0), +(1304940, 2, 2454.56, -5606.66, 433.226, 0, 0, 0, 0, 100, 0), +(1304940, 3, 2431.77, -5618.29, 432.56, 0, 0, 0, 0, 100, 0), +(1304940, 4, 2444.1, -5629.27, 432.948, 0, 0, 0, 0, 100, 0), +(1304940, 5, 2461.61, -5633.12, 432.837, 0, 0, 0, 0, 100, 0); + +DELETE FROM `creature` WHERE `guid` IN (320522, 320562, 320563, 320564, 320565, 320566, 320567, 320568, 320569, 320570, 320571, 320572, 320573, 320574, 320575, 320576, 320577, 320579, 320580, 320581, 320582, 320583, 320584, 320585, 320586, 320587, 320588, 320589, 320590, 320591, 320592, 320593, 320594, 320595, 320596, 320597, 320598, 320599, 320600, 320601, 320602, 320603, 320604, 320605, 320606, 320607, 320608, 320609, 320610, 320611, 320612, 320613, 320614, 320615, 320616, 320617, 320657, 320658, 320659, 320660, 320661, 320662, 320663, 320664, 320665, 320666, 320667, 320668, 320669, 320670, 320671, 320672, 320673, 320674, 320675, 320676, 320677, 320678, 320679, 320680, 320681, 320682, 320683, 320684, 320685, 320686, 320687, 320688, 320689, 320690, 320691, 320692, 320693, 320694, 320695, 320696, 320697, 320698, 320699, 320700, 320701, 320702, 320703, 320704, 320705, 320706, 320707, 320708, 320709, 320710, 320711, 320712, 320713, 320714, 320715, 320716, 320717, 320718, 320719, 320720, 320721, 320722, 320723, 320724, 320725, 320728, 320730, 320731, 320732, 320733, 320734, 320735, 320736, 320737, 320738, 320739, 320740, 320741, 320742, 320744, 320745, 320746, 320747, 320748, 320749, 320750, 320751, 320752, 320753, 320754, 320755, 320756, 320757, 320758, 320759, 320760, 320761, 320762, 320763, 320764, 320765, 320766); +DELETE FROM `creature_addon` WHERE `guid` IN (320522, 320562, 320563, 320564, 320565, 320566, 320567, 320568, 320569, 320570, 320571, 320572, 320573, 320574, 320575, 320576, 320577, 320579, 320580, 320581, 320582, 320583, 320584, 320585, 320586, 320587, 320588, 320589, 320590, 320591, 320592, 320593, 320594, 320595, 320596, 320597, 320598, 320599, 320600, 320601, 320602, 320603, 320604, 320605, 320606, 320607, 320608, 320609, 320610, 320611, 320612, 320613, 320614, 320615, 320616, 320617, 320657, 320658, 320659, 320660, 320661, 320662, 320663, 320664, 320665, 320666, 320667, 320668, 320669, 320670, 320671, 320672, 320673, 320674, 320675, 320676, 320677, 320678, 320679, 320680, 320681, 320682, 320683, 320684, 320685, 320686, 320687, 320688, 320689, 320690, 320691, 320692, 320693, 320694, 320695, 320696, 320697, 320698, 320699, 320700, 320701, 320702, 320703, 320704, 320705, 320706, 320707, 320708, 320709, 320710, 320711, 320712, 320713, 320714, 320715, 320716, 320717, 320718, 320719, 320720, 320721, 320722, 320723, 320724, 320725, 320728, 320730, 320731, 320732, 320733, 320734, 320735, 320736, 320737, 320738, 320739, 320740, 320741, 320742, 320744, 320745, 320746, 320747, 320748, 320749, 320750, 320751, 320752, 320753, 320754, 320755, 320756, 320757, 320758, 320759, 320760, 320761, 320762, 320763, 320764, 320765, 320766); + +DELETE FROM `gameobject` WHERE `guid` IN (219713, 219714, 219715, 219719, 219721, 219722, 219723, 219724, 219725, 219726, 219727, 219728, 219729, 222179, 222180, 222181); +DELETE FROM `gameobject_addon` WHERE `guid` IN (219713, 219714, 219715, 219719, 219721, 219722, 219723, 219724, 219725, 219726, 219727, 219728, 219729, 222179, 222180, 222181); + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=49072 AND `spell_id`=69063; +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES +(49072, 69063, 1, 0); + +UPDATE `creature_template_addon` SET `auras`="" WHERE `entry`=40792; |