aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/2013_01_01_00_item_template_restore.sql646
-rw-r--r--src/server/game/Entities/Player/Player.cpp4
-rw-r--r--src/server/game/Handlers/ItemHandler.cpp2
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;