From 50c8672f42107678eb2250a16c80f6309e947504 Mon Sep 17 00:00:00 2001 From: tkrokli Date: Mon, 20 Mar 2017 04:28:06 +0100 Subject: DB/Quests: startup errors in quest_mail_sender table Startup errors related to commit d4e15f1aac3159bb5e17808ee06efb847fdd4789 - Draenei & Blood Elf Orphan QuestId and RewardMailSenderEntry were switched - Oracle & Wolvar QuestId were from 4.0.3a and higher (not valid on 3.3.5) --- sql/updates/world/3.3.5/2017_03_20_00_world_335.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/3.3.5/2017_03_20_00_world_335.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2017_03_20_00_world_335.sql b/sql/updates/world/3.3.5/2017_03_20_00_world_335.sql new file mode 100644 index 00000000000..f5c7b2375bb --- /dev/null +++ b/sql/updates/world/3.3.5/2017_03_20_00_world_335.sql @@ -0,0 +1,7 @@ +-- Children's Week quest "Back to the Orphanage" and mail from the Orphans +DELETE FROM `quest_mail_sender` WHERE `QuestId` IN (22817,22818,28879,28880); +INSERT INTO `quest_mail_sender` (`QuestId`,`RewardMailSenderEntry`) VALUES +(10966, 22818), -- Back to the Orphanage (A) sends mail from Draenei Orphan +(10967, 22817), -- Back to the Orphanage (H) sends mail from Blood Elf Orphan +(13959, 33533), -- Back To The Orphanage (Oracle) sends mail from Oracle Orphan +(13960, 33532); -- Back To The Orphanage (Wolvar) sends mail from Wolvar Orphan -- cgit v1.2.3