diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2016-06-15 10:38:27 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-01-29 21:00:41 +0100 |
| commit | b32d13576aa4a7c963230a9c1b99e980cd7b5234 (patch) | |
| tree | 9bf312bc45f7c8768e0fb1e3269a8b2ae417d30a | |
| parent | 875c51b116704ba5e831c72a5f5df46d6733b468 (diff) | |
DB/Item: missing TCG loot from Landro's Pet Box & Gift Box
Closes #15948 by tkrokli
(cherry picked from commit 3c6059bf446087b9c8b1704d634efdb9f02eaefb)
| -rw-r--r-- | sql/updates/world/master/2017_01_29_08_world_2016_06_15_02_world.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_01_29_08_world_2016_06_15_02_world.sql b/sql/updates/world/master/2017_01_29_08_world_2016_06_15_02_world.sql new file mode 100644 index 00000000000..b94af5ec293 --- /dev/null +++ b/sql/updates/world/master/2017_01_29_08_world_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'); |