From 3bfdb548ddcb51d20eb041a878b6b773ba5f7356 Mon Sep 17 00:00:00 2001 From: Killyana Date: Fri, 24 Jul 2015 19:19:53 +0200 Subject: DB/Item: Sack of Ulduar Spoils / Large Sack of Ulduar Spoils * closes #15059 --- sql/updates/world/2015_07_24_05_world.sql | 27 +++++++++++++++++++++++++++ 1 file changed, 27 insertions(+) create mode 100644 sql/updates/world/2015_07_24_05_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2015_07_24_05_world.sql b/sql/updates/world/2015_07_24_05_world.sql new file mode 100644 index 00000000000..21577ac8cf1 --- /dev/null +++ b/sql/updates/world/2015_07_24_05_world.sql @@ -0,0 +1,27 @@ +DELETE FROM `item_loot_template` WHERE `Entry` IN (45875, 45878); +INSERT INTO `item_loot_template` (`entry`,`item`,`Chance`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`) VALUES +(45875,45087,100,1,0,1,1), +(45875,47241,100,1,0,5,5), +(45878,45087,100,1,0,2,2), +(45878,45088,0,1,1,1,1), +(45878,45089,0,1,1,1,1), +(45878,45090,0,1,1,1,1), +(45878,45091,0,1,1,1,1), +(45878,45092,0,1,1,1,1), +(45878,45093,0,1,1,1,1), +(45878,45094,0,1,1,1,1), +(45878,45095,0,1,1,1,1), +(45878,45096,0,1,1,1,1), +(45878,45097,0,1,1,1,1), +(45878,45098,0,1,1,1,1), +(45878,45099,0,1,1,1,1), +(45878,45100,0,1,1,1,1), +(45878,45101,0,1,1,1,1), +(45878,45102,0,1,1,1,1), +(45878,45103,0,1,1,1,1), +(45878,45104,0,1,1,1,1), +(45878,45105,0,1,1,1,1), +(45878,47241,100,1,0,10,10); + +UPDATE `item_template` SET `minMoneyLoot`=1000000, `maxMoneyLoot`=1000000 WHERE `entry`=45875; +UPDATE `item_template` SET `minMoneyLoot`=1500000, `maxMoneyLoot`=1500000 WHERE `entry`=45878; -- cgit v1.2.3