diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2016-11-26 03:52:59 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-11-26 03:52:59 +0100 |
| commit | c276e144b2835f75d153efd9701e7b8e8f56c755 (patch) | |
| tree | 58436f162ca03d74aeeb6116d8b841ed75ba6675 | |
| parent | 5014da86d4636c2600817af265404af0e61261d5 (diff) | |
DB/Misc: Armor for LvL 100+ creature_classlevelstats
Closes #18315 by funjoker
| -rw-r--r-- | sql/updates/world/master/2016_11_26_01_world.sql | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/sql/updates/world/master/2016_11_26_01_world.sql b/sql/updates/world/master/2016_11_26_01_world.sql new file mode 100644 index 00000000000..a4e7ae4d21a --- /dev/null +++ b/sql/updates/world/master/2016_11_26_01_world.sql @@ -0,0 +1,28 @@ +-- +UPDATE `creature_classlevelstats` SET `basearmor` = 1850 WHERE `level` = 101 AND `class` = 8; +UPDATE `creature_classlevelstats` SET `basearmor` = 1911 WHERE `level` = 102 AND `class` = 8; +UPDATE `creature_classlevelstats` SET `basearmor` = 1974 WHERE `level` = 103 AND `class` = 8; +UPDATE `creature_classlevelstats` SET `basearmor` = 2041 WHERE `level` = 104 AND `class` = 8; +UPDATE `creature_classlevelstats` SET `basearmor` = 2110 WHERE `level` = 105 AND `class` = 8; +UPDATE `creature_classlevelstats` SET `basearmor` = 2184 WHERE `level` = 106 AND `class` = 8; +UPDATE `creature_classlevelstats` SET `basearmor` = 2261 WHERE `level` = 107 AND `class` = 8; +UPDATE `creature_classlevelstats` SET `basearmor` = 2342 WHERE `level` = 108 AND `class` = 8; +UPDATE `creature_classlevelstats` SET `basearmor` = 2428 WHERE `level` = 109 AND `class` = 8; +UPDATE `creature_classlevelstats` SET `basearmor` = 2516 WHERE `level` = 110 AND `class` = 8; +UPDATE `creature_classlevelstats` SET `basearmor` = 2604 WHERE `level` = 111 AND `class` = 8; +UPDATE `creature_classlevelstats` SET `basearmor` = 2692 WHERE `level` = 112 AND `class` = 8; +UPDATE `creature_classlevelstats` SET `basearmor` = 2779 WHERE `level` = 113 AND `class` = 8; +UPDATE `creature_classlevelstats` SET `basearmor` = 2313 WHERE `level` = 101 AND `class` IN (1, 2, 4); +UPDATE `creature_classlevelstats` SET `basearmor` = 2388 WHERE `level` = 102 AND `class` IN (1, 2, 4); +UPDATE `creature_classlevelstats` SET `basearmor` = 2467 WHERE `level` = 103 AND `class` IN (1, 2, 4); +UPDATE `creature_classlevelstats` SET `basearmor` = 2550 WHERE `level` = 104 AND `class` IN (1, 2, 4); +UPDATE `creature_classlevelstats` SET `basearmor` = 2638 WHERE `level` = 105 AND `class` IN (1, 2, 4); +UPDATE `creature_classlevelstats` SET `basearmor` = 2729 WHERE `level` = 106 AND `class` IN (1, 2, 4); +UPDATE `creature_classlevelstats` SET `basearmor` = 2826 WHERE `level` = 107 AND `class` IN (1, 2, 4); +UPDATE `creature_classlevelstats` SET `basearmor` = 2927 WHERE `level` = 108 AND `class` IN (1, 2, 4); +UPDATE `creature_classlevelstats` SET `basearmor` = 3035 WHERE `level` = 109 AND `class` IN (1, 2, 4); +UPDATE `creature_classlevelstats` SET `basearmor` = 3144 WHERE `level` = 110 AND `class` IN (1, 2, 4); +UPDATE `creature_classlevelstats` SET `basearmor` = 3254 WHERE `level` = 111 AND `class` IN (1, 2, 4); +UPDATE `creature_classlevelstats` SET `basearmor` = 3364 WHERE `level` = 112 AND `class` IN (1, 2, 4); +UPDATE `creature_classlevelstats` SET `basearmor` = 3474 WHERE `level` = 113 AND `class` IN (1, 2, 4); +-- |