aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--sql/updates/world/2015_09_23_00_world.sql612
-rw-r--r--sql/updates/world/2015_09_23_01_world.sql155
-rw-r--r--sql/updates/world/2015_09_23_02_world.sql176
-rw-r--r--sql/updates/world/2015_09_23_03_world.sql80
-rw-r--r--src/server/worldserver/worldserver.conf.dist25
5 files changed, 1036 insertions, 12 deletions
diff --git a/sql/updates/world/2015_09_23_00_world.sql b/sql/updates/world/2015_09_23_00_world.sql
new file mode 100644
index 00000000000..5483d78b2ce
--- /dev/null
+++ b/sql/updates/world/2015_09_23_00_world.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);
diff --git a/sql/updates/world/2015_09_23_01_world.sql b/sql/updates/world/2015_09_23_01_world.sql
new file mode 100644
index 00000000000..a90442e8b5a
--- /dev/null
+++ b/sql/updates/world/2015_09_23_01_world.sql
@@ -0,0 +1,155 @@
+DELETE FROM `creature` WHERE `guid` IN (86098, 86097, 86092, 86091, 86090, 86088, 86089, 86087, 86086, 86085);
+
+-- Pathing for Dragonmaw Shaman Entry: 21720 'TDB FORMAT'
+SET @NPC := 75806;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4178.686,`position_y`=490.5659,`position_z`=30.16439 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,-4178.686,490.5659,30.16439,0,0,0,0,100,0), -- 10:20:24
+(@PATH,2,-4197.292,485.9068,30.38932,0,0,0,0,100,0), -- 10:20:35
+(@PATH,3,-4225.723,467.5575,41.27721,0,0,0,0,100,0), -- 10:20:44
+(@PATH,4,-4215.874,436.8994,48.21687,0,0,0,0,100,0), -- 10:20:57
+(@PATH,5,-4237.429,402.9925,63.27236,0,0,0,0,100,0), -- 10:21:13
+(@PATH,6,-4257.311,375.9668,78.98435,0,0,0,0,100,0), -- 10:21:30
+(@PATH,7,-4218.265,427.3583,49.21005,0,0,0,0,100,0), -- 10:21:59
+(@PATH,8,-4226.337,464.256,42.97073,0,0,0,0,100,0), -- 10:22:17
+(@PATH,9,-4205.016,481.8601,31.38265,0,0,0,0,100,0), -- 10:22:32
+(@PATH,10,-4193.525,487.0911,30.10522,0,0,0,0,100,0), -- 10:22:46
+(@PATH,11,-4172.567,476.759,31.17034,0,0,0,0,100,0), -- 10:22:55
+(@PATH,12,-4151.987,448.1165,33.53831,0,0,0,0,100,0), -- 10:23:06
+(@PATH,13,-4113.85,424.8085,34.97233,0,0,0,0,100,0), -- 10:23:18
+(@PATH,14,-4147.163,444.2449,34.1104,0,0,0,0,100,0), -- 10:23:38
+(@PATH,15,-4157.673,454.7521,31.41072,0,0,0,0,100,0); -- 10:23:57
+
+-- Pathing for Dragonmaw Shaman Entry: 21720 'TDB FORMAT'
+SET @NPC := 75803;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4294.086,`position_y`=400.621,`position_z`=81.62926 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,233, '');
+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,-4294.086,400.621,81.62926,0,25000,0,0,100,0), -- 10:13:30
+(@PATH,2,-4292.586,399.621,81.62926,0,25000,0,0,100,0); -- 10:13:50
+
+-- Pathing for Dragonmaw Shaman Entry: 21720 'TDB FORMAT'
+SET @NPC := 75798;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4244.082,`position_y`=315.9884,`position_z`=134.664 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,-4244.082,315.9884,134.664,0,0,0,0,100,0), -- 10:12:22
+(@PATH,2,-4235.726,319.797,134.6712,0,0,0,0,100,0), -- 10:12:25
+(@PATH,3,-4229.505,315.7428,134.6895,0,0,0,0,100,0), -- 10:12:28
+(@PATH,4,-4194.724,303.9587,136.7709,0,0,0,0,100,0), -- 10:12:30
+(@PATH,5,-4190.966,294.0813,135.7594,0,0,0,0,100,0), -- 10:12:45
+(@PATH,6,-4183.756,287.0773,135.6553,0,0,0,0,100,0), -- 10:14:20
+(@PATH,7,-4191.174,297.8928,136.033,0,0,0,0,100,0), -- 10:14:26
+(@PATH,8,-4220.702,310.0533,134.9795,0,0,0,0,100,0), -- 10:14:30
+(@PATH,9,-4229.358,315.7001,134.6958,0,0,0,0,100,0), -- 10:14:45
+(@PATH,10,-4230.426,317.3666,134.676,0,0,0,0,100,0), -- 10:14:48
+(@PATH,11,-4235.935,319.6286,134.6698,0,0,0,0,100,0), -- 10:14:50
+(@PATH,12,-4255.562,318.7018,134.6108,0,0,0,0,100,0), -- 10:14:54
+(@PATH,13,-4249.844,317.125,134.6809,0,0,0,0,100,0), -- 10:15:00
+(@PATH,14,-4243.675,313.4105,134.6629,0,0,0,0,100,0), -- 10:15:06
+(@PATH,15,-4235.89,308.923,134.6676,0,0,0,0,100,0), -- 10:15:08
+(@PATH,16,-4230.517,310.4198,134.6871,0,0,0,0,100,0), -- 10:15:11
+(@PATH,17,-4194.894,303.7994,136.77,0,0,0,0,100,0), -- 10:15:14
+(@PATH,18,-4188.841,309.6393,135.933,0,0,0,0,100,0), -- 10:15:29
+(@PATH,19,-4175.213,316.2365,135.7092,0,0,0,0,100,0), -- 10:15:34
+(@PATH,20,-4161.508,360.043,141.9081,0,0,0,0,100,0), -- 10:15:40
+(@PATH,21,-4171.737,320.0564,135.9073,0,0,0,0,100,0), -- 10:16:01
+(@PATH,22,-4185.639,313.6697,135.3489,0,0,0,0,100,0), -- 10:16:20
+(@PATH,23,-4191.21,305.0679,136.4015,0,0,0,0,100,0), -- 10:16:26
+(@PATH,24,-4220.617,309.9903,134.8077,0,0,0,0,100,0), -- 10:16:31
+(@PATH,25,-4229.755,310.8228,134.6904,0,0,0,0,100,0), -- 10:16:45
+(@PATH,26,-4235.208,308.5773,134.6808,0,0,0,0,100,0), -- 10:16:48
+(@PATH,27,-4243.492,313.3849,134.6674,0,0,0,0,100,0), -- 10:16:51
+(@PATH,28,-4255.519,318.5628,134.6098,0,0,0,0,100,0), -- 10:16:54
+(@PATH,29,-4249.62,317.301,134.6521,0,0,0,0,100,0); -- 10:17:00
+
+-- Pathing for Dragonmaw Shaman Entry: 21720 'TDB FORMAT'
+SET @NPC := 75801;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4263.521,`position_y`=408.381,`position_z`=79.67068 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,-4263.521,408.381,79.67068,0,0,0,0,100,0), -- 10:12:48
+(@PATH,2,-4275.601,391.1442,81.45609,0,0,0,0,100,0), -- 10:13:03
+(@PATH,3,-4276.916,384.2662,79.99209,0,0,0,0,100,0), -- 10:13:13
+(@PATH,4,-4272.852,367.3383,83.40826,0,0,0,0,100,0), -- 10:13:19
+(@PATH,5,-4299.143,333.1703,109.8589,0,0,0,0,100,0), -- 10:13:24
+(@PATH,6,-4291.638,298.5769,121.6239,0,0,0,0,100,0), -- 10:13:44
+(@PATH,7,-4284.62,294.5884,122.3762,0,0,0,0,100,0), -- 10:14:00
+(@PATH,8,-4265.867,286.0486,122.6935,0,0,0,0,100,0), -- 10:14:11
+(@PATH,9,-4231.655,272.0292,122.6157,0,0,0,0,100,0), -- 10:14:22
+(@PATH,10,-4221.664,271.404,122.5952,0,0,0,0,100,0), -- 10:14:30
+(@PATH,11,-4221.826,271.2171,122.3309,0,0,0,0,100,0), -- 10:14:42
+(@PATH,12,-4241.433,272.7845,122.9299,0,0,0,0,100,0), -- 10:14:50
+(@PATH,13,-4243.721,273.0889,123.1742,0,0,0,0,100,0), -- 10:15:00
+(@PATH,14,-4287.71,296.0865,122.0869,0,0,0,0,100,0), -- 10:15:09
+(@PATH,15,-4299.358,330.6028,110.9833,0,0,0,0,100,0), -- 10:15:20
+(@PATH,16,-4274.684,364.696,85.32684,0,0,0,0,100,0), -- 10:15:36
+(@PATH,17,-4269.528,373.963,80.26889,0,0,0,0,100,0), -- 10:15:57
+(@PATH,18,-4276.889,385.2,79.98441,0,0,0,0,100,0); -- 10:16:01
+
+-- Dragonmaw Subjugator SAI
+SET @ENTRY := 21718;
+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,1,0,100,1,0,0,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonmaw Subjugator - Out of Combat - Enable Combat Movement (No Repeat)"),
+(@ENTRY,0,1,2,4,0,100,1,0,0,0,0,11,9613,0,0,0,0,0,2,0,0,0,0,0,0,0,"Dragonmaw Subjugator - On Aggro - Cast 'Shadow Bolt' (No Repeat)"),
+(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonmaw Subjugator - On Aggro - Increment Phase By 1 (No Repeat)"),
+(@ENTRY,0,3,0,9,1,100,0,0,40,2400,3800,11,9613,0,0,0,0,0,2,0,0,0,0,0,0,0,"Dragonmaw Subjugator - Within 0-40 Range - Cast 'Shadow Bolt' (No Repeat)"),
+(@ENTRY,0,4,5,3,1,100,1,0,15,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonmaw Subjugator - Between 0-15% Mana - Enable Combat Movement (Phase 1) (No Repeat)"),
+(@ENTRY,0,5,0,61,1,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonmaw Subjugator - Between 0-15% Mana - Increment Phase By 1 (Phase 1) (No Repeat)"),
+(@ENTRY,0,6,0,9,1,100,1,35,80,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonmaw Subjugator - Within 35-80 Range - Enable Combat Movement (Phase 1) (No Repeat)"),
+(@ENTRY,0,7,0,9,1,100,1,5,15,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonmaw Subjugator - Within 5-15 Range - Disable Combat Movement (Phase 1) (No Repeat)"),
+(@ENTRY,0,8,0,9,1,100,1,0,5,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonmaw Subjugator - Within 0-5 Range - Enable Combat Movement (Phase 1) (No Repeat)"),
+(@ENTRY,0,9,0,3,2,100,0,30,100,100,100,23,0,1,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonmaw Subjugator - Between 30-100% Mana - Decrement Phase By 1 (Phase 1) (No Repeat)"),
+(@ENTRY,0,10,11,2,0,100,1,0,15,0,0,22,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonmaw Subjugator - Between 0-15% Health - Set Event Phase 3 (No Repeat)"),
+(@ENTRY,0,11,12,61,0,100,0,0,0,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonmaw Subjugator - Between 0-15% Health - Enable Combat Movement (No Repeat)"),
+(@ENTRY,0,12,0,61,0,100,0,0,0,0,0,25,1,0,0,0,0,0,0,0,0,0,0,0,0,0,"Dragonmaw Subjugator - Between 0-15% Health - Flee For Assist (No Repeat)"),
+(@ENTRY,0,13,0,6,0,100,1,0,0,0,0,33,22197,0,0,0,0,0,7,0,0,0,0,0,0,0,"Dragonmaw Subjugator - On Just Died - Quest Credit 'Infiltrating Dragonmaw Fortress' (No Repeat)");
+
+-- Pathing for Dragonmaw Subjugator Entry: 21718 'TDB FORMAT'
+SET @NPC := 75774;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4102.015,`position_y`=377.2606,`position_z`=30.89463 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,-4102.015,377.2606,30.89463,0,0,0,0,100,0), -- 10:20:43
+(@PATH,2,-4108.736,382.3355,30.58962,0,0,0,0,100,0), -- 10:20:47
+(@PATH,3,-4115.181,384.7361,30.83398,0,0,0,0,100,0), -- 10:20:49
+(@PATH,4,-4115.945,392.739,30.79796,0,0,0,0,100,0), -- 10:20:53
+(@PATH,5,-4111.743,392.8836,30.53397,0,0,0,0,100,0), -- 10:20:54
+(@PATH,6,-4106.752,389.3356,30.54209,0,0,0,0,100,0), -- 10:20:57
+(@PATH,7,-4103.535,395.7037,30.67706,0,0,0,0,100,0), -- 10:21:00
+(@PATH,8,-4103.445,396.1037,30.62162,0,0,0,0,100,0), -- 10:21:02
+(@PATH,9,-4099.806,402.0006,30.79059,0,0,0,0,100,0), -- 10:21:14
+(@PATH,10,-4099.44,401.964,30.87934,0,0,0,0,100,0), -- 10:21:15
+(@PATH,11,-4086.569,405.2619,30.82691,0,0,0,0,100,0), -- 10:21:21
+(@PATH,12,-4089.497,392.9045,30.76514,0,0,0,0,100,0), -- 10:21:26
+(@PATH,13,-4089.03,381.2375,31.16474,0,0,0,0,100,0), -- 10:21:31
+(@PATH,14,-4091.608,379.7381,30.97511,0,0,0,0,100,0); -- 10:21:33
+
+-- Pathing for Dragonmaw Subjugator Entry: 21718 'TDB FORMAT'
+SET @NPC := 75780;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4192.549,`position_y`=463.3147,`position_z`=30.76653 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,-4192.549,463.3147,30.76653,0,0,0,0,100,0), -- 10:21:58
+(@PATH,2,-4188.431,467.3629,30.58786,0,0,0,0,100,0); -- 10:22:00
diff --git a/sql/updates/world/2015_09_23_02_world.sql b/sql/updates/world/2015_09_23_02_world.sql
new file mode 100644
index 00000000000..fa89371371d
--- /dev/null
+++ b/sql/updates/world/2015_09_23_02_world.sql
@@ -0,0 +1,176 @@
+--
+SET @GUID1 := -78496;
+SET @GUID2 := -52330;
+UPDATE `creature` SET `position_x`= -4236.136230, `position_y`= 313.865417, `position_z`= 160.389038, `orientation`= 3.5595 WHERE `guid`= 78496;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry` IN (22317, 23188, 22253);
+UPDATE `creature_template` SET `InhabitType`= 4 WHERE `entry`=23225;
+DELETE FROM `creature` WHERE `guid` IN (132815, 132816, 132817) AND `id`=23188; -- remove wrong spawns
+UPDATE `smart_scripts` SET `event_type`=25 WHERE `entryorguid`=23311 AND `source_type`=0 AND `id`=11; -- Fix an aura set by spawn instead of reset
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@GUID1, -52330, 23188, 22253) AND `source_type`=0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (22317*100, 22317*100+1, 22317*100+2, 2318800, 2318801, 2318802, 2318803, 22253*100) 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
+(@GUID1,0,0,0,1,0,100,0,2000,4000,12000,16000,12,23188,7,0,0,0,0,8,0,0,0,-4236.136230, 313.865417, 160.389038, 3.9795,"Netherwing Drake Escape Dummy - OOC - Summon Creature 'Dragonmaw Transporter'"),
+(@GUID1,0,1,0,63,0,100,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Netherwing Drake Escape Dummy - Just created - Set active"),
+(23188,0,0,0,54,0,100,0,0,0,0,0,87,2318800,2318801,2318802,0,0,0,1,0,0,0,0,0,0,0,"Dragonmaw Transporter - Just summoned - action list"),
+(2318800,9,0,0,0,0,100,0,0,0,0,0,53,1,231880,0,0,0,2,1,0,0,0,0,0,0,0,"Dragonmaw Transporter - Action list - Start Waypoint"),
+(2318800,9,1,0,0,0,100,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonmaw Transporter - Action list - Set Active On"),
+(2318801,9,0,0,0,0,100,0,0,0,0,0,53,1,231881,0,0,0,2,1,0,0,0,0,0,0,0,"Dragonmaw Transporter - Action list - Start Waypoint"),
+(2318801,9,1,0,0,0,100,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonmaw Transporter - Action list - Set Active On"),
+(2318802,9,0,0,0,0,100,0,0,0,0,0,53,1,231882,0,0,0,2,1,0,0,0,0,0,0,0,"Dragonmaw Transporter - Action list - Start Waypoint"),
+(2318802,9,1,0,0,0,100,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonmaw Transporter - Action list - Set Active On"),
+(23188,0,1,0,58,0,100,0,27,231880,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonmaw Transporter - On Waypoint Finished - Despawn Instant"),
+(23188,0,2,0,58,0,100,0,31,231881,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonmaw Transporter - On Waypoint Finished - Despawn Instant"),
+(23188,0,3,0,58,0,100,0,25,231882,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonmaw Transporter - On Waypoint Finished - Despawn Instant"),
+(23188,0,4,0,58,0,100,0,26,231883,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonmaw Transporter - On Waypoint Finished - Despawn Instant"),
+(22253, 0, 0, 0, 0, 0, 100, 0, 3000, 5000, 7000, 7000, 11, 15496, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Dragonmaw Ascendant - IC - Cast Cleave"),
+(22253, 0, 1, 0, 0, 0, 100, 0, 5000, 7000, 8000, 10000, 11, 17547, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Dragonmaw Ascendant - IC - Cast Mortal Strike"),
+(22253, 0, 2, 0, 0, 0, 100, 0, 4000, 7000, 9000, 12000, 11, 10966, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Dragonmaw Ascendant - IC - Cast Uppercut"),
+(@GUID2, 0, 0, 0, 0, 0, 100, 0, 3000, 5000, 7000, 7000, 11, 15496, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Dragonmaw Ascendant - IC - Cast Cleave"),
+(@GUID2, 0, 1, 0, 0, 0, 100, 0, 5000, 7000, 8000, 10000, 11, 17547, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Dragonmaw Ascendant - IC - Cast Mortal Strike"),
+(@GUID2, 0, 2, 0, 0, 0, 100, 0, 4000, 7000, 9000, 12000, 11, 10966, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Dragonmaw Ascendant - IC - Cast Uppercut"),
+(@GUID2,0,3,0,1,0,100,0,2000,5000,12000,16000,12,23188,7,0,0,0,0,8,0,0,0,-4933.316895, 31.134706, 61.772137, 0.480736,"Dragonmaw Ascendant - OOC - Summon Creature 'Dragonmaw Transporter'"),
+(@GUID2,0,4,0,63,0,100,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonmaw Ascendant - Just created - Set active"),
+(23188,0,5,0,54,0,100,0,0,0,0,0,80,2318803,2,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonmaw Transporter - Just summoned - action list"),
+(2318803,9,0,0,0,0,100,0,0,0,0,0,53,1,231883,0,0,0,2,1,0,0,0,0,0,0,0,"Dragonmaw Transporter - action list - Start Waypoint"),
+(2318803,9,1,0,0,0,100,0,0,0,0,0,48,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dragonmaw Transporter - action list - Set Active On"),
+(23188, 0, 6, 0, 0, 0, 100, 0, 3000, 5000, 7000, 7000, 11, 38861, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Dragonmaw Transporter- IC - Aimed Shot"),
+(23188, 0, 7, 0, 0, 0, 100, 0, 5000, 7000, 8000, 10000, 11, 19503, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Dragonmaw Transporter - IC - Scatter Shot"),
+(23188, 0, 8, 0, 0, 0, 100, 0, 4000, 7000, 9000, 12000, 11, 38859, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Dragonmaw Transporter - IC - Serpent Sting"),
+(23188, 0, 9, 0, 0, 0, 100, 0, 1000, 2000, 3000, 4000, 11, 38858, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Dragonmaw Transporter - IC - Shoot");
+
+DELETE FROM conditions WHERE SourceTypeOrReferenceId=22 AND SourceEntry=23188;
+INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorTextId, ScriptName, Comment) VALUES
+(22, 1, 23188, 0, 0, 23, 0, 3939, 0, 0, 0, 0, '', 'Execute SmartAI for Dragonmaw Transporter if the area is 3759'),
+(22, 6, 23188, 0, 0, 23, 0, 3759, 0, 0, 0, 0, '', 'Execute SmartAI for Dragonmaw Transporter if the area is 3759');
+
+SET @PATH := 231880;
+DELETE FROM `waypoints` WHERE `entry`=@PATH;
+INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
+(@PATH,1,-4234.259,316.7951,194.5695, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,2,-4278.778,291.9364,162.6098, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,3,-4315.755,272.5735,162.6098, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,4,-4332.82,267.5372,162.6098, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,5,-4354.233,260.8795,162.6098, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,6,-4391.55,249.5022,162.6098, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,7,-4429.059,238.4517,162.6098, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,8,-4470.008,227.2337,162.6098, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,9,-4489.761,222.9549,162.6098, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,10,-4502.434,220.6088,162.6098, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,11,-4528.817,218.5281,162.6098, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,12,-4546.15,218.6741,162.6098, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,13,-4595.704,217.5207,162.6098, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,14,-4641.978,205.2794,147.0265, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,15,-4662.014,198.3955,118.6931, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,16,-4686.042,195.7724,92.6098, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,17,-4720.744,183.9892,92.33202, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,18,-4745.649,173.8856,98.19311, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,19,-4756.257,154.736,105.7487, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,20,-4761.057,143.5172,108.3876, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,21,-4787.247,129.8356,110.6098, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,22,-4815.383,124.4918,109.6376, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,23,-4841.104,99.13585,116.1653, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,24,-4876.217,68.20888,99.16536, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,25,-4887.112,56.80024,92.74867, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,26,-4921.727,36.11827,73.94312, 'Dragonmaw Transporter'), -- 07:14:59
+(@PATH,27,-4924.737,36.20354,61.87088, 'Dragonmaw Transporter'); -- 07:14:59
+-- 0x1C09FC424016A500000019000022323C .go -4234.259 316.7951 194.5695
+
+-- Pathing for Dragonmaw Transporter Entry: 23188 'TDB FORMAT'
+SET @PATH := 231881;
+DELETE FROM `waypoints` WHERE `entry`=@PATH;
+INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
+(@PATH,1,-4235.772,310.6806,195.9172, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,2,-4266.868,305.2986,170.0554, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,3,-4289.381,299.2866,169.0554, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,4,-4313.463,296.8451,169.0554, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,5,-4334.991,295.7913,169.0554, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,6,-4355.52,290.1741,169.0554, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,7,-4382.983,278.409,169.0554, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,8,-4419.237,271.8036,169.0554, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,9,-4448.44,268.7892,169.0554, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,10,-4463.974,265.9718,169.0554, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,11,-4486.522,265.1359,165.4998, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,12,-4515.319,266.4659,154.3332, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,13,-4538.145,266.9955,143.7777, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,14,-4565.51,267.0066,134.7498, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,15,-4574.724,266.6996,130.4999, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,16,-4585.344,265.8585,125.2221, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,17,-4610.452,266.8059,114.0276, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,18,-4648.119,265.0245,89.41651, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,19,-4679.999,264.3499,80.02769, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,20,-4726.6,265.6508,91.11095, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,21,-4757.61,263.9644,96.61092, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,22,-4790.494,252.6213,107.7221, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,23,-4830.46,243.5237,113.6109, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,24,-4850.946,232.3608,114.611, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,25,-4865.539,204.393,115.9165, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,26,-4867.515,184.822,112.5276, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,27,-4869.98,147.345,96.99986, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,28,-4875.779,115.5371,89.69432, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,29,-4900.512,79.47276,79.22215, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,30,-4920.873,41.16504,69.30544, 'Dragonmaw Transporter'), -- 07:15:20
+(@PATH,31,-4924.737,36.20354,61.87088, 'Dragonmaw Transporter'); -- 07:15:20
+-- 0x1C09FC424016A5000000190000223259 .go -4235.772 310.6806 195.9172
+
+-- Pathing for Dragonmaw Transporter Entry: 23188 'TDB FORMAT'
+SET @PATH := 231882;
+DELETE FROM `waypoints` WHERE `entry`=@PATH;
+INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
+(@PATH,1,-4235.186,312.622,195.6112, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,2,-4234.272,312.2153,195.6112, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,3,-4293.566,245.1756,179.3634, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,4,-4305.508,238.4082,179.3634, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,5,-4329.843,217.8027,179.3634, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,6,-4362.729,186.0796,186.419, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,7,-4434.846,123.756,230.3912, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,8,-4459.073,85.18902,233.9189, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,9,-4482.534,56.35666,232.5023, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,10,-4493.029,34.64518,235.1689, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,11,-4503.293,2.772352,232.5856, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,12,-4536.873,-16.30306,224.7523, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,13,-4579.444,-18.38878,223.5301, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,14,-4611.417,9.642578,219.03, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,15,-4660.565,11.25814,228.7522, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,16,-4698.878,14.15853,227.3911, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,17,-4734.97,25.07422,223.0023, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,18,-4766.538,46.62153,220.8356, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,19,-4794.966,67.12045,197.8634, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,20,-4815.075,72.55089,183.6967, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,21,-4855.917,67.18316,133.6689, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,22,-4868.51,61.47526,116.2801, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,23,-4890.089,51.30317,92.11338, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,24,-4922.806,35.50499,72.91895, 'Dragonmaw Transporter'), -- 07:18:37
+(@PATH,25,-4924.737,36.20354,61.87088, 'Dragonmaw Transporter'); -- 07:18:37
+-- 0x1C09FC424016A50000001900002232FF .go -4235.186 312.622 195.6112
+
+-- Pathing for Dragonmaw Transporter Entry: 23188 'TDB FORMAT'
+SET @PATH := 231883;
+DELETE FROM `waypoints` WHERE `entry`=@PATH;
+INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
+(@PATH,1,-4921.116,38.40239,62.79848, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,2,-4920.266,38.92785,62.79848, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,3,-4911.522,44.50662,65.54009, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,4,-4897.991,49.12988,69.23454, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,5,-4854.699,71.66743,69.23454, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,6,-4811.554,91.95888,69.23454, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,7,-4782.642,107.2382,69.23454, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,8,-4749.689,123.6898,102.4568, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,9,-4717.377,120.1987,102.5401, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,10,-4677.343,111.8249,122.37344, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,11,-4642.299,106.9923,122.62343, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,12,-4595.685,101.0696,122.23454, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,13,-4568.682,107.7912,122.23454, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,14,-4532.451,105.1658,122.23454, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,15,-4502.495,109.315,122.23454, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,16,-4478.215,118.6488,122.23454, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,17,-4437.049,132.6271,122.23454, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,18,-4401.484,131.5858,122.23454, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,19,-4360.693,156.9551,122.37343, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,20,-4324.191,184.9894,122.9568, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,21,-4299.081,216.2382,141.7901, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,22,-4292.715,227.4521,179.9077, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,23,-4281.613,263.6761,179.9077, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,24,-4260.6,294.3777,179.9077, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,25,-4240.507,326.8979,154.0465, 'Dragonmaw Transporter'), -- 07:15:14
+(@PATH,26,-4240.507,326.8979,154.0465, 'Dragonmaw Transporter'); -- 07:15:14
+-- 0x1C09FC424016A5000000190000223269 .go -4921.116 38.40239 62.79848
diff --git a/sql/updates/world/2015_09_23_03_world.sql b/sql/updates/world/2015_09_23_03_world.sql
new file mode 100644
index 00000000000..7a241bafd41
--- /dev/null
+++ b/sql/updates/world/2015_09_23_03_world.sql
@@ -0,0 +1,80 @@
+--
+SET @DredgeWorm:= 8925;
+SET @DeepStinger:= 8926;
+SET @DarkScreecher:= 8927;
+SET @Burrowing:= 8928;
+SET @Creeper:= 8933;
+SET @Beetle:= 8932;
+SET @Gorosh:= 9027;
+SET @Grizzle:= 9028;
+SET @Eviscerator:= 9029;
+SET @Okthor:= 9030;
+SET @Anubshiah:= 9031;
+SET @Hedrum:= 9032;
+
+UPDATE `creature_template` SET `AIName`="SmartAI", `ScriptName`='' WHERE `entry` IN (@DredgeWorm, @DeepStinger, @DarkScreecher, @Burrowing, @Creeper, @Beetle, @Gorosh, @Grizzle, @Eviscerator, @Okthor, @Anubshiah, @Hedrum);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@DredgeWorm, @DeepStinger, @DarkScreecher, @Burrowing, @Creeper, @Beetle, @Gorosh, @Grizzle, @Eviscerator, @Okthor, @Anubshiah, @Hedrum) 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
+(@DredgeWorm,0,0,0,54,0,100,0,0,0,0,0,49,0,0,0,0,0,0,21,100,0,0,0,0,0,0,"@DredgeWorm - Just summoned - Start Attack"),
+(@DeepStinger,0,0,0,54,0,100,0,0,0,0,0,49,0,0,0,0,0,0,21,100,0,0,0,0,0,0,"@DredgeWorm - Just summoned - Start Attack"),
+(@DarkScreecher,0,0,0,54,0,100,0,0,0,0,0,49,0,0,0,0,0,0,21,100,0,0,0,0,0,0,"@DredgeWorm - Just summoned - Start Attack"),
+(@Burrowing,0,0,0,54,0,100,0,0,0,0,0,49,0,0,0,0,0,0,21,100,0,0,0,0,0,0,"@DredgeWorm - Just summoned - Start Attack"),
+(@Creeper,0,0,0,54,0,100,0,0,0,0,0,49,0,0,0,0,0,0,21,100,0,0,0,0,0,0,"@DredgeWorm - Just summoned - Start Attack"),
+(@Beetle,0,0,0,54,0,100,0,0,0,0,0,49,0,0,0,0,0,0,21,100,0,0,0,0,0,0,"@DredgeWorm - Just summoned - Start Attack"),
+(@Gorosh,0,0,0,54,0,100,0,0,0,0,0,49,0,0,0,0,0,0,21,100,0,0,0,0,0,0,"@DredgeWorm - Just summoned - Start Attack"),
+(@Grizzle,0,0,0,54,0,100,0,0,0,0,0,49,0,0,0,0,0,0,21,100,0,0,0,0,0,0,"@DredgeWorm - Just summoned - Start Attack"),
+(@Eviscerator,0,0,0,54,0,100,0,0,0,0,0,49,0,0,0,0,0,0,21,100,0,0,0,0,0,0,"@DredgeWorm - Just summoned - Start Attack"),
+(@Okthor,0,0,0,54,0,100,0,0,0,0,0,49,0,0,0,0,0,0,21,100,0,0,0,0,0,0,"@DredgeWorm - Just summoned - Start Attack"),
+(@Anubshiah,0,0,0,54,0,100,0,0,0,0,0,49,0,0,0,0,0,0,21,100,0,0,0,0,0,0,"@DredgeWorm - Just summoned - Start Attack"),
+(@Hedrum,0,0,0,54,0,100,0,0,0,0,0,49,0,0,0,0,0,0,21,100,0,0,0,0,0,0,"@DredgeWorm - Just summoned - Start Attack"),
+(@DredgeWorm,0,1,0,0,0,100,0,3000,4000,10000,15000,11,14535,0,0,0,0,0,5,0,0,0,0,0,0,0,"Dredge Worm - In Combat - Cast Dredge Sickness"),
+(@DredgeWorm,0,2,0,0,0,100,0,4000,4000,8000,8000,11,13298,32,0,0,0,0,5,0,0,0,0,0,0,0,"Dredge Worm - In Combat - Cast Poison"),
+(@DredgeWorm,0,3,0,0,0,100,0,5000,6000,3000,3000,11,6917,0,0,0,0,0,5,0,0,0,0,0,0,0,"Dredge Worm - In Combat - Cast Venom Spit)"),
+(@DeepStinger,0,1,0,0,0,100,0,2000,2000,6000,8000,11,14534,0,0,0,0,0,5,0,0,0,0,0,0,0,"Deep Stinger - In Combat - Cast Barbed Sting"),
+(@DeepStinger,0,2,0,0,0,100,0,4000,4000,4000,4000,11,40504,0,0,0,0,0,2,0,0,0,0,0,0,0,"Deep Stinger - In Combat - Cast Cleave"),
+(@DarkScreecher,0,1,0,0,0,100,0,2000,2000,6000,8000,11,14538,0,0,0,0,0,5,0,0,0,0,0,0,0,"Dark Screecher - In Combat - Cast Aural Shock"),
+(@DarkScreecher,0,2,0,0,0,100,0,4000,4000,9000,10000,11,8281,0,0,0,0,0,5,0,0,0,0,0,0,0,"Dark Screecher - In Combat - Cast Sonic Burst"),
+(@Burrowing,0,1,0,0,0,100,0,2000,2000,30000,30000,11,14533,0,0,0,0,0,5,0,0,0,0,0,0,0,"Burrowing Thundersnout - In Combat - Cast Disjonction"),
+(@Burrowing,0,2,0,0,0,100,0,3000,3000,3000,3000,11,15611,0,0,0,0,0,5,0,0,0,0,0,0,0,"Burrowing Thundersnout - In Combat - Cast Lizard Bolt"),
+(@Burrowing,0,3,0,0,0,100,0,5000,5000,8000,8000,11,15548,0,0,0,0,0,5,0,0,0,0,0,0,0,"Burrowing Thundersnout - In Combat - Cast Thunderclap"),
+(@Creeper,0,1,0,0,0,100,0,2000,2000,20000,20000,11,14532,0,0,0,0,0,5,0,0,0,0,0,0,0,"Cave Creeper - In Combat - Cast Creeper Venom"),
+(@Creeper,0,2,0,0,0,100,0,4000,4000,8000,8000,11,745,0,0,0,0,0,2,0,0,0,0,0,0,0,"Cave Creeper - In Combat - Cast Web"),
+(@Creeper,0,3,0,0,0,100,0,5000,6000,4000,8000,11,15656,0,0,0,0,0,5,0,0,0,0,0,0,0,"Cave Creeper - In Combat - Cast Poisonous Stab"),
+(@Beetle,0,1,0,0,0,100,0,2000,2000,30000,30000,11,14539,0,0,0,0,0,2,0,0,0,0,0,0,0,"Borer Beetle - In Combat - Cast Putrid Enzyme"),
+(@Beetle,0,2,0,0,0,100,0,4000,4000,15000,20000,11,6016,0,0,0,0,0,5,0,0,0,0,0,0,0,"Borer Beetle - In Combat - Cast Pierce Armor"),
+(@Gorosh,0,1,0,0,0,100,0,2000,4000,6000,8000,11,13736,0,0,0,0,0,2,0,0,0,0,0,0,0,"Gorosh the Dervish - In Combat - Cast Whirlwind"),
+(@Gorosh,0,2,0,0,0,100,0,4000,6000,5000,6000,11,15708,0,0,0,0,0,2,0,0,0,0,0,0,0,"Gorosh the Dervish - In Combat - Cast Mortal Strike"),
+(@Gorosh,0,3,0,0,0,100,1,10000,15000,10000,15000,11,21049,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gorosh the Dervish - In Combat - Cast Bloodlust"),
+(@Grizzle,0,1,0,0,0,100,0,2000,3000,4000,5000,11,40504,0,0,0,0,0,2,0,0,0,0,0,0,0,"Grizzle the Dervish - In Combat - Cast Cleave"),
+(@Grizzle,0,2,0,0,0,100,0,4000,5000,8000,9000,11,6524,0,0,0,0,0,2,0,0,0,0,0,0,0,"Grizzle the Dervish - In Combat - Cast Ground Tremor"),
+(@Grizzle,0,3,0,0,0,100,1,10000,15000,10000,15000,11,8269,0,0,0,0,0,1,0,0,0,0,0,0,0,"Grizzle the Dervish - In Combat - Cast Frenzy"),
+(@Grizzle,0,4,0,0,0,100,0,6000,7000,6000,9000,11,24458,0,0,0,0,0,5,0,0,0,0,0,0,0,"Grizzle the Dervish - In Combat - Cast Shadow Shock"),
+(@Eviscerator,0,1,0,0,0,100,0,2000,3000,14000,15000,11,14331,0,0,0,0,0,2,0,0,0,0,0,0,0,"Eviscerator - In Combat - Cast Vicious Rend"),
+(@Eviscerator,0,2,0,0,0,100,0,4000,5000,4000,5000,11,15245,0,0,0,0,0,2,0,0,0,0,0,0,0,"Eviscerator - In Combat - Cast Shadow Bolt Volley"),
+(@Eviscerator,0,3,0,0,0,100,0,5000,6000,15000,16000,11,8269,0,0,0,0,0,1,0,0,0,0,0,0,0,"Eviscerator - In Combat - Cast Anti-Magic Shield"),
+(@Okthor,0,1,0,0,0,100,0,2000,3000,4000,5000,11,15254,0,0,0,0,0,2,0,0,0,0,0,0,0,"Okthor - In Combat - Cast Arcane Bolt"),
+(@Okthor,0,2,0,0,0,100,0,5000,6000,6000,7000,11,15453,0,0,0,0,0,2,0,0,0,0,0,0,0,"Okthor - In Combat - Cast Arcane Explosion"),
+(@Okthor,0,3,0,0,0,100,0,9000,11000,11000,12000,11,13323,0,0,0,0,0,5,0,0,0,0,0,0,0,"Okthor - In Combat - Cast Polymorph"),
+(@Okthor,0,4,0,0,0,100,0,7000,8000,9000,10000,11,13747,0,0,0,0,0,5,0,0,0,0,0,0,0,"Okthor - In Combat - Cast Slow"),
+(@Anubshiah,0,1,0,0,0,100,0,5000,7000,10000,11000,11,8994,0,0,0,0,0,5,0,0,0,0,0,0,0,"Anubshiah - In Combat - Cast Banish"),
+(@Anubshiah,0,2,0,0,0,100,0,2000,3000,8000,9000,11,15470,0,0,0,0,0,5,0,0,0,0,0,0,0,"Anubshiah - In Combat - Cast Curse of Tongues"),
+(@Anubshiah,0,3,0,0,0,100,0,4000,5000,13000,15000,11,12493,0,0,0,0,0,5,0,0,0,0,0,0,0,"Anubshiah - In Combat - Cast Curse of Weakness"),
+(@Anubshiah,0,4,0,0,0,100,0,1000,1000,300000,300000,11,13787,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anubshiah - In Combat - Cast Demon Armor"),
+(@Anubshiah,0,5,0,0,0,100,0,7000,8000,10000,13000,11,15471,0,0,0,0,0,5,0,0,0,0,0,0,0,"Anubshiah - In Combat - Cast Enveloping Web"),
+(@Anubshiah,0,6,0,0,0,100,0,3000,4000,4000,5000,11,15472,0,0,0,0,0,5,0,0,0,0,0,0,0,"Anubshiah - In Combat - Cast Shadow Bolt"),
+(@Hedrum,0,1,0,0,0,100,0,2000,2000,15000,18000,11,15475,0,0,0,0,0,5,0,0,0,0,0,0,0,"Hedrum - In Combat - Cast Baneful Poison"),
+(@Hedrum,0,2,0,0,0,100,0,7000,9000,15000,18000,11,3609,0,0,0,0,0,5,0,0,0,0,0,0,0,"Hedrum - In Combat - Cast Paralyzing Poison"),
+(@Hedrum,0,3,0,0,0,100,1,10000,15000,20000,25000,11,15474,0,0,0,0,0,5,0,0,0,0,0,0,0,"Hedrum - In Combat - Cast Web Explosion");
+
+UPDATE `creature_template` SET `unit_flags`=131904 WHERE `entry`=10096;
+DELETE FROM `creature_template_addon` WHERE `entry` IN (@DeepStinger);
+INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `auras`) VALUES
+(@DeepStinger, 1, '8601');
+
+UPDATE `creature_text` SET `groupid`=4, `id`=1 WHERE `BroadcastTextId`=5441 AND `entry`=10096;
+UPDATE `creature_text` SET `groupid`=0, `id`=1 WHERE `BroadcastTextId`=5442 AND `entry`=10096;
+UPDATE `creature_text` SET `groupid`=1, `id`=1 WHERE `BroadcastTextId`=5443 AND `entry`=10096;
+UPDATE `creature_text` SET `groupid`=5, `id`=1 WHERE `BroadcastTextId`=5444 AND `entry`=10096;
+UPDATE `creature_text` SET `groupid`=2, `id`=1 WHERE `BroadcastTextId`=5445 AND `entry`=10096;
+UPDATE `creature_text` SET `groupid`=3, `id`=1 WHERE `BroadcastTextId`=5446 AND `entry`=10096;
+UPDATE `creature_text` SET `id`=0 WHERE `entry`=10096;
diff --git a/src/server/worldserver/worldserver.conf.dist b/src/server/worldserver/worldserver.conf.dist
index 8e06c1c9ca4..aeeb90a0488 100644
--- a/src/server/worldserver/worldserver.conf.dist
+++ b/src/server/worldserver/worldserver.conf.dist
@@ -956,7 +956,7 @@ Guild.BankEventLogRecordsCount = 25
#
# MaxPrimaryTradeSkill
# Description: Maximum number of primary professions a character can learn.
-# Range: 0-10
+# Range: 0-11
# Default: 2
MaxPrimaryTradeSkill = 2
@@ -1148,7 +1148,7 @@ Updates.EnableDatabases = 0
Updates.SourcePath = ""
#
-# Updates.SourcePath
+# Updates.MySqlCLIPath
# Description: The path to your mysql cli binary.
# If the path is left empty, built-in path from cmake is used.
# Example: "C:/Program Files/MySQL/MySQL Server 5.6/bin/mysql.exe"
@@ -1667,6 +1667,7 @@ GM.WhisperingTo = 2
# applied on players when using the .freeze command
# Default: 0 - (Original aura duration. Lasts until the .unfreeze command is used)
# N - (Aura duration if unspecified in .freeze command, in seconds)
+
GM.FreezeAuraDuration = 0
#
@@ -2148,7 +2149,7 @@ AutoBroadcast.Center = 0
#
# AutoBroadcast.Timer
# Description: Timer (in milliseconds) for auto broadcasts.
-# Default: 60000 - (10 minutes)
+# Default: 600000 - (10 minutes)
AutoBroadcast.Timer = 600000
@@ -2556,14 +2557,14 @@ CharDelete.KeepDays = 30
#
# AllowTrackBothResources
# Description: Allows players to track herbs and minerals at the same time (if they have the skills)
-# Default: 0 (do not allow)
-# 1 (allow)
+# Default: 0 - (Do not allow)
+# 1 - (Allow)
#
-# Note: The following are client limitations and cannot be coded for:
-# * The minimap tracking icon will display whichever skill is activated second
-# * The minimap tracking list will only show a check mark next to the last skill activated (sometimes this
-# bugs out and doesn't switch the check mark. It has no effect on the actual tracking though).
-# * The minimap dots are yellow for both resources
+# Note: The following are client limitations and cannot be coded for:
+# * The minimap tracking icon will display whichever skill is activated second.
+# * The minimap tracking list will only show a check mark next to the last skill activated (sometimes this
+# bugs out and doesn't switch the check mark. It has no effect on the actual tracking though).
+# * The minimap dots are yellow for both resources.
AllowTrackBothResources = 0
@@ -2965,8 +2966,8 @@ AuctionHouseBot.Items.ItemLevel.Max = 0
#
# AuctionHouseBot.Items.ReqLevel.*
-# Prevent seller from listing items below/above this required level
-# Default: - 0 (Disabled)
+# Description: Prevent seller from listing items below/above this required level
+# Default: 0 - (Disabled)
AuctionHouseBot.Items.ReqLevel.Min = 0
AuctionHouseBot.Items.ReqLevel.Max = 0