From c7e576becdf5317fa6682253d24785069d514447 Mon Sep 17 00:00:00 2001 From: Rothend Date: Thu, 2 Jul 2020 23:37:59 +0200 Subject: DB/Creature: fix gossip text and quest requirement for NPC Lorekeeper Lydros Closes #24858 --- sql/updates/world/3.3.5/2020_07_01_05_world.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 sql/updates/world/3.3.5/2020_07_01_05_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2020_07_01_05_world.sql b/sql/updates/world/3.3.5/2020_07_01_05_world.sql new file mode 100644 index 00000000000..298e1267938 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_07_01_05_world.sql @@ -0,0 +1,15 @@ +DELETE FROM `gossip_menu` WHERE `MenuID`=5747 AND `TextID`=6926; +INSERT INTO `gossip_menu` (`MenuID`, `TextID`) VALUES +(5747, 6926); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=5747 AND `SourceEntry` IN (6926, 6925); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=19 AND `SourceEntry` IN (7483, 7484, 7485); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(14, 5747, 6926, 0, 0, 8, 0, 7481, 0, 0, 0, 0, 0, "", "Gossip Text 6926 requires quest 'Elven Legends' (Horde) rewarded OR"), +(14, 5747, 6926, 0, 1, 8, 0, 7482, 0, 0, 0, 0, 0, "", "Gossip Text 6926 requires quest 'Elven Legends' (Alliance) rewarded "), +(19, 0, 7483, 0, 0, 8, 0, 7481, 0, 0, 0, 0, 0, "", "Quest 'Libram of Rapidity' is available if player has quest 'Elven Legends' (Horde) rewarded OR"), +(19, 0, 7483, 0, 1, 8, 0, 7482, 0, 0, 0, 0, 0, "", "Quest 'Libram of Rapidity' is available if player has quest 'Elven Legends' (Alliance) rewarded"), +(19, 0, 7484, 0, 0, 8, 0, 7481, 0, 0, 0, 0, 0, "", "Quest 'Libram of Focus' is available if player has quest 'Elven Legends' (Horde) rewarded OR"), +(19, 0, 7484, 0, 1, 8, 0, 7482, 0, 0, 0, 0, 0, "", "Quest 'Libram of Focus' is available if player has quest 'Elven Legends' (Alliance) rewarded"), +(19, 0, 7485, 0, 0, 8, 0, 7481, 0, 0, 0, 0, 0, "", "Quest 'Libram of Protection' is available if player has quest 'Elven Legends' (Horde) rewarded OR"), +(19, 0, 7485, 0, 1, 8, 0, 7482, 0, 0, 0, 0, 0, "", "Quest 'Libram of Protection' is available if player has quest 'Elven Legends' (Alliance) rewarded"); -- cgit v1.2.3