diff options
| author | Xyventh <Xyventh@users.noreply.github.com> | 2017-04-24 16:38:17 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2017-04-24 16:38:17 +0200 |
| commit | 95ef73901299555daca1d5f72b4055f947b716d3 (patch) | |
| tree | de30ecd4cc3f6c74734b52276babae0b4410b654 | |
| parent | 136f1e75aa8968eee9b94fa0d19e46e97332867a (diff) | |
DB/Gossip: Add Missing gossip texts for some NPCs in Sunstrider Isle
Closes #19501
| -rw-r--r-- | sql/updates/world/3.3.5/2017_04_24_03_world.sql | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_04_24_03_world.sql b/sql/updates/world/3.3.5/2017_04_24_03_world.sql new file mode 100644 index 00000000000..ad87f54e954 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_04_24_03_world.sql @@ -0,0 +1,29 @@ +-- Arcanist Ithanas +UPDATE `creature_template` SET `gossip_menu_id`= 15296 WHERE `entry`= 15296; + +DELETE FROM `gossip_menu` WHERE `entry`= 15296; +INSERT INTO `gossip_menu` (`entry`,`text_id`,`VerifiedBuild`) VALUES (15296, 7787, 0); + +-- Arcanist Helion +UPDATE `creature_template` SET `gossip_menu_id`= 15297 WHERE `entry`= 15297; + +DELETE FROM `gossip_menu` WHERE `entry`= 15297; +INSERT INTO `gossip_menu` (`entry`,`text_id`,`VerifiedBuild`) VALUES (15297, 7786, 0); + +-- Lanthan Perilon +DELETE FROM `gossip_menu` WHERE `entry`= 6570 AND `text_id`= 7785; +INSERT INTO `gossip_menu` (`entry`,`text_id`,`VerifiedBuild`) VALUES (6570, 7785, 0); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`= 14 AND `SourceGroup`= 6570; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`comment`) VALUES +(14, 6570, 7785, 0, 0, 8, 0, 8335, 0, 0, 1, 0, 0, '', "Gossip text requires quest 'Felendren the Banished' NOT rewarded"), +(14, 6570, 7869, 0, 0, 8, 0, 8335, 0, 0, 0, 0, 0, '', "Gossip text requires quest 'Felendren the Banished' rewarded"); + +-- Outrunner Alarion +DELETE FROM `gossip_menu` WHERE `entry`= 6573 AND `text_id`= 7788; +INSERT INTO `gossip_menu` (`entry`,`text_id`,`VerifiedBuild`) VALUES (6573, 7788, 0); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`= 14 AND `SourceGroup`= 6573; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`comment`) VALUES +(14, 6573, 7788, 0, 0, 8, 0, 9705, 0, 0, 1, 0, 0, '', "Gossip text requires quest 'Package Recovery' NOT rewarded"), +(14, 6573, 7821, 0, 0, 8, 0, 9705, 0, 0, 0, 0, 0, '', "Gossip text requires quest 'Package Recovery' rewarded"); |