From 634e5d41e4e1c0c6c824a6eb271d928144e69b82 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Wed, 11 Mar 2015 13:31:02 +0100 Subject: DB/Creature: Tyrion flavor text By Killyana, closes #12702 --- sql/updates/world/2015_03_10_08_world.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/2015_03_10_08_world.sql (limited to 'sql') diff --git a/sql/updates/world/2015_03_10_08_world.sql b/sql/updates/world/2015_03_10_08_world.sql new file mode 100644 index 00000000000..2992a858dc6 --- /dev/null +++ b/sql/updates/world/2015_03_10_08_world.sql @@ -0,0 +1,8 @@ +-- Add missing gossip for entry 7766 +DELETE FROM `gossip_menu` WHERE `entry`=1761; +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (1761,2393),(1761,2394); +UPDATE `creature_template` SET `gossip_menu_id`=1761 WHERE entry=7766; + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=1761; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`, `NegativeCondition`, `ErrorTextId`,`ScriptName`,`Comment`) VALUES +(14,1761,2394,0,9,434,0,0,0,0,'','Show gossip menu text if quest 434 is taken'); -- cgit v1.2.3