- 916
- 2015
- 24
- Location
- Barryton Michigan USA
Dropping his head at 33 percent was wrong.
Code:
-- 23954 Ingvar The Plunderer
DELETE FROM `creature_loot_template` WHERE `entry`=23954 AND `item`=22829;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23954, 22829, 1, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23954 AND `item`=22832;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23954, 22832, 1, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23954 AND `item`=33330;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23954, 33330, -100, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23954 AND `item`=33444;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23954, 33444, 1, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23954 AND `item`=33454;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23954, 33454, 2, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23954 AND `item`=33470;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23954, 33470, 5, 1, 1, 2, 7);
DELETE FROM `creature_loot_template` WHERE `entry`=23954 AND `item`=35576;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23954, 35576, 25, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23954 AND `item`=35577;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23954, 35577, 28, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23954 AND `item`=35578;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23954, 35578, 25, 1, 0, 1, 1);