diff options
| -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'); |