diff options
| author | Killyana <morphone1@gmail.com> | 2019-12-22 16:53:13 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-12-19 14:56:41 +0100 |
| commit | 9eab3407c0ee0137721d90900313e247f20fdac1 (patch) | |
| tree | 9976ae2a176c01ae1b7b2d0d2a788c2cd0222233 | |
| parent | eb0090dc411106d6ffba0f48da8d44d9903f5087 (diff) | |
DB/Misc: Fix some cosmetics in Zul'drak
(cherry picked from commit 967a5868976bf2b03dbebfb67beb0022e792062c)
| -rw-r--r-- | sql/updates/world/master/2021_12_19_14_world_2019_12_22_03_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_19_14_world_2019_12_22_03_world.sql b/sql/updates/world/master/2021_12_19_14_world_2019_12_22_03_world.sql new file mode 100644 index 00000000000..f8a27dfea78 --- /dev/null +++ b/sql/updates/world/master/2021_12_19_14_world_2019_12_22_03_world.sql @@ -0,0 +1,9 @@ +-- +DELETE FROM `creature_template_addon` WHERE `entry` IN (29691, 29688, 29689) ; +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(29691,0,7,1,0, ""), +(29688,0,0,1,233, ""), +(29689,0,0,1,333, ""); +UPDATE `gossip_menu_option` SET `OptionType`=3, `OptionNpcFlag`=128 WHERE `MenuID` IN (9848); +UPDATE `creature` SET `MovementType`=0, `spawndist`=0 WHERE `id`= 29468; +UPDATE `creature` SET `position_x`=5766.979492, `position_y`=-1617.112793, `position_z`=234.942978, `orientation`=0.605617 WHERE `guid`= 97401; |