
Originally Posted by
DarkSoul
possible fix for fel strength elixir.
Bug: Recipe: Fel Strength Elixir does not droped
Entry: 31680 - Recipe: Fel Strength Elixir
Database: UDB rev 325.
MaNGOS core: 4640 (Windows/Linux)
Addons: ScriptDev2
Links: bellow
This recipe does not droped, based on thottbot it must be droped from 4 npc.
Creature: Wrathwalker
SQL
DELETE FROM `creature_loot_template` WHERE (`entry`=19740) AND (`item`=31680);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrRef`, `QuestChanceOrGroup`, `mincount`, `maxcount`, `quest_freeforall`) VALUES (19740, 31680, 0.8, 0, 1, 1, 1);
Creature: Shadow Council Warlock
SQL
DELETE FROM `creature_loot_template` WHERE (`entry`=21302) AND (`item`=31680);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrRef`, `QuestChanceOrGroup`, `mincount`, `maxcount`, `quest_freeforall`) VALUES (21302, 31680, 0.1, 0, 1, 1, '');
Creature: Mo'arg Weaponsmith
SQL
DELETE FROM `creature_loot_template` WHERE (`entry`=19755) AND (`item`=31680);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrRef`, `QuestChanceOrGroup`, `mincount`, `maxcount`, `quest_freeforall`) VALUES (19755, 31680, 0.1, 0, 1, 1, '');
Creature: Terrormaster
SQL
DELETE FROM `creature_loot_template` WHERE (`entry`=21314) AND (`item`=31680);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrRef`, `QuestChanceOrGroup`, `mincount`, `maxcount`, `quest_freeforall`) VALUES (21314, 31680, 0.2, 0, 1, 1, '');
Share This Thread