diff options
| -rw-r--r-- | sql/updates/world/2011_03_02_1_world_achievement_reward.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2011_03_02_1_world_achievement_reward.sql b/sql/updates/world/2011_03_02_1_world_achievement_reward.sql new file mode 100644 index 00000000000..2afcce64f7b --- /dev/null +++ b/sql/updates/world/2011_03_02_1_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!'); |