diff options
| -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; |