Prospecting_fixes_AMPM

-- //PROSPECTING//

SET @RefObsi1 := xxx; -- Green Quality Gem, diisi sendiri untuk reference_loot_template
SET @RefObsi2 := xxx; -- Blue Quality Gem, diisi sendiri
SET @RefElem1 := xxx; -- Green Quality Gem, diisi sendiri
SET @RefElem2 := xxx; -- Blue Quality Gem, diisi sendiri
SET @RefPyri1 := xxx; -- Green Quality Gem, diisi sendiri
SET @RefPyri2 := xxx; -- Blue Quality Gem, diisi sendiri

SET @Obsidium := 53038;
SET @Elementium := 52185;
SET @Pyrite := 52183;

DELETE FROM prospecting_loot_template WHERE entry IN (@Obsidium, @Elementium, @Pyrite);
DELETE FROM reference_loot_template WHERE entry IN (@RefObsi1, @RefObsi2, @RefElem1, @RefElem2, @RefPyri1, @RefPyri2);

-- Obsidium Ore
INSERT INTO prospecting_loot_template VALUES
(@Obsidium,1,98,1,0,-@RefObsi1,1), -- 98% chance uncommon gems
(@Obsidium,2,2,1,0,-@RefObsi2,1); -- 2% chance rare gems
INSERT INTO reference_loot_template VALUES
-- Uncommon gems, 1-2
(@RefObsi1,52177,0,1,1,1,2), -- Carnelian
(@RefObsi1,52181,0,1,1,1,2), -- Hessonite
(@RefObsi1,52182,0,1,1,1,2), -- Jasper
(@RefObsi1,52180,0,1,1,1,2), -- Nightstone
(@RefObsi1,52178,0,1,1,1,2), -- Zephyrite
(@RefObsi1,52179,0,1,1,1,2), -- Alicite
-- Rare gems, 1
(@RefObsi2,52192,0,1,1,1,1), -- Dream Emerald
(@RefObsi2,52190,0,1,1,1,1), -- Inferno Ruby
(@RefObsi2,52195,0,1,1,1,1), -- Amberjewel
(@RefObsi2,52194,0,1,1,1,1), -- Demonseye
(@RefObsi2,52193,0,1,1,1,1), -- Ember Topaz
(@RefObsi2,52191,0,1,1,1,1); -- Ocean Sapphire

-- Elementium Ore
INSERT INTO prospecting_loot_template VALUES
(@Elementium,1,95,1,0,-@RefElem1,1), -- 95% chance uncommon gems
(@Elementium,2,5,1,0,-@RefElem2,1); -- 5% chance rare gems
INSERT INTO reference_loot_template VALUES
-- Uncommon gems, 1-2
(@RefElem1,52177,0,1,1,1,2), -- Carnelian
(@RefElem1,52181,0,1,1,1,2), -- Hessonite
(@RefElem1,52182,0,1,1,1,2), -- Jasper
(@RefElem1,52180,0,1,1,1,2), -- Nightstone
(@RefElem1,52178,0,1,1,1,2), -- Zephyrite
(@RefElem1,52179,0,1,1,1,2), -- Alicite
-- Rare gems, 1-2
(@RefElem2,52192,0,1,1,1,2), -- Dream Emerald
(@RefElem2,52190,0,1,1,1,2), -- Inferno Ruby
(@RefElem2,52195,0,1,1,1,2), -- Amberjewel
(@RefElem2,52194,0,1,1,1,2), -- Demonseye
(@RefElem2,52193,0,1,1,1,2), -- Ember Topaz
(@RefElem2,52191,0,1,1,1,2); -- Ocean Sapphire

-- Pyrite Ore
INSERT INTO prospecting_loot_template VALUES
(@Pyrite,1,95,1,0,-@RefPyri1,1), -- 92% chance uncommon gems
(@Pyrite,2,5,1,0,-@RefPyri2,1), -- 8% chance rare gems
(@Pyrite,52327,100,1,1,1,3); -- Volatile Earth
INSERT INTO reference_loot_template VALUES
-- Uncommon gems, 1
(@RefPyri1,52177,0,1,1,1,1), -- Carnelian
(@RefPyri1,52181,0,1,1,1,1), -- Hessonite
(@RefPyri1,52182,0,1,1,1,1), -- Jasper
(@RefPyri1,52180,0,1,1,1,1), -- Nightstone
(@RefPyri1,52178,0,1,1,1,1), -- Zephyrite
(@RefPyri1,52179,0,1,1,1,1), -- Alicite
-- Rare gems, 1-2
(@RefPyri2,52192,0,1,1,1,2), -- Dream Emerald
(@RefPyri2,52190,0,1,1,1,2), -- Inferno Ruby
(@RefPyri2,52195,0,1,1,1,2), -- Amberjewel
(@RefPyri2,52194,0,1,1,1,2), -- Demonseye
(@RefPyri2,52193,0,1,1,1,2), -- Ember Topaz
(@RefPyri2,52191,0,1,1,1,2); -- Ocean Sapphire