DB/Item: Fix Deck of Trades

By Malcrom

1 files changed, 61 insertions, 0 deletions

diff --git a/sql/updates/world/6.x/2016_07_31_04_world.sql b/sql/updates/world/6.x/2016_07_31_04_world.sql
new file mode 100644
index 00000000000..a50b85bc8e2
--- /dev/null
+++ b/sql/updates/world/6.x/2016_07_31_04_world.sql
@@ -0,0 +1,61 @@
+-- Add items to spell_loot_template for "Deck of Trades" spell
+DELETE FROM `spell_loot_template` WHERE `Entry`=84193;
+INSERT INTO `spell_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
+(84193, 62559, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62558, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62562, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62557, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62561, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62560, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62554, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62552, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62553, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62563, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62555, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62556, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62567, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62573, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62572, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62574, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62575, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62576, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62571, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62570, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62566, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62565, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62247, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62568, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62569, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62564, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62588, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62580, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62581, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62579, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62591, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62246, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62577, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62582, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62578, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62590, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62583, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62589, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62587, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62584, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62585, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62586, 0, 2, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 60839, 0, 1, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62598, 0, 1, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62600, 0, 1, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62599, 0, 1, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62601, 0, 1, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62602, 0, 1, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 60841, 0, 1, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62604, 0, 1, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62603, 0, 1, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62605, 0, 1, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 60842, 0, 1, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 60843, 0, 1, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 62606, 0, 1, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 60845, 0, 1, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 60840, 0, 1, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card'),
+(84193, 60844, 0, 1, 0, 1, 1, 1, 1, 'Spell Deck of Trades creates Fortune Card');