Trinitycore: [NPC/Event Scripts] Children of Goldshire

Created on 9 Feb 2017  路  39Comments  路  Source: TrinityCore/TrinityCore

Description: The event "Children of Goldshire" is missing

Current behaviour: The event is missing or not working correctly on master / 3.3.5

Expected behaviour:
The children should spawn at 7:00 am and move to different locations. After they return home, a random sound file should play and then the children should despawn at 8:00 am.

Steps to reproduce the problem:

  1. Go to the house where the event starts/ends

Branch(es): 3.3.5 and master

TC rev. hash/commit: https://github.com/TrinityCore/TrinityCore/commit/8aacc07727835ad3f81bebde3308cfdc4de2f26e

TDB version:
3.3.5 TDB 335.62 - Oct 16, 2016 + updates
master TDB 703.00 - Oct 16, 2016 + updates

Operating system: Windows 10 64-bit

Branch-3.3.5a Comp-Database
Source
picture ArcaneFox

Most helpful comment

I'll look into it again in a few days and complete it

picture Kittnz on 27 Sep 2017
❤1 👍1

All 39 comments

More info.

offl picture offl on 9 Feb 2017

alphas version of this:

/* Other children around npc Cameron(805) will follow him */
DELETE FROM `creature_formations` WHERE `leaderGUID`=79638;
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES
(79638, 79638, 0, 10, 2),
(79638, 79641, 3, 110, 2),
(79638, 79640, 3, 180, 2),
(79638, 79639, 3, 250, 2),
(79638, 79643, 3, 50, 2),
(79638, 79642, 3, 310, 2);

