aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorZxBiohazardZx <zxbiohazardzx@gmail.com>2012-04-20 20:06:24 +0200
committerZxBiohazardZx <zxbiohazardzx@gmail.com>2012-04-20 20:06:24 +0200
commitda9554b6a14a2e567eff943d924ad02c8cc4d01a (patch)
tree3b2ebd65464fd8e43f2e610b990463d5ce549f2f
parentd0fa53c087ea56e44fc1b9da498a27c20e45a385 (diff)
DB/Loot: Add Formula: Enchant Gloves - Angler in some lootscheme's
Closes #4602
-rw-r--r--sql/updates/world/2012_04_20_03_world_creature_loot_template.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/2012_04_20_03_world_creature_loot_template.sql b/sql/updates/world/2012_04_20_03_world_creature_loot_template.sql
new file mode 100644
index 00000000000..a0b586ee0d9
--- /dev/null
+++ b/sql/updates/world/2012_04_20_03_world_creature_loot_template.sql
@@ -0,0 +1,7 @@
+SET @ITEM := 50406; -- Formula: Enchant Gloves - Angler
+UPDATE `creature_template` SET `lootid` = `entry` WHERE `entry` IN(26343,26344,26336);
+DELETE FROM `creature_loot_template` WHERE `item`=@ITEM;
+INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES
+(26343, @ITEM, 1.1, 1, 0, 1, 1), -- Indu'Le Fisherman
+(26336, @ITEM, 0.9, 1, 0, 1, 1), -- Indu'Le Mystic
+(26344, @ITEM, 1, 1, 0, 1, 1); -- Indu'Le Warrior