Trinitycore: [NPC] Avian Flyer - Missing waypoints
Description:
http://wotlk.openwow.com/npc=21931 is not spawned and has no waypoints
Current behaviour: (Tell us what happens.)
http://wotlk.openwow.com/npc=21931 is not spawned and has no waypoints
Expected behaviour: (Tell us what should happen instead.)
http://wotlk.openwow.com/npc=21931 should be spawned and have waypoints
Branch(es): 3.3.5 / master (Tell us which branch(es) this issue affects.)
3.3.5
TC rev. hash/commit: https://github.com/TrinityCore/TrinityCore/commit/3d5c1b83b15cfc9f73888eb525c64323266c1fd4
TDB version: TDB_full_world_335.62_2016_10_17 + updates
Operating system: Win10
Fix:
Thanks for the data @Grz3s
UPDATE `creature` SET `position_x`=1032.46, `position_y`=1479.80, `position_z`=37.48 WHERE id=1766 AND FLOOR(position_x)=1029 AND FLOOR(position_y)=1474 AND FLOOR(position_z)=36; -- GUID 17952
-- Paths for Birds in Sethekk Halls
-- Adjust inhabittype to fly
UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry` IN (21931,21988);
SET @GUID := XXXXXXXXXX; -- 15 unused GUIDs from TC
DELETE FROM `creature` WHERE `guid` BETWEEN @GUID AND @GUID+14;
INSERT INTO `creature` (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, spawntimesecs, curhealth, curmana, spawndist, MovementType) VALUES
(@GUID, 21931, 556, 3, 1, -69.078, 255.062, 27.6692, 2.23169, 1, 6326, 0, 0, 2),
(@GUID+1, 21931, 556, 3, 1, 84.91618,251.3969,37.0668, 3.204143, 1, 6326, 0, 0, 2),
(@GUID+2, 21931, 556, 3, 1, 82.7928, 251.0653, 37.0668, 3.192098, 1, 6326, 0, 0, 2),
(@GUID+3, 21931, 556, 3, 1, -55.35431, 292.4135, 27.84376, 3.334406, 1, 6326, 0, 0, 2),
(@GUID+4, 21931, 556, 3, 1, -56.81138, 293.4768, 27.82975, 1.066901, 1, 6326, 0, 0, 2),
(@GUID+5, 21931, 556, 3, 1, -109.229, 288.209, 53.3584, 3.249347, 1, 6326, 0, 0, 2),
(@GUID+6, 21931, 556, 3, 1, -77.7733, 299.15, 60.5558, 5.757163, 1, 6326, 0, 0, 2),
(@GUID+7, 21931, 556, 3, 1, -52.39689, 293.2879, 27.82958, 1.420948, 1, 6326, 0, 0, 2),
(@GUID+8, 21931, 556, 3, 1, -65.26201, 281.413, 47.28283, 0.8305511, 1, 6326, 0, 0, 2),
(@GUID+9, 21931, 556, 3, 1, -59.42, 289.0999, 27.89292, 2.894336, 1, 6326, 0, 0, 2),
(@GUID+10, 21931, 556, 3, 1, -102.279, 278.86, 56.0703, 5.414571, 1, 6326, 0, 0, 2),
(@GUID+11, 21931, 556, 3, 1, -86.60637, 286.1224, 27.48317, 2.953945, 1, 6326, 0, 0, 2),
(@GUID+12, 21931, 556, 3, 1, -68.3353, 281.741, 61.757, 3.844181, 1, 6326, 0, 0, 2),
(@GUID+13, 21931, 556, 3, 1, -71.9701, 272.574, 59.1446, 6.184331, 1, 6326, 0, 0, 2),
(@GUID+14, 21931, 556, 3, 1, -84.35631, 263.7281, 27.80793, 4.523829, 1, 6326, 0, 0, 2);
-- 1.
SET @NPC := @GUID;
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`) VALUES
(@PATH, 1, -69.078, 255.062, 27.6692),
(@PATH, 2, -69.078, 255.062, 27.6692),
(@PATH, 3, -77.6467, 256.825, 27.8182),
(@PATH, 4, -85.5541, 263.248, 37.4314),
(@PATH, 5, -89.3701, 273.449, 46.1637),
(@PATH, 6, -87.3918, 283.626, 55.5433),
(@PATH, 7, -81.6323, 288.392, 67.374),
(@PATH, 8, -83.6451, 281.803, 77.323),
(@PATH, 9, -97.3242, 280.983, 74.488),
(@PATH, 10, -95.2966, 294.303, 27.4832),
(@PATH, 11, -91.9066, 298.554, 40.3148),
(@PATH, 12, -84.9968, 296.969, 52.3776),
(@PATH, 13, -81.5458, 289.807, 63.8514),
(@PATH, 14, -91.5585, 284.275, 71.9894),
(@PATH, 15, -95.834, 292.943, 27.4832),
(@PATH, 16, -94.3393, 295.352, 41.1404),
(@PATH, 17, -88.5665, 292.19, 53.5047),
(@PATH, 18, -88.0789, 284.173, 65.0211),
(@PATH, 19, -96.7033, 282.247, 75.63),
(@PATH, 20, -92.1857, 296.241, 27.4832);
-- 2.
SET @NPC := @GUID+1;
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`) VALUES
(@PATH, 1, -84.3563, 263.728, 27.8079),
(@PATH, 2, -87.4666, 261.464, 58.4138),
(@PATH, 3, -94.4575, 270.352, 66.6585),
(@PATH, 4, -95.7386, 284.443, 27.4832),
(@PATH, 5, -91.3219, 290.488, 39.2894),
(@PATH, 6, -84.573, 290.53, 51.5467),
(@PATH, 7, -83.1581, 284.409, 64.0506),
(@PATH, 8, -92.9101, 280.978, 73.484),
(@PATH, 9, -96.079, 293.202, 74.566),
(@PATH, 10, -82.8515, 297.569, 74.9201),
(@PATH, 11, -77.4638, 284.989, 27.4832),
(@PATH, 12, -81.0183, 279.803, 39.9446),
(@PATH, 13, -89.1536, 280.506, 51.3678),
(@PATH, 14, -94.1382, 293.611, 27.4832),
(@PATH, 15, -88.9669, 297.982, 39.6762),
(@PATH, 16, -84.4414, 293.357, 52.098),
(@PATH, 17, -86.5034, 284.787, 63.0289),
(@PATH, 18, -97.8593, 278.945, 26.2094),
(@PATH, 19, -83.9472, 285.452, 63.0513),
(@PATH, 20, -93.4871, 275.608, 26.8408);
-- 3.
SET @NPC := @GUID+2;
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`) VALUES
(@PATH, 1, 84.9162, 251.397, 37.0668),
(@PATH, 2, 83.9651, 251.088, 37.0668),
(@PATH, 3, 51.4796, 252.183, 37.0668),
(@PATH, 4, 33.2474, 282.432, 37.0668),
(@PATH, 5, -4.58595, 288.248, 37.0668),
(@PATH, 6, -33.1252, 287.388, 33.6501),
(@PATH, 7, -63.6614, 287.145, 37.0668),
(@PATH, 8, -86.5805, 281.312, 37.0668),
(@PATH, 9, -122.867, 287.583, 33.7057),
(@PATH, 10, -166.135, 286.002, 37.0668),
(@PATH, 11, -197.129, 319.599, 41.5668),
(@PATH, 12, -226.722, 321.688, 41.5391),
(@PATH, 13, -241.978, 284.026, 37.0668),
(@PATH, 14, -241.867, 239.697, 34.7891),
(@PATH, 15, -240.409, 205.258, 33.289),
(@PATH, 16, -247.921, 181.826, 37.0668),
(@PATH, 17, -258.541, 176.818, 28.8724),
(@PATH, 18, -254.589, 187.929, 17.5946),
(@PATH, 19, -233.282, 183.525, 9.45569),
(@PATH, 20, -207.969, 174.104, 9.45569),
(@PATH, 21, -174.273, 173.592, 7.17792),
(@PATH, 22, -153.428, 164.087, 10.4835),
(@PATH, 23, -141.719, 162.854, 10.9835),
(@PATH, 24, -125.931, 171.58, 9.15015),
(@PATH, 25, -97.7346, 173.65, 7.15014),
(@PATH, 26, -82.8989, 173.921, 10.3168),
(@PATH, 27, -73.9182, 173.077, 10.3168),
(@PATH, 28, -69.9846, 163.459, 10.3168),
(@PATH, 29, -70.2812, 156.773, 9.34458),
(@PATH, 30, -71.1548, 128.592, 6.7057),
(@PATH, 31, -80.0383, 115.576, 7.51125),
(@PATH, 32, -82.5443, 99.0856, 7.51125),
(@PATH, 33, -74.7056, 88.5289, 7.51125),
(@PATH, 34, -60.1037, 87.1475, 7.51125),
(@PATH, 35, -43.8567, 99.2091, 7.03903),
(@PATH, 36, -21.4774, 99.8071, 7.26125),
(@PATH, 37, 7.50968, 100.248, 7.51125),
(@PATH, 38, 27.4025, 97.8097, 19.3168),
(@PATH, 39, 37.0373, 95.8226, 30.8446);
-- 4.
SET @NPC := @GUID+3;
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`) VALUES
(@PATH, 1, -119.16, 291.958, 26.7305),
(@PATH, 2, -119.16, 291.958, 26.7305),
(@PATH, 3, -118.246, 291.551, 26.7198),
(@PATH, 4, -116.125, 290.169, 41.5238),
(@PATH, 5, -114.528, 275.12, 40.1532),
(@PATH, 6, -90.689, 265.24, 41.0333),
(@PATH, 7, -62.0894, 286.098, 48.6939),
(@PATH, 8, -76.8407, 304.686, 51.9439),
(@PATH, 9, -98.7576, 303.572, 46.4161);
-- 5.
SET @NPC := @GUID+4;
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`) VALUES
(@PATH, 1, -56.8114, 293.477, 27.8298),
(@PATH, 2, -58.7468, 295.764, 29.4033),
(@PATH, 3, -80.8255, 317.109, 28.9557),
(@PATH, 4, -84.6018, 313.357, 62.0829),
(@PATH, 5, -100.485, 310.06, 60.6726),
(@PATH, 6, -119.643, 290.201, 57.4676),
(@PATH, 7, -119.602, 271.028, 61.3137),
(@PATH, 8, -99.3827, 260.039, 59.8997),
(@PATH, 9, -62.9444, 265.206, 63.3061),
(@PATH, 10, -53.9817, 286.896, 63.0482),
(@PATH, 11, -66.9341, 300.934, 58.5854),
(@PATH, 12, -82.0958, 309.241, 61.3414),
(@PATH, 13, -100.199, 310.19, 60.9001),
(@PATH, 14, -109.249, 296.2, 58.5368),
(@PATH, 15, -112.956, 287.824, 28.945),
(@PATH, 16, -131.244, 263.41, 30.9794),
(@PATH, 17, -124.562, 262.687, 57.9071),
(@PATH, 18, -89.1208, 261.935, 60.3001),
(@PATH, 19, -66.6449, 264.328, 64.3038),
(@PATH, 20, -56.4546, 270.201, 65.3866),
(@PATH, 21, -53.7442, 287.453, 64.0839),
(@PATH, 22, -56.4072, 293.549, 29.5758);
-- 6.
SET @NPC := @GUID+5;
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`) VALUES
(@PATH, 1, -59.42, 289.1, 27.8929),
(@PATH, 2, -58.7468, 295.764, 29.4033),
(@PATH, 3, -80.8255, 317.109, 28.9557),
(@PATH, 4, -84.6018, 313.357, 62.0829),
(@PATH, 5, -100.485, 310.06, 60.6726),
(@PATH, 6, -119.643, 290.201, 57.4676),
(@PATH, 7, -119.602, 271.028, 61.3137),
(@PATH, 8, -99.3827, 260.039, 59.8997),
(@PATH, 9, -62.9444, 265.206, 63.3061),
(@PATH, 10, -53.9817, 286.896, 63.0482),
(@PATH, 11, -66.9341, 300.934, 58.5854),
(@PATH, 12, -82.0958, 309.241, 61.3414),
(@PATH, 13, -100.199, 310.19, 60.9001),
(@PATH, 14, -109.249, 296.2, 58.5368),
(@PATH, 15, -112.956, 287.824, 28.945),
(@PATH, 16, -131.244, 263.41, 30.9794),
(@PATH, 17, -124.562, 262.687, 57.9071),
(@PATH, 18, -89.1208, 261.935, 60.3001),
(@PATH, 19, -66.6449, 264.328, 64.3038),
(@PATH, 20, -56.4546, 270.201, 65.3866),
(@PATH, 21, -53.7442, 287.453, 64.0839),
(@PATH, 22, -56.4072, 293.549, 29.5758);
-- 7.
SET @NPC := @GUID+6;
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`) VALUES
(@PATH, 1, -52.3969, 293.288, 27.8296),
(@PATH, 2, -58.7468, 295.764, 29.4033),
(@PATH, 3, -80.8255, 317.109, 28.9557),
(@PATH, 4, -84.6018, 313.357, 62.0829),
(@PATH, 5, -100.485, 310.06, 60.6726),
(@PATH, 6, -119.643, 290.201, 57.4676),
(@PATH, 7, -119.602, 271.028, 61.3137),
(@PATH, 8, -99.3827, 260.039, 59.8997),
(@PATH, 9, -62.9444, 265.206, 63.3061),
(@PATH, 10, -53.9817, 286.896, 63.0482),
(@PATH, 11, -66.9341, 300.934, 58.5854),
(@PATH, 12, -82.0958, 309.241, 61.3414),
(@PATH, 13, -100.199, 310.19, 60.9001),
(@PATH, 14, -109.249, 296.2, 58.5368),
(@PATH, 15, -112.956, 287.824, 28.945),
(@PATH, 16, -131.244, 263.41, 30.9794),
(@PATH, 17, -124.562, 262.687, 57.9071),
(@PATH, 18, -89.1208, 261.935, 60.3001),
(@PATH, 19, -66.6449, 264.328, 64.3038),
(@PATH, 20, -56.4546, 270.201, 65.3866),
(@PATH, 21, -53.7442, 287.453, 64.0839),
(@PATH, 22, -56.4072, 293.549, 29.5758);
-- 8.
SET @NPC := @GUID+7;
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`) VALUES
(@PATH, 1, -62.0894, 286.098, 48.6939),
(@PATH, 2, -76.8407, 304.686, 51.9439),
(@PATH, 3, -98.7576, 303.572, 46.4161),
(@PATH, 4, -119.16, 291.958, 26.7305),
(@PATH, 5, -119.16, 291.958, 26.7305),
(@PATH, 6, -118.246, 291.551, 26.7198),
(@PATH, 7, -116.125, 290.169, 41.5238),
(@PATH, 8, -114.528, 275.12, 40.1532),
(@PATH, 9, -90.689, 265.24, 41.0333);
-- 9.
SET @NPC := @GUID+8;
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`) VALUES
(@PATH, 1, -109.229, 288.209, 53.3584),
(@PATH, 2, -102.279, 278.86, 56.0703),
(@PATH, 3, -88.1313, 272.423, 59.4688),
(@PATH, 4, -71.9701, 272.574, 59.1446),
(@PATH, 5, -68.3353, 281.741, 61.757),
(@PATH, 6, -77.7733, 299.15, 60.5558),
(@PATH, 7, -94.7425, 300.49, 56.1018);
-- 10.
SET @NPC := @GUID+9;
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`) VALUES
(@PATH, 1, -71.9701, 272.574, 59.1446),
(@PATH, 2, -68.3353, 281.741, 61.757),
(@PATH, 3, -77.7733, 299.15, 60.5558),
(@PATH, 4, -94.7425, 300.49, 56.1018),
(@PATH, 5, -109.229, 288.209, 53.3584),
(@PATH, 6, -102.279, 278.86, 56.0703),
(@PATH, 7, -88.1313, 272.423, 59.4688);
-- 11.
SET @NPC := @GUID+10;
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`) VALUES
(@PATH, 1, -68.3353, 281.741, 61.757),
(@PATH, 2, -77.7733, 299.15, 60.5558),
(@PATH, 3, -94.7425, 300.49, 56.1018),
(@PATH, 4, -109.229, 288.209, 53.3584),
(@PATH, 5, -102.279, 278.86, 56.0703),
(@PATH, 6, -88.1313, 272.423, 59.4688),
(@PATH, 7, -71.9701, 272.574, 59.1446);
-- 12.
SET @NPC := @GUID+11;
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`) VALUES
(@PATH, 1, -102.279, 278.86, 56.0703),
(@PATH, 2, -88.1313, 272.423, 59.4688),
(@PATH, 3, -71.9701, 272.574, 59.1446),
(@PATH, 4, -68.3353, 281.741, 61.757),
(@PATH, 5, -77.7733, 299.15, 60.5558),
(@PATH, 6, -94.7425, 300.49, 56.1018),
(@PATH, 7, -109.229, 288.209, 53.3584);
-- 13.
SET @NPC := @GUID+12;
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`) VALUES
(@PATH, 1, -77.7733, 299.15, 60.5558),
(@PATH, 2, -94.7425, 300.49, 56.1018),
(@PATH, 3, -109.229, 288.209, 53.3584),
(@PATH, 4, -102.279, 278.86, 56.0703),
(@PATH, 5, -88.1313, 272.423, 59.4688),
(@PATH, 6, -71.9701, 272.574, 59.1446),
(@PATH, 7, -68.3353, 281.741, 61.757);
-- 14.
SET @NPC := @GUID+13;
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`) VALUES
(@PATH, 1, -86.6064, 286.122, 27.4832),
(@PATH, 2, -84.2669, 286.076, 57.4227),
(@PATH, 3, -71.9701, 272.574, 59.1446),
(@PATH, 4, -68.3353, 281.741, 61.757),
(@PATH, 5, -77.7733, 299.15, 60.5558),
(@PATH, 6, -94.7425, 300.49, 56.1018),
(@PATH, 7, -109.229, 288.209, 53.3584),
(@PATH, 8, -102.279, 278.86, 56.0703),
(@PATH, 9, -88.1313, 272.423, 59.4688);
-- 14.
SET @NPC := @GUID+14;
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`) VALUES
(@PATH, 1, 84.9162, 251.397, 37.0668),
(@PATH, 2, 83.9651, 251.088, 37.0668),
(@PATH, 3, 51.4796, 252.183, 37.0668),
(@PATH, 4, 33.2474, 282.432, 37.0668),
(@PATH, 5, -4.58595, 288.248, 37.0668),
(@PATH, 6, -33.1252, 287.388, 33.6501),
(@PATH, 7, -63.6614, 287.145, 37.0668),
(@PATH, 8, -77.5616, 286.325, 98.1903);
UPDATE `waypoint_data` SET `move_type`=1 WHERE `id` BETWEEN (@GUID+0)*10 AND (@GUID+14)*10;
Rushor
❤3
All 7 comments
insert: wow awesome gif usage
Rushor
on 9 Dec 2016
🎉2
❤1
Despawnscript ? @Rushor
Kittnz
on 9 Dec 2016
removed the despawnscript, it was actually not needed on tc core :)
Rushor
on 10 Dec 2016
how not love this visual stuffs? xd
Keader
on 10 Dec 2016
If I may suggest a minor improvement, gathering all the creature_addon lines in 1 query + some spacing:
(9 lines shorter, even with the added spacing)
-- Birds in Sethekk Halls - spawns and paths
UPDATE `creature` SET `position_x`=1032.46, `position_y`=1479.80, `position_z`=37.48 WHERE `id`= 1766 AND FLOOR(position_x)=1029 AND FLOOR(position_y)=1474 AND FLOOR(position_z)=36; -- GUID 17952
-- Set InhabitType to flying
UPDATE `creature_template` SET `InhabitType`= 4 WHERE `entry` IN (21931,21988);
SET @GUID := 99126; -- 15 unused GUIDs from TC
DELETE FROM `creature` WHERE `guid` BETWEEN @GUID AND @GUID+14;
INSERT INTO `creature` (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, spawntimesecs, curhealth, curmana, spawndist, MovementType) VALUES
(@GUID+0, 21931, 556, 3, 1, -69.078, 255.062, 27.6692, 2.23169, 1, 6326, 0, 0, 2),
(@GUID+1, 21931, 556, 3, 1, 84.91618, 251.3969, 37.0668, 3.204143, 1, 6326, 0, 0, 2),
(@GUID+2, 21931, 556, 3, 1, 82.7928, 251.0653, 37.0668, 3.192098, 1, 6326, 0, 0, 2),
(@GUID+3, 21931, 556, 3, 1, -55.35431, 292.4135, 27.84376, 3.334406, 1, 6326, 0, 0, 2),
(@GUID+4, 21931, 556, 3, 1, -56.81138, 293.4768, 27.82975, 1.066901, 1, 6326, 0, 0, 2),
(@GUID+5, 21931, 556, 3, 1, -109.229, 288.209, 53.3584, 3.249347, 1, 6326, 0, 0, 2),
(@GUID+6, 21931, 556, 3, 1, -77.7733, 299.15, 60.5558, 5.757163, 1, 6326, 0, 0, 2),
(@GUID+7, 21931, 556, 3, 1, -52.39689, 293.2879, 27.82958, 1.420948, 1, 6326, 0, 0, 2),
(@GUID+8, 21931, 556, 3, 1, -65.26201, 281.413, 47.28283, 0.8305511, 1, 6326, 0, 0, 2),
(@GUID+9, 21931, 556, 3, 1, -59.42, 289.0999, 27.89292, 2.894336, 1, 6326, 0, 0, 2),
(@GUID+10, 21931, 556, 3, 1, -102.279, 278.86, 56.0703, 5.414571, 1, 6326, 0, 0, 2),
(@GUID+11, 21931, 556, 3, 1, -86.60637, 286.1224, 27.48317, 2.953945, 1, 6326, 0, 0, 2),
(@GUID+12, 21931, 556, 3, 1, -68.3353, 281.741, 61.757, 3.844181, 1, 6326, 0, 0, 2),
(@GUID+13, 21931, 556, 3, 1, -71.9701, 272.574, 59.1446, 6.184331, 1, 6326, 0, 0, 2),
(@GUID+14, 21931, 556, 3, 1, -84.35631, 263.7281, 27.80793, 4.523829, 1, 6326, 0, 0, 2);
DELETE FROM `creature_addon` WHERE `guid` BETWEEN @GUID AND @GUID+14;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES
(@GUID+0, @GUID+0 *10, 0, 0, 1, 0, ''),
(@GUID+1, @GUID+1 *10, 0, 0, 1, 0, ''),
(@GUID+2, @GUID+2 *10, 0, 0, 1, 0, ''),
(@GUID+3, @GUID+3 *10, 0, 0, 1, 0, ''),
(@GUID+4, @GUID+4 *10, 0, 0, 1, 0, ''),
(@GUID+5, @GUID+5 *10, 0, 0, 1, 0, ''),
(@GUID+6, @GUID+6 *10, 0, 0, 1, 0, ''),
(@GUID+7, @GUID+7 *10, 0, 0, 1, 0, ''),
(@GUID+8, @GUID+8 *10, 0, 0, 1, 0, ''),
(@GUID+9, @GUID+9 *10, 0, 0, 1, 0, ''),
(@GUID+10, @GUID+10*10, 0, 0, 1, 0, ''),
(@GUID+11, @GUID+11*10, 0, 0, 1, 0, ''),
(@GUID+12, @GUID+12*10, 0, 0, 1, 0, ''),
(@GUID+13, @GUID+13*10, 0, 0, 1, 0, ''),
(@GUID+14, @GUID+14*10, 0, 0, 1, 0, '');
-- 1.
SET @PATH := @GUID+0 * 10;
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
(@PATH, 1, -69.078, 255.062, 27.6692),
(@PATH, 2, -69.078, 255.062, 27.6692),
(@PATH, 3, -77.6467, 256.825, 27.8182),
(@PATH, 4, -85.5541, 263.248, 37.4314),
(@PATH, 5, -89.3701, 273.449, 46.1637),
(@PATH, 6, -87.3918, 283.626, 55.5433),
(@PATH, 7, -81.6323, 288.392, 67.374),
(@PATH, 8, -83.6451, 281.803, 77.323),
(@PATH, 9, -97.3242, 280.983, 74.488),
(@PATH, 10, -95.2966, 294.303, 27.4832),
(@PATH, 11, -91.9066, 298.554, 40.3148),
(@PATH, 12, -84.9968, 296.969, 52.3776),
(@PATH, 13, -81.5458, 289.807, 63.8514),
(@PATH, 14, -91.5585, 284.275, 71.9894),
(@PATH, 15, -95.834, 292.943, 27.4832),
(@PATH, 16, -94.3393, 295.352, 41.1404),
(@PATH, 17, -88.5665, 292.19, 53.5047),
(@PATH, 18, -88.0789, 284.173, 65.0211),
(@PATH, 19, -96.7033, 282.247, 75.63),
(@PATH, 20, -92.1857, 296.241, 27.4832);
-- 2.
SET @PATH := @GUID+1 * 10;
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
(@PATH, 1, -84.3563, 263.728, 27.8079),
(@PATH, 2, -87.4666, 261.464, 58.4138),
(@PATH, 3, -94.4575, 270.352, 66.6585),
(@PATH, 4, -95.7386, 284.443, 27.4832),
(@PATH, 5, -91.3219, 290.488, 39.2894),
(@PATH, 6, -84.573, 290.53, 51.5467),
(@PATH, 7, -83.1581, 284.409, 64.0506),
(@PATH, 8, -92.9101, 280.978, 73.484),
(@PATH, 9, -96.079, 293.202, 74.566),
(@PATH, 10, -82.8515, 297.569, 74.9201),
(@PATH, 11, -77.4638, 284.989, 27.4832),
(@PATH, 12, -81.0183, 279.803, 39.9446),
(@PATH, 13, -89.1536, 280.506, 51.3678),
(@PATH, 14, -94.1382, 293.611, 27.4832),
(@PATH, 15, -88.9669, 297.982, 39.6762),
(@PATH, 16, -84.4414, 293.357, 52.098),
(@PATH, 17, -86.5034, 284.787, 63.0289),
(@PATH, 18, -97.8593, 278.945, 26.2094),
(@PATH, 19, -83.9472, 285.452, 63.0513),
(@PATH, 20, -93.4871, 275.608, 26.8408);
-- 3.
SET @PATH := @GUID+2 * 10;
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
(@PATH, 1, 84.9162, 251.397, 37.0668),
(@PATH, 2, 83.9651, 251.088, 37.0668),
(@PATH, 3, 51.4796, 252.183, 37.0668),
(@PATH, 4, 33.2474, 282.432, 37.0668),
(@PATH, 5, -4.58595, 288.248, 37.0668),
(@PATH, 6, -33.1252, 287.388, 33.6501),
(@PATH, 7, -63.6614, 287.145, 37.0668),
(@PATH, 8, -86.5805, 281.312, 37.0668),
(@PATH, 9, -122.867, 287.583, 33.7057),
(@PATH, 10, -166.135, 286.002, 37.0668),
(@PATH, 11, -197.129, 319.599, 41.5668),
(@PATH, 12, -226.722, 321.688, 41.5391),
(@PATH, 13, -241.978, 284.026, 37.0668),
(@PATH, 14, -241.867, 239.697, 34.7891),
(@PATH, 15, -240.409, 205.258, 33.289),
(@PATH, 16, -247.921, 181.826, 37.0668),
(@PATH, 17, -258.541, 176.818, 28.8724),
(@PATH, 18, -254.589, 187.929, 17.5946),
(@PATH, 19, -233.282, 183.525, 9.45569),
(@PATH, 20, -207.969, 174.104, 9.45569),
(@PATH, 21, -174.273, 173.592, 7.17792),
(@PATH, 22, -153.428, 164.087, 10.4835),
(@PATH, 23, -141.719, 162.854, 10.9835),
(@PATH, 24, -125.931, 171.58, 9.15015),
(@PATH, 25, -97.7346, 173.65, 7.15014),
(@PATH, 26, -82.8989, 173.921, 10.3168),
(@PATH, 27, -73.9182, 173.077, 10.3168),
(@PATH, 28, -69.9846, 163.459, 10.3168),
(@PATH, 29, -70.2812, 156.773, 9.34458),
(@PATH, 30, -71.1548, 128.592, 6.7057),
(@PATH, 31, -80.0383, 115.576, 7.51125),
(@PATH, 32, -82.5443, 99.0856, 7.51125),
(@PATH, 33, -74.7056, 88.5289, 7.51125),
(@PATH, 34, -60.1037, 87.1475, 7.51125),
(@PATH, 35, -43.8567, 99.2091, 7.03903),
(@PATH, 36, -21.4774, 99.8071, 7.26125),
(@PATH, 37, 7.50968, 100.248, 7.51125),
(@PATH, 38, 27.4025, 97.8097, 19.3168),
(@PATH, 39, 37.0373, 95.8226, 30.8446);
-- 4.
SET @PATH := @GUID+3 * 10;
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
(@PATH, 1, -119.16, 291.958, 26.7305),
(@PATH, 2, -119.16, 291.958, 26.7305),
(@PATH, 3, -118.246, 291.551, 26.7198),
(@PATH, 4, -116.125, 290.169, 41.5238),
(@PATH, 5, -114.528, 275.12, 40.1532),
(@PATH, 6, -90.689, 265.24, 41.0333),
(@PATH, 7, -62.0894, 286.098, 48.6939),
(@PATH, 8, -76.8407, 304.686, 51.9439),
(@PATH, 9, -98.7576, 303.572, 46.4161);
-- 5.
SET @PATH := @GUID+4 * 10;
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
(@PATH, 1, -56.8114, 293.477, 27.8298),
(@PATH, 2, -58.7468, 295.764, 29.4033),
(@PATH, 3, -80.8255, 317.109, 28.9557),
(@PATH, 4, -84.6018, 313.357, 62.0829),
(@PATH, 5, -100.485, 310.06, 60.6726),
(@PATH, 6, -119.643, 290.201, 57.4676),
(@PATH, 7, -119.602, 271.028, 61.3137),
(@PATH, 8, -99.3827, 260.039, 59.8997),
(@PATH, 9, -62.9444, 265.206, 63.3061),
(@PATH, 10, -53.9817, 286.896, 63.0482),
(@PATH, 11, -66.9341, 300.934, 58.5854),
(@PATH, 12, -82.0958, 309.241, 61.3414),
(@PATH, 13, -100.199, 310.19, 60.9001),
(@PATH, 14, -109.249, 296.2, 58.5368),
(@PATH, 15, -112.956, 287.824, 28.945),
(@PATH, 16, -131.244, 263.41, 30.9794),
(@PATH, 17, -124.562, 262.687, 57.9071),
(@PATH, 18, -89.1208, 261.935, 60.3001),
(@PATH, 19, -66.6449, 264.328, 64.3038),
(@PATH, 20, -56.4546, 270.201, 65.3866),
(@PATH, 21, -53.7442, 287.453, 64.0839),
(@PATH, 22, -56.4072, 293.549, 29.5758);
-- 6.
SET @PATH := @GUID+5 * 10;
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
(@PATH, 1, -59.42, 289.1, 27.8929),
(@PATH, 2, -58.7468, 295.764, 29.4033),
(@PATH, 3, -80.8255, 317.109, 28.9557),
(@PATH, 4, -84.6018, 313.357, 62.0829),
(@PATH, 5, -100.485, 310.06, 60.6726),
(@PATH, 6, -119.643, 290.201, 57.4676),
(@PATH, 7, -119.602, 271.028, 61.3137),
(@PATH, 8, -99.3827, 260.039, 59.8997),
(@PATH, 9, -62.9444, 265.206, 63.3061),
(@PATH, 10, -53.9817, 286.896, 63.0482),
(@PATH, 11, -66.9341, 300.934, 58.5854),
(@PATH, 12, -82.0958, 309.241, 61.3414),
(@PATH, 13, -100.199, 310.19, 60.9001),
(@PATH, 14, -109.249, 296.2, 58.5368),
(@PATH, 15, -112.956, 287.824, 28.945),
(@PATH, 16, -131.244, 263.41, 30.9794),
(@PATH, 17, -124.562, 262.687, 57.9071),
(@PATH, 18, -89.1208, 261.935, 60.3001),
(@PATH, 19, -66.6449, 264.328, 64.3038),
(@PATH, 20, -56.4546, 270.201, 65.3866),
(@PATH, 21, -53.7442, 287.453, 64.0839),
(@PATH, 22, -56.4072, 293.549, 29.5758);
-- 7.
SET @PATH := @GUID+6 * 10;
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
(@PATH, 1, -52.3969, 293.288, 27.8296),
(@PATH, 2, -58.7468, 295.764, 29.4033),
(@PATH, 3, -80.8255, 317.109, 28.9557),
(@PATH, 4, -84.6018, 313.357, 62.0829),
(@PATH, 5, -100.485, 310.06, 60.6726),
(@PATH, 6, -119.643, 290.201, 57.4676),
(@PATH, 7, -119.602, 271.028, 61.3137),
(@PATH, 8, -99.3827, 260.039, 59.8997),
(@PATH, 9, -62.9444, 265.206, 63.3061),
(@PATH, 10, -53.9817, 286.896, 63.0482),
(@PATH, 11, -66.9341, 300.934, 58.5854),
(@PATH, 12, -82.0958, 309.241, 61.3414),
(@PATH, 13, -100.199, 310.19, 60.9001),
(@PATH, 14, -109.249, 296.2, 58.5368),
(@PATH, 15, -112.956, 287.824, 28.945),
(@PATH, 16, -131.244, 263.41, 30.9794),
(@PATH, 17, -124.562, 262.687, 57.9071),
(@PATH, 18, -89.1208, 261.935, 60.3001),
(@PATH, 19, -66.6449, 264.328, 64.3038),
(@PATH, 20, -56.4546, 270.201, 65.3866),
(@PATH, 21, -53.7442, 287.453, 64.0839),
(@PATH, 22, -56.4072, 293.549, 29.5758);
-- 8.
SET @PATH := @GUID+7 * 10;
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
(@PATH, 1, -62.0894, 286.098, 48.6939),
(@PATH, 2, -76.8407, 304.686, 51.9439),
(@PATH, 3, -98.7576, 303.572, 46.4161),
(@PATH, 4, -119.16, 291.958, 26.7305),
(@PATH, 5, -119.16, 291.958, 26.7305),
(@PATH, 6, -118.246, 291.551, 26.7198),
(@PATH, 7, -116.125, 290.169, 41.5238),
(@PATH, 8, -114.528, 275.12, 40.1532),
(@PATH, 9, -90.689, 265.24, 41.0333);
-- 9.
SET @PATH := @GUID+8 * 10;
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
(@PATH, 1, -109.229, 288.209, 53.3584),
(@PATH, 2, -102.279, 278.86, 56.0703),
(@PATH, 3, -88.1313, 272.423, 59.4688),
(@PATH, 4, -71.9701, 272.574, 59.1446),
(@PATH, 5, -68.3353, 281.741, 61.757),
(@PATH, 6, -77.7733, 299.15, 60.5558),
(@PATH, 7, -94.7425, 300.49, 56.1018);
-- 10.
SET @PATH := @GUID+9 * 10;
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
(@PATH, 1, -71.9701, 272.574, 59.1446),
(@PATH, 2, -68.3353, 281.741, 61.757),
(@PATH, 3, -77.7733, 299.15, 60.5558),
(@PATH, 4, -94.7425, 300.49, 56.1018),
(@PATH, 5, -109.229, 288.209, 53.3584),
(@PATH, 6, -102.279, 278.86, 56.0703),
(@PATH, 7, -88.1313, 272.423, 59.4688);
-- 11.
SET @PATH := @GUID+10 * 10;
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
(@PATH, 1, -68.3353, 281.741, 61.757),
(@PATH, 2, -77.7733, 299.15, 60.5558),
(@PATH, 3, -94.7425, 300.49, 56.1018),
(@PATH, 4, -109.229, 288.209, 53.3584),
(@PATH, 5, -102.279, 278.86, 56.0703),
(@PATH, 6, -88.1313, 272.423, 59.4688),
(@PATH, 7, -71.9701, 272.574, 59.1446);
-- 12.
SET @PATH := @GUID+11 * 10;
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
(@PATH, 1, -102.279, 278.86, 56.0703),
(@PATH, 2, -88.1313, 272.423, 59.4688),
(@PATH, 3, -71.9701, 272.574, 59.1446),
(@PATH, 4, -68.3353, 281.741, 61.757),
(@PATH, 5, -77.7733, 299.15, 60.5558),
(@PATH, 6, -94.7425, 300.49, 56.1018),
(@PATH, 7, -109.229, 288.209, 53.3584);
-- 13.
SET @PATH := @GUID+12 * 10;
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
(@PATH, 1, -77.7733, 299.15, 60.5558),
(@PATH, 2, -94.7425, 300.49, 56.1018),
(@PATH, 3, -109.229, 288.209, 53.3584),
(@PATH, 4, -102.279, 278.86, 56.0703),
(@PATH, 5, -88.1313, 272.423, 59.4688),
(@PATH, 6, -71.9701, 272.574, 59.1446),
(@PATH, 7, -68.3353, 281.741, 61.757);
-- 14.
SET @PATH := @GUID+13 * 10;
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
(@PATH, 1, -86.6064, 286.122, 27.4832),
(@PATH, 2, -84.2669, 286.076, 57.4227),
(@PATH, 3, -71.9701, 272.574, 59.1446),
(@PATH, 4, -68.3353, 281.741, 61.757),
(@PATH, 5, -77.7733, 299.15, 60.5558),
(@PATH, 6, -94.7425, 300.49, 56.1018),
(@PATH, 7, -109.229, 288.209, 53.3584),
(@PATH, 8, -102.279, 278.86, 56.0703),
(@PATH, 9, -88.1313, 272.423, 59.4688);
-- 15.
SET @PATH := @GUID+14 * 10;
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`) VALUES
(@PATH, 1, 84.9162, 251.397, 37.0668),
(@PATH, 2, 83.9651, 251.088, 37.0668),
(@PATH, 3, 51.4796, 252.183, 37.0668),
(@PATH, 4, 33.2474, 282.432, 37.0668),
(@PATH, 5, -4.58595, 288.248, 37.0668),
(@PATH, 6, -33.1252, 287.388, 33.6501),
(@PATH, 7, -63.6614, 287.145, 37.0668),
(@PATH, 8, -77.5616, 286.325, 98.1903);
UPDATE `waypoint_data` SET `move_type`=1 WHERE `id` BETWEEN (@GUID+0)*10 AND (@GUID+14)*10;
ghost
on 11 Dec 2016
👍2
First 15 available GUIDs from TDB 335.62 + updates up to & including 2016_12_10_01_world.sql:
99126, 99127, 99128, 99129, 99130,
99131, 99132, 99133, 99134, 99135,
99136, 99137, 99138, 99139, 99140
( 99126 - 99140, including first & last )
ghost
on 11 Dec 2016
i had fun working with this thing ;) and yes it looks good :P
Grz3s
on 11 Dec 2016
👍1
Was this page helpful?
0 / 5 - 0 ratings
Related issues
DDuarte
路
3Comments
besplash
路
3Comments
Jildor
路
3Comments
Keader
路
3Comments
cbcs
路
3Comments
Most helpful comment
insert: wow awesome gif usage