diff options
| author | Killyana <morphone1@gmail.com> | 2019-05-25 05:46:50 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2019-05-25 05:46:50 +0200 |
| commit | 63c7bccb5014c7b356b07ab448e6b845f76ca7b2 (patch) | |
| tree | 806cff84bcfe5f7f106bc2d73613e283d6d1f93f | |
| parent | 2829f5fb9ce4d61ae6e88cf65ed7302985e5cf36 (diff) | |
DB: Fix wrong spawnMask
| -rw-r--r-- | sql/updates/world/3.3.5/2019_05_24_05_world.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/sql/updates/world/3.3.5/2019_05_24_05_world.sql b/sql/updates/world/3.3.5/2019_05_24_05_world.sql index 50bf281c15c..9ab5d9a15cc 100644 --- a/sql/updates/world/3.3.5/2019_05_24_05_world.sql +++ b/sql/updates/world/3.3.5/2019_05_24_05_world.sql @@ -1,9 +1,9 @@ -- DELETE FROM `creature` WHERE `guid` IN (106799, 106801, 106802) AND `id` IN (21933,21934); INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES -(106799, 21933, 548, 3607, 0, 3, 1, 0, 0, -215.7533, -375.3428, 38.40299, 5.009095, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- 21933 (Area: 0 - Difficulty: 0) -(106801, 21933, 548, 3607, 0, 3, 1, 0, 0, -264.1653, -357.1713, 38.80691, 2.844887, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- 21933 (Area: 0 - Difficulty: 0) -(106802, 21934, 548, 3607, 0, 3, 1, 0, 0, -239.7149, -366.4398, -0.7445137, 1.239184, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595); -- 21934 (Area: 0 - Difficulty: 0) (Auras: 37935 - 37935) +(106799, 21933, 548, 3607, 0, 1, 1, 0, 0, -215.7533, -375.3428, 38.40299, 5.009095, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- 21933 (Area: 0 - Difficulty: 0) +(106801, 21933, 548, 3607, 0, 1, 1, 0, 0, -264.1653, -357.1713, 38.80691, 2.844887, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- 21933 (Area: 0 - Difficulty: 0) +(106802, 21934, 548, 3607, 0, 1, 1, 0, 0, -239.7149, -366.4398, -0.7445137, 1.239184, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595); -- 21934 (Area: 0 - Difficulty: 0) (Auras: 37935 - 37935) UPDATE `creature` SET `position_x`=-239.8427, `position_y`=-366.4942, `position_z`=-0.7445897, `orientation`=1.22173 WHERE `id`=21216; DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (21933); |