aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/3.3.5/2017_10_29_11_world_335.sql8
1 files changed, 8 insertions, 0 deletions
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);