- 916
- 2015
- 24
- Location
- Barryton Michigan USA
Code:
-- 33961 33962 Scourge Device
DELETE FROM `creature_loot_template` WHERE `entry`=23643 AND `item`=33961;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23643, 33961, 1.4, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23644 AND `item`=33961;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23644, 33961, 4, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23645 AND `item`=33961;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23645, 33961, 3, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=24485 AND `item`=33961;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (24485, 33961, 5, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=24540 AND `item`=33961;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (24540, 33961, 3, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=24460 AND `item`=33961;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (24460, 33961, 1, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23643 AND `item`=33962;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23643, 33962, 5, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23644 AND `item`=33962;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23644, 33962, 6, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23645 AND `item`=33962;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23645, 33962, 5, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=24485 AND `item`=33962;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (24485, 33962, 4, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=24540 AND `item`=33962;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (24540, 33962, 3, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=24478 AND `item`=33962;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (24478, 33962, 3, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=24459 AND `item`=33962;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (24459, 33962, 1, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=24460 AND `item`=33962;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (24460, 33962, 1, 1, 0, 1, 1);