diff options
| author | Exodius <exodius@trinity.contrib> | 2013-02-16 11:10:08 +0100 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2013-02-16 11:10:08 +0100 |
| commit | 6141d38269d19b280def8203d5b35e65f1208b93 (patch) | |
| tree | 1f247a8a3c856ad0655b2b89b76d996f2a73ef2e | |
| parent | 4e1aae82b21d53e8b75a467f1bfb83b1627a5b87 (diff) | |
DB/Loot:
+ Remove Zulian Mudskunk from Zulian Crocolisk loot template Closes #9169
+ Add Vicious Oil to Vicous Oil Closes #9147
| -rw-r--r-- | sql/updates/world/2013_02_16_04_world_creature_loot_template.sql | 6 |
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); |