diff options
| author | Keader <Keader@users.noreply.github.com> | 2019-11-12 14:45:55 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2019-11-12 14:45:55 +0100 |
| commit | 3526f6a20b58649e62eb05fccaf985fbbbe187dd (patch) | |
| tree | eb659e1d96072be495284e47015390883932c26b /sql | |
| parent | 73bc3d8ea49a4793b14976e86010a36f19c1d18b (diff) | |
DB/Loot: The drop rate of Frost Lotus, from herbs in Northrend, has been increased by 50%. From 5% to 7.5%
Closes #23880
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2019_11_12_00_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
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; |