diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2023-04-06 19:18:23 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-04-06 19:18:23 +0200 |
| commit | 878a3d263944083c77a957a07f5c53c7d8d17dd2 (patch) | |
| tree | 8eb3ed7f38a4adfe9def4f6bb9feb15a7d8120d6 /sql | |
| parent | 379dc1c6a990a62a063a76f9bced50a7b7150d22 (diff) | |
DB/Creature: Restored wrong gold on a few creatures
closes #28578 by @Jildor
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2023_04_06_07_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2023_04_06_07_world.sql b/sql/updates/world/3.3.5/2023_04_06_07_world.sql new file mode 100644 index 00000000000..2d243f0f44f --- /dev/null +++ b/sql/updates/world/3.3.5/2023_04_06_07_world.sql @@ -0,0 +1,9 @@ +-- These 2 creatures have a 25 difficulty (naxx), in them they have gold, it doesn't make sense that in one difficulty they have it and in another they don't. +UPDATE `creature_template` SET `mingold`=3883, `maxgold`=5076 WHERE `entry`=16215; +UPDATE `creature_template` SET `mingold`=4138, `maxgold`=5409 WHERE `entry`=16216; + +-- Restored old gold values for this creature: +UPDATE `creature_template` SET `mingold`=4776, `maxgold`=6241 WHERE `entry`=16194; + +-- Karazhan - Spectral Charger: Remove wrong gold values. +UPDATE `creature_template` SET `mingold`=0, `maxgold`=0 WHERE `entry`=15547; |