/* waypoints for leadernpc Cameron (805) */
SET @NPC := 79638;
SET @PATH := @NPC * 10;
UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES 
(@PATH, 1, -9375.14, -70.5235, 69.2021, 0, 0, 0, 0, 100, 0),
(@PATH, 2, -9377.67, -72.9422, 69.1951, 0, 0, 0, 0, 100, 0),
(@PATH, 3, -9384.01, -76.1072, 69.1587, 0, 0, 0, 0, 100, 0),
(@PATH, 4, -9389.03, -73.8447, 66.5582, 0, 0, 0, 0, 100, 0),
(@PATH, 5, -9392.28, -70.9913, 64.4379, 0, 0, 0, 0, 100, 0),
(@PATH, 6, -9392.28, -70.9913, 64.4379, 0, 0, 0, 0, 100, 0),
(@PATH, 7, -9390.7, -68.5401, 64.4379, 0, 0, 0, 0, 100, 0),
(@PATH, 8, -9386.24, -72.644, 64.4379, 0, 0, 0, 0, 100, 0),
(@PATH, 9, -9383.9, -75.2439, 64.4379, 0, 0, 0, 0, 100, 0),
(@PATH, 10, -9381.51, -78.4171, 64.4379, 0, 0, 0, 0, 100, 0),
(@PATH, 11, -9382.24, -84.2414, 63.4885, 0, 0, 0, 0, 100, 0),
(@PATH, 12, -9381.7, -91.5521, 62.9217, 0, 0, 0, 0, 100, 0),
(@PATH, 13, -9376.36, -93.733, 63.2707, 0, 0, 0, 0, 100, 0),
(@PATH, 14, -9372.08, -93.1172, 63.8368, 0, 0, 0, 0, 100, 0),
(@PATH, 15, -9365.3, -91.3687, 64.634, 0, 0, 0, 0, 100, 0),
(@PATH, 16, -9355.57, -88.9763, 65.3241, 0, 0, 0, 0, 100, 0),
(@PATH, 17, -9348.62, -88.1182, 65.4435, 0, 0, 0, 0, 100, 0),
(@PATH, 18, -9343.53, -87.4706, 65.9026, 0, 0, 0, 0, 100, 0),
(@PATH, 19, -9336.85, -84.8624, 67.1047, 0, 0, 0, 0, 100, 0),
(@PATH, 20, -9332.23, -80.4332, 67.9971, 0, 0, 0, 0, 100, 0),
(@PATH, 21, -9328.48, -74.53, 68.3166, 0, 0, 0, 0, 100, 0),
(@PATH, 22, -9325.15, -69.8934, 68.0528, 0, 0, 0, 0, 100, 0),
(@PATH, 23, -9318.21, -64.2456, 67.2191, 0, 0, 0, 0, 100, 0),
(@PATH, 24, -9313.28, -61.847, 67.0896, 0, 0, 0, 0, 100, 0),
(@PATH, 25, -9305.41, -60.3452, 66.9876, 0, 0, 0, 0, 100, 0),
(@PATH, 26, -9296.23, -61.7631, 67.249, 0, 0, 0, 0, 100, 0),
(@PATH, 27, -9290.15, -64.9306, 67.645, 0, 0, 0, 0, 100, 0),
(@PATH, 28, -9281.5, -70.8825, 68.0632, 0, 0, 0, 0, 100, 0),
(@PATH, 29, -9270.2, -79.1402, 68.6133, 0, 0, 0, 0, 100, 0),
(@PATH, 30, -9258.7, -87.1119, 69.4765, 0, 0, 0, 0, 100, 0),
(@PATH, 31, -9249.94, -92.9011, 70.3125, 0, 0, 0, 0, 100, 0),
(@PATH, 32, -9237.74, -99.7221, 70.6789, 0, 0, 0, 0, 100, 0),
(@PATH, 33, -9227.93, -103.444, 71.1278, 0, 0, 0, 0, 100, 0),
(@PATH, 34, -9217.9, -106.527, 71.1899, 0, 0, 0, 0, 100, 0),
(@PATH, 35, -9207.64, -108.756, 71.1295, 0, 0, 0, 0, 100, 0),
(@PATH, 36, -9197.31, -110.613, 71.1654, 0, 0, 0, 0, 100, 0),
(@PATH, 37, -9186.91, -111.991, 70.9437, 0, 0, 0, 0, 100, 0),
(@PATH, 38, -9178.15, -111.669, 71.1114, 0, 0, 0, 0, 100, 0),
(@PATH, 39, -9167.85, -109.651, 72.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 40, -9162.08, -109.095, 72.5969, 0, 0, 0, 0, 100, 0),
(@PATH, 41, -9155.34, -114.873, 73.7624, 0, 0, 0, 0, 100, 0),
(@PATH, 42, -9155.04, -120.091, 74.232, 0, 0, 0, 0, 100, 0),
(@PATH, 43, -9158.17, -128.137, 74.2367, 0, 0, 0, 0, 100, 0),
(@PATH, 44, -9157.47, -133.741, 75.1087, 0, 0, 0, 0, 100, 0),
(@PATH, 45, -9153.17, -136.953, 74.7505, 0, 0, 0, 0, 100, 0),
(@PATH, 46, -9151.44, -137.193, 74.5636, 0, 0, 0, 0, 100, 0),
(@PATH, 47, -9147.98, -133.336, 75.3929, 0, 0, 0, 0, 100, 0),
(@PATH, 48, -9151.29, -132.604, 75.4152, 0, 0, 0, 0, 100, 0),
(@PATH, 49, -9154.44, -134.81, 75.0993, 0, 30000, 0, 0, 100, 0),
(@PATH, 50, -9155.41, -135.457, 75.0219, 0, 0, 0, 0, 100, 0),
(@PATH, 51, -9159.41, -125.745, 73.7823, 0, 0, 0, 0, 100, 0),
(@PATH, 52, -9163.57, -117.941, 72.8302, 0, 0, 0, 0, 100, 0),
(@PATH, 53, -9168.52, -113.876, 72.1067, 0, 0, 0, 0, 100, 0),
(@PATH, 54, -9179.14, -112.58, 70.9958, 0, 0, 0, 0, 100, 0),
(@PATH, 55, -9189.62, -111.932, 70.9847, 0, 0, 0, 0, 100, 0),
(@PATH, 56, -9200.04, -110.7, 71.1596, 0, 0, 0, 0, 100, 0),
(@PATH, 57, -9212.34, -107.986, 71.2069, 0, 0, 0, 0, 100, 0),
(@PATH, 58, -9219.06, -106.051, 71.1665, 0, 0, 0, 0, 100, 0),
(@PATH, 59, -9231.87, -101.041, 71.0486, 0, 0, 0, 0, 100, 0),
(@PATH, 60, -9241.1, -96.0433, 70.7299, 0, 0, 0, 0, 100, 0),
(@PATH, 61, -9252.92, -88.559, 70.1368, 0, 0, 0, 0, 100, 0),
(@PATH, 62, -9264.45, -80.6122, 68.8488, 0, 0, 0, 0, 100, 0),
(@PATH, 63, -9275.98, -72.6654, 68.3797, 0, 0, 0, 0, 100, 0),
(@PATH, 64, -9284.66, -66.7682, 67.8845, 0, 0, 0, 0, 100, 0),
(@PATH, 65, -9293.87, -61.7518, 67.3272, 0, 0, 0, 0, 100, 0),
(@PATH, 66, -9303.82, -58.4508, 66.7927, 0, 0, 0, 0, 100, 0),
(@PATH, 67, -9314.03, -56.0206, 66.6752, 0, 0, 0, 0, 100, 0),
(@PATH, 68, -9327.68, -52.9497, 66.1404, 0, 0, 0, 0, 100, 0),
(@PATH, 69, -9337.52, -49.3289, 65.6574, 0, 0, 0, 0, 100, 0),
(@PATH, 70, -9346.77, -43.0368, 65.1328, 0, 0, 0, 0, 100, 0),
(@PATH, 71, -9354.5, -35.9323, 64.4145, 0, 0, 0, 0, 100, 0),
(@PATH, 72, -9362, -28.5894, 63.7007, 0, 0, 0, 0, 100, 0),
(@PATH, 73, -9369.51, -21.2465, 62.8835, 0, 0, 0, 0, 100, 0),
(@PATH, 74, -9378.92, -10.8996, 61.7456, 0, 0, 0, 0, 100, 0),
(@PATH, 75, -9385.8, -2.97428, 61.0096, 0, 0, 0, 0, 100, 0),
(@PATH, 76, -9395.16, 7.44363, 60.0094, 0, 0, 0, 0, 100, 0),
(@PATH, 77, -9406.85, 20.466, 58.9473, 0, 0, 0, 0, 100, 0),
(@PATH, 78, -9416.2, 30.8839, 57.6287, 0, 0, 0, 0, 100, 0),
(@PATH, 79, -9425.66, 41.1932, 57.03, 0, 0, 0, 0, 100, 0),
(@PATH, 80, -9438.47, 53.1694, 56.114, 0, 0, 0, 0, 100, 0),
(@PATH, 81, -9444.03, 57.4189, 56.0142, 0, 0, 0, 0, 100, 0),
(@PATH, 82, -9451.92, 61.2165, 55.9194, 0, 0, 0, 0, 100, 0),
(@PATH, 83, -9460.65, 61.2785, 55.8536, 0, 0, 0, 0, 100, 0),
(@PATH, 84, -9461.93, 61.1691, 55.8947, 0, 0, 0, 0, 100, 0),
(@PATH, 85, -9469.19, 59.6835, 56.1937, 0, 0, 0, 0, 100, 0),
(@PATH, 86, -9472.46, 64.3967, 56.0649, 0, 30000, 0, 0, 100, 0),
(@PATH, 87, -9468.04, 67.1008, 56.1885, 0, 0, 0, 0, 100, 0),
(@PATH, 88, -9457.57, 67.6594, 56.2101, 0, 0, 0, 0, 100, 0),
(@PATH, 89, -9447.22, 69.3377, 56.3616, 0, 0, 0, 0, 100, 0),
(@PATH, 90, -9439.49, 72.2851, 56.1864, 0, 0, 0, 0, 100, 0),
(@PATH, 91, -9430.24, 77.2203, 56.3138, 0, 0, 0, 0, 100, 0),
(@PATH, 92, -9421.34, 82.7813, 56.6331, 0, 0, 0, 0, 100, 0),
(@PATH, 93, -9412.63, 88.6589, 57.307, 0, 0, 0, 0, 100, 0),
(@PATH, 94, -9400.8, 96.1144, 58.5008, 0, 0, 0, 0, 100, 0),
(@PATH, 95, -9393.7, 99.3682, 58.9069, 0, 0, 0, 0, 100, 0),
(@PATH, 96, -9383.76, 102.734, 59.7659, 0, 0, 0, 0, 100, 0),
(@PATH, 97, -9373.81, 106.093, 60.6065, 0, 0, 0, 0, 100, 0),
(@PATH, 98, -9361, 111.682, 61.4774, 0, 0, 0, 0, 100, 0),
(@PATH, 99, -9348.61, 118.168, 62.7774, 0, 0, 0, 0, 100, 0),
(@PATH, 100, -9339.41, 123.031, 63.4321, 0, 0, 0, 0, 100, 0),
(@PATH, 101, -9323.96, 131.233, 64.1046, 0, 0, 0, 0, 100, 0),
(@PATH, 102, -9308.5, 139.439, 65.4717, 0, 0, 0, 0, 100, 0),
(@PATH, 103, -9291.12, 147.323, 66.3921, 0, 0, 0, 0, 100, 0),
(@PATH, 104, -9278.84, 150.071, 66.7508, 0, 0, 0, 0, 100, 0),
(@PATH, 105, -9265.02, 152.277, 67.298, 0, 0, 0, 0, 100, 0),
(@PATH, 106, -9254.45, 156.499, 67.8177, 0, 0, 0, 0, 100, 0),
(@PATH, 107, -9248.12, 163.394, 67.9424, 0, 0, 0, 0, 100, 0),
(@PATH, 108, -9242.45, 172.23, 67.88, 0, 0, 0, 0, 100, 0),
(@PATH, 109, -9234.15, 183.49, 67.6577, 0, 0, 0, 0, 100, 0),
(@PATH, 110, -9225.11, 194.169, 68.2985, 0, 0, 0, 0, 100, 0),
(@PATH, 111, -9215.91, 204.717, 69.2435, 0, 0, 0, 0, 100, 0),
(@PATH, 112, -9204.4, 217.902, 70.9475, 0, 0, 0, 0, 100, 0),
(@PATH, 113, -9193, 231.174, 71.817, 0, 0, 0, 0, 100, 0),
(@PATH, 114, -9187.79, 241.188, 72.5264, 0, 0, 0, 0, 100, 0),
(@PATH, 115, -9184.19, 254.693, 73.654, 0, 0, 0, 0, 100, 0),
(@PATH, 116, -9182.25, 268.54, 74.7483, 0, 0, 0, 0, 100, 0),
(@PATH, 117, -9181.6, 279.016, 75.6831, 0, 0, 0, 0, 100, 0),
(@PATH, 118, -9180.8, 296.498, 77.7167, 0, 0, 0, 0, 100, 0),
(@PATH, 119, -9180, 313.974, 79.371, 0, 0, 0, 0, 100, 0),
(@PATH, 120, -9178.52, 327.678, 81.466, 0, 0, 0, 0, 100, 0),
(@PATH, 121, -9172.67, 340.542, 84.374, 0, 0, 0, 0, 100, 0),
(@PATH, 122, -9160.16, 356.591, 88.6446, 0, 0, 0, 0, 100, 0),
(@PATH, 123, -9148.06, 369.234, 90.3806, 0, 0, 0, 0, 100, 0),
(@PATH, 124, -9138.28, 378.404, 90.6199, 0, 0, 0, 0, 100, 0),
(@PATH, 125, -9127.16, 386.91, 91.0892, 0, 0, 0, 0, 100, 0),
(@PATH, 126, -9113.37, 397.676, 92.4758, 0, 0, 0, 0, 100, 0),
(@PATH, 127, -9102.41, 406.371, 92.6455, 0, 0, 0, 0, 100, 0),
(@PATH, 128, -9094.18, 412.897, 92.1286, 0, 0, 0, 0, 100, 0),
(@PATH, 129, -9085.96, 419.415, 92.3447, 0, 0, 0, 0, 100, 0),
(@PATH, 130, -9077.47, 425.599, 93.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 131, -9075.49, 426.889, 93.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 132, -9069.71, 430.835, 93.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 133, -9067.73, 432.281, 93.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 134, -9061.32, 431.62, 93.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 135, -9058.09, 433.429, 93.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 136, -9056.32, 437.841, 93.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 137, -9057.77, 440.978, 93.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 138, -9058.21, 441.523, 93.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 139, -9058.21, 441.523, 93.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 140, -9062.25, 438.062, 93.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 141, -9061.79, 437.389, 93.0562, 0, 30000, 0, 0, 100, 0),
(@PATH, 283, -9373, -66.336502, 69.2021, 0, 180000, 0, 0, 100, 0),
(@PATH, 282, -9375.14, -70.5235, 69.2021, 0, 0, 0, 0, 100, 0),
(@PATH, 281, -9377.67, -72.9422, 69.1951, 0, 0, 0, 0, 100, 0),
(@PATH, 280, -9384.01, -76.1072, 69.1587, 0, 0, 0, 0, 100, 0),
(@PATH, 279, -9389.03, -73.8447, 66.5582, 0, 0, 0, 0, 100, 0),
(@PATH, 278, -9392.28, -70.9913, 64.4379, 0, 0, 0, 0, 100, 0),
(@PATH, 277, -9392.28, -70.9913, 64.4379, 0, 0, 0, 0, 100, 0),
(@PATH, 276, -9390.7, -68.5401, 64.4379, 0, 0, 0, 0, 100, 0),
(@PATH, 275, -9386.24, -72.644, 64.4379, 0, 0, 0, 0, 100, 0),
(@PATH, 274, -9383.9, -75.2439, 64.4379, 0, 0, 0, 0, 100, 0),
(@PATH, 273, -9381.51, -78.4171, 64.4379, 0, 0, 0, 0, 100, 0),
(@PATH, 272, -9382.24, -84.2414, 63.4885, 0, 0, 0, 0, 100, 0),
(@PATH, 271, -9381.7, -91.5521, 62.9217, 0, 0, 0, 0, 100, 0),
(@PATH, 270, -9376.36, -93.733, 63.2707, 0, 0, 0, 0, 100, 0),
(@PATH, 269, -9372.08, -93.1172, 63.8368, 0, 0, 0, 0, 100, 0),
(@PATH, 268, -9365.3, -91.3687, 64.634, 0, 0, 0, 0, 100, 0),
(@PATH, 267, -9355.57, -88.9763, 65.3241, 0, 0, 0, 0, 100, 0),
(@PATH, 266, -9348.62, -88.1182, 65.4435, 0, 0, 0, 0, 100, 0),
(@PATH, 265, -9343.53, -87.4706, 65.9026, 0, 0, 0, 0, 100, 0),
(@PATH, 264, -9336.85, -84.8624, 67.1047, 0, 0, 0, 0, 100, 0),
(@PATH, 263, -9332.23, -80.4332, 67.9971, 0, 0, 0, 0, 100, 0),
(@PATH, 262, -9328.48, -74.53, 68.3166, 0, 0, 0, 0, 100, 0),
(@PATH, 261, -9325.15, -69.8934, 68.0528, 0, 0, 0, 0, 100, 0),
(@PATH, 260, -9318.21, -64.2456, 67.2191, 0, 0, 0, 0, 100, 0),
(@PATH, 258, -9313.28, -61.847, 67.0896, 0, 0, 0, 0, 100, 0),
(@PATH, 257, -9305.41, -60.3452, 66.9876, 0, 0, 0, 0, 100, 0),
(@PATH, 256, -9296.23, -61.7631, 67.249, 0, 0, 0, 0, 100, 0),
(@PATH, 255, -9290.15, -64.9306, 67.645, 0, 0, 0, 0, 100, 0),
(@PATH, 254, -9281.5, -70.8825, 68.0632, 0, 0, 0, 0, 100, 0),
(@PATH, 253, -9270.2, -79.1402, 68.6133, 0, 0, 0, 0, 100, 0),
(@PATH, 252, -9258.7, -87.1119, 69.4765, 0, 0, 0, 0, 100, 0),
(@PATH, 251, -9249.94, -92.9011, 70.3125, 0, 0, 0, 0, 100, 0),
(@PATH, 250, -9237.74, -99.7221, 70.6789, 0, 0, 0, 0, 100, 0),
(@PATH, 249, -9227.93, -103.444, 71.1278, 0, 0, 0, 0, 100, 0),
(@PATH, 248, -9217.9, -106.527, 71.1899, 0, 0, 0, 0, 100, 0),
(@PATH, 247, -9207.64, -108.756, 71.1295, 0, 0, 0, 0, 100, 0),
(@PATH, 246, -9197.31, -110.613, 71.1654, 0, 0, 0, 0, 100, 0),
(@PATH, 245, -9186.91, -111.991, 70.9437, 0, 0, 0, 0, 100, 0),
(@PATH, 244, -9178.15, -111.669, 71.1114, 0, 0, 0, 0, 100, 0),
(@PATH, 243, -9167.85, -109.651, 72.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 242, -9162.08, -109.095, 72.5969, 0, 0, 0, 0, 100, 0),
(@PATH, 241, -9155.34, -114.873, 73.7624, 0, 0, 0, 0, 100, 0),
(@PATH, 240, -9155.04, -120.091, 74.232, 0, 0, 0, 0, 100, 0),
(@PATH, 239, -9158.17, -128.137, 74.2367, 0, 0, 0, 0, 100, 0),
(@PATH, 238, -9157.47, -133.741, 75.1087, 0, 0, 0, 0, 100, 0),
(@PATH, 237, -9153.17, -136.953, 74.7505, 0, 0, 0, 0, 100, 0),
(@PATH, 236, -9151.44, -137.193, 74.5636, 0, 0, 0, 0, 100, 0),
(@PATH, 235, -9147.98, -133.336, 75.3929, 0, 0, 0, 0, 100, 0),
(@PATH, 234, -9151.29, -132.604, 75.4152, 0, 0, 0, 0, 100, 0),
(@PATH, 233, -9154.44, -134.81, 75.0993, 0, 30000, 0, 0, 100, 0),
(@PATH, 232, -9155.41, -135.457, 75.0219, 0, 0, 0, 0, 100, 0),
(@PATH, 231, -9159.41, -125.745, 73.7823, 0, 0, 0, 0, 100, 0),
(@PATH, 230, -9163.57, -117.941, 72.8302, 0, 0, 0, 0, 100, 0),
(@PATH, 229, -9168.52, -113.876, 72.1067, 0, 0, 0, 0, 100, 0),
(@PATH, 228, -9179.14, -112.58, 70.9958, 0, 0, 0, 0, 100, 0),
(@PATH, 227, -9189.62, -111.932, 70.9847, 0, 0, 0, 0, 100, 0),
(@PATH, 226, -9200.04, -110.7, 71.1596, 0, 0, 0, 0, 100, 0),
(@PATH, 225, -9212.34, -107.986, 71.2069, 0, 0, 0, 0, 100, 0),
(@PATH, 224, -9219.06, -106.051, 71.1665, 0, 0, 0, 0, 100, 0),
(@PATH, 223, -9231.87, -101.041, 71.0486, 0, 0, 0, 0, 100, 0),
(@PATH, 222, -9241.1, -96.0433, 70.7299, 0, 0, 0, 0, 100, 0),
(@PATH, 221, -9252.92, -88.559, 70.1368, 0, 0, 0, 0, 100, 0),
(@PATH, 220, -9264.45, -80.6122, 68.8488, 0, 0, 0, 0, 100, 0),
(@PATH, 219, -9275.98, -72.6654, 68.3797, 0, 0, 0, 0, 100, 0),
(@PATH, 218, -9284.66, -66.7682, 67.8845, 0, 0, 0, 0, 100, 0),
(@PATH, 217, -9293.87, -61.7518, 67.3272, 0, 0, 0, 0, 100, 0),
(@PATH, 216, -9303.82, -58.4508, 66.7927, 0, 0, 0, 0, 100, 0),
(@PATH, 215, -9314.03, -56.0206, 66.6752, 0, 0, 0, 0, 100, 0),
(@PATH, 214, -9327.68, -52.9497, 66.1404, 0, 0, 0, 0, 100, 0),
(@PATH, 213, -9337.52, -49.3289, 65.6574, 0, 0, 0, 0, 100, 0),
(@PATH, 212, -9346.77, -43.0368, 65.1328, 0, 0, 0, 0, 100, 0),
(@PATH, 211, -9354.5, -35.9323, 64.4145, 0, 0, 0, 0, 100, 0),
(@PATH, 210, -9362, -28.5894, 63.7007, 0, 0, 0, 0, 100, 0),
(@PATH, 209, -9369.51, -21.2465, 62.8835, 0, 0, 0, 0, 100, 0),
(@PATH, 208, -9378.92, -10.8996, 61.7456, 0, 0, 0, 0, 100, 0),
(@PATH, 207, -9385.8, -2.97428, 61.0096, 0, 0, 0, 0, 100, 0),
(@PATH, 206, -9395.16, 7.44363, 60.0094, 0, 0, 0, 0, 100, 0),
(@PATH, 205, -9406.85, 20.466, 58.9473, 0, 0, 0, 0, 100, 0),
(@PATH, 204, -9416.2, 30.8839, 57.6287, 0, 0, 0, 0, 100, 0),
(@PATH, 203, -9425.66, 41.1932, 57.03, 0, 0, 0, 0, 100, 0),
(@PATH, 202, -9438.47, 53.1694, 56.114, 0, 0, 0, 0, 100, 0),
(@PATH, 201, -9444.03, 57.4189, 56.0142, 0, 0, 0, 0, 100, 0),
(@PATH, 200, -9451.92, 61.2165, 55.9194, 0, 0, 0, 0, 100, 0),
(@PATH, 199, -9460.65, 61.2785, 55.8536, 0, 0, 0, 0, 100, 0),
(@PATH, 198, -9461.93, 61.1691, 55.8947, 0, 0, 0, 0, 100, 0),
(@PATH, 197, -9469.19, 59.6835, 56.1937, 0, 0, 0, 0, 100, 0),
(@PATH, 196, -9472.46, 64.3967, 56.0649, 0, 30000, 0, 0, 100, 0),
(@PATH, 195, -9468.04, 67.1008, 56.1885, 0, 0, 0, 0, 100, 0),
(@PATH, 194, -9457.57, 67.6594, 56.2101, 0, 0, 0, 0, 100, 0),
(@PATH, 193, -9447.22, 69.3377, 56.3616, 0, 0, 0, 0, 100, 0),
(@PATH, 192, -9439.49, 72.2851, 56.1864, 0, 0, 0, 0, 100, 0),
(@PATH, 191, -9430.24, 77.2203, 56.3138, 0, 0, 0, 0, 100, 0),
(@PATH, 190, -9421.34, 82.7813, 56.6331, 0, 0, 0, 0, 100, 0),
(@PATH, 189, -9412.63, 88.6589, 57.307, 0, 0, 0, 0, 100, 0),
(@PATH, 188, -9400.8, 96.1144, 58.5008, 0, 0, 0, 0, 100, 0),
(@PATH, 187, -9393.7, 99.3682, 58.9069, 0, 0, 0, 0, 100, 0),
(@PATH, 186, -9383.76, 102.734, 59.7659, 0, 0, 0, 0, 100, 0),
(@PATH, 185, -9373.81, 106.093, 60.6065, 0, 0, 0, 0, 100, 0),
(@PATH, 184, -9361, 111.682, 61.4774, 0, 0, 0, 0, 100, 0),
(@PATH, 183, -9348.61, 118.168, 62.7774, 0, 0, 0, 0, 100, 0),
(@PATH, 182, -9339.41, 123.031, 63.4321, 0, 0, 0, 0, 100, 0),
(@PATH, 181, -9323.96, 131.233, 64.1046, 0, 0, 0, 0, 100, 0),
(@PATH, 180, -9308.5, 139.439, 65.4717, 0, 0, 0, 0, 100, 0),
(@PATH, 179, -9291.12, 147.323, 66.3921, 0, 0, 0, 0, 100, 0),
(@PATH, 178, -9278.84, 150.071, 66.7508, 0, 0, 0, 0, 100, 0),
(@PATH, 177, -9265.02, 152.277, 67.298, 0, 0, 0, 0, 100, 0),
(@PATH, 176, -9254.45, 156.499, 67.8177, 0, 0, 0, 0, 100, 0),
(@PATH, 175, -9248.12, 163.394, 67.9424, 0, 0, 0, 0, 100, 0),
(@PATH, 174, -9242.45, 172.23, 67.88, 0, 0, 0, 0, 100, 0),
(@PATH, 173, -9234.15, 183.49, 67.6577, 0, 0, 0, 0, 100, 0),
(@PATH, 172, -9225.11, 194.169, 68.2985, 0, 0, 0, 0, 100, 0),
(@PATH, 171, -9215.91, 204.717, 69.2435, 0, 0, 0, 0, 100, 0),
(@PATH, 170, -9204.4, 217.902, 70.9475, 0, 0, 0, 0, 100, 0),
(@PATH, 169, -9193, 231.174, 71.817, 0, 0, 0, 0, 100, 0),
(@PATH, 168, -9187.79, 241.188, 72.5264, 0, 0, 0, 0, 100, 0),
(@PATH, 167, -9184.19, 254.693, 73.654, 0, 0, 0, 0, 100, 0),
(@PATH, 166, -9182.25, 268.54, 74.7483, 0, 0, 0, 0, 100, 0),
(@PATH, 165, -9181.6, 279.016, 75.6831, 0, 0, 0, 0, 100, 0),
(@PATH, 164, -9180.8, 296.498, 77.7167, 0, 0, 0, 0, 100, 0),
(@PATH, 163, -9180, 313.974, 79.371, 0, 0, 0, 0, 100, 0),
(@PATH, 162, -9178.52, 327.678, 81.466, 0, 0, 0, 0, 100, 0),
(@PATH, 161, -9172.67, 340.542, 84.374, 0, 0, 0, 0, 100, 0),
(@PATH, 160, -9160.16, 356.591, 88.6446, 0, 0, 0, 0, 100, 0),
(@PATH, 159, -9148.06, 369.234, 90.3806, 0, 0, 0, 0, 100, 0),
(@PATH, 158, -9138.28, 378.404, 90.6199, 0, 0, 0, 0, 100, 0),
(@PATH, 157, -9127.16, 386.91, 91.0892, 0, 0, 0, 0, 100, 0),
(@PATH, 156, -9113.37, 397.676, 92.4758, 0, 0, 0, 0, 100, 0),
(@PATH, 155, -9102.41, 406.371, 92.6455, 0, 0, 0, 0, 100, 0),
(@PATH, 154, -9094.18, 412.897, 92.1286, 0, 0, 0, 0, 100, 0),
(@PATH, 153, -9085.96, 419.415, 92.3447, 0, 0, 0, 0, 100, 0),
(@PATH, 152, -9077.47, 425.599, 93.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 151, -9075.49, 426.889, 93.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 150, -9069.71, 430.835, 93.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 149, -9067.73, 432.281, 93.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 148, -9061.32, 431.62, 93.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 147, -9058.09, 433.429, 93.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 146, -9056.32, 437.841, 93.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 145, -9057.77, 440.978, 93.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 144, -9058.21, 441.523, 93.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 143, -9058.21, 441.523, 93.0562, 0, 0, 0, 0, 100, 0),
(@PATH, 142, -9062.25, 438.062, 93.0562, 0, 0, 0, 0, 100, 0);

