From 286f5c9d031fb8722b6e9f9eafa124d985cec64b Mon Sep 17 00:00:00 2001 From: Shauren Date: Fri, 23 May 2025 21:28:32 +0200 Subject: DB/Achievements: Added reward mail data for achievement 40942 and 40943 --- sql/updates/world/master/2025_05_23_00_world.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/master/2025_05_23_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2025_05_23_00_world.sql b/sql/updates/world/master/2025_05_23_00_world.sql new file mode 100644 index 00000000000..a74bcb724d3 --- /dev/null +++ b/sql/updates/world/master/2025_05_23_00_world.sql @@ -0,0 +1,8 @@ +DELETE FROM `achievement_reward` WHERE `ID` IN (40942,40943); +INSERT INTO `achievement_reward` (`ID`,`TitleA`,`TitleH`,`ItemID`,`Sender`,`Subject`,`Body`,`MailTemplateID`) VALUES +(40942,0,0,236953,219226,'Undermine Crest Analysis','$n,\r\n\r\nI have been doing some digging and I think I hit the jackpot. These Carved Crests are actually quite similar to Runed Crests once you start breaking them down to the fundamental level.\r\n\r\nWith this knowledge, I should be able to transmute your Carved Undermine Crests into Runed Undermine Crests!\r\n\r\nSee you in Dornogal,\r\nVaskarn',0), +(40943,0,0,236953,219226,'Undermine Crest Advancements','My friend!\r\n\r\nCuzolth and I have been analyzing these Undermine Crests and I think we finally unearthed their secrets.\r\n\r\nI should be able to transmute your Weathered Undermine Crests into Carved Undermine Crests now. Make haste and meet me in Dornogal at once!\r\n\r\nYour friend,\r\nVaskarn',0); + +DELETE FROM `item_loot_template` WHERE `Entry`=236953 AND `ItemType`=2 AND `Item`=3008; +INSERT INTO `item_loot_template` (`Entry`,`ItemType`,`Item`,`MinCount`,`MaxCount`,`Comment`) VALUES +(236953,2,3008,100,100,'Crimson Valorstone - 100 Valorstones'); -- cgit v1.2.3