aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/2013_02_16_04_world_creature_loot_template.sql6
1 files changed, 6 insertions, 0 deletions
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);