DB/Creature Stats: Armor update for Warrior class from Bestiary

1 files changed, 74 insertions, 0 deletions

diff --git a/sql/updates/world/2014_08_26_06_world_creature_stats.sql b/sql/updates/world/2014_08_26_06_world_creature_stats.sql
new file mode 100644
index 00000000000..9f7d256fd63
--- /dev/null
+++ b/sql/updates/world/2014_08_26_06_world_creature_stats.sql
@@ -0,0 +1,74 @@
+-- Armor update for Warrior class from Bestiary
+UPDATE `creature_classlevelstats` SET `basearmor`=15 WHERE `level`=1 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=16 WHERE `level`=2 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=41 WHERE `level`=3 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=76 WHERE `level`=4 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=120 WHERE `level`=5 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=174 WHERE `level`=6 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=239 WHERE `level`=7 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=316 WHERE `level`=8 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=406 WHERE `level`=9 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=512 WHERE `level`=10 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=538 WHERE `level`=11 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=573 WHERE `level`=12 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=608 WHERE `level`=13 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=642 WHERE `level`=14 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=677 WHERE `level`=15 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=713 WHERE `level`=16 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=748 WHERE `level`=17 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=782 WHERE `level`=18 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=817 WHERE `level`=19 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=852 WHERE `level`=20 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=888 WHERE `level`=21 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=922 WHERE `level`=22 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=957 WHERE `level`=23 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=992 WHERE `level`=24 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=1026 WHERE `level`=25 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=1061 WHERE `level`=26 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=1097 WHERE `level`=27 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=1130 WHERE `level`=28 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=1165 WHERE `level`=29 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=1200 WHERE `level`=30 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=1234 WHERE `level`=31 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=1270 WHERE `level`=32 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=1304 WHERE `level`=33 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=1340 WHERE `level`=34 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=1373 WHERE `level`=35 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=1480 WHERE `level`=36 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=1593 WHERE `level`=37 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=1709 WHERE `level`=38 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=1834 WHERE `level`=39 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=1964 WHERE `level`=40 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=2101 WHERE `level`=41 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=2246 WHERE `level`=42 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=2397 WHERE `level`=43 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=2557 WHERE `level`=44 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=2725 WHERE `level`=45 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=2780 WHERE `level`=46 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=2835 WHERE `level`=47 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=2888 WHERE `level`=48 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=2944 WHERE `level`=49 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=2999 WHERE `level`=50 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=3052 WHERE `level`=51 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=3108 WHERE `level`=52 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=3163 WHERE `level`=53 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=3216 WHERE `level`=54 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=3271 WHERE `level`=55 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=3327 WHERE `level`=56 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=3380 WHERE `level`=57 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=3435 WHERE `level`=58 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=3489 WHERE `level`=59 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=3791 WHERE `level`=60 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=4091 WHERE `level`=61 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=4391 WHERE `level`=62 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=4691 WHERE `level`=63 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=4991 WHERE `level`=64 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=5291 WHERE `level`=65 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=5591 WHERE `level`=66 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=5892 WHERE `level`=67 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=6192 WHERE `level`=68 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=6492 WHERE `level`=69 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=6792 WHERE `level`=70 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=7089 WHERE `level`=71 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=7387 WHERE `level`=72 AND `class`=1;
+UPDATE `creature_classlevelstats` SET `basearmor`=7684 WHERE `level`=73 AND `class`=1;