diff options
| author | Teppic1 <Teppic1@users.noreply.github.com> | 2017-10-21 12:52:35 +0200 |
|---|---|---|
| committer | funjoker <funjoker109@gmail.com> | 2021-01-08 21:12:11 +0100 |
| commit | 9457c1bb9dfa8bf888f7391d59209e89690dda15 (patch) | |
| tree | 11e67eb1ac7ab00ece90301bc1387e27389e08bd | |
| parent | 2493663a8efff97b9964bf15367c14a51d27f21d (diff) | |
DB/Loot: Reference template 24076 corrections
Closes #20667
(cherry picked from commit 7e9ad877883422bd8a4f368ab87d0628fd6c6c44)
| -rw-r--r-- | sql/updates/world/master/2021_01_07_03_world_2017_10_21_06_world_335.sql | 17 |
1 files changed, 17 insertions, 0 deletions
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); |