From d1e8aa2f8f956555b853e3da3b9f8abaaa769b1f Mon Sep 17 00:00:00 2001 From: ZxBiohazardZx Date: Mon, 11 Apr 2011 20:51:31 +0200 Subject: DB/Loot: add Mature Lasher loot table fixes #719 --- .../world/2011_04_11_01_world_creature_loot_template.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/world/2011_04_11_01_world_creature_loot_template.sql (limited to 'sql') 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); -- cgit v1.2.3