TrinityCore/TrinityCore — Issue #5269: [DB\FIX][LOOT] Apprentice Osterkilgr
Author: Valcorb
Created: 2012-02-16 18:26:32+00:00
State: open

```sql

SET @ENTRY := 30409; -- Apprentice Osterkilgr
DELETE FROM `creature_loot_template` WHERE entry=@ENTRY;
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES
(@ENTRY, 45912, 0.1, 1, 0, 1, 1),
(@ENTRY, 43089, 98, 1, 0, 1, 1),
(@ENTRY, 33470, 24, 1, 0, 1, 4),
(@ENTRY, 42422, 3, 1, 0, 1, 1),
(@ENTRY, 42772, 70, 1, 0, 1, 1);