/*
Autor: Lansing
Ticket: #4563
Descr: New Oredeposit Loot
*/

/*Delete all Oredeposit loot*/
DELETE FROM `gameobject_loot_template` WHERE `entry` IN (24153, 24154, 24155, 24156, 24157);

/*Cobalt Deposit Loot= 24153*/
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(24153, 36909, 100, 0, 2, 9), /*Kobalterz*/

(24153, 37701, 30, 0, 1, 2), /*KristErde*/
(24153, 37705, 30, 0, 1, 2), /*KristWasser*/

(24153, 36917, 0.5, 1, 1, 1), /*Blutstein*/
(24153, 36923, 0.5, 1, 1, 1), /*Chalzedon*/
(24153, 36932, 0.5, 1, 1, 1), /*Nephrit*/
(24153, 36929, 0.5, 1, 1, 1), /*Riesencitrin*/
(24153, 36926, 0.5, 1, 1, 1), /*Schattenkristall*/
(24153, 36920, 0.5, 1, 1, 1), /*Sonnenkristall*/

(24153, 36924, 0.2, 2, 1, 1), /*Himmelssaphier*/
(24153, 36918, 0.2, 2, 1, 1), /*Scharlachrubin*/
(24153, 36927, 0.3, 2, 1, 1), /*Zwielichtopal*/
(24153, 36921, 0.2, 2, 1, 1), /*Herbstglimmer*/
(24153, 36930, 0.2, 2, 1, 1), /*Monarchentopas*/
(24153, 36933, 0.3, 2, 1, 1); /*Waldsmaragd*/


/*Rich Cobalt Deposit Loot= 24154*/
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(24154, 36909, 100, 0, 5, 12), /*Kobalterz*/

(24154, 37701, 65, 0, 1, 2), /*KristErde*/
(24154, 37705, 65, 0, 1, 2), /*KristWasser*/

(24154, 36917, 1.7, 1, 1, 1), /*Blutstein*/
(24154, 36923, 1.4, 1, 1, 1), /*Chalzedon*/
(24154, 36932, 1.5, 1, 1, 1), /*Nephrit*/
(24154, 36929, 1.5, 1, 1, 1), /*Riesencitrin*/
(24154, 36926, 1.7, 1, 1, 1), /*Schattenkristall*/
(24154, 36920, 1.4, 1, 1, 1), /*Sonnenkristall*/

(24154, 36924, 0.8, 2, 1, 1), /*Himmelssaphier*/
(24154, 36918, 0.8, 2, 1, 1), /*Scharlachrubin*/
(24154, 36927, 0.8, 2, 1, 1), /*Zwielichtopal*/
(24154, 36921, 0.9, 2, 1, 1), /*Herbstglimmer*/
(24154, 36930, 0.8, 2, 1, 1), /*Monarchentopas*/
(24154, 36933, 0.7, 2, 1, 1); /*Waldsmaragd*/


/*Saronit Deposit Loot= 24155*/
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(24155, 36912, 100, 0, 2, 9), /*Saroniterz*/

(24155, 37701, 45, 0, 1, 2), /*KristErde*/
(24155, 37703, 45, 0, 1, 2), /*Kristschatten*/

(24155, 36917, 0.5, 1, 1, 1), /*Blutstein*/
(24155, 36923, 0.5, 1, 1, 1), /*Chalzedon*/
(24155, 36932, 0.5, 1, 1, 1), /*Nephrit*/
(24155, 36929, 0.5, 1, 1, 1), /*Riesencitrin*/
(24155, 36926, 0.5, 1, 1, 1), /*Schattenkristall*/
(24155, 36920, 0.5, 1, 1, 1), /*Sonnenkristall*/

(24155, 36924, 0.3, 2, 1, 1), /*Himmelssaphier*/
(24155, 36918, 0.2, 2, 1, 1), /*Scharlachrubin*/
(24155, 36927, 0.3, 2, 1, 1), /*Zwielichtopal*/
(24155, 36921, 0.2, 2, 1, 1), /*Herbstglimmer*/
(24155, 36930, 0.2, 2, 1, 1), /*Monarchentopas*/
(24155, 36933, 0.2, 2, 1, 1); /*Waldsmaragd*/


/*Rich Saronit Deposit Loot= 24156*/
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(24156, 36912, 100, 0, 5, 12), /*Saroniterz*/

(24156, 37701, 50, 0, 2, 8), /*KristErde*/
(24156, 37703, 50, 0, 2, 8), /*Kristschatten*/

(24156, 36917, 8, 1, 1, 1), /*Blutstein*/
(24156, 36923, 8, 1, 1, 1), /*Chalzedon*/
(24156, 36932, 8, 1, 1, 1), /*Nephrit*/
(24156, 36929, 8, 1, 1, 1), /*Riesencitrin*/
(24156, 36926, 8, 1, 1, 1), /*Schattenkristall*/
(24156, 36920, 8, 1, 1, 1), /*Sonnenkristall*/

(24156, 36924, 0.8, 2, 1, 1), /*Himmelssaphier*/
(24156, 36918, 0.8, 2, 1, 1), /*Scharlachrubin*/
(24156, 36927, 0.8, 2, 1, 1), /*Zwielichtopal*/
(24156, 36921, 0.9, 2, 1, 1), /*Herbstglimmer*/
(24156, 36930, 0.9, 2, 1, 1), /*Monarchentopas*/
(24156, 36933, 0.8, 2, 1, 1); /*Waldsmaragd*/


/*Titan Vein Loot= 24157*/
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(24157, 36910, 100, 0, 2, 8), /*Titanerz*/

(24157, 37701, 49, 0, 3, 6), /*KristErde*/
(24157, 37705, 50, 0, 3, 6), /*KristWasser*/
(24157, 37700, 50, 0, 3, 6), /*KristLuft*/
(24157, 37702, 50, 0, 3, 6), /*KristFeuer*/

(24157, 36917, 8, 1, 1, 1), /*Blutstein*/
(24157, 36923, 8, 1, 1, 1), /*Chalzedon*/
(24157, 36932, 8, 1, 1, 1), /*Nephrit*/
(24157, 36929, 9, 1, 1, 1), /*Riesencitrin*/
(24157, 36926, 8, 1, 1, 1), /*Schattenkristall*/
(24157, 36920, 8, 1, 1, 1), /*Sonnenkristall*/

(24157, 36924, 1.7, 2, 1, 1), /*Himmelssaphier*/
(24157, 36918, 1.7, 2, 1, 1), /*Scharlachrubin*/
(24157, 36927, 1.7, 2, 1, 1), /*Zwielichtopal*/
(24157, 36921, 1.6, 2, 1, 1), /*Herbstglimmer*/
(24157, 36930, 1.6, 2, 1, 1), /*Monarchentopas*/
(24157, 36933, 1.6, 2, 1, 1); /*Waldsmaragd*/