aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2016-06-15 10:48:47 +0200
committerGitHub <noreply@github.com>2016-06-15 10:48:47 +0200
commita76f6419ce125e7687bbe46133618989d649571b (patch)
treeb8dbe066677bff98323d50543d665099e49aa632 /sql
parent41123795843b3d8b30084360a7244295dac1d200 (diff)
DB/Quest: Hunting the Huntress
Closes #16064 by tkrokli
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/6.x/2016_06_15_03_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_06_15_03_world.sql b/sql/updates/world/6.x/2016_06_15_03_world.sql
new file mode 100644
index 00000000000..f1b024e2d30
--- /dev/null
+++ b/sql/updates/world/6.x/2016_06_15_03_world.sql
@@ -0,0 +1,6 @@
+--
+-- remove loot item 4893, 'Savannah Lion Tusk' from the loot table
+-- move loot item 5096 from Savannah Prowler (3425) to Savannah Huntress (3415)
+DELETE FROM `creature_loot_template` WHERE `Item` IN (4893,5096);
+INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES
+(3415, 5096, 0, 50.08, 1, 1, 0, 1, 1, NULL);