diff options
| author | Teppic1 <Teppic1@users.noreply.github.com> | 2017-10-21 12:52:35 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2017-10-21 12:52:35 +0200 |
| commit | 7e9ad877883422bd8a4f368ab87d0628fd6c6c44 (patch) | |
| tree | c015d138c80bb7bed572deed7bd984ec1947f9f8 | |
| parent | 90f2c474adb17545829f32c055bebe700295ca6e (diff) | |
DB/Loot: Reference template 24076 corrections
Closes #20667
| -rw-r--r-- | sql/updates/world/3.3.5/2017_10_21_06_world_335.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_10_21_06_world_335.sql b/sql/updates/world/3.3.5/2017_10_21_06_world_335.sql new file mode 100644 index 00000000000..371b0a1131d --- /dev/null +++ b/sql/updates/world/3.3.5/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); |