diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2015_06_14_01_world.sql | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/sql/updates/world/2015_06_14_01_world.sql b/sql/updates/world/2015_06_14_01_world.sql new file mode 100644 index 00000000000..709f78fca92 --- /dev/null +++ b/sql/updates/world/2015_06_14_01_world.sql @@ -0,0 +1,37 @@ +DELETE FROM `creature_formations` WHERE `leaderGUID`=203571; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES +(203571, 203571, 0, 0, 1), +(203571, 203559, 2, 90, 2); + +-- Pathing for Gundrak Savage Entry: 29235 'TDB FORMAT' +SET @NPC := 203571; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=6332.113,`position_y`=-4009.055,`position_z`=457.2701 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,6332.113,-4009.055,457.2701,0,0,0,0,100,0), -- 13:57:18 +(@PATH,2,6354.536,-4030.933,457.2702,0,0,0,0,100,0), -- 13:57:30 +(@PATH,3,6372.311,-4048.536,457.2703,0,0,0,0,100,0), -- 13:57:40 +(@PATH,4,6386.682,-4062.151,457.2303,0,0,0,0,100,0), -- 13:57:49 +(@PATH,5,6406.021,-4081.781,457.2282,0,0,0,0,100,0), -- 13:57:59 +(@PATH,6,6414.187,-4095.374,457.6551,0,0,0,0,100,0), -- 13:58:06 +(@PATH,7,6400.186,-4088.764,457.0648,0,0,0,0,100,0), -- 13:58:12 +(@PATH,8,6383.09,-4071.84,457.2628,0,0,0,0,100,0), -- 13:58:21 +(@PATH,9,6371.94,-4060.654,457.0837,0,0,0,0,100,0), -- 13:58:29 +(@PATH,10,6361.409,-4050.251,457.4023,0,0,0,0,100,0), -- 13:58:35 +(@PATH,11,6346.225,-4035.04,457.3448,0,0,0,0,100,0), -- 13:58:43 +(@PATH,12,6325.968,-4014.103,457.2808,0,0,0,0,100,0), -- 13:58:54 +(@PATH,13,6306.042,-3994.58,457.2701,0,0,0,0,100,0), -- 13:59:05 +(@PATH,14,6264.928,-3950.012,457.2701,0,0,0,0,100,0), -- 13:59:22 +(@PATH,15,6262.15,-3946.607,457.2701,0,0,0,0,100,0), -- 13:59:32 +(@PATH,16,6241.434,-3927.12,457.2723,0,0,0,0,100,0), -- 13:59:44 +(@PATH,17,6216.531,-3899.659,458.7351,0,0,0,0,100,0), -- 13:59:54 +(@PATH,18,6221.433,-3900.517,457.7585,0,0,0,0,100,0), -- 14:00:00 +(@PATH,19,6228.114,-3903.022,457.1964,0,0,0,0,100,0), -- 14:00:05 +(@PATH,20,6245.55,-3922.648,457.2741,0,0,0,0,100,0), -- 14:00:16 +(@PATH,21,6265.786,-3942.583,457.2701,0,0,0,0,100,0), -- 14:00:26 +(@PATH,22,6283.895,-3961.789,457.2701,0,0,0,0,100,0), -- 14:00:37 +(@PATH,23,6311.935,-3990.581,457.2701,0,0,0,0,100,0); -- 14:00:53 +-- 0x1C393047601C8CC000000D000079A937 .go 6332.113 -4009.055 457.2701 |