diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2025-05-17 14:01:55 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-05-17 14:01:55 +0200 |
| commit | 82158f375331926267fb635e59e22dccd2bf35e1 (patch) | |
| tree | f78ef0685f26375aeb0ca6ac8be9d78eb24b12b8 | |
| parent | e965d53f2dbcd8bbfae41bd3dd195bfb550521e0 (diff) | |
DB/Loot: Add chance to TBC skinning loot
closes #30922
by offl
| -rw-r--r-- | sql/updates/world/3.3.5/2025_05_17_10_world.sql | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2025_05_17_10_world.sql b/sql/updates/world/3.3.5/2025_05_17_10_world.sql new file mode 100644 index 00000000000..08037a6e753 --- /dev/null +++ b/sql/updates/world/3.3.5/2025_05_17_10_world.sql @@ -0,0 +1,30 @@ +-- This is not a math session to calculate it every time +UPDATE `skinning_loot_template` SET `Chance` = 90 WHERE `Entry` = 70060 AND `Item` = 25649; +UPDATE `skinning_loot_template` SET `Chance` = 70 WHERE `Entry` = 70061 AND `Item` = 25649; +UPDATE `skinning_loot_template` SET `Chance` = 80 WHERE `Entry` = 70062 AND `Item` = 25649; +UPDATE `skinning_loot_template` SET `Chance` = 50 WHERE `Entry` = 70063 AND `Item` = 21887; +UPDATE `skinning_loot_template` SET `Chance` = 50 WHERE `Entry` = 70063 AND `Item` = 25649; +UPDATE `skinning_loot_template` SET `Chance` = 80 WHERE `Entry` = 70064 AND `Item` = 21887; +UPDATE `skinning_loot_template` SET `Chance` = 50 WHERE `Entry` = 70065 AND `Item` = 21887; +UPDATE `skinning_loot_template` SET `Chance` = 50 WHERE `Entry` = 70065 AND `Item` = 25649; +UPDATE `skinning_loot_template` SET `Chance` = 70 WHERE `Entry` = 70066 AND `Item` = 21887; +UPDATE `skinning_loot_template` SET `Chance` = 100 WHERE `Entry` = 70067 AND `Item` = 21887; +UPDATE `skinning_loot_template` SET `Chance` = 70 WHERE `Entry` = 70160 AND `Item` = 25649; +UPDATE `skinning_loot_template` SET `Chance` = 45 WHERE `Entry` = 70161 AND `Item` = 25649; +UPDATE `skinning_loot_template` SET `Chance` = 45 WHERE `Entry` = 70162 AND `Item` = 25649; +UPDATE `skinning_loot_template` SET `Chance` = 55 WHERE `Entry` = 70163 AND `Item` = 25649; +UPDATE `skinning_loot_template` SET `Chance` = 30 WHERE `Entry` = 70164 AND `Item` = 21887; +UPDATE `skinning_loot_template` SET `Chance` = 30 WHERE `Entry` = 70164 AND `Item` = 25649; +UPDATE `skinning_loot_template` SET `Chance` = 28.5 WHERE `Entry` = 70165 AND `Item` = 21887; +UPDATE `skinning_loot_template` SET `Chance` = 28.5 WHERE `Entry` = 70165 AND `Item` = 25649; +UPDATE `skinning_loot_template` SET `Chance` = 65 WHERE `Entry` = 70166 AND `Item` = 25649; +UPDATE `skinning_loot_template` SET `Chance` = 40 WHERE `Entry` = 70167 AND `Item` = 25649; +UPDATE `skinning_loot_template` SET `Chance` = 45 WHERE `Entry` = 70168 AND `Item` = 21887; +UPDATE `skinning_loot_template` SET `Chance` = 45 WHERE `Entry` = 70168 AND `Item` = 25649; +UPDATE `skinning_loot_template` SET `Chance` = 40 WHERE `Entry` = 70169 AND `Item` = 21887; +UPDATE `skinning_loot_template` SET `Chance` = 40 WHERE `Entry` = 70169 AND `Item` = 25649; +UPDATE `skinning_loot_template` SET `Chance` = 75 WHERE `Entry` = 70170 AND `Item` = 21887; +UPDATE `skinning_loot_template` SET `Chance` = 35 WHERE `Entry` = 70171 AND `Item` = 21887; +UPDATE `skinning_loot_template` SET `Chance` = 35 WHERE `Entry` = 70171 AND `Item` = 25649; +UPDATE `skinning_loot_template` SET `Chance` = 30 WHERE `Entry` = 70172 AND `Item` = 21887; +UPDATE `skinning_loot_template` SET `Chance` = 30 WHERE `Entry` = 70172 AND `Item` = 25649; |