From ab184414ae2a462c89433a8c0678bae1e69dee85 Mon Sep 17 00:00:00 2001 From: Killyana Date: Mon, 13 Jun 2016 02:34:27 +0200 Subject: DB/Loot: Fix drop chance and quantity for Rough/Coarse Stone and Copper/Tin ore from mining veins Closes #17341 By SnapperRy --- sql/updates/world/3.3.5/2016_06_13_03_world_335.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/3.3.5/2016_06_13_03_world_335.sql (limited to 'sql') 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); -- cgit v1.2.3