however the music/sounds from the woman/c'thun/ghul etc. is missing

Rushor picture Rushor on 9 Feb 2017

A banshee scream.
A ghoul call.
C'Thun saying, "You... Will... Die." - 8585
C'Thun saying, "Death is close." - 8580
Growling.
A woman crying.

offl picture offl on 9 Feb 2017

if we don't get a sniff for this someone could search manually for the soundfiles maybe? or at least search for a sound like:

A banshee scream.
A ghoul call.
Growling.
A woman crying.

Rushor picture Rushor on 9 Feb 2017

@Rushor , something like this 1171, 8585, 8580, 12863, 6916 ?

Eliminationzx picture Eliminationzx on 9 Feb 2017
👍1
ghost picture ghost on 9 Feb 2017
👍1

@tkrokli , thank you :)

Eliminationzx picture Eliminationzx on 9 Feb 2017

yes nice! one last is missing: "A ghoul call."

Rushor picture Rushor on 9 Feb 2017

Also kids should use random movement while they are not moving by path.
https://www.youtube.com/watch?v=MapUz5xNq54

At the end of path they should change orientation like on this vid:
https://youtu.be/c1OESPtnmtU?t=6m28s

Missing script forgame_event and game_event_creature

DELETE FROM `game_event_creature` WHERE  @eventEntry=73;
INSERT INTO `game_event_creature` VALUES 
(73, 79638),
(73, 79639),
(73, 79640),
(73, 79641),
(73, 79642),
(73, 79643);

