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