[MoP] Archology Fragments

[Florix]

Patch made by narfnarf
Original: http://community.pandashan.com/index.php?/topic/26266-3426-3664/#entry237405

 

-- Dwarven
DELETE FROM `item_loot_template` WHERE `entry`=87533;
INSERT INTO `item_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(87533, 52843, 17, 1, 0, 1, 1),
(87533, 384, 90, 1, 0, 5, 10);

-- Draenei
DELETE FROM `item_loot_template` WHERE `entry`=87534;
INSERT INTO `item_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(57534, 64394, 14, 1, 0, 1, 1),
(57534, 398, 94, 1, 0, 5, 10);

-- Fossil
DELETE FROM `item_loot_template` WHERE `entry`=87535;
INSERT INTO `item_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(87535, 393, 95, 1, 0, 5, 10);

-- Nigh Elf
DELETE FROM `item_loot_template` WHERE `entry`=87536;
INSERT INTO `item_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(87536, 63127, 11, 1, 0, 1, 1),
(87536, 394, 94, 1, 0, 5, 10),
(87536, 385, 0.08, 1, 0, 5, 10);

-- Nerubian
DELETE FROM `item_loot_template` WHERE `entry`=87537;
INSERT INTO `item_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(87537, 64396, 15, 1, 0, 1, 1),
(57537, 400, 94, 1, 0, 5, 10);

-- Orc
DELETE FROM `item_loot_template` WHERE `entry`=87538;
INSERT INTO `item_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(87538, 64392, 12, 1, 0, 1, 1),
(87538, 397, 96, 1, 0, 5, 10);


-- Tol'Vir
DELETE FROM `item_loot_template` WHERE `entry`=87539;
INSERT INTO `item_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(87539, 64397, 12, 1, 0, 1, 1),
(87539, 97986, 3, 1, 0, 1, 1),
(87539, 401, 96, 1, 0, 5, 10);

-- Troll
DELETE FROM `item_loot_template` WHERE `entry`=87540;
INSERT INTO `item_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(87540, 63128, 11, 1, 0, 1, 1),
(87540, 385, 96, 1, 0, 5, 10);


-- Vrykul
DELETE FROM `item_loot_template` WHERE `entry`=87541;
INSERT INTO `item_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(87541, 64395, 13, 1, 0, 1, 1),
(87541, 399, 93, 1, 0, 5, 10),
(87541, 401, 0.17, 0, 5, 10);