Crate_Treasure_Supplies_fix_AMPM

--//Item Loots
SET @FIRE := xxx; -- diisi sendiri untuk reference entry Fire Prism.
SET @SHINY := xxx; -- Bag of Shiny Things entry
SET @CRATE := xxx; -- Crate of Tasty Meat entry
SET @TINY := xxx; -- Tiny Treasure Chest entry

-- Fire Prism (http://www.wowhead.com/item=52304)
DELETE FROM item_loot_template WHERE entry=52304;
INSERT INTO item_loot_template VALUES (52304,52304,100,1,1,-@FIRE,1);

DELETE FROM reference_loot_template WHERE entry=@FIRE;
INSERT INTO reference_loot_template VALUES
(@FIRE,52194,38,1,1,1,3),
(@FIRE,52192,38,1,1,1,3),
(@FIRE,52193,38,1,1,1,3),
(@FIRE,52190,37,1,1,1,3),
(@FIRE,52195,37,1,1,1,3),
(@FIRE,52191,37,1,1,1,3),
(@FIRE,52196,10,1,1,1,1);

-- Imported Supplies (http://www.wowhead.com/item=68689)
DELETE FROM item_loot_template WHERE entry=68689;
INSERT INTO item_loot_template VALUES (68689,62786,100,1,1,5,20);

-- Bag of Shiny Things (http://www.wowhead.com/item=67414)
DELETE FROM item_loot_template WHERE entry=67414;
INSERT INTO item_loot_template VALUES (67414,67414,100,1,1,-@SHINY,4);

DELETE FROM reference_loot_template WHERE entry=@SHINY;
INSERT INTO reference_loot_template VALUES
(@SHINY,6532,42,1,1,1,1),
(@SHINY,8827,14,1,1,1,1),
(@SHINY,3820,14,1,1,2,3),
(@SHINY,2459,14,1,1,1,1),
(@SHINY,6372,14,1,1,1,1),
(@SHINY,67404,5,1,1,1,1),
(@SHINY,67406,5,1,1,1,1),
(@SHINY,67397,5,1,1,1,1),
(@SHINY,67398,5,1,1,1,1),
(@SHINY,67405,5,1,1,1,1),
(@SHINY,67411,5,1,1,1,1),
(@SHINY,67409,5,1,1,1,1),
(@SHINY,67402,5,1,1,1,1),
(@SHINY,67412,5,1,1,1,1),
(@SHINY,67403,5,1,1,1,1),
(@SHINY,67400,5,1,1,1,1),
(@SHINY,67391,5,1,1,1,1),
(@SHINY,67385,5,1,1,1,1),
(@SHINY,67388,5,1,1,1,1),
(@SHINY,67399,5,1,1,1,1),
(@SHINY,67401,5,1,1,1,1),
(@SHINY,67407,5,1,1,1,1),
(@SHINY,67386,5,1,1,1,1),
(@SHINY,67410,5,1,1,1,1),
(@SHINY,67408,5,1,1,1,1),
(@SHINY,929,2,1,1,1,1),
(@SHINY,33820,1.1,1,1,1,1),
(@SHINY,44983,1,1,1,1,1),
(@SHINY,34834,1,1,1,1,1),
(@SHINY,34109,1,1,1,1,1),
(@SHINY,45991,0.5,1,1,1,1),
(@SHINY,45992,0.5,1,1,1,1);

-- Crate of Tasty Meat (http://www.wowhead.com/item=65513)
DELETE FROM item_loot_template WHERE entry=65513;
INSERT INTO item_loot_template VALUES (65513,65513,100,1,1,-@CRATE,2);

DELETE FROM reference_loot_template WHERE entry=@CRATE;
INSERT INTO reference_loot_template VALUES
(@CRATE,62783,16,1,1,2,10),
(@CRATE,62784,16,1,1,2,10),
(@CRATE,62785,16,1,1,2,10),
(@CRATE,62782,16,1,1,2,10),
(@CRATE,62781,16,1,1,2,10),
(@CRATE,62780,16,1,1,2,10),
(@CRATE,62791,15,1,1,2,10),
(@CRATE,62779,15,1,1,2,10),
(@CRATE,62778,15,1,1,2,10),
(@CRATE,65505,13,1,1,1,1),
(@CRATE,65506,13,1,1,1,1),
(@CRATE,65502,13,1,1,1,1),
(@CRATE,65509,13,1,1,2,4),
(@CRATE,65501,12,1,1,1,1),
(@CRATE,65512,12,1,1,1,1),
(@CRATE,65511,12,1,1,1,1),
(@CRATE,65503,12,1,1,1,1);

-- Tiny Treasure Chest (http://www.wowhead.com/item=67539)
DELETE FROM item_loot_template WHERE entry=67539;
INSERT INTO item_loot_template VALUES (67539,67539,100,1,1,-@TINY,2);

DELETE FROM reference_loot_template WHERE entry=@TINY;
INSERT INTO reference_loot_template VALUES
(@TINY,53010,75,1,1,4,20),
(@TINY,52183,14,1,1,1,4),
(@TINY,52185,14,1,1,1,4),
(@TINY,52328,11,1,1,1,5),
(@TINY,52327,11,1,1,1,5),
(@TINY,52325,11,1,1,1,5),
(@TINY,52329,11,1,1,1,5),
(@TINY,52326,11,1,1,1,5),
(@TINY,67045,0.01,1,1,1,1),
(@TINY,68782,0.01,1,1,1,1),
(@TINY,66971,0.01,1,1,1,1),
(@TINY,67057,0.01,1,1,1,1),
(@TINY,66986,0.01,1,1,1,1),
(@TINY,67047,0.01,1,1,1,1),
(@TINY,67050,0.01,1,1,1,1),
(@TINY,67051,0.01,1,1,1,1),
(@TINY,67061,0.01,1,1,1,1),
(@TINY,66967,0.01,1,1,1,1),
(@TINY,66991,0.01,1,1,1,1),
(@TINY,66916,0.01,1,1,1,1),
(@TINY,68781,0.01,1,1,1,1),
(@TINY,68783,0.01,1,1,1,1),
(@TINY,68787,0.01,1,1,1,1),
(@TINY,68788,0.01,1,1,1,1),
(@TINY,68789,0.01,1,1,1,1),
(@TINY,66990,0.01,1,1,1,1),
(@TINY,66965,0.01,1,1,1,1),
(@TINY,66966,0.01,1,1,1,1),
(@TINY,66989,0.01,1,1,1,1),
(@TINY,66932,0.01,1,1,1,1);