diff options
| -rw-r--r-- | sql/updates/world/2011_06_16_04_world_waypoint_data.sql | 84 |
1 files changed, 84 insertions, 0 deletions
diff --git a/sql/updates/world/2011_06_16_04_world_waypoint_data.sql b/sql/updates/world/2011_06_16_04_world_waypoint_data.sql new file mode 100644 index 00000000000..29d252d2cdc --- /dev/null +++ b/sql/updates/world/2011_06_16_04_world_waypoint_data.sql @@ -0,0 +1,84 @@ +-- Pathing for Anub'ar Underlord Entry: 26605 +SET @NPC := 118237; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3704.838,`position_y`=2095.148,`position_z`=29.32822 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,3704.878,2078.017,22.76327,0,0,0,100,0), +(@PATH,2,3704.838,2095.148,29.32822,0,0,0,100,0), +(@PATH,3,3716.224,2107.784,34.74489,0,0,0,100,0), +(@PATH,4,3704.838,2095.148,29.32822,0,0,0,100,0); +-- Pathing for Anub'ar Underlord Entry: 26605 +SET @NPC := 118244; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3720.111,`position_y`=2070.069,`position_z`=20.87124 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,3719.379,2060.642,18.13046,0,0,0,100,0), +(@PATH,2,3717.377,2046.599,19.50792,0,0,0,100,0), +(@PATH,3,3712.452,2034.414,20.03152,0,0,0,100,0), +(@PATH,4,3717.377,2046.599,19.50792,0,0,0,100,0), +(@PATH,5,3719.186,2059.884,18.13046,0,0,0,100,0), +(@PATH,6,3720.111,2070.069,20.87124,0,0,0,100,0); +-- Pathing for Anub'ar Underlord Entry: 26605 +SET @NPC := 118288; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3697.697,`position_y`=2009.523,`position_z`=26.85555 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,3694.476,2020.034,23.35549,0,0,0,100,0), +(@PATH,2,3696.517,2032.483,19.2324,0,0,0,100,0), +(@PATH,3,3694.476,2020.034,23.35549,0,0,0,100,0), +(@PATH,4,3697.697,2009.523,26.85555,0,0,0,100,0); +-- Pathing for Anub'ar Underlord Entry: 26605 +SET @NPC := 118245; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3732.257,`position_y`=2176.174,`position_z`=37.1051 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,3718.512,2172.458,37.42885,0,0,0,100,0), +(@PATH,2,3732.257,2176.174,37.1051,0,0,0,100,0), +(@PATH,3,3743.498,2155.942,37.23704,0,0,0,100,0), +(@PATH,4,3732.257,2176.174,37.1051,0,0,0,100,0); +-- Pathing for Anub'ar Underlord Entry: 26605 +SET @NPC := 118238; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3743.132,`position_y`=2124.906,`position_z`=44.5452 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,3736.5,2122.697,41.26656,0,0,0,100,0), +(@PATH,2,3728.368,2133.333,39.51953,0,0,0,100,0), +(@PATH,3,3736.5,2122.697,41.26656,0,0,0,100,0), +(@PATH,4,3742.983,2124.628,44.42427,0,0,0,100,0), +(@PATH,5,3748.981,2135.839,47.54227,0,0,0,100,0), +(@PATH,6,3746.108,2146.75,50.10811,0,0,0,100,0), +(@PATH,7,3748.981,2135.839,47.54227,0,0,0,100,0), +(@PATH,8,3743.132,2124.906,44.5452,0,0,0,100,0); +-- Pathing for Anub'ar Cultist Entry: 26319 +SET @NPC := 115443; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4022.739,`position_y`=2258.957,`position_z`=152.3082 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,4032.673,2267.958,152.1369,0,0,0,100,0), +(@PATH,2,4023.99,2280.177,153.2619,0,0,0,100,0), +(@PATH,3,4012.677,2274.532,153.6369,0,0,0,100,0), +(@PATH,4,3999.963,2258.323,154.234,0,0,0,100,0), +(@PATH,5,4000.036,2251.767,154.5582,0,0,0,100,0), +(@PATH,6,3995.088,2248.992,154.234,0,0,0,100,0), +(@PATH,7,3993.707,2243.226,154.109,0,0,0,100,0), +(@PATH,8,3998.962,2241.267,154.734,0,0,0,100,0), +(@PATH,9,4006.684,2243.027,154.1832,0,0,0,100,0), +(@PATH,10,4022.739,2258.957,152.3082,0,0,0,100,0); |