diff options
| author | Rothend <Rothend@users.noreply.github.com> | 2020-07-02 23:37:59 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2020-07-02 23:37:59 +0200 |
| commit | c7e576becdf5317fa6682253d24785069d514447 (patch) | |
| tree | a21acd0e2d886aaf54c5c288e6892621f42f5bdc /sql | |
| parent | 47d07e827d51c97b06d2abd16287a35b6379349a (diff) | |
DB/Creature: fix gossip text and quest requirement for NPC Lorekeeper Lydros
Closes #24858
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2020_07_01_05_world.sql | 15 |
1 files changed, 15 insertions, 0 deletions
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"); |