From f8e56c18b2c23626c6c79d6891b565979e4ef892 Mon Sep 17 00:00:00 2001 From: Malcrom Date: Mon, 15 Jul 2013 14:38:48 -0230 Subject: DB/Gossip: Gossip fixup for Drull and Tog'thar --- sql/updates/world/2013_07_15_01_world_gossip.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 sql/updates/world/2013_07_15_01_world_gossip.sql (limited to 'sql') diff --git a/sql/updates/world/2013_07_15_01_world_gossip.sql b/sql/updates/world/2013_07_15_01_world_gossip.sql new file mode 100644 index 00000000000..b59feae2c5c --- /dev/null +++ b/sql/updates/world/2013_07_15_01_world_gossip.sql @@ -0,0 +1,15 @@ +-- Gossip fixup for Drull and Tog'thar +UPDATE `creature_template` SET `gossip_menu_id`=262 WHERE `entry`=2239; +DELETE FROM `gossip_menu` WHERE `entry` IN (261,262,263); +INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES +('261','760'), ('262','759'), ('263','762'); +-- Gossip Options +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (262,264); +INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`) VALUES +(262,0,0, 'Where is the key to this lock?',1,1,261), +(264,1,0, 'Where is the key to this lock?',1,1,263); +-- Gossip Options Conditions +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup` IN (262,264); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(15,262,0,0,0,9,0,498,0,0,0,'','Gossip Option requires quest not complete'), +(15,264,1,0,0,9,0,498,0,0,0,'','Gossip Option requires quest not complete'); -- cgit v1.2.3