[Legion]: BUG RARES LOOT (XP POTIONS)

[Herculano]

Title: BUG RARES LOOT (XP POTIONS)
Bugtracker Link:

https://firestorm-servers.com/es/report/see_report/32821

Patch Content:

-- Xelganak
-- http://www.wowhead.com/npc=86835
UPDATE `creature_template` SET lootid='86835' WHERE entry='86835';
DELETE FROM `creature_loot_template` WHERE entry='86835';
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
('86835', '118099', '0','68.29','0', '1', '0', '2', '10', ''),
('86835', '118661', '0','99.79','0', '1', '0', '1', '1', ''),
('86835', '120170', '0','11.57','0', '1', '0', '1', '1', '');

-- Direhoof
-- http://www.wowhead.com/npc=86729
UPDATE `creature_template` SET lootid='86729' WHERE entry='86729';
DELETE FROM `creature_loot_template` WHERE entry='86729';
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
('86729', '109134', '0','0.13', '0','1', '0', '1', '1', ''),
('86729', '111557', '0','0.13', '0','1', '0', '1', '1', ''),
('86729', '118099', '0','54.03','0', '1', '0', '2', '10', ''),
('86729', '118657', '0','99.86', '0','1', '0', '1', '1', ''),
('86729', '120170', '0','11.56', '0','1', '0', '1', '1', '');

UPDATE `creature_template` SET skinloot='86729' WHERE entry='86729';
DELETE FROM `skinning_loot_template` WHERE entry='86729';
INSERT INTO `skinning_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`)  VALUES
('86729', '110609', '0','0.11','0', '1', '0', '1', '3', ''),
('86729', '110610', '0','0.17', '0','1', '0', '1', '3', ''),
('86729', '120945', '0','0.17','0', '1', '0', '1', '3', '');

-- Dekorhan
-- http://www.wowhead.com/npc=86743

UPDATE `creature_template` SET lootid='86743' WHERE entry='86743';
DELETE FROM `creature_loot_template` WHERE entry='86743';
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
('86743', '109131', '0','0.13',	'0', '1', '0', '1', '1', ''),
('86743', '118099', '0','51.47','0', '1', '0', '2', '10', ''),
('86743', '118656', '0','99.96', '0','1', '0', '1', '1', ''),
('86743', '120170', '0','12.05', '0','1', '0', '1', '1', '');

UPDATE `creature_template` SET skinloot='86743' WHERE entry='86743';
DELETE FROM `skinning_loot_template` WHERE entry='86743';
INSERT INTO `skinning_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`)  VALUES
('86743', '110609', '0','0.1','0', '1', '0', '1', '3', ''),
('86743', '110610', '0','0.16','0', '1', '0', '1', '3', ''),
('86743', '111351', '0','0', '1','0', '0', '1', '1', ''),
('86743', '120945', '0','0.16', '0','1', '0', '1', '3', '');