diff options
| -rw-r--r-- | sql/updates/world/master/2022_01_25_01_world.sql | 39 |
1 files changed, 39 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_25_01_world.sql b/sql/updates/world/master/2022_01_25_01_world.sql new file mode 100644 index 00000000000..9e308831636 --- /dev/null +++ b/sql/updates/world/master/2022_01_25_01_world.sql @@ -0,0 +1,39 @@ +-- remove wrong entries +DELETE FROM `creature_addon` WHERE `guid` IN(1050448); +DELETE FROM `waypoint_data` WHERE `id` IN(10504480); + +-- Pathing for Summoned Guardian Entry: 149121 'TDB FORMAT' +SET @NPC := 850197; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawnDifficulties`=0,`MovementType`=2,`position_x`=-9033.98,`position_y`=911.62683,`position_z`=66.36547 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,-9033.98,911.62683,66.36547,0,0,0,0,100,0), +(@PATH,2,-9024.955,928.29865,66.36513,0,0,0,0,100,0), +(@PATH,3,-9021.234,930.6823,67.67302,0,0,0,0,100,0), +(@PATH,4,-9002.014,944.3748,67.58477,0,0,0,0,100,0), +(@PATH,5,-8995.31,949.3299,67.65515,0,0,0,0,100,0), +(@PATH,6,-8989.04,955.7639,67.71188,0,10000,0,0,100,0), +(@PATH,7,-9003.446,943.16144,67.58858,0,0,0,0,100,0), +(@PATH,8,-9007.967,938.8281,67.66206,0,0,0,0,100,0), +(@PATH,9,-9018.306,930.42365,67.70766,0,0,0,0,100,0), +(@PATH,10,-9022.879,927.0434,66.36513,0,0,0,0,100,0), +(@PATH,11,-9032.703,916.80383,66.38743,0,0,0,0,100,0), +(@PATH,12,-9035.311,911.94617,66.36513,0,0,0,0,100,0), +(@PATH,13,-9026.66,901.0781,65.05767,0,0,0,0,100,0), +(@PATH,14,-9017.679,890.72394,64.98259,0,0,0,0,100,0), +(@PATH,15,-9003.127,874.8958,64.9745,0,0,0,0,100,0), +(@PATH,16,-9001.582,875.80383,64.9745,0,0,0,0,100,0), +(@PATH,17,-9001.582,875.80383,64.9745,0,10000,0,0,100,0), +(@PATH,18,-9010.266,879.375,65.04902,0,0,0,0,100,0), +(@PATH,19,-9013.076,883.4184,65.11821,0,0,0,0,100,0), +(@PATH,20,-9017.929,889.72394,64.99534,0,0,0,0,100,0), +(@PATH,21,-9024.042,893.0052,65.04807,0,0,0,0,100,0), +(@PATH,22,-9031.618,892.3472,64.96365,0,6000,0,0,100,0), +(@PATH,23,-9028.044,899.99023,65.04553,0,0,0,0,100,0), +(@PATH,24,-9030.424,906.1059,66.36513,0,0,0,0,100,0); |