From c276e144b2835f75d153efd9701e7b8e8f56c755 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Sat, 26 Nov 2016 03:52:59 +0100 Subject: DB/Misc: Armor for LvL 100+ creature_classlevelstats Closes #18315 by funjoker --- sql/updates/world/master/2016_11_26_01_world.sql | 28 ++++++++++++++++++++++++ 1 file changed, 28 insertions(+) create mode 100644 sql/updates/world/master/2016_11_26_01_world.sql (limited to 'sql') 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); +-- -- cgit v1.2.3