From a0047e6d2038540b4e7a463f50844130fb78931d Mon Sep 17 00:00:00 2001 From: offl Date: Sun, 29 Oct 2017 20:43:22 +0100 Subject: DB/Quest greeting: Marshal Dughan Closes #19756 For 3.3.5 Only --- sql/updates/world/3.3.5/2017_10_29_11_world_335.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/3.3.5/2017_10_29_11_world_335.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2017_10_29_11_world_335.sql b/sql/updates/world/3.3.5/2017_10_29_11_world_335.sql new file mode 100644 index 00000000000..66a997418ba --- /dev/null +++ b/sql/updates/world/3.3.5/2017_10_29_11_world_335.sql @@ -0,0 +1,8 @@ +-- +UPDATE `creature_template` SET `npcflag`=2, `gossip_menu_id`=0 WHERE `entry`=240; +DELETE FROM `gossip_menu` WHERE `MenuID`=11611; +DELETE FROM `npc_text` WHERE `ID`=16211; + +DELETE FROM `quest_greeting` WHERE `ID`=240; +INSERT INTO `quest_greeting` (`ID`, `Type`, `GreetEmoteType`, `GreetEmoteDelay`, `Greeting`, `VerifiedBuild`) VALUES +(240, 0, 0, 0, "Ach, it's hard enough keeping order around here without all these new troubles popping up! I hope you have good news, $n...", 0); -- cgit v1.2.3