From 7450be4cfd3f06ef3cac59ab0cd73e3af47f4857 Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Mon, 10 Feb 2020 22:33:38 +0100
Subject: DB/Text: Fix and remove some npc_text

---
 sql/updates/world/3.3.5/2020_02_10_00_world.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 sql/updates/world/3.3.5/2020_02_10_00_world.sql

(limited to 'sql/updates')

diff --git a/sql/updates/world/3.3.5/2020_02_10_00_world.sql b/sql/updates/world/3.3.5/2020_02_10_00_world.sql
new file mode 100644
index 00000000000..3a71a1eee09
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_02_10_00_world.sql
@@ -0,0 +1,11 @@
+--
+UPDATE `npc_text` SET `Text0_0`="You can find our mana loom in the merchant's bazaar within the Lower City.", `Text0_1`="You can find our mana loom in the merchant's bazaar within the Lower City.", `Emote0_0`=1, `BroadcastTextID0`=19591, `Probability0`=1 WHERE `id`=10503;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=8418 WHERE `MenuID`=8403 AND `OptionID`=6;
+UPDATE `gossip_menu_option` SET `ActionMenuID`=8410 WHERE `MenuID`=8357 AND `OptionID`=8;
+
+DELETE FROM `npc_text` WHERE `ID` IN (10515, 724001, 724002, 724003, 724004, 724005, 2981);
+INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `lang0`, `Probability0`, `BroadcastTextID0`) VALUES
+(10515, "<The Arcane Guardian gestures towards the Lower City's bazaar.>", '', 0, 1, 41148);
+
+DELETE FROM `gossip_menu` WHERE `MenuID`=8410 AND `TextID`=10515;
+INSERT INTO `gossip_menu` (`MenuID`,`TextID`) VALUES (8410,10515);
-- 
cgit v1.2.3