diff options
| -rw-r--r-- | sql/updates/world/2014_08_26_07_world_creature_stats.sql | 75 |
1 files changed, 75 insertions, 0 deletions
diff --git a/sql/updates/world/2014_08_26_07_world_creature_stats.sql b/sql/updates/world/2014_08_26_07_world_creature_stats.sql new file mode 100644 index 00000000000..123f1218780 --- /dev/null +++ b/sql/updates/world/2014_08_26_07_world_creature_stats.sql @@ -0,0 +1,75 @@ +-- Armor update for Paladin class from Bestiary +-- 1 & 2 are estimated has I have no info for those levels of Paladin class. Also they are only used in db for totems +UPDATE `creature_classlevelstats` SET `basearmor`=13, `comment`= 'armor estimated' WHERE `level`=1 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=14, `comment`= 'armor estimated' WHERE `level`=2 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=37 WHERE `level`=3 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=67 WHERE `level`=4 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=105 WHERE `level`=5 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=150 WHERE `level`=6 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=205 WHERE `level`=7 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=268 WHERE `level`=8 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=342 WHERE `level`=9 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=426 WHERE `level`=10 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=450 WHERE `level`=11 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=479 WHERE `level`=12 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=507 WHERE `level`=13 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=537 WHERE `level`=14 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=566 WHERE `level`=15 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=596 WHERE `level`=16 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=625 WHERE `level`=17 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=652 WHERE `level`=18 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=683 WHERE `level`=19 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=712 WHERE `level`=20 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=740 WHERE `level`=21 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=770 WHERE `level`=22 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=800 WHERE `level`=23 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=829 WHERE `level`=24 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=858 WHERE `level`=25 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=887 WHERE `level`=26 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=916 WHERE `level`=27 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=946 WHERE `level`=28 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=975 WHERE `level`=29 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1004 WHERE `level`=30 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1033 WHERE `level`=31 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1063 WHERE `level`=32 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1091 WHERE `level`=33 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1121 WHERE `level`=34 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1149 WHERE `level`=35 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1234 WHERE `level`=36 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1325 WHERE `level`=37 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1418 WHERE `level`=38 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1517 WHERE `level`=39 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1619 WHERE `level`=40 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1727 WHERE `level`=41 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1841 WHERE `level`=42 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=1958 WHERE `level`=43 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2082 WHERE `level`=44 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2211 WHERE `level`=45 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2255 WHERE `level`=46 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2300 WHERE `level`=47 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2344 WHERE `level`=48 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2389 WHERE `level`=49 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2432 WHERE `level`=50 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2477 WHERE `level`=51 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2522 WHERE `level`=52 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2566 WHERE `level`=53 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2610 WHERE `level`=54 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2654 WHERE `level`=55 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2699 WHERE `level`=56 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2744 WHERE `level`=57 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2788 WHERE `level`=58 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=2832 WHERE `level`=59 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=3075 WHERE `level`=60 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=3316 WHERE `level`=61 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=3555 WHERE `level`=62 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=3795 WHERE `level`=63 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=4036 WHERE `level`=64 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=4275 WHERE `level`=65 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=4515 WHERE `level`=66 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=4755 WHERE `level`=67 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=4995 WHERE `level`=68 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=5235 WHERE `level`=69 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=5474 WHERE `level`=70 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=5714 WHERE `level`=71 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=5954 WHERE `level`=72 AND `class`=2; +UPDATE `creature_classlevelstats` SET `basearmor`=6193 WHERE `level`=73 AND `class`=2; |