From 47e41be5157f2e3bb536dfc4f2cbbdc66e64b4bd Mon Sep 17 00:00:00 2001 From: Teppic Date: Mon, 19 Feb 2018 20:21:57 +0100 Subject: DB/Loot: Reference template 24048 & 24050 corrections Closes #21457 (cherry picked from commit 1cc3d33cfe7e51d66925d5df536a952165a88094) --- .../2021_07_01_06_world_2018_02_19_18_world_335.sql | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 sql/updates/world/master/2021_07_01_06_world_2018_02_19_18_world_335.sql (limited to 'sql') diff --git a/sql/updates/world/master/2021_07_01_06_world_2018_02_19_18_world_335.sql b/sql/updates/world/master/2021_07_01_06_world_2018_02_19_18_world_335.sql new file mode 100644 index 00000000000..129ad218fd3 --- /dev/null +++ b/sql/updates/world/master/2021_07_01_06_world_2018_02_19_18_world_335.sql @@ -0,0 +1,21 @@ +-- Remove unique items from reference table 24048 +DELETE FROM `reference_loot_template` WHERE `Entry`=24048 AND `Item` IN (1297, 2234, 4462, 4724); + +-- Add former items from reference table 24048 to their proper NPCs +-- DELETE FROM `creature_loot_template` WHERE `Item` IN (1297, 2234, 4462, 4724); +-- INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Chance`, `GroupId`, `Comment`) VALUES +-- (2553, 1297, 0.1, 0, "Witherbark Shadowcaster - Robes of the Shadowcaster"), +-- (2577, 1297, 0.1, 0, "Dark Iron Shadowcaster - Robes of the Shadowcaster"), +-- (920, 2234, 0.1, 0, "Nightbane Tainted One - Nightwalker Armor"), +-- (503, 4462, 5, 0, "Lord Malathrom - Cloak of Rot"), +-- (2345, 4724, 2.5, 0, "Dun Garok Rifleman - Humbert's Helm"); + +-- Remove unique items from reference table 24050 +DELETE FROM `reference_loot_template` WHERE `Entry`=24050 AND `Item` IN (1998, 3341); + +-- Add former items from reference table 24050 to their proper NPCs +-- DELETE FROM `creature_loot_template` WHERE `Item` IN (1998, 3341); +-- INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Chance`, `GroupId`, `Comment`) VALUES +-- (697, 1998, 0.1, 0, "Bloodscalp Shaman - Bloodscalp Channeling Staff"), +-- (2562, 3341, 0.1, 0, "Boulderfist Ogre - Gauntlets of Ogre Strength"), +-- (2564, 3341, 0.1, 0, "Boulderfist Enforcer - Gauntlets of Ogre Strength"); -- cgit v1.2.3