diff options
| author | Teppic1 <Teppic1@users.noreply.github.com> | 2018-02-08 17:26:38 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-06-19 23:33:24 +0200 |
| commit | 014a77938d31189f4d21e6cbcced8362ab79ed10 (patch) | |
| tree | e862e7a33cfea9af2bc9f4bba38c0fd1f65283ce /sql | |
| parent | 2d08f4ce76ef7fbadaa5c74a5cfe380cff9af83c (diff) | |
DB/Loot: Reference template 24062 corrections
Closes #21368
(cherry picked from commit 3aee76b2d66a9dff6d86c204d38bef97d00d222b)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2021_06_19_07_world_2018_02_08_02_world_335.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_06_19_07_world_2018_02_08_02_world_335.sql b/sql/updates/world/master/2021_06_19_07_world_2018_02_08_02_world_335.sql new file mode 100644 index 00000000000..61a8fa303b0 --- /dev/null +++ b/sql/updates/world/master/2021_06_19_07_world_2018_02_08_02_world_335.sql @@ -0,0 +1,14 @@ +-- Remove unique items from reference table 24062 +DELETE FROM `reference_loot_template` WHERE `Entry`=24062 AND `Item` IN (880, 1299, 1457, 1458, 2175, 1462, 1461, 1459, 3018, 3227); + +-- Add former items from reference table 24062 to their proper NPCs +DELETE FROM `creature_loot_template` WHERE `Item` IN (880, 1299, 1457, 1458, 2175, 1462, 1461, 1459); +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Chance`, `GroupId`, `Comment`) VALUES +(202, 880, 0.1, 0, "Rotting Horror - Staff of Horrors"), +(436, 1299, 0.1, 0, "Blackrock Shadowcaster - Lesser Belt of the Spire"), +(433, 1457, 0.1, 0, "Shadowhide Gnoll - Shadowhide Mace"), +(432, 1458, 0.1, 0, "Shadowhide Brute - Shadowhide Maul"), +(568, 2175, 0.1, 0, "Shadowhide Warrior - Shadowhide Battle Axe"), +(429, 1462, 0.1, 0, "Shadowhide Darkweaver - Ring of the Shadow"), +(431, 1461, 0.1, 0, "Shadowhide Slayer - Slayer's Battle Axe"), +(579, 1459, 0.1, 0, "Shadowhide Assassin - Shadowhide Scalper"); |