Core/Player: Fix armor calculation - 2nd try

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.

3 files changed, 651 insertions, 1 deletions

diff --git a/sql/updates/world/2013_01_01_00_item_template_restore.sql b/sql/updates/world/2013_01_01_00_item_template_restore.sql
new file mode 100644
index 00000000000..dc18ff71fe8
--- /dev/null
+++ b/sql/updates/world/2013_01_01_00_item_template_restore.sql
@@ -0,0 +1,646 @@
+UPDATE `item_template` SET `armor`=2163 WHERE `entry`=1169;
+UPDATE `item_template` SET `armor`=278 WHERE `entry`=1717;
+UPDATE `item_template` SET `armor`=131 WHERE `entry`=3835;
+UPDATE `item_template` SET `armor`=358 WHERE `entry`=3844;
+UPDATE `item_template` SET `armor`=1101 WHERE `entry`=4070;
+UPDATE `item_template` SET `armor`=513 WHERE `entry`=6447;
+UPDATE `item_template` SET `armor`=775 WHERE `entry`=6725;
+UPDATE `item_template` SET `armor`=198 WHERE `entry`=6731;
+UPDATE `item_template` SET `armor`=234 WHERE `entry`=6742;
+UPDATE `item_template` SET `armor`=311 WHERE `entry`=6907;
+UPDATE `item_template` SET `armor`=363 WHERE `entry`=7919;
+UPDATE `item_template` SET `armor`=502 WHERE `entry`=7921;
+UPDATE `item_template` SET `armor`=421 WHERE `entry`=7922;
+UPDATE `item_template` SET `armor`=536 WHERE `entry`=7930;
+UPDATE `item_template` SET `armor`=382 WHERE `entry`=7933;
+UPDATE `item_template` SET `armor`=469 WHERE `entry`=7934;
+UPDATE `item_template` SET `armor`=341 WHERE `entry`=7963;
+UPDATE `item_template` SET `armor`=165 WHERE `entry`=9409;
+UPDATE `item_template` SET `armor`=391 WHERE `entry`=9625;
+UPDATE `item_template` SET `armor`=193 WHERE `entry`=10783;
+UPDATE `item_template` SET `armor`=817 WHERE `entry`=11604;
+UPDATE `item_template` SET `armor`=514 WHERE `entry`=11605;
+UPDATE `item_template` SET `armor`=433 WHERE `entry`=11606;
+UPDATE `item_template` SET `armor`=1903 WHERE `entry`=11631;
+UPDATE `item_template` SET `armor`=50 WHERE `entry`=11669;
+UPDATE `item_template` SET `armor`=484 WHERE `entry`=11703;
+UPDATE `item_template` SET `armor`=742 WHERE `entry`=11927;
+UPDATE `item_template` SET `armor`=150 WHERE `entry`=12544;
+UPDATE `item_template` SET `armor`=190 WHERE `entry`=12551;
+UPDATE `item_template` SET `armor`=553 WHERE `entry`=12557;
+UPDATE `item_template` SET `armor`=527 WHERE `entry`=12610;
+UPDATE `item_template` SET `armor`=492 WHERE `entry`=12611;
+UPDATE `item_template` SET `armor`=621 WHERE `entry`=12612;
+UPDATE `item_template` SET `armor`=738 WHERE `entry`=12613;
+UPDATE `item_template` SET `armor`=665 WHERE `entry`=12614;
+UPDATE `item_template` SET `armor`=629 WHERE `entry`=12633;
+UPDATE `item_template` SET `armor`=611 WHERE `entry`=12641;
+UPDATE `item_template` SET `armor`=711 WHERE `entry`=13079;
+UPDATE `item_template` SET `armor`=185 WHERE `entry`=13252;
+UPDATE `item_template` SET `armor`=207 WHERE `entry`=13258;
+UPDATE `item_template` SET `armor`=519 WHERE `entry`=13502;
+UPDATE `item_template` SET `armor`=688 WHERE `entry`=13955;
+UPDATE `item_template` SET `armor`=267 WHERE `entry`=35496;
+UPDATE `item_template` SET `armor`=268 WHERE `entry`=15053;
+UPDATE `item_template` SET `armor`=204 WHERE `entry`=15054;
+UPDATE `item_template` SET `armor`=167 WHERE `entry`=15055;
+UPDATE `item_template` SET `armor`=807 WHERE `entry`=15413;
+UPDATE `item_template` SET `armor`=96 WHERE `entry`=16341;
+UPDATE `item_template` SET `armor`=115 WHERE `entry`=16342;
+UPDATE `item_template` SET `armor`=125 WHERE `entry`=16437;
+UPDATE `item_template` SET `armor`=118 WHERE `entry`=16440;
+UPDATE `item_template` SET `armor`=175 WHERE `entry`=16441;
+UPDATE `item_template` SET `armor`=169 WHERE `entry`=16442;
+UPDATE `item_template` SET `armor`=199 WHERE `entry`=16443;
+UPDATE `item_template` SET `armor`=147 WHERE `entry`=16444;
+UPDATE `item_template` SET `armor`=207 WHERE `entry`=16446;
+UPDATE `item_template` SET `armor`=192 WHERE `entry`=16448;
+UPDATE `item_template` SET `armor`=238 WHERE `entry`=16449;
+UPDATE `item_template` SET `armor`=242 WHERE `entry`=16450;
+UPDATE `item_template` SET `armor`=234 WHERE `entry`=16451;
+UPDATE `item_template` SET `armor`=291 WHERE `entry`=16452;
+UPDATE `item_template` SET `armor`=291 WHERE `entry`=16453;
+UPDATE `item_template` SET `armor`=212 WHERE `entry`=16454;
+UPDATE `item_template` SET `armor`=254 WHERE `entry`=16455;
+UPDATE `item_template` SET `armor`=262 WHERE `entry`=16456;
+UPDATE `item_template` SET `armor`=238 WHERE `entry`=16457;
+UPDATE `item_template` SET `armor`=197 WHERE `entry`=16459;
+UPDATE `item_template` SET `armor`=405 WHERE `entry`=16462;
+UPDATE `item_template` SET `armor`=363 WHERE `entry`=16463;
+UPDATE `item_template` SET `armor`=486 WHERE `entry`=16465;
+UPDATE `item_template` SET `armor`=587 WHERE `entry`=16466;
+UPDATE `item_template` SET `armor`=502 WHERE `entry`=16467;
+UPDATE `item_template` SET `armor`=453 WHERE `entry`=16468;
+UPDATE `item_template` SET `armor`=994 WHERE `entry`=16477;
+UPDATE `item_template` SET `armor`=815 WHERE `entry`=16478;
+UPDATE `item_template` SET `armor`=842 WHERE `entry`=16479;
+UPDATE `item_template` SET `armor`=670 WHERE `entry`=16483;
+UPDATE `item_template` SET `armor`=603 WHERE `entry`=16484;
+UPDATE `item_template` SET `armor`=175 WHERE `entry`=16533;
+UPDATE `item_template` SET `armor`=169 WHERE `entry`=16534;
+UPDATE `item_template` SET `armor`=199 WHERE `entry`=16535;
+UPDATE `item_template` SET `armor`=147 WHERE `entry`=16536;
+UPDATE `item_template` SET `armor`=125 WHERE `entry`=16539;
+UPDATE `item_template` SET `armor`=118 WHERE `entry`=16540;
+UPDATE `item_template` SET `armor`=994 WHERE `entry`=16541;
+UPDATE `item_template` SET `armor`=815 WHERE `entry`=16542;
+UPDATE `item_template` SET `armor`=842 WHERE `entry`=16543;
+UPDATE `item_template` SET `armor`=670 WHERE `entry`=16545;
+UPDATE `item_template` SET `armor`=603 WHERE `entry`=16548;
+UPDATE `item_template` SET `armor`=291 WHERE `entry`=16549;
+UPDATE `item_template` SET `armor`=234 WHERE `entry`=16550;
+UPDATE `item_template` SET `armor`=238 WHERE `entry`=16551;
+UPDATE `item_template` SET `armor`=242 WHERE `entry`=16552;
+UPDATE `item_template` SET `armor`=197 WHERE `entry`=16554;
+UPDATE `item_template` SET `armor`=192 WHERE `entry`=16555;
+UPDATE `item_template` SET `armor`=212 WHERE `entry`=16560;
+UPDATE `item_template` SET `armor`=254 WHERE `entry`=16561;
+UPDATE `item_template` SET `armor`=238 WHERE `entry`=16562;
+UPDATE `item_template` SET `armor`=291 WHERE `entry`=16563;
+UPDATE `item_template` SET `armor`=262 WHERE `entry`=16564;
+UPDATE `item_template` SET `armor`=587 WHERE `entry`=16565;
+UPDATE `item_template` SET `armor`=486 WHERE `entry`=16566;
+UPDATE `item_template` SET `armor`=502 WHERE `entry`=16567;
+UPDATE `item_template` SET `armor`=453 WHERE `entry`=16568;
+UPDATE `item_template` SET `armor`=405 WHERE `entry`=16569;
+UPDATE `item_template` SET `armor`=363 WHERE `entry`=16571;
+UPDATE `item_template` SET `armor`=393 WHERE `entry`=16574;
+UPDATE `item_template` SET `armor`=863 WHERE `entry`=17013;
+UPDATE `item_template` SET `armor`=436 WHERE `entry`=17014;
+UPDATE `item_template` SET `armor`=124 WHERE `entry`=17107;
+UPDATE `item_template` SET `armor`=145 WHERE `entry`=17578;
+UPDATE `item_template` SET `armor`=149 WHERE `entry`=17579;
+UPDATE `item_template` SET `armor`=127 WHERE `entry`=17580;
+UPDATE `item_template` SET `armor`=169 WHERE `entry`=17581;
+UPDATE `item_template` SET `armor`=145 WHERE `entry`=17583;
+UPDATE `item_template` SET `armor`=145 WHERE `entry`=17586;
+UPDATE `item_template` SET `armor`=127 WHERE `entry`=17590;
+UPDATE `item_template` SET `armor`=145 WHERE `entry`=17591;
+UPDATE `item_template` SET `armor`=169 WHERE `entry`=17592;
+UPDATE `item_template` SET `armor`=149 WHERE `entry`=17593;
+UPDATE `item_template` SET `armor`=175 WHERE `entry`=17602;
+UPDATE `item_template` SET `armor`=179 WHERE `entry`=17603;
+UPDATE `item_template` SET `armor`=157 WHERE `entry`=17604;
+UPDATE `item_template` SET `armor`=199 WHERE `entry`=17605;
+UPDATE `item_template` SET `armor`=135 WHERE `entry`=17607;
+UPDATE `item_template` SET `armor`=128 WHERE `entry`=17608;
+UPDATE `item_template` SET `armor`=135 WHERE `entry`=17618;
+UPDATE `item_template` SET `armor`=128 WHERE `entry`=17620;
+UPDATE `item_template` SET `armor`=157 WHERE `entry`=17622;
+UPDATE `item_template` SET `armor`=175 WHERE `entry`=17623;
+UPDATE `item_template` SET `armor`=199 WHERE `entry`=17624;
+UPDATE `item_template` SET `armor`=179 WHERE `entry`=17625;
+UPDATE `item_template` SET `armor`=683 WHERE `entry`=17734;
+UPDATE `item_template` SET `armor`=2916 WHERE `entry`=18168;
+UPDATE `item_template` SET `armor`=383 WHERE `entry`=18351;
+UPDATE `item_template` SET `armor`=538 WHERE `entry`=18383;
+UPDATE `item_template` SET `armor`=214 WHERE `entry`=18413;
+UPDATE `item_template` SET `armor`=66 WHERE `entry`=18427;
+UPDATE `item_template` SET `armor`=66 WHERE `entry`=18440;
+UPDATE `item_template` SET `armor`=96 WHERE `entry`=18441;
+UPDATE `item_template` SET `armor`=115 WHERE `entry`=18461;
+UPDATE `item_template` SET `armor`=777 WHERE `entry`=18503;
+UPDATE `item_template` SET `armor`=552 WHERE `entry`=18521;
+UPDATE `item_template` SET `armor`=2106 WHERE `entry`=18535;
+UPDATE `item_template` SET `armor`=114 WHERE `entry`=18689;
+UPDATE `item_template` SET `armor`=696 WHERE `entry`=18690;
+UPDATE `item_template` SET `armor`=371 WHERE `entry`=18712;
+UPDATE `item_template` SET `armor`=584 WHERE `entry`=18718;
+UPDATE `item_template` SET `armor`=711 WHERE `entry`=18806;
+UPDATE `item_template` SET `armor`=447 WHERE `entry`=18829;
+UPDATE `item_template` SET `armor`=834 WHERE `entry`=18861;
+UPDATE `item_template` SET `armor`=110 WHERE `entry`=18879;
+UPDATE `item_template` SET `armor`=845 WHERE `entry`=19148;
+UPDATE `item_template` SET `armor`=238 WHERE `entry`=19149;
+UPDATE `item_template` SET `armor`=310 WHERE `entry`=19381;
+UPDATE `item_template` SET `armor`=177 WHERE `entry`=19386;
+UPDATE `item_template` SET `armor`=424 WHERE `entry`=19405;
+UPDATE `item_template` SET `armor`=237 WHERE `entry`=19509;
+UPDATE `item_template` SET `armor`=736 WHERE `entry`=19693;
+UPDATE `item_template` SET `armor`=722 WHERE `entry`=19694;
+UPDATE `item_template` SET `armor`=932 WHERE `entry`=19822;
+UPDATE `item_template` SET `armor`=315 WHERE `entry`=19838;
+UPDATE `item_template` SET `armor`=180 WHERE `entry`=19839;
+UPDATE `item_template` SET `armor`=133 WHERE `entry`=19840;
+UPDATE `item_template` SET `armor`=240 WHERE `entry`=19877;
+UPDATE `item_template` SET `armor`=140 WHERE `entry`=19888;
+UPDATE `item_template` SET `armor`=184 WHERE `entry`=19892;
+UPDATE `item_template` SET `armor`=201 WHERE `entry`=19928;
+UPDATE `item_template` SET `armor`=741 WHERE `entry`=20039;
+UPDATE `item_template` SET `armor`=159 WHERE `entry`=20045;
+UPDATE `item_template` SET `armor`=159 WHERE `entry`=20046;
+UPDATE `item_template` SET `armor`=150 WHERE `entry`=20047;
+UPDATE `item_template` SET `armor`=181 WHERE `entry`=20052;
+UPDATE `item_template` SET `armor`=181 WHERE `entry`=20053;
+UPDATE `item_template` SET `armor`=161 WHERE `entry`=20054;
+UPDATE `item_template` SET `armor`=279 WHERE `entry`=20059;
+UPDATE `item_template` SET `armor`=279 WHERE `entry`=20060;
+UPDATE `item_template` SET `armor`=196 WHERE `entry`=20061;
+UPDATE `item_template` SET `armor`=100 WHERE `entry`=20069;
+UPDATE `item_template` SET `armor`=40 WHERE `entry`=20070;
+UPDATE `item_template` SET `armor`=132 WHERE `entry`=20094;
+UPDATE `item_template` SET `armor`=103 WHERE `entry`=20095;
+UPDATE `item_template` SET `armor`=84 WHERE `entry`=20096;
+UPDATE `item_template` SET `armor`=113 WHERE `entry`=20097;
+UPDATE `item_template` SET `armor`=105 WHERE `entry`=20098;
+UPDATE `item_template` SET `armor`=88 WHERE `entry`=20099;
+UPDATE `item_template` SET `armor`=145 WHERE `entry`=20100;
+UPDATE `item_template` SET `armor`=129 WHERE `entry`=20101;
+UPDATE `item_template` SET `armor`=104 WHERE `entry`=20102;
+UPDATE `item_template` SET `armor`=136 WHERE `entry`=20103;
+UPDATE `item_template` SET `armor`=113 WHERE `entry`=20104;
+UPDATE `item_template` SET `armor`=91 WHERE `entry`=20105;
+UPDATE `item_template` SET `armor`=145 WHERE `entry`=20112;
+UPDATE `item_template` SET `armor`=129 WHERE `entry`=20113;
+UPDATE `item_template` SET `armor`=104 WHERE `entry`=20114;
+UPDATE `item_template` SET `armor`=136 WHERE `entry`=20115;
+UPDATE `item_template` SET `armor`=113 WHERE `entry`=20116;
+UPDATE `item_template` SET `armor`=91 WHERE `entry`=20117;
+UPDATE `item_template` SET `armor`=161 WHERE `entry`=20159;
+UPDATE `item_template` SET `armor`=132 WHERE `entry`=20160;
+UPDATE `item_template` SET `armor`=103 WHERE `entry`=20161;
+UPDATE `item_template` SET `armor`=84 WHERE `entry`=20162;
+UPDATE `item_template` SET `armor`=150 WHERE `entry`=20163;
+UPDATE `item_template` SET `armor`=88 WHERE `entry`=20164;
+UPDATE `item_template` SET `armor`=113 WHERE `entry`=20165;
+UPDATE `item_template` SET `armor`=105 WHERE `entry`=20166;
+UPDATE `item_template` SET `armor`=181 WHERE `entry`=20167;
+UPDATE `item_template` SET `armor`=129 WHERE `entry`=20168;
+UPDATE `item_template` SET `armor`=104 WHERE `entry`=20169;
+UPDATE `item_template` SET `armor`=145 WHERE `entry`=20170;
+UPDATE `item_template` SET `armor`=159 WHERE `entry`=20171;
+UPDATE `item_template` SET `armor`=91 WHERE `entry`=20172;
+UPDATE `item_template` SET `armor`=113 WHERE `entry`=20173;
+UPDATE `item_template` SET `armor`=136 WHERE `entry`=20174;
+UPDATE `item_template` SET `armor`=279 WHERE `entry`=20175;
+UPDATE `item_template` SET `armor`=196 WHERE `entry`=20176;
+UPDATE `item_template` SET `armor`=181 WHERE `entry`=20186;
+UPDATE `item_template` SET `armor`=129 WHERE `entry`=20187;
+UPDATE `item_template` SET `armor`=104 WHERE `entry`=20188;
+UPDATE `item_template` SET `armor`=145 WHERE `entry`=20189;
+UPDATE `item_template` SET `armor`=159 WHERE `entry`=20190;
+UPDATE `item_template` SET `armor`=91 WHERE `entry`=20191;
+UPDATE `item_template` SET `armor`=113 WHERE `entry`=20192;
+UPDATE `item_template` SET `armor`=136 WHERE `entry`=20193;
+UPDATE `item_template` SET `armor`=279 WHERE `entry`=20194;
+UPDATE `item_template` SET `armor`=40 WHERE `entry`=20214;
+UPDATE `item_template` SET `armor`=100 WHERE `entry`=20220;
+UPDATE `item_template` SET `armor`=173 WHERE `entry`=20259;
+UPDATE `item_template` SET `armor`=220 WHERE `entry`=20476;
+UPDATE `item_template` SET `armor`=308 WHERE `entry`=20477;
+UPDATE `item_template` SET `armor`=485 WHERE `entry`=20478;
+UPDATE `item_template` SET `armor`=322 WHERE `entry`=20627;
+UPDATE `item_template` SET `armor`=99 WHERE `entry`=20693;
+UPDATE `item_template` SET `armor`=512 WHERE `entry`=20710;
+UPDATE `item_template` SET `armor`=30 WHERE `entry`=20907;
+UPDATE `item_template` SET `armor`=164 WHERE `entry`=21348;
+UPDATE `item_template` SET `armor`=123 WHERE `entry`=21349;
+UPDATE `item_template` SET `armor`=132 WHERE `entry`=21350;
+UPDATE `item_template` SET `armor`=201 WHERE `entry`=21351;
+UPDATE `item_template` SET `armor`=173 WHERE `entry`=21352;
+UPDATE `item_template` SET `armor`=143 WHERE `entry`=21456;
+UPDATE `item_template` SET `armor`=287 WHERE `entry`=21467;
+UPDATE `item_template` SET `armor`=182 WHERE `entry`=21501;
+UPDATE `item_template` SET `armor`=494 WHERE `entry`=21503;
+UPDATE `item_template` SET `armor`=100 WHERE `entry`=21601;
+UPDATE `item_template` SET `armor`=269 WHERE `entry`=21605;
+UPDATE `item_template` SET `armor`=238 WHERE `entry`=21645;
+UPDATE `item_template` SET `armor`=204 WHERE `entry`=21675;
+UPDATE `item_template` SET `armor`=224 WHERE `entry`=21682;
+UPDATE `item_template` SET `armor`=276 WHERE `entry`=21693;
+UPDATE `item_template` SET `armor`=727 WHERE `entry`=21706;
+UPDATE `item_template` SET `armor`=198 WHERE `entry`=21888;
+UPDATE `item_template` SET `armor`=219 WHERE `entry`=22301;
+UPDATE `item_template` SET `armor`=203 WHERE `entry`=22302;
+UPDATE `item_template` SET `armor`=207 WHERE `entry`=22303;
+UPDATE `item_template` SET `armor`=144 WHERE `entry`=22304;
+UPDATE `item_template` SET `armor`=155 WHERE `entry`=22305;
+UPDATE `item_template` SET `armor`=139 WHERE `entry`=22306;
+UPDATE `item_template` SET `armor`=150 WHERE `entry`=22311;
+UPDATE `item_template` SET `armor`=108 WHERE `entry`=22313;
+UPDATE `item_template` SET `armor`=311 WHERE `entry`=22410;
+UPDATE `item_template` SET `armor`=257 WHERE `entry`=22740;
+UPDATE `item_template` SET `armor`=287 WHERE `entry`=22741;
+UPDATE `item_template` SET `armor`=200 WHERE `entry`=22747;
+UPDATE `item_template` SET `armor`=257 WHERE `entry`=22749;
+UPDATE `item_template` SET `armor`=287 WHERE `entry`=22750;
+UPDATE `item_template` SET `armor`=200 WHERE `entry`=22752;
+UPDATE `item_template` SET `armor`=166 WHERE `entry`=22856;
+UPDATE `item_template` SET `armor`=104 WHERE `entry`=22860;
+UPDATE `item_template` SET `armor`=155 WHERE `entry`=22864;
+UPDATE `item_template` SET `armor`=98 WHERE `entry`=22869;
+UPDATE `item_template` SET `armor`=98 WHERE `entry`=22870;
+UPDATE `item_template` SET `armor`=218 WHERE `entry`=22877;
+UPDATE `item_template` SET `armor`=215 WHERE `entry`=22878;
+UPDATE `item_template` SET `armor`=248 WHERE `entry`=22879;
+UPDATE `item_template` SET `armor`=225 WHERE `entry`=22880;
+UPDATE `item_template` SET `armor`=144 WHERE `entry`=22882;
+UPDATE `item_template` SET `armor`=144 WHERE `entry`=22883;
+UPDATE `item_template` SET `armor`=156 WHERE `entry`=22885;
+UPDATE `item_template` SET `armor`=156 WHERE `entry`=22886;
+UPDATE `item_template` SET `armor`=212 WHERE `entry`=22938;
+UPDATE `item_template` SET `armor`=140 WHERE `entry`=23018;
+UPDATE `item_template` SET `armor`=3994 WHERE `entry`=23043;
+UPDATE `item_template` SET `armor`=467 WHERE `entry`=23069;
+UPDATE `item_template` SET `armor`=446 WHERE `entry`=23226;
+UPDATE `item_template` SET `armor`=198 WHERE `entry`=23253;
+UPDATE `item_template` SET `armor`=206 WHERE `entry`=23254;
+UPDATE `item_template` SET `armor`=238 WHERE `entry`=23257;
+UPDATE `item_template` SET `armor`=196 WHERE `entry`=23258;
+UPDATE `item_template` SET `armor`=131 WHERE `entry`=23261;
+UPDATE `item_template` SET `armor`=115 WHERE `entry`=23262;
+UPDATE `item_template` SET `armor`=141 WHERE `entry`=23263;
+UPDATE `item_template` SET `armor`=135 WHERE `entry`=23264;
+UPDATE `item_template` SET `armor`=155 WHERE `entry`=23284;
+UPDATE `item_template` SET `armor`=166 WHERE `entry`=23285;
+UPDATE `item_template` SET `armor`=98 WHERE `entry`=23288;
+UPDATE `item_template` SET `armor`=98 WHERE `entry`=23290;
+UPDATE `item_template` SET `armor`=104 WHERE `entry`=23291;
+UPDATE `item_template` SET `armor`=218 WHERE `entry`=23294;
+UPDATE `item_template` SET `armor`=215 WHERE `entry`=23295;
+UPDATE `item_template` SET `armor`=248 WHERE `entry`=23298;
+UPDATE `item_template` SET `armor`=225 WHERE `entry`=23299;
+UPDATE `item_template` SET `armor`=144 WHERE `entry`=23302;
+UPDATE `item_template` SET `armor`=156 WHERE `entry`=23303;
+UPDATE `item_template` SET `armor`=144 WHERE `entry`=23304;
+UPDATE `item_template` SET `armor`=156 WHERE `entry`=23305;
+UPDATE `item_template` SET `armor`=198 WHERE `entry`=23308;
+UPDATE `item_template` SET `armor`=206 WHERE `entry`=23309;
+UPDATE `item_template` SET `armor`=238 WHERE `entry`=23312;
+UPDATE `item_template` SET `armor`=196 WHERE `entry`=23313;
+UPDATE `item_template` SET `armor`=131 WHERE `entry`=23316;
+UPDATE `item_template` SET `armor`=115 WHERE `entry`=23317;
+UPDATE `item_template` SET `armor`=141 WHERE `entry`=23318;
+UPDATE `item_template` SET `armor`=135 WHERE `entry`=23319;
+UPDATE `item_template` SET `armor`=943 WHERE `entry`=23517;
+UPDATE `item_template` SET `armor`=1257 WHERE `entry`=23518;
+UPDATE `item_template` SET `armor`=1284 WHERE `entry`=23519;
+UPDATE `item_template` SET `armor`=1366 WHERE `entry`=23535;
+UPDATE `item_template` SET `armor`=223 WHERE `entry`=23825;
+UPDATE `item_template` SET `armor`=349 WHERE `entry`=24258;
+UPDATE `item_template` SET `armor`=271 WHERE `entry`=24379;
+UPDATE `item_template` SET `armor`=181 WHERE `entry`=26030;
+UPDATE `item_template` SET `armor`=184 WHERE `entry`=27645;
+UPDATE `item_template` SET `armor`=284 WHERE `entry`=27648;
+UPDATE `item_template` SET `armor`=205 WHERE `entry`=27768;
+UPDATE `item_template` SET `armor`=216 WHERE `entry`=27988;
+UPDATE `item_template` SET `armor`=283 WHERE `entry`=28126;
+UPDATE `item_template` SET `armor`=356 WHERE `entry`=28127;
+UPDATE `item_template` SET `armor`=400 WHERE `entry`=28128;
+UPDATE `item_template` SET `armor`=331 WHERE `entry`=28129;
+UPDATE `item_template` SET `armor`=429 WHERE `entry`=28130;
+UPDATE `item_template` SET `armor`=283 WHERE `entry`=28136;
+UPDATE `item_template` SET `armor`=356 WHERE `entry`=28137;
+UPDATE `item_template` SET `armor`=400 WHERE `entry`=28138;
+UPDATE `item_template` SET `armor`=331 WHERE `entry`=28139;
+UPDATE `item_template` SET `armor`=429 WHERE `entry`=28140;
+UPDATE `item_template` SET `armor`=143 WHERE `entry`=28211;
+UPDATE `item_template` SET `armor`=390 WHERE `entry`=28256;
+UPDATE `item_template` SET `armor`=234 WHERE `entry`=28301;
+UPDATE `item_template` SET `armor`=259 WHERE `entry`=28443;
+UPDATE `item_template` SET `armor`=307 WHERE `entry`=28444;
+UPDATE `item_template` SET `armor`=213 WHERE `entry`=28445;
+UPDATE `item_template` SET `armor`=259 WHERE `entry`=28446;
+UPDATE `item_template` SET `armor`=307 WHERE `entry`=28447;
+UPDATE `item_template` SET `armor`=187 WHERE `entry`=28448;
+UPDATE `item_template` SET `armor`=248 WHERE `entry`=28574;
+UPDATE `item_template` SET `armor`=248 WHERE `entry`=28575;
+UPDATE `item_template` SET `armor`=213 WHERE `entry`=28618;
+UPDATE `item_template` SET `armor`=267 WHERE `entry`=28619;
+UPDATE `item_template` SET `armor`=306 WHERE `entry`=28620;
+UPDATE `item_template` SET `armor`=249 WHERE `entry`=28622;
+UPDATE `item_template` SET `armor`=322 WHERE `entry`=28623;
+UPDATE `item_template` SET `armor`=385 WHERE `entry`=28660;
+UPDATE `item_template` SET `armor`=223 WHERE `entry`=28675;
+UPDATE `item_template` SET `armor`=213 WHERE `entry`=28719;
+UPDATE `item_template` SET `armor`=267 WHERE `entry`=28720;
+UPDATE `item_template` SET `armor`=306 WHERE `entry`=28721;
+UPDATE `item_template` SET `armor`=249 WHERE `entry`=28722;
+UPDATE `item_template` SET `armor`=322 WHERE `entry`=28723;
+UPDATE `item_template` SET `armor`=213 WHERE `entry`=28811;
+UPDATE `item_template` SET `armor`=267 WHERE `entry`=28812;
+UPDATE `item_template` SET `armor`=306 WHERE `entry`=28813;
+UPDATE `item_template` SET `armor`=249 WHERE `entry`=28814;
+UPDATE `item_template` SET `armor`=322 WHERE `entry`=28815;
+UPDATE `item_template` SET `armor`=213 WHERE `entry`=28871;
+UPDATE `item_template` SET `armor`=267 WHERE `entry`=28872;
+UPDATE `item_template` SET `armor`=306 WHERE `entry`=28873;
+UPDATE `item_template` SET `armor`=249 WHERE `entry`=28874;
+UPDATE `item_template` SET `armor`=322 WHERE `entry`=28875;
+UPDATE `item_template` SET `armor`=259 WHERE `entry`=28976;
+UPDATE `item_template` SET `armor`=307 WHERE `entry`=28977;
+UPDATE `item_template` SET `armor`=213 WHERE `entry`=28978;
+UPDATE `item_template` SET `armor`=259 WHERE `entry`=29004;
+UPDATE `item_template` SET `armor`=307 WHERE `entry`=29005;
+UPDATE `item_template` SET `armor`=187 WHERE `entry`=29006;
+UPDATE `item_template` SET `armor`=294 WHERE `entry`=29276;
+UPDATE `item_template` SET `armor`=350 WHERE `entry`=29277;
+UPDATE `item_template` SET `armor`=371 WHERE `entry`=29278;
+UPDATE `item_template` SET `armor`=392 WHERE `entry`=29279;
+UPDATE `item_template` SET `armor`=294 WHERE `entry`=29384;
+UPDATE `item_template` SET `armor`=267 WHERE `entry`=29385;
+UPDATE `item_template` SET `armor`=393 WHERE `entry`=29607;
+UPDATE `item_template` SET `armor`=262 WHERE `entry`=29777;
+UPDATE `item_template` SET `armor`=489 WHERE `entry`=30069;
+UPDATE `item_template` SET `armor`=257 WHERE `entry`=30931;
+UPDATE `item_template` SET `armor`=195 WHERE `entry`=30932;
+UPDATE `item_template` SET `armor`=283 WHERE `entry`=31375;
+UPDATE `item_template` SET `armor`=356 WHERE `entry`=31376;
+UPDATE `item_template` SET `armor`=400 WHERE `entry`=31377;
+UPDATE `item_template` SET `armor`=331 WHERE `entry`=31378;
+UPDATE `item_template` SET `armor`=429 WHERE `entry`=31379;
+UPDATE `item_template` SET `armor`=213 WHERE `entry`=31584;
+UPDATE `item_template` SET `armor`=267 WHERE `entry`=31585;
+UPDATE `item_template` SET `armor`=306 WHERE `entry`=31586;
+UPDATE `item_template` SET `armor`=249 WHERE `entry`=31587;
+UPDATE `item_template` SET `armor`=322 WHERE `entry`=31588;
+UPDATE `item_template` SET `armor`=213 WHERE `entry`=31589;
+UPDATE `item_template` SET `armor`=267 WHERE `entry`=31590;
+UPDATE `item_template` SET `armor`=306 WHERE `entry`=31591;
+UPDATE `item_template` SET `armor`=249 WHERE `entry`=31592;
+UPDATE `item_template` SET `armor`=322 WHERE `entry`=31593;
+UPDATE `item_template` SET `armor`=259 WHERE `entry`=31594;
+UPDATE `item_template` SET `armor`=307 WHERE `entry`=31595;
+UPDATE `item_template` SET `armor`=259 WHERE `entry`=31596;
+UPDATE `item_template` SET `armor`=307 WHERE `entry`=31597;
+UPDATE `item_template` SET `armor`=187 WHERE `entry`=31598;
+UPDATE `item_template` SET `armor`=187 WHERE `entry`=31599;
+UPDATE `item_template` SET `armor`=324 WHERE `entry`=31967;
+UPDATE `item_template` SET `armor`=404 WHERE `entry`=31968;
+UPDATE `item_template` SET `armor`=417 WHERE `entry`=31969;
+UPDATE `item_template` SET `armor`=377 WHERE `entry`=31971;
+UPDATE `item_template` SET `armor`=498 WHERE `entry`=31972;
+UPDATE `item_template` SET `armor`=283 WHERE `entry`=31973;
+UPDATE `item_template` SET `armor`=395 WHERE `entry`=31974;
+UPDATE `item_template` SET `armor`=410 WHERE `entry`=31975;
+UPDATE `item_template` SET `armor`=311 WHERE `entry`=31976;
+UPDATE `item_template` SET `armor`=438 WHERE `entry`=31977;
+UPDATE `item_template` SET `armor`=311 WHERE `entry`=31979;
+UPDATE `item_template` SET `armor`=395 WHERE `entry`=31980;
+UPDATE `item_template` SET `armor`=283 WHERE `entry`=31981;
+UPDATE `item_template` SET `armor`=438 WHERE `entry`=31982;
+UPDATE `item_template` SET `armor`=410 WHERE `entry`=31983;
+UPDATE `item_template` SET `armor`=310 WHERE `entry`=31987;
+UPDATE `item_template` SET `armor`=390 WHERE `entry`=31988;
+UPDATE `item_template` SET `armor`=417 WHERE `entry`=31989;
+UPDATE `item_template` SET `armor`=377 WHERE `entry`=31990;
+UPDATE `item_template` SET `armor`=470 WHERE `entry`=31991;
+UPDATE `item_template` SET `armor`=283 WHERE `entry`=32015;
+UPDATE `item_template` SET `armor`=395 WHERE `entry`=32016;
+UPDATE `item_template` SET `armor`=410 WHERE `entry`=32017;
+UPDATE `item_template` SET `armor`=311 WHERE `entry`=32018;
+UPDATE `item_template` SET `armor`=438 WHERE `entry`=32019;
+UPDATE `item_template` SET `armor`=283 WHERE `entry`=32034;
+UPDATE `item_template` SET `armor`=395 WHERE `entry`=32035;
+UPDATE `item_template` SET `armor`=410 WHERE `entry`=32036;
+UPDATE `item_template` SET `armor`=311 WHERE `entry`=32037;
+UPDATE `item_template` SET `armor`=438 WHERE `entry`=32038;
+UPDATE `item_template` SET `armor`=310 WHERE `entry`=32056;
+UPDATE `item_template` SET `armor`=390 WHERE `entry`=32057;
+UPDATE `item_template` SET `armor`=431 WHERE `entry`=32058;
+UPDATE `item_template` SET `armor`=363 WHERE `entry`=32059;
+UPDATE `item_template` SET `armor`=470 WHERE `entry`=32060;
+UPDATE `item_template` SET `armor`=336 WHERE `entry`=32786;
+UPDATE `item_template` SET `armor`=336 WHERE `entry`=32788;
+UPDATE `item_template` SET `armor`=336 WHERE `entry`=32796;
+UPDATE `item_template` SET `armor`=283 WHERE `entry`=32798;
+UPDATE `item_template` SET `armor`=283 WHERE `entry`=32800;
+UPDATE `item_template` SET `armor`=283 WHERE `entry`=32808;
+UPDATE `item_template` SET `armor`=216 WHERE `entry`=32810;
+UPDATE `item_template` SET `armor`=216 WHERE `entry`=32812;
+UPDATE `item_template` SET `armor`=216 WHERE `entry`=32821;
+UPDATE `item_template` SET `armor`=295 WHERE `entry`=33054;
+UPDATE `item_template` SET `armor`=293 WHERE `entry`=33759;
+UPDATE `item_template` SET `armor`=471 WHERE `entry`=33702;
+UPDATE `item_template` SET `armor`=343 WHERE `entry`=33700;
+UPDATE `item_template` SET `armor`=409 WHERE `entry`=33677;
+UPDATE `item_template` SET `armor`=409 WHERE `entry`=33718;
+UPDATE `item_template` SET `armor`=293 WHERE `entry`=33717;
+UPDATE `item_template` SET `armor`=409 WHERE `entry`=33745;
+UPDATE `item_template` SET `armor`=443 WHERE `entry`=33673;
+UPDATE `item_template` SET `armor`=409 WHERE `entry`=33758;
+UPDATE `item_template` SET `armor`=346 WHERE `entry`=33593;
+UPDATE `item_template` SET `armor`=424 WHERE `entry`=33761;
+UPDATE `item_template` SET `armor`=329 WHERE `entry`=33690;
+UPDATE `item_template` SET `armor`=293 WHERE `entry`=33676;
+UPDATE `item_template` SET `armor`=529 WHERE `entry`=33675;
+UPDATE `item_template` SET `armor`=454 WHERE `entry`=33680;
+UPDATE `item_template` SET `armor`=443 WHERE `entry`=33701;
+UPDATE `item_template` SET `armor`=238 WHERE `entry`=33914;
+UPDATE `item_template` SET `armor`=173 WHERE `entry`=33913;
+UPDATE `item_template` SET `armor`=454 WHERE `entry`=33721;
+UPDATE `item_template` SET `armor`=208 WHERE `entry`=33900;
+UPDATE `item_template` SET `armor`=454 WHERE `entry`=33760;
+UPDATE `item_template` SET `armor`=529 WHERE `entry`=33704;
+UPDATE `item_template` SET `armor`=409 WHERE `entry`=33683;
+UPDATE `item_template` SET `armor`=238 WHERE `entry`=33884;
+UPDATE `item_template` SET `armor`=208 WHERE `entry`=33912;
+UPDATE `item_template` SET `armor`=293 WHERE `entry`=33684;
+UPDATE `item_template` SET `armor`=173 WHERE `entry`=33901;
+UPDATE `item_template` SET `armor`=424 WHERE `entry`=33678;
+UPDATE `item_template` SET `armor`=208 WHERE `entry`=33882;
+UPDATE `item_template` SET `armor`=173 WHERE `entry`=33883;
+UPDATE `item_template` SET `armor`=293 WHERE `entry`=33744;
+UPDATE `item_template` SET `armor`=300 WHERE `entry`=33879;
+UPDATE `item_template` SET `armor`=343 WHERE `entry`=33671;
+UPDATE `item_template` SET `armor`=415 WHERE `entry`=33691;
+UPDATE `item_template` SET `armor`=501 WHERE `entry`=33694;
+UPDATE `item_template` SET `armor`=300 WHERE `entry`=33885;
+UPDATE `item_template` SET `armor`=357 WHERE `entry`=33886;
+UPDATE `item_template` SET `armor`=236 WHERE `entry`=33887;
+UPDATE `item_template` SET `armor`=238 WHERE `entry`=33902;
+UPDATE `item_template` SET `armor`=429 WHERE `entry`=33672;
+UPDATE `item_template` SET `armor`=236 WHERE `entry`=33881;
+UPDATE `item_template` SET `armor`=424 WHERE `entry`=33686;
+UPDATE `item_template` SET `armor`=454 WHERE `entry`=33685;
+UPDATE `item_template` SET `armor`=443 WHERE `entry`=33692;
+UPDATE `item_template` SET `armor`=424 WHERE `entry`=33719;
+UPDATE `item_template` SET `armor`=454 WHERE `entry`=33748;
+UPDATE `item_template` SET `armor`=357 WHERE `entry`=33880;
+UPDATE `item_template` SET `armor`=236 WHERE `entry`=33917;
+UPDATE `item_template` SET `armor`=329 WHERE `entry`=33767;
+UPDATE `item_template` SET `armor`=457 WHERE `entry`=33769;
+UPDATE `item_template` SET `armor`=357 WHERE `entry`=33916;
+UPDATE `item_template` SET `armor`=415 WHERE `entry`=33768;
+UPDATE `item_template` SET `armor`=501 WHERE `entry`=33771;
+UPDATE `item_template` SET `armor`=300 WHERE `entry`=33915;
+UPDATE `item_template` SET `armor`=424 WHERE `entry`=33746;
+UPDATE `item_template` SET `armor`=323 WHERE `entry`=33679;
+UPDATE `item_template` SET `armor`=323 WHERE `entry`=33682;
+UPDATE `item_template` SET `armor`=400 WHERE `entry`=33693;
+UPDATE `item_template` SET `armor`=400 WHERE `entry`=33674;
+UPDATE `item_template` SET `armor`=386 WHERE `entry`=33770;
+UPDATE `item_template` SET `armor`=323 WHERE `entry`=33747;
+UPDATE `item_template` SET `armor`=323 WHERE `entry`=33720;
+UPDATE `item_template` SET `armor`=400 WHERE `entry`=33703;
+UPDATE `item_template` SET `armor`=323 WHERE `entry`=33757;
+UPDATE `item_template` SET `armor`=252 WHERE `entry`=34706;
+UPDATE `item_template` SET `armor`=387 WHERE `entry`=34810;
+UPDATE `item_template` SET `armor`=392 WHERE `entry`=34888;
+UPDATE `item_template` SET `armor`=213 WHERE `entry`=35356;
+UPDATE `item_template` SET `armor`=267 WHERE `entry`=35357;
+UPDATE `item_template` SET `armor`=306 WHERE `entry`=35358;
+UPDATE `item_template` SET `armor`=249 WHERE `entry`=35359;
+UPDATE `item_template` SET `armor`=322 WHERE `entry`=35360;
+UPDATE `item_template` SET `armor`=213 WHERE `entry`=35361;
+UPDATE `item_template` SET `armor`=267 WHERE `entry`=35362;
+UPDATE `item_template` SET `armor`=306 WHERE `entry`=35363;
+UPDATE `item_template` SET `armor`=249 WHERE `entry`=35364;
+UPDATE `item_template` SET `armor`=322 WHERE `entry`=35365;
+UPDATE `item_template` SET `armor`=213 WHERE `entry`=35371;
+UPDATE `item_template` SET `armor`=267 WHERE `entry`=35372;
+UPDATE `item_template` SET `armor`=306 WHERE `entry`=35373;
+UPDATE `item_template` SET `armor`=249 WHERE `entry`=35374;
+UPDATE `item_template` SET `armor`=322 WHERE `entry`=35375;
+UPDATE `item_template` SET `armor`=322 WHERE `entry`=35469;
+UPDATE `item_template` SET `armor`=249 WHERE `entry`=35470;
+UPDATE `item_template` SET `armor`=213 WHERE `entry`=35471;
+UPDATE `item_template` SET `armor`=308 WHERE `entry`=34213;
+UPDATE `item_template` SET `armor`=306 WHERE `entry`=35003;
+UPDATE `item_template` SET `armor`=354 WHERE `entry`=35022;
+UPDATE `item_template` SET `armor`=478 WHERE `entry`=35024;
+UPDATE `item_template` SET `armor`=430 WHERE `entry`=35025;
+UPDATE `item_template` SET `armor`=541 WHERE `entry`=35026;
+UPDATE `item_template` SET `armor`=447 WHERE `entry`=35023;
+UPDATE `item_template` SET `armor`=430 WHERE `entry`=35001;
+UPDATE `item_template` SET `armor`=569 WHERE `entry`=35002;
+UPDATE `item_template` SET `armor`=461 WHERE `entry`=34999;
+UPDATE `item_template` SET `armor`=368 WHERE `entry`=34998;
+UPDATE `item_template` SET `armor`=478 WHERE `entry`=35000;
+UPDATE `item_template` SET `armor`=416 WHERE `entry`=35114;
+UPDATE `item_template` SET `armor`=541 WHERE `entry`=35115;
+UPDATE `item_template` SET `armor`=447 WHERE `entry`=35112;
+UPDATE `item_template` SET `armor`=354 WHERE `entry`=35111;
+UPDATE `item_template` SET `armor`=492 WHERE `entry`=35113;
+UPDATE `item_template` SET `armor`=476 WHERE `entry`=35099;
+UPDATE `item_template` SET `armor`=442 WHERE `entry`=35100;
+UPDATE `item_template` SET `armor`=306 WHERE `entry`=35098;
+UPDATE `item_template` SET `armor`=339 WHERE `entry`=35096;
+UPDATE `item_template` SET `armor`=426 WHERE `entry`=35097;
+UPDATE `item_template` SET `armor`=368 WHERE `entry`=35032;
+UPDATE `item_template` SET `armor`=569 WHERE `entry`=35036;
+UPDATE `item_template` SET `armor`=475 WHERE `entry`=35033;
+UPDATE `item_template` SET `armor`=430 WHERE `entry`=35035;
+UPDATE `item_template` SET `armor`=506 WHERE `entry`=35034;
+UPDATE `item_template` SET `armor`=442 WHERE `entry`=35005;
+UPDATE `item_template` SET `armor`=476 WHERE `entry`=35007;
+UPDATE `item_template` SET `armor`=339 WHERE `entry`=35006;
+UPDATE `item_template` SET `armor`=426 WHERE `entry`=35004;
+UPDATE `item_template` SET `armor`=339 WHERE `entry`=35009;
+UPDATE `item_template` SET `armor`=306 WHERE `entry`=35011;
+UPDATE `item_template` SET `armor`=476 WHERE `entry`=35012;
+UPDATE `item_template` SET `armor`=426 WHERE `entry`=35010;
+UPDATE `item_template` SET `armor`=442 WHERE `entry`=35013;
+UPDATE `item_template` SET `armor`=219 WHERE `entry`=35153;
+UPDATE `item_template` SET `armor`=219 WHERE `entry`=35159;
+UPDATE `item_template` SET `armor`=306 WHERE `entry`=35053;
+UPDATE `item_template` SET `armor`=219 WHERE `entry`=35164;
+UPDATE `item_template` SET `armor`=322 WHERE `entry`=35165;
+UPDATE `item_template` SET `armor`=322 WHERE `entry`=35152;
+UPDATE `item_template` SET `armor`=253 WHERE `entry`=35167;
+UPDATE `item_template` SET `armor`=322 WHERE `entry`=35154;
+UPDATE `item_template` SET `armor`=183 WHERE `entry`=35168;
+UPDATE `item_template` SET `armor`=183 WHERE `entry`=35174;
+UPDATE `item_template` SET `armor`=442 WHERE `entry`=35055;
+UPDATE `item_template` SET `armor`=183 WHERE `entry`=35179;
+UPDATE `item_template` SET `armor`=385 WHERE `entry`=35139;
+UPDATE `item_template` SET `armor`=253 WHERE `entry`=35169;
+UPDATE `item_template` SET `armor`=476 WHERE `entry`=35057;
+UPDATE `item_template` SET `armor`=426 WHERE `entry`=35054;
+UPDATE `item_template` SET `armor`=442 WHERE `entry`=35085;
+UPDATE `item_template` SET `armor`=476 WHERE `entry`=35087;
+UPDATE `item_template` SET `armor`=339 WHERE `entry`=35086;
+UPDATE `item_template` SET `armor`=426 WHERE `entry`=35084;
+UPDATE `item_template` SET `armor`=306 WHERE `entry`=35083;
+UPDATE `item_template` SET `armor`=339 WHERE `entry`=35056;
+UPDATE `item_template` SET `armor`=253 WHERE `entry`=35149;
+UPDATE `item_template` SET `armor`=253 WHERE `entry`=35180;
+UPDATE `item_template` SET `armor`=385 WHERE `entry`=35150;
+UPDATE `item_template` SET `armor`=385 WHERE `entry`=35137;
+UPDATE `item_template` SET `armor`=253 WHERE `entry`=35138;
+UPDATE `item_template` SET `armor`=253 WHERE `entry`=35144;
+UPDATE `item_template` SET `armor`=170 WHERE `entry`=6733;
+UPDATE `item_template` SET `armor`=605 WHERE `entry`=15141;
+UPDATE `item_template` SET `armor`=504 WHERE `entry`=37084;
+UPDATE `item_template` SET `armor`=486 WHERE `entry`=39225;
+UPDATE `item_template` SET `armor`=490 WHERE `entry`=40252;
+UPDATE `item_template` SET `armor`=1788 WHERE `entry`=41190;
+UPDATE `item_template` SET `armor`=337 WHERE `entry`=41238;
+UPDATE `item_template` SET `armor`=1438 WHERE `entry`=42826;
+UPDATE `item_template` SET `armor`=2880 WHERE `entry`=45267;
+UPDATE `item_template` SET `armor`=3500 WHERE `entry`=49904;
+UPDATE `item_template` SET `armor`=737 WHERE `entry`=50466;
+UPDATE `item_template` SET `armor`=1735 WHERE `entry`=50802;
+UPDATE `item_template` SET `armor`=2461 WHERE `entry`=50849;
+UPDATE `item_template` SET `armor`=3590 WHERE `entry`=50850;
+UPDATE `item_template` SET `armor`=2461 WHERE `entry`=50856;
+UPDATE `item_template` SET `armor`=3590 WHERE `entry`=50857;
+UPDATE `item_template` SET `armor`=2461 WHERE `entry`=50863;
+UPDATE `item_template` SET `armor`=3817 WHERE `entry`=50968;
+UPDATE `item_template` SET `armor`=2658 WHERE `entry`=50978;
+UPDATE `item_template` SET `armor`=2143 WHERE `entry`=50991;
+UPDATE `item_template` SET `armor`=2658 WHERE `entry`=51172;
+UPDATE `item_template` SET `armor`=3831 WHERE `entry`=51174;
+UPDATE `item_template` SET `armor`=2658 WHERE `entry`=51217;
+UPDATE `item_template` SET `armor`=3590 WHERE `entry`=50864;
+UPDATE `item_template` SET `armor`=2658 WHERE `entry`=51132;
+UPDATE `item_template` SET `armor`=3831 WHERE `entry`=51219;
+UPDATE `item_template` SET `armor`=4100 WHERE `entry`=51220;
+UPDATE `item_template` SET `armor`=2871 WHERE `entry`=51222;
+UPDATE `item_template` SET `armor`=3831 WHERE `entry`=51134;
+UPDATE `item_template` SET `armor`=4100 WHERE `entry`=51265;
+UPDATE `item_template` SET `armor`=2871 WHERE `entry`=51267;
+UPDATE `item_template` SET `armor`=4100 WHERE `entry`=51305;
+UPDATE `item_template` SET `armor`=2871 WHERE `entry`=51307;
+UPDATE `item_template` SET `armor`=1869 WHERE `entry`=51901;
+UPDATE `item_template` SET `armor`=649 WHERE `entry`=54801;
+UPDATE `item_template` SET `armor`=283 WHERE `entry`=42680;
+UPDATE `item_template` SET `armor`=356 WHERE `entry`=42681;
+UPDATE `item_template` SET `armor`=400 WHERE `entry`=42682;
+UPDATE `item_template` SET `armor`=331 WHERE `entry`=42683;
+UPDATE `item_template` SET `armor`=429 WHERE `entry`=42684;
+UPDATE `item_template` SET `armor`=283 WHERE `entry`=42685;
+UPDATE `item_template` SET `armor`=356 WHERE `entry`=42686;
+UPDATE `item_template` SET `armor`=400 WHERE `entry`=42687;
+UPDATE `item_template` SET `armor`=331 WHERE `entry`=42688;
+UPDATE `item_template` SET `armor`=429 WHERE `entry`=42689;
diff --git a/src/server/game/Entities/Player/Player.cpp b/src/server/game/Entities/Player/Player.cpp
index 66e37a2e10f..a762cf18ffe 100644
--- a/src/server/game/Entities/Player/Player.cpp
+++ b/src/server/game/Entities/Player/Player.cpp
@@ -7957,8 +7957,12 @@ void Player::_ApplyItemBonuses(ItemTemplate const* proto, uint8 slot, bool apply
     // If set ScalingStatValue armor get it or use item armor
     uint32 armor = proto->Armor;
     if (ssv)
+    {
         if (uint32 ssvarmor = ssv->getArmorMod(proto->ScalingStatValue))
             armor = ssvarmor;
+    }
+    else if (armor && proto->ArmorDamageModifier)
+        armor -= uint32(proto->ArmorDamageModifier);
 
     if (armor)
     {
diff --git a/src/server/game/Handlers/ItemHandler.cpp b/src/server/game/Handlers/ItemHandler.cpp
index 712b1f5f25a..77d44dffd1b 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 ? pProto->Armor + uint32(pProto->ArmorDamageModifier) : 0);
+        data << pProto->Armor;
         data << pProto->HolyRes;
         data << pProto->FireRes;
         data << pProto->NatureRes;