DB/Gossip: Remove wrong gossip menus

Ref #22912

1 files changed, 9 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_01_10_01_world.sql b/sql/updates/world/3.3.5/2019_01_10_01_world.sql
new file mode 100644
index 00000000000..815d5b25459
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_01_10_01_world.sql
@@ -0,0 +1,9 @@
+-- 
+DELETE FROM `npc_text` WHERE `ID` IN (773,737,733,2498);
+DELETE FROM `gossip_menu` WHERE `MenuID` IN (773,737,733,2498);
+
+UPDATE `creature_template` SET `npcflag` = `npcflag`&~1 WHERE `entry` = 733;
+
+DELETE FROM `quest_greeting` WHERE `Id` = 733;
+INSERT INTO `quest_greeting` (`Id`, `Type`, `GreetEmoteType`, `GreetEmoteDelay`, `Greeting`, `VerifiedBuild`) VALUES
+(733, 0, 0, 0, 'You watch where you step around here, $Glad:lass;.  You might not be a part of our outfit, but that doesn\'t mean I won\'t take a cane to you if you fall out of line!', 0);