diff options
author | Killyana <morphone1@gmail.com> | 2015-07-24 19:19:53 +0200 |
---|---|---|
committer | Rushor <PBienati@web.de> | 2015-07-24 19:20:05 +0200 |
commit | 3bfdb548ddcb51d20eb041a878b6b773ba5f7356 (patch) | |
tree | a6e77fcb9052a3863a4e8f68e55b9ef3e369c9b0 | |
parent | 3c66a88d04405eb06edf1192785b4abd25e111fd (diff) |
DB/Item: Sack of Ulduar Spoils / Large Sack of Ulduar Spoils
* closes #15059
-rw-r--r-- | sql/updates/world/2015_07_24_05_world.sql | 27 |
1 files changed, 27 insertions, 0 deletions
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; |