diff options
| author | Wyrserth <wyrserth@protonmail.com> | 2019-06-30 19:41:29 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-12-13 00:42:19 +0100 |
| commit | 41df87d7aa85df4968771a65956aee7cde607337 (patch) | |
| tree | a78f5c32c9afe67e467f8c8edf7be1585487c3ad | |
| parent | 9d84b56df1a2ccd2d64845e4c739b73e4db5ff22 (diff) | |
DB/Creature: fix spawns and emote state for Mjordin Combatants in Icecrown.
(cherry picked from commit e1787b883e1dc4cd67d6b30c8a1ca6db4abb2660)
| -rw-r--r-- | sql/updates/world/master/2021_12_12_18_world_2019_06_30_01_world.sql | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_12_18_world_2019_06_30_01_world.sql b/sql/updates/world/master/2021_12_12_18_world_2019_06_30_01_world.sql new file mode 100644 index 00000000000..71e54d37b29 --- /dev/null +++ b/sql/updates/world/master/2021_12_12_18_world_2019_06_30_01_world.sql @@ -0,0 +1,22 @@ +-- +UPDATE `creature` SET `modelid`=0, `spawndist`=0, `MovementType`=0 WHERE `id`=30037; +UPDATE `creature` SET `orientation`=4.01702 WHERE `guid`=122274; +UPDATE `creature` SET `position_x`=8418.1152, `position_y`=3099.1055, `position_z`=588.1407, `orientation`=2.39233 WHERE `guid`=122282; +UPDATE `creature` SET `position_x`=8389.5381, `position_y`=3089.6367, `position_z`=588.1461, `orientation`=0.19321 WHERE `guid`=122277; +UPDATE `creature` SET `position_x`=8407.9512, `position_y`=3067.1392, `position_z`=588.1420, `orientation`=2.35367 WHERE `guid`=122280; +UPDATE `creature` SET `position_x`=8403.9629, `position_y`=3071.0413, `position_z`=588.1420, `orientation`=5.55800 WHERE `guid`=122272; +UPDATE `creature` SET `position_x`=8432.4512, `position_y`=3076.2439, `position_z`=588.1423, `orientation`=5.98605 WHERE `guid`=122276; +UPDATE `creature` SET `position_x`=8468.8838, `position_y`=3095.4836, `position_z`=588.1412, `orientation`=0.79457 WHERE `guid`=122275; +UPDATE `creature` SET `position_x`=8461.1221, `position_y`=3120.8025, `position_z`=588.1393, `orientation`=1.90437 WHERE `guid`=122281; +UPDATE `creature` SET `position_x`=8460.2520, `position_y`=3125.6013, `position_z`=588.1425, `orientation`=4.88889 WHERE `guid`=122271; +UPDATE `creature` SET `position_x`=8449.5693, `position_y`=3149.9019, `position_z`=588.1426, `orientation`=2.80751 WHERE `guid`=122273; +UPDATE `creature` SET `position_x`=8445.9375, `position_y`=3151.6152, `position_z`=588.1661, `orientation`=5.83915 WHERE `guid`=122284; + +DELETE FROM `creature` WHERE `guid`=111259; +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`, `ScriptName`, `VerifiedBuild`) VALUES +(111259, 30037, 571, 0, 0, '0', 0, 0, 1, 8412.42, 3161.56, 588.106, 0.757619, 300, 0, 0, 12175, 0, 0, 0, 0, 0, "", 0); + +DELETE FROM `creature_addon` WHERE `guid` IN (122271, 122272, 122273, 122274, 122275, 122276, 122277, 122280, 122281, 122282, 122283, 122284, 122287, 122288, 122289, 122290, 122291, 122292, 122293); +DELETE FROM `creature_template_addon` WHERE `entry`=30037; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES +(30037, 0, 0, 0, 1, 333, 0, ""); |