[WoD] Mining in Draenor

[Tavari]

-- https://firestorm-servers.com/en/report/see_report/32380

-- http://www.wowhead.com/object=228563/blackrock-deposit

DELETE FROM `gameobject_loot_template` WHERE `entry`='228563';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`,`itembonuses`) VALUES
('228563', '109118', '86', '1', '0', '1', '15',''),
('228563', '115508', '80', '1', '0', '1', '3',''),
('228563', '120945', '15', '1', '0', '1', '3',''),
('228563', '109992', '15', '1', '0', '1', '10',''),
('228563', '111349', '1.4', '1', '0', '1', '1','');
UPDATE `gameobject_template` SET `data1`='228563' WHERE `entry`='228563';

-- http://www.wowhead.com/object=228493/true-iron-deposit

DELETE FROM `gameobject_loot_template` WHERE `entry`='228493';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`,`itembonuses`) VALUES
('228493', '109119', '86', '1', '0', '1', '15',''),
('228493', '120945', '15', '1', '0', '1', '3',''),
('228493', '109991', '14', '1', '0', '1', '10',''),
('228493', '115508', '12', '1', '0', '1', '3',''),
('228493', '111349', '1.4', '1', '0', '1', '1','');
UPDATE `gameobject_template` SET `data1`='228493' WHERE `entry`='228493';

-- http://www.wowhead.com/object=228564/rich-blackrock-deposit

DELETE FROM `gameobject_loot_template` WHERE `entry`='228564';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`,`itembonuses`) VALUES
('228564', '109118', '88', '1', '0', '1', '20',''),
('228564', '115508', '88', '1', '0', '1', '5',''),
('228564', '120945', '28', '1', '0', '1', '3',''),
('228564', '109992', '12', '1', '0', '1', '9',''),
('228564', '111349', '1.1', '1', '0', '1', '1','');
UPDATE `gameobject_template` SET `data1`='228564' WHERE `entry`='228564';

-- http://www.wowhead.com/object=228510/rich-true-iron-deposit

DELETE FROM `gameobject_loot_template` WHERE `entry`='228510';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`,`itembonuses`) VALUES
('228510', '109119', '87', '1', '0', '1', '20',''),
('228510', '120945', '27', '1', '0', '1', '3',''),
('228510', '115508', '13', '1', '0', '1', '5',''),
('228510', '109991', '13', '1', '0', '1', '10',''),
('228510', '111349', '0.9', '1', '0', '1', '1','');
UPDATE `gameobject_template` SET `data1`='228510' WHERE `entry`='228510';

 

[Mikrole]

Patch Accepted, merged soon on Live Realm. Thanks!