diff options
| -rw-r--r-- | sql/updates/world/2011_04_11_01_world_creature_loot_template.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/2011_04_11_01_world_creature_loot_template.sql b/sql/updates/world/2011_04_11_01_world_creature_loot_template.sql new file mode 100644 index 00000000000..5d7a0f4687e --- /dev/null +++ b/sql/updates/world/2011_04_11_01_world_creature_loot_template.sql @@ -0,0 +1,12 @@ +-- Missing database loot entries for Mature Lasher +SET @lasher := 34300; +DELETE FROM `creature_loot_template` WHERE `entry`=@lasher; +INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES +(@lasher,37704,100,1,0,1,3), -- Crystalised Life +(@lasher,43324,-75,1,0,1,1), -- Alliance Herb Pouch +(@lasher,44809,-75,1,0,1,1), -- Horde Herb Pouch +(@lasher,44774,80,1,0,1,1), -- Ice-Piercing Thorn +(@lasher,44775,20,1,0,1,1); -- Revolting Flower + +-- Missing database harvest loot entries for Mature and Living Lasher +UPDATE `creature_template` SET `skinloot`=80007 WHERE `entry` IN (34300,30845); |