diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2020_05_03_02_world.sql | 84 |
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"); + |