DELETE FROM `game_event` WHERE eventEntry=73;
INSERT INTO `game_event` VALUES (73, '2017-01-24 07:00:00', '2020-07-04 10:00:00', 1380, 60, 0, 'Children of Goldshire ', 0, 2);
Eliminationzx picture Eliminationzx on 9 Feb 2017

Don't forget that this fix is only for 3.3.5.
https://github.com/TrinityCore/TrinityCore/issues/18583#issuecomment-269132432

offl picture offl on 9 Feb 2017

I tried browsing through 1000 sound files between http://www.wowhead.com/sounds and http://www.wowhead.com/sounds#950 , but that list is not specific enough to find a match.

http://www.wowhead.com/sound=17895/amb-deserthigh-day seems to be an ambient sound file, but I don't know if it fits better than one of the 6 "ghoul birth" sounds in http://www.wowhead.com/sound=12945/northrendghoulbirth (which to me sound like they could be used by a Death Knight ghoul pet when it is summoned). I will leave it to you to choose.

ghost picture ghost on 9 Feb 2017

Maybe this is the "A ghoul call." sound:
https://youtu.be/XsyId7W_3G0?t=3m12s

ArcaneFox picture ArcaneFox on 9 Feb 2017

I worked on this as well, it seems on retail the kids don't go inside anymore so pathing will not be 100% correct. Also some of these kids run off while waiting at some point. They even teleport somewhere. Sniffed this several times.

