diff options
| author | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2012-02-21 20:44:35 +0100 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2012-02-21 20:44:35 +0100 |
| commit | 9dbcdf0eb16be69c5f1d2c2368aecbf521230be7 (patch) | |
| tree | 1543bacf8f036b41671dba787052dc654837bd0e | |
| parent | 3b8510e65a37f85b311eb927c5750a6a0c2402ca (diff) | |
DB/Loot: Add loot for Apprentice Osterkilgr
Closes #5269
| -rw-r--r-- | sql/updates/world/2012_02_21_04_world_creature_loot_template.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/2012_02_21_04_world_creature_loot_template.sql b/sql/updates/world/2012_02_21_04_world_creature_loot_template.sql new file mode 100644 index 00000000000..3deedbf0b0d --- /dev/null +++ b/sql/updates/world/2012_02_21_04_world_creature_loot_template.sql @@ -0,0 +1,16 @@ +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 +-- Quest related Items +(@ENTRY,43089,-100,1,0,1,1), -- Vrykul Bones +(@ENTRY,42772,-100,1,0,1,1), -- Dr Terrible's "Building a Better Flesh Giant" +(@ENTRY,42422,-50,1,0,1,1), -- Jotunheim Cage Key +-- Other random stuff +(@ENTRY,33470,20,1,0,1,4), -- Frostweave Cloth +(@ENTRY,43851,20,1,0,1,1), -- Fur Clothing Scraps +(@ENTRY,43852,20,1,0,1,1), -- Thick Fur Clothing Scraps +-- References for world drops +(@ENTRY,1,10,1,0,-35063,1), -- Northrend Grey Items +(@ENTRY,2,5,1,0,-35066,1), -- Northrend Green Items +-- hatebook +(@ENTRY,45912,0.1,1,0,1,1); -- Book Glyph of Mastery (honestly screw that thing) |