aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2015-07-26 00:32:54 +0100
committerDDuarte <dnpd.dd@gmail.com>2015-07-26 00:32:54 +0100
commit127c3187d29a54a870d080b3b6c8b7e803046edb (patch)
treeea121dd6252b804fcd617fc4c20879de219b0d87
parent6ce05144b25f15062e4c74490340cb2a15f5e3bb (diff)
DB/Item: Sack of Ulduar Spoils / Large Sack of Ulduar Spoils
* closes #15059 (cherry picked from commit 3bfdb548ddcb51d20eb041a878b6b773ba5f7356)
-rw-r--r--sql/updates/world/2015_07_26_02_world_2015_07_24_05.sql29
1 files changed, 29 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_26_02_world_2015_07_24_05.sql b/sql/updates/world/2015_07_26_02_world_2015_07_24_05.sql
new file mode 100644
index 00000000000..557e64f040b
--- /dev/null
+++ b/sql/updates/world/2015_07_26_02_world_2015_07_24_05.sql
@@ -0,0 +1,29 @@
+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);
+
+DELETE FROM `item_template_addon` WHERE `Id` IN (45875, 45878);
+INSERT INTO `item_template_addon` (`Id`, `MinMoneyLoot`, `MaxMoneyLoot`) VALUES
+(45875, 1000000, 1000000),
+(45878, 1500000, 1500000);