diff options
| author | Keader <Keader@users.noreply.github.com> | 2019-11-12 14:45:55 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-12-19 00:15:30 +0100 |
| commit | 397cd0f63c526df1fde6a7db3d52489273c90473 (patch) | |
| tree | a278fd4ee480e46f8194a774ece9ba12d6c72fd6 | |
| parent | b93bf95f2e76eca8be12ba07828387ab8529c050 (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
(cherry picked from commit 3526f6a20b58649e62eb05fccaf985fbbbe187dd)
| -rw-r--r-- | sql/updates/world/master/2021_12_18_63_world_2019_11_12_00_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_18_63_world_2019_11_12_00_world.sql b/sql/updates/world/master/2021_12_18_63_world_2019_11_12_00_world.sql new file mode 100644 index 00000000000..cef83d47b36 --- /dev/null +++ b/sql/updates/world/master/2021_12_18_63_world_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; |