Core/Player: Fix armor calculation

Base armor value from WDB data includes the ArmorDamageModifier. Items of
same item level, required level, armor type and equiptment slot should
have (nearly) the same armor values.

See following links for further proofs:
http://pastebin.com/fqNJLYj4
http://www.wowhead.com/item=50466#comments:id=889035:reply=444786

The shown item should have a base armor value of 177 as similar items and
a bonus armor value of 560 which equals 737 - like in DB atm.

2 files changed, 647 insertions, 1 deletions

diff --git a/sql/updates/world/2013_01_01_00_item_template.sql b/sql/updates/world/2013_01_01_00_item_template.sql
new file mode 100644
index 00000000000..aac98a7a089
--- /dev/null
+++ b/sql/updates/world/2013_01_01_00_item_template.sql
@@ -0,0 +1,646 @@
+UPDATE `item_template` SET `armor`=2063 WHERE `entry`=1169;
+UPDATE `item_template` SET `armor`=218 WHERE `entry`=1717;
+UPDATE `item_template` SET `armor`=91 WHERE `entry`=3835;
+UPDATE `item_template` SET `armor`=238 WHERE `entry`=3844;
+UPDATE `item_template` SET `armor`=1051 WHERE `entry`=4070;
+UPDATE `item_template` SET `armor`=471 WHERE `entry`=6447;
+UPDATE `item_template` SET `armor`=776 WHERE `entry`=6725;
+UPDATE `item_template` SET `armor`=168 WHERE `entry`=6731;
+UPDATE `item_template` SET `armor`=134 WHERE `entry`=6742;
+UPDATE `item_template` SET `armor`=201 WHERE `entry`=6907;
+UPDATE `item_template` SET `armor`=273 WHERE `entry`=7919;
+UPDATE `item_template` SET `armor`=382 WHERE `entry`=7921;
+UPDATE `item_template` SET `armor`=341 WHERE `entry`=7922;
+UPDATE `item_template` SET `armor`=446 WHERE `entry`=7930;
+UPDATE `item_template` SET `armor`=312 WHERE `entry`=7933;
+UPDATE `item_template` SET `armor`=369 WHERE `entry`=7934;
+UPDATE `item_template` SET `armor`=231 WHERE `entry`=7963;
+UPDATE `item_template` SET `armor`=115 WHERE `entry`=9409;
+UPDATE `item_template` SET `armor`=211 WHERE `entry`=9625;
+UPDATE `item_template` SET `armor`=113 WHERE `entry`=10783;
+UPDATE `item_template` SET `armor`=617 WHERE `entry`=11604;
+UPDATE `item_template` SET `armor`=414 WHERE `entry`=11605;
+UPDATE `item_template` SET `armor`=303 WHERE `entry`=11606;
+UPDATE `item_template` SET `armor`=1803 WHERE `entry`=11631;
+UPDATE `item_template` SET `armor`=0 WHERE `entry`=11669;
+UPDATE `item_template` SET `armor`=324 WHERE `entry`=11703;
+UPDATE `item_template` SET `armor`=522 WHERE `entry`=11927;
+UPDATE `item_template` SET `armor`=0 WHERE `entry`=12544;
+UPDATE `item_template` SET `armor`=40 WHERE `entry`=12551;
+UPDATE `item_template` SET `armor`=463 WHERE `entry`=12557;
+UPDATE `item_template` SET `armor`=427 WHERE `entry`=12610;
+UPDATE `item_template` SET `armor`=392 WHERE `entry`=12611;
+UPDATE `item_template` SET `armor`=471 WHERE `entry`=12612;
+UPDATE `item_template` SET `armor`=588 WHERE `entry`=12613;
+UPDATE `item_template` SET `armor`=515 WHERE `entry`=12614;
+UPDATE `item_template` SET `armor`=509 WHERE `entry`=12633;
+UPDATE `item_template` SET `armor`=461 WHERE `entry`=12641;
+UPDATE `item_template` SET `armor`=661 WHERE `entry`=13079;
+UPDATE `item_template` SET `armor`=95 WHERE `entry`=13252;
+UPDATE `item_template` SET `armor`=107 WHERE `entry`=13258;
+UPDATE `item_template` SET `armor`=369 WHERE `entry`=13502;
+UPDATE `item_template` SET `armor`=478 WHERE `entry`=13955;
+UPDATE `item_template` SET `armor`=93 WHERE `entry`=35496;
+UPDATE `item_template` SET `armor`=148 WHERE `entry`=15053;
+UPDATE `item_template` SET `armor`=124 WHERE `entry`=15054;
+UPDATE `item_template` SET `armor`=117 WHERE `entry`=15055;
+UPDATE `item_template` SET `armor`=657 WHERE `entry`=15413;
+UPDATE `item_template` SET `armor`=36 WHERE `entry`=16341;
+UPDATE `item_template` SET `armor`=45 WHERE `entry`=16342;
+UPDATE `item_template` SET `armor`=85 WHERE `entry`=16437;
+UPDATE `item_template` SET `armor`=78 WHERE `entry`=16440;
+UPDATE `item_template` SET `armor`=105 WHERE `entry`=16441;
+UPDATE `item_template` SET `armor`=109 WHERE `entry`=16442;
+UPDATE `item_template` SET `armor`=129 WHERE `entry`=16443;
+UPDATE `item_template` SET `armor`=97 WHERE `entry`=16444;
+UPDATE `item_template` SET `armor`=167 WHERE `entry`=16446;
+UPDATE `item_template` SET `armor`=152 WHERE `entry`=16448;
+UPDATE `item_template` SET `armor`=188 WHERE `entry`=16449;
+UPDATE `item_template` SET `armor`=212 WHERE `entry`=16450;
+UPDATE `item_template` SET `armor`=204 WHERE `entry`=16451;
+UPDATE `item_template` SET `armor`=251 WHERE `entry`=16452;
+UPDATE `item_template` SET `armor`=251 WHERE `entry`=16453;
+UPDATE `item_template` SET `armor`=152 WHERE `entry`=16454;
+UPDATE `item_template` SET `armor`=204 WHERE `entry`=16455;
+UPDATE `item_template` SET `armor`=212 WHERE `entry`=16456;
+UPDATE `item_template` SET `armor`=188 WHERE `entry`=16457;
+UPDATE `item_template` SET `armor`=167 WHERE `entry`=16459;
+UPDATE `item_template` SET `armor`=355 WHERE `entry`=16462;
+UPDATE `item_template` SET `armor`=323 WHERE `entry`=16463;
+UPDATE `item_template` SET `armor`=436 WHERE `entry`=16465;
+UPDATE `item_template` SET `armor`=537 WHERE `entry`=16466;
+UPDATE `item_template` SET `armor`=452 WHERE `entry`=16467;
+UPDATE `item_template` SET `armor`=403 WHERE `entry`=16468;
+UPDATE `item_template` SET `armor`=954 WHERE `entry`=16477;
+UPDATE `item_template` SET `armor`=775 WHERE `entry`=16478;
+UPDATE `item_template` SET `armor`=802 WHERE `entry`=16479;
+UPDATE `item_template` SET `armor`=630 WHERE `entry`=16483;
+UPDATE `item_template` SET `armor`=573 WHERE `entry`=16484;
+UPDATE `item_template` SET `armor`=105 WHERE `entry`=16533;
+UPDATE `item_template` SET `armor`=109 WHERE `entry`=16534;
+UPDATE `item_template` SET `armor`=129 WHERE `entry`=16535;
+UPDATE `item_template` SET `armor`=97 WHERE `entry`=16536;
+UPDATE `item_template` SET `armor`=85 WHERE `entry`=16539;
+UPDATE `item_template` SET `armor`=78 WHERE `entry`=16540;
+UPDATE `item_template` SET `armor`=954 WHERE `entry`=16541;
+UPDATE `item_template` SET `armor`=775 WHERE `entry`=16542;
+UPDATE `item_template` SET `armor`=802 WHERE `entry`=16543;
+UPDATE `item_template` SET `armor`=630 WHERE `entry`=16545;
+UPDATE `item_template` SET `armor`=573 WHERE `entry`=16548;
+UPDATE `item_template` SET `armor`=251 WHERE `entry`=16549;
+UPDATE `item_template` SET `armor`=204 WHERE `entry`=16550;
+UPDATE `item_template` SET `armor`=188 WHERE `entry`=16551;
+UPDATE `item_template` SET `armor`=212 WHERE `entry`=16552;
+UPDATE `item_template` SET `armor`=167 WHERE `entry`=16554;
+UPDATE `item_template` SET `armor`=152 WHERE `entry`=16555;
+UPDATE `item_template` SET `armor`=152 WHERE `entry`=16560;
+UPDATE `item_template` SET `armor`=204 WHERE `entry`=16561;
+UPDATE `item_template` SET `armor`=188 WHERE `entry`=16562;
+UPDATE `item_template` SET `armor`=251 WHERE `entry`=16563;
+UPDATE `item_template` SET `armor`=212 WHERE `entry`=16564;
+UPDATE `item_template` SET `armor`=537 WHERE `entry`=16565;
+UPDATE `item_template` SET `armor`=436 WHERE `entry`=16566;
+UPDATE `item_template` SET `armor`=452 WHERE `entry`=16567;
+UPDATE `item_template` SET `armor`=403 WHERE `entry`=16568;
+UPDATE `item_template` SET `armor`=355 WHERE `entry`=16569;
+UPDATE `item_template` SET `armor`=323 WHERE `entry`=16571;
+UPDATE `item_template` SET `armor`=323 WHERE `entry`=16574;
+UPDATE `item_template` SET `armor`=683 WHERE `entry`=17013;
+UPDATE `item_template` SET `armor`=336 WHERE `entry`=17014;
+UPDATE `item_template` SET `armor`=64 WHERE `entry`=17107;
+UPDATE `item_template` SET `armor`=105 WHERE `entry`=17578;
+UPDATE `item_template` SET `armor`=109 WHERE `entry`=17579;
+UPDATE `item_template` SET `armor`=97 WHERE `entry`=17580;
+UPDATE `item_template` SET `armor`=129 WHERE `entry`=17581;
+UPDATE `item_template` SET `armor`=85 WHERE `entry`=17583;
+UPDATE `item_template` SET `armor`=85 WHERE `entry`=17586;
+UPDATE `item_template` SET `armor`=97 WHERE `entry`=17590;
+UPDATE `item_template` SET `armor`=105 WHERE `entry`=17591;
+UPDATE `item_template` SET `armor`=129 WHERE `entry`=17592;
+UPDATE `item_template` SET `armor`=109 WHERE `entry`=17593;
+UPDATE `item_template` SET `armor`=105 WHERE `entry`=17602;
+UPDATE `item_template` SET `armor`=109 WHERE `entry`=17603;
+UPDATE `item_template` SET `armor`=97 WHERE `entry`=17604;
+UPDATE `item_template` SET `armor`=129 WHERE `entry`=17605;
+UPDATE `item_template` SET `armor`=85 WHERE `entry`=17607;
+UPDATE `item_template` SET `armor`=78 WHERE `entry`=17608;
+UPDATE `item_template` SET `armor`=85 WHERE `entry`=17618;
+UPDATE `item_template` SET `armor`=78 WHERE `entry`=17620;
+UPDATE `item_template` SET `armor`=97 WHERE `entry`=17622;
+UPDATE `item_template` SET `armor`=105 WHERE `entry`=17623;
+UPDATE `item_template` SET `armor`=129 WHERE `entry`=17624;
+UPDATE `item_template` SET `armor`=109 WHERE `entry`=17625;
+UPDATE `item_template` SET `armor`=453 WHERE `entry`=17734;
+UPDATE `item_template` SET `armor`=2836 WHERE `entry`=18168;
+UPDATE `item_template` SET `armor`=253 WHERE `entry`=18351;
+UPDATE `item_template` SET `armor`=398 WHERE `entry`=18383;
+UPDATE `item_template` SET `armor`=44 WHERE `entry`=18413;
+UPDATE `item_template` SET `armor`=26 WHERE `entry`=18427;
+UPDATE `item_template` SET `armor`=26 WHERE `entry`=18440;
+UPDATE `item_template` SET `armor`=36 WHERE `entry`=18441;
+UPDATE `item_template` SET `armor`=45 WHERE `entry`=18461;
+UPDATE `item_template` SET `armor`=647 WHERE `entry`=18503;
+UPDATE `item_template` SET `armor`=452 WHERE `entry`=18521;
+UPDATE `item_template` SET `armor`=2026 WHERE `entry`=18535;
+UPDATE `item_template` SET `armor`=44 WHERE `entry`=18689;
+UPDATE `item_template` SET `armor`=566 WHERE `entry`=18690;
+UPDATE `item_template` SET `armor`=231 WHERE `entry`=18712;
+UPDATE `item_template` SET `armor`=534 WHERE `entry`=18718;
+UPDATE `item_template` SET `armor`=621 WHERE `entry`=18806;
+UPDATE `item_template` SET `armor`=387 WHERE `entry`=18829;
+UPDATE `item_template` SET `armor`=694 WHERE `entry`=18861;
+UPDATE `item_template` SET `armor`=0 WHERE `entry`=18879;
+UPDATE `item_template` SET `armor`=695 WHERE `entry`=19148;
+UPDATE `item_template` SET `armor`=128 WHERE `entry`=19149;
+UPDATE `item_template` SET `armor`=190 WHERE `entry`=19381;
+UPDATE `item_template` SET `armor`=67 WHERE `entry`=19386;
+UPDATE `item_template` SET `armor`=254 WHERE `entry`=19405;
+UPDATE `item_template` SET `armor`=177 WHERE `entry`=19509;
+UPDATE `item_template` SET `armor`=676 WHERE `entry`=19693;
+UPDATE `item_template` SET `armor`=592 WHERE `entry`=19694;
+UPDATE `item_template` SET `armor`=842 WHERE `entry`=19822;
+UPDATE `item_template` SET `armor`=225 WHERE `entry`=19838;
+UPDATE `item_template` SET `armor`=120 WHERE `entry`=19839;
+UPDATE `item_template` SET `armor`=93 WHERE `entry`=19840;
+UPDATE `item_template` SET `armor`=170 WHERE `entry`=19877;
+UPDATE `item_template` SET `armor`=50 WHERE `entry`=19888;
+UPDATE `item_template` SET `armor`=134 WHERE `entry`=19892;
+UPDATE `item_template` SET `armor`=141 WHERE `entry`=19928;
+UPDATE `item_template` SET `armor`=621 WHERE `entry`=20039;
+UPDATE `item_template` SET `armor`=99 WHERE `entry`=20045;
+UPDATE `item_template` SET `armor`=99 WHERE `entry`=20046;
+UPDATE `item_template` SET `armor`=50 WHERE `entry`=20047;
+UPDATE `item_template` SET `armor`=121 WHERE `entry`=20052;
+UPDATE `item_template` SET `armor`=121 WHERE `entry`=20053;
+UPDATE `item_template` SET `armor`=61 WHERE `entry`=20054;
+UPDATE `item_template` SET `armor`=169 WHERE `entry`=20059;
+UPDATE `item_template` SET `armor`=169 WHERE `entry`=20060;
+UPDATE `item_template` SET `armor`=86 WHERE `entry`=20061;
+UPDATE `item_template` SET `armor`=105 WHERE `entry`=20069;
+UPDATE `item_template` SET `armor`=45 WHERE `entry`=20070;
+UPDATE `item_template` SET `armor`=52 WHERE `entry`=20094;
+UPDATE `item_template` SET `armor`=43 WHERE `entry`=20095;
+UPDATE `item_template` SET `armor`=34 WHERE `entry`=20096;
+UPDATE `item_template` SET `armor`=43 WHERE `entry`=20097;
+UPDATE `item_template` SET `armor`=35 WHERE `entry`=20098;
+UPDATE `item_template` SET `armor`=28 WHERE `entry`=20099;
+UPDATE `item_template` SET `armor`=105 WHERE `entry`=20100;
+UPDATE `item_template` SET `armor`=89 WHERE `entry`=20101;
+UPDATE `item_template` SET `armor`=74 WHERE `entry`=20102;
+UPDATE `item_template` SET `armor`=86 WHERE `entry`=20103;
+UPDATE `item_template` SET `armor`=73 WHERE `entry`=20104;
+UPDATE `item_template` SET `armor`=61 WHERE `entry`=20105;
+UPDATE `item_template` SET `armor`=105 WHERE `entry`=20112;
+UPDATE `item_template` SET `armor`=89 WHERE `entry`=20113;
+UPDATE `item_template` SET `armor`=74 WHERE `entry`=20114;
+UPDATE `item_template` SET `armor`=86 WHERE `entry`=20115;
+UPDATE `item_template` SET `armor`=73 WHERE `entry`=20116;
+UPDATE `item_template` SET `armor`=61 WHERE `entry`=20117;
+UPDATE `item_template` SET `armor`=61 WHERE `entry`=20159;
+UPDATE `item_template` SET `armor`=52 WHERE `entry`=20160;
+UPDATE `item_template` SET `armor`=43 WHERE `entry`=20161;
+UPDATE `item_template` SET `armor`=34 WHERE `entry`=20162;
+UPDATE `item_template` SET `armor`=50 WHERE `entry`=20163;
+UPDATE `item_template` SET `armor`=28 WHERE `entry`=20164;
+UPDATE `item_template` SET `armor`=43 WHERE `entry`=20165;
+UPDATE `item_template` SET `armor`=35 WHERE `entry`=20166;
+UPDATE `item_template` SET `armor`=121 WHERE `entry`=20167;
+UPDATE `item_template` SET `armor`=89 WHERE `entry`=20168;
+UPDATE `item_template` SET `armor`=74 WHERE `entry`=20169;
+UPDATE `item_template` SET `armor`=105 WHERE `entry`=20170;
+UPDATE `item_template` SET `armor`=99 WHERE `entry`=20171;
+UPDATE `item_template` SET `armor`=61 WHERE `entry`=20172;
+UPDATE `item_template` SET `armor`=73 WHERE `entry`=20173;
+UPDATE `item_template` SET `armor`=86 WHERE `entry`=20174;
+UPDATE `item_template` SET `armor`=169 WHERE `entry`=20175;
+UPDATE `item_template` SET `armor`=86 WHERE `entry`=20176;
+UPDATE `item_template` SET `armor`=121 WHERE `entry`=20186;
+UPDATE `item_template` SET `armor`=89 WHERE `entry`=20187;
+UPDATE `item_template` SET `armor`=74 WHERE `entry`=20188;
+UPDATE `item_template` SET `armor`=105 WHERE `entry`=20189;
+UPDATE `item_template` SET `armor`=99 WHERE `entry`=20190;
+UPDATE `item_template` SET `armor`=61 WHERE `entry`=20191;
+UPDATE `item_template` SET `armor`=73 WHERE `entry`=20192;
+UPDATE `item_template` SET `armor`=86 WHERE `entry`=20193;
+UPDATE `item_template` SET `armor`=169 WHERE `entry`=20194;
+UPDATE `item_template` SET `armor`=45 WHERE `entry`=20214;
+UPDATE `item_template` SET `armor`=105 WHERE `entry`=20220;
+UPDATE `item_template` SET `armor`=113 WHERE `entry`=20259;
+UPDATE `item_template` SET `armor`=160 WHERE `entry`=20476;
+UPDATE `item_template` SET `armor`=228 WHERE `entry`=20477;
+UPDATE `item_template` SET `armor`=365 WHERE `entry`=20478;
+UPDATE `item_template` SET `armor`=212 WHERE `entry`=20627;
+UPDATE `item_template` SET `armor`=39 WHERE `entry`=20693;
+UPDATE `item_template` SET `armor`=452 WHERE `entry`=20710;
+UPDATE `item_template` SET `armor`=0 WHERE `entry`=20907;
+UPDATE `item_template` SET `armor`=114 WHERE `entry`=21348;
+UPDATE `item_template` SET `armor`=93 WHERE `entry`=21349;
+UPDATE `item_template` SET `armor`=102 WHERE `entry`=21350;
+UPDATE `item_template` SET `armor`=151 WHERE `entry`=21351;
+UPDATE `item_template` SET `armor`=123 WHERE `entry`=21352;
+UPDATE `item_template` SET `armor`=63 WHERE `entry`=21456;
+UPDATE `item_template` SET `armor`=237 WHERE `entry`=21467;
+UPDATE `item_template` SET `armor`=122 WHERE `entry`=21501;
+UPDATE `item_template` SET `armor`=414 WHERE `entry`=21503;
+UPDATE `item_template` SET `armor`=0 WHERE `entry`=21601;
+UPDATE `item_template` SET `armor`=169 WHERE `entry`=21605;
+UPDATE `item_template` SET `armor`=178 WHERE `entry`=21645;
+UPDATE `item_template` SET `armor`=144 WHERE `entry`=21675;
+UPDATE `item_template` SET `armor`=164 WHERE `entry`=21682;
+UPDATE `item_template` SET `armor`=206 WHERE `entry`=21693;
+UPDATE `item_template` SET `armor`=647 WHERE `entry`=21706;
+UPDATE `item_template` SET `armor`=78 WHERE `entry`=21888;
+UPDATE `item_template` SET `armor`=89 WHERE `entry`=22301;
+UPDATE `item_template` SET `armor`=73 WHERE `entry`=22302;
+UPDATE `item_template` SET `armor`=77 WHERE `entry`=22303;
+UPDATE `item_template` SET `armor`=54 WHERE `entry`=22304;
+UPDATE `item_template` SET `armor`=65 WHERE `entry`=22305;
+UPDATE `item_template` SET `armor`=49 WHERE `entry`=22306;
+UPDATE `item_template` SET `armor`=60 WHERE `entry`=22311;
+UPDATE `item_template` SET `armor`=38 WHERE `entry`=22313;
+UPDATE `item_template` SET `armor`=231 WHERE `entry`=22410;
+UPDATE `item_template` SET `armor`=197 WHERE `entry`=22740;
+UPDATE `item_template` SET `armor`=197 WHERE `entry`=22741;
+UPDATE `item_template` SET `armor`=100 WHERE `entry`=22747;
+UPDATE `item_template` SET `armor`=197 WHERE `entry`=22749;
+UPDATE `item_template` SET `armor`=197 WHERE `entry`=22750;
+UPDATE `item_template` SET `armor`=100 WHERE `entry`=22752;
+UPDATE `item_template` SET `armor`=126 WHERE `entry`=22856;
+UPDATE `item_template` SET `armor`=64 WHERE `entry`=22860;
+UPDATE `item_template` SET `armor`=115 WHERE `entry`=22864;
+UPDATE `item_template` SET `armor`=58 WHERE `entry`=22869;
+UPDATE `item_template` SET `armor`=58 WHERE `entry`=22870;
+UPDATE `item_template` SET `armor`=188 WHERE `entry`=22877;
+UPDATE `item_template` SET `armor`=165 WHERE `entry`=22878;
+UPDATE `item_template` SET `armor`=188 WHERE `entry`=22879;
+UPDATE `item_template` SET `armor`=165 WHERE `entry`=22880;
+UPDATE `item_template` SET `armor`=84 WHERE `entry`=22882;
+UPDATE `item_template` SET `armor`=84 WHERE `entry`=22883;
+UPDATE `item_template` SET `armor`=96 WHERE `entry`=22885;
+UPDATE `item_template` SET `armor`=96 WHERE `entry`=22886;
+UPDATE `item_template` SET `armor`=72 WHERE `entry`=22938;
+UPDATE `item_template` SET `armor`=0 WHERE `entry`=23018;
+UPDATE `item_template` SET `armor`=3854 WHERE `entry`=23043;
+UPDATE `item_template` SET `armor`=147 WHERE `entry`=23069;
+UPDATE `item_template` SET `armor`=276 WHERE `entry`=23226;
+UPDATE `item_template` SET `armor`=158 WHERE `entry`=23253;
+UPDATE `item_template` SET `armor`=146 WHERE `entry`=23254;
+UPDATE `item_template` SET `armor`=158 WHERE `entry`=23257;
+UPDATE `item_template` SET `armor`=146 WHERE `entry`=23258;
+UPDATE `item_template` SET `armor`=81 WHERE `entry`=23261;
+UPDATE `item_template` SET `armor`=75 WHERE `entry`=23262;
+UPDATE `item_template` SET `armor`=81 WHERE `entry`=23263;
+UPDATE `item_template` SET `armor`=75 WHERE `entry`=23264;
+UPDATE `item_template` SET `armor`=115 WHERE `entry`=23284;
+UPDATE `item_template` SET `armor`=126 WHERE `entry`=23285;
+UPDATE `item_template` SET `armor`=58 WHERE `entry`=23288;
+UPDATE `item_template` SET `armor`=58 WHERE `entry`=23290;
+UPDATE `item_template` SET `armor`=64 WHERE `entry`=23291;
+UPDATE `item_template` SET `armor`=188 WHERE `entry`=23294;
+UPDATE `item_template` SET `armor`=165 WHERE `entry`=23295;
+UPDATE `item_template` SET `armor`=188 WHERE `entry`=23298;
+UPDATE `item_template` SET `armor`=165 WHERE `entry`=23299;
+UPDATE `item_template` SET `armor`=84 WHERE `entry`=23302;
+UPDATE `item_template` SET `armor`=96 WHERE `entry`=23303;
+UPDATE `item_template` SET `armor`=84 WHERE `entry`=23304;
+UPDATE `item_template` SET `armor`=96 WHERE `entry`=23305;
+UPDATE `item_template` SET `armor`=158 WHERE `entry`=23308;
+UPDATE `item_template` SET `armor`=146 WHERE `entry`=23309;
+UPDATE `item_template` SET `armor`=158 WHERE `entry`=23312;
+UPDATE `item_template` SET `armor`=146 WHERE `entry`=23313;
+UPDATE `item_template` SET `armor`=81 WHERE `entry`=23316;
+UPDATE `item_template` SET `armor`=75 WHERE `entry`=23317;
+UPDATE `item_template` SET `armor`=81 WHERE `entry`=23318;
+UPDATE `item_template` SET `armor`=75 WHERE `entry`=23319;
+UPDATE `item_template` SET `armor`=722 WHERE `entry`=23517;
+UPDATE `item_template` SET `armor`=1010 WHERE `entry`=23518;
+UPDATE `item_template` SET `armor`=946 WHERE `entry`=23519;
+UPDATE `item_template` SET `armor`=1080 WHERE `entry`=23535;
+UPDATE `item_template` SET `armor`=83 WHERE `entry`=23825;
+UPDATE `item_template` SET `armor`=89 WHERE `entry`=24258;
+UPDATE `item_template` SET `armor`=63 WHERE `entry`=24379;
+UPDATE `item_template` SET `armor`=151 WHERE `entry`=26030;
+UPDATE `item_template` SET `armor`=144 WHERE `entry`=27645;
+UPDATE `item_template` SET `armor`=224 WHERE `entry`=27648;
+UPDATE `item_template` SET `armor`=88 WHERE `entry`=27768;
+UPDATE `item_template` SET `armor`=76 WHERE `entry`=27988;
+UPDATE `item_template` SET `armor`=243 WHERE `entry`=28126;
+UPDATE `item_template` SET `armor`=316 WHERE `entry`=28127;
+UPDATE `item_template` SET `armor`=340 WHERE `entry`=28128;
+UPDATE `item_template` SET `armor`=291 WHERE `entry`=28129;
+UPDATE `item_template` SET `armor`=389 WHERE `entry`=28130;
+UPDATE `item_template` SET `armor`=243 WHERE `entry`=28136;
+UPDATE `item_template` SET `armor`=316 WHERE `entry`=28137;
+UPDATE `item_template` SET `armor`=340 WHERE `entry`=28138;
+UPDATE `item_template` SET `armor`=291 WHERE `entry`=28139;
+UPDATE `item_template` SET `armor`=389 WHERE `entry`=28140;
+UPDATE `item_template` SET `armor`=0 WHERE `entry`=28211;
+UPDATE `item_template` SET `armor`=78 WHERE `entry`=28256;
+UPDATE `item_template` SET `armor`=78 WHERE `entry`=28301;
+UPDATE `item_template` SET `armor`=219 WHERE `entry`=28443;
+UPDATE `item_template` SET `armor`=267 WHERE `entry`=28444;
+UPDATE `item_template` SET `armor`=157 WHERE `entry`=28445;
+UPDATE `item_template` SET `armor`=219 WHERE `entry`=28446;
+UPDATE `item_template` SET `armor`=267 WHERE `entry`=28447;
+UPDATE `item_template` SET `armor`=157 WHERE `entry`=28448;
+UPDATE `item_template` SET `armor`=208 WHERE `entry`=28574;
+UPDATE `item_template` SET `armor`=208 WHERE `entry`=28575;
+UPDATE `item_template` SET `armor`=183 WHERE `entry`=28618;
+UPDATE `item_template` SET `armor`=237 WHERE `entry`=28619;
+UPDATE `item_template` SET `armor`=256 WHERE `entry`=28620;
+UPDATE `item_template` SET `armor`=219 WHERE `entry`=28622;
+UPDATE `item_template` SET `armor`=292 WHERE `entry`=28623;
+UPDATE `item_template` SET `armor`=97 WHERE `entry`=28660;
+UPDATE `item_template` SET `armor`=0 WHERE `entry`=28675;
+UPDATE `item_template` SET `armor`=183 WHERE `entry`=28719;
+UPDATE `item_template` SET `armor`=237 WHERE `entry`=28720;
+UPDATE `item_template` SET `armor`=256 WHERE `entry`=28721;
+UPDATE `item_template` SET `armor`=219 WHERE `entry`=28722;
+UPDATE `item_template` SET `armor`=292 WHERE `entry`=28723;
+UPDATE `item_template` SET `armor`=183 WHERE `entry`=28811;
+UPDATE `item_template` SET `armor`=237 WHERE `entry`=28812;
+UPDATE `item_template` SET `armor`=256 WHERE `entry`=28813;
+UPDATE `item_template` SET `armor`=219 WHERE `entry`=28814;
+UPDATE `item_template` SET `armor`=292 WHERE `entry`=28815;
+UPDATE `item_template` SET `armor`=183 WHERE `entry`=28871;
+UPDATE `item_template` SET `armor`=237 WHERE `entry`=28872;
+UPDATE `item_template` SET `armor`=256 WHERE `entry`=28873;
+UPDATE `item_template` SET `armor`=219 WHERE `entry`=28874;
+UPDATE `item_template` SET `armor`=292 WHERE `entry`=28875;
+UPDATE `item_template` SET `armor`=219 WHERE `entry`=28976;
+UPDATE `item_template` SET `armor`=267 WHERE `entry`=28977;
+UPDATE `item_template` SET `armor`=157 WHERE `entry`=28978;
+UPDATE `item_template` SET `armor`=219 WHERE `entry`=29004;
+UPDATE `item_template` SET `armor`=267 WHERE `entry`=29005;
+UPDATE `item_template` SET `armor`=157 WHERE `entry`=29006;
+UPDATE `item_template` SET `armor`=0 WHERE `entry`=29276;
+UPDATE `item_template` SET `armor`=0 WHERE `entry`=29277;
+UPDATE `item_template` SET `armor`=0 WHERE `entry`=29278;
+UPDATE `item_template` SET `armor`=0 WHERE `entry`=29279;
+UPDATE `item_template` SET `armor`=0 WHERE `entry`=29384;
+UPDATE `item_template` SET `armor`=93 WHERE `entry`=29385;
+UPDATE `item_template` SET `armor`=323 WHERE `entry`=29607;
+UPDATE `item_template` SET `armor`=67 WHERE `entry`=29777;
+UPDATE `item_template` SET `armor`=479 WHERE `entry`=30069;
+UPDATE `item_template` SET `armor`=114 WHERE `entry`=30931;
+UPDATE `item_template` SET `armor`=83 WHERE `entry`=30932;
+UPDATE `item_template` SET `armor`=243 WHERE `entry`=31375;
+UPDATE `item_template` SET `armor`=316 WHERE `entry`=31376;
+UPDATE `item_template` SET `armor`=340 WHERE `entry`=31377;
+UPDATE `item_template` SET `armor`=291 WHERE `entry`=31378;
+UPDATE `item_template` SET `armor`=389 WHERE `entry`=31379;
+UPDATE `item_template` SET `armor`=183 WHERE `entry`=31584;
+UPDATE `item_template` SET `armor`=237 WHERE `entry`=31585;
+UPDATE `item_template` SET `armor`=256 WHERE `entry`=31586;
+UPDATE `item_template` SET `armor`=219 WHERE `entry`=31587;
+UPDATE `item_template` SET `armor`=292 WHERE `entry`=31588;
+UPDATE `item_template` SET `armor`=183 WHERE `entry`=31589;
+UPDATE `item_template` SET `armor`=237 WHERE `entry`=31590;
+UPDATE `item_template` SET `armor`=256 WHERE `entry`=31591;
+UPDATE `item_template` SET `armor`=219 WHERE `entry`=31592;
+UPDATE `item_template` SET `armor`=292 WHERE `entry`=31593;
+UPDATE `item_template` SET `armor`=219 WHERE `entry`=31594;
+UPDATE `item_template` SET `armor`=267 WHERE `entry`=31595;
+UPDATE `item_template` SET `armor`=219 WHERE `entry`=31596;
+UPDATE `item_template` SET `armor`=267 WHERE `entry`=31597;
+UPDATE `item_template` SET `armor`=157 WHERE `entry`=31598;
+UPDATE `item_template` SET `armor`=157 WHERE `entry`=31599;
+UPDATE `item_template` SET `armor`=268 WHERE `entry`=31967;
+UPDATE `item_template` SET `armor`=348 WHERE `entry`=31968;
+UPDATE `item_template` SET `armor`=375 WHERE `entry`=31969;
+UPDATE `item_template` SET `armor`=321 WHERE `entry`=31971;
+UPDATE `item_template` SET `armor`=428 WHERE `entry`=31972;
+UPDATE `item_template` SET `armor`=143 WHERE `entry`=31973;
+UPDATE `item_template` SET `armor`=185 WHERE `entry`=31974;
+UPDATE `item_template` SET `armor`=200 WHERE `entry`=31975;
+UPDATE `item_template` SET `armor`=171 WHERE `entry`=31976;
+UPDATE `item_template` SET `armor`=228 WHERE `entry`=31977;
+UPDATE `item_template` SET `armor`=171 WHERE `entry`=31979;
+UPDATE `item_template` SET `armor`=185 WHERE `entry`=31980;
+UPDATE `item_template` SET `armor`=143 WHERE `entry`=31981;
+UPDATE `item_template` SET `armor`=228 WHERE `entry`=31982;
+UPDATE `item_template` SET `armor`=200 WHERE `entry`=31983;
+UPDATE `item_template` SET `armor`=268 WHERE `entry`=31987;
+UPDATE `item_template` SET `armor`=348 WHERE `entry`=31988;
+UPDATE `item_template` SET `armor`=375 WHERE `entry`=31989;
+UPDATE `item_template` SET `armor`=321 WHERE `entry`=31990;
+UPDATE `item_template` SET `armor`=428 WHERE `entry`=31991;
+UPDATE `item_template` SET `armor`=143 WHERE `entry`=32015;
+UPDATE `item_template` SET `armor`=185 WHERE `entry`=32016;
+UPDATE `item_template` SET `armor`=200 WHERE `entry`=32017;
+UPDATE `item_template` SET `armor`=171 WHERE `entry`=32018;
+UPDATE `item_template` SET `armor`=228 WHERE `entry`=32019;
+UPDATE `item_template` SET `armor`=143 WHERE `entry`=32034;
+UPDATE `item_template` SET `armor`=185 WHERE `entry`=32035;
+UPDATE `item_template` SET `armor`=200 WHERE `entry`=32036;
+UPDATE `item_template` SET `armor`=171 WHERE `entry`=32037;
+UPDATE `item_template` SET `armor`=228 WHERE `entry`=32038;
+UPDATE `item_template` SET `armor`=268 WHERE `entry`=32056;
+UPDATE `item_template` SET `armor`=348 WHERE `entry`=32057;
+UPDATE `item_template` SET `armor`=375 WHERE `entry`=32058;
+UPDATE `item_template` SET `armor`=321 WHERE `entry`=32059;
+UPDATE `item_template` SET `armor`=428 WHERE `entry`=32060;
+UPDATE `item_template` SET `armor`=294 WHERE `entry`=32786;
+UPDATE `item_template` SET `armor`=294 WHERE `entry`=32788;
+UPDATE `item_template` SET `armor`=294 WHERE `entry`=32796;
+UPDATE `item_template` SET `armor`=241 WHERE `entry`=32798;
+UPDATE `item_template` SET `armor`=241 WHERE `entry`=32800;
+UPDATE `item_template` SET `armor`=241 WHERE `entry`=32808;
+UPDATE `item_template` SET `armor`=174 WHERE `entry`=32810;
+UPDATE `item_template` SET `armor`=174 WHERE `entry`=32812;
+UPDATE `item_template` SET `armor`=174 WHERE `entry`=32821;
+UPDATE `item_template` SET `armor`=0 WHERE `entry`=33054;
+UPDATE `item_template` SET `armor`=153 WHERE `entry`=33759;
+UPDATE `item_template` SET `armor`=401 WHERE `entry`=33702;
+UPDATE `item_template` SET `armor`=287 WHERE `entry`=33700;
+UPDATE `item_template` SET `armor`=199 WHERE `entry`=33677;
+UPDATE `item_template` SET `armor`=199 WHERE `entry`=33718;
+UPDATE `item_template` SET `armor`=153 WHERE `entry`=33717;
+UPDATE `item_template` SET `armor`=199 WHERE `entry`=33745;
+UPDATE `item_template` SET `armor`=401 WHERE `entry`=33673;
+UPDATE `item_template` SET `armor`=199 WHERE `entry`=33758;
+UPDATE `item_template` SET `armor`=108 WHERE `entry`=33593;
+UPDATE `item_template` SET `armor`=214 WHERE `entry`=33761;
+UPDATE `item_template` SET `armor`=287 WHERE `entry`=33690;
+UPDATE `item_template` SET `armor`=153 WHERE `entry`=33676;
+UPDATE `item_template` SET `armor`=459 WHERE `entry`=33675;
+UPDATE `item_template` SET `armor`=244 WHERE `entry`=33680;
+UPDATE `item_template` SET `armor`=373 WHERE `entry`=33701;
+UPDATE `item_template` SET `armor`=168 WHERE `entry`=33914;
+UPDATE `item_template` SET `armor`=103 WHERE `entry`=33913;
+UPDATE `item_template` SET `armor`=244 WHERE `entry`=33721;
+UPDATE `item_template` SET `armor`=138 WHERE `entry`=33900;
+UPDATE `item_template` SET `armor`=244 WHERE `entry`=33760;
+UPDATE `item_template` SET `armor`=459 WHERE `entry`=33704;
+UPDATE `item_template` SET `armor`=199 WHERE `entry`=33683;
+UPDATE `item_template` SET `armor`=168 WHERE `entry`=33884;
+UPDATE `item_template` SET `armor`=138 WHERE `entry`=33912;
+UPDATE `item_template` SET `armor`=153 WHERE `entry`=33684;
+UPDATE `item_template` SET `armor`=103 WHERE `entry`=33901;
+UPDATE `item_template` SET `armor`=214 WHERE `entry`=33678;
+UPDATE `item_template` SET `armor`=138 WHERE `entry`=33882;
+UPDATE `item_template` SET `armor`=103 WHERE `entry`=33883;
+UPDATE `item_template` SET `armor`=153 WHERE `entry`=33744;
+UPDATE `item_template` SET `armor`=258 WHERE `entry`=33879;
+UPDATE `item_template` SET `armor`=287 WHERE `entry`=33671;
+UPDATE `item_template` SET `armor`=373 WHERE `entry`=33691;
+UPDATE `item_template` SET `armor`=459 WHERE `entry`=33694;
+UPDATE `item_template` SET `armor`=258 WHERE `entry`=33885;
+UPDATE `item_template` SET `armor`=315 WHERE `entry`=33886;
+UPDATE `item_template` SET `armor`=194 WHERE `entry`=33887;
+UPDATE `item_template` SET `armor`=168 WHERE `entry`=33902;
+UPDATE `item_template` SET `armor`=373 WHERE `entry`=33672;
+UPDATE `item_template` SET `armor`=194 WHERE `entry`=33881;
+UPDATE `item_template` SET `armor`=214 WHERE `entry`=33686;
+UPDATE `item_template` SET `armor`=244 WHERE `entry`=33685;
+UPDATE `item_template` SET `armor`=401 WHERE `entry`=33692;
+UPDATE `item_template` SET `armor`=214 WHERE `entry`=33719;
+UPDATE `item_template` SET `armor`=244 WHERE `entry`=33748;
+UPDATE `item_template` SET `armor`=315 WHERE `entry`=33880;
+UPDATE `item_template` SET `armor`=194 WHERE `entry`=33917;
+UPDATE `item_template` SET `armor`=287 WHERE `entry`=33767;
+UPDATE `item_template` SET `armor`=401 WHERE `entry`=33769;
+UPDATE `item_template` SET `armor`=315 WHERE `entry`=33916;
+UPDATE `item_template` SET `armor`=373 WHERE `entry`=33768;
+UPDATE `item_template` SET `armor`=459 WHERE `entry`=33771;
+UPDATE `item_template` SET `armor`=258 WHERE `entry`=33915;
+UPDATE `item_template` SET `armor`=214 WHERE `entry`=33746;
+UPDATE `item_template` SET `armor`=183 WHERE `entry`=33679;
+UPDATE `item_template` SET `armor`=183 WHERE `entry`=33682;
+UPDATE `item_template` SET `armor`=344 WHERE `entry`=33693;
+UPDATE `item_template` SET `armor`=344 WHERE `entry`=33674;
+UPDATE `item_template` SET `armor`=344 WHERE `entry`=33770;
+UPDATE `item_template` SET `armor`=183 WHERE `entry`=33747;
+UPDATE `item_template` SET `armor`=183 WHERE `entry`=33720;
+UPDATE `item_template` SET `armor`=344 WHERE `entry`=33703;
+UPDATE `item_template` SET `armor`=183 WHERE `entry`=33757;
+UPDATE `item_template` SET `armor`=0 WHERE `entry`=34706;
+UPDATE `item_template` SET `armor`=93 WHERE `entry`=34810;
+UPDATE `item_template` SET `armor`=0 WHERE `entry`=34888;
+UPDATE `item_template` SET `armor`=183 WHERE `entry`=35356;
+UPDATE `item_template` SET `armor`=237 WHERE `entry`=35357;
+UPDATE `item_template` SET `armor`=256 WHERE `entry`=35358;
+UPDATE `item_template` SET `armor`=219 WHERE `entry`=35359;
+UPDATE `item_template` SET `armor`=292 WHERE `entry`=35360;
+UPDATE `item_template` SET `armor`=183 WHERE `entry`=35361;
+UPDATE `item_template` SET `armor`=237 WHERE `entry`=35362;
+UPDATE `item_template` SET `armor`=256 WHERE `entry`=35363;
+UPDATE `item_template` SET `armor`=219 WHERE `entry`=35364;
+UPDATE `item_template` SET `armor`=292 WHERE `entry`=35365;
+UPDATE `item_template` SET `armor`=183 WHERE `entry`=35371;
+UPDATE `item_template` SET `armor`=237 WHERE `entry`=35372;
+UPDATE `item_template` SET `armor`=256 WHERE `entry`=35373;
+UPDATE `item_template` SET `armor`=219 WHERE `entry`=35374;
+UPDATE `item_template` SET `armor`=292 WHERE `entry`=35375;
+UPDATE `item_template` SET `armor`=292 WHERE `entry`=35469;
+UPDATE `item_template` SET `armor`=219 WHERE `entry`=35470;
+UPDATE `item_template` SET `armor`=183 WHERE `entry`=35471;
+UPDATE `item_template` SET `armor`=0 WHERE `entry`=34213;
+UPDATE `item_template` SET `armor`=166 WHERE `entry`=35003;
+UPDATE `item_template` SET `armor`=312 WHERE `entry`=35022;
+UPDATE `item_template` SET `armor`=436 WHERE `entry`=35024;
+UPDATE `item_template` SET `armor`=374 WHERE `entry`=35025;
+UPDATE `item_template` SET `armor`=499 WHERE `entry`=35026;
+UPDATE `item_template` SET `armor`=405 WHERE `entry`=35023;
+UPDATE `item_template` SET `armor`=374 WHERE `entry`=35001;
+UPDATE `item_template` SET `armor`=499 WHERE `entry`=35002;
+UPDATE `item_template` SET `armor`=405 WHERE `entry`=34999;
+UPDATE `item_template` SET `armor`=312 WHERE `entry`=34998;
+UPDATE `item_template` SET `armor`=436 WHERE `entry`=35000;
+UPDATE `item_template` SET `armor`=374 WHERE `entry`=35114;
+UPDATE `item_template` SET `armor`=499 WHERE `entry`=35115;
+UPDATE `item_template` SET `armor`=405 WHERE `entry`=35112;
+UPDATE `item_template` SET `armor`=312 WHERE `entry`=35111;
+UPDATE `item_template` SET `armor`=436 WHERE `entry`=35113;
+UPDATE `item_template` SET `armor`=266 WHERE `entry`=35099;
+UPDATE `item_template` SET `armor`=232 WHERE `entry`=35100;
+UPDATE `item_template` SET `armor`=166 WHERE `entry`=35098;
+UPDATE `item_template` SET `armor`=199 WHERE `entry`=35096;
+UPDATE `item_template` SET `armor`=216 WHERE `entry`=35097;
+UPDATE `item_template` SET `armor`=312 WHERE `entry`=35032;
+UPDATE `item_template` SET `armor`=499 WHERE `entry`=35036;
+UPDATE `item_template` SET `armor`=405 WHERE `entry`=35033;
+UPDATE `item_template` SET `armor`=374 WHERE `entry`=35035;
+UPDATE `item_template` SET `armor`=436 WHERE `entry`=35034;
+UPDATE `item_template` SET `armor`=232 WHERE `entry`=35005;
+UPDATE `item_template` SET `armor`=266 WHERE `entry`=35007;
+UPDATE `item_template` SET `armor`=199 WHERE `entry`=35006;
+UPDATE `item_template` SET `armor`=216 WHERE `entry`=35004;
+UPDATE `item_template` SET `armor`=199 WHERE `entry`=35009;
+UPDATE `item_template` SET `armor`=166 WHERE `entry`=35011;
+UPDATE `item_template` SET `armor`=266 WHERE `entry`=35012;
+UPDATE `item_template` SET `armor`=216 WHERE `entry`=35010;
+UPDATE `item_template` SET `armor`=232 WHERE `entry`=35013;
+UPDATE `item_template` SET `armor`=149 WHERE `entry`=35153;
+UPDATE `item_template` SET `armor`=149 WHERE `entry`=35159;
+UPDATE `item_template` SET `armor`=166 WHERE `entry`=35053;
+UPDATE `item_template` SET `armor`=149 WHERE `entry`=35164;
+UPDATE `item_template` SET `armor`=280 WHERE `entry`=35165;
+UPDATE `item_template` SET `armor`=280 WHERE `entry`=35152;
+UPDATE `item_template` SET `armor`=211 WHERE `entry`=35167;
+UPDATE `item_template` SET `armor`=280 WHERE `entry`=35154;
+UPDATE `item_template` SET `armor`=113 WHERE `entry`=35168;
+UPDATE `item_template` SET `armor`=113 WHERE `entry`=35174;
+UPDATE `item_template` SET `armor`=232 WHERE `entry`=35055;
+UPDATE `item_template` SET `armor`=113 WHERE `entry`=35179;
+UPDATE `item_template` SET `armor`=343 WHERE `entry`=35139;
+UPDATE `item_template` SET `armor`=211 WHERE `entry`=35169;
+UPDATE `item_template` SET `armor`=266 WHERE `entry`=35057;
+UPDATE `item_template` SET `armor`=216 WHERE `entry`=35054;
+UPDATE `item_template` SET `armor`=232 WHERE `entry`=35085;
+UPDATE `item_template` SET `armor`=266 WHERE `entry`=35087;
+UPDATE `item_template` SET `armor`=199 WHERE `entry`=35086;
+UPDATE `item_template` SET `armor`=216 WHERE `entry`=35084;
+UPDATE `item_template` SET `armor`=166 WHERE `entry`=35083;
+UPDATE `item_template` SET `armor`=199 WHERE `entry`=35056;
+UPDATE `item_template` SET `armor`=183 WHERE `entry`=35149;
+UPDATE `item_template` SET `armor`=211 WHERE `entry`=35180;
+UPDATE `item_template` SET `armor`=343 WHERE `entry`=35150;
+UPDATE `item_template` SET `armor`=343 WHERE `entry`=35137;
+UPDATE `item_template` SET `armor`=183 WHERE `entry`=35138;
+UPDATE `item_template` SET `armor`=183 WHERE `entry`=35144;
+UPDATE `item_template` SET `armor`=120 WHERE `entry`=6733;
+UPDATE `item_template` SET `armor`=455 WHERE `entry`=15141;
+UPDATE `item_template` SET `armor`=140 WHERE `entry`=37084;
+UPDATE `item_template` SET `armor`=150 WHERE `entry`=39225;
+UPDATE `item_template` SET `armor`=154 WHERE `entry`=40252;
+UPDATE `item_template` SET `armor`=1650 WHERE `entry`=41190;
+UPDATE `item_template` SET `armor`=127 WHERE `entry`=41238;
+UPDATE `item_template` SET `armor`=889 WHERE `entry`=42826;
+UPDATE `item_template` SET `armor`=2054 WHERE `entry`=45267;
+UPDATE `item_template` SET `armor`=2310 WHERE `entry`=49904;
+UPDATE `item_template` SET `armor`=177 WHERE `entry`=50466;
+UPDATE `item_template` SET `armor`=1105 WHERE `entry`=50802;
+UPDATE `item_template` SET `armor`=1579 WHERE `entry`=50849;
+UPDATE `item_template` SET `armor`=2526 WHERE `entry`=50850;
+UPDATE `item_template` SET `armor`=1579 WHERE `entry`=50856;
+UPDATE `item_template` SET `armor`=2526 WHERE `entry`=50857;
+UPDATE `item_template` SET `armor`=1579 WHERE `entry`=50863;
+UPDATE `item_template` SET `armor`=2641 WHERE `entry`=50968;
+UPDATE `item_template` SET `armor`=1650 WHERE `entry`=50978;
+UPDATE `item_template` SET `armor`=1485 WHERE `entry`=50991;
+UPDATE `item_template` SET `armor`=1650 WHERE `entry`=51172;
+UPDATE `item_template` SET `armor`=2641 WHERE `entry`=51174;
+UPDATE `item_template` SET `armor`=1650 WHERE `entry`=51217;
+UPDATE `item_template` SET `armor`=2526 WHERE `entry`=50864;
+UPDATE `item_template` SET `armor`=1650 WHERE `entry`=51132;
+UPDATE `item_template` SET `armor`=2641 WHERE `entry`=51219;
+UPDATE `item_template` SET `armor`=2756 WHERE `entry`=51220;
+UPDATE `item_template` SET `armor`=1723 WHERE `entry`=51222;
+UPDATE `item_template` SET `armor`=2641 WHERE `entry`=51134;
+UPDATE `item_template` SET `armor`=2756 WHERE `entry`=51265;
+UPDATE `item_template` SET `armor`=1723 WHERE `entry`=51267;
+UPDATE `item_template` SET `armor`=2756 WHERE `entry`=51305;
+UPDATE `item_template` SET `armor`=1723 WHERE `entry`=51307;
+UPDATE `item_template` SET `armor`=1155 WHERE `entry`=51901;
+UPDATE `item_template` SET `armor`=159 WHERE `entry`=54801;
+UPDATE `item_template` SET `armor`=243 WHERE `entry`=42680;
+UPDATE `item_template` SET `armor`=316 WHERE `entry`=42681;
+UPDATE `item_template` SET `armor`=340 WHERE `entry`=42682;
+UPDATE `item_template` SET `armor`=291 WHERE `entry`=42683;
+UPDATE `item_template` SET `armor`=389 WHERE `entry`=42684;
+UPDATE `item_template` SET `armor`=243 WHERE `entry`=42685;
+UPDATE `item_template` SET `armor`=316 WHERE `entry`=42686;
+UPDATE `item_template` SET `armor`=340 WHERE `entry`=42687;
+UPDATE `item_template` SET `armor`=291 WHERE `entry`=42688;
+UPDATE `item_template` SET `armor`=389 WHERE `entry`=42689;
diff --git a/src/server/game/Handlers/ItemHandler.cpp b/src/server/game/Handlers/ItemHandler.cpp
index 77d44dffd1b..712b1f5f25a 100644
--- a/src/server/game/Handlers/ItemHandler.cpp
+++ b/src/server/game/Handlers/ItemHandler.cpp
@@ -348,7 +348,7 @@ void WorldSession::HandleItemQuerySingleOpcode(WorldPacket& recvData)
         }
 
         // resistances (7)
-        data << pProto->Armor;
+        data << (pProto->Armor ? pProto->Armor + uint32(pProto->ArmorDamageModifier) : 0);
         data << pProto->HolyRes;
         data << pProto->FireRes;
         data << pProto->NatureRes;