diff options
| author | Teppic1 <Teppic1@users.noreply.github.com> | 2018-02-17 21:06:01 +0100 |
|---|---|---|
| committer | funjoker <funjoker109@gmail.com> | 2021-08-08 21:21:34 +0200 |
| commit | 463ffb69c4472537575bb152aa351503be614bb3 (patch) | |
| tree | 4a6715c7833ff5562c9b91af702a66279d65d90a | |
| parent | 64234b35ede0ec6e12048ec9a3dc8ae438ddb6e4 (diff) | |
DB/Loot: Reference template 24068 corrections
Closes #21416
(cherry picked from commit d38031715d3f9494bbc07f45f768f2151c9d9cf0)
| -rw-r--r-- | sql/updates/world/master/2021_07_01_00_world_2018_02_17_00_world_335.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_07_01_00_world_2018_02_17_00_world_335.sql b/sql/updates/world/master/2021_07_01_00_world_2018_02_17_00_world_335.sql new file mode 100644 index 00000000000..9611d2d7072 --- /dev/null +++ b/sql/updates/world/master/2021_07_01_00_world_2018_02_17_00_world_335.sql @@ -0,0 +1,14 @@ +-- +-- Remove unique items from reference table 24068 +DELETE FROM `reference_loot_template` WHERE `Entry`=24068 AND `Item` IN (897, 1351, 2015, 2017, 3053, 3336, 4723); +-- Add former items from reference table 24068 to their proper NPCs +-- DELETE FROM `creature_loot_template` WHERE `Item` IN (897, 1351, 2015, 2017, 3053, 3336, 4723); +-- INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Chance`, `GroupId`, `Comment`) VALUES +-- (206, 897, 0.1, 0, "Nightbane Vile Fang - Madwolf Bracers"), +-- (3808, 1351, 0.1, 0, "Forsaken Dark Stalker - Fingerbone Bracers"), +-- (570, 2015, 1, 0, "Brain Eater - Black Metal War Axe"), +-- (785, 2017, 1, 0, "Skeletal Warder - Glowing Leather Bracers"), +-- (2344, 3053, 2.5, 0, "Dun Garok Mountaineer - Humbert's Chestpiece"), +-- (2368, 3336, 0.1, 0, "Daggerspine Shorestalker - Flesh Piercer"), +-- (2370, 3336, 0.1, 0, "Daggerspine Screamer - Flesh Piercer"), +-- (2346, 4723, 2.5, 0, "Dun Garok Priest - Humbert's Pants"); |