diff options
| author | Xyventh <Xyventh@users.noreply.github.com> | 2017-04-24 16:38:17 +0200 |
|---|---|---|
| committer | funjoker <funjoker109@gmail.com> | 2020-04-28 12:56:07 +0200 |
| commit | 2bf9b0655e7f41ff33adb9599d4e24c982a00d2d (patch) | |
| tree | 315c3cb51ab5b927e3c6d16e62521fd000c6d095 | |
| parent | 16cf95654f35f6bb563e82608476d8f53837bd06 (diff) | |
DB/Gossip: Add Missing gossip texts for some NPCs in Sunstrider Isle
Closes #19501
(cherry picked from commit 95ef73901299555daca1d5f72b4055f947b716d3)
| -rw-r--r-- | sql/updates/world/master/2020_04_27_00_world_2017_04_24_03_world.sql | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/sql/updates/world/master/2020_04_27_00_world_2017_04_24_03_world.sql b/sql/updates/world/master/2020_04_27_00_world_2017_04_24_03_world.sql new file mode 100644 index 00000000000..78f9ec54456 --- /dev/null +++ b/sql/updates/world/master/2020_04_27_00_world_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 `MenuId`= 15296; +INSERT INTO `gossip_menu` (`MenuId`,`textid`,`VerifiedBuild`) VALUES (15296, 7787, 0); + +-- Arcanist Helion +UPDATE `creature_template` SET `gossip_menu_id`= 15297 WHERE `entry`= 15297; + +DELETE FROM `gossip_menu` WHERE `MenuId`= 15297; +INSERT INTO `gossip_menu` (`MenuId`,`textid`,`VerifiedBuild`) VALUES (15297, 7786, 0); + +-- Lanthan Perilon +DELETE FROM `gossip_menu` WHERE `MenuId`= 6570 AND `textid`= 7785; +INSERT INTO `gossip_menu` (`MenuId`,`textid`,`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 `MenuId`= 6573 AND `textid`= 7788; +INSERT INTO `gossip_menu` (`MenuId`,`textid`,`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"); |