From 401f8a18ddf849123f88d267a518a2e77a4e494d Mon Sep 17 00:00:00 2001
From: Shamage <7515044+shamage@users.noreply.github.com>
Date: Fri, 8 Sep 2023 02:12:28 +0200
Subject: DB/Gossip: Update gossip data for Inkeeper Haelthol

Closes #29225
---
 sql/updates/world/master/2023_09_08_00_world.sql | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 sql/updates/world/master/2023_09_08_00_world.sql

(limited to 'sql')

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
-- 
cgit v1.2.3