diff options
| author | Naddley <NaddleyTC@gmail.com> | 2024-03-19 00:09:40 +0100 |
|---|---|---|
| committer | Naddley <NaddleyTC@gmail.com> | 2024-03-19 00:09:40 +0100 |
| commit | 6d3f70d369c639c954a84b793abe967f9416b417 (patch) | |
| tree | e441361ed1fcdf2d7cf72526dbec5bcbb1916028 | |
| parent | 7c736d8cf27ee5bfcf705f5b05000abaf28e3400 (diff) | |
DB/Mardum: Added Soulwrought Key drop to Anguish Jailor
| -rw-r--r-- | sql/updates/world/master/2024_03_19_00_world.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_03_19_00_world.sql b/sql/updates/world/master/2024_03_19_00_world.sql new file mode 100644 index 00000000000..3399f0c7547 --- /dev/null +++ b/sql/updates/world/master/2024_03_19_00_world.sql @@ -0,0 +1,7 @@ +DELETE FROM `creature_template_difficulty` WHERE `Entry` = 95226 AND `DifficultyID` = 1; + +UPDATE `creature_template_difficulty` SET `LootID` = 95226 WHERE `Entry` = 95226 AND `DifficultyID` = 0; + +DELETE FROM `creature_loot_template` WHERE `Entry` = 95226 AND `Item` = 128227; +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(95226, 128227, 0, 100, 1, 1, 0, 1, 1, 'Anguish Jailer - Soulwrought Key'); |