DB/Loot: Add references for Level 70 Darkmoon Cards (5-8) & Books and use them in TK & SSC

Closes #24584

(cherry picked from commit 0b60b482730f03399104b64a69a14598cf137edc)

1 files changed, 111 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_01_02_15_world_2020_05_08_03_world.sql b/sql/updates/world/master/2022_01_02_15_world_2020_05_08_03_world.sql
new file mode 100644
index 00000000000..bec1b8e7b84
--- /dev/null
+++ b/sql/updates/world/master/2022_01_02_15_world_2020_05_08_03_world.sql
@@ -0,0 +1,111 @@
+--
+SET @ENTRY := 34118;
+DELETE FROM `reference_loot_template` WHERE `Entry` IN (@ENTRY,@ENTRY+1);
+INSERT INTO `reference_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`) VALUES
+(@ENTRY,31883,0,0,0,1,1,1,1),
+(@ENTRY,31884,0,0,0,1,1,1,1),
+(@ENTRY,31886,0,0,0,1,1,1,1),
+(@ENTRY,31887,0,0,0,1,1,1,1),
+(@ENTRY,31893,0,0,0,1,1,1,1),
+(@ENTRY,31894,0,0,0,1,1,1,1),
+(@ENTRY,31896,0,0,0,1,1,1,1),
+(@ENTRY,31898,0,0,0,1,1,1,1),
+(@ENTRY,31902,0,0,0,1,1,1,1),
+(@ENTRY,31903,0,0,0,1,1,1,1),
+(@ENTRY,31905,0,0,0,1,1,1,1),
+(@ENTRY,31906,0,0,0,1,1,1,1),
+(@ENTRY,31911,0,0,0,1,1,1,1),
+(@ENTRY,31912,0,0,0,1,1,1,1),
+(@ENTRY,31915,0,0,0,1,1,1,1),
+(@ENTRY,31916,0,0,0,1,1,1,1),
+(@ENTRY+1,22146,0,0,0,1,1,1,1),
+(@ENTRY+1,22153,0,0,0,1,1,1,1),
+(@ENTRY+1,29549,0,0,0,1,1,1,1),
+(@ENTRY+1,29550,0,0,0,1,1,1,1),
+(@ENTRY+1,31501,0,0,0,1,1,1,1),
+(@ENTRY+1,31837,0,0,0,1,1,1,1);
+
+DELETE FROM `creature_loot_template` WHERE `Entry` IN (20031,20032,20033,20034,20035,20036,20037,20038,20039,20040,20041,20042,20043,20044,20045,20046,20047,20048,20049,20050,20052,21218,21220,21221,21224,21225,21226,21227,21228,21229,21230,21231,21232,21246,21251,21263,21298,21299,21301,21339,21863) AND ((`Item` IN (31883,31884,31886,31887,31893,31894,31896,31898,31902,31903,31905,31906,31911,31912,31915,31916,22146,22153,29549,29550,31501,31837) AND `Reference` = 0) OR `Reference` IN (@ENTRY,@ENTRY+1));
+INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES
+(20031,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(20032,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(20033,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(20034,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(20035,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(20036,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(20037,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(20038,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(20039,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(20040,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(20041,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(20042,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(20043,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(20044,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(20045,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(20046,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(20047,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(20048,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(20049,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(20050,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(20052,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(21218,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(21220,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(21221,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(21224,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(21225,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(21226,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(21227,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(21228,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(21229,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(21230,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(21231,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(21232,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(21246,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(21251,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(21263,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(21298,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(21299,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(21301,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(21339,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(21863,@ENTRY,@ENTRY,0.01,0,1,0,1,1,"Darkmoon Cards Level 70 (5-8)"),
+(20031,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(20032,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(20033,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(20034,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(20035,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(20036,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(20037,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(20038,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(20039,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(20040,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(20041,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(20042,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(20043,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(20044,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(20045,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(20046,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(20047,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(20048,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(20049,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(20050,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(20052,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(21218,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(21220,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(21221,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(21224,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(21225,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(21226,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(21227,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(21228,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(21229,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(21230,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(21231,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(21232,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(21246,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(21251,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(21263,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(21298,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(21299,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(21301,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(21339,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70"),
+(21863,@ENTRY+1,@ENTRY+1,0.5,0,1,0,1,1,"Books Level 70");