diff options
| -rw-r--r-- | sql/updates/world/2016_01_01_00_world.sql | 133 |
1 files changed, 133 insertions, 0 deletions
diff --git a/sql/updates/world/2016_01_01_00_world.sql b/sql/updates/world/2016_01_01_00_world.sql new file mode 100644 index 00000000000..889f968b6c4 --- /dev/null +++ b/sql/updates/world/2016_01_01_00_world.sql @@ -0,0 +1,133 @@ +-- +SET @guid=250899; +DELETE FROM `creature` WHERE `guid` BETWEEN @guid+0 AND @guid+70; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseid`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES +(@guid+0, 49945, 530, 1, 0, 36923, 0, 7562.98, -6890.36, 96.11, 1.25664, 300, 0, 0, 562, 1633, 0), +(@guid+1, 49946, 530, 1, 0, 36922, 0, 7555.75, -6881.65, 96.11, 4.76475, 300, 0, 0, 640, 655, 0), +(@guid+2, 49949, 530, 1, 0, 36921, 0, 7558.24, -6897.9, 96.11, 1.46608, 300, 0, 0, 699, 100, 0), +(@guid+3, 49950, 530, 1, 0, 36920, 0, 7564.74, -6887.96, 96.11, 4.01426, 300, 0, 0, 562, 1633, 0), +(@guid+4, 49952, 530, 1, 0, 36919, 0, 7552.37, -6881.98, 96.11, 2.60054, 300, 0, 0, 590, 1633, 0), +(@guid+5, 49954, 530, 1, 0, 36918, 0, 7552.26, -6887.38, 96.11, 4.60767, 300, 0, 0, 640, 655, 0), +(@guid+6, 49955, 530, 1, 0, 36917, 0, 7552.21, -6889.55, 96.11, 1.64061, 300, 0, 0, 699, 0, 0), +(@guid+7, 51902, 530, 1, 0, 15511, 0, 7514.06, -6838.54, 83.7541, 4.71239, 300, 0, 0, 116235, 0, 0), +(@guid+8, 51902, 530, 1, 0, 15511, 0, 7581.58, -6817.63, 86.2394, 0.172672, 300, 0, 0, 116235, 0, 2), +(@guid+9, 51902, 530, 1, 0, 15511, 0, 7540.93, -6818.74, 85.2167, 3.1455, 300, 0, 0, 116235, 0, 2), +(@guid+10, 51902, 530, 1, 0, 15511, 0, 7582.64, -6815.27, 86.3208, 0.785164, 300, 0, 0, 116235, 0, 2), +(@guid+11, 51902, 530, 1, 0, 15511, 0, 7626.04, -6846, 84.0313, 4.19385, 300, 0, 0, 116235, 0, 0), +(@guid+12, 51902, 530, 1, 0, 15511, 0, 7643.56, -6817.37, 79.2091, 5.00687, 300, 0, 0, 116235, 0, 0), +(@guid+13, 52938, 530, 1, 0, 38095, 0, 6750.67, -7729.65, 129.976, 5.68977, 300, 0, 0, 232470, 0, 0), +(@guid+14, 52938, 530, 1, 0, 38095, 0, 6753.26, -7756.97, 129.755, 3.38712, 300, 0, 0, 232470, 0, 0), +(@guid+15, 52938, 530, 1, 0, 38095, 0, 6780.78, -7719.82, 126.907, 0.715585, 300, 0, 0, 232470, 0, 0), +(@guid+16, 52938, 530, 1, 0, 38092, 0, 6759.3, -7729.95, 129.976, 3.76991, 300, 0, 0, 232470, 0, 0), +(@guid+17, 52938, 530, 1, 0, 38092, 0, 6779.34, -7711.33, 126.834, 0.575959, 300, 0, 0, 232470, 0, 0), +(@guid+18, 52938, 530, 1, 0, 38095, 0, 6775.38, -7711.49, 126.927, 0.610865, 300, 0, 0, 232470, 0, 0), +(@guid+19, 52938, 530, 1, 0, 38095, 0, 6765.49, -7735.35, 129.976, 2.94961, 300, 0, 0, 232470, 0, 0), +(@guid+20, 52938, 530, 1, 0, 38092, 0, 6750.1, -7737.19, 129.976, 0.663225, 300, 0, 0, 232470, 0, 0), +(@guid+21, 52938, 530, 1, 0, 38094, 0, 6737.66, -7748.35, 137.421, 3.87463, 300, 0, 0, 232470, 0, 0), +(@guid+22, 52938, 530, 1, 0, 38092, 0, 6755.21, -7723.88, 129.976, 4.83456, 300, 0, 0, 232470, 0, 0), +(@guid+23, 52938, 530, 1, 0, 38094, 0, 6781.95, -7715.75, 126.604, 0.575959, 300, 0, 0, 232470, 0, 0), +(@guid+24, 52938, 530, 1, 0, 38092, 0, 6750.85, -7746.96, 129.976, 1.39626, 300, 0, 0, 232470, 0, 0), +(@guid+25, 53067, 530, 1, 0, 28222, 0, 6783.57, -7705.95, 127.689, 4.79965, 300, 0, 0, 82994000, 4655000, 0), +(@guid+26, 53068, 530, 1, 0, 19707, 0, 6787.56, -7712.54, 126.556, 2.51327, 300, 0, 0, 8299400, 74480, 0), +(@guid+27, 53069, 530, 1, 0, 31736, 0, 6782.63, -7711.92, 126.823, 0.680678, 300, 0, 0, 30996000, 142528, 0), +(@guid+28, 53070, 530, 1, 0, 28755, 0, 6792.86, -7573.88, 127.269, 5.67232, 300, 0, 0, 774900, 0, 0), +(@guid+29, 53070, 530, 1, 0, 28756, 0, 6769.3, -7652.87, 127.274, 4.88692, 300, 0, 0, 774900, 0, 0), +(@guid+30, 53070, 530, 1, 0, 28755, 0, 6776, -7653.46, 127.318, 4.36332, 300, 0, 0, 774900, 0, 0), +(@guid+31, 53070, 530, 1, 0, 28755, 0, 6785.05, -7701.83, 127.974, 5.13127, 300, 0, 0, 774900, 0, 0), +(@guid+32, 53070, 530, 1, 0, 28754, 0, 6755.86, -7686.43, 127.325, 5.16617, 300, 0, 0, 774900, 0, 0), +(@guid+33, 53070, 530, 1, 0, 28756, 0, 6783.33, -7699.49, 128.026, 5.13127, 300, 0, 0, 774900, 0, 0), +(@guid+34, 53070, 530, 1, 0, 28754, 0, 6736.6, -7606.33, 126.186, 5.75959, 300, 0, 0, 774900, 0, 0), +(@guid+35, 53070, 530, 1, 0, 28755, 0, 6778.09, -7703.3, 127.706, 5.13127, 300, 0, 0, 774900, 0, 0), +(@guid+36, 53070, 530, 1, 0, 28754, 0, 6782.48, -7703.53, 127.886, 5.13127, 300, 0, 0, 774900, 0, 0), +(@guid+37, 53070, 530, 1, 0, 28756, 0, 6764.15, -7611.73, 128.545, 4.83456, 300, 0, 0, 774900, 0, 0), +(@guid+38, 53070, 530, 1, 0, 28755, 0, 6782.21, -7593.43, 127.944, 4.83456, 300, 0, 0, 774900, 0, 0), +(@guid+39, 53070, 530, 1, 0, 28756, 0, 6777.74, -7596.62, 128.462, 4.83456, 300, 0, 0, 774900, 0, 0), +(@guid+40, 53070, 530, 1, 0, 28754, 0, 6738.81, -7614.49, 125.995, 0.558505, 300, 0, 0, 774900, 0, 0), +(@guid+41, 53070, 530, 1, 0, 28756, 0, 6762.54, -7607.6, 128.656, 4.83456, 300, 0, 0, 774900, 0, 0), +(@guid+42, 53070, 530, 1, 0, 28756, 0, 6797.67, -7576.1, 126.879, 3.01942, 300, 0, 0, 774900, 0, 0), +(@guid+43, 53070, 530, 1, 0, 28754, 0, 6778.62, -7581.28, 128.064, 5.67232, 300, 0, 0, 774900, 0, 0), +(@guid+44, 53070, 530, 1, 0, 28755, 0, 6777.19, -7594.61, 128.302, 4.83456, 300, 0, 0, 774900, 0, 0), +(@guid+45, 53070, 530, 1, 0, 28754, 0, 6779.69, -7593.94, 128.165, 4.83456, 300, 0, 0, 774900, 0, 0), +(@guid+46, 53070, 530, 1, 0, 28756, 0, 6790.07, -7687.64, 128.242, 3.82227, 300, 0, 0, 774900, 0, 0), +(@guid+47, 53070, 530, 1, 0, 28754, 0, 6779.95, -7705.48, 127.693, 5.13127, 300, 0, 0, 774900, 0, 0), +(@guid+48, 53070, 530, 1, 0, 28754, 0, 6782.77, -7595.43, 128.014, 4.83456, 300, 0, 0, 774900, 0, 0), +(@guid+49, 53070, 530, 1, 0, 28756, 0, 6737.72, -7609.73, 125.971, 0.994838, 300, 0, 0, 774900, 0, 0), +(@guid+50, 53070, 530, 1, 0, 28754, 0, 6780.65, -7701.34, 127.943, 5.13127, 300, 0, 0, 774900, 0, 0), +(@guid+51, 53070, 530, 1, 0, 28755, 0, 6780.25, -7595.94, 128.264, 4.83456, 300, 0, 0, 774900, 0, 0), +(@guid+52, 53071, 530, 1, 0, 38275, 0, 6791.96, -7713.33, 126.731, 2.11185, 300, 0, 0, 842048, 0, 0), +(@guid+53, 53071, 530, 1, 0, 38275, 0, 6788.6, -7719.07, 126.375, 2.16421, 300, 0, 0, 842048, 0, 0), +(@guid+54, 53071, 530, 1, 0, 38275, 0, 6793.53, -7715.56, 126.635, 2.11185, 300, 0, 0, 842048, 0, 0), +(@guid+55, 53071, 530, 1, 0, 38275, 0, 6787.04, -7716.85, 126.309, 2.16421, 300, 0, 0, 842048, 0, 0), +(@guid+56, 53071, 530, 1, 0, 38276, 0, 6879.77, -7746.63, 126.696, 2.25148, 300, 0, 0, 842048, 0, 0), +(@guid+57, 53071, 530, 1, 0, 38275, 0, 6887.58, -7759.79, 129.016, 2.70526, 300, 0, 0, 842048, 0, 0), +(@guid+58, 53071, 530, 1, 0, 38274, 0, 6875.72, -7746.11, 126.637, 2.16421, 300, 0, 0, 842048, 0, 0), +(@guid+59, 53071, 530, 1, 0, 38274, 0, 6841.81, -7752.15, 123.371, 0.802851, 300, 0, 0, 842048, 0, 0), +(@guid+60, 53071, 530, 1, 0, 38276, 0, 6882.2, -7744.82, 126.76, 2.11185, 300, 0, 0, 842048, 0, 0), +(@guid+61, 53071, 530, 1, 0, 38275, 0, 6855.17, -7756.89, 124.841, 2.44346, 300, 0, 0, 842048, 0, 0), +(@guid+62, 53071, 530, 1, 0, 38276, 0, 6808.27, -7760.45, 127.062, 0.541052, 300, 0, 0, 842048, 0, 0), +(@guid+63, 53071, 530, 1, 0, 38274, 0, 6880.55, -7772.11, 129.756, 2.35619, 300, 0, 0, 842048, 0, 0), +(@guid+64, 53071, 530, 1, 0, 38274, 0, 6878.2, -7744.41, 126.578, 2.25148, 300, 0, 0, 842048, 0, 0), +(@guid+65, 53071, 530, 1, 0, 38275, 0, 6789.53, -7715.14, 126.453, 2.25148, 300, 0, 0, 842048, 0, 0), +(@guid+66, 53071, 530, 1, 0, 38276, 0, 6791.09, -7717.37, 126.444, 2.25148, 300, 0, 0, 842048, 0, 0), +(@guid+67, 53071, 530, 1, 0, 38274, 0, 6816.47, -7771.03, 127.359, 0.785398, 300, 0, 0, 842048, 0, 0), +(@guid+68, 53071, 530, 1, 0, 38276, 0, 6880.64, -7742.6, 126.576, 2.11185, 300, 0, 0, 842048, 0, 0), +(@guid+69, 53071, 530, 1, 0, 38276, 0, 6877.28, -7748.33, 126.79, 2.16421, 300, 0, 0, 842048, 0, 0), +(@guid+70, 53072, 530, 1, 0, 0, 0, 6812.83, -7722.282, 125.766, 2.558998, 300, 0, 0, 0, 0, 0); + +DELETE FROM `waypoint_data` WHERE `id` IN ((@guid+8)*10, (@guid+9)*10, (@guid+10)*10); +INSERT INTO `waypoint_data`(`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES +((@guid+8)*10, 1, 7581.47, -6816.64, 86.1958), +((@guid+8)*10, 2, 7581.58, -6817.63, 86.1958), +((@guid+8)*10, 3, 7585.52, -6816.95, 85.5708), +((@guid+8)*10, 4, 7591.43, -6815.92, 84.9458), +((@guid+8)*10, 5, 7597.34, -6814.88, 84.3208), +((@guid+8)*10, 6, 7600.3, -6814.37, 83.6836), +((@guid+8)*10, 7, 7603.25, -6813.85, 82.9336), +((@guid+8)*10, 8, 7607.19, -6813.17, 82.3086), +((@guid+8)*10, 9, 7610.15, -6812.65, 81.6836), +((@guid+8)*10, 10, 7613.11, -6812.13, 81.0586), +((@guid+8)*10, 11, 7617.05, -6811.45, 80.4336), +((@guid+8)*10, 12, 7629.86, -6809.21, 79.8086), +((@guid+8)*10, 13, 7639.71, -6807.49, 79.2275), +((@guid+8)*10, 14, 7639.71, -6807.49, 79.2275), +((@guid+9)*10, 1, 7543.73, -6819.72, 85.7704), +((@guid+9)*10, 2, 7543.88, -6818.73, 85.7704), +((@guid+9)*10, 3, 7539.88, -6818.74, 85.0204), +((@guid+9)*10, 4, 7535.88, -6818.76, 84.2704), +((@guid+9)*10, 5, 7532.88, -6818.77, 83.5552), +((@guid+9)*10, 6, 7529.88, -6818.78, 82.9302), +((@guid+9)*10, 7, 7528.08, -6818.79, 82.6133), +((@guid+9)*10, 8, 7528.08, -6818.79, 82.6133), +((@guid+10)*10, 1, 7581.47, -6816.64, 86.2191), +((@guid+10)*10, 2, 7581.58, -6817.63, 86.2191), +((@guid+10)*10, 3, 7581.25, -6816.67, 86.3208), +((@guid+10)*10, 4, 7583.33, -6814.58, 86.3208), +((@guid+10)*10, 5, 7590.12, -6812.89, 85.5708), +((@guid+10)*10, 6, 7591.67, -6812.5, 85.4458), +((@guid+10)*10, 7, 7597.48, -6811.05, 84.6958), +((@guid+10)*10, 8, 7600, -6810.42, 84.1958), +((@guid+10)*10, 9, 7601.41, -6809, 83.6836), +((@guid+10)*10, 10, 7602.08, -6808.33, 83.6836), +((@guid+10)*10, 11, 7603.62, -6807.05, 83.0586), +((@guid+10)*10, 12, 7605.93, -6805.13, 82.1836), +((@guid+10)*10, 13, 7607.46, -6803.85, 81.3086), +((@guid+10)*10, 14, 7608.33, -6803.13, 81.3086), +((@guid+10)*10, 15, 7610.27, -6802.64, 80.5586), +((@guid+10)*10, 16, 7611.46, -6802.6, 80.3086), +((@guid+10)*10, 17, 7612.5, -6802.6, 80.0586), +((@guid+10)*10, 18, 7616.67, -6802.08, 79.5586), +((@guid+10)*10, 19, 7619.48, -6801.03, 78.8086), +((@guid+10)*10, 20, 7620.83, -6800.52, 78.6836), +((@guid+10)*10, 21, 7622.77, -6798.59, 77.9414), +((@guid+10)*10, 22, 7623.96, -6798.44, 77.8164), +((@guid+10)*10, 23, 7625, -6798.44, 77.6914), +((@guid+10)*10, 24, 7633.33, -6795.83, 78.0664), +((@guid+10)*10, 25, 7638.18, -6794.62, 77.2062), +((@guid+10)*10, 26, 7649.04, -6791.91, 76.9765), +((@guid+10)*10, 27, 7649.04, -6791.91, 76.9765); + +DELETE FROM `creature_addon` WHERE `guid` IN (@guid+8, @guid+9, @guid+10); +INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES +(@guid+8, (@guid+8)*10), +(@guid+9, (@guid+9)*10), +(@guid+10, (@guid+10)*10); |