diff options
| author | zxbiohazardzx <zxbiohazardzx@gmail.com> | 2013-09-30 11:27:13 +0200 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2013-09-30 11:27:13 +0200 |
| commit | 6e9584696c2f531ebc547e8c04f8f00eeb97807a (patch) | |
| tree | b500becb2b0f888efbe1af110718a9158cd7d14c | |
| parent | 7a234c83f49c4f10deb8dbdcfb92c3dee4342a8a (diff) | |
DB/Loot: correct petdrops from the fishingbags and cleanup the misused reference
Closes #10975
| -rw-r--r-- | sql/updates/world/2013_09_30_01_world_item_loot_template.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/2013_09_30_01_world_item_loot_template.sql b/sql/updates/world/2013_09_30_01_world_item_loot_template.sql new file mode 100644 index 00000000000..9c60a618139 --- /dev/null +++ b/sql/updates/world/2013_09_30_01_world_item_loot_template.sql @@ -0,0 +1,8 @@ +DELETE FROM `reference_loot_template` WHERE `entry`=11112; +UPDATE `reference_loot_template` SET `entry`=11114 WHERE `item`= 34831 AND `entry`=11115; +DELETE FROM `item_loot_template` WHERE `entry`=35348; +INSERT INTO `item_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(35348,1,100,1,0,-11113,1), -- Garanteed Drops +(35348,2, 60,1,0,-11116,1), -- Rare Pets +(35348,4, 60,1,0,-11115,1), -- Junk items +(35348,3, 5,1,0,-11114,1); -- Lesser Treasures |