From 9457c1bb9dfa8bf888f7391d59209e89690dda15 Mon Sep 17 00:00:00 2001 From: Teppic1 Date: Sat, 21 Oct 2017 12:52:35 +0200 Subject: DB/Loot: Reference template 24076 corrections Closes #20667 (cherry picked from commit 7e9ad877883422bd8a4f368ab87d0628fd6c6c44) --- .../2021_01_07_03_world_2017_10_21_06_world_335.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 sql/updates/world/master/2021_01_07_03_world_2017_10_21_06_world_335.sql (limited to 'sql') diff --git a/sql/updates/world/master/2021_01_07_03_world_2017_10_21_06_world_335.sql b/sql/updates/world/master/2021_01_07_03_world_2017_10_21_06_world_335.sql new file mode 100644 index 00000000000..371b0a1131d --- /dev/null +++ b/sql/updates/world/master/2021_01_07_03_world_2017_10_21_06_world_335.sql @@ -0,0 +1,17 @@ +-- +-- Remove unique items from reference table 24076 +DELETE FROM `reference_loot_template` WHERE `Item` IN (826, 1211, 1287, 1394, 1926, 1927, 1933, 2088, 4767, 4768, 4771); +-- Add former items from reference table 24076 to their proper NPCs +DELETE FROM `creature_loot_template` WHERE `Item` IN (826, 1211, 1287, 1394, 1926, 1927, 1933, 2088, 4767, 4768, 4771); +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Chance`, `GroupId`) VALUES +(124, 826, 0.1, 0), +(423, 1211, 0.1, 0), +(442, 1287, 0.1, 0), +(171, 1394, 0.1, 0), +(824, 1926, 0.1, 0), +(594, 1927, 0.1, 0), +(619, 1933, 0.1, 0), +(831, 2088, 0.1, 0), +(3578, 4767, 3, 0), +(3270, 4768, 3, 2), +(3270, 4771, 3, 2); -- cgit v1.2.3