From 3526f6a20b58649e62eb05fccaf985fbbbe187dd Mon Sep 17 00:00:00 2001 From: Keader Date: Tue, 12 Nov 2019 14:45:55 +0100 Subject: DB/Loot: The drop rate of Frost Lotus, from herbs in Northrend, has been increased by 50%. From 5% to 7.5% Closes #23880 --- sql/updates/world/3.3.5/2019_11_12_00_world.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/3.3.5/2019_11_12_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2019_11_12_00_world.sql b/sql/updates/world/3.3.5/2019_11_12_00_world.sql new file mode 100644 index 00000000000..cef83d47b36 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_11_12_00_world.sql @@ -0,0 +1,8 @@ +-- Hotfix (2010-02-18): The drop rate of Frost Lotus, from herbs in Northrend, has been increased by 50%. From 5% to 7.5% +UPDATE `gameobject_loot_template` SET `Chance` = 7.5 WHERE `Entry` = 24093 AND `Item` = 36908; +UPDATE `gameobject_loot_template` SET `Chance` = 7.5 WHERE `Entry` = 24224 AND `Item` = 36908; +UPDATE `gameobject_loot_template` SET `Chance` = 7.5 WHERE `Entry` = 24225 AND `Item` = 36908; +UPDATE `gameobject_loot_template` SET `Chance` = 7.5 WHERE `Entry` = 24226 AND `Item` = 36908; +UPDATE `gameobject_loot_template` SET `MaxCount` = 1, `Chance` = 7.5 WHERE `Entry` = 24227 AND `Item` = 36908; +UPDATE `gameobject_loot_template` SET `Chance` = 7.5 WHERE `Entry` = 25089 AND `Item` = 36908; +UPDATE `gameobject_loot_template` SET `Chance` = 7.5 WHERE `Entry` = 25093 AND `Item` = 36908; -- cgit v1.2.3