diff options
| author | Killyana <morphone1@gmail.com> | 2019-12-22 16:53:13 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2019-12-22 16:53:13 +0100 |
| commit | 967a5868976bf2b03dbebfb67beb0022e792062c (patch) | |
| tree | 6ae6899056fd22487033d1613e3aaebeee546b78 /sql | |
| parent | bb3f9b8b44db8c69f93ba6cdec7e63fc8c4798af (diff) | |
DB/Misc: Fix some cosmetics in Zul'drak
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2019_12_22_03_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_12_22_03_world.sql b/sql/updates/world/3.3.5/2019_12_22_03_world.sql new file mode 100644 index 00000000000..f8a27dfea78 --- /dev/null +++ b/sql/updates/world/3.3.5/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; |