DB/Achievements: Re-implement reward (mail) for Emblematic achievement

1 files changed, 5 insertions, 0 deletions

diff --git a/sql/updates/world/2011_03_27_03_world_achievement_reward.sql b/sql/updates/world/2011_03_27_03_world_achievement_reward.sql
new file mode 100644
index 00000000000..2afcce64f7b
--- /dev/null
+++ b/sql/updates/world/2011_03_27_03_world_achievement_reward.sql
@@ -0,0 +1,5 @@
+-- Send in-game mail when player completes achievements Emblematic
+DELETE FROM `achievement_reward` WHERE `entry` IN (4784,4785);
+INSERT INTO `achievement_reward` (`entry`,`title_A`,`title_H`,`item`,`sender`,`subject`,`text`) VALUES
+(4784,0,0,0,37942, 'Emblem Quartermasters in Dalaran''s Silver Enclave', 'Your achievements in Northrend have not gone unnoticed, friend.$B$BThe Emblems you have earned may be used to purchase equipment from the various Emblem Quartermasters in Dalaran.$B$BYou may find us there, in the Silver Enclave, where each variety of Emblem has its own quartermaster.$B$BWe look forward to your arrival!'),
+(4785,0,0,0,37941, 'Emblem Quartermasters in Dalaran''s Sunreaver Sanctuary', 'Your achievements in Northrend have not gone unnoticed, friend.$B$BThe Emblems you have earned may be used to purchase equipment from the various Emblem Quartermasters in Dalaran.$B$BYou may find us there, in the Sunreaver Sanctuary, where each variety of Emblem has its own quartermaster.$B$BWe look forward to your arrival!');