From 5cdb53896f89bfff82ad627dd30aebe3834aabf5 Mon Sep 17 00:00:00 2001 From: ZenoX92 Date: Thu, 2 Aug 2018 19:09:40 +0200 Subject: DB/Gossip: Captain Nials, Skuerto & Navigator Mehran Closes #22219 --- sql/updates/world/3.3.5/2018_08_02_05_world_335.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 sql/updates/world/3.3.5/2018_08_02_05_world_335.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2018_08_02_05_world_335.sql b/sql/updates/world/3.3.5/2018_08_02_05_world_335.sql new file mode 100644 index 00000000000..4ef4656b60e --- /dev/null +++ b/sql/updates/world/3.3.5/2018_08_02_05_world_335.sql @@ -0,0 +1,16 @@ +-- Captain Nials +UPDATE `creature_template` SET `npcflag`=2, `gossip_menu_id`=0 WHERE `entry`=2700; + +UPDATE `smart_scripts` SET `action_param1`=2 WHERE `entryorguid`=270000 AND `source_type`=9 AND `id` IN (0,9); + +-- Skuerto +UPDATE `creature_template` SET `npcflag`=2, `gossip_menu_id`=0 WHERE `entry`=2789; + +-- Apprentice Kryten +-- DELETE FROM `gossip_menu` WHERE `MenuID`=2601 AND `TextID`=3294; + +-- Navigator Mehran +UPDATE `npc_text` SET `em0_0`=0, `em0_1`=274 WHERE `ID`=12209; + +-- Restless Apparition +UPDATE `creature_template` SET `npcflag`=0 WHERE `entry`=23861; -- cgit v1.2.3