diff options
| -rw-r--r-- | sql/updates/world/master/2018_03_12_08_world_2016_12_13_01_world.sql | 301 |
1 files changed, 301 insertions, 0 deletions
diff --git a/sql/updates/world/master/2018_03_12_08_world_2016_12_13_01_world.sql b/sql/updates/world/master/2018_03_12_08_world_2016_12_13_01_world.sql new file mode 100644 index 00000000000..50133cd1b61 --- /dev/null +++ b/sql/updates/world/master/2018_03_12_08_world_2016_12_13_01_world.sql @@ -0,0 +1,301 @@ +-- +SET @Cguid:=145826; +DELETE FROM `creature` WHERE `id` IN (14351,11444,11446,11448,11442,11441,11445,11450,14385,13036) AND `map`=429; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(@Cguid+0, 11444, 429, 2, 0, 0, 278.29, 32.931, -2.46346, 0.05236, 86400, 0, 0), +(@Cguid+1, 11444, 429, 2, 0, 0, 356.308, 27.8438, -24.9039, 6.23082, 86400, 0, 0), +(@Cguid+2, 11444, 429, 2, 0, 0, 364.345, 17.3626, -25.5038, 1.36136, 86400, 0, 0), +(@Cguid+3, 11444, 429, 2, 0, 0, 413.308, 200.467, 11.2983, 0.261799, 86400, 0, 0), +(@Cguid+4, 11444, 429, 2, 0, 0, 425.703, 203.455, 11.2904, 3.35103, 86400, 0, 0), +(@Cguid+5, 11444, 429, 2, 0, 0, 324.012, 296.401, 11.2898, 1.36136, 86400, 0, 0), +(@Cguid+6, 11444, 429, 2, 0, 0, 325.699, 305.354, 11.2862, 4.53786, 86400, 0, 0), +(@Cguid+7, 11444, 429, 2, 0, 0, 288.657, 317.849, 2.93636, 2.42601, 86400, 0, 0), +(@Cguid+8, 11444, 429, 2, 0, 0, 279.307, 325.271, 2.93639, 5.65487, 86400, 0, 0), +(@Cguid+9, 11444, 429, 2, 0, 0, 431.546, 171.163, 2.85225, 3.26898, 86400, 0, 2), +(@Cguid+10, 11444, 429, 2, 0, 0, 253.062, 92.799, -2.47625, 0.802851, 86400, 0, 0), +(@Cguid+11, 11444, 429, 2, 0, 0, 273.006, 195.121, 2.93627, 0.855211, 86400, 0, 0), +(@Cguid+12, 11444, 429, 2, 0, 0, 280.528, 204.355, 2.93633, 4.06662, 86400, 0, 0), +(@Cguid+13, 11444, 429, 2, 0, 0, 333.932, 132.645, -2.49961, 3.40339, 86400, 0, 0), +(@Cguid+14, 11444, 429, 2, 0, 0, 462.979, 55.9376, -3.80328, 0.541052, 86400, 0, 0), +(@Cguid+15, 11444, 429, 2, 0, 0, 349.212, -110.3, -3.80274, 0.733038, 86400, 0, 0), +(@Cguid+16, 11444, 429, 2, 0, 0, 341.384, 219.696, 11.287, 4.27606, 86400, 0, 0), +(@Cguid+17, 11444, 429, 2, 0, 0, 487.189, 179.82, 2.93627, 4.06662, 86400, 0, 0), +(@Cguid+18, 11444, 429, 2, 0, 0, 735.327, 423.83, 28.2633, 0.750492, 86400, 0, 0), +(@Cguid+19, 11444, 429, 2, 0, 0, 299.916, 40.0648, -3.8728, 3.80482, 86400, 0, 0), +(@Cguid+20, 11444, 429, 2, 0, 0, 384.076, 144.653, 0.654953, 4.57276, 86400, 0, 0), +(@Cguid+21, 11444, 429, 2, 0, 0, 314.267, 125.077, -3.80362, 0.453786, 86400, 0, 0), +(@Cguid+22, 11444, 429, 2, 0, 0, 471.769, 192.862, 2.93626, 6.12611, 86400, 0, 0), +(@Cguid+23, 11444, 429, 2, 0, 0, 479.482, 59.1785, -3.80289, 3.24631, 86400, 0, 0), +(@Cguid+24, 11444, 429, 2, 0, 0, 350.451, 203.075, 11.2928, 1.44862, 86400, 0, 0), +(@Cguid+25, 11446, 429, 2, 0, 0, 910.469, 460.242, 40.4794, 2.93215, 86400, 0, 0), +(@Cguid+26, 11446, 429, 2, 0, 0, 794.791, 565.687, 40.4798, 5.07891, 86400, 0, 0), +(@Cguid+27, 11446, 429, 2, 0, 0, 879.269, 413.435, 40.48, 2.23402, 86400, 0, 0), +(@Cguid+28, 11446, 429, 2, 0, 0, 759.706, 415.478, 40.4794, 0.750492, 86400, 0, 0), +(@Cguid+29, 11446, 429, 2, 0, 0, 819.916, 391.366, 40.4797, 1.48353, 86400, 0, 0), +(@Cguid+30, 11446, 429, 2, 0, 0, 764.541, 548.918, 40.4821, 5.44543, 86400, 0, 0), +(@Cguid+31, 11446, 429, 2, 0, 0, 814.476, 570.523, 40.479, 4.86947, 86400, 0, 0), +(@Cguid+32, 11446, 429, 2, 0, 0, 879.467, 549.782, 40.48, 4.08407, 86400, 0, 0), +(@Cguid+33, 11446, 429, 2, 0, 0, 909.916, 505.704, 40.479, 3.47321, 86400, 0, 0), +(@Cguid+34, 11446, 429, 2, 0, 0, 852.577, 564.638, 40.4802, 4.43314, 86400, 0, 0), +(@Cguid+35, 11446, 429, 2, 0, 0, 851.739, 398.095, 40.4801, 1.85005, 86400, 0, 0), +(@Cguid+36, 11446, 429, 2, 0, 0, 902.99, 442.14, 40.4793, 2.68781, 86400, 0, 0), +(@Cguid+37, 11446, 429, 2, 0, 0, 794.689, 394.92, 40.4798, 1.20428, 86400, 0, 0), +(@Cguid+38, 11448, 429, 2, 0, 0, 379.625, 466.833, -7.14894, 5.77704, 86400, 0, 0), +(@Cguid+39, 11448, 429, 2, 0, 0, 581.503, 596.278, -4.67144, 0.05236, 86400, 0, 0), +(@Cguid+40, 11448, 429, 2, 0, 0, 593.01, 596.731, -4.67143, 3.15905, 86400, 0, 0), +(@Cguid+41, 11448, 429, 2, 0, 0, 568.204, 479.525, 29.5475, 3.22886, 86400, 0, 0), +(@Cguid+42, 11448, 429, 2, 0, 0, 518.04, 562.212, 27.9994, 5.21853, 86400, 0, 0), +(@Cguid+43, 11448, 429, 2, 0, 0, 476.998, 565.548, 27.9979, 5.44543, 86400, 0, 0), +(@Cguid+44, 11448, 429, 2, 0, 0, 580.365, 565.465, -4.67144, 0.034907, 86400, 0, 0), +(@Cguid+45, 11448, 429, 2, 0, 0, 480.812, 600.12, -25.3203, 1.13446, 86400, 0, 0), +(@Cguid+46, 11448, 429, 2, 0, 0, 483.991, 607.756, -25.3214, 4.38078, 86400, 0, 0), +(@Cguid+47, 11448, 429, 2, 0, 0, 579.373, 590.731, -25.3194, 1.88496, 86400, 0, 0), +(@Cguid+48, 11448, 429, 2, 0, 0, 572.401, 599.51, -25.3194, 5.49779, 86400, 0, 0), +(@Cguid+49, 11448, 429, 2, 0, 0, 548.933, 575.927, -4.67144, 2.28638, 86400, 0, 0), +(@Cguid+50, 11448, 429, 2, 0, 0, 425.414, 543.026, -18.26, 3.61283, 86400, 0, 0), +(@Cguid+51, 11448, 429, 2, 0, 0, 584.833, 544.572, -25.3159, 2.28638, 86400, 0, 0), +(@Cguid+52, 11448, 429, 2, 0, 0, 577.443, 549.148, -25.3152, 5.37561, 86400, 0, 0), +(@Cguid+53, 11441, 429, 2, 0, 1, 402.45, 333.237, 2.9312, 0.191986, 86400, 0, 0), +(@Cguid+54, 11441, 429, 2, 0, 1, 439.642, 134.562, -2.4987, 6.19592, 86400, 0, 0), +(@Cguid+55, 11441, 429, 2, 0, 1, 450.071, 134.044, -2.49898, 3.14159, 86400, 0, 0), +(@Cguid+56, 11441, 429, 2, 0, 1, 445.038, 350.688, 2.93627, 1.62316, 86400, 0, 0), +(@Cguid+57, 11441, 429, 2, 0, 1, 289.288, -75.3393, -3.80366, 0.855211, 86400, 0, 0), +(@Cguid+58, 11441, 429, 2, 0, 1, 297.368, -66.7381, -3.80376, 3.92699, 86400, 0, 0), +(@Cguid+59, 11441, 429, 2, 0, 1, 404.442, 180.283, 2.93519, 5.39307, 86400, 0, 0), +(@Cguid+60, 11441, 429, 2, 0, 1, 367.083, 36.711, -24.7118, 4.64258, 86400, 0, 0), +(@Cguid+61, 11441, 429, 2, 0, 1, 375.465, 26.511, -25.888, 3.05433, 86400, 0, 0), +(@Cguid+62, 11441, 429, 2, 0, 1, 417.915, 292.252, 11.1982, 3.60941, 86400, 0, 0), +(@Cguid+63, 11441, 429, 2, 0, 1, 312.086, 182.917, 2.93627, 4.36332, 86400, 0, 0), +(@Cguid+64, 11441, 429, 2, 0, 1, 326.912, 360.968, 2.93626, 4.74729, 86400, 0, 0), +(@Cguid+65, 11441, 429, 2, 0, 1, 469.788, 46.4686, -3.91727, 1.44576, 86400, 0, 2), +(@Cguid+66, 11441, 429, 2, 0, 1, 310.688, -12.7194, -3.80129, 6.19592, 86400, 0, 0), +(@Cguid+67, 11441, 429, 2, 0, 1, 387.546, 135.562, -2.50008, 2.00713, 86400, 0, 0), +(@Cguid+68, 11441, 429, 2, 0, 1, 301.618, 48.9438, -3.88544, 0.541052, 86400, 0, 0), +(@Cguid+69, 11441, 429, 2, 0, 1, 391.712, 102.586, -3.80363, 0.541052, 86400, 0, 0), +(@Cguid+70, 11441, 429, 2, 0, 1, 262.402, 94.8272, -2.47626, 3.21141, 86400, 0, 0), +(@Cguid+71, 11441, 429, 2, 0, 1, 431.271, 75.9517, -23.5555, 3.76991, 86400, 0, 0), +(@Cguid+72, 11441, 429, 2, 0, 1, 321.913, 132.877, -2.49938, 5.37561, 86400, 0, 0), +(@Cguid+73, 11441, 429, 2, 0, 1, 316.945, 239.888, 11.2093, 3.14159, 86400, 0, 0), +(@Cguid+74, 11441, 429, 2, 0, 1, 292.932, 264.732, 2.94989, 3.7001, 86400, 0, 0), +(@Cguid+75, 11441, 429, 2, 0, 1, 281.884, 257.988, 2.9364, 0.541052, 86400, 0, 0), +(@Cguid+76, 11441, 429, 2, 0, 1, 469.761, 66.3496, -3.80288, 4.27606, 86400, 0, 0), +(@Cguid+77, 11441, 429, 2, 0, 1, 352.292, 219.206, 11.2871, 4.60767, 86400, 0, 0), +(@Cguid+78, 11441, 429, 2, 0, 1, 484.79, 192.536, 2.93627, 3.22886, 86400, 0, 0), +(@Cguid+79, 11441, 429, 2, 0, 1, 480.492, 171.572, 2.93626, 0.855211, 86400, 0, 0), +(@Cguid+80, 11441, 429, 2, 0, 1, 357.101, -105.233, -3.8031, 3.735, 86400, 0, 0), +(@Cguid+81, 11441, 429, 2, 0, 1, 420.708, 212.934, 11.2148, 4.02882, 86400, 0, 0), +(@Cguid+82, 11441, 429, 2, 0, 1, 253.919, 101.484, -2.47626, 4.79965, 86400, 0, 0), +(@Cguid+83, 11441, 429, 2, 0, 1, 293.43, 22.6771, -3.83323, 1.71042, 86400, 0, 0), +(@Cguid+84, 11441, 429, 2, 0, 1, 290, 43.9366, -3.84639, 4.88692, 86400, 0, 0), +(@Cguid+85, 11441, 429, 2, 0, 1, 387.18, 212.206, 11.2158, 3.16332, 86400, 0, 2), +(@Cguid+86, 11441, 429, 2, 0, 1, 414.897, 260.269, 11.2061, 4.6183, 86400, 5, 1), +(@Cguid+87, 11441, 429, 2, 0, 1, 378.439, 136.133, -2.50067, 0.925025, 86400, 0, 0), +(@Cguid+88, 11441, 429, 2, 0, 1, 325.94, 124.511, -3.80362, 1.88496, 86400, 0, 0), +(@Cguid+89, 11441, 429, 2, 0, 1, 350.716, 306.468, 11.2068, 1.12018, 86400, 0, 0), +(@Cguid+90, 11441, 429, 2, 0, 1, 338.808, 208.337, 11.2875, 1.37881, 86400, 0, 0), +(@Cguid+91, 11445, 429, 2, 0, 1, 692.195, 511.417, 28.2594, 2.87979, 86400, 0, 0), +(@Cguid+92, 11445, 429, 2, 0, 1, 743.179, 436.379, 28.2657, 4.17134, 86400, 0, 0), +(@Cguid+93, 11445, 429, 2, 0, 1, 667.484, 467.305, 29.5391, 4.20624, 86400, 0, 0), +(@Cguid+94, 11445, 429, 2, 0, 1, 676.629, 460.347, 29.5408, 3.19395, 86400, 0, 0), +(@Cguid+95, 11445, 429, 2, 0, 1, 681.03, 504.275, 29.5437, 1.48353, 86400, 0, 0), +(@Cguid+96, 11450, 429, 2, 0, 1, 387.409, 462.772, -7.14894, 2.68781, 86400, 0, 0), +(@Cguid+97, 11450, 429, 2, 0, 1, 419.015, 538.269, -18.26, 0.488692, 86400, 0, 0), +(@Cguid+98, 11450, 429, 2, 0, 1, 530.169, 580.439, -25.3194, 1.41372, 86400, 0, 0), +(@Cguid+99, 11450, 429, 2, 0, 1, 530.206, 600.875, -25.3194, 4.86947, 86400, 0, 0), +(@Cguid+100, 11450, 429, 2, 0, 1, 593.228, 565.12, -4.67144, 3.10669, 86400, 0, 0), +(@Cguid+101, 11450, 429, 2, 0, 1, 484.101, 523.808, 27.9977, 1.44862, 86400, 0, 0), +(@Cguid+102, 11450, 429, 2, 0, 1, 497.733, 523.807, 27.9982, 1.64061, 86400, 0, 0), +(@Cguid+103, 11450, 429, 2, 0, 1, 480.264, 558.168, 27.9953, 1.85005, 86400, 0, 0), +(@Cguid+104, 11450, 429, 2, 0, 1, 485.141, 564.946, 27.9951, 3.21141, 86400, 0, 0), +(@Cguid+105, 11450, 429, 2, 0, 1, 565.936, 486.725, 29.5474, 4.2586, 86400, 0, 0), +(@Cguid+106, 11450, 429, 2, 0, 1, 559.22, 477.314, 29.5474, 0.855211, 86400, 0, 0), +(@Cguid+107, 11450, 429, 2, 0, 1, 688.459, 505.916, 29.5529, 2.30383, 86400, 0, 0), +(@Cguid+108, 11450, 429, 2, 0, 1, 541.695, 582.741, -4.67144, 5.67232, 86400, 0, 0), +(@Cguid+109, 11450, 429, 2, 0, 1, 522.958, 554.504, 28.0006, 2.19911, 86400, 0, 0), +(@Cguid+110, 11450, 429, 2, 0, 1, 748.483, 433.161, 28.2665, 3.56047, 86400, 0, 0), +(@Cguid+111, 13036, 429, 2, 0, 0, 725.086, 486.37, 28.2642, 4.36332, 86400, 0, 0), +(@Cguid+112, 13036, 429, 2, 0, 0, 719.403, 477.228, 28.263, 5.86431, 86400, 0, 0), +(@Cguid+113, 13036, 429, 2, 0, 0, 712.803, 468.677, 28.2616, 5.06145, 86400, 0, 0), +(@Cguid+114, 13036, 429, 2, 0, 0, 724.21, 464.514, 28.2634, 0.925025, 86400, 0, 0), +(@Cguid+115, 13036, 429, 2, 0, 0, 715.356, 492.574, 28.2628, 4.74729, 86400, 0, 0), +(@Cguid+116, 13036, 429, 2, 0, 0, 729.782, 497.977, 28.1809, 1.0012, 86400, 0, 0), +(@Cguid+117, 13036, 429, 2, 0, 0, 731.356, 440.905, 28.1809, 3.69297, 86400, 0, 0), +(@Cguid+118, 13036, 429, 2, 0, 0, 730.857, 454.202, 28.1818, 4.64055, 86400, 0, 0), +(@Cguid+119, 13036, 429, 2, 0, 0, 735.317, 444.417, 28.1823, 0.813315, 86400, 0, 0), +(@Cguid+120, 13036, 429, 2, 0, 0, 340.884, -22.1709, -25.0456, 5.84685, 86400, 0, 0), +(@Cguid+121, 13036, 429, 2, 0, 0, 357.606, -31.0619, -25.3087, 1.57987, 86400, 0, 0), +(@Cguid+122, 13036, 429, 2, 0, 0, 349.138, -36.2457, -25.3775, 0.750492, 86400, 0, 0), +(@Cguid+123, 13036, 429, 2, 0, 0, 341.746, -30.117, -25.1938, 3.12414, 86400, 0, 0), +(@Cguid+124, 13036, 429, 2, 0, 0, 382.306, -69.0369, -23.5575, 1.91986, 86400, 0, 0), +(@Cguid+125, 13036, 429, 2, 0, 0, 377.483, -51.7621, -24.1065, 2.63545, 86400, 0, 0), +(@Cguid+126, 13036, 429, 2, 0, 0, 382.778, -47.0005, -23.906, 4.95674, 86400, 0, 0), +(@Cguid+127, 13036, 429, 2, 0, 0, 374.831, -59.13, -24.1519, 0.418879, 86400, 0, 0), +(@Cguid+128, 13036, 429, 2, 0, 0, 399.18, 16.25, -25.5551, 4.4731, 86400, 0, 0), +(@Cguid+129, 13036, 429, 2, 0, 0, 407.789, -50.7201, -23.0973, 1.5708, 86400, 0, 0), +(@Cguid+130, 13036, 429, 2, 0, 0, 428.65, -35.0334, -24.7101, 0.884373, 86400, 0, 0), +(@Cguid+131, 13036, 429, 2, 0, 0, 415.32, -37.0531, -23.9358, 4.29386, 86400, 0, 0), +(@Cguid+132, 13036, 429, 2, 0, 0, 428.125, 79.5227, -23.7273, 3.03687, 86400, 0, 0), +(@Cguid+133, 13036, 429, 2, 0, 0, 426.051, 73.2831, -23.4526, 0.296706, 86400, 0, 0), +(@Cguid+134, 13036, 429, 2, 0, 0, 434.372, 68.875, -23.2256, 5.39307, 86400, 0, 0), +(@Cguid+135, 13036, 429, 2, 0, 0, 448.359, 304.18, 11.2033, 3.98352, 86400, 0, 0), +(@Cguid+136, 13036, 429, 2, 0, 0, 441.873, 292.296, 11.2877, 1.20428, 86400, 0, 0), +(@Cguid+137, 13036, 429, 2, 0, 0, 399.746, 102.826, -3.80367, 1.8326, 86400, 0, 0), +(@Cguid+138, 13036, 429, 2, 0, 0, 402.409, 171.529, 2.93519, 3.28122, 86400, 0, 0), +(@Cguid+139, 13036, 429, 2, 0, 0, 410.881, 174.518, 2.93516, 1.67552, 86400, 0, 0), +(@Cguid+140, 13036, 429, 2, 0, 0, 412.8, 183.446, 2.93557, 0.645772, 86400, 0, 0), +(@Cguid+141, 13036, 429, 2, 0, 0, 433.926, 168.443, 2.85223, 3.27681, 86400, 0, 0), +(@Cguid+142, 13036, 429, 2, 0, 0, 436.521, 171.8, 2.85232, 3.38357, 86400, 0, 0), +(@Cguid+143, 13036, 429, 2, 0, 0, 409.139, 327.11, 2.93415, 6.0912, 86400, 0, 0), +(@Cguid+144, 13036, 429, 2, 0, 0, 408.077, 23.4038, -25.356, 5.84685, 86400, 0, 0), +(@Cguid+145, 13036, 429, 2, 0, 0, 413.974, 15.749, -25.0879, 2.54818, 86400, 0, 0), +(@Cguid+146, 13036, 429, 2, 0, 0, 341.223, -61.7868, -25.4697, 2.46091, 86400, 0, 0), +(@Cguid+147, 13036, 429, 2, 0, 0, 352.286, -57.7756, -25.8241, 0.804581, 86400, 0, 0), +(@Cguid+148, 13036, 429, 2, 0, 0, 335.31, -54.8641, -25.8178, 1.0472, 86400, 0, 0), +(@Cguid+149, 13036, 429, 2, 0, 0, 356.844, -67.5697, -26.1843, 4.65561, 86400, 0, 0), +(@Cguid+150, 13036, 429, 2, 0, 0, 439.126, 359.171, 3.86281, 0.384838, 86400, 0, 0), +(@Cguid+151, 13036, 429, 2, 0, 0, 444.332, 342.271, 2.93627, 1.16937, 86400, 0, 0), +(@Cguid+152, 13036, 429, 2, 0, 0, 451.231, 358.101, 3.8628, 3.69278, 86400, 0, 0), +(@Cguid+153, 13036, 429, 2, 0, 0, 311.978, 173.334, 2.93627, 2.00713, 86400, 0, 0), +(@Cguid+154, 13036, 429, 2, 0, 0, 318.378, 360.432, 2.85293, 5.02763, 86400, 0, 0), +(@Cguid+155, 13036, 429, 2, 0, 0, 325.075, 351.874, 2.93626, 1.3439, 86400, 0, 0), +(@Cguid+156, 13036, 429, 2, 0, 0, 780.872, 483.796, 36.0493, 4.05614, 86400, 0, 0), +(@Cguid+157, 13036, 429, 2, 0, 0, 792.718, 495.528, 37.3182, 3.61377, 86400, 5, 1), +(@Cguid+158, 13036, 429, 2, 0, 0, 778.848, 490.062, 35.1498, 3.45469, 86400, 5, 1), +(@Cguid+159, 13036, 429, 2, 0, 0, 399.836, 220.873, 11.2113, 4.08073, 86400, 0, 0), +(@Cguid+160, 13036, 429, 2, 0, 0, 387.138, 203.458, 11.2161, 4.61475, 86400, 5, 1), +(@Cguid+161, 13036, 429, 2, 0, 0, 355.238, -18.4445, -25.1449, 2.0674, 86400, 0, 0), +(@Cguid+162, 13036, 429, 2, 0, 0, 409.935, 335.965, 2.84705, 3.19855, 86400, 0, 0), +(@Cguid+163, 13036, 429, 2, 0, 0, 404.258, 342.263, 2.84682, 0.80796, 86400, 0, 0), +(@Cguid+164, 13036, 429, 2, 0, 0, 412.695, -61.5281, -25.3884, 6.03884, 86400, 0, 0), +(@Cguid+165, 13036, 429, 2, 0, 0, 420.648, -49.2333, -23.81, 0.958851, 86400, 0, 0), +(@Cguid+166, 13036, 429, 2, 0, 0, 334.235, 357.029, 2.93627, 3.4383, 86400, 0, 0), +(@Cguid+167, 13036, 429, 2, 0, 0, 464.224, 26.2598, -3.9254, 1.44948, 86400, 0, 0), +(@Cguid+168, 13036, 429, 2, 0, 0, 466.826, 22.9091, -3.9267, 1.52329, 86400, 0, 0), +(@Cguid+169, 13036, 429, 2, 0, 0, 434.5, 304.634, 11.2862, 1.8326, 86400, 0, 0), +(@Cguid+170, 13036, 429, 2, 0, 0, 386.18, -59.6284, -23.0857, 3.68265, 86400, 0, 0), +(@Cguid+171, 13036, 429, 2, 0, 0, 404.756, 9.16734, -24.9806, 5.37936, 86400, 5, 1), +(@Cguid+172, 13036, 429, 2, 0, 0, 304.092, 183.315, 2.93627, 0.314159, 86400, 0, 0), +(@Cguid+173, 13036, 429, 2, 0, 0, 319.061, 181.406, 2.93627, 3.36848, 86400, 0, 0), +(@Cguid+174, 13036, 429, 2, 0, 0, 415.292, 32.0243, -25.0731, 2.00533, 86400, 0, 0), +(@Cguid+175, 13036, 429, 2, 0, 0, 404.637, 33.3228, -25.3474, 1.09309, 86400, 0, 0), +(@Cguid+176, 13036, 429, 2, 0, 0, 397.051, 108.892, -3.80362, 3.85718, 86400, 0, 0), +(@Cguid+177, 13036, 429, 2, 0, 0, 391.716, 110.485, -3.80361, 5.81195, 86400, 0, 0), +(@Cguid+178, 13036, 429, 2, 0, 0, 347.183, -67.9546, -25.8799, 0.77538, 86400, 0, 0); + +DELETE FROM `creature_addon` WHERE `guid` IN (@Cguid+9, @Cguid+65, @Cguid+85); +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(@Cguid+9,@Cguid+9*10,0,0,0,0, ''), +(@Cguid+65,@Cguid+65*10,0,0,0,0, ''), +(@Cguid+85,@Cguid+85*10,0,0,0,0, ''); + +DELETE FROM `waypoint_data` WHERE `id` IN (@Cguid+9*10, @Cguid+65*10, @Cguid+85*10); +INSERT INTO `waypoint_data`(`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES +(@Cguid+9*10, 1, 442.135, 168.735, 2.85342), +(@Cguid+9*10, 2, 450.931, 164.414, 2.85342), +(@Cguid+9*10, 3, 460.57, 162.294, 2.85342), +(@Cguid+9*10, 4, 468.127, 163.767, 2.85342), +(@Cguid+9*10, 5, 472.599, 168.592, 2.85342), +(@Cguid+9*10, 6, 475.572, 176.822, 2.85342), +(@Cguid+9*10, 7, 472.075, 182.395, 2.85342), +(@Cguid+9*10, 8, 463.501, 184.145, 2.85296), +(@Cguid+9*10, 9, 452.911, 181.483, 2.85296), +(@Cguid+9*10, 10, 437.194, 176.868, 2.85296), +(@Cguid+9*10, 11, 421.478, 172.254, 2.85296), +(@Cguid+9*10, 12, 409.993, 168.882, 2.85296), +(@Cguid+9*10, 13, 392.501, 168.334, 2.85296), +(@Cguid+9*10, 14, 376.129, 167.837, 2.85024), +(@Cguid+9*10, 15, 358.637, 167.307, 2.85024), +(@Cguid+9*10, 16, 343.384, 166.844, 2.85024), +(@Cguid+9*10, 17, 329.18, 166.413, 2.85152), +(@Cguid+9*10, 18, 313.857, 165.948, 2.85152), +(@Cguid+9*10, 19, 309.247, 174.596, 2.85152), +(@Cguid+9*10, 20, 306.336, 185.121, 2.85152), +(@Cguid+9*10, 21, 303.704, 194.634, 2.85152), +(@Cguid+9*10, 22, 297.923, 199.612, 2.85152), +(@Cguid+9*10, 23, 292.069, 202.459, 2.85152), +(@Cguid+9*10, 24, 283.32, 202.297, 2.85152), +(@Cguid+9*10, 25, 276.718, 198.472, 2.85152), +(@Cguid+9*10, 26, 273.014, 193.034, 2.85152), +(@Cguid+9*10, 27, 275.28, 184.582, 2.85152), +(@Cguid+9*10, 28, 280.487, 179.006, 2.85152), +(@Cguid+9*10, 29, 291.396, 173.91, 2.85152), +(@Cguid+9*10, 30, 305.235, 170.686, 2.85152), +(@Cguid+9*10, 31, 320.203, 167.747, 2.85152), +(@Cguid+9*10, 32, 336.49, 169.461, 2.85152), +(@Cguid+9*10, 33, 356.008, 167.671, 2.84997), +(@Cguid+9*10, 34, 374.529, 166.631, 2.84997), +(@Cguid+9*10, 35, 392.021, 167.162, 2.85354), +(@Cguid+9*10, 36, 407.344, 167.626, 2.85354), +(@Cguid+9*10, 37, 417.679, 171.152, 2.8521), +(@Cguid+65*10, 1, 472.197, 53.2145, -3.88626), +(@Cguid+65*10, 2, 473.194, 64.0889, -3.88626), +(@Cguid+65*10, 3, 472.972, 76.0569, -3.88626), +(@Cguid+65*10, 4, 472.027, 91.2871, -3.88626), +(@Cguid+65*10, 5, 467.937, 103.717, -3.88626), +(@Cguid+65*10, 6, 460.131, 112.792, -3.88626), +(@Cguid+65*10, 7, 446.05, 114.699, -3.88626), +(@Cguid+65*10, 8, 434.096, 115.322, -3.88626), +(@Cguid+65*10, 9, 419.905, 116.063, -3.88626), +(@Cguid+65*10, 10, 405.74, 117.193, -3.88626), +(@Cguid+65*10, 11, 390.459, 118.413, -3.88626), +(@Cguid+65*10, 12, 377.411, 119.454, -3.88626), +(@Cguid+65*10, 13, 358.919, 120.929, -3.88626), +(@Cguid+65*10, 14, 346.022, 118.693, -3.88688), +(@Cguid+65*10, 15, 330.928, 116.014, -3.88688), +(@Cguid+65*10, 16, 313.697, 112.956, -3.88688), +(@Cguid+65*10, 17, 298.672, 110.29, -3.88688), +(@Cguid+65*10, 18, 291.316, 105.551, -3.88688), +(@Cguid+65*10, 19, 290.928, 96.81, -3.89224), +(@Cguid+65*10, 20, 296.896, 88.9496, -3.94951), +(@Cguid+65*10, 21, 304.51, 87.7965, -3.95713), +(@Cguid+65*10, 22, 306.56, 95.1458, -3.91082), +(@Cguid+65*10, 23, 309.453, 105.676, -3.88691), +(@Cguid+65*10, 24, 319.53, 109.883, -3.88691), +(@Cguid+65*10, 25, 331.609, 114.927, -3.88691), +(@Cguid+65*10, 26, 346.437, 118.531, -3.88691), +(@Cguid+65*10, 27, 366.053, 119.989, -3.88688), +(@Cguid+65*10, 28, 382.427, 120.417, -3.88688), +(@Cguid+65*10, 29, 403.157, 118.844, -3.88688), +(@Cguid+65*10, 30, 421.654, 117.441, -3.88688), +(@Cguid+65*10, 31, 436.94, 116.282, -3.88688), +(@Cguid+65*10, 32, 453.399, 110.336, -3.88688), +(@Cguid+65*10, 33, 462.091, 100.455, -3.88688), +(@Cguid+65*10, 34, 470.142, 84.9167, -3.8865), +(@Cguid+65*10, 35, 475.162, 73.9736, -3.8865), +(@Cguid+65*10, 36, 473.823, 58.7022, -3.8865), +(@Cguid+65*10, 37, 472.636, 45.6663, -3.8865), +(@Cguid+65*10, 38, 469.196, 31.8792, -3.89542), +(@Cguid+65*10, 39, 468.308, 18.8193, -3.90732), +(@Cguid+65*10, 40, 464.428, 14.9778, -3.90474), +(@Cguid+65*10, 41, 460.413, 9.85398, -3.89766), +(@Cguid+65*10, 42, 459.58, 1.14371, -3.8957), +(@Cguid+65*10, 43, 464.664, -4.54537, -3.90719), +(@Cguid+65*10, 44, 470.113, -4.89415, -3.89107), +(@Cguid+65*10, 45, 474.069, 0.363454, -3.9255), +(@Cguid+65*10, 46, 474.077, 6.94345, -3.92959), +(@Cguid+65*10, 47, 472.317, 14.4396, -3.92072), +(@Cguid+65*10, 48, 470.901, 23.0034, -3.90916), +(@Cguid+65*10, 49, 469.542, 31.6471, -3.89763), +(@Cguid+85*10, 1, 376.477, 216.907, 11.2042), +(@Cguid+85*10, 2, 363.732, 222.789, 11.2044), +(@Cguid+85*10, 3, 355.696, 228.519, 11.2044), +(@Cguid+85*10, 4, 345.245, 242.469, 11.2044), +(@Cguid+85*10, 5, 339.532, 257.82, 11.2044), +(@Cguid+85*10, 6, 337.245, 270.709, 11.2044), +(@Cguid+85*10, 7, 337.428, 284.918, 11.2044), +(@Cguid+85*10, 8, 338.399, 298.04, 11.2044), +(@Cguid+85*10, 9, 352.562, 299.195, 11.2055), +(@Cguid+85*10, 10, 366.725, 300.35, 11.2067), +(@Cguid+85*10, 11, 387.5, 300.998, 11.2071), +(@Cguid+85*10, 12, 401.707, 301.261, 11.2071), +(@Cguid+85*10, 13, 415.845, 301.523, 11.2071), +(@Cguid+85*10, 14, 429.857, 299.626, 11.2054), +(@Cguid+85*10, 15, 437.782, 293.861, 11.204), +(@Cguid+85*10, 16, 438.926, 283.001, 11.2053), +(@Cguid+85*10, 17, 439.421, 268.8, 11.2058), +(@Cguid+85*10, 18, 439.908, 254.598, 11.2061), +(@Cguid+85*10, 19, 439.119, 241.462, 11.2061), +(@Cguid+85*10, 20, 437.965, 226.245, 11.2061), +(@Cguid+85*10, 21, 428.057, 219.528, 11.2041), +(@Cguid+85*10, 22, 416.777, 215.32, 11.2041), +(@Cguid+85*10, 23, 404.033, 212.328, 11.2061); |