Kittnz picture Kittnz on 10 Feb 2017

Path is not finished yet.

Eliminationzx picture Eliminationzx on 10 Feb 2017

I've got finished pathing for them staying outside.

Kittnz picture Kittnz on 10 Feb 2017

@Kittnz , can you make pathing also for wotlk, like on this video
https://www.youtube.com/watch?v=c1OESPtnmtU ? :)

Eliminationzx picture Eliminationzx on 10 Feb 2017

I can modify it and add a few points yes.

Kittnz picture Kittnz on 10 Feb 2017

The main issue with this is the formation, i'm not sure if we can disband the formation with SAI. Haven't checked that out.

Kittnz picture Kittnz on 10 Feb 2017

@Kittnz , I have done special SAI action 

        case SMART_ACTION_RESET_FORMATIONS:
            {
                ObjectList* targets = GetTargets(e, unit);

                if (!targets)
                    break;

                for (ObjectList::const_iterator itr = targets->begin(); itr != targets->end(); ++itr)
                {
                    if (Creature* creature = (*itr)->ToCreature())
                        creature->GetFormation()->FormationReset(true);
                }

                delete targets;
                break;
            }

and it works

Eliminationzx picture Eliminationzx on 10 Feb 2017

but FormationReset makes them to modeidle no?

Rushor picture Rushor on 10 Feb 2017

@Rushor , we can still move them with SMART_ACTION_MOVE_TO_POS

Eliminationzx picture Eliminationzx on 10 Feb 2017

the whole script feels so hacky then xd, but he have no other option to fix it like that

Rushor picture Rushor on 10 Feb 2017

Yeah that will be the way to do it, when i get home ill post what i have.

Kittnz picture Kittnz on 10 Feb 2017

I need correct path and I can fix this issue.

Eliminationzx picture Eliminationzx on 10 Feb 2017

@ArcaneFox : regarding your video sample in https://github.com/TrinityCore/TrinityCore/issues/19090#issuecomment-278791547 , that "ghoul call" sound clip sounds similar (to me) to a fire elemental like http://www.wowhead.com/npc=53630/unstable-pyrelord#sounds

ghost picture ghost on 10 Feb 2017

I need correct path and I can fix this issue.

you won't get them. on retail they no longer walk inside the house so we need to add a work-around for that

Rushor picture Rushor on 11 Feb 2017

it's the same path, just not going inside, you can clearly see the points where he walks on video, we can just add these points ourself..

Kittnz picture Kittnz on 11 Feb 2017

It still needs finishing.
These points go inside the house. We have to manually change them.
Need points where the kids stand inside the house.
The random movement between the stop points needs to be added.
And proper game_event entry & guids

Have no time to finish at the moment, maybe @Rushor can.

