Cata ore prospecting loot - 11/25

-- -----------------------------------
-- -- prospecting loot for Cata ore --
-- -----------------------------------

-- equal chancing the uncommon (green quality) gems - not sure if that's entirely correct, but >100% chance is a BAD setting
DELETE FROM `prospecting_loot_template` WHERE `entry` IN (53038, 52185, 52183); -- remove current prospecting defines
INSERT INTO `prospecting_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
-- Obsidium ore
        (53038, 52177, 0, 1, 1, 1, 2), --  Carnelian
        (53038, 52178, 0, 1, 1, 1, 2), --  Zephyrite
        (53038, 52179, 0, 1, 1, 1, 2), --  Alicite
        (53038, 52180, 0, 1, 1, 1, 2), --  Nightstone
        (53038, 52181, 0, 1, 1, 1, 2), --  Hessonite
        (53038, 52182, 0, 1, 1, 1, 2), --  Jasper
        (53038, 52190, 1.3, 1, 0, 1, 1), -- Inferno Ruby
        (53038, 52191, 1.2, 1, 0, 1, 1), -- Ocean Sapphire
        (53038, 52192, 1.2, 1, 0, 1, 1), -- Dream Emerald
        (53038, 52193, 1.2, 1, 0, 1, 1), -- Ember Topaz
        (53038, 52194, 1.3, 1, 0, 1, 1), -- Demonseye
        (53038, 52195, 1.2, 1, 0, 1, 1), -- Amberjewel
-- Elementium ore
        (52185, 52177, 0, 1, 1, 1, 2), -- Carnelian
        (52185, 52178, 0, 1, 1, 1, 2), -- Zephyrite
        (52185, 52179, 0, 1, 1, 1, 2), -- Alicite
        (52185, 52180, 0, 1, 1, 1, 2), -- Nightstone
        (52185, 52181, 0, 1, 1, 1, 2), -- Hessonite
        (52185, 52182, 0, 1, 1, 1, 2), -- Jasper
        (52185, 52190, 4.5, 1, 0, 1, 1), --  Inferno Ruby
        (52185, 52191, 4.4, 1, 0, 1, 1), --  Ocean Sapphire
        (52185, 52192, 4.6, 1, 0, 1, 1), --  Dream Emerald
        (52185, 52193, 4.5, 1, 0, 1, 1), --  Ember Topaz
        (52185, 52194, 4.5, 1, 0, 1, 1), --  Demonseye
        (52185, 52195, 4.5, 1, 0, 1, 1), --  Amberjewel
-- Pyrite ore
        (52183, 52327, 100, 1, 2, 1, 3), -- Volatile Earth
        (52183, 52177, 0, 1, 1, 1, 1), --  Carnelian
        (52183, 52178, 0, 1, 1, 1, 1), --  Zephyrite
        (52183, 52179, 0, 1, 1, 1, 1), --  Alicite
        (52183, 52180, 0, 1, 1, 1, 1), --  Nightstone
        (52183, 52181, 0, 1, 1, 1, 1), --  Hessonite
        (52183, 52182, 0, 1, 1, 1, 1), --  Jasper
        (52183, 52190, 6.9, 1, 0, 1, 2), --   Inferno Ruby
        (52183, 52191, 6.4, 1, 0, 1, 2), --   Ocean Sapphire
        (52183, 52192, 8.4, 1, 0, 1, 2), --   Dream Emerald
        (52183, 52193, 7.7, 1, 0, 1, 2), --   Ember Topaz
        (52183, 52194, 7.8, 1, 0, 1, 2), --   Demonseye
        (52183, 52195, 7, 1, 0, 1, 2); --   Amberjewel