diff options
| author | Rothend <Rothend@users.noreply.github.com> | 2020-07-02 23:37:59 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-21 18:29:29 +0100 |
| commit | 78a928fa0cbae432673c743fdf7ba024460e4746 (patch) | |
| tree | 839b4cb75da60635e0922a30f2e68f33f481e0e8 | |
| parent | 0dc3644580216fe35661d75b947107326fa381a5 (diff) | |
DB/Creature: fix gossip text and quest requirement for NPC Lorekeeper Lydros
Closes #24858
(cherry picked from commit c7e576becdf5317fa6682253d24785069d514447)
| -rw-r--r-- | sql/updates/world/master/2022_01_21_05_world_2020_07_01_05_world.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_21_05_world_2020_07_01_05_world.sql b/sql/updates/world/master/2022_01_21_05_world_2020_07_01_05_world.sql new file mode 100644 index 00000000000..298e1267938 --- /dev/null +++ b/sql/updates/world/master/2022_01_21_05_world_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"); |