diff options
| author | zxbiohazardzx <zxbiohazardzx@gmail.com> | 2011-11-14 01:10:59 +0100 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2011-11-14 01:10:59 +0100 |
| commit | 210be7d0d133ee936fd3b12b2dfa58a120b52310 (patch) | |
| tree | c821ccf2017a48db339591dddfe3c18f6a1ffe6a | |
| parent | 3cc54cb6e8df57954a02bfe5514f7a5f4b1996a5 (diff) | |
DB/Loot: Heavy Scorpid Vest should only drop from Shadowsworn Thug at roughly 0.5%
fixes #2861
| -rw-r--r-- | sql/updates/world/2011_11_13_12_world_creature_loot_template.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/2011_11_13_12_world_creature_loot_template.sql b/sql/updates/world/2011_11_13_12_world_creature_loot_template.sql new file mode 100644 index 00000000000..7982910cee6 --- /dev/null +++ b/sql/updates/world/2011_11_13_12_world_creature_loot_template.sql @@ -0,0 +1,4 @@ +-- Add Heavy Scorpid Vest to Shadowsworn Thug and remove from Portal Seeker +DELETE FROM `creature_loot_template` WHERE `item`=15727; +INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(6005,15727,0.5,1,0,1,1); -- Shadowsworn Thug |