diff options
| author | SnapperRy <snapperryen@gmail.com> | 2016-10-01 19:39:10 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-03-04 19:55:33 +0100 |
| commit | 36e0843f66aed438fe0d32174dd0d3068c6fbd58 (patch) | |
| tree | 6c5b3961f695258052a02a967db2ef116409a7bb | |
| parent | 0bc23071e156e227b95cb2f70eddb26909cfb59d (diff) | |
DB/Item: fix loot for Dented Crate.
The crate is supposed to always drop at least one item.
(cherry picked from commit 0800c807ac4c850bb7b74293f4fa14e6a367a505)
| -rw-r--r-- | sql/updates/world/master/2017_03_04_17_world_2016_10_01_03_world.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_03_04_17_world_2016_10_01_03_world.sql b/sql/updates/world/master/2017_03_04_17_world_2016_10_01_03_world.sql new file mode 100644 index 00000000000..378e2ea918f --- /dev/null +++ b/sql/updates/world/master/2017_03_04_17_world_2016_10_01_03_world.sql @@ -0,0 +1,4 @@ +-- +DELETE FROM `item_loot_template` WHERE `Entry`=6351 AND `Item`=2318; +UPDATE `item_loot_template` SET `Chance`=46.9 WHERE `Entry`=6351 AND `Item`=4364; +UPDATE `item_loot_template` SET `GroupId`=1 WHERE `Entry`=6351; |