diff options
| author | QAston <qaston@gmail.com> | 2011-02-06 13:17:59 +0100 |
|---|---|---|
| committer | QAston <qaston@gmail.com> | 2011-02-06 13:17:59 +0100 |
| commit | 6e08e51976cac1673de028eb6f780e13d78538b3 (patch) | |
| tree | 988c08aad102ee76635acb38184ec85a31395f9f | |
| parent | b5e78bf208d2ab95f875cd7de57233217467dfe9 (diff) | |
| parent | 1844e8b1d8f9f04ca95b887dd9c9911debb82fb1 (diff) | |
Merge branch 'master' of https://github.com/TrinityCore/TrinityCore
| -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); |