diff options
| -rw-r--r-- | sql/updates/world/2013_07_15_01_world_gossip.sql | 15 |
1 files changed, 15 insertions, 0 deletions
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'); |