diff options
| author | tkrokli <tkrokli@users.noreply.github.com> | 2017-03-20 04:28:06 +0100 |
|---|---|---|
| committer | tkrokli <tkrokli@users.noreply.github.com> | 2017-03-20 04:29:52 +0100 |
| commit | 50c8672f42107678eb2250a16c80f6309e947504 (patch) | |
| tree | 2084954a465968ecbf5fc531e9be273b44e467ac | |
| parent | 9cfa7c752e1d61b02acb852d2fd304a80d10b60a (diff) | |
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)
| -rw-r--r-- | sql/updates/world/3.3.5/2017_03_20_00_world_335.sql | 7 |
1 files changed, 7 insertions, 0 deletions
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 |