diff options
| author | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2012-07-14 13:57:39 +0200 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2012-07-14 13:57:39 +0200 |
| commit | 02fa3684df308c1d2c6c5273e4011df9c464926e (patch) | |
| tree | 978a8ea19b3f649e93854713caa07eeea72589a7 | |
| parent | bf7ead977359024a45c3560a406ed509e2f2f425 (diff) | |
DB/Loot: Various Lootfixes for quest-related items
Closes #6951,#6957,#6980
| -rw-r--r-- | sql/updates/world/2012_07_14_00_world_creature_loot_template.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2012_07_14_00_world_creature_loot_template.sql b/sql/updates/world/2012_07_14_00_world_creature_loot_template.sql new file mode 100644 index 00000000000..f76e5519594 --- /dev/null +++ b/sql/updates/world/2012_07_14_00_world_creature_loot_template.sql @@ -0,0 +1,6 @@ +-- Gorilla Fang should always be able to drop (Exodius) +UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = ABS(`ChanceOrQuestChance`) WHERE `item`=2799; +-- Update "Count" Ungula's Mandible drop rate does not require quest to drop it starts one (gecko32) +UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = ABS(`ChanceOrQuestChance`) WHERE `item`=25459; +-- Tainted Hellboar Meat fix (ZxBiohazardZx) +UPDATE `quest_template` SET `RequiredSourceItemId1`=23270,`RequiredSourceItemCount1`=8 WHERE `Id`=9361; |