aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/master/2023_09_08_00_world.sql8
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