diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2025_05_23_00_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
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'); |