diff options
| -rw-r--r-- | sql/updates/world/2015_10_31_01_world_2015_09_23_00.sql | 612 |
1 files changed, 612 insertions, 0 deletions
diff --git a/sql/updates/world/2015_10_31_01_world_2015_09_23_00.sql b/sql/updates/world/2015_10_31_01_world_2015_09_23_00.sql new file mode 100644 index 00000000000..5483d78b2ce --- /dev/null +++ b/sql/updates/world/2015_10_31_01_world_2015_09_23_00.sql @@ -0,0 +1,612 @@ +-- Pathing for Venom Stalker Entry: 15976 'TDB FORMAT' +SET @NPC := 127866; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3454.462,`position_y`=-3562.112,`position_z`=267.593 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,3454.462,-3562.112,267.593,0,0,0,0,100,0), -- 18:40:27 +(@PATH,2,3454.662,-3548.537,267.593,0,0,0,0,100,0), -- 18:40:38 +(@PATH,3,3464.026,-3545.334,267.593,0,0,0,0,100,0), -- 18:40:43 +(@PATH,4,3469.727,-3539.112,267.593,0,0,0,0,100,0), -- 18:40:47 +(@PATH,5,3471.318,-3524.515,267.593,0,0,0,0,100,0), -- 18:40:50 +(@PATH,6,3465.038,-3515.349,267.593,0,0,0,0,100,0), -- 18:40:56 +(@PATH,7,3454.185,-3511.259,267.593,0,0,0,0,100,0), -- 18:41:01 +(@PATH,8,3442.813,-3514.244,267.593,0,0,0,0,100,0), -- 18:41:06 +(@PATH,9,3435.952,-3524.05,267.593,0,0,0,0,100,0), -- 18:41:11 +(@PATH,10,3436.82,-3538.214,267.593,0,0,0,0,100,0), -- 18:41:16 +(@PATH,11,3445.783,-3546.556,267.593,0,0,0,0,100,0), -- 18:41:21 +(@PATH,12,3453.797,-3548.311,267.593,0,0,0,0,100,0), -- 18:41:25 +(@PATH,13,3453.227,-3570.022,267.593,0,0,0,0,100,0), -- 18:41:29 +(@PATH,14,3453.297,-3589.868,267.593,0,0,0,0,100,0), -- 18:41:38 +(@PATH,15,3452.981,-3624.833,269.3551,0,0,0,0,100,0), -- 18:41:46 +(@PATH,16,3453.006,-3638.403,276.4746,0,0,0,0,100,0), -- 18:41:59 +(@PATH,17,3453.413,-3650.563,282.8547,0,0,0,0,100,0), -- 18:42:06 +(@PATH,18,3453.339,-3674.839,294.1114,0,0,0,0,100,0), -- 18:42:12 +(@PATH,19,3453.625,-3707.783,294.6607,0,0,0,0,100,0), -- 18:42:23 +(@PATH,20,3453.646,-3719.333,294.6607,0,0,0,0,100,0), -- 18:42:36 +(@PATH,21,3440.435,-3724.057,294.6607,0,0,0,0,100,0), -- 18:42:41 +(@PATH,22,3433.669,-3735.089,294.6609,0,0,0,0,100,0), -- 18:42:46 +(@PATH,23,3435.129,-3747.669,294.6607,0,0,0,0,100,0), -- 18:42:50 +(@PATH,24,3444.191,-3756.717,294.6607,0,0,0,0,100,0), -- 18:42:55 +(@PATH,25,3457.736,-3759.273,294.6607,0,0,0,0,100,0), -- 18:43:01 +(@PATH,26,3468.683,-3752.32,294.6607,0,0,0,0,100,0), -- 18:43:06 +(@PATH,27,3473.417,-3741.013,294.6607,0,0,0,0,100,0), -- 18:43:12 +(@PATH,28,3469.141,-3727.593,294.6607,0,0,0,0,100,0), -- 18:43:17 +(@PATH,29,3461.402,-3721.552,294.6607,0,0,0,0,100,0), -- 18:43:22 +(@PATH,30,3453.865,-3719.445,294.6607,0,0,0,0,100,0), -- 18:43:27 +(@PATH,31,3453.944,-3707.97,294.6607,0,0,0,0,100,0), -- 18:43:29 +(@PATH,32,3453.922,-3674.717,294.0525,0,0,0,0,100,0), -- 18:43:34 +(@PATH,33,3454.177,-3650.563,282.855,0,0,0,0,100,0), -- 18:43:47 +(@PATH,34,3454.576,-3638.243,276.3913,0,0,0,0,100,0), -- 18:43:58 +(@PATH,35,3454.075,-3614.297,267.5918,0,0,0,0,100,0), -- 18:44:03 +(@PATH,36,3454.152,-3589.311,267.593,0,0,0,0,100,0); -- 18:44:14 + +-- Pathing for Venom Stalker Entry: 15976 'TDB FORMAT' +SET @NPC := 127867; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3454.462,`position_y`=-3569.112,`position_z`=267.593 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,3454.462,-3562.112,267.593,0,0,0,0,100,0), -- 18:40:27 +(@PATH,2,3454.662,-3548.537,267.593,0,0,0,0,100,0), -- 18:40:38 +(@PATH,3,3464.026,-3545.334,267.593,0,0,0,0,100,0), -- 18:40:43 +(@PATH,4,3469.727,-3539.112,267.593,0,0,0,0,100,0), -- 18:40:47 +(@PATH,5,3471.318,-3524.515,267.593,0,0,0,0,100,0), -- 18:40:50 +(@PATH,6,3465.038,-3515.349,267.593,0,0,0,0,100,0), -- 18:40:56 +(@PATH,7,3454.185,-3511.259,267.593,0,0,0,0,100,0), -- 18:41:01 +(@PATH,8,3442.813,-3514.244,267.593,0,0,0,0,100,0), -- 18:41:06 +(@PATH,9,3435.952,-3524.05,267.593,0,0,0,0,100,0), -- 18:41:11 +(@PATH,10,3436.82,-3538.214,267.593,0,0,0,0,100,0), -- 18:41:16 +(@PATH,11,3445.783,-3546.556,267.593,0,0,0,0,100,0), -- 18:41:21 +(@PATH,12,3453.797,-3548.311,267.593,0,0,0,0,100,0), -- 18:41:25 +(@PATH,13,3453.227,-3570.022,267.593,0,0,0,0,100,0), -- 18:41:29 +(@PATH,14,3453.297,-3589.868,267.593,0,0,0,0,100,0), -- 18:41:38 +(@PATH,15,3452.981,-3624.833,269.3551,0,0,0,0,100,0), -- 18:41:46 +(@PATH,16,3453.006,-3638.403,276.4746,0,0,0,0,100,0), -- 18:41:59 +(@PATH,17,3453.413,-3650.563,282.8547,0,0,0,0,100,0), -- 18:42:06 +(@PATH,18,3453.339,-3674.839,294.1114,0,0,0,0,100,0), -- 18:42:12 +(@PATH,19,3453.625,-3707.783,294.6607,0,0,0,0,100,0), -- 18:42:23 +(@PATH,20,3453.646,-3719.333,294.6607,0,0,0,0,100,0), -- 18:42:36 +(@PATH,21,3440.435,-3724.057,294.6607,0,0,0,0,100,0), -- 18:42:41 +(@PATH,22,3433.669,-3735.089,294.6609,0,0,0,0,100,0), -- 18:42:46 +(@PATH,23,3435.129,-3747.669,294.6607,0,0,0,0,100,0), -- 18:42:50 +(@PATH,24,3444.191,-3756.717,294.6607,0,0,0,0,100,0), -- 18:42:55 +(@PATH,25,3457.736,-3759.273,294.6607,0,0,0,0,100,0), -- 18:43:01 +(@PATH,26,3468.683,-3752.32,294.6607,0,0,0,0,100,0), -- 18:43:06 +(@PATH,27,3473.417,-3741.013,294.6607,0,0,0,0,100,0), -- 18:43:12 +(@PATH,28,3469.141,-3727.593,294.6607,0,0,0,0,100,0), -- 18:43:17 +(@PATH,29,3461.402,-3721.552,294.6607,0,0,0,0,100,0), -- 18:43:22 +(@PATH,30,3453.865,-3719.445,294.6607,0,0,0,0,100,0), -- 18:43:27 +(@PATH,31,3453.944,-3707.97,294.6607,0,0,0,0,100,0), -- 18:43:29 +(@PATH,32,3453.922,-3674.717,294.0525,0,0,0,0,100,0), -- 18:43:34 +(@PATH,33,3454.177,-3650.563,282.855,0,0,0,0,100,0), -- 18:43:47 +(@PATH,34,3454.576,-3638.243,276.3913,0,0,0,0,100,0), -- 18:43:58 +(@PATH,35,3454.075,-3614.297,267.5918,0,0,0,0,100,0), -- 18:44:03 +(@PATH,36,3454.152,-3589.311,267.593,0,0,0,0,100,0); -- 18:44:14 + +-- Pathing for Venom Stalker Entry: 15976 'TDB FORMAT' +SET @NPC := 127862; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3234.124,`position_y`=-3743.281,`position_z`=280.9517 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,3234.124,-3743.281,280.9517,0,0,0,0,100,0), -- 18:45:33 +(@PATH,2,3234.624,-3733.446,282.4194,0,0,0,0,100,0), -- 18:45:43 +(@PATH,3,3252.519,-3730.217,279.2638,0,0,0,0,100,0), -- 18:45:46 +(@PATH,4,3276.249,-3724.284,275.8947,0,0,0,0,100,0), -- 18:45:54 +(@PATH,5,3309.417,-3714.943,266.8448,0,0,0,0,100,0), -- 18:46:03 +(@PATH,6,3322.029,-3700.557,262.8869,0,0,0,0,100,0), -- 18:46:18 +(@PATH,7,3298.23,-3700.239,271.5519,0,0,0,0,100,0), -- 18:46:26 +(@PATH,8,3280.485,-3698.461,278.4746,0,0,0,0,100,0), -- 18:46:36 +(@PATH,9,3298.23,-3700.239,271.5519,0,0,0,0,100,0), -- 18:46:45 +(@PATH,10,3321.937,-3700.525,262.8836,0,0,0,0,100,0), -- 18:46:52 +(@PATH,11,3309.417,-3714.943,266.8448,0,0,0,0,100,0), -- 18:47:02 +(@PATH,12,3276.249,-3724.284,275.8947,0,0,0,0,100,0), -- 18:47:10 +(@PATH,13,3252.581,-3730.202,279.2548,0,0,0,0,100,0), -- 18:47:25 +(@PATH,14,3234.624,-3733.446,282.4194,0,0,0,0,100,0), -- 18:47:34 +(@PATH,15,3234.132,-3743.128,280.9408,0,0,0,0,100,0), -- 18:47:42 +(@PATH,16,3247.629,-3762.814,277.5423,0,0,0,0,100,0), -- 18:47:45 +(@PATH,17,3232.144,-3779.076,273.1304,0,0,0,0,100,0), -- 18:47:55 +(@PATH,18,3247.629,-3762.814,277.5423,0,0,0,0,100,0); -- 18:48:06 + +-- Pathing for Venom Stalker Entry: 15976 'TDB FORMAT' +SET @NPC := 127863; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3232.124,`position_y`=-3751.281,`position_z`=280.9517 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,3234.124,-3743.281,280.9517,0,0,0,0,100,0), -- 18:45:33 +(@PATH,2,3234.624,-3733.446,282.4194,0,0,0,0,100,0), -- 18:45:43 +(@PATH,3,3252.519,-3730.217,279.2638,0,0,0,0,100,0), -- 18:45:46 +(@PATH,4,3276.249,-3724.284,275.8947,0,0,0,0,100,0), -- 18:45:54 +(@PATH,5,3309.417,-3714.943,266.8448,0,0,0,0,100,0), -- 18:46:03 +(@PATH,6,3322.029,-3700.557,262.8869,0,0,0,0,100,0), -- 18:46:18 +(@PATH,7,3298.23,-3700.239,271.5519,0,0,0,0,100,0), -- 18:46:26 +(@PATH,8,3280.485,-3698.461,278.4746,0,0,0,0,100,0), -- 18:46:36 +(@PATH,9,3298.23,-3700.239,271.5519,0,0,0,0,100,0), -- 18:46:45 +(@PATH,10,3321.937,-3700.525,262.8836,0,0,0,0,100,0), -- 18:46:52 +(@PATH,11,3309.417,-3714.943,266.8448,0,0,0,0,100,0), -- 18:47:02 +(@PATH,12,3276.249,-3724.284,275.8947,0,0,0,0,100,0), -- 18:47:10 +(@PATH,13,3252.581,-3730.202,279.2548,0,0,0,0,100,0), -- 18:47:25 +(@PATH,14,3234.624,-3733.446,282.4194,0,0,0,0,100,0), -- 18:47:34 +(@PATH,15,3234.132,-3743.128,280.9408,0,0,0,0,100,0), -- 18:47:42 +(@PATH,16,3247.629,-3762.814,277.5423,0,0,0,0,100,0), -- 18:47:45 +(@PATH,17,3232.144,-3779.076,273.1304,0,0,0,0,100,0), -- 18:47:55 +(@PATH,18,3247.629,-3762.814,277.5423,0,0,0,0,100,0); -- 18:48:06 + +-- Pathing for Venom Stalker Entry: 15976 'TDB FORMAT' +SET @NPC := 127872; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3282.724,`position_y`=-3894.288,`position_z`=294.6608 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,3282.724,-3894.288,294.6608,0,0,0,0,100,0), -- 18:48:08 +(@PATH,2,3280.431,-3878.874,294.6607,0,0,0,0,100,0), -- 18:48:14 +(@PATH,3,3288.137,-3862.199,294.6597,0,0,0,0,100,0), -- 18:48:21 +(@PATH,4,3300.762,-3854.986,294.6609,0,0,0,0,100,0), -- 18:48:28 +(@PATH,5,3317.737,-3854.183,294.6609,0,0,0,0,100,0), -- 18:48:34 +(@PATH,6,3337.437,-3853.406,294.6607,0,0,0,0,100,0), -- 18:48:41 +(@PATH,7,3359.545,-3831.036,294.662,0,0,0,0,100,0), -- 18:48:48 +(@PATH,8,3383.364,-3807.658,294.6969,0,0,0,0,100,0), -- 18:49:02 +(@PATH,9,3407.369,-3783.911,294.661,0,0,0,0,100,0), -- 18:49:15 +(@PATH,10,3425.444,-3761.708,294.6607,0,0,0,0,100,0), -- 18:49:29 +(@PATH,11,3425.071,-3748.542,294.6605,0,0,0,0,100,0), -- 18:49:39 +(@PATH,12,3425.387,-3729.456,294.6607,0,0,0,0,100,0), -- 18:49:44 +(@PATH,13,3435.633,-3715.143,294.6598,0,0,0,0,100,0), -- 18:49:53 +(@PATH,14,3453.195,-3709.209,294.6607,0,0,0,0,100,0), -- 18:49:59 +(@PATH,15,3465.947,-3712.353,294.6602,0,0,0,0,100,0), -- 18:50:07 +(@PATH,16,3477.195,-3720.679,294.6599,0,0,0,0,100,0), -- 18:50:12 +(@PATH,17,3483.336,-3735.452,294.6605,0,0,0,0,100,0), -- 18:50:17 +(@PATH,18,3481.773,-3748.506,294.66,0,0,0,0,100,0), -- 18:50:24 +(@PATH,19,3474.602,-3761.479,294.6591,0,0,0,0,100,0), -- 18:50:29 +(@PATH,20,3459.724,-3768.537,294.6591,0,0,0,0,100,0), -- 18:50:35 +(@PATH,21,3444.191,-3767.875,294.6595,0,0,0,0,100,0), -- 18:50:41 +(@PATH,22,3431.064,-3767.097,294.6601,0,0,0,0,100,0), -- 18:50:49 +(@PATH,23,3410.49,-3782.893,294.6607,0,0,0,0,100,0), -- 18:50:53 +(@PATH,24,3385.208,-3808.768,294.6991,0,0,0,0,100,0), -- 18:51:03 +(@PATH,25,3361.281,-3832.754,294.662,0,0,0,0,100,0), -- 18:51:18 +(@PATH,26,3338.748,-3854.621,294.6607,0,0,0,0,100,0), -- 18:51:32 +(@PATH,27,3338.51,-3872.156,294.6597,0,0,0,0,100,0), -- 18:51:44 +(@PATH,28,3339.48,-3888.635,294.6605,0,0,0,0,100,0), -- 18:51:51 +(@PATH,29,3325.759,-3908.016,294.6607,0,0,0,0,100,0), -- 18:51:58 +(@PATH,30,3310.214,-3913.58,294.6595,0,0,0,0,100,0), -- 18:52:08 +(@PATH,31,3292.234,-3906.752,294.6605,0,0,0,0,100,0); -- 18:52:14 + +-- Pathing for Venom Stalker Entry: 15976 'TDB FORMAT' +SET @NPC := 127873; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3286.724,`position_y`=-3902.288,`position_z`=294.6608 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,3282.724,-3894.288,294.6608,0,0,0,0,100,0), -- 18:48:08 +(@PATH,2,3280.431,-3878.874,294.6607,0,0,0,0,100,0), -- 18:48:14 +(@PATH,3,3288.137,-3862.199,294.6597,0,0,0,0,100,0), -- 18:48:21 +(@PATH,4,3300.762,-3854.986,294.6609,0,0,0,0,100,0), -- 18:48:28 +(@PATH,5,3317.737,-3854.183,294.6609,0,0,0,0,100,0), -- 18:48:34 +(@PATH,6,3337.437,-3853.406,294.6607,0,0,0,0,100,0), -- 18:48:41 +(@PATH,7,3359.545,-3831.036,294.662,0,0,0,0,100,0), -- 18:48:48 +(@PATH,8,3383.364,-3807.658,294.6969,0,0,0,0,100,0), -- 18:49:02 +(@PATH,9,3407.369,-3783.911,294.661,0,0,0,0,100,0), -- 18:49:15 +(@PATH,10,3425.444,-3761.708,294.6607,0,0,0,0,100,0), -- 18:49:29 +(@PATH,11,3425.071,-3748.542,294.6605,0,0,0,0,100,0), -- 18:49:39 +(@PATH,12,3425.387,-3729.456,294.6607,0,0,0,0,100,0), -- 18:49:44 +(@PATH,13,3435.633,-3715.143,294.6598,0,0,0,0,100,0), -- 18:49:53 +(@PATH,14,3453.195,-3709.209,294.6607,0,0,0,0,100,0), -- 18:49:59 +(@PATH,15,3465.947,-3712.353,294.6602,0,0,0,0,100,0), -- 18:50:07 +(@PATH,16,3477.195,-3720.679,294.6599,0,0,0,0,100,0), -- 18:50:12 +(@PATH,17,3483.336,-3735.452,294.6605,0,0,0,0,100,0), -- 18:50:17 +(@PATH,18,3481.773,-3748.506,294.66,0,0,0,0,100,0), -- 18:50:24 +(@PATH,19,3474.602,-3761.479,294.6591,0,0,0,0,100,0), -- 18:50:29 +(@PATH,20,3459.724,-3768.537,294.6591,0,0,0,0,100,0), -- 18:50:35 +(@PATH,21,3444.191,-3767.875,294.6595,0,0,0,0,100,0), -- 18:50:41 +(@PATH,22,3431.064,-3767.097,294.6601,0,0,0,0,100,0), -- 18:50:49 +(@PATH,23,3410.49,-3782.893,294.6607,0,0,0,0,100,0), -- 18:50:53 +(@PATH,24,3385.208,-3808.768,294.6991,0,0,0,0,100,0), -- 18:51:03 +(@PATH,25,3361.281,-3832.754,294.662,0,0,0,0,100,0), -- 18:51:18 +(@PATH,26,3338.748,-3854.621,294.6607,0,0,0,0,100,0), -- 18:51:32 +(@PATH,27,3338.51,-3872.156,294.6597,0,0,0,0,100,0), -- 18:51:44 +(@PATH,28,3339.48,-3888.635,294.6605,0,0,0,0,100,0), -- 18:51:51 +(@PATH,29,3325.759,-3908.016,294.6607,0,0,0,0,100,0), -- 18:51:58 +(@PATH,30,3310.214,-3913.58,294.6595,0,0,0,0,100,0), -- 18:52:08 +(@PATH,31,3292.234,-3906.752,294.6605,0,0,0,0,100,0); -- 18:52:14 + +-- Pathing for Venom Stalker Entry: 15976 'TDB FORMAT' +SET @NPC := 127864; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3118.083,`position_y`=-3883.491,`position_z`=267.593 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,3118.083,-3883.491,267.593,0,0,0,0,100,0), -- 18:36:24 +(@PATH,2,3114.162,-3894.186,267.593,0,0,0,0,100,0), -- 18:36:33 +(@PATH,3,3104.3,-3900.575,267.593,0,0,0,0,100,0), -- 18:36:38 +(@PATH,4,3093.041,-3899.523,267.593,0,0,0,0,100,0), -- 18:36:43 +(@PATH,5,3083.292,-3890.907,267.593,0,0,0,0,100,0), -- 18:36:48 +(@PATH,6,3082.536,-3878.924,267.593,0,0,0,0,100,0), -- 18:36:53 +(@PATH,7,3088.724,-3868.493,267.593,0,0,0,0,100,0), -- 18:36:57 +(@PATH,8,3103.835,-3863.884,267.593,0,0,0,0,100,0), -- 18:37:02 +(@PATH,9,3114.156,-3873.857,267.593,0,0,0,0,100,0), -- 18:37:08 +(@PATH,10,3118.014,-3882.239,267.593,0,0,0,0,100,0), -- 18:37:14 +(@PATH,11,3142.844,-3882.002,267.593,0,0,0,0,100,0), -- 18:37:18 +(@PATH,12,3166.273,-3881.469,267.5934,0,0,0,0,100,0), -- 18:37:28 +(@PATH,13,3194.12,-3881.767,268.6533,0,0,0,0,100,0), -- 18:37:37 +(@PATH,14,3207.929,-3881.54,275.8944,0,0,0,0,100,0), -- 18:37:48 +(@PATH,15,3221.411,-3881.945,282.9668,0,0,0,0,100,0), -- 18:37:54 +(@PATH,16,3241.861,-3882.487,292.3779,0,0,0,0,100,0), -- 18:38:01 +(@PATH,17,3260.216,-3882.229,294.6607,0,0,0,0,100,0), -- 18:38:10 +(@PATH,18,3279.568,-3882.604,294.6607,0,0,0,0,100,0), -- 18:38:17 +(@PATH,19,3290.396,-3881.747,294.6607,0,0,0,0,100,0), -- 18:38:25 +(@PATH,20,3296.476,-3869.041,294.6607,0,0,0,0,100,0), -- 18:38:30 +(@PATH,21,3307.822,-3864.203,294.6607,0,0,0,0,100,0), -- 18:46:32 +(@PATH,22,3321.301,-3868.157,294.6607,0,0,0,0,100,0), -- 18:46:37 +(@PATH,23,3328.406,-3877.447,294.6597,0,0,0,0,100,0), -- 18:46:43 +(@PATH,24,3327.705,-3889.598,294.6607,0,0,0,0,100,0), -- 18:46:47 +(@PATH,25,3320.085,-3897.669,294.6607,0,0,0,0,100,0), -- 18:46:52 +(@PATH,26,3312.01,-3901.51,294.6607,0,0,0,0,100,0), -- 18:46:57 +(@PATH,27,3297.603,-3897.307,294.6607,0,0,0,0,100,0), -- 18:47:00 +(@PATH,28,3292.267,-3890.234,294.6607,0,0,0,0,100,0), -- 18:47:07 +(@PATH,29,3290.384,-3882.75,294.6607,0,0,0,0,100,0), -- 18:47:10 +(@PATH,30,3279.155,-3882.98,294.6607,0,0,0,0,100,0), -- 18:47:14 +(@PATH,31,3260.253,-3882.767,294.6607,0,0,0,0,100,0), -- 18:47:17 +(@PATH,32,3241.78,-3882.872,292.339,0,0,0,0,100,0), -- 18:47:25 +(@PATH,33,3221.214,-3882.398,282.8636,0,0,0,0,100,0), -- 18:47:33 +(@PATH,34,3207.818,-3881.953,275.8358,0,0,0,0,100,0), -- 18:47:42 +(@PATH,35,3194.124,-3882.38,268.655,0,0,0,0,100,0), -- 18:47:48 +(@PATH,36,3166.121,-3882.08,267.5934,0,0,0,0,100,0), -- 18:47:54 +(@PATH,37,3142.54,-3882.999,267.593,0,0,0,0,100,0); -- 18:48:06 + +-- Pathing for Venom Stalker Entry: 15976 'TDB FORMAT' +SET @NPC := 127865; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3126.083,`position_y`=-3882.491,`position_z`=267.593 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,3118.083,-3883.491,267.593,0,0,0,0,100,0), -- 18:36:24 +(@PATH,2,3114.162,-3894.186,267.593,0,0,0,0,100,0), -- 18:36:33 +(@PATH,3,3104.3,-3900.575,267.593,0,0,0,0,100,0), -- 18:36:38 +(@PATH,4,3093.041,-3899.523,267.593,0,0,0,0,100,0), -- 18:36:43 +(@PATH,5,3083.292,-3890.907,267.593,0,0,0,0,100,0), -- 18:36:48 +(@PATH,6,3082.536,-3878.924,267.593,0,0,0,0,100,0), -- 18:36:53 +(@PATH,7,3088.724,-3868.493,267.593,0,0,0,0,100,0), -- 18:36:57 +(@PATH,8,3103.835,-3863.884,267.593,0,0,0,0,100,0), -- 18:37:02 +(@PATH,9,3114.156,-3873.857,267.593,0,0,0,0,100,0), -- 18:37:08 +(@PATH,10,3118.014,-3882.239,267.593,0,0,0,0,100,0), -- 18:37:14 +(@PATH,11,3142.844,-3882.002,267.593,0,0,0,0,100,0), -- 18:37:18 +(@PATH,12,3166.273,-3881.469,267.5934,0,0,0,0,100,0), -- 18:37:28 +(@PATH,13,3194.12,-3881.767,268.6533,0,0,0,0,100,0), -- 18:37:37 +(@PATH,14,3207.929,-3881.54,275.8944,0,0,0,0,100,0), -- 18:37:48 +(@PATH,15,3221.411,-3881.945,282.9668,0,0,0,0,100,0), -- 18:37:54 +(@PATH,16,3241.861,-3882.487,292.3779,0,0,0,0,100,0), -- 18:38:01 +(@PATH,17,3260.216,-3882.229,294.6607,0,0,0,0,100,0), -- 18:38:10 +(@PATH,18,3279.568,-3882.604,294.6607,0,0,0,0,100,0), -- 18:38:17 +(@PATH,19,3290.396,-3881.747,294.6607,0,0,0,0,100,0), -- 18:38:25 +(@PATH,20,3296.476,-3869.041,294.6607,0,0,0,0,100,0), -- 18:38:30 +(@PATH,21,3307.822,-3864.203,294.6607,0,0,0,0,100,0), -- 18:46:32 +(@PATH,22,3321.301,-3868.157,294.6607,0,0,0,0,100,0), -- 18:46:37 +(@PATH,23,3328.406,-3877.447,294.6597,0,0,0,0,100,0), -- 18:46:43 +(@PATH,24,3327.705,-3889.598,294.6607,0,0,0,0,100,0), -- 18:46:47 +(@PATH,25,3320.085,-3897.669,294.6607,0,0,0,0,100,0), -- 18:46:52 +(@PATH,26,3312.01,-3901.51,294.6607,0,0,0,0,100,0), -- 18:46:57 +(@PATH,27,3297.603,-3897.307,294.6607,0,0,0,0,100,0), -- 18:47:00 +(@PATH,28,3292.267,-3890.234,294.6607,0,0,0,0,100,0), -- 18:47:07 +(@PATH,29,3290.384,-3882.75,294.6607,0,0,0,0,100,0), -- 18:47:10 +(@PATH,30,3279.155,-3882.98,294.6607,0,0,0,0,100,0), -- 18:47:14 +(@PATH,31,3260.253,-3882.767,294.6607,0,0,0,0,100,0), -- 18:47:17 +(@PATH,32,3241.78,-3882.872,292.339,0,0,0,0,100,0), -- 18:47:25 +(@PATH,33,3221.214,-3882.398,282.8636,0,0,0,0,100,0), -- 18:47:33 +(@PATH,34,3207.818,-3881.953,275.8358,0,0,0,0,100,0), -- 18:47:42 +(@PATH,35,3194.124,-3882.38,268.655,0,0,0,0,100,0), -- 18:47:48 +(@PATH,36,3166.121,-3882.08,267.5934,0,0,0,0,100,0), -- 18:47:54 +(@PATH,37,3142.54,-3882.999,267.593,0,0,0,0,100,0); -- 18:48:06 + +DELETE FROM `creature_formations` WHERE `leaderGUID` IN (127862,127863,127864,127865,127866,127867,127872,127873); +DELETE FROM `creature_formations` WHERE `memberGUID` IN (127862,127863,127864,127865,127866,127867,127872,127873); +INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`,`point_1`,`point_2`) VALUES +(127866,127866,0,0,2,0,0), +(127866,127867,8,360,2,0,0), +(127862,127862,0,0,2,0,0), +(127862,127863,8,360,2,0,0), +(127872,127872,0,0,2,0,0), +(127872,127873,8,360,2,0,0), +(127864,127864,0,0,2,0,0), +(127864,127865,8,360,2,0,0); + +-- Pathing for Poisonous Skitterer Entry: 15977 'TDB FORMAT' +SET @NPC := 127907; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3074.529,`position_y`=-3897.057,`position_z`=267.593 WHERE `guid` IN (@NPC,@NPC+1,@NPC+2,@NPC+3,@NPC+4,@NPC+5,@NPC+6,@NPC+7); +DELETE FROM `creature_addon` WHERE `guid` IN (@NPC,@NPC+1,@NPC+2,@NPC+3,@NPC+4,@NPC+5,@NPC+6,@NPC+7); +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(@NPC,@PATH,0,0,1,0, ''),(@NPC+1,@PATH,0,0,1,0, ''),(@NPC+2,@PATH,0,0,1,0, ''),(@NPC+3,@PATH,0,0,1,0, ''), +(@NPC+4,@PATH,0,0,1,0, ''),(@NPC+5,@PATH,0,0,1,0, ''),(@NPC+6,@PATH,0,0,1,0, ''),(@NPC+7,@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,3074.529,-3897.057,267.593,0,0,1,0,100,0), -- 18:49:16 +(@PATH,2,3079.677,-3905.275,267.5924,0,0,1,0,100,0), -- 18:49:18 +(@PATH,3,3100.693,-3912.941,267.593,0,0,1,0,100,0), -- 18:49:19 +(@PATH,4,3117.195,-3907.615,267.5934,0,0,1,0,100,0), -- 18:49:21 +(@PATH,5,3127.366,-3895.706,267.593,0,0,1,0,100,0), -- 18:49:22 +(@PATH,6,3140.936,-3884.294,267.593,0,0,1,0,100,0), -- 18:49:24 +(@PATH,7,3158.318,-3883.925,267.593,0,0,1,0,100,0), -- 18:49:26 +(@PATH,8,3174.53,-3883.984,267.5941,0,0,1,0,100,0), -- 18:49:27 +(@PATH,9,3194.791,-3884.305,269.0044,0,0,1,0,100,0), -- 18:49:30 +(@PATH,10,3205.072,-3884.625,274.395,0,0,1,0,100,0), -- 18:49:31 +(@PATH,11,3215.293,-3885.147,279.7566,0,0,1,0,100,0), -- 18:49:32 +(@PATH,12,3223.794,-3885.607,284.2162,0,0,1,0,100,0), -- 18:49:33 +(@PATH,13,3237.89,-3886.143,290.4647,0,0,1,0,100,0), -- 18:49:35 +(@PATH,14,3247.501,-3886.756,294.6604,0,0,1,0,100,0), -- 18:49:36 +(@PATH,15,3267.746,-3887.45,294.6607,0,0,1,0,100,0), -- 18:49:37 +(@PATH,16,3282.858,-3895.334,294.6606,0,0,1,0,100,0), -- 18:49:39 +(@PATH,17,3295.857,-3909.075,294.6605,0,0,1,0,100,0), -- 18:49:41 +(@PATH,18,3313.104,-3913.105,294.6597,0,0,1,0,100,0), -- 18:49:43 +(@PATH,19,3331.879,-3904.76,294.6607,0,0,1,0,100,0), -- 18:49:44 +(@PATH,20,3338.559,-3891.88,294.6608,0,0,1,0,100,0), -- 18:49:47 +(@PATH,21,3339.517,-3878.169,294.6594,0,0,1,0,100,0), -- 18:49:48 +(@PATH,22,3332.953,-3864.011,294.6603,0,0,1,0,100,0), -- 18:49:49 +(@PATH,23,3319.689,-3854.916,294.6607,0,0,1,0,100,0), -- 18:49:50 +(@PATH,24,3304.591,-3853.372,294.6609,0,0,1,0,100,0), -- 18:49:53 +(@PATH,25,3288.425,-3861.284,294.6596,0,0,1,0,100,0), -- 18:49:54 +(@PATH,26,3280.122,-3870.386,294.6606,0,0,1,0,100,0), -- 18:49:56 +(@PATH,27,3267.866,-3880.449,294.6615,0,0,1,0,100,0), -- 18:49:58 +(@PATH,28,3247.675,-3880.42,294.6608,0,0,1,0,100,0), -- 18:49:59 +(@PATH,29,3237.588,-3880.728,290.3199,0,0,1,0,100,0), -- 18:50:01 +(@PATH,30,3224.797,-3880.583,284.7434,0,0,1,0,100,0), -- 18:50:02 +(@PATH,31,3215.042,-3880.425,279.6261,0,0,1,0,100,0), -- 18:50:04 +(@PATH,32,3195.322,-3880.004,269.2845,0,0,1,0,100,0), -- 18:50:05 +(@PATH,33,3175.766,-3879.59,267.5942,0,0,1,0,100,0), -- 18:50:06 +(@PATH,34,3158.302,-3879.587,267.593,0,0,1,0,100,0), -- 18:50:09 +(@PATH,35,3140.589,-3879.343,267.593,0,0,1,0,100,0), -- 18:50:11 +(@PATH,36,3127.137,-3869.814,267.5929,0,0,1,0,100,0), -- 18:50:12 +(@PATH,37,3118.936,-3859.253,267.5927,0,0,1,0,100,0), -- 18:50:13 +(@PATH,38,3103.765,-3853.207,267.5929,0,0,1,0,100,0), -- 18:50:15 +(@PATH,39,3087.844,-3856.353,267.593,0,0,1,0,100,0), -- 18:50:17 +(@PATH,40,3075.642,-3865.845,267.5934,0,0,1,0,100,0), -- 18:50:18 +(@PATH,41,3070.007,-3884.099,267.593,0,0,1,0,100,0); -- 18:50:19 +-- 0x1C3B1C42A00F9A400063AC0000019CDF .go 3074.529 -3897.057 267.593 + +DELETE FROM `creature_formations` WHERE `leaderGUID` IN (@NPC,@NPC+1,@NPC+2,@NPC+3,@NPC+4,@NPC+5,@NPC+6,@NPC+7); +DELETE FROM `creature_formations` WHERE `memberGUID` IN (@NPC,@NPC+1,@NPC+2,@NPC+3,@NPC+4,@NPC+5,@NPC+6,@NPC+7); +INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`,`point_1`,`point_2`) VALUES +(@NPC,@NPC,0,0,2,0,0), +(@NPC,@NPC+1,6,150,2,0,0), +(@NPC,@NPC+2,6,100,2,0,0), +(@NPC,@NPC+3,6,50,2,0,0), +(@NPC,@NPC+4,6,360,2,0,0), +(@NPC,@NPC+5,6,310,2,0,0), +(@NPC,@NPC+6,6,240,2,0,0), +(@NPC,@NPC+7,6,190,2,0,0); + +-- Pathing for Poisonous Skitterer Entry: 15977 'TDB FORMAT' +SET @NPC := 127963; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3224.441,`position_y`=-3876.754,`position_z`=284.5573 WHERE `guid` IN (@NPC,@NPC+1,@NPC+2,@NPC+3,@NPC+4,@NPC+5,@NPC+6,@NPC+7); +DELETE FROM `creature_addon` WHERE `guid` IN (@NPC,@NPC+1,@NPC+2,@NPC+3,@NPC+4,@NPC+5,@NPC+6,@NPC+7); +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(@NPC,@PATH,0,0,1,0, ''),(@NPC+1,@PATH,0,0,1,0, ''),(@NPC+2,@PATH,0,0,1,0, ''),(@NPC+3,@PATH,0,0,1,0, ''), +(@NPC+4,@PATH,0,0,1,0, ''),(@NPC+5,@PATH,0,0,1,0, ''),(@NPC+6,@PATH,0,0,1,0, ''),(@NPC+7,@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,3224.441,-3876.754,284.5573,0,0,1,0,100,0), -- 18:48:59 +(@PATH,2,3243.073,-3881.118,292.9622,0,0,1,0,100,0), -- 18:49:03 +(@PATH,3,3264.531,-3885.239,294.6607,0,0,1,0,100,0), -- 18:49:04 +(@PATH,4,3280.712,-3887.944,294.6607,0,0,1,0,100,0), -- 18:49:07 +(@PATH,5,3286.485,-3901.147,294.66,0,0,1,0,100,0), -- 18:49:08 +(@PATH,6,3299.353,-3910.954,294.6605,0,0,1,0,100,0), -- 18:49:10 +(@PATH,7,3310.171,-3913.553,294.6593,0,0,1,0,100,0), -- 18:49:12 +(@PATH,8,3320.141,-3911.575,294.6602,0,0,1,0,100,0), -- 18:49:13 +(@PATH,9,3327.62,-3907.016,294.6607,0,0,1,0,100,0), -- 18:49:14 +(@PATH,10,3337.314,-3895.928,294.6607,0,0,1,0,100,0), -- 18:49:15 +(@PATH,11,3339.708,-3878.755,294.6594,0,0,1,0,100,0), -- 18:49:16 +(@PATH,12,3333.498,-3863.702,294.6603,0,0,1,0,100,0), -- 18:49:18 +(@PATH,13,3323.844,-3856.551,294.6607,0,0,1,0,100,0), -- 18:49:20 +(@PATH,14,3309.547,-3852.652,294.6601,0,0,1,0,100,0), -- 18:49:21 +(@PATH,15,3294.998,-3857.095,294.6609,0,0,1,0,100,0), -- 18:49:22 +(@PATH,16,3284.745,-3868.869,294.6604,0,0,1,0,100,0), -- 18:49:24 +(@PATH,17,3280.295,-3878.902,294.6607,0,0,1,0,100,0), -- 18:49:25 +(@PATH,18,3264.526,-3882.421,294.6607,0,0,1,0,100,0), -- 18:49:26 +(@PATH,19,3243.129,-3885.538,292.9888,0,0,1,0,100,0), -- 18:49:29 +(@PATH,20,3225,-3889.948,284.8481,0,0,1,0,100,0), -- 18:49:30 +(@PATH,21,3207.006,-3898.323,275.4061,0,0,1,0,100,0), -- 18:49:32 +(@PATH,22,3182.24,-3901.498,267.5922,0,0,1,0,100,0), -- 18:49:35 +(@PATH,23,3181.843,-3882.055,267.5952,0,0,1,0,100,0), -- 18:49:37 +(@PATH,24,3181.309,-3863.954,267.6013,0,0,1,0,100,0), -- 18:49:39 +(@PATH,25,3202.393,-3869.113,272.9927,0,0,1,0,100,0); -- 18:49:41 +-- 0x1C3B1C42A00F9A400063AC0004019CDF .go 3224.441 -3876.754 284.5573 + +DELETE FROM `creature_formations` WHERE `leaderGUID` IN (@NPC,@NPC+1,@NPC+2,@NPC+3,@NPC+4,@NPC+5,@NPC+6,@NPC+7); +DELETE FROM `creature_formations` WHERE `memberGUID` IN (@NPC,@NPC+1,@NPC+2,@NPC+3,@NPC+4,@NPC+5,@NPC+6,@NPC+7); +INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`,`point_1`,`point_2`) VALUES +(@NPC,@NPC,0,0,2,0,0), +(@NPC,@NPC+1,6,150,2,0,0), +(@NPC,@NPC+2,6,100,2,0,0), +(@NPC,@NPC+3,6,50,2,0,0), +(@NPC,@NPC+4,6,360,2,0,0), +(@NPC,@NPC+5,6,310,2,0,0), +(@NPC,@NPC+6,6,240,2,0,0), +(@NPC,@NPC+7,6,190,2,0,0); + +-- Pathing for Poisonous Skitterer Entry: 15977 'TDB FORMAT' +SET @NPC := 127915; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3435.956,`position_y`=-3606.878,`position_z`=267.5925 WHERE `guid` IN (@NPC,@NPC+1,@NPC+2,@NPC+3,@NPC+4,@NPC+5,@NPC+6,@NPC+7); +DELETE FROM `creature_addon` WHERE `guid` IN (@NPC,@NPC+1,@NPC+2,@NPC+3,@NPC+4,@NPC+5,@NPC+6,@NPC+7); +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(@NPC,@PATH,0,0,1,0, ''),(@NPC+1,@PATH,0,0,1,0, ''),(@NPC+2,@PATH,0,0,1,0, ''),(@NPC+3,@PATH,0,0,1,0, ''), +(@NPC+4,@PATH,0,0,1,0, ''),(@NPC+5,@PATH,0,0,1,0, ''),(@NPC+6,@PATH,0,0,1,0, ''),(@NPC+7,@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,3435.956,-3606.878,267.5925,0,0,1,0,100,0), -- 18:40:42 +(@PATH,2,3435.056,-3623.646,268.7272,0,0,1,0,100,0), -- 18:40:43 +(@PATH,3,3434.696,-3642.454,278.5947,0,0,1,0,100,0), -- 18:40:45 +(@PATH,4,3451.302,-3657.603,286.5476,0,0,1,0,100,0), -- 18:40:47 +(@PATH,5,3451.777,-3674.688,294.0381,0,0,1,0,100,0), -- 18:40:49 +(@PATH,6,3450.148,-3687.086,294.6606,0,0,1,0,100,0), -- 18:40:52 +(@PATH,7,3448.747,-3700.197,294.6606,0,0,1,0,100,0), -- 18:40:53 +(@PATH,8,3441.068,-3712.697,294.6603,0,0,1,0,100,0), -- 18:40:54 +(@PATH,9,3427.858,-3724.603,294.6606,0,0,1,0,100,0), -- 18:40:56 +(@PATH,10,3424.089,-3742.215,294.6599,0,0,1,0,100,0), -- 18:40:58 +(@PATH,11,3432.195,-3760.958,294.6607,0,0,1,0,100,0), -- 18:40:59 +(@PATH,12,3446.482,-3768.38,294.6594,0,0,1,0,100,0), -- 18:41:02 +(@PATH,13,3458.209,-3769.1,294.6591,0,0,1,0,100,0), -- 18:41:03 +(@PATH,14,3474.842,-3761.217,294.6591,0,0,1,0,100,0), -- 18:41:04 +(@PATH,15,3483.013,-3745.727,294.6602,0,0,1,0,100,0), -- 18:44:04 +(@PATH,16,3482.468,-3731.778,294.6606,0,0,1,0,100,0), -- 18:43:22 +(@PATH,17,3476.008,-3718.655,294.6598,0,0,1,0,100,0), -- 18:43:24 +(@PATH,18,3463.966,-3711.199,294.6607,0,0,1,0,100,0), -- 18:43:25 +(@PATH,19,3458.016,-3700.416,294.6607,0,0,1,0,100,0), -- 18:43:26 +(@PATH,20,3456.704,-3687.183,294.6606,0,0,1,0,100,0), -- 18:43:27 +(@PATH,21,3453.893,-3674.658,294.0241,0,0,1,0,100,0), -- 18:43:28 +(@PATH,22,3453.96,-3657.726,286.6128,0,0,1,0,100,0), -- 18:43:30 +(@PATH,23,3469.155,-3643.573,279.192,0,0,1,0,100,0), -- 18:43:32 +(@PATH,24,3470.532,-3624.281,269.0706,0,0,1,0,100,0), -- 18:43:34 +(@PATH,25,3470.325,-3607.22,267.5942,0,0,1,0,100,0), -- 18:43:37 +(@PATH,26,3451.28,-3607.224,267.5939,0,0,1,0,100,0); -- 18:43:38 +-- 0x1C3B1C42A00F9A400063AC0000019CE0 .go 3435.956 -3606.878 267.5925 + +DELETE FROM `creature_formations` WHERE `leaderGUID` IN (@NPC,@NPC+1,@NPC+2,@NPC+3,@NPC+4,@NPC+5,@NPC+6,@NPC+7); +DELETE FROM `creature_formations` WHERE `memberGUID` IN (@NPC,@NPC+1,@NPC+2,@NPC+3,@NPC+4,@NPC+5,@NPC+6,@NPC+7); +INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`,`point_1`,`point_2`) VALUES +(@NPC,@NPC,0,0,2,0,0), +(@NPC,@NPC+1,6,150,2,0,0), +(@NPC,@NPC+2,6,100,2,0,0), +(@NPC,@NPC+3,6,50,2,0,0), +(@NPC,@NPC+4,6,360,2,0,0), +(@NPC,@NPC+5,6,310,2,0,0), +(@NPC,@NPC+6,6,240,2,0,0), +(@NPC,@NPC+7,6,190,2,0,0); + +-- Pathing for Poisonous Skitterer Entry: 15977 'TDB FORMAT' +SET @NPC := 127971; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3295.49,`position_y`=-3908.793,`position_z`=294.6605 WHERE `guid` IN (@NPC,@NPC+1,@NPC+2,@NPC+3,@NPC+4,@NPC+5,@NPC+6,@NPC+7); +DELETE FROM `creature_addon` WHERE `guid` IN (@NPC,@NPC+1,@NPC+2,@NPC+3,@NPC+4,@NPC+5,@NPC+6,@NPC+7); +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(@NPC,@PATH,0,0,1,0, ''),(@NPC+1,@PATH,0,0,1,0, ''),(@NPC+2,@PATH,0,0,1,0, ''),(@NPC+3,@PATH,0,0,1,0, ''), +(@NPC+4,@PATH,0,0,1,0, ''),(@NPC+5,@PATH,0,0,1,0, ''),(@NPC+6,@PATH,0,0,1,0, ''),(@NPC+7,@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,3295.49,-3908.793,294.6605,0,0,1,0,100,0), -- 18:51:17 +(@PATH,2,3315.678,-3912.224,294.6599,0,0,1,0,100,0), -- 18:51:19 +(@PATH,3,3333.155,-3901.934,294.6607,0,0,1,0,100,0), -- 18:51:21 +(@PATH,4,3340.176,-3885.257,294.6602,0,0,1,0,100,0), -- 18:51:23 +(@PATH,5,3340.906,-3871.007,294.6597,0,0,1,0,100,0), -- 18:51:24 +(@PATH,6,3346.968,-3852.773,294.6607,0,0,1,0,100,0), -- 18:51:27 +(@PATH,7,3351.746,-3834.469,294.661,0,0,1,0,100,0), -- 18:51:28 +(@PATH,8,3355.633,-3811.367,294.6529,0,0,1,0,100,0), -- 18:51:30 +(@PATH,9,3364.557,-3793.01,294.6719,0,0,1,0,100,0), -- 18:51:33 +(@PATH,10,3373.259,-3788.029,294.6747,0,0,1,0,100,0), -- 18:51:34 +(@PATH,11,3386.617,-3791.233,294.6732,0,0,1,0,100,0), -- 18:51:35 +(@PATH,12,3403.893,-3786.905,294.6616,0,0,1,0,100,0), -- 18:51:36 +(@PATH,13,3417.919,-3780.905,294.6603,0,0,1,0,100,0), -- 18:51:39 +(@PATH,14,3435.631,-3777.892,294.6598,0,0,1,0,100,0), -- 18:51:40 +(@PATH,15,3453.584,-3770.242,294.6595,0,0,1,0,100,0), -- 18:51:41 +(@PATH,16,3473.68,-3761.83,294.6591,0,0,1,0,100,0), -- 18:51:44 +(@PATH,17,3482.105,-3748.733,294.66,0,0,1,0,100,0), -- 18:51:46 +(@PATH,18,3481.656,-3730.049,294.6605,0,0,1,0,100,0), -- 18:51:47 +(@PATH,19,3466.719,-3713.448,294.6601,0,0,1,0,100,0), -- 18:51:50 +(@PATH,20,3442.352,-3711.847,294.6607,0,0,1,0,100,0), -- 18:51:52 +(@PATH,21,3425.655,-3728.148,294.6607,0,0,1,0,100,0), -- 18:51:55 +(@PATH,22,3424.592,-3744.035,294.6601,0,0,1,0,100,0), -- 18:51:57 +(@PATH,23,3425.272,-3756.561,294.6607,0,0,1,0,100,0), -- 18:51:58 +(@PATH,24,3416.304,-3774.603,294.6607,0,0,1,0,100,0), -- 18:51:59 +(@PATH,25,3405.274,-3797.244,294.6658,0,0,1,0,100,0), -- 18:52:02 +(@PATH,26,3394.972,-3815.078,294.7111,0,0,1,0,100,0), -- 18:52:04 +(@PATH,27,3377.224,-3831.485,294.6744,0,0,1,0,100,0), -- 18:52:06 +(@PATH,28,3355.986,-3838.537,294.661,0,0,1,0,100,0), -- 18:52:08 +(@PATH,29,3337.649,-3843.212,294.6607,0,0,1,0,100,0), -- 18:52:10 +(@PATH,30,3316.94,-3850.059,294.6604,0,0,1,0,100,0), -- 18:52:13 +(@PATH,31,3304.55,-3853.525,294.6609,0,0,1,0,100,0), -- 18:52:15 +(@PATH,32,3288.827,-3861.687,294.6596,0,0,1,0,100,0), -- 18:52:16 +(@PATH,33,3281.996,-3873.274,294.6607,0,0,1,0,100,0), -- 18:52:18 +(@PATH,34,3281.982,-3891.924,294.6607,0,0,1,0,100,0); -- 18:52:19 +-- 0x1C3B1C42A00F9A400063AC0004019CE0 .go 3295.49 -3908.793 294.6605 + +DELETE FROM `creature_formations` WHERE `leaderGUID` IN (@NPC,@NPC+1,@NPC+2,@NPC+3,@NPC+4,@NPC+5,@NPC+6,@NPC+7); +DELETE FROM `creature_formations` WHERE `memberGUID` IN (@NPC,@NPC+1,@NPC+2,@NPC+3,@NPC+4,@NPC+5,@NPC+6,@NPC+7); +INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`,`point_1`,`point_2`) VALUES +(@NPC,@NPC,0,0,2,0,0), +(@NPC,@NPC+1,6,150,2,0,0), +(@NPC,@NPC+2,6,100,2,0,0), +(@NPC,@NPC+3,6,50,2,0,0), +(@NPC,@NPC+4,6,360,2,0,0), +(@NPC,@NPC+5,6,310,2,0,0), +(@NPC,@NPC+6,6,240,2,0,0), +(@NPC,@NPC+7,6,190,2,0,0); + +-- Pathing for Poisonous Skitterer Entry: 15977 'TDB FORMAT' +SET @NPC := 127923; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3445.511,`position_y`=-3562.019,`position_z`=267.5927 WHERE `guid` IN (@NPC,@NPC+1,@NPC+2,@NPC+3,@NPC+4,@NPC+5,@NPC+6,@NPC+7); +DELETE FROM `creature_addon` WHERE `guid` IN (@NPC,@NPC+1,@NPC+2,@NPC+3,@NPC+4,@NPC+5,@NPC+6,@NPC+7); +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(@NPC,@PATH,0,0,1,0, ''),(@NPC+1,@PATH,0,0,1,0, ''),(@NPC+2,@PATH,0,0,1,0, ''),(@NPC+3,@PATH,0,0,1,0, ''), +(@NPC+4,@PATH,0,0,1,0, ''),(@NPC+5,@PATH,0,0,1,0, ''),(@NPC+6,@PATH,0,0,1,0, ''),(@NPC+7,@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,3445.511,-3562.019,267.5927,0,0,1,0,100,0), -- 18:50:41 +(@PATH,2,3436.16,-3553.894,267.5926,0,0,1,0,100,0), -- 18:50:40 +(@PATH,3,3427.388,-3543.853,267.5927,0,0,1,0,100,0), -- 18:50:39 +(@PATH,4,3424.374,-3524.575,267.593,0,0,1,0,100,0), -- 18:50:36 +(@PATH,5,3430.726,-3510.367,267.5926,0,0,1,0,100,0), -- 18:50:35 +(@PATH,6,3450.23,-3500.03,267.593,0,0,1,0,100,0), -- 18:50:33 +(@PATH,7,3467.847,-3503.534,267.592,0,0,1,0,100,0), -- 18:50:32 +(@PATH,8,3476.588,-3510.952,267.5963,0,0,1,0,100,0), -- 18:50:30 +(@PATH,9,3481.654,-3519.189,267.599,0,0,1,0,100,0), -- 18:50:29 +(@PATH,10,3483.025,-3534.862,267.5939,0,0,1,0,100,0), -- 18:50:28 +(@PATH,11,3476.475,-3549.416,267.5925,0,0,1,0,100,0), -- 18:50:26 +(@PATH,12,3462.348,-3561.076,267.5923,0,0,1,0,100,0), -- 18:50:24 +(@PATH,13,3457.105,-3576.026,267.593,0,0,1,0,100,0), -- 18:50:22 +(@PATH,14,3456.484,-3596.646,267.5931,0,0,1,0,100,0), -- 18:50:21 +(@PATH,15,3456.006,-3616.097,267.5933,0,0,1,0,100,0), -- 18:50:18 +(@PATH,16,3455.418,-3633.274,273.7843,0,0,1,0,100,0), -- 18:50:17 +(@PATH,17,3455.296,-3644.975,279.9232,0,0,1,0,100,0), -- 18:50:16 +(@PATH,18,3455.71,-3658.097,286.8079,0,0,1,0,100,0), -- 18:50:13 +(@PATH,19,3454.985,-3676.887,294.6609,0,0,1,0,100,0), -- 18:50:12 +(@PATH,20,3455.906,-3694.337,294.6607,0,0,1,0,100,0), -- 18:50:10 +(@PATH,21,3467.804,-3706.619,294.66,0,0,1,0,100,0), -- 18:50:09 +(@PATH,22,3476.442,-3720.346,294.6599,0,0,1,0,100,0), -- 18:50:06 +(@PATH,23,3483.089,-3735.734,294.6605,0,0,1,0,100,0), -- 18:50:05 +(@PATH,24,3480.588,-3752.523,294.6599,0,0,1,0,100,0), -- 18:50:04 +(@PATH,25,3467.757,-3765.589,294.6591,0,0,1,0,100,0), -- 18:50:01 +(@PATH,26,3453.585,-3770.197,294.6595,0,0,1,0,100,0), -- 18:50:00 +(@PATH,27,3436.298,-3764.208,294.6599,0,0,1,0,100,0), -- 18:49:59 +(@PATH,28,3426.811,-3752.177,294.6607,0,0,1,0,100,0), -- 18:49:56 +(@PATH,29,3423.844,-3737.633,294.6601,0,0,1,0,100,0), -- 18:49:55 +(@PATH,30,3429.387,-3722.426,294.6605,0,0,1,0,100,0), -- 18:49:54 +(@PATH,31,3441.138,-3712.122,294.6603,0,0,1,0,100,0), -- 18:49:52 +(@PATH,32,3449.993,-3694.774,294.6606,0,0,1,0,100,0), -- 18:49:50 +(@PATH,33,3450.414,-3676.926,294.6604,0,0,1,0,100,0), -- 18:49:48 +(@PATH,34,3451.136,-3657.843,286.6731,0,0,1,0,100,0), -- 18:49:47 +(@PATH,35,3451.486,-3645.041,279.957,0,0,1,0,100,0), -- 18:49:46 +(@PATH,36,3451.301,-3632.746,273.5061,0,0,1,0,100,0), -- 18:49:43 +(@PATH,37,3451.295,-3615.899,267.594,0,0,1,0,100,0), -- 18:49:41 +(@PATH,38,3451.307,-3596.557,267.5931,0,0,1,0,100,0), -- 18:49:39 +(@PATH,39,3451.611,-3575.75,267.5927,0,0,1,0,100,0); -- 18:49:37 +-- 0x1C3B1C42A00F9A400063AC0008019CDF .go 3445.511 -3562.019 267.5927 + +DELETE FROM `creature_formations` WHERE `leaderGUID` IN (@NPC,@NPC+1,@NPC+2,@NPC+3,@NPC+4,@NPC+5,@NPC+6,@NPC+7); +DELETE FROM `creature_formations` WHERE `memberGUID` IN (@NPC,@NPC+1,@NPC+2,@NPC+3,@NPC+4,@NPC+5,@NPC+6,@NPC+7); +INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`,`point_1`,`point_2`) VALUES +(@NPC,@NPC,0,0,2,0,0), +(@NPC,@NPC+1,6,150,2,0,0), +(@NPC,@NPC+2,6,100,2,0,0), +(@NPC,@NPC+3,6,50,2,0,0), +(@NPC,@NPC+4,6,360,2,0,0), +(@NPC,@NPC+5,6,310,2,0,0), +(@NPC,@NPC+6,6,240,2,0,0), +(@NPC,@NPC+7,6,190,2,0,0); |