``sql DELETE FROMgame_eventWHEREeventEntry=73; INSERT INTOgame_event(eventEntry,start_time,end_time,occurence,length,holiday,description,world_event,announce`) VALUES
(73, '2010-07-04 07:00:00', '2020-07-04 07:00:00', 660, 780, 0, 'Children of Goldshire', 0, 2);

DELETE FROM game_event_creature WHERE guid IN (79638, 79639, 79640, 79641, 79642, 79643);
INSERT INTO game_event_creature (eventEntry, guid) VALUES
(73, 79638),
(73, 79639),
(73, 79640),
(73, 79641),
(73, 79642),
(73, 79643);

UPDATE creature SET position_x=-9350.654, position_y=-90.29861, position_z=65.15973, orientation=0 WHERE guid=79642;
UPDATE creature SET position_x=-9354.359, position_y=-91.97743, position_z=64.87327, orientation=0 WHERE guid=79643;
UPDATE creature SET position_x=-9356.938, position_y=-87.10703, position_z=64.92709, orientation=0 WHERE guid=79641;
UPDATE creature SET position_x=-9355.375, position_y=-87.10703, position_z=65.69692, orientation=0 WHERE guid=79638;
UPDATE creature SET position_x=-9353.279, position_y=-89.96702, position_z=65.22049, orientation=0 WHERE guid=79640;
UPDATE creature SET position_x=-9352.859, position_y=-93.96007, position_z=64.4566, orientation=0 WHERE guid=79639;

DELETE FROM creature_formations WHERE leaderGUID=79638;
INSERT INTO creature_formations (leaderGUID, memberGUID, dist, angle, groupAI) VALUES
(79638, 79638, 0, 0, 0), -- Cameron
(79638, 79639, 3, 230, 0), -- John
(79638, 79640, 3, 180, 0), -- Dana
(79638, 79641, 3, 130, 0), -- Jose
(79638, 79642, 3, 310, 0), -- Lisa
(79638, 79643, 3, 50, 0); -- Aaron

SET @ENTRY := 80500;
DELETE FROM waypoints WHERE entry=@ENTRY;
INSERT INTO waypoints (entry, pointid, position_x, position_y, position_z, point_comment) VALUES
(@ENTRY, 1 ,-9351.973,-92.05708,64.95626, 'Cameron'), -- 07:00:21
(@ENTRY, 2 ,-9354.806,-87.93577,65.57292, 'Cameron'), -- 07:00:21
(@ENTRY, 3 ,-9357.639,-83.81445,66.18958, 'Cameron'), -- 07:00:21
(@ENTRY, 4 ,-9360.979,-78.97743,65.9347, 'Cameron'), -- 07:00:21
(@ENTRY, 5 ,-9359.736,-75.17188,65.31458, 'Cameron'), -- 07:00:21
(@ENTRY, 6 ,-9358.805,-72.31836,64.56458, 'Cameron'), -- 07:00:21
(@ENTRY, 7 ,-9357.252,-67.5625,65.31458, 'Cameron'), -- 07:00:21
(@ENTRY, 8 ,-9357.252,-67.5625,65.31458, 'Cameron'), -- 07:00:21
(@ENTRY, 9 ,-9356.818,-59.81693,66.47333, 'Cameron'), -- 07:00:23
(@ENTRY, 10 ,-9359.703,-40.74677,64.90179, 'Cameron'), -- 07:00:24
(@ENTRY, 11 ,-9366.912,-26.63774,63.58042, 'Cameron'), -- 07:00:27
(@ENTRY, 12 ,-9376.815,-16.4907,62.47466, 'Cameron'), -- 07:00:29
(@ENTRY, 13 ,-9390.682,0.2398973,60.84456, 'Cameron'), -- 07:00:30
(@ENTRY, 14 ,-9402.53,14.60529,59.79248, 'Cameron'), -- 07:00:34
(@ENTRY, 15 ,-9419.141,34.55973,57.84264, 'Cameron'), -- 07:00:35
(@ENTRY, 16 ,-9426.896,43.84751,57.06255, 'Cameron'), -- 07:00:40
(@ENTRY, 17 ,-9433.867,53.78213,56.78226, 'Cameron'), -- 07:00:41
(@ENTRY, 18 ,-9438.548,61.02147,56.39376, 'Cameron'), -- 07:00:42
(@ENTRY, 19 ,-9436.482,68.04466,56.42494, 'Cameron'), -- 07:00:44
(@ENTRY, 20 ,-9415.27,87.07191,57.30513, 'Cameron'), -- 07:00:45
(@ENTRY, 21 ,-9396.235,98.29691,59.15154, 'Cameron'), -- 07:00:47
(@ENTRY, 22 ,-9375.271,106.7702,60.70432, 'Cameron'), -- 07:00:51
(@ENTRY, 23 ,-9364.256,110.7547,61.50436, 'Cameron'), -- 07:00:53
(@ENTRY, 24 ,-9344.307,120.2394,63.43427, 'Cameron'), -- 07:00:55
(@ENTRY, 25 ,-9332.738,126.8489,63.9777, 'Cameron'), -- 07:00:57
(@ENTRY, 26 ,-9308.697,137.7139,65.57498, 'Cameron'), -- 07:00:59
(@ENTRY, 27 ,-9292.605,144.2936,66.53963, 'Cameron'), -- 07:01:03
(@ENTRY, 28 ,-9271.355,152.9366,67.37766, 'Cameron'), -- 07:01:04
(@ENTRY, 29 ,-9258.908,158.3268,67.75345, 'Cameron'), -- 07:01:07
(@ENTRY, 30 ,-9258.107,158.9872,67.80977, 'Cameron'), -- 07:01:08
(@ENTRY, 31 ,-9245.959,170.1512,68.25052, 'Cameron'), -- 07:01:10
(@ENTRY, 32 ,-9219.314,201.358,69.06726, 'Cameron'), -- 07:01:13
(@ENTRY, 33 ,-9208.215,212.5414,70.81392, 'Cameron'), -- 07:01:17
(@ENTRY, 34 ,-9198.92,222.5978,71.63802, 'Cameron'), -- 07:01:18
(@ENTRY, 35 , -9194.827, 227.36, 71.91199, 'Cameron'), -- 07:01:20
(@ENTRY, 36 ,-9187.375,241.8835,72.91473, 'Cameron'), -- 07:01:21
(@ENTRY, 37 ,-9184.045,254.7417,73.77821, 'Cameron'), -- 07:01:23
(@ENTRY, 38 ,-9182.289,274.1739,75.36765, 'Cameron'), -- 07:01:25
(@ENTRY, 39 ,-9181.092,289.6617,77.20319, 'Cameron'), -- 07:01:26
(@ENTRY, 40 ,-9180.633,300.7958,78.49542, 'Cameron'), -- 07:01:29
(@ENTRY, 41 ,-9178.008,326.7234,81.67275, 'Cameron'), -- 07:01:31
(@ENTRY, 42 ,-9174.055,336.8582,84.08626, 'Cameron'), -- 07:01:34
(@ENTRY, 43 ,-9163.633,351.4775,87.70863, 'Cameron'), -- 07:01:35
(@ENTRY, 44 ,-9153.682,362.516,90.23949, 'Cameron'), -- 07:01:37
(@ENTRY, 45 ,-9148.218,368.3586,90.66177, 'Cameron'), -- 07:01:40
(@ENTRY, 46 ,-9125.46,390.1248,91.81776, 'Cameron'), -- 07:01:43
(@ENTRY, 47 ,-9115.926,397.5776,92.71513, 'Cameron'), -- 07:01:45
(@ENTRY, 48 ,-9095.435,413.1418,92.21481, 'Cameron'), -- 07:01:46
(@ENTRY, 49 ,-9088.044,418.7169,92.44129, 'Cameron'), -- 07:01:49
(@ENTRY, 50 ,-9058.086,439.64,93.14257, 'Cameron'), -- 07:01:52
(@ENTRY, 51 ,-9045.07,450.092,93.28775, 'Cameron'), -- 07:01:54
(@ENTRY, 52 ,-9040.674,453.6961,93.05584, 'Cameron'),
(@ENTRY, 53 ,-9057.086,442.696,93.05582, 'Cameron'), -- 07:13:02
(@ENTRY, 54 ,-9074.805,431.4119,93.05582, 'Cameron'), -- 07:13:03
(@ENTRY, 55 ,-9077.455,426.727,92.54478, 'Cameron'), -- 07:13:05
(@ENTRY, 56 ,-9130.008,384.1526,91.08342, 'Cameron'), -- 07:13:11
(@ENTRY, 57 ,-9138.167,378.1005,90.83872, 'Cameron'), -- 07:13:14
(@ENTRY, 58 ,-9170.719,340.1506,85.00079, 'Cameron'), -- 07:13:17
(@ENTRY, 59 ,-9177.553,324.4485,81.63397, 'Cameron'), -- 07:13:22
(@ENTRY, 60 ,-9179.79,302.5313,78.90688, 'Cameron'), -- 07:13:24
(@ENTRY, 61 ,-9180.076,284.7124,76.62807, 'Cameron'), -- 07:13:26
(@ENTRY, 62 ,-9180.527,273.4619,75.51992, 'Cameron'), -- 07:13:29
(@ENTRY, 63 ,-9181.712,261.4136,74.55137, 'Cameron'), -- 07:13:30
(@ENTRY, 64 ,-9187.871,242.3035,72.95731, 'Cameron'), -- 07:13:32
(@ENTRY, 65 ,-9199.146,222.4604,71.7192, 'Cameron'), -- 07:13:35
(@ENTRY, 66 ,-9217.201,203.2024,69.32413, 'Cameron'), -- 07:13:37
(@ENTRY, 67 ,-9230.155,189.5526,68.19696, 'Cameron'), -- 07:13:41
(@ENTRY, 68 ,-9241.491,176.5851,67.95673, 'Cameron'), -- 07:13:45
(@ENTRY, 69 ,-9263.844,156.9561,67.57113, 'Cameron'), -- 07:13:46
(@ENTRY, 70 ,-9267.183,155.5535,67.38669, 'Cameron'), -- 07:13:48
(@ENTRY, 71 ,-9276.685,152.7653,67.1469, 'Cameron'), -- 07:13:50
(@ENTRY, 72 ,-9299.891,144.6541,66.28534, 'Cameron'), -- 07:13:52
(@ENTRY, 73 ,-9319.277,135.1606,65.03548, 'Cameron'), -- 07:13:53
(@ENTRY, 74 ,-9332.896,126.1193,63.87636, 'Cameron'), -- 07:13:57
(@ENTRY, 75 ,-9352.381,116.5327,62.6504, 'Cameron'), -- 07:13:58
(@ENTRY, 76 ,-9372.848,108.2433,60.93748, 'Cameron'), -- 07:14:02
(@ENTRY, 77 ,-9390.894,102.341,59.62895, 'Cameron'), -- 07:14:04
(@ENTRY, 78 ,-9395.941,100.5215,59.13963, 'Cameron'), -- 07:14:07
(@ENTRY, 79 ,-9409.482,92.83659,58.09391, 'Cameron'), -- 07:14:08
(@ENTRY, 80 ,-9417.838,86.17823,57.23439, 'Cameron'), -- 07:14:09
(@ENTRY, 81 ,-9433.703,74.28316,56.51966, 'Cameron'), -- 07:14:10
(@ENTRY, 82 ,-9435.221,73.19769,56.34148, 'Cameron'), -- 07:14:13
(@ENTRY, 83 ,-9448.541,67.65511,56.51829, 'Cameron'), -- 07:14:14
(@ENTRY, 84 ,-9460.035,63.37641,55.895, 'Cameron'),
(@ENTRY, 85 ,-9445.364,58.4987,55.97727, 'Cameron'), -- 07:31:27
(@ENTRY, 86 ,-9445.032,58.55785,56.2136, 'Cameron'), -- 07:31:28
(@ENTRY, 87 ,-9427.596,41.84236,57.21891, 'Cameron'), -- 07:31:30
(@ENTRY, 88 ,-9410.779,22.67539,58.65345, 'Cameron'), -- 07:31:32
(@ENTRY, 89 ,-9391.792,0.02795124,60.67725, 'Cameron'), -- 07:31:34
(@ENTRY, 90 ,-9377.568,-14.63209,62.37714, 'Cameron'), -- 07:31:38
(@ENTRY, 91 ,-9363.139,-29.04746,63.92186, 'Cameron'), -- 07:31:41
(@ENTRY, 92 ,-9348.428,-41.40288,65.24854, 'Cameron'), -- 07:31:43
(@ENTRY, 93 ,-9333.074,-51.61682,66.22433, 'Cameron'), -- 07:31:46
(@ENTRY, 94 ,-9324.543,-55.41918,66.51912, 'Cameron'), -- 07:31:49
(@ENTRY, 95 ,-9306.514,-57.01295,66.98401, 'Cameron'), -- 07:31:51
(@ENTRY, 96 ,-9288.65,-65.67791,67.9245, 'Cameron'), -- 07:31:53
(@ENTRY, 97 ,-9266.111,-81.1689,69.09925, 'Cameron'), -- 07:31:55
(@ENTRY, 98 ,-9246.279,-94.43002,70.69906, 'Cameron'), -- 07:31:57
(@ENTRY, 99 ,-9241.527,-97.61461,70.86122, 'Cameron'), -- 07:32:01
(@ENTRY, 100,-9228.587,-103.1802,71.24693, 'Cameron'), -- 07:32:02
(@ENTRY, 101,-9202.936,-110.5503,71.32005, 'Cameron'), -- 07:32:06
(@ENTRY, 102,-9189.19,-111.8865,71.32235, 'Cameron'), -- 07:32:07
(@ENTRY, 103,-9164.87,-117.8934,73.10243, 'Cameron'), -- 07:32:10
(@ENTRY, 104,-9164.276,-118.5964,73.10841, 'Cameron'), -- 07:32:11
(@ENTRY, 105,-9157.389,-130.045,74.83447, 'Cameron'), -- 07:32:12
(@ENTRY, 106,-9155.88,-137.6466,74.73592, 'Cameron');

SET @ENTRY := 80501;
DELETE FROM waypoints WHERE entry=@ENTRY;
INSERT INTO waypoints (entry, pointid, position_x, position_y, position_z, point_comment) VALUES
(@ENTRY, 1 ,-9158.411,-126.9952,74.33096, 'Cameron'), -- 07:38:14
(@ENTRY, 2 ,-9161.936,-122.2632,73.48005, 'Cameron'), -- 07:38:18
(@ENTRY, 3 ,-9171.188,-116.403,72.13133, 'Cameron'), -- 07:38:23
(@ENTRY, 4 ,-9175.792,-115.2302,71.66595, 'Cameron'), -- 07:38:26
(@ENTRY, 5 ,-9188.126,-113.6762,71.1235, 'Cameron'), -- 07:38:31
(@ENTRY, 6 ,-9198.314,-111.6536,71.19713, 'Cameron'), -- 07:38:36
(@ENTRY, 7 ,-9212.777,-108.1362,71.49892, 'Cameron'), -- 07:38:41
(@ENTRY, 8 ,-9221.962,-106.0956,71.29646, 'Cameron'), -- 07:38:46
(@ENTRY, 9 ,-9238.102,-98.25057,71.02353, 'Cameron'), -- 07:38:52
(@ENTRY, 10,-9255.748,-87.4807,70.21791, 'Cameron'), -- 07:38:55
(@ENTRY, 11,-9262.821,-82.41038,69.39944, 'Cameron'), -- 07:39:01
(@ENTRY, 12,-9267.083,-79.06253,68.88945, 'Cameron'), -- 07:39:06
(@ENTRY, 13,-9277.369,-71.58946,68.45795, 'Cameron'), -- 07:39:11
(@ENTRY, 14,-9294.043,-62.51098,67.73149, 'Cameron'), -- 07:39:15
(@ENTRY, 15,-9296.369,-61.36803,67.39666, 'Cameron'), -- 07:39:20
(@ENTRY, 16,-9306.391,-58.70887,67.12717, 'Cameron'), -- 07:39:23
(@ENTRY, 17,-9314.822,-57.41774,66.82509, 'Cameron'), -- 07:39:27
(@ENTRY, 18,-9336.649,-53.8809,66.1555, 'Cameron'), -- 07:39:31
(@ENTRY, 19,-9337.359,-53.52038,65.92425, 'Cameron'), -- 07:39:37
(@ENTRY, 20,-9350.479,-55.02436,66.34923, 'Cameron'), -- 07:39:40
(@ENTRY, 21,-9351.158,-55.39683,66.35679, 'Cameron'), -- 07:39:43
(@ENTRY, 22,-9359.373,-69.76035,64.45229, 'Cameron'), -- 07:39:44
(@ENTRY, 23,-9360.618,-71.72406,64.24545, 'Cameron'), -- 07:39:50
(@ENTRY, 24,-9366.256,-80.96321,64.52115, 'Cameron'), -- 07:39:54
(@ENTRY, 25,-9364.25,-85.4796,65.50365, 'Cameron'), -- 07:39:56
(@ENTRY, 26,-9354.806,-87.93577,65.47449, 'Cameron'); -- 07:40:01

-- Lisa waypoints
DELETE FROM waypoints WHERE entry=807;
INSERT INTO waypoints (entry, pointid, position_x, position_y, position_z, point_comment) VALUES
(807, 1,-9154.618,-134.9246,75.17611, 'Lisa'), -- 07:32:15
(807, 2,-9155.719,-132.458,75.17039, 'Lisa'), -- 07:32:15
(807, 3,-9340.689,-89.09771,66.49249, 'Lisa'), -- 07:32:27
(807, 4,-9353.076,-86.58789,65.68958, 'Lisa'); -- 07:33:47 Random movement

-- Cameron SAI
SET @ENTRY := 805;
UPDATE creature_template SET AIName="SmartAI" WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE entryorguid=@ENTRY AND source_type=0;
INSERT INTO smart_scripts (entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(@ENTRY,0,0,0,25,0,100,512,0,0,0,0,53,1,@ENTRY100+00,0,0,0,0,1,0,0,0,0,0,0,0,"Cameron - On Reset - Start Waypoint"),
(@ENTRY,0,1,0,40,0,100,512,51,@ENTRY100+00,0,0,54,2000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Cameron - On Waypoint 51 Reached - Pause Waypoint"),
(@ENTRY,0,2,0,40,0,100,512,83,@ENTRY100+00,0,0,54,2000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Cameron - On Waypoint 83 Reached - Pause Waypoint"),
(@ENTRY,0,4,0,40,0,100,512,105,@ENTRY100+00,0,0,80,@ENTRY100+00,2,0,0,0,0,1,0,0,0,0,0,0,0,"Cameron - On Waypoint 105 Reached - Run Script"),
(@ENTRY,0,5,0,58,0,100,0,25,@ENTRY100+01,0,0,69,26,0,0,0,0,0,8,0,0,0,-9354.81,-87.9358,65.4745,5.20108,"Cameron - On Waypoint Finished - Move To Position"),
(@ENTRY,0,6,0,58,0,100,0,25,@ENTRY100+01,0,0,45,1,1,0,0,0,0,9,807,0,10,0,0,0,0,"Cameron - On Waypoint Finished - Set Data 1 1"),
(@ENTRY,0,7,0,58,0,100,0,25,@ENTRY100+01,0,0,45,1,1,0,0,0,0,9,810,0,10,0,0,0,0,"Cameron - On Waypoint Finished - Set Data 1 1"),
(@ENTRY,0,8,0,58,0,100,0,25,@ENTRY100+01,0,0,45,1,1,0,0,0,0,9,811,0,10,0,0,0,0,"Cameron - On Waypoint Finished - Set Data 1 1"),
(@ENTRY,0,9,0,58,0,100,0,25,@ENTRY100+01,0,0,45,1,1,0,0,0,0,9,804,0,10,0,0,0,0,"Cameron - On Waypoint Finished - Set Data 1 1"),
(@ENTRY,0,10,0,58,0,100,0,25,@ENTRY100+01,0,0,45,1,1,0,0,0,0,9,804,0,10,0,0,0,0,"Cameron - On Waypoint Finished - Set Data 1 1"),
(@ENTRY,0,11,0,58,0,100,0,25,@ENTRY100+01,0,0,45,1,1,0,0,0,0,9,806,0,10,0,0,0,0,"Cameron - On Waypoint Finished - Set Data 1 1");

-- Actionlist SAI
SET @ENTRY := 805;
DELETE FROM smart_scripts WHERE entryorguid=@ENTRY AND source_type=9;
INSERT INTO smart_scripts (entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(@ENTRY,9,1,0,0,0,100,0,2000,2000,0,0,45,2,1,0,0,0,0,9,807,0,10,0,0,0,0,"On Script - Set Data 2 1"),
(@ENTRY,9,2,0,0,0,100,0,2000,2000,0,0,55,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Stop Waypoint"),
(@ENTRY,9,3,0,0,0,100,0,100000,100000,0,0,53,0,@ENTRY*100+01,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Start Waypoint");

-- Lisa SAI
SET @ENTRY := 807;
UPDATE creature_template SET AIName="SmartAI" WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE entryorguid=@ENTRY AND source_type=0;
INSERT INTO smart_scripts (entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(@ENTRY,0,0,0,38,0,100,0,1,1,0,0,69,5,0,0,0,0,0,8,0,0,0,-9350.654,-90.29861,65.16615,3.141593,"Lisa - On Data Set 1 1 - Move To Position"),
(@ENTRY,0,1,0,38,0,100,0,2,1,0,0,53,1,807,0,0,0,0,1,0,0,0,0,0,0,0,"Lisa - On Data Set 2 1 - Start Waypoint");

-- Aaron SAI
SET @ENTRY := 810;
UPDATE creature_template SET AIName="SmartAI" WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE entryorguid=@ENTRY AND source_type=0;
INSERT INTO smart_scripts (entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(@ENTRY,0,0,0,38,0,100,0,1,1,0,0,69,1,0,0,0,0,0,8,0,0,0,-9354.359,-91.97743,64.86536,1.117011,"Aaron - On Data Set 1 1 - Move To Position");

-- Jose SAI
SET @ENTRY := 811;
UPDATE creature_template SET AIName="SmartAI" WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE entryorguid=@ENTRY AND source_type=0;
INSERT INTO smart_scripts (entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(@ENTRY,0,0,0,38,0,100,0,1,1,0,0,69,1,0,0,0,0,0,8,0,0,0,-9356.938,-91.69791,64.93226,0.296706,"Jose - On Data Set 1 1 - Move To Position");

-- Dana SAI
SET @ENTRY := 804;
UPDATE creature_template SET AIName="SmartAI" WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE entryorguid=@ENTRY AND source_type=0;
INSERT INTO smart_scripts (entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(@ENTRY,0,0,0,38,0,100,0,1,1,0,0,69,1,0,0,0,0,0,8,0,0,0,-9353.279,-89.96702,65.20618,4.206244,"Dana - On Data Set 1 1 - Move To Position");

-- John SAI
SET @ENTRY := 806;
UPDATE creature_template SET AIName="SmartAI" WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE entryorguid=@ENTRY AND source_type=0;
INSERT INTO smart_scripts (entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(@ENTRY,0,0,0,38,0,100,0,1,1,0,0,69,1,0,0,0,0,0,8,0,0,0,-9352.859,-93.96007,64.3888,1.937315,"John - On Data Set 1 1 - Move To Position");

UPDATE creature SET spawndist=5, MovementType=1 WHERE guid=80321;
UPDATE creature SET spawndist=5, MovementType=1 WHERE guid=80317;

Kittnz picture Kittnz on 11 Feb 2017

@Kittnz , can we do random movement with WP_PAUSE?
Something like this

(805,0, 0,1, 40, 0,100,0, $, 805,0,0,  54, 30000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cameron - On Reached WP$ - Pause WP'),
(805,0, 1,2, 61, 0,100,0, 0,   0,0,0, 101,     0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cameron - On Reached WP$ - Set Home pos'),
(805,0, 2,0, 61, 0,100,0, 0,   0,0,0,  89,     6,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cameron - On Reached WP$ - Random mov'),
Eliminationzx picture Eliminationzx on 11 Feb 2017

yeah ofc you can @Eliminationzx add that.

Kittnz picture Kittnz on 13 Feb 2017

Don't add random movement while the creature has wp movement paused, it will cause runtime errors.

You need to remove the whole movement, set random movement and then after a few seconds remove the whole movement again and load a new path.

Rushor picture Rushor on 13 Feb 2017

see https://github.com/TrinityCore/TrinityCore/pull/18891/files for more infos

Rushor picture Rushor on 13 Feb 2017

any news?

Eliminationzx picture Eliminationzx on 18 Feb 2017

Well if you don't work on it, it won't happen :)

Kittnz picture Kittnz on 18 Feb 2017

we could need a way to pause waypoint movement, start rndmmovement and after few seconds initalise the rest of the waypointmovement (similar to the way currentwaypoint from creature table works)

Rushor picture Rushor on 18 Feb 2017

maybe we need an new action

Kittnz picture Kittnz on 18 Feb 2017
👍1

any news?

Eliminationzx picture Eliminationzx on 27 Sep 2017

I'll look into it again in a few days and complete it

Kittnz picture Kittnz on 27 Sep 2017
❤1 👍1

should be closed?
https://github.com/TrinityCore/TrinityCore/commit/a9c853ee3fc13d1aa59bde14df8f1f0a5b035ff3

Jildor picture Jildor on 16 Jan 2018
👍1
Was this page helpful?
0 / 5 - 0 ratings

Related issues

Teppic1 picture Teppic1  路  3Comments
jerbookins picture jerbookins  路  3Comments
Tatara902 picture Tatara902  路  3Comments
funjoker picture funjoker  路  3Comments
Lopfest picture Lopfest  路  3Comments