From 6141d38269d19b280def8203d5b35e65f1208b93 Mon Sep 17 00:00:00 2001 From: Exodius Date: Sat, 16 Feb 2013 11:10:08 +0100 Subject: DB/Loot: + Remove Zulian Mudskunk from Zulian Crocolisk loot template Closes #9169 + Add Vicious Oil to Vicous Oil Closes #9147 --- sql/updates/world/2013_02_16_04_world_creature_loot_template.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/2013_02_16_04_world_creature_loot_template.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2013_02_16_04_world_creature_loot_template.sql b/sql/updates/world/2013_02_16_04_world_creature_loot_template.sql new file mode 100644 index 00000000000..6819b7aeb45 --- /dev/null +++ b/sql/updates/world/2013_02_16_04_world_creature_loot_template.sql @@ -0,0 +1,6 @@ +-- Remove Zulian Mudskunk from Zulian Crocolisk's loot template +DELETE FROM `creature_loot_template` WHERE `entry`=15043 and `item`=19975; +-- Add Vicious Oil (Item) into loot template of Vicious Oil (NPC) +DELETE FROM `creature_loot_template` WHERE `entry`=30325 and `item`=42640; +INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values +(30325,42640,-100,1,0,1,1); -- cgit v1.2.3