diff options
| -rw-r--r-- | sql/updates/world/2011_02_06_1_world_creature_loot.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2011_02_06_2_world_item_loot.sql | 4 |
2 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2011_02_06_1_world_creature_loot.sql b/sql/updates/world/2011_02_06_1_world_creature_loot.sql new file mode 100644 index 00000000000..295bb76a261 --- /dev/null +++ b/sql/updates/world/2011_02_06_1_world_creature_loot.sql @@ -0,0 +1,2 @@ +-- Fragment of the Nightmare's Corruption drops 100% as of patch 3.0.2 +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=-100 WHERE `item` IN (21146,21147,21148,21149); diff --git a/sql/updates/world/2011_02_06_2_world_item_loot.sql b/sql/updates/world/2011_02_06_2_world_item_loot.sql new file mode 100644 index 00000000000..e77a40def02 --- /dev/null +++ b/sql/updates/world/2011_02_06_2_world_item_loot.sql @@ -0,0 +1,4 @@ +-- Insert loot for Gently Shaken Gift +DELETE FROM `item_loot_template` WHERE `entry`=21271; +INSERT INTO `item_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(21271,21241,100,1,0,5,5); |