diff options
| author | Rushor <Rushor@users.noreply.github.com> | 2017-02-05 01:24:02 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2017-02-05 01:24:02 +0100 |
| commit | d54a06823e1d7fce1879ecc2ed30cd45f3072dc3 (patch) | |
| tree | 3cb23705e92261b118937677d0a30b99c0bad95a | |
| parent | 9ee8838840339a81427f0f881f02b6d861ef00e7 (diff) | |
DB/Creature: Slosh
Closes #19043
| -rw-r--r-- | sql/updates/world/3.3.5/2017_02_05_16_world.sql | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_02_05_16_world.sql b/sql/updates/world/3.3.5/2017_02_05_16_world.sql new file mode 100644 index 00000000000..0c29cdad97c --- /dev/null +++ b/sql/updates/world/3.3.5/2017_02_05_16_world.sql @@ -0,0 +1,23 @@ +-- Pathing for Entry: 32478 'TDB FORMAT' +SET @NPC := 88139; +SET @PATH := @NPC * 10; + +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=8877.512,`position_y`=-1358.266,`position_z`=1033.88 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,8877.512,-1358.266,1033.88,0,0,0,0,100,0), +(@PATH,2,8877.512,-1359.266,1033.88,0,0,0,0,100,0), +(@PATH,3,8876.762,-1360.266,1033.63,0,0,0,0,100,0), +(@PATH,4,8876.447,-1360.297,1033.653,0,0,0,0,100,0), +(@PATH,5,8875.947,-1362.047,1033.653,0,0,0,0,100,0), +(@PATH,6,8873.364,-1366.144,1033.657,1.099557,120000,0,0,100,0), +(@PATH,7,8873.255,-1358.092,1033.895,0,0,0,0,100,0), +(@PATH,8,8873.492,-1357.932,1034.002,0,0,0,0,100,0), +(@PATH,9,8873.856,-1353.284,1034.383,0,0,0,0,100,0), +(@PATH,10,8878.05,-1356.542,1033.729,0,0,0,0,100,0), +(@PATH,11,8878.05,-1356.542,1033.729,0.541052,120000,0,0,100,0); +-- 0x203CD047601FB780000C1D000008E709 .go 8877.512 -1358.266 1033.88 |