diff options
| author | SnapperRy <snapperryen@gmail.com> | 2016-07-19 09:02:01 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-02-11 15:19:42 +0100 |
| commit | 13bac539d6c19b366be714c712c1acbcd4d1fb16 (patch) | |
| tree | 768d388f24719f3f6a3a5fca23a8d36558f8e584 /sql/updates | |
| parent | 8d45095e28911a9e832467141ca30336b53f83a2 (diff) | |
Core/Mail: implement a way to specify NPC sender for mails when they should be different from the quest ender (#17601)
(cherry picked from commit d4e15f1aac3159bb5e17808ee06efb847fdd4789)
# Conflicts:
# src/server/game/Quests/QuestDef.cpp
# src/server/game/Quests/QuestDef.h
Rename 9999_99_99_99_world.sql to sql/updates/world/3.3.5/2016_07_19_00_world.sql
(cherry picked from commit 3a77dec6e6fac47fedeb0aeddd09dfe12c3817a2)
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/master/2017_02_11_01_world_2016_07_19_00_world.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_11_01_world_2016_07_19_00_world.sql b/sql/updates/world/master/2017_02_11_01_world_2016_07_19_00_world.sql new file mode 100644 index 00000000000..ae623f25db0 --- /dev/null +++ b/sql/updates/world/master/2017_02_11_01_world_2016_07_19_00_world.sql @@ -0,0 +1,20 @@ +-- +DROP TABLE IF EXISTS `quest_mail_sender`; +CREATE TABLE `quest_mail_sender` +( + `QuestId` INT(5) UNSIGNED NOT NULL DEFAULT 0, + `RewardMailSenderEntry` INT(5) UNSIGNED NOT NULL DEFAULT 0, + PRIMARY KEY (`QuestId`) +); + +INSERT INTO `quest_mail_sender` (`QuestId`, `RewardMailSenderEntry`) VALUES +(8729, 11811), -- Quest The Wrath of Neptulon sends mail from Narain Soothfancy +(10588, 18166), -- Quest The Cipher of Damnation sends mail from Archmage Khadgar +(12085, 5885), -- Quest A Letter for Home (Horde) sends mail from Deino +(12067, 2708), -- Quest A Letter for Home (Alliance) sends mail from Archmage Malin +(12422, 27102), -- Quest Tactical Clemency sends mail from Gorgonna +(12711, 28930), -- Quest Abandoned Mail sends mail from Dansel Adams +(22817, 10967), -- Quest Back to the Orphanage (Blood Elf) sends mail from Blood Elf Orphan +(22818, 10966), -- Quest Back to the Orphanage (Draenei) sends mail from Draenei Orphan +(28879, 33533), -- Quest Back To The Orphanage (Oracle) sends mail from Oracle Orphan +(28880, 33532); -- Quest Back To The Orphanage (Wolvar) sends mail from Wolvar Orphan |