Fishing_cataclysm_fixes_AMPM

-- // FISHING //
SET @hyjal := 53067; -- dipake buat reference loot buat mancing di open water hyjal, 53067 diambil dari entry Striped Lurker, hanya contoh untuk mempermudah penomoran reference loot untuk fishing.
SET @lava := 62512; -- dipake buat reference loot buat mancing di open lava land, 62512(Small Animal Bone) seperti nomer di atas, untuk mempermudah.
SET @deepholm := 53068;
SET @uldum := 53066;
SET @coast1 := 53070; -- Uldum's coast
SET @coast2 := 53071; -- Tolbarad & Twilight Highlands coasts
SET @vashj := 53069;
SET @twilight := 53054;
SET @trash := 45190; -- trash loots from fishing

-- //Fishing in MOUNT HYJAL (616)//
DELETE FROM fishing_loot_template WHERE entry=616; -- open water hyjal
INSERT INTO fishing_loot_template VALUES
(616,@hyjal,99.2,1,1,-@hyjal,1),
(616,@trash,0.8,1,1,-@trash,1);
DELETE FROM fishing_loot_template WHERE entry=5040; -- the throne of flame
INSERT INTO fishing_loot_template VALUES
(5040,@lava,100,1,1,-@lava,1);

DELETE FROM reference_loot_template WHERE entry=@hyjal;
INSERT INTO reference_loot_template VALUES
(@hyjal,53067,33,1,1,1,1), -- Striped Lurker
(@hyjal,53062,50,1,1,1,1), -- Sharptooth
(@hyjal,52326,2,1,1,1,3), -- Volatile Water
(@hyjal,53063,15,1,1,1,1); -- Mountain Trout

-- //Fishing in DEEPHOLM (5042)//
DELETE FROM fishing_loot_template WHERE entry=5042;
INSERT INTO fishing_loot_template VALUES
(5042,@deepholm,99.2,1,1,-@deepholm,1),
(5042,@trash,0.8,1,1,-@trash,1);

DELETE FROM reference_loot_template WHERE entry=@deepholm;
INSERT INTO reference_loot_template VALUES
(@deepholm,53062,50,1,1,1,1), -- Sharptooth
(@deepholm,53068,33,1,1,1,1),-- Lavascale Catfish
(@deepholm,53065,15,1,1,1,1), -- Albino Catfish
(@deepholm,52326,2,1,1,1,3); -- Volatile Water

-- //Fishing in ULDUM (5034)//
-- uldum's inland (unfortunately 5034 = uldum's coastal)
DELETE FROM fishing_loot_template WHERE entry IN (5670,5668,5715,5642,5466,5666,5716,5585,5586,5499);
INSERT INTO fishing_loot_template VALUES
(5670,@uldum,99.2,1,1,-@uldum,1),
(5670,@trash,0.8,1,1,-@trash,1),
(5668,@uldum,99.2,1,1,-@uldum,1),
(5668,@trash,0.8,1,1,-@trash,1),
(5715,@uldum,99.2,1,1,-@uldum,1),
(5715,@trash,0.8,1,1,-@trash,1),
(5642,@uldum,99.2,1,1,-@uldum,1),
(5642,@trash,0.8,1,1,-@trash,1),
(5466,@uldum,99.2,1,1,-@uldum,1),
(5466,@trash,0.8,1,1,-@trash,1),
(5666,@uldum,99.2,1,1,-@uldum,1),
(5666,@trash,0.8,1,1,-@trash,1),
(5716,@uldum,99.2,1,1,-@uldum,1),
(5716,@trash,0.8,1,1,-@trash,1),
(5585,@uldum,99.2,1,1,-@uldum,1),
(5585,@trash,0.8,1,1,-@trash,1),
(5499,@uldum,99.2,1,1,-@uldum,1),
(5499,@trash,0.8,1,1,-@trash,1),
(5586,@uldum,99.2,1,1,-@uldum,1),
(5586,@trash,0.8,1,1,-@trash,1);
DELETE FROM fishing_loot_template WHERE entry=5034; -- uldum's coasts
INSERT INTO fishing_loot_template VALUES
(5034,@coast1,99.2,1,1,-@coast1,1),
(5034,@trash,0.8,1,1,-@trash,1);

DELETE FROM reference_loot_template WHERE entry=@uldum;
INSERT INTO reference_loot_template VALUES
(@uldum,53062,50,1,1,1,1), -- Sharptooth
(@uldum,53068,33,1,1,1,1),-- Lavascale Catfish
(@uldum,53066,15,1,1,1,1), -- Blackbelly Mudfish
(@uldum,52326,2,1,1,1,3); -- Volatile Water
DELETE FROM reference_loot_template WHERE entry=@coast1;
INSERT INTO reference_loot_template VALUES
(@coast1,53069,50,1,1,1,1), -- Murglesnout
(@coast1,53072,33,1,1,1,1), -- Deepsea Sagefish
(@coast1,53070,15,1,1,1,1), -- Fathom Eel
(@coast1,52985,1,1,1,1,2), -- Azshara's Veil
(@coast1,52326,1,1,1,1,2); -- Volatile Water

-- //Fishing in TOL'BARAD (5095) & PENINSULA (5389)//
DELETE FROM fishing_loot_template WHERE entry in (5095,5389);
INSERT INTO fishing_loot_template VALUES
(5095,@coast2,99.2,1,1,-@coast2,1),
(5095,@trash,0.8,1,1,-@trash,1),
(5389,@coast2,99.2,1,1,-@coast2,1),
(5389,@trash,0.8,1,1,-@trash,1);

-- //Fishing in VASH'JIR (5144,5145,4815)//
DELETE FROM fishing_loot_template WHERE entry IN (4815,5144,5145,5146);
INSERT INTO fishing_loot_template VALUES
(4815,@vashj,99.2,1,1,-@vashj,1), -- Kelp'thar Forest
(4815,@trash,0.8,1,1,-@trash,1),
(5144,@vashj,99.2,1,1,-@vashj,1), -- Shimmering Expanse
(5144,@trash,0.8,1,1,-@trash,1),
(5145,@vashj,99.2,1,1,-@vashj,1), -- Abyssal Depths
(5145,@trash,0.8,1,1,-@trash,1),
(5146,@vashj,99.2,1,1,-@vashj,1),
(5146,@trash,0.8,1,1,-@trash,1);

DELETE FROM reference_loot_template WHERE entry=@vashj;
INSERT INTO reference_loot_template VALUES
(@vashj,53069,50,1,1,1,1), -- Murglesnout
(@vashj,53072,15,1,1,1,1), -- Deepsea Sagefish
(@vashj,53070,30,1,1,1,1), -- Fathom Eel
(@vashj,53071,5,1,1,1,1); -- Algaelin Rockfish

-- //Fishing in TWILIGHT HIGHLANDS (4922)//
-- twilight's inland (unfortunately 4922 = twilight's coastal)
DELETE FROM fishing_loot_template WHERE entry IN (5155,5563,5473,5472,5000,5353,5595,5143);
INSERT INTO fishing_loot_template VALUES
(5155,@twilight,99.2,1,1,-@twilight,1),
(5155,@trash,0.8,1,1,-@trash,1),
(5563,@twilight,99.2,1,1,-@twilight,1),
(5563,@trash,0.8,1,1,-@trash,1),
(5473,@twilight,99.2,1,1,-@twilight,1),
(5473,@trash,0.8,1,1,-@trash,1),
(5472,@twilight,99.2,1,1,-@twilight,1),
(5472,@trash,0.8,1,1,-@trash,1),
(5000,@twilight,99.2,1,1,-@twilight,1),
(5000,@trash,0.8,1,1,-@trash,1),
(5353,@twilight,99.2,1,1,-@twilight,1),
(5353,@trash,0.8,1,1,-@trash,1),
(5595,@twilight,99.2,1,1,-@twilight,1),
(5595,@trash,0.8,1,1,-@trash,1),
(5143,@twilight,99.2,1,1,-@twilight,1),
(5143,@trash,0.8,1,1,-@trash,1);
DELETE FROM fishing_loot_template WHERE entry=4922; -- twilight's coasts
INSERT INTO fishing_loot_template VALUES
(4922,@coast2,99.2,1,1,-@coast2,1),
(4922,@trash,0.8,1,1,-@trash,1);
DELETE FROM fishing_loot_template WHERE entry=5667; -- cannon's inferno
INSERT INTO fishing_loot_template VALUES
(5667,@lava,100,1,1,-@lava,1);

DELETE FROM reference_loot_template WHERE entry=@twilight;
INSERT INTO reference_loot_template VALUES
(@twilight,53067,33,1,1,1,1), -- Striped Lurker
(@twilight,53062,50,1,1,1,1), -- Sharptooth
(@twilight,52326,2,1,1,1,2), -- Volatile Water
(@twilight,53064,15,1,1,1,1); -- Highland Guppy

-- // FISHING MISC //
-- Open lava lands loots
DELETE FROM reference_loot_template WHERE entry=@lava;
INSERT INTO reference_loot_template VALUES
(@lava,62512,40,1,1,1,1), -- Small Animal Bone
(@lava,6297,40,1,1,1,1), -- Old Skull
(@lava,3857,10,1,1,1,1), -- Coal
(@lava,62065,5,1,1,1,1), -- Melted Cleaver
(@lava,52325,5,1,1,1,2); -- Volatile Fire

-- Coast 2
DELETE FROM reference_loot_template WHERE entry=@coast2;
INSERT INTO reference_loot_template VALUES
(@coast2,53069,50,1,1,1,1), -- Murglesnout
(@coast2,53072,33,1,1,1,1), -- Deepsea Sagefish
(@coast2,53071,15,1,1,1,1), -- Algaelin Rockfish
(@coast2,52985,1,1,1,1,2), -- Azshara's Veil
(@coast2,52326,1,1,1,1,2); -- Volatile Water

-- Random trashes loots
DELETE FROM reference_loot_template WHERE entry=@trash;
INSERT INTO reference_loot_template VALUES
(@trash,45190,1,1,1,1,1), -- trashes..
(@trash,45200,1,1,1,1,1),
(@trash,45194,1,1,1,1,1),
(@trash,45196,1,1,1,1,1),
(@trash,45198,1,1,1,1,1),
(@trash,45195,0.02,1,1,1,1),
(@trash,45199,0.02,1,1,1,1),
(@trash,45197,0.02,1,1,1,1),
(@trash,45202,0.02,1,1,1,1),
(@trash,45201,0.02,1,1,1,1);