diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2021_12_18_50_world_2019_10_21_01_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_18_50_world_2019_10_21_01_world.sql b/sql/updates/world/master/2021_12_18_50_world_2019_10_21_01_world.sql new file mode 100644 index 00000000000..b70130a2de8 --- /dev/null +++ b/sql/updates/world/master/2021_12_18_50_world_2019_10_21_01_world.sql @@ -0,0 +1,8 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (117317,117318,117319); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(117317, 30685, 571, 210, 4504, 1, 176, 0, 1, 6370.581, 227.0712, 396.1292, 3.089233, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 30685 (Area: 4504 - Difficulty: 0) +(117318, 30685, 571, 210, 4504, 1, 176, 0, 1, 6378.393, 229.9219, 396.1292, 0.9250245, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340), -- 30685 (Area: 4504 - Difficulty: 0) +(117319, 30685, 571, 210, 4504, 1, 176, 0, 1, 6378.936, 224.7951, 396.1292, 6.003932, 120, 0, 0, 0, 0, 0, 0, 0, 0, 12340); -- 30685 (Area: 4504 - Difficulty: 0) + +UPDATE `creature` SET `position_x`=6371.885, `position_y`=237.8247, `position_z`=396.1291, `orientation`=1.710423 WHERE `id`=30686; |