diff options
| author | Rushor <PBienati@web.de> | 2015-03-23 19:32:00 +0100 |
|---|---|---|
| committer | Rushor <PBienati@web.de> | 2015-03-23 19:32:00 +0100 |
| commit | 65b171055346ca4e5b2fa817d2de0e4355f8224b (patch) | |
| tree | 827db2e32bb81caedef3ca2e1dbd2ce0fe722fb4 | |
| parent | 72bd107a159234ef4f4334f62cfd7177b4fcf304 (diff) | |
DB/Creature: Blackrock Worg Drops
by @danlapps + @Gecko60
closes #14218
| -rw-r--r-- | sql/updates/world/2015_03_23_02_world.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/2015_03_23_02_world.sql b/sql/updates/world/2015_03_23_02_world.sql new file mode 100644 index 00000000000..5dce75b6538 --- /dev/null +++ b/sql/updates/world/2015_03_23_02_world.sql @@ -0,0 +1,13 @@ +-- Blackrock Worg Drops with correct rates from wiki +UPDATE `creature_template` SET lootid=49871 WHERE entry=49871; +DELETE FROM `creature_loot_template` WHERE entry=49871; +INSERT INTO `creature_loot_template` (entry,item,Reference,Chance,QuestRequired,LootMode,GroupId,MinCount,MaxCount,Comment) VALUES +(49871, 62328, 0, 76, 0, 1, 0, 1, 1, 'Shed Fur'), +(49871, 3300, 0, 24, 0, 1, 0, 1, 1, 'Rabbit Foot'), +(49871, 5572, 0, 0.5, 0, 1, 0, 1, 1, 'Small Green Pouch'), +(49871, 5571, 0, 0.12, 0, 1, 0, 1, 1, 'Small Black Pouch'), +(49871, 828, 0, 0.09, 0, 1, 0, 1, 1, 'Small Blue Pouch'), +(49871, 805, 0, 0.1, 0, 1, 0, 1, 1, 'Small Red Pouch'), +(49871, 4496, 0, 0.12, 0, 1, 0, 1, 1, 'Small Brown Pouch'), +(49871, 2589, 0, 0.02, 0, 1, 0, 1, 1, 'Linen Cloth'), +(49871, 117, 0, 0.01, 0, 1, 0, 1, 1, 'Tough Jerky'); |