From 3c6059bf446087b9c8b1704d634efdb9f02eaefb Mon Sep 17 00:00:00 2001 From: Aokromes Date: Wed, 15 Jun 2016 10:38:27 +0200 Subject: DB/Item: missing TCG loot from Landro's Pet Box & Gift Box Closes #15948 by tkrokli --- sql/updates/world/3.3.5/2016_06_15_02_world.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 sql/updates/world/3.3.5/2016_06_15_02_world.sql (limited to 'sql/updates/world') diff --git a/sql/updates/world/3.3.5/2016_06_15_02_world.sql b/sql/updates/world/3.3.5/2016_06_15_02_world.sql new file mode 100644 index 00000000000..b94af5ec293 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_06_15_02_world.sql @@ -0,0 +1,18 @@ +-- +DELETE FROM `item_loot_template` WHERE `Entry` IN (50301,54218); +INSERT INTO `item_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES +(50301,46779,0,36.36,0,1,1,50,50,'Landro\'s Pet Box, Path of Cenarius'), +(50301,35223,0,36.36,0,1,1,50,50,'Landro\'s Pet Box, Papa Hummel\'s Old-Fashioned Pet Biscuit'), +(50301,45047,0,27.28,0,1,1,50,50,'Landro\'s Pet Box, Sandbox Tiger'), +(50301,32588,0,0.45,0,1,2,1,1,'Landro\'s Pet Box, Banana Charm'), +(50301,38050,0,0.45,0,1,2,1,1,'Landro\'s Pet Box, Soul-Trader Beacon'), +(50301,34493,0,0.10,0,1,2,1,1,'Landro\'s Pet Box, Dragon Kite'), +(54218,46779,0,36.36,0,1,1,50,50,'Landro\'s Gift Box, Path of Cenarius'), +(54218,35223,0,36.36,0,1,1,50,50,'Landro\'s Gift Box, Papa Hummel\'s Old-Fashioned Pet Biscuit'), +(54218,45047,0,27.28,0,1,1,50,50,'Landro\'s Gift Box, Sandbox Tiger'), +(54218,23720,0,0.50,0,1,2,1,1,'Landro\'s Gift Box, Riding Turtle'), +(54218,49284,0,0.30,0,1,2,1,1,'Landro\'s Gift Box, Reins of the Swift Spectral Tiger'), +(54218,49283,0,0.30,0,1,2,1,1,'Landro\'s Gift Box, Reins of the Spectral Tiger'), +(54218,49286,0,0.30,0,1,2,1,1,'Landro\'s Gift Box, X-51 Nether-Rocket X-TREME'), +(54218,49285,0,0.10,0,1,2,1,1,'Landro\'s Gift Box, X-51 Nether-Rocket'), +(54218,49282,0,0.20,0,1,2,1,1,'Landro\'s Gift Box, Big Battle Bear'); -- cgit v1.2.3