loot mineria cata ejemplo

loot mineria cata ejemplo

-- Corregido loot de los Depósitos de Minería de Cataclysm

SET @OBSIDIUM := 202736;
SET @OBSIDIUM_RICO := 202739;
SET @ELEMENTIUM := 202738;
SET @ELEMENTIUM_RICO := 202741;
SET @PIRITA := 202737;
SET @PIRITA_RICA := 202740;

SET @OBSIDIUM_LOOT := 28490;
SET @OBSIDIUM_RICO_LOOT := 28495;
SET @ELEMENTIUM_LOOT := 202738;
SET @ELEMENTIUM_RICO_LOOT := 202741;
SET @PIRITA_LOOT := 28491;
SET @PIRITA_RICA_LOOT := 202740;

SET @ELEMENTIUM_LOOT_NUEVO := 28492;
SET @ELEMENTIUM_RICO_LOOT_NUEVO := 28493;
SET @PIRITA_RICA_LOOT_NUEVO := 28494;


-- Actualizados data1 (lootid)
UPDATE `gameobject_template` SET `data1`=@ELEMENTIUM_LOOT_NUEVO WHERE `entry`=@ELEMENTIUM;
UPDATE `gameobject_template` SET `data1`=@ELEMENTIUM_RICO_LOOT_NUEVO WHERE `entry`=@ELEMENTIUM_RICO;
UPDATE `gameobject_template` SET `data1`=@PIRITA_RICA_LOOT_NUEVO WHERE `entry`=@PIRITA_RICA;


DELETE FROM `gameobject_loot_template` WHERE `entry` IN (@OBSIDIUM_LOOT,@OBSIDIUM_RICO_LOOT,@ELEMENTIUM_LOOT,@ELEMENTIUM_RICO_LOOT,@PIRITA_LOOT,@PIRITA_RICA_LOOT);
DELETE FROM `gameobject_loot_template` WHERE `entry` IN (@ELEMENTIUM_LOOT_NUEVO,@ELEMENTIUM_RICO_LOOT_NUEVO,@PIRITA_RICA_LOOT_NUEVO);
INSERT INTO `gameobject_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES
-- Obsidium
(@OBSIDIUM_LOOT,53038,100,1,0,2,9),  -- Mena de obsidium
(@OBSIDIUM_LOOT,52327,10,1,0,1,2),   -- Tierra volátil
(@OBSIDIUM_LOOT,52328,1.8,1,0,1,2),  -- Aire volátil
(@OBSIDIUM_LOOT,52179,0.8,1,0,1,1),  -- Alicita
(@OBSIDIUM_LOOT,52178,0.8,1,0,1,1),  -- Cefirita
(@OBSIDIUM_LOOT,52177,0.8,1,0,1,1),  -- Cornalina
(@OBSIDIUM_LOOT,52181,0.8,1,0,1,1),  -- Grosularia
(@OBSIDIUM_LOOT,52182,0.8,1,0,1,1),  -- Jaspe
(@OBSIDIUM_LOOT,52180,0.8,1,0,1,1),  -- Piedra nocturna
(@OBSIDIUM_LOOT,52194,0.17,1,0,1,1), -- Ojo de demonio
(@OBSIDIUM_LOOT,52193,0.17,1,0,1,1), -- Topacio de ascuas
(@OBSIDIUM_LOOT,52191,0.17,1,0,1,1), -- Zafiro oceánico
(@OBSIDIUM_LOOT,52195,0.16,1,0,1,1), -- Ambarina
(@OBSIDIUM_LOOT,52192,0.16,1,0,1,1), -- Esmeralda onírica
(@OBSIDIUM_LOOT,52190,0.16,1,0,1,1), -- Rubí inferno
-- Obsidium Rico
(@OBSIDIUM_RICO_LOOT,53038,100,1,0,5,12), -- Mena de obsidium
(@OBSIDIUM_RICO_LOOT,52327,19,1,0,1,4),   -- Tierra volátil
(@OBSIDIUM_RICO_LOOT,52328,4,1,0,1,2),    -- Aire volátil
(@OBSIDIUM_RICO_LOOT,52179,0.9,1,0,1,1),  -- Alicita
(@OBSIDIUM_RICO_LOOT,52181,0.9,1,0,1,1),  -- Grosularia
(@OBSIDIUM_RICO_LOOT,52177,0.8,1,0,1,1),  -- Cornalina
(@OBSIDIUM_RICO_LOOT,52182,0.8,1,0,1,1),  -- Jaspe
(@OBSIDIUM_RICO_LOOT,52180,0.8,1,0,1,1),  -- Piedra nocturna
(@OBSIDIUM_RICO_LOOT,52178,0.7,1,0,1,1),  -- Cefirita
(@OBSIDIUM_RICO_LOOT,52192,0.18,1,0,1,1), -- Esmeralda onírica
(@OBSIDIUM_RICO_LOOT,52193,0.17,1,0,1,1), -- Topacio de ascuas
(@OBSIDIUM_RICO_LOOT,52194,0.16,1,0,1,1), -- Ojo de demonio
(@OBSIDIUM_RICO_LOOT,52195,0.15,1,0,1,1), -- Ambarina
(@OBSIDIUM_RICO_LOOT,52190,0.15,1,0,1,1), -- Rubí inferno
(@OBSIDIUM_RICO_LOOT,52191,0.15,1,0,1,1), -- Zafiro oceánico
-- Elementium
(@ELEMENTIUM_LOOT_NUEVO,52185,100,1,0,1,9),  -- Mena de elementium
(@ELEMENTIUM_LOOT_NUEVO,52326,10,1,0,1,2),   -- Agua volátil
(@ELEMENTIUM_LOOT_NUEVO,52325,10,1,0,1,2),   -- Fuego volátil
(@ELEMENTIUM_LOOT_NUEVO,52327,10,1,0,1,2),   -- Tierra volátil
(@ELEMENTIUM_LOOT_NUEVO,52328,2,1,0,1,2),    -- Aire volátil
(@ELEMENTIUM_LOOT_NUEVO,52179,0.8,1,0,1,1),  -- Alicita
(@ELEMENTIUM_LOOT_NUEVO,52178,0.8,1,0,1,1),  -- Cefirita
(@ELEMENTIUM_LOOT_NUEVO,52177,0.8,1,0,1,1),  -- Cornalina
(@ELEMENTIUM_LOOT_NUEVO,52181,0.8,1,0,1,1),  -- Grosularia
(@ELEMENTIUM_LOOT_NUEVO,52182,0.8,1,0,1,1),  -- Jaspe
(@ELEMENTIUM_LOOT_NUEVO,52180,0.8,1,0,1,1),  -- Piedra nocturna
(@ELEMENTIUM_LOOT_NUEVO,52193,0.17,1,0,1,1), -- Topacio de ascuas
(@ELEMENTIUM_LOOT_NUEVO,52195,0.16,1,0,1,1), -- Ambarina
(@ELEMENTIUM_LOOT_NUEVO,52192,0.16,1,0,1,1), -- Esmeralda onírica
(@ELEMENTIUM_LOOT_NUEVO,52194,0.16,1,0,1,1), -- Ojo de demonio
(@ELEMENTIUM_LOOT_NUEVO,52190,0.16,1,0,1,1), -- Rubí inferno
(@ELEMENTIUM_LOOT_NUEVO,52191,0.16,1,0,1,1), -- Zafiro oceánico
(@ELEMENTIUM_LOOT_NUEVO,67282,0.05,1,0,1,1), -- Geoda de elementium
-- Elementium Rico
(@ELEMENTIUM_RICO_LOOT_NUEVO,52185,100,1,0,5,12), -- Mena de elementium
(@ELEMENTIUM_RICO_LOOT_NUEVO,52325,20,1,0,1,2),   -- Fuego volátil
(@ELEMENTIUM_RICO_LOOT_NUEVO,52326,19,1,0,1,2),   -- Agua volátil
(@ELEMENTIUM_RICO_LOOT_NUEVO,52327,19,1,0,1,2),   -- Tierra volátil
(@ELEMENTIUM_RICO_LOOT_NUEVO,52328,4,1,0,1,2),    -- Aire volátil
(@ELEMENTIUM_RICO_LOOT_NUEVO,52182,0.9,1,0,1,1),  -- Jaspe
(@ELEMENTIUM_RICO_LOOT_NUEVO,52179,0.8,1,0,1,1),  -- Alicita
(@ELEMENTIUM_RICO_LOOT_NUEVO,52178,0.8,1,0,1,1),  -- Cefirita
(@ELEMENTIUM_RICO_LOOT_NUEVO,52177,0.8,1,0,1,1),  -- Cornalina
(@ELEMENTIUM_RICO_LOOT_NUEVO,52181,0.8,1,0,1,1),  -- Grosularia
(@ELEMENTIUM_RICO_LOOT_NUEVO,52180,0.8,1,0,1,1),  -- Piedra nocturna
(@ELEMENTIUM_RICO_LOOT_NUEVO,52195,0.16,1,0,1,1), -- Ambarina
(@ELEMENTIUM_RICO_LOOT_NUEVO,52192,0.16,1,0,1,1), -- Esmeralda onírica
(@ELEMENTIUM_RICO_LOOT_NUEVO,52194,0.16,1,0,1,1), -- Ojo de demonio
(@ELEMENTIUM_RICO_LOOT_NUEVO,52190,0.16,1,0,1,1), -- Rubí inferno
(@ELEMENTIUM_RICO_LOOT_NUEVO,52193,0.16,1,0,1,1), -- Topacio de ascuas
(@ELEMENTIUM_RICO_LOOT_NUEVO,52191,0.16,1,0,1,1), -- Zafiro oceánico
(@ELEMENTIUM_RICO_LOOT_NUEVO,67282,0.08,1,0,1,1), -- Geoda de elementium
-- Pirita
(@PIRITA_LOOT,52183,100,1,0,2,8),  -- Mena de pirita
(@PIRITA_LOOT,52325,10,1,0,1,2),   -- Fuego volátil
(@PIRITA_LOOT,52328,7,1,0,1,2),    -- Aire volátil
(@PIRITA_LOOT,52179,0.8,1,0,1,1),  -- Alicita
(@PIRITA_LOOT,52178,0.8,1,0,1,1),  -- Cefirita
(@PIRITA_LOOT,52177,0.8,1,0,1,1),  -- Cornalina
(@PIRITA_LOOT,52181,0.8,1,0,1,1),  -- Grosularia
(@PIRITA_LOOT,52182,0.8,1,0,1,1),  -- Jaspe
(@PIRITA_LOOT,52180,0.8,1,0,1,1),  -- Piedra nocturna
(@PIRITA_LOOT,52193,0.18,1,0,1,1), -- Topacio de ascuas
(@PIRITA_LOOT,52192,0.16,1,0,1,1), -- Esmeralda onírica
(@PIRITA_LOOT,52191,0.16,1,0,1,1), -- Zafiro oceánico
(@PIRITA_LOOT,52195,0.15,1,0,1,1), -- Ambarina
(@PIRITA_LOOT,52194,0.15,1,0,1,1), -- Ojo de demonio
(@PIRITA_LOOT,52190,0.15,1,0,1,1), -- Rubí inferno
-- Pirita Rica
(@PIRITA_RICA_LOOT_NUEVO,52183,100,1,0,5,11), -- Mena de pirita
(@PIRITA_RICA_LOOT_NUEVO,52325,19,1,0,1,3),   -- Fuego volátil
(@PIRITA_RICA_LOOT_NUEVO,52328,14,1,0,1,2),   -- Aire volátil
(@PIRITA_RICA_LOOT_NUEVO,52181,0.9,1,0,1,1),  -- Grosularia
(@PIRITA_RICA_LOOT_NUEVO,52179,0.8,1,0,1,1),  -- Alicita
(@PIRITA_RICA_LOOT_NUEVO,52178,0.8,1,0,1,1),  -- Cefirita
(@PIRITA_RICA_LOOT_NUEVO,52177,0.8,1,0,1,1),  -- Cornalina
(@PIRITA_RICA_LOOT_NUEVO,52180,0.8,1,0,1,1),  -- Piedra nocturna
(@PIRITA_RICA_LOOT_NUEVO,52182,0.7,1,0,1,1),  -- Jaspe
(@PIRITA_RICA_LOOT_NUEVO,52192,0.2,1,0,1,1),  -- Esmeralda onírica
(@PIRITA_RICA_LOOT_NUEVO,52194,0.18,1,0,1,1), -- Ojo de demonio
(@PIRITA_RICA_LOOT_NUEVO,52191,0.17,1,0,1,1), -- Zafiro oceánico
(@PIRITA_RICA_LOOT_NUEVO,52195,0.16,1,0,1,1), -- Ambarina
(@PIRITA_RICA_LOOT_NUEVO,52190,0.16,1,0,1,1), -- Rubí inferno
(@PIRITA_RICA_LOOT_NUEVO,52193,0.15,1,0,1,1); -- Topacio de ascuas