diff options
| author | Killyana <morphone1@gmail.com> | 2016-06-13 02:34:27 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2016-06-13 02:34:27 +0200 |
| commit | ab184414ae2a462c89433a8c0678bae1e69dee85 (patch) | |
| tree | e93605b29289f059207e43037a0f5690cc75b00a | |
| parent | edc2b557a00e95400b5d747b597ea697bd5fbb21 (diff) | |
DB/Loot: Fix drop chance and quantity for Rough/Coarse Stone and Copper/Tin ore from mining veins
Closes #17341
By SnapperRy
| -rw-r--r-- | sql/updates/world/3.3.5/2016_06_13_03_world_335.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_06_13_03_world_335.sql b/sql/updates/world/3.3.5/2016_06_13_03_world_335.sql new file mode 100644 index 00000000000..c4d80e13405 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_06_13_03_world_335.sql @@ -0,0 +1,4 @@ +-- +UPDATE `gameobject_loot_template` SET `Chance`=50, `MaxCount`=6 WHERE `Item`=2835 AND `Entry` IN (1502, 1735, 2626, 18092); +UPDATE `gameobject_loot_template` SET `Chance`=50, `MaxCount`=8 WHERE `Item`=2836 AND `Entry` IN (1503, 1736, 2627, 18093); +UPDATE `gameobject_loot_template` SET `MaxCount`=4 WHERE `Item` IN (2770, 2771) AND `Entry` IN (1502, 1503, 1735, 1736, 2626, 2627, 18092, 18093); |