DB/Loot: Add reference for Green Hills of Stranglethorn Pages

Closes #24547

1 files changed, 84 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2020_05_03_02_world.sql b/sql/updates/world/3.3.5/2020_05_03_02_world.sql
new file mode 100644
index 00000000000..2a81e49f2f7
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_05_03_02_world.sql
@@ -0,0 +1,84 @@
+-- 
+UPDATE `creature_loot_template` SET `Comment` = "Green Hills of Stranglethorn Pages" WHERE `Item` = 44011 AND `Reference` = 44011;
+DELETE FROM `creature_loot_template` WHERE `Item` IN (2725,2728,2730,2732,2734,2735,2738,2740,2742,2744,2745,2748,2749,2750,2751);
+DELETE FROM `creature_loot_template` WHERE `Item` = 44011 AND `Reference` = 44011 AND `Entry` NOT IN (1059,1060,1061,1062,1094,1095,1096,1097,1142,1144,1488,1489,1490,1491,1492,1493,1494,1561,1653);
+INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES
+(587,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(588,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(595,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(597,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(660,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(667,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(669,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(670,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(671,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(672,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(674,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(675,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(676,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(677,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(678,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(679,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(680,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(694,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(696,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(697,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(699,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(701,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(702,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(709,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(710,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(723,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(775,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(780,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(781,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(782,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(783,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(784,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(813,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(814,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(815,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(818,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(871,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(873,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(875,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(877,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(879,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(921,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(937,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(938,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(939,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(940,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(941,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(942,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(943,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(978,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(979,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(1907,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(2530,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(2534,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(2535,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(2536,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(2537,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(2541,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(2545,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(2546,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(2547,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(2548,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(2549,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(2550,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(2551,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(2624,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(4260,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(4457,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(4458,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(4459,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(4460,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(4461,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(4505,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(4506,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(4723,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(14487,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(14488,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages"),
+(14492,44011,44011,10,0,1,0,1,1,"Green Hills of Stranglethorn Pages");
+