mirror of
https://github.com/vmangos/core
synced 2026-08-14 16:29:10 -04:00
684 lines
61 KiB
SQL
684 lines
61 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`='20200627204553');
|
|
IF v=0 THEN
|
|
INSERT INTO `migrations` VALUES ('20200627204553');
|
|
-- Add your query below.
|
|
|
|
|
|
-- forests edge
|
|
-- add stormwind guard 80463 waypoints
|
|
UPDATE `creature` SET `position_x` = -9625.91, `position_y` = 648.695, `position_z` = 38.6521, `movement_type` = 2 WHERE `guid` = 80463;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
|
|
(80463, 1, -9625.91, 648.695, 38.6521, 100, 0, 0, 0),
|
|
(80463, 2, -9623.76, 653.384, 38.6521, 100, 0, 0, 0),
|
|
(80463, 3, -9622.76, 656.105, 38.6521, 100, 0, 0, 0),
|
|
(80463, 4, -9619.55, 663.514, 38.6522, 100, 0, 0, 0),
|
|
(80463, 5, -9613.32, 678.183, 38.6521, 100, 0, 0, 0),
|
|
(80463, 6, -9611.34, 683.016, 38.6521, 100, 0, 0, 0),
|
|
(80463, 7, -9611.34, 685.784, 38.6521, 100, 0, 0, 0),
|
|
(80463, 8, -9611.43, 686.799, 38.6521, 100, 0, 0, 0),
|
|
(80463, 9, -9612.43, 690.784, 38.6521, 100, 0, 0, 0),
|
|
(80463, 10, -9616.25, 691.774, 38.6521, 100, 0, 0, 0),
|
|
(80463, 11, -9619.87, 690.613, 38.6521, 100, 0, 0, 0),
|
|
(80463, 12, -9627.26, 676.629, 37.1529, 100, 0, 0, 0),
|
|
(80463, 13, -9630.66, 669.282, 37.1513, 100, 0, 0, 0),
|
|
(80463, 14, -9633.66, 662.105, 38.6522, 100, 0, 0, 0),
|
|
(80463, 15, -9635.15, 658.352, 38.6521, 100, 0, 0, 0),
|
|
(80463, 16, -9635.84, 654.435, 38.6521, 100, 0, 0, 0),
|
|
(80463, 17, -9634.51, 650.732, 38.6521, 100, 0, 0, 0),
|
|
(80463, 18, -9631.16, 648.651, 38.6521, 100, 0, 0, 0),
|
|
(80463, 19, -9627.21, 647.762, 38.6521, 100, 0, 0, 0);
|
|
|
|
-- add stormwind guard 80455 waypoints
|
|
UPDATE `creature` SET `position_x` = -9635.84, `position_y` = 670.504, `position_z` = 52.5756, `movement_type` = 2 WHERE `guid` = 80455;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
|
|
(80455, 1, -9635.84, 670.504, 52.5756, 100, 0, 0, 0),
|
|
(80455, 2, -9638.48, 662.928, 52.5756, 100, 0, 0, 0),
|
|
(80455, 3, -9638.7, 658.931, 52.5756, 100, 0, 0, 0),
|
|
(80455, 4, -9633.14, 654.6, 50.4932, 100, 0, 0, 0),
|
|
(80455, 5, -9629.9, 653.253, 48.5795, 100, 0, 0, 0),
|
|
(80455, 6, -9626.23, 652.409, 47.474, 100, 0, 0, 0),
|
|
(80455, 7, -9622.63, 652.93, 47.4739, 100, 0, 0, 0),
|
|
(80455, 8, -9620.84, 656.479, 47.4739, 100, 0, 0, 0),
|
|
(80455, 9, -9619.6, 660.315, 47.4739, 100, 0, 0, 0),
|
|
(80455, 10, -9616.38, 667.677, 47.4739, 100, 0, 0, 0),
|
|
(80455, 11, -9614.46, 671.513, 47.4739, 100, 0, 0, 0),
|
|
(80455, 12, -9611.32, 678.789, 47.4739, 100, 0, 0, 0),
|
|
(80455, 13, -9609.55, 682.391, 47.4739, 100, 0, 0, 0),
|
|
(80455, 14, -9615.16, 687.424, 48.6381, 100, 0, 0, 0),
|
|
(80455, 15, -9618.63, 688.961, 50.707, 100, 0, 0, 0),
|
|
(80455, 16, -9621.95, 690.225, 52.5753, 100, 0, 0, 0),
|
|
(80455, 17, -9625.85, 689.829, 52.5756, 100, 0, 0, 0),
|
|
(80455, 18, -9630.21, 683.398, 52.5756, 100, 0, 0, 0),
|
|
(80455, 19, -9631.69, 679.623, 52.5756, 100, 0, 0, 0),
|
|
(80455, 20, -9634.94, 672.239, 52.5756, 100, 0, 0, 0);
|
|
|
|
-- add stormwind guard 80444 waypoints
|
|
UPDATE `creature` SET `position_x` = -9628.23, `position_y` = 648.636, `position_z` = 62.7332, `movement_type` = 2 WHERE `guid` = 80444;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
|
|
(80444, 1, -9628.23, 648.636, 62.7332, 100, 0, 0, 0),
|
|
(80444, 2, -9635.62, 651.89, 62.7336, 100, 0, 0, 0),
|
|
(80444, 3, -9649.08, 657.328, 62.678, 100, 0, 0, 0),
|
|
(80444, 4, -9645.38, 655.816, 62.6891, 100, 0, 0, 0),
|
|
(80444, 5, -9637.88, 652.785, 62.7337, 100, 0, 0, 0),
|
|
(80444, 6, -9626.8, 647.985, 62.7332, 100, 0, 0, 0),
|
|
(80444, 7, -9613.6, 641.953, 62.6781, 100, 0, 0, 0),
|
|
(80444, 8, -9620.9, 645.289, 62.7328, 100, 0, 0, 0);
|
|
|
|
-- add stormwind guard 80462 waypoints
|
|
UPDATE `creature` SET `movement_type` = 2 WHERE `guid` = 80462;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
|
|
(80462, 1, -9621.15, 693.24, 62.7332, 100, 0, 0, 0),
|
|
(80462, 2, -9631.31, 697.477, 62.678, 100, 0, 0, 0),
|
|
(80462, 3, -9623.89, 694.383, 62.7337, 100, 0, 0, 0),
|
|
(80462, 4, -9616.57, 691.015, 62.733, 100, 0, 0, 0),
|
|
(80462, 5, -9609.09, 688.021, 62.7326, 100, 0, 0, 0),
|
|
(80462, 6, -9596.61, 682.74, 62.6781, 100, 0, 0, 0),
|
|
(80462, 7, -9603.99, 685.945, 62.7327, 100, 0, 0, 0),
|
|
(80462, 8, -9611.46, 688.906, 62.7327, 100, 0, 0, 0);
|
|
|
|
-- add stormwind guard 80484 waypoints
|
|
UPDATE `creature` SET `position_x` = -9790.6, `position_y` = 734.172, `position_z` = 33.0179, `movement_type` = 2 WHERE `guid` = 80484;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
|
|
(80484, 1, -9790.6, 734.172, 33.0179, 100, 0, 0, 0),
|
|
(80484, 2, -9780.62, 722.212, 33.017, 100, 0, 0, 0),
|
|
(80484, 3, -9780.21, 710.461, 33.1088, 100, 0, 0, 0),
|
|
(80484, 4, -9786.44, 700.557, 33.0353, 100, 0, 0, 0),
|
|
(80484, 5, -9798.45, 695.196, 33.112, 100, 2000, 0, 0),
|
|
(80484, 6, -9790.79, 697.754, 33.0282, 100, 0, 0, 0),
|
|
(80484, 7, -9782.18, 705.72, 33.0731, 100, 0, 0, 0),
|
|
(80484, 8, -9779.61, 717.149, 33.0392, 100, 0, 0, 0),
|
|
(80484, 9, -9780.62, 722.212, 33.017, 100, 0, 0, 0),
|
|
(80484, 10, -9787.31, 731.866, 33.0451, 100, 0, 0, 0),
|
|
(80484, 11, -9801.2, 734.852, 33.1115, 100, 0, 0, 0),
|
|
(80484, 12, -9812.29, 729.431, 33.089, 100, 0, 0, 0),
|
|
(80484, 13, -9818.15, 718.665, 33.1132, 100, 0, 0, 0),
|
|
(80484, 14, -9815.6, 706.033, 33.1109, 100, 0, 0, 0),
|
|
(80484, 15, -9813.02, 701.892, 33.1128, 100, 2000, 0, 0),
|
|
(80484, 16, -9818.41, 712.983, 33.0263, 100, 0, 0, 0),
|
|
(80484, 17, -9815.06, 725.226, 33.1132, 100, 0, 0, 0),
|
|
(80484, 18, -9806.01, 733.877, 33.1115, 100, 0, 0, 0);
|
|
|
|
-- add missing guard
|
|
INSERT INTO `creature` (`guid`, `id`, `id2`, `id3`, `id4`, `map`, `display_id`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `health_percent`, `mana_percent`, `movement_type`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
|
|
(99141, 1423, 0, 0, 0, 0, 0, 0, -9611.2, 637.101, 51.6805, 0.887339, 285, 285, 1, 100, 0, 1, 0, 0, 0, 10);
|
|
|
|
-- npc's should roam
|
|
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 1 WHERE `guid` IN (80464, 80465, 80443, 80447, 80460, 80461, 80456, 80458, 80446, 80457, 80486);
|
|
|
|
-- goldshire
|
|
-- update waypoints for bo
|
|
DELETE FROM `creature_movement` WHERE `id` = 80320;
|
|
DELETE FROM `creature_movement_template` WHERE `entry` = 797;
|
|
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
|
|
(797, 1, -9425.55, 129.192, 59.5418, 100, 38000, 7, 8032001),
|
|
(797, 2, -9442.73, 135.681, 58.3425, 100, 0, 0, 0),
|
|
(797, 3, -9446.76, 132.807, 58.745, 100, 0, 0, 0),
|
|
(797, 4, -9452.98, 129.175, 58.9913, 100, 0, 0, 0),
|
|
(797, 5, -9457.24, 125.796, 59.014, 100, 0, 0, 0),
|
|
(797, 6, -9463.49, 121.757, 58.6251, 100, 0, 0, 0),
|
|
(797, 7, -9464.32, 118.82, 58.0714, 100, 0, 0, 0),
|
|
(797, 8, -9464.71, 116.082, 57.9214, 100, 0, 0, 0),
|
|
(797, 9, -9464.12, 107.346, 57.5387, 100, 0, 0, 0),
|
|
(797, 10, -9461.14, 95.8617, 58.3268, 100, 44000, 3, 0),
|
|
(797, 11, -9464.12, 107.346, 57.5387, 100, 0, 0, 0),
|
|
(797, 12, -9464.71, 116.082, 57.9214, 100, 0, 0, 0),
|
|
(797, 13, -9464.32, 118.82, 58.0714, 100, 0, 0, 0),
|
|
(797, 14, -9463.49, 121.757, 58.6251, 100, 0, 0, 0),
|
|
(797, 15, -9457.24, 125.796, 59.014, 100, 0, 0, 0),
|
|
(797, 16, -9452.98, 129.175, 58.9913, 100, 0, 0, 0),
|
|
(797, 17, -9446.76, 132.807, 58.745, 100, 0, 0, 0),
|
|
(797, 18, -9442.73, 135.681, 58.3425, 100, 0, 0, 0);
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8032001, 0, 25, 1, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bo - Run');
|
|
|
|
-- npc's should roam
|
|
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 7 WHERE `guid` IN (80317, 80321);
|
|
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 0.5 WHERE `guid` IN (79905, 79909, 79908, 79910);
|
|
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 1 WHERE `guid` = 80292;
|
|
|
|
-- add missing text to innkeeper farley
|
|
DELETE FROM `creature_ai_scripts` WHERE `id`=29501;
|
|
INSERT INTO `creature_ai_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (29501, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 84, 85, 86, 0, 0, 0, 0, 0, 0, 'Innkeeper Farley - Say Text');
|
|
|
|
-- add waypoints and scripts to matt
|
|
UPDATE `creature` SET `movement_type` = 2 WHERE `id` = 794;
|
|
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
|
|
(794, 1, -9387.13, -117.859, 58.862, 2.818, 3597000, 0, 0),
|
|
(794, 2, -9387.13, -117.859, 58.862, 2.818, 0, 0, 79401),
|
|
(794, 3, -9383.68, -114.327, 58.8469, 100, 0, 0, 0),
|
|
(794, 4, -9380.77, -110.285, 58.8178, 100, 0, 0, 0),
|
|
(794, 5, -9378.45, -104.929, 60.5617, 100, 0, 0, 0),
|
|
(794, 6, -9388.37, -91.1196, 63.2423, 100, 0, 0, 0),
|
|
(794, 7, -9418.03, -87.5691, 60.0556, 100, 0, 0, 0),
|
|
(794, 8, -9421.72, -81.2192, 60.4194, 100, 0, 0, 0),
|
|
(794, 9, -9423.2, -53.2072, 63.5551, 100, 0, 0, 0),
|
|
(794, 10, -9420.56, -37.2724, 62.9432, 100, 0, 0, 0),
|
|
(794, 11, -9422.44, -21.2467, 62.0099, 100, 0, 0, 0),
|
|
(794, 12, -9432.84, 15.3516, 59.0447, 100, 0, 0, 0),
|
|
(794, 13, -9433.96, 52.9096, 56.3998, 100, 0, 0, 0),
|
|
(794, 14, -9437.53, 63.9734, 56.3863, 100, 0, 0, 0),
|
|
(794, 15, -9433.31, 76.173, 56.1534, 100, 0, 0, 0),
|
|
(794, 16, -9421.61, 95.8219, 57.8012, 100, 0, 0, 0),
|
|
(794, 17, -9410.34, 117.386, 60.4114, 100, 0, 0, 0),
|
|
(794, 18, -9410.93, 130.485, 59.4201, 100, 0, 0, 0),
|
|
(794, 19, -9420.29, 146.493, 57.5605, 100, 0, 0, 0),
|
|
(794, 20, -9430.31, 151.226, 55.5763, 100, 900000, 0, 0),
|
|
(794, 21, -9430.31, 151.226, 55.5763, 100, 0, 0, 79402),
|
|
(794, 22, -9426.91, 144.703, 57.4634, 100, 0, 0, 0),
|
|
(794, 23, -9413.45, 125.26, 59.7663, 100, 0, 0, 0),
|
|
(794, 24, -9404.68, 114.129, 60.4918, 100, 0, 0, 0),
|
|
(794, 25, -9402.83, 103.103, 59.0547, 100, 0, 0, 0),
|
|
(794, 26, -9418.24, 85.2314, 56.7479, 100, 0, 0, 0),
|
|
(794, 27, -9434.07, 71.3512, 56.1786, 100, 0, 0, 0),
|
|
(794, 28, -9439.36, 64.1234, 56.2029, 100, 0, 0, 0),
|
|
(794, 29, -9437.39, 53.4107, 56.0962, 100, 0, 0, 0),
|
|
(794, 30, -9427.39, 38.3134, 57.1306, 100, 0, 0, 0),
|
|
(794, 31, -9418.42, 26.2133, 58.0576, 100, 0, 0, 0),
|
|
(794, 32, -9401.25, 4.77202, 60.2208, 100, 0, 0, 0),
|
|
(794, 33, -9392.87, -4.30769, 60.91, 100, 0, 0, 0),
|
|
(794, 34, -9380.95, -17.9289, 62.2038, 100, 0, 0, 0),
|
|
(794, 35, -9360.5, -37.7572, 64.222, 100, 0, 0, 0),
|
|
(794, 36, -9356, -50.1369, 65.8597, 100, 0, 0, 0),
|
|
(794, 37, -9356.07, -60.5225, 66.4481, 100, 0, 0, 0),
|
|
(794, 38, -9358.77, -73.3921, 64.9128, 100, 0, 0, 0),
|
|
(794, 39, -9371.97, -90.3814, 64.1589, 100, 0, 0, 0),
|
|
(794, 40, -9377.91, -101.176, 61.7324, 100, 0, 0, 0),
|
|
(794, 41, -9379.77, -110.074, 58.8343, 100, 0, 0, 0),
|
|
(794, 42, -9383.17, -114.531, 58.8394, 100, 0, 0, 0);
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (79401, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 894, 0, 0, 0, 0, 0, 0, 0, 0, 'Matt - Say Text');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (79402, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 893, 0, 0, 0, 0, 0, 0, 0, 0, 'Matt - Say Text');
|
|
|
|
-- add clara charles ambush event
|
|
UPDATE creature_movement SET `position_x` = -9215.99, `position_y` = 364.038, `position_z` = 72.1662, `script_id` = 591701, `waittime` = 11000 WHERE `id` = 79881 AND `point` = 6;
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (591701, 0, 39, 591701, 591702, 0, 0, 0, 0, 0, 0, 35, 35, 0, 0, 0, 0, 0, 0, 0, 'Clara Charles - Summon Defias Ambusher');
|
|
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (591701, 0, 10, 583, 0, 0, 0, 0, 0, 0, 0, 1, 58301, 6, 7, -9228.46, 340.316, 73.8243, 0, 0, 'Clara Charles - Summon Defias Ambusher');
|
|
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (58301, 0, 60, 3, 0, 0, 0, 0, 0, 0, 0, 0, 58301, 0, 0, 0, 0, 0, 0, 0, 'Defias Ambusher - Start Waypoints');
|
|
INSERT INTO `creature_movement_special` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
|
|
(58301, 1, -9228.46, 340.316, 73.8243, 100, 2000, 0, 0),
|
|
(58301, 2, -9219.99, 347.96, 73.9481, 100, 0, 0, 0),
|
|
(58301, 3, -9217.71, 362.5, 72.1445, 100, 3000, 0, 0),
|
|
(58301, 4, -9219.24, 368.871, 72.4996, 100, 5000, 0, 0),
|
|
(58301, 5, -9218.29, 356.559, 72.7523, 100, 0, 0, 0),
|
|
(58301, 6, -9220.93, 337.276, 73.3947, 100, 0, 0, 0),
|
|
(58301, 7, -9228.5, 309.567, 74.4148, 100, 0, 0, 0),
|
|
(58301, 8, -9229.13, 304.239, 74.4127, 100, 0, 0, 0),
|
|
(58301, 9, -9238.92, 305.596, 74.2677, 100, 2000, 0, 58301);
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (58301, 0, 18, 2, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Defias Ambusher - Despawn');
|
|
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (591702, 0, 10, 583, 0, 0, 0, 0, 0, 0, 0, 1, 58302, 6, 7, -9231.07, 358.854, 73.7231, 0, 0, 'Clara Charles - Summon Defias Ambusher');
|
|
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (58302, 0, 60, 3, 0, 0, 0, 0, 0, 0, 0, 0, 58302, 0, 0, 0, 0, 0, 0, 0, 'Defias Ambusher - Start Waypoints');
|
|
INSERT INTO `creature_movement_special` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
|
|
(58302, 1, -9231.07, 358.854, 73.7231, 100, 2000, 0, 0),
|
|
(58302, 2, -9218.56, 364.569, 72.1008, 100, 3000, 0, 0),
|
|
(58302, 3, -9220.06, 367.568, 72.3202, 100, 5000, 0, 0),
|
|
(58302, 4, -9225.81, 367.491, 72.543, 100, 0, 0, 0),
|
|
(58302, 5, -9244.6, 368.092, 75.1086, 100, 0, 0, 0),
|
|
(58302, 6, -9268.99, 377.365, 78.1787, 100, 0, 0, 0),
|
|
(58302, 7, -9288.57, 386.671, 76.7691, 100, 0, 0, 0),
|
|
(58302, 8, -9295.63, 392.504, 76.2484, 100, 0, 0, 0),
|
|
(58302, 9, -9300.58, 404.784, 74.2369, 100, 2000, 0, 58302);
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (58302, 0, 18, 2, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Defias Ambusher - Despawn');
|
|
|
|
-- add missing guard
|
|
INSERT INTO `creature` (`guid`, `id`, `id2`, `id3`, `id4`, `map`, `display_id`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `health_percent`, `mana_percent`, `movement_type`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
|
|
(99140, 1423, 0, 0, 0, 0, 0, 0, -9073.3, 427.18, 93.0558, 0.887339, 285, 285, 0, 100, 0, 2, 0, 0, 0, 10);
|
|
|
|
-- add stormwind guard 99140 waypoints
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
|
|
(99140, 1, -9073.3, 427.18, 93.0558, 100, 0, 0, 0),
|
|
(99140, 2, -9086.64, 417.472, 92.2924, 100, 0, 0, 0),
|
|
(99140, 3, -9120.96, 394.504, 92.0548, 100, 0, 0, 0),
|
|
(99140, 4, -9142.03, 376.161, 90.6847, 100, 0, 0, 0),
|
|
(99140, 5, -9165.44, 351.636, 87.3068, 100, 2000, 0, 0),
|
|
(99140, 6, -9142.03, 376.161, 90.6847, 100, 0, 0, 0),
|
|
(99140, 7, -9120.96, 394.504, 92.0548, 100, 0, 0, 0),
|
|
(99140, 8, -9086.64, 417.472, 92.2924, 100, 0, 0, 0),
|
|
(99140, 9, -9079.49, 425.134, 92.5005, 100, 0, 0, 0);
|
|
|
|
-- update kira songshine waypoints
|
|
DELETE FROM `creature_movement` WHERE `id` = 80283;
|
|
UPDATE `creature` SET `position_x` = -9537.01, `position_y` = -30.562, `position_z` = 55.8583 WHERE `guid` = 80283;
|
|
DELETE FROM `creature_movement_template` WHERE `entry` = 3937;
|
|
INSERT INTO `creature_movement_template` (`entry`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
|
|
(3937, 1, -9537.01, -30.562, 55.8583, 100, 0, 0, 0),
|
|
(3937, 2, -9531.63, -19.6561, 55.8516, 100, 0, 0, 0),
|
|
(3937, 3, -9525.49, -9.22328, 55.7858, 100, 0, 0, 0),
|
|
(3937, 4, -9518.46, 6.28009, 56.0239, 100, 0, 0, 0),
|
|
(3937, 5, -9509.91, 24.6347, 56.4859, 100, 0, 0, 0),
|
|
(3937, 6, -9498.52, 46.063, 55.8474, 100, 0, 0, 0),
|
|
(3937, 7, -9494.38, 62.3094, 56.0238, 100, 0, 0, 0),
|
|
(3937, 8, -9488.1, 85.4097, 56.0715, 100, 0, 0, 0),
|
|
(3937, 9, -9485.11, 97.1514, 56.3964, 100, 0, 0, 0),
|
|
(3937, 10, -9481.04, 121.147, 56.6061, 100, 0, 0, 0),
|
|
(3937, 11, -9482.35, 141.257, 56.4753, 100, 0, 0, 0),
|
|
(3937, 12, -9485.17, 165.088, 56.0302, 100, 0, 0, 0),
|
|
(3937, 13, -9484.95, 177.247, 55.5409, 100, 0, 0, 0),
|
|
(3937, 14, -9490.67, 192.082, 54.7156, 100, 0, 0, 0),
|
|
(3937, 15, -9506.59, 215.494, 53.1006, 100, 0, 0, 0),
|
|
(3937, 16, -9529.36, 238.496, 51.1366, 100, 0, 0, 0),
|
|
(3937, 17, -9520.83, 233.5, 51.5522, 100, 0, 0, 0),
|
|
(3937, 18, -9517.99, 230.713, 51.8943, 100, 0, 0, 0),
|
|
(3937, 19, -9506.57, 219.274, 52.945, 100, 0, 0, 0),
|
|
(3937, 20, -9499.31, 205.653, 53.862, 100, 0, 0, 0),
|
|
(3937, 21, -9489.13, 188.276, 54.8621, 100, 0, 0, 0),
|
|
(3937, 22, -9484.03, 169.079, 55.8947, 100, 0, 0, 0),
|
|
(3937, 23, -9481.98, 152.933, 56.2342, 100, 0, 0, 0),
|
|
(3937, 24, -9481.83, 140.821, 56.6108, 100, 0, 0, 0),
|
|
(3937, 25, -9483.11, 124.717, 56.6051, 100, 0, 0, 0),
|
|
(3937, 26, -9485.7, 104.679, 56.4852, 100, 0, 0, 0),
|
|
(3937, 27, -9487.2, 87.6606, 56.1202, 100, 0, 0, 0),
|
|
(3937, 28, -9486.24, 75.8076, 56.2578, 100, 0, 0, 0),
|
|
(3937, 29, -9482.39, 69.3032, 56.3605, 100, 0, 0, 0),
|
|
(3937, 30, -9471.87, 63.3003, 56.0149, 100, 0, 0, 0),
|
|
(3937, 31, -9456.96, 65.6871, 56.0383, 100, 0, 0, 0),
|
|
(3937, 32, -9420.6, 83.9996, 56.6717, 100, 0, 0, 0),
|
|
(3937, 33, -9406.71, 91.6255, 57.8558, 100, 0, 0, 0),
|
|
(3937, 34, -9385.48, 104.003, 59.6502, 100, 0, 0, 0),
|
|
(3937, 35, -9366.48, 110.453, 61.1282, 100, 0, 0, 0),
|
|
(3937, 36, -9341.06, 122.631, 63.3622, 100, 0, 0, 0),
|
|
(3937, 37, -9319.76, 134.248, 64.4297, 100, 0, 0, 0),
|
|
(3937, 38, -9301.26, 142.166, 65.7357, 100, 0, 0, 0),
|
|
(3937, 39, -9278.15, 149.637, 66.7753, 100, 0, 0, 0),
|
|
(3937, 40, -9259.72, 157.862, 67.5181, 100, 0, 0, 0),
|
|
(3937, 41, -9245.17, 171.719, 67.9062, 100, 0, 0, 0),
|
|
(3937, 42, -9234.34, 183.789, 67.6498, 100, 0, 0, 0),
|
|
(3937, 43, -9221.37, 199.328, 68.6304, 100, 0, 0, 0),
|
|
(3937, 44, -9204.7, 216.766, 70.8805, 100, 0, 0, 0),
|
|
(3937, 45, -9191.8, 232.327, 71.8285, 100, 0, 0, 0),
|
|
(3937, 46, -9184.4, 250.696, 73.4315, 100, 0, 0, 0),
|
|
(3937, 47, -9182.43, 270.717, 74.9709, 100, 0, 0, 0),
|
|
(3937, 48, -9181.05, 298.795, 78.0074, 100, 0, 0, 0),
|
|
(3937, 49, -9178.72, 318.851, 80.0275, 100, 0, 0, 0),
|
|
(3937, 50, -9175.71, 330.347, 82.2052, 100, 0, 0, 0),
|
|
(3937, 51, -9169.73, 344.79, 85.7392, 100, 0, 0, 0),
|
|
(3937, 52, -9158.13, 360.966, 89.4625, 100, 0, 0, 0),
|
|
(3937, 53, -9146.6, 372.209, 90.5716, 100, 0, 0, 0),
|
|
(3937, 54, -9127.98, 387.88, 91.1215, 100, 0, 0, 0),
|
|
(3937, 55, -9142.45, 377.77, 90.7101, 100, 0, 0, 0),
|
|
(3937, 56, -9148.49, 372.415, 90.618, 100, 0, 0, 0),
|
|
(3937, 57, -9156.33, 363.221, 89.8709, 100, 0, 0, 0),
|
|
(3937, 58, -9166.58, 350.972, 87.0228, 100, 0, 0, 0),
|
|
(3937, 59, -9175.35, 337.859, 83.6657, 100, 0, 0, 0),
|
|
(3937, 60, -9178.5, 326.473, 81.3119, 100, 0, 0, 0),
|
|
(3937, 61, -9180.81, 314.752, 79.3805, 100, 0, 0, 0),
|
|
(3937, 62, -9182.13, 302.736, 78.3334, 100, 0, 0, 0),
|
|
(3937, 63, -9183.2, 290.608, 76.8484, 100, 0, 0, 0),
|
|
(3937, 64, -9184.12, 262.436, 74.1921, 100, 0, 0, 0),
|
|
(3937, 65, -9187.03, 242.503, 72.6539, 100, 0, 0, 0),
|
|
(3937, 66, -9192.09, 231.631, 71.8149, 100, 0, 0, 0),
|
|
(3937, 67, -9213.72, 207.69, 69.7202, 100, 0, 0, 0),
|
|
(3937, 68, -9228.08, 193.469, 68.0946, 100, 0, 0, 0),
|
|
(3937, 69, -9236.33, 184.551, 67.6546, 100, 0, 0, 0),
|
|
(3937, 70, -9250.2, 164.564, 67.8689, 100, 0, 0, 0),
|
|
(3937, 71, -9266.91, 154.116, 67.1636, 100, 0, 0, 0),
|
|
(3937, 72, -9278.62, 151.2, 66.8232, 100, 0, 0, 0),
|
|
(3937, 73, -9297.88, 144.958, 65.96, 100, 0, 0, 0),
|
|
(3937, 74, -9324.3, 134.552, 64.3442, 100, 0, 0, 0),
|
|
(3937, 75, -9334.7, 128.369, 63.9347, 100, 0, 0, 0),
|
|
(3937, 76, -9351.97, 117.915, 62.495, 100, 0, 0, 0),
|
|
(3937, 77, -9373.61, 106.951, 60.6195, 100, 0, 0, 0),
|
|
(3937, 78, -9392.87, 101.027, 58.9956, 100, 0, 0, 0),
|
|
(3937, 79, -9411.12, 92.4998, 57.6524, 100, 0, 0, 0),
|
|
(3937, 80, -9427.81, 81.1753, 56.6052, 100, 0, 0, 0),
|
|
(3937, 81, -9440.09, 70.6694, 56.0638, 100, 0, 0, 0),
|
|
(3937, 82, -9454.65, 63.7952, 55.9132, 100, 0, 0, 0),
|
|
(3937, 83, -9466.33, 62.9064, 55.8631, 100, 0, 0, 0),
|
|
(3937, 84, -9487.97, 60.003, 55.9554, 100, 0, 0, 0),
|
|
(3937, 85, -9499.65, 45.6409, 55.822, 100, 0, 0, 0),
|
|
(3937, 86, -9511.78, 19.9769, 56.445, 100, 0, 0, 0),
|
|
(3937, 87, -9519.03, 5.5374, 56.0064, 100, 0, 0, 0),
|
|
(3937, 88, -9524.81, -5.16347, 55.8383, 100, 0, 0, 0),
|
|
(3937, 89, -9533.5, -23.5105, 55.8444, 100, 0, 0, 0),
|
|
(3937, 90, -9543.58, -49.9466, 56.702, 100, 0, 0, 0),
|
|
(3937, 91, -9550.06, -81.6245, 57.4979, 100, 0, 0, 0),
|
|
(3937, 92, -9550.68, -110.273, 57.4996, 100, 0, 0, 0),
|
|
(3937, 93, -9549.27, -84.9852, 57.5477, 100, 0, 0, 0),
|
|
(3937, 94, -9544.73, -57.0475, 56.8001, 100, 0, 0, 0),
|
|
(3937, 95, -9537.97, -33.6973, 56.2375, 100, 0, 0, 0);
|
|
|
|
-- tower of azora
|
|
-- npc's should roam
|
|
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 1 WHERE `guid` IN (80928, 80936, 80929, 80924, 80926, 80925, 80931);
|
|
|
|
-- add servant of azora 80927 waypoints
|
|
UPDATE `creature` SET `movement_type` = 2 WHERE `guid` = 80927;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
|
|
(80927, 1, -9554.81, -706.766, 90.4123, 100, 0, 0, 0),
|
|
(80927, 2, -9559.78, -705.204, 90.4257, 100, 0, 0, 0),
|
|
(80927, 3, -9567.61, -707.474, 90.422, 100, 0, 0, 0),
|
|
(80927, 4, -9573.15, -714.011, 90.4237, 100, 0, 0, 0),
|
|
(80927, 5, -9573.83, -722.376, 90.4257, 100, 0, 0, 0),
|
|
(80927, 6, -9569.41, -729.787, 90.4263, 100, 0, 0, 0),
|
|
(80927, 7, -9557.52, -734.085, 90.4258, 100, 0, 0, 0),
|
|
(80927, 8, -9549.81, -728.635, 90.4258, 100, 0, 0, 0),
|
|
(80927, 9, -9546.45, -720.288, 90.4259, 100, 0, 0, 0),
|
|
(80927, 10, -9548.53, -712.153, 90.4209, 100, 0, 0, 0);
|
|
|
|
-- add stormwind guard 81362 waypoints
|
|
UPDATE `creature` SET `movement_type` = 2 WHERE `guid` = 81362;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
|
|
(81362, 1, -9799.68, -1403.43, 62.7097, 100, 0, 0, 0),
|
|
(81362, 2, -9797.08, -1395.84, 62.7891, 100, 0, 0, 0),
|
|
(81362, 3, -9789.32, -1386.82, 62.7207, 100, 0, 0, 0),
|
|
(81362, 4, -9776.63, -1383.53, 62.7928, 100, 2000, 0, 0),
|
|
(81362, 5, -9784.66, -1384.44, 62.7101, 100, 0, 0, 0),
|
|
(81362, 6, -9793.97, -1391.36, 62.749, 100, 0, 0, 0),
|
|
(81362, 7, -9797.87, -1398.13, 62.7751, 100, 0, 0, 0),
|
|
(81362, 8, -9798.26, -1409.72, 62.735, 100, 0, 0, 0),
|
|
(81362, 9, -9794.25, -1416.94, 62.7356, 100, 0, 0, 0),
|
|
(81362, 10, -9784.03, -1422.15, 62.6837, 100, 0, 0, 0),
|
|
(81362, 11, -9771.84, -1421.92, 62.6979, 100, 0, 0, 0),
|
|
(81362, 12, -9761.87, -1408.17, 62.7735, 100, 0, 0, 0),
|
|
(81362, 13, -9763.66, -1392.01, 62.7932, 100, 2000, 0, 0),
|
|
(81362, 14, -9762.63, -1412.12, 62.793, 100, 0, 0, 0),
|
|
(81362, 15, -9775.93, -1422.36, 62.6859, 100, 0, 0, 0),
|
|
(81362, 16, -9787.56, -1421.32, 62.6966, 100, 0, 0, 0),
|
|
(81362, 17, -9794.25, -1416.94, 62.7356, 100, 0, 0, 0),
|
|
(81362, 18, -9798.88, -1406.96, 62.6995, 100, 0, 0, 0);
|
|
|
|
-- add stormwind guard 81365 waypoints
|
|
UPDATE `creature` SET `movement_type` = 2 WHERE `guid` = 81365;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
|
|
(81365, 1, -9776.59, -1394.81, 97.8873, 100, 60000, 0, 0),
|
|
(81365, 2, -9788.5, -1399.94, 97.8873, 4.34587, 60000, 0, 0),
|
|
(81365, 3, -9783.52, -1412.02, 97.8873, 100, 60000, 0, 0),
|
|
(81365, 4, -9771.3, -1406.96, 97.8868, 1.16937, 60000, 0, 0);
|
|
|
|
-- add missing guard
|
|
INSERT INTO `creature` (`guid`, `id`, `id2`, `id3`, `id4`, `map`, `display_id`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecsmin`, `spawntimesecsmax`, `wander_distance`, `health_percent`, `mana_percent`, `movement_type`, `spawn_flags`, `visibility_mod`, `patch_min`, `patch_max`) VALUES
|
|
(80491, 1423, 0, 0, 0, 0, 0, 0, -9610.83, -427.736, 57.5228, 0.887339, 285, 285, 1, 100, 0, 2, 0, 0, 0, 10);
|
|
|
|
-- add stormwind guard 80491 waypoints
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
|
|
(80491, 1, -9610.83, -427.736, 57.3851, 100, 0, 0, 0),
|
|
(80491, 2, -9597.86, -457.442, 57.6541, 100, 0, 0, 0),
|
|
(80491, 3, -9592.34, -472.696, 57.7307, 100, 0, 0, 0),
|
|
(80491, 4, -9591.36, -484.646, 57.6957, 100, 0, 0, 0),
|
|
(80491, 5, -9592.92, -496.615, 57.2575, 100, 0, 0, 0),
|
|
(80491, 6, -9596.63, -508.086, 57.4292, 100, 0, 0, 0),
|
|
(80491, 7, -9607.64, -529.579, 55.1624, 100, 0, 0, 0),
|
|
(80491, 8, -9615.09, -548.363, 54.4266, 100, 0, 0, 0),
|
|
(80491, 9, -9618.55, -568.24, 54.3775, 100, 0, 0, 0),
|
|
(80491, 10, -9620.36, -588.76, 53.8899, 100, 0, 0, 0),
|
|
(80491, 11, -9623.17, -616.901, 52.0324, 100, 0, 0, 0),
|
|
(80491, 12, -9628.43, -636.379, 51.0754, 100, 0, 0, 0),
|
|
(80491, 13, -9635.5, -650.824, 49.7613, 100, 0, 0, 0),
|
|
(80491, 14, -9640.43, -661.93, 49.3905, 100, 0, 0, 0),
|
|
(80491, 15, -9644.48, -677.592, 48.4178, 100, 0, 0, 0),
|
|
(80491, 16, -9649.44, -697.157, 46.444, 100, 0, 0, 0),
|
|
(80491, 17, -9652.92, -716.913, 44.7564, 100, 0, 0, 0),
|
|
(80491, 18, -9654.35, -737.086, 44.5833, 100, 0, 0, 0),
|
|
(80491, 19, -9653.01, -761.748, 44.3301, 100, 0, 0, 0),
|
|
(80491, 20, -9648.57, -789.684, 43.6278, 100, 0, 0, 0),
|
|
(80491, 21, -9641.42, -803.969, 43.6403, 100, 0, 0, 0),
|
|
(80491, 22, -9628.91, -819.817, 43.8473, 100, 0, 0, 0),
|
|
(80491, 23, -9615.3, -834.812, 43.6255, 100, 0, 0, 0),
|
|
(80491, 24, -9602, -850.135, 43.6753, 100, 0, 0, 0),
|
|
(80491, 25, -9592.03, -862.812, 43.6915, 100, 0, 0, 0),
|
|
(80491, 26, -9586.39, -873.497, 43.8156, 100, 0, 0, 0),
|
|
(80491, 27, -9584.93, -893.528, 43.7109, 100, 0, 0, 0),
|
|
(80491, 28, -9585.6, -909.496, 43.8113, 100, 0, 0, 0),
|
|
(80491, 29, -9591.05, -928.84, 43.7207, 100, 0, 0, 0),
|
|
(80491, 30, -9596.56, -939.682, 43.8228, 100, 0, 0, 0),
|
|
(80491, 31, -9606.8, -957.333, 43.6926, 100, 0, 0, 0),
|
|
(80491, 32, -9614.04, -971.387, 43.7864, 100, 0, 0, 0),
|
|
(80491, 33, -9620.09, -990.635, 42.9437, 100, 0, 0, 0),
|
|
(80491, 34, -9620.74, -998.555, 42.3257, 100, 0, 0, 0),
|
|
(80491, 35, -9620.42, -1010.65, 41.4511, 100, 0, 0, 0),
|
|
(80491, 36, -9620.17, -1018.72, 40.8098, 100, 0, 0, 0),
|
|
(80491, 37, -9619.24, -1036.47, 39.7794, 100, 0, 0, 0),
|
|
(80491, 38, -9621.25, -1012.6, 41.1192, 100, 0, 0, 0),
|
|
(80491, 39, -9622.77, -996.103, 42.5415, 100, 0, 0, 0),
|
|
(80491, 40, -9618.27, -976.682, 43.7581, 100, 0, 0, 0),
|
|
(80491, 41, -9607.07, -955.24, 43.7397, 100, 0, 0, 0),
|
|
(80491, 42, -9591.02, -937.07, 43.6543, 100, 0, 0, 0),
|
|
(80491, 43, -9584.1, -922.587, 43.6656, 100, 0, 0, 0),
|
|
(80491, 44, -9582.06, -898.73, 43.6345, 100, 0, 0, 0),
|
|
(80491, 45, -9586.04, -874.896, 43.7787, 100, 0, 0, 0),
|
|
(80491, 46, -9601.04, -851.231, 43.6787, 100, 0, 0, 0),
|
|
(80491, 47, -9633.93, -815.31, 43.8024, 100, 0, 0, 0),
|
|
(80491, 48, -9643.49, -802.215, 43.5667, 100, 0, 0, 0),
|
|
(80491, 49, -9649.96, -787.545, 43.7597, 100, 0, 0, 0),
|
|
(80491, 50, -9651.4, -767.318, 44.0816, 100, 0, 0, 0),
|
|
(80491, 51, -9655.7, -743.488, 44.5337, 100, 0, 0, 0),
|
|
(80491, 52, -9656.57, -727.014, 44.3327, 100, 0, 0, 0),
|
|
(80491, 53, -9649.79, -703.956, 45.6522, 100, 0, 0, 0),
|
|
(80491, 54, -9644.04, -668.115, 48.9443, 100, 0, 0, 0),
|
|
(80491, 55, -9630.29, -643.846, 50.5491, 100, 0, 0, 0),
|
|
(80491, 56, -9622.42, -603.777, 52.7227, 100, 5000, 0, 0),
|
|
(80491, 57, -9620.14, -579.619, 54.0855, 100, 0, 0, 0),
|
|
(80491, 58, -9617.71, -555.418, 54.4344, 100, 0, 0, 0),
|
|
(80491, 59, -9612.64, -535.758, 54.5456, 100, 0, 0, 0),
|
|
(80491, 60, -9604.84, -521.801, 56.0415, 100, 0, 0, 0),
|
|
(80491, 61, -9596, -508.276, 57.3978, 100, 0, 0, 0),
|
|
(80491, 62, -9590.8, -493.112, 57.3992, 100, 0, 0, 0),
|
|
(80491, 63, -9590.5, -473.174, 57.7398, 100, 0, 0, 0),
|
|
(80491, 64, -9599.2, -455.248, 57.6494, 100, 0, 0, 0),
|
|
(80491, 65, -9606.34, -440.673, 57.4867, 100, 0, 0, 0),
|
|
(80491, 66, -9613.4, -419.977, 57.497, 100, 0, 0, 0),
|
|
(80491, 67, -9617.16, -400.143, 57.8496, 100, 0, 0, 0),
|
|
(80491, 68, -9619.51, -375.932, 57.629, 100, 0, 0, 0),
|
|
(80491, 69, -9620.31, -359.728, 57.2669, 100, 0, 0, 0),
|
|
(80491, 70, -9620.89, -323.211, 57.5583, 100, 0, 0, 0),
|
|
(80491, 71, -9619.11, -302.474, 57.2485, 100, 0, 0, 0),
|
|
(80491, 72, -9613.36, -278.916, 57.8253, 100, 0, 0, 0),
|
|
(80491, 73, -9612.38, -274.971, 57.562, 100, 0, 0, 0),
|
|
(80491, 74, -9609.39, -259.07, 57.1138, 100, 0, 0, 0),
|
|
(80491, 75, -9600.07, -232.281, 57.4324, 100, 0, 0, 0),
|
|
(80491, 76, -9595.62, -220.931, 57.237, 100, 0, 0, 0),
|
|
(80491, 77, -9589.61, -205.855, 57.807, 100, 0, 0, 0),
|
|
(80491, 78, -9578.54, -171.495, 57.3288, 100, 5000, 0, 0),
|
|
(80491, 79, -9569.3, -153.57, 57.2731, 100, 0, 0, 0),
|
|
(80491, 80, -9555.75, -138.594, 57.3337, 100, 0, 0, 0),
|
|
(80491, 81, -9550.5, -119.509, 57.5132, 100, 0, 0, 0),
|
|
(80491, 82, -9549.79, -115.51, 57.5772, 100, 0, 0, 0),
|
|
(80491, 83, -9548.54, -87.1807, 57.5831, 100, 0, 0, 0),
|
|
(80491, 84, -9546.83, -66.9852, 57.1997, 100, 0, 0, 0),
|
|
(80491, 85, -9542.77, -47.1666, 56.6504, 100, 0, 0, 0),
|
|
(80491, 86, -9532.81, -20.6156, 55.906, 100, 0, 0, 0),
|
|
(80491, 87, -9520.91, 0.506857, 55.8761, 100, 0, 0, 0),
|
|
(80491, 88, -9506.67, 29.607, 56.4039, 100, 0, 0, 0),
|
|
(80491, 89, -9496.42, 51.6881, 55.8752, 100, 0, 0, 0),
|
|
(80491, 90, -9492.8, 64.3598, 55.9687, 100, 10000, 0, 0),
|
|
(80491, 91, -9495.58, 53.4582, 55.8877, 100, 0, 0, 0),
|
|
(80491, 92, -9502.15, 38.6496, 56.37, 100, 0, 0, 0),
|
|
(80491, 93, -9507.69, 27.8344, 56.4295, 100, 0, 0, 0),
|
|
(80491, 94, -9516.49, 9.58141, 56.1726, 100, 0, 0, 0),
|
|
(80491, 95, -9527.75, -11.9696, 55.8002, 100, 0, 0, 0),
|
|
(80491, 96, -9540.48, -42.7742, 56.5457, 100, 0, 0, 0),
|
|
(80491, 97, -9546.08, -66.1659, 57.1358, 100, 0, 0, 0),
|
|
(80491, 98, -9549.34, -106.516, 57.3789, 100, 0, 0, 0),
|
|
(80491, 99, -9556.03, -134.083, 57.5253, 100, 0, 0, 0),
|
|
(80491, 100, -9565.01, -147.377, 57.1688, 100, 0, 0, 0),
|
|
(80491, 101, -9577.62, -168.094, 57.3046, 100, 0, 0, 0),
|
|
(80491, 102, -9585.47, -191.021, 57.6163, 100, 0, 0, 0),
|
|
(80491, 103, -9596.95, -221.38, 57.2558, 100, 0, 0, 0),
|
|
(80491, 104, -9607.99, -256.08, 57.1767, 100, 0, 0, 0),
|
|
(80491, 105, -9613.91, -284.431, 57.7817, 100, 0, 0, 0),
|
|
(80491, 106, -9617.48, -308.396, 57.5369, 100, 0, 0, 0),
|
|
(80491, 107, -9619.96, -336.702, 57.4981, 100, 0, 0, 0),
|
|
(80491, 108, -9619.94, -361.1, 57.2982, 100, 0, 0, 0),
|
|
(80491, 109, -9618.42, -389.484, 57.8103, 100, 0, 0, 0),
|
|
(80491, 110, -9612.96, -417.835, 57.539, 100, 0, 0, 0);
|
|
|
|
-- eastvale logging camp
|
|
-- remove old scripts and waypoints
|
|
DELETE FROM `creature_template_addon` WHERE `entry` = 11328;
|
|
DELETE FROM `creature_addon` WHERE `guid` IN (81252, 81249, 81348, 81349, 81250);
|
|
DELETE FROM `creature_movement` WHERE `id` IN (81252, 81249, 81348, 81349, 81250);
|
|
DELETE FROM `creature_movement_scripts` WHERE `id` IN (8125001, 8125002, 8125003, 8125204, 8125208, 8125209, 8124901, 8124904, 8124905, 8134805, 8134810, 8134811, 8134902, 8134906, 8134907);
|
|
UPDATE `creature` SET `movement_type` = 0, `wander_distance` = 0 WHERE `guid` IN (81252, 81249, 81348, 81349, 81250);
|
|
|
|
-- add corect positions
|
|
UPDATE `creature` SET `position_x` = -9535.65, `position_y` = -1329.81, `position_z` = 47.3419, `orientation` = 1.939 WHERE `guid` = 81252;
|
|
UPDATE `creature` SET `position_x` = -9529.32, `position_y` = -1323.67, `position_z` = 45.9509, `orientation` = 2.70945 WHERE `guid` = 81249;
|
|
UPDATE `creature` SET `position_x` = -9535.3, `position_y` = -1304.7, `position_z` = 44.702, `orientation` = 5.28088 WHERE `guid` = 81348;
|
|
UPDATE `creature` SET `position_x` = -9536.21, `position_y` = -1273.05, `position_z` = 43.4187, `orientation` = 2.93691 WHERE `guid` = 81349;
|
|
UPDATE `creature` SET `position_x` = -9523.21, `position_y` = -1290.25, `position_z` = 44.1174, `orientation` = 5.23877 WHERE `guid` = 81250;
|
|
|
|
-- eastvale peasant 81252
|
|
UPDATE `creature` SET `movement_type`=2 WHERE `guid`=81252;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
|
|
(81252, 1, -9535.65, -1329.81, 47.272, 100, 6000, 0, 8125201),
|
|
(81252, 2, -9508.88, -1333.61, 44.3237, 100, 0, 0, 0),
|
|
(81252, 3, -9498.48, -1327.6, 42.0789, 100, 0, 0, 0),
|
|
(81252, 4, -9478.76, -1307.33, 42.1843, 100, 0, 0, 0),
|
|
(81252, 5, -9466.71, -1296.88, 41.4483, 100, 2000, 0, 8125202),
|
|
(81252, 6, -9470.67, -1295.27, 41.0593, 100, 0, 0, 0),
|
|
(81252, 7, -9471.37, -1289.82, 41.1039, 100, 10000, 0, 8125203),
|
|
(81252, 8, -9497.14, -1325.79, 41.7219, 100, 0, 0, 0),
|
|
(81252, 9, -9511.88, -1333.19, 44.8482, 100, 0, 0, 0),
|
|
(81252, 10, -9523.05, -1335.57, 46.8005, 100, 0, 0, 0),
|
|
(81252, 11, -9532.64, -1333.36, 47.621, 100, 0, 0, 0),
|
|
(81252, 12, -9535.65, -1329.81, 47.272, 100, 360000, 0, 8125204);
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125201, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81252 - Emote None');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125201, 4, 23, 89, 1, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81252 - Morph');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125202, 2, 23, 308, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81252 - Morph');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125203, 1, 16, 6289, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81252 - Play Sound - What');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125203, 1, 35, 0, 0, 0, 0, 81251, 0, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81252 - Face Target');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125203, 2, 16, 6288, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81252 - Play Sound - More Work');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125203, 4, 39, 1061601, 0, 0, 0, 81251, 0, 9, 2, 100, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81252 - Start Script Supervisor Raelene');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125203, 8, 16, 6242, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81252 - Play Sound - No One Else Available');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125203, 10, 39, 8125001, 0, 0, 0, 81348, 0, 9, 2, 100, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81252 - Start Script Eastvale Peasant 81250');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125204, 1, 35, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1.939, 0, 'Eastvale Peasant 81252 - Orientation');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125204, 2, 1, 234, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81252 - Emote ChopWood');
|
|
|
|
-- eastvale peasant 81348
|
|
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125001, 0, 60, 1, 0, 0, 0, 0, 0, 0, 0, 81348, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81348 - Start Waypoints - Started by Eastvale Peasant 81252');
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
|
|
(81348, 1, -9535.3, -1304.7, 44.6066, 100, 6000, 0, 8134801),
|
|
(81348, 2, -9525.24, -1286.03, 43.7736, 100, 0, 0, 0),
|
|
(81348, 3, -9502.34, -1283.87, 43.5437, 100, 0, 0, 0),
|
|
(81348, 4, -9472.02, -1296.85, 41.1791, 100, 0, 0, 0),
|
|
(81348, 5, -9466.69, -1296.88, 41.4499, 100, 2000, 0, 8134802),
|
|
(81348, 6, -9468.66, -1297.33, 41.4075, 100, 0, 0, 0),
|
|
(81348, 7, -9471.09, -1294.93, 41.0424, 100, 0, 0, 0),
|
|
(81348, 8, -9471.72, -1289.99, 41.0953, 100, 10000, 0, 8134803),
|
|
(81348, 9, -9497.3, -1284.53, 42.9337, 100, 0, 0, 0),
|
|
(81348, 10, -9523.47, -1284.09, 43.8342, 100, 0, 0, 0),
|
|
(81348, 11, -9535.18, -1301.59, 44.4283, 100, 0, 0, 0),
|
|
(81348, 12, -9535.3, -1304.7, 44.6075, 100, 6000, 0, 8134804);
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8134801, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81348 - Emote None');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8134801, 4, 23, 89, 1, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81348 - Morph');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8134802, 2, 23, 308, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81348 - Morph');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8134803, 1, 35, 0, 0, 0, 0, 81251, 0, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81348 - Face Target');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8134803, 1, 16, 6288, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81348 - Play Sound - More Work');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8134803, 4, 39, 1061601, 0, 0, 0, 81251, 0, 9, 2, 100, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81348 - Start Script Supervisor Raelene');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8134803, 8, 16, 6284, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81348 - Play Sound - Right O');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8134803, 10, 39, 8124901, 0, 0, 0, 81249, 0, 9, 2, 100, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81348 - Start Script Eastvale Peasant 81249');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8134804, 1, 35, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.28088, 0, 'Eastvale Peasant 81348 - Orientation');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8134804, 2, 1, 234, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81348 - Emote ChopWood');
|
|
|
|
-- eastvale peasant 81249
|
|
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8124901, 0, 60, 1, 0, 0, 0, 0, 0, 0, 0, 81249, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81249 - Start Waypoints - Started by Eastvale Peasant 81348');
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
|
|
(81249, 1, -9529.32, -1323.67, 45.7866, 100, 6000, 0, 8124901),
|
|
(81249, 2, -9520, -1331.45, 45.9187, 100, 0, 0, 0),
|
|
(81249, 3, -9514.88, -1332.6, 45.299, 100, 0, 0, 0),
|
|
(81249, 4, -9496.5, -1323.7, 41.4285, 100, 0, 0, 0),
|
|
(81249, 5, -9466.73, -1296.88, 41.4469, 100, 2000, 0, 8124902),
|
|
(81249, 6, -9468.69, -1297.31, 41.4041, 100, 0, 0, 0),
|
|
(81249, 7, -9470.94, -1295.14, 41.0533, 100, 0, 0, 0),
|
|
(81249, 8, -9471.44, -1289.93, 41.097, 100, 10000, 0, 8124903),
|
|
(81249, 9, -9494.73, -1320.24, 40.9404, 100, 0, 0, 0),
|
|
(81249, 10, -9514.85, -1332.59, 45.2935, 100, 0, 0, 0),
|
|
(81249, 11, -9525.68, -1325.85, 45.8462, 100, 0, 0, 0),
|
|
(81249, 12, -9529.32, -1323.67, 45.7879, 100, 6000, 0, 8124904);
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8124901, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81249 - Emote None');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8124901, 4, 23, 89, 1, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81249 - Morph');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8124902, 2, 23, 308, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81249 - Morph');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8124903, 1, 35, 0, 0, 0, 0, 81251, 0, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81249 - Face Target');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8124903, 1, 16, 6290, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81249 - Play Sound - Ready to Work');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8124903, 4, 39, 1061601, 0, 0, 0, 81251, 0, 9, 2, 100, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81249 - Start Script Supervisor Raelene');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8124903, 8, 16, 6285, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81249 - Play Sound - Alright');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8124903, 9, 16, 6286, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81249 - Play Sound - Off I go Then');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8124903, 10, 39, 8125001, 0, 0, 0, 81250, 0, 9, 2, 100, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81249 - Start Script Eastvale Peasant 81250');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8124904, 1, 35, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.70945, 0, 'Eastvale Peasant 81249 - Orientation');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8124904, 2, 1, 234, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81249 - Emote ChopWood');
|
|
|
|
-- eastvale peasant 81250
|
|
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125001, 0, 60, 1, 0, 0, 0, 0, 0, 0, 0, 81250, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81250 - Start Waypoints - Started by Eastvale Peasant 81249');
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
|
|
(81250, 1, -9523.21, -1290.25, 44.0269, 100, 6000, 0, 8125001),
|
|
(81250, 2, -9522.08, -1287.45, 44.0455, 100, 0, 0, 0),
|
|
(81250, 3, -9506.19, -1283.11, 43.9688, 100, 0, 0, 0),
|
|
(81250, 4, -9470.43, -1297.81, 41.421, 100, 0, 0, 0),
|
|
(81250, 5, -9466.68, -1296.88, 41.4504, 100, 2000, 0, 8125002),
|
|
(81250, 6, -9471.13, -1294.9, 41.0405, 100, 0, 0, 0),
|
|
(81250, 7, -9471.41, -1290.05, 41.0895, 100, 10000, 0, 8125003),
|
|
(81250, 8, -9515.19, -1283.77, 44.2669, 100, 0, 0, 0),
|
|
(81250, 9, -9522.13, -1286.84, 44.0258, 100, 0, 0, 0),
|
|
(81250, 10, -9523.21, -1290.25, 44.0269, 100, 6000, 0, 8125004);
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125001, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81250 - Emote None');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125001, 4, 23, 89, 1, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81250 - Morph');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125002, 2, 23, 308, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81250 - Morph');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125003, 1, 35, 0, 0, 0, 0, 81251, 0, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81250 - Face Target');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125003, 1, 16, 6288, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81250 - Play Sound - More Work');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125003, 4, 39, 1061601, 0, 0, 0, 81251, 0, 9, 2, 100, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81250 - Start Script Supervisor Raelene');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125003, 8, 16, 6285, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81250 - Play Sound - Alright');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125003, 9, 16, 6286, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81250 - Play Sound - Off I go Then');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125003, 13, 39, 8134901, 0, 0, 0, 81349, 0, 9, 2, 100, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81250 - Start Script Eastvale Peasant 81349');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125004, 1, 35, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.23877, 0, 'Eastvale Peasant 81250 - Orientation');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8125004, 2, 1, 234, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81250 - Emote ChopWood');
|
|
|
|
-- eastvale peasant 81349
|
|
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8134901, 0, 60, 1, 0, 0, 0, 0, 0, 0, 0, 81349, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81349 - Start Waypoints - Started by Eastvale Peasant 81250');
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
|
|
(81349, 1, -9536.21, -1273.05, 43.4187, 100, 6000, 0, 8134901),
|
|
(81349, 2, -9504.34, -1282.1, 43.9606, 100, 0, 0, 0),
|
|
(81349, 3, -9471.51, -1296.86, 41.2074, 100, 0, 0, 0),
|
|
(81349, 4, -9466.68, -1296.88, 41.4506, 100, 2000, 0, 8134902),
|
|
(81349, 5, -9470.82, -1294.56, 41.0447, 100, 0, 0, 0),
|
|
(81349, 6, -9471.36, -1289.8, 41.1054, 100, 10000, 0, 8134903),
|
|
(81349, 7, -9504.04, -1279.93, 44.2039, 100, 0, 0, 0),
|
|
(81349, 8, -9536.21, -1273.05, 43.4187, 100, 6000, 0, 8134904);
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8134901, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81349 - Emote None');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8134901, 4, 23, 89, 1, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81349 - Morph');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8134902, 2, 23, 308, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81349 - Morph');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8134903, 1, 35, 0, 0, 0, 0, 81251, 0, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81349 - Face Target');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8134903, 1, 16, 6288, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81349 - Play Sound - More Work');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8134903, 4, 39, 1061601, 0, 0, 0, 81251, 0, 9, 2, 100, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81349 - Start Script Supervisor Raelene');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8134903, 8, 16, 6282, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81349 - Play Sound - I Guess I Can');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8134904, 1, 35, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.93691, 0, 'Eastvale Peasant 81349 - Orientation');
|
|
INSERT INTO `creature_movement_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (8134904, 2, 1, 234, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Eastvale Peasant 81349 - Emote ChopWood');
|
|
|
|
-- supervisor raelen scripts
|
|
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (1061601, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6891, 6892, 6890, 0, 0, 0, 0, 0, 0, 'Supervisor Raelen - Speak');
|
|
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `target_param1`, `target_param2`, `target_type`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `condition_id`, `comments`) VALUES (1061601, 2, 1, 25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Supervisor Raelen - Emote Point');
|
|
|
|
-- add eastvale lumberjack waypoints
|
|
UPDATE `creature` SET `movement_type` = 2, `wander_distance` = 0 WHERE `guid` = 81257;
|
|
INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `waittime`, `wander_distance`, `script_id`) VALUES
|
|
(81257, 1, -9400.75, -1336.92, 50.0289, 100, 20000, 0, 0),
|
|
(81257, 2, -9401.56, -1338.09, 50.0274, 100, 0, 0, 0),
|
|
(81257, 3, -9405.42, -1339.04, 50.0274, 100, 0, 0, 0),
|
|
(81257, 4, -9409.35, -1338.22, 50.0274, 100, 0, 0, 0),
|
|
(81257, 5, -9414.88, -1332.98, 51.4641, 100, 0, 0, 0),
|
|
(81257, 6, -9417.64, -1330.03, 51.4427, 100, 0, 0, 0),
|
|
(81257, 7, -9426.08, -1323.97, 51.4639, 100, 20000, 0, 0),
|
|
(81257, 8, -9419.65, -1328.88, 51.4533, 100, 0, 0, 0),
|
|
(81257, 9, -9416.5, -1331.4, 51.4431, 100, 0, 0, 0),
|
|
(81257, 10, -9410.44, -1336.3, 50.4051, 100, 0, 0, 0);
|
|
|
|
-- npc's should roam
|
|
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 1 WHERE `guid` = 81259;
|
|
UPDATE `creature` SET `movement_type` = 1, `wander_distance` = 0.5 WHERE `guid` = 81247;
|
|
|
|
-- remove kids at night
|
|
INSERT INTO `game_event_creature` VALUES
|
|
(86156, -27),
|
|
(86157, -27),
|
|
(86158, -27),
|
|
(86159, -27),
|
|
(86354, -27);
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
delimiter ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|