From 13bac539d6c19b366be714c712c1acbcd4d1fb16 Mon Sep 17 00:00:00 2001 From: SnapperRy Date: Tue, 19 Jul 2016 09:02:01 +0200 Subject: 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) --- .../2017_02_11_01_world_2016_07_19_00_world.sql | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 sql/updates/world/master/2017_02_11_01_world_2016_07_19_00_world.sql (limited to 'sql/updates') 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 -- cgit v1.2.3