diff options
| author | Shamage <7515044+shamage@users.noreply.github.com> | 2023-09-08 02:12:28 +0200 |
|---|---|---|
| committer | Naddley <NaddleyTC@gmail.com> | 2023-09-08 02:12:37 +0200 |
| commit | 401f8a18ddf849123f88d267a518a2e77a4e494d (patch) | |
| tree | cffc4229df4ceef7709e3eccdf7524b82822e6a9 | |
| parent | e56fca906f3141a4ffc22c5680ddbd4df1249f37 (diff) | |
DB/Gossip: Update gossip data for Inkeeper Haelthol
Closes #29225
| -rw-r--r-- | sql/updates/world/master/2023_09_08_00_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_09_08_00_world.sql b/sql/updates/world/master/2023_09_08_00_world.sql new file mode 100644 index 00000000000..270c3f09eb0 --- /dev/null +++ b/sql/updates/world/master/2023_09_08_00_world.sql @@ -0,0 +1,8 @@ +-- update template +UPDATE `creature_template` SET `ScriptName` = '' WHERE `entry` = 19232; + +-- Gossip Menu Options +DELETE FROM `gossip_menu_option` WHERE `MenuID`=7949; +INSERT INTO `gossip_menu_option` (`GossipOptionID`, `MenuID`, `OptionID`, `OptionNpc`, `OptionText`, `OptionBroadcastTextId`, `Language`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `SpellID`, `Flags`, `OverrideIconID`, `GossipNpcOptionID`, `VerifiedBuild`) VALUES +(35008, 7949, 1, 1, 'Let me browse your goods.', 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 50747), -- for Innkeeper Haelthol +(35007, 7949, 0, 5, 'Make this inn your home.', 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 28861, 50747); -- for Innkeeper Haelthol |