diff options
| author | Teppic1 <Teppic1@users.noreply.github.com> | 2018-02-13 01:26:40 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2018-02-13 01:26:40 +0100 |
| commit | 75b975b4e8a26e9edcc3825b4c27837bf947aefc (patch) | |
| tree | 9651e54db98dd17c66b127677771f1b966ff8325 | |
| parent | 28c6db0807a604b0178abe24daa0e4eb21f560fb (diff) | |
DB/Loot: Reference template 24064 corrections
Closes #21385
| -rw-r--r-- | sql/updates/world/3.3.5/2018_02_13_00_world_335.sql | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_02_13_00_world_335.sql b/sql/updates/world/3.3.5/2018_02_13_00_world_335.sql new file mode 100644 index 00000000000..c991c6b1554 --- /dev/null +++ b/sql/updates/world/3.3.5/2018_02_13_00_world_335.sql @@ -0,0 +1,26 @@ +-- Remove unique items from reference table 24064 +DELETE FROM `reference_loot_template` WHERE `Entry`=24064 AND `Item` IN (911, 920, 1076, 1406, 1455, 1459, 1461, 1462, 2034, 2232, 3429); + +-- Add former items from reference table 24064 to their proper NPCs +DELETE FROM `creature_loot_template` WHERE `Item` IN (911, 920, 1076, 1406, 1455, 2034, 2232, 3429); +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Chance`, `GroupId`) VALUES +(889, 911, 0.1, 0, "Splinter Fist Ogre - Ironwood Treebranch"), +(215, 920, 0.1, 0, "Defias Night Runner - Wicked Spiked Mace"), +(909, 920, 0.1, 0, "Defias Night Blade - Wicked Spiked Mace"), +(1706, 1076, 1, 0, "Defias Prisoner - Defias Renegade Ring"), +(1711, 1076, 1, 0, "Defias Convict - Defias Renegade Ring"), +(1715, 1076, 1, 0, "Defias Insurgent - Defias Renegade Ring"), +(1708, 1076, 1, 0, "Defias Inmate - Defias Renegade Ring"), +(1707, 1076, 1, 0, "Defias Captive - Defias Renegade Ring"), +(544, 1406, 0.1, 0, "Murloc Nightcrawler - Pearl-encrusted Spear"), +(435, 1455, 0.1, 0, "Blackrock Champion - Blackrock Champion's Axe"), +(4464, 1455, 0.1, 0, "Blackrock Gladiator - Blackrock Champion's Axe"), +(4809, 2034, 1, 0, "Twilight Acolyte - Scholarly Robes"), +(4811, 2034, 1, 0, "Twilight Aquamancer - Scholarly Robes"), +(4810, 2034, 1, 0, "Twilight Reaver - Scholarly Robes"), +(4814, 2034, 1, 0, "Twilight Elementalist - Scholarly Robes"), +(4813, 2034, 1, 0, "Twilight Shadowmage - Scholarly Robes"), +(4812, 2034, 1, 0, "Twilight Loreseeker - Scholarly Robes"), +(205, 2232, 0.1, 0, "Nightbane Dark Runner - Dark Runner Boots"), +(2427, 3429, 1, 0, "Jailor Eston - Guardsman Belt"), +(2428, 3429, 1, 0, "Jailor Marlgen - Guardsman Belt"); |