aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorzxbiohazardzx <zxbiohazardzx@gmail.com>2011-11-14 00:52:14 +0100
committerZxBiohazardZx <zxbiohazardzx@gmail.com>2011-11-14 00:52:14 +0100
commit38349a63e45e9148e61ae5366dd1cfbf50470582 (patch)
treee942e7ff10184ed22e1744f61de4db2fe4a8a8b0
parent145b9c05d7119d28002f0b87fd6f46eb19d056c1 (diff)
DB/Loot: Drakkari Offerings should also drop while not on a quest
fixes #3299
-rw-r--r--sql/updates/world/2011_11_13_10_world_creature_loot_template.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/world/2011_11_13_10_world_creature_loot_template.sql b/sql/updates/world/2011_11_13_10_world_creature_loot_template.sql
new file mode 100644
index 00000000000..3052ba96745
--- /dev/null
+++ b/sql/updates/world/2011_11_13_10_world_creature_loot_template.sql
@@ -0,0 +1,2 @@
+-- Drakkari Offerings should also drop when NOT on a quest:
+UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=ABS(`ChanceOrQuestChance`) WHERE `item`=38551;