From 7fea285aead434e5db01f3730fa964e5c607d4c3 Mon Sep 17 00:00:00 2001 From: Vincent_Michael Date: Sun, 30 Dec 2012 17:09:55 +0100 Subject: Core/Command: Add command for near creature finding --- sql/updates/world/2012_12_30_01_world_trinity_string.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 sql/updates/world/2012_12_30_01_world_trinity_string.sql (limited to 'sql') diff --git a/sql/updates/world/2012_12_30_01_world_trinity_string.sql b/sql/updates/world/2012_12_30_01_world_trinity_string.sql new file mode 100644 index 00000000000..ce0578168f4 --- /dev/null +++ b/sql/updates/world/2012_12_30_01_world_trinity_string.sql @@ -0,0 +1,3 @@ +DELETE FROM `trinity_string` WHERE `entry`=556; +INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES +(556, 'Found near creatures (distance %f): %u ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); -- cgit v1.2.3 From 431b80727545484222f76a593bd0c7e62609d568 Mon Sep 17 00:00:00 2001 From: Gacko Date: Tue, 1 Jan 2013 19:41:25 +0100 Subject: Core/Player: Fix armor calculation Base armor value from WDB data includes the ArmorDamageModifier. Items of same item level, required level, armor type and equiptment slot should have (nearly) the same armor values. See following links for further proofs: http://pastebin.com/fqNJLYj4 http://www.wowhead.com/item=50466#comments:id=889035:reply=444786 The shown item should have a base armor value of 177 as similar items and a bonus armor value of 560 which equals 737 - like in DB atm. --- sql/updates/world/2013_01_01_00_item_template.sql | 646 ++++++++++++++++++++++ src/server/game/Handlers/ItemHandler.cpp | 2 +- 2 files changed, 647 insertions(+), 1 deletion(-) create mode 100644 sql/updates/world/2013_01_01_00_item_template.sql (limited to 'sql') 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; -- cgit v1.2.3 From 87368cab45b82e0931045e2f5de9009d7075b58c Mon Sep 17 00:00:00 2001 From: Gacko Date: Tue, 1 Jan 2013 21:17:48 +0100 Subject: Partially revert last commit - fix on ItemHandler coming soon --- sql/updates/world/2013_01_01_00_item_template.sql | 646 ---------------------- 1 file changed, 646 deletions(-) delete mode 100644 sql/updates/world/2013_01_01_00_item_template.sql (limited to 'sql') diff --git a/sql/updates/world/2013_01_01_00_item_template.sql b/sql/updates/world/2013_01_01_00_item_template.sql deleted file mode 100644 index aac98a7a089..00000000000 --- a/sql/updates/world/2013_01_01_00_item_template.sql +++ /dev/null @@ -1,646 +0,0 @@ -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; -- cgit v1.2.3 From 01b705c84422902201a9ae51b1fb457f9f53d601 Mon Sep 17 00:00:00 2001 From: Gacko Date: Tue, 1 Jan 2013 21:43:17 +0100 Subject: 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. --- .../world/2013_01_01_00_item_template_restore.sql | 646 +++++++++++++++++++++ src/server/game/Entities/Player/Player.cpp | 4 + src/server/game/Handlers/ItemHandler.cpp | 2 +- 3 files changed, 651 insertions(+), 1 deletion(-) create mode 100644 sql/updates/world/2013_01_01_00_item_template_restore.sql (limited to 'sql') 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; -- cgit v1.2.3 From f7e7f5fe26cca68f51e9ad9869f057ebbe191d32 Mon Sep 17 00:00:00 2001 From: Malcrom Date: Tue, 1 Jan 2013 21:36:21 -0330 Subject: CORE/Scripting: Move Commander Sarannis & Thorngrin the Tender to cpp scripting. Add instance script. Thanks to Vincent Micheal for the help :) --- .../world/2013_01_01_01_world_creature_text.sql | 30 ++++ src/server/game/Scripting/ScriptLoader.cpp | 3 + src/server/scripts/Outland/CMakeLists.txt | 4 + .../botanica/boss_commander_sarannis.cpp | 138 +++++++++++++++++ .../botanica/boss_high_botanist_freywinn.cpp | 6 +- .../Outland/TempestKeep/botanica/boss_laj.cpp | 6 +- .../TempestKeep/botanica/boss_warp_splinter.cpp | 6 +- .../Outland/TempestKeep/botanica/the_botanica.cpp | 164 +++++++++++++++++++++ .../Outland/TempestKeep/botanica/the_botanica.h | 42 ++++++ .../TempestKeep/botanica/thorngrin_the_tender.cpp | 150 +++++++++++++++++++ 10 files changed, 540 insertions(+), 9 deletions(-) create mode 100644 sql/updates/world/2013_01_01_01_world_creature_text.sql create mode 100644 src/server/scripts/Outland/TempestKeep/botanica/boss_commander_sarannis.cpp create mode 100644 src/server/scripts/Outland/TempestKeep/botanica/the_botanica.cpp create mode 100644 src/server/scripts/Outland/TempestKeep/botanica/the_botanica.h create mode 100644 src/server/scripts/Outland/TempestKeep/botanica/thorngrin_the_tender.cpp (limited to 'sql') diff --git a/sql/updates/world/2013_01_01_01_world_creature_text.sql b/sql/updates/world/2013_01_01_01_world_creature_text.sql new file mode 100644 index 00000000000..9b7a0e2a240 --- /dev/null +++ b/sql/updates/world/2013_01_01_01_world_creature_text.sql @@ -0,0 +1,30 @@ +-- NPC talk text convert from creature_ai_text. Moving boss to cpp. +UPDATE `creature_template` SET `AIName`= '', `ScriptName`= 'boss_commander_sarannis' WHERE entry`=17976; +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=17976; +DELETE FROM `creature_ai_texts` WHERE `entry` BETWEEN -39 AND -34; +DELETE FROM `creature_text` WHERE `entry` IN (17976); +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(17976,0,0, 'Step forward! I will see that you are properly welcomed.',14,0,100,0,0,11071, 'Commander Sarannis - On Aggro Say'), +(17976,1,0, 'Oh stop your whimpering.',14,0,100,0,0,11072, 'Commander Sarannis - On Player Death Say'), +(17976,1,1, 'Mission accomplished.',14,0,100,0,0,11073, 'Commander Sarannis - On Player Death Say'), +(17976,2,0, 'You are no longer dealing with some underling.',14,0,100,0,0,11076, 'Commander Sarannis - On Cast Arcane Resonance Say'), +(17976,3,0, 'Band''or shorel''aran!',14,0,100,0,0,11077, 'Commander Sarannis - On Cast Arcane Devastation Say'), +(17976,4,0, '%s calls for reinforcements.',16,0,100,0,0,0, 'Commander Sarannis - On HP@50% Summon emote'), +(17976,5,0, 'Guards! Come and kill these intruders!',14,0,100,0,0,11078, 'Commander Sarannis - On HP@50% Summon Say'), +(17976,6,0, 'I have not yet... begun to...',14,0,100,0,0,11079, 'Commander Sarannis - On Death Say'); + +-- NPC talk text convert from creature_ai_text. Moving boss to cpp. +UPDATE `creature_template` SET `AIName`= '', `ScriptName`= 'thorngrin_the_tender' WHERE entry`=17978; +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=17978; +DELETE FROM `creature_ai_texts` WHERE entry BETWEEN -16 AND -9; +DELETE FROM `creature_text` WHERE `entry` IN (17978); +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(17978,0,0, 'What aggravation is this? You will die!',14,0,100,0,0,11205, 'Thorngrin the Tender - Aggro Say'), +(17978,1,0, 'You seek a prize, eh? How about death?',14,0,100,0,0,11206, 'Thorngrin the Tender - 20% Health Say'), +(17978,2,0, 'I hate to say I told you so...',14,0,100,0,0,11207, 'Thorngrin the Tender - Player Death Say'), +(17978,3,0, 'Your life will be mine!',14,0,100,0,0,11208, 'Thorngrin the Tender - Cast Sacrifice Say'), +(17978,4,0, 'I revel in your pain!',14,0,100,0,0,11209, 'Thorngrin the Tender - 50% Health Say'), +(17978,5,0, 'I''ll incinerate you!',14,0,100,0,0,11210, 'Thorngrin the Tender - Cast Hellfire Say'), +(17978,5,1, 'Scream while you burn!',14,0,100,0,0,11211, 'Thorngrin the Tender - Cast Hellfire Say'), +(17978,6,0, 'You won''t... get far.',14,0,100,0,0,11212, 'Thorngrin the Tender - On Death Say'), +(17978,7,0, '%s becomes enraged!',16,0,100,0,0,0, 'Thorngrin the Tender - On Enrage Say'); diff --git a/src/server/game/Scripting/ScriptLoader.cpp b/src/server/game/Scripting/ScriptLoader.cpp index 31e3adb976a..540f1948c9b 100644 --- a/src/server/game/Scripting/ScriptLoader.cpp +++ b/src/server/game/Scripting/ScriptLoader.cpp @@ -579,6 +579,9 @@ void AddSC_instance_arcatraz(); void AddSC_boss_high_botanist_freywinn(); //TK Botanica void AddSC_boss_laj(); void AddSC_boss_warp_splinter(); +void AddSC_boss_thorngrin_the_tender(); +void AddSC_boss_commander_sarannis(); +void AddSC_instance_the_botanica(); void AddSC_boss_alar(); //TK The Eye void AddSC_boss_kaelthas(); void AddSC_boss_void_reaver(); diff --git a/src/server/scripts/Outland/CMakeLists.txt b/src/server/scripts/Outland/CMakeLists.txt index 9fb0d4715a0..05f329b5b1a 100644 --- a/src/server/scripts/Outland/CMakeLists.txt +++ b/src/server/scripts/Outland/CMakeLists.txt @@ -59,6 +59,10 @@ set(scripts_STAT_SRCS Outland/TempestKeep/Eye/boss_alar.cpp Outland/TempestKeep/Eye/boss_kaelthas.cpp Outland/TempestKeep/Eye/the_eye.cpp + Outland/TempestKeep/botanica/the_botanica.h + Outland/TempestKeep/botanica/the_botanica.cpp + Outland/TempestKeep/botanica/boss_commander_sarannis.cpp + Outland/TempestKeep/botanica/thorngrin_the_tender.cpp Outland/TempestKeep/botanica/boss_high_botanist_freywinn.cpp Outland/TempestKeep/botanica/boss_warp_splinter.cpp Outland/TempestKeep/botanica/boss_laj.cpp diff --git a/src/server/scripts/Outland/TempestKeep/botanica/boss_commander_sarannis.cpp b/src/server/scripts/Outland/TempestKeep/botanica/boss_commander_sarannis.cpp new file mode 100644 index 00000000000..e19d6709edc --- /dev/null +++ b/src/server/scripts/Outland/TempestKeep/botanica/boss_commander_sarannis.cpp @@ -0,0 +1,138 @@ +/* + * Copyright (C) 2008-2013 TrinityCore + * + * This program is free software; you can redistribute it and/or modify it + * under the terms of the GNU General Public License as published by the + * Free Software Foundation; either version 2 of the License, or (at your + * option) any later version. + * + * This program is distributed in the hope that it will be useful, but WITHOUT + * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or + * FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for + * more details. + * + * You should have received a copy of the GNU General Public License along + * with this program. If not, see . + */ + +#include "ScriptMgr.h" +#include "ScriptedCreature.h" + +enum Says +{ + SAY_AGGRO = 0, + SAY_KILL = 1, + SAY_ARCANE_RESONANCE = 2, + SAY_ARCANE_DEVASTATION = 3, + EMOTE_SUMMON = 4, + SAY_SUMMON = 5, + SAY_DEATH = 6 +}; + +enum Spells +{ + SPELL_ARCANE_RESONANCE = 34794, + SPELL_ARCANE_DEVASTATION = 34799, + SPELL_SUMMON_REINFORCEMENTS = 34803 +}; + +enum +{ + EVENT_ARCANE_RESONANCE = 1, + EVENT_ARCANE_DEVASTATION = 2 +}; + +class boss_commander_sarannis : public CreatureScript +{ + public: boss_commander_sarannis() : CreatureScript("boss_commander_sarannis") { } + + struct boss_commander_sarannisAI : public ScriptedAI + { + boss_commander_sarannisAI(Creature* creature) : BossAI(creature, DATA_COMMANDER_SARANNIS) { } + + void Reset() + { + _phase = true; + } + + void EnterCombat(Unit* /*who*/) + { + Talk(SAY_AGGRO); + _events.Reset(); + _events.ScheduleEvent(EVENT_ARCANE_RESONANCE, 42700); + _events.ScheduleEvent(EVENT_ARCANE_DEVASTATION, 15200); + } + + void KilledUnit(Unit* /*victim*/) + { + Talk(SAY_KILL); + } + + void JustDied(Unit* /*killer*/) + { + Talk(SAY_DEATH); + } + + void DamageTaken(Unit* /*killer*/, uint32 &damage) + { + if (me->HealthBelowPctDamaged(50, damage) && _phase) + { + _phase = false; + Talk(EMOTE_SUMMON); + Talk(SAY_SUMMON); + DoCast(me, SPELL_SUMMON_REINFORCEMENTS); + } + } + + void JustSummoned(Creature* summon) + { + ScriptedAI::JustSummoned(summon); + } + + void UpdateAI(const uint32 diff) + { + if (!UpdateVictim()) + return; + + _events.Update(diff); + + if (me->HasUnitState(UNIT_STATE_CASTING)) + return; + + while (uint32 eventId = _events.ExecuteEvent()) + { + switch (eventId) + { + case EVENT_ARCANE_RESONANCE: + Talk(SAY_ARCANE_RESONANCE); + DoCastVictim(SPELL_ARCANE_RESONANCE, true); + _events.ScheduleEvent(EVENT_ARCANE_RESONANCE, 42700); + break; + case EVENT_ARCANE_DEVASTATION: + Talk(SAY_ARCANE_DEVASTATION); + DoCastVictim(SPELL_ARCANE_DEVASTATION, true); + _events.ScheduleEvent(EVENT_ARCANE_DEVASTATION, urand(11000, 19200)); + break; + default: + break; + } + } + + DoMeleeAttackIfReady(); + } + + private: + EventMap _events; + bool _phase; + }; + + CreatureAI* GetAI(Creature* creature) const + { + return new boss_commander_sarannisAI(creature); + } +}; + +void AddSC_boss_commander_sarannis() +{ + new boss_commander_sarannis(); +} \ No newline at end of file diff --git a/src/server/scripts/Outland/TempestKeep/botanica/boss_high_botanist_freywinn.cpp b/src/server/scripts/Outland/TempestKeep/botanica/boss_high_botanist_freywinn.cpp index b3604d66d90..12e5acf4222 100644 --- a/src/server/scripts/Outland/TempestKeep/botanica/boss_high_botanist_freywinn.cpp +++ b/src/server/scripts/Outland/TempestKeep/botanica/boss_high_botanist_freywinn.cpp @@ -33,7 +33,7 @@ enum eSays SAY_TREE = 2, SAY_SUMMON = 3, SAY_DEATH = 4, - SAY_OOC_RANDOM = 5, + SAY_OOC_RANDOM = 5 }; enum eSpells @@ -44,7 +44,7 @@ enum eSpells SPELL_PLANT_WHITE = 34759, SPELL_PLANT_GREEN = 34761, SPELL_PLANT_BLUE = 34762, - SPELL_PLANT_RED = 34763, + SPELL_PLANT_RED = 34763 }; #define ENTRY_FRAYER 19953 @@ -60,7 +60,7 @@ class boss_high_botanist_freywinn : public CreatureScript struct boss_high_botanist_freywinnAI : public ScriptedAI { - boss_high_botanist_freywinnAI(Creature* creature) : ScriptedAI(creature) {} + boss_high_botanist_freywinnAI(Creature* creature) : BossAI(creature, DATA_HIGH_BOTANIST_FREYWINN) { } std::list Adds_List; diff --git a/src/server/scripts/Outland/TempestKeep/botanica/boss_laj.cpp b/src/server/scripts/Outland/TempestKeep/botanica/boss_laj.cpp index b1a894d9b48..58f5d7ade54 100644 --- a/src/server/scripts/Outland/TempestKeep/botanica/boss_laj.cpp +++ b/src/server/scripts/Outland/TempestKeep/botanica/boss_laj.cpp @@ -38,7 +38,7 @@ enum eSpells SPELL_SUMMON_LASHER_3 = 34686, SPELL_SUMMON_FLAYER_4 = 34687, SPELL_SUMMON_LASHER_4 = 34688, - SPELL_SUMMON_FLAYER_3 = 34690, + SPELL_SUMMON_FLAYER_3 = 34690 }; enum eOthers { @@ -47,7 +47,7 @@ enum eOthers MODEL_ARCANE = 14213, MODEL_FIRE = 13110, MODEL_FROST = 14112, - MODEL_NATURE = 14214, + MODEL_NATURE = 14214 }; class boss_laj : public CreatureScript @@ -61,7 +61,7 @@ class boss_laj : public CreatureScript struct boss_lajAI : public ScriptedAI { - boss_lajAI(Creature* creature) : ScriptedAI(creature) {} + boss_lajAI(Creature* creature) : BossAI(creature, DATA_LAJ) { } bool CanSummon; uint32 Teleport_Timer; diff --git a/src/server/scripts/Outland/TempestKeep/botanica/boss_warp_splinter.cpp b/src/server/scripts/Outland/TempestKeep/botanica/boss_warp_splinter.cpp index 2ca1bb28f96..131c0fcaf75 100644 --- a/src/server/scripts/Outland/TempestKeep/botanica/boss_warp_splinter.cpp +++ b/src/server/scripts/Outland/TempestKeep/botanica/boss_warp_splinter.cpp @@ -40,13 +40,13 @@ enum eSpells SUMMON_TREANTS = 34727, // DBC: 34727, 34731, 34733, 34734, 34736, 34739, 34741 (with Ancestral Life spell 34742) // won't work (guardian summon) ARCANE_VOLLEY = 36705, ARCANE_VOLLEY_H = 39133, - SPELL_HEAL_FATHER = 6262, + SPELL_HEAL_FATHER = 6262 }; enum eOthers { CREATURE_TREANT = 19949, - TREANT_SPAWN_DIST = 50, //50 yards from Warp Splinter's spawn point + TREANT_SPAWN_DIST = 50 //50 yards from Warp Splinter's spawn point }; float treant_pos[6][3] = @@ -136,7 +136,7 @@ class boss_warp_splinter : public CreatureScript } struct boss_warp_splinterAI : public ScriptedAI { - boss_warp_splinterAI(Creature* creature) : ScriptedAI(creature) + boss_warp_splinterAI(Creature* creature) : BossAI(creature, DATA_WARP_SPLINTER) { } { Treant_Spawn_Pos_X = creature->GetPositionX(); Treant_Spawn_Pos_Y = creature->GetPositionY(); diff --git a/src/server/scripts/Outland/TempestKeep/botanica/the_botanica.cpp b/src/server/scripts/Outland/TempestKeep/botanica/the_botanica.cpp new file mode 100644 index 00000000000..4fc44633345 --- /dev/null +++ b/src/server/scripts/Outland/TempestKeep/botanica/the_botanica.cpp @@ -0,0 +1,164 @@ +/* + * Copyright (C) 2008-2013 TrinityCore + * + * This program is free software; you can redistribute it and/or modify it + * under the terms of the GNU General Public License as published by the + * Free Software Foundation; either version 2 of the License, or (at your + * option) any later version. + * + * This program is distributed in the hope that it will be useful, but WITHOUT + * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or + * FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for + * more details. + * + * You should have received a copy of the GNU General Public License along + * with this program. If not, see . + */ + +#include "ScriptMgr.h" +#include "InstanceScript.h" +#include "the_botanica.h" + +class instance_the_botanica : public InstanceMapScript +{ + public: + instance_the_botanica() : InstanceMapScript("instance_the_botanica", 553) { } + + struct instance_the_botanica_InstanceMapScript : public InstanceScript + { + instance_the_botanica_InstanceMapScript(Map* map) : InstanceScript(map) + { + CommanderSarannisGUID = 0; + HighBotanistFreywinnGUID = 0; + ThorngrinTheTenderGUID = 0; + LajGUID = 0; + WarpSplinterGUID = 0; + } + + void OnCreatureCreate(Creature* creature) + { + switch (creature->GetEntry()) + { + case NPC_COMMANDER_SARANNIS: + CommanderSarannisGUID = creature->GetGUID(); + break; + case NPC_HIGH_BOTANIST_FREYWINN: + HighBotanistFreywinnGUID = creature->GetGUID(); + break; + case NPC_THORNGRIN_THE_TENDER: + ThorngrinTheTenderGUID = creature->GetGUID(); + break; + case NPC_LAJ: + LajGUID = creature->GetGUID(); + break; + case NPC_WARP_SPLINTER: + WarpSplinterGUID = creature->GetGUID(); + break; + default: + break; + } + } + + uint64 GetData64(uint32 type) const + { + switch (type) + { + case DATA_COMMANDER_SARANNIS: + return CommanderSarannisGUID; + case DATA_HIGH_BOTANIST_FREYWINN: + return HighBotanistFreywinnGUID; + case DATA_THORNGRIN_THE_TENDER: + return ThorngrinTheTenderGUID; + case DATA_LAJ: + return LajGUID; + case DATA_WARP_SPLINTER: + return WarpSplinterGUID; + default: + break; + } + + return 0; + } + + bool SetBossState(uint32 type, EncounterState state) + { + if (!InstanceScript::SetBossState(type, state)) + return false; + + switch (type) + { + case DATA_COMMANDER_SARANNIS: + case DATA_HIGH_BOTANIST_FREYWINN: + case DATA_THORNGRIN_THE_TENDER: + case DATA_LAJ: + case DATA_WARP_SPLINTER: + break; + default: + break; + } + + return true; + } + + std::string GetSaveData() + { + OUT_SAVE_INST_DATA; + + std::ostringstream saveStream; + saveStream << "B O " << GetBossSaveData(); + + OUT_SAVE_INST_DATA_COMPLETE; + return saveStream.str(); + } + + void Load(char const* str) + { + if (!str) + { + OUT_LOAD_INST_DATA_FAIL; + return; + } + + OUT_LOAD_INST_DATA(str); + + char dataHead1, dataHead2; + + std::istringstream loadStream(str); + loadStream >> dataHead1 >> dataHead2; + + if (dataHead1 == 'B' && dataHead2 == 'O') + { + for (uint8 i = 0; i < EncounterCount; ++i) + { + uint32 tmpState; + loadStream >> tmpState; + if (tmpState == IN_PROGRESS || tmpState > SPECIAL) + tmpState = NOT_STARTED; + + SetBossState(i, EncounterState(tmpState)); + } + } + else + OUT_LOAD_INST_DATA_FAIL; + + OUT_LOAD_INST_DATA_COMPLETE; + } + + protected: + uint64 CommanderSarannisGUID; + uint64 HighBotanistFreywinnGUID; + uint64 ThorngrinTheTenderGUID; + uint64 LajGUID; + uint64 WarpSplinterGUID; + }; + + InstanceScript* GetInstanceScript(InstanceMap* map) const + { + return new instance_the_botanica_InstanceMapScript(map); + } +}; + +void AddSC_instance_the_botanica() +{ + new instance_the_botanica; +} \ No newline at end of file diff --git a/src/server/scripts/Outland/TempestKeep/botanica/the_botanica.h b/src/server/scripts/Outland/TempestKeep/botanica/the_botanica.h new file mode 100644 index 00000000000..e9a7f533ad2 --- /dev/null +++ b/src/server/scripts/Outland/TempestKeep/botanica/the_botanica.h @@ -0,0 +1,42 @@ +/* + * Copyright (C) 2008-2013 TrinityCore + * Copyright (C) 2006-2009 ScriptDev2 + * + * This program is free software; you can redistribute it and/or modify it + * under the terms of the GNU General Public License as published by the + * Free Software Foundation; either version 2 of the License, or (at your + * option) any later version. + * + * This program is distributed in the hope that it will be useful, but WITHOUT + * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or + * FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for + * more details. + * + * You should have received a copy of the GNU General Public License along + * with this program. If not, see . + */ + +#ifndef DEF_THE_BOTANICA_H +#define DEF_THE_BOTANICA_H + +uint32 const EncounterCount = 5; + +enum DataTypes +{ + DATA_COMMANDER_SARANNIS = 1, + DATA_HIGH_BOTANIST_FREYWINN = 2, + DATA_THORNGRIN_THE_TENDER = 3, + DATA_LAJ = 4, + DATA_WARP_SPLINTER = 5 +}; + +enum CreatureIds +{ + NPC_COMMANDER_SARANNIS = 17976, + NPC_HIGH_BOTANIST_FREYWINN = 17975, + NPC_THORNGRIN_THE_TENDER = 17978, + NPC_LAJ = 17980, + NPC_WARP_SPLINTER = 17977 +}; + +#endif \ No newline at end of file diff --git a/src/server/scripts/Outland/TempestKeep/botanica/thorngrin_the_tender.cpp b/src/server/scripts/Outland/TempestKeep/botanica/thorngrin_the_tender.cpp new file mode 100644 index 00000000000..eb1150dc169 --- /dev/null +++ b/src/server/scripts/Outland/TempestKeep/botanica/thorngrin_the_tender.cpp @@ -0,0 +1,150 @@ +/* + * Copyright (C) 2008-2013 TrinityCore + * + * This program is free software; you can redistribute it and/or modify it + * under the terms of the GNU General Public License as published by the + * Free Software Foundation; either version 2 of the License, or (at your + * option) any later version. + * + * This program is distributed in the hope that it will be useful, but WITHOUT + * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or + * FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for + * more details. + * + * You should have received a copy of the GNU General Public License along + * with this program. If not, see . + */ + +#include "ScriptMgr.h" +#include "ScriptedCreature.h" + +enum Says +{ + SAY_AGGRO = 0, + SAY_20_PERCENT_HP = 1, + SAY_KILL = 2, + SAY_CAST_SACRIFICE = 3, + SAY_50_PERCENT_HP = 4, + SAY_CAST_HELLFIRE = 5, + SAY_DEATH = 6, + EMOTE_ENRAGE = 7 +}; + +enum Spells +{ + SPELL_SACRIFICE = 34661, + SPELL_HELLFIRE_NORMAL = 34659, + SPELL_HELLFIRE_HEROIC = 39131, + SPELL_ENRAGE = 34670 +}; + +enum Events +{ + EVENT_SACRIFICE = 1, + EVENT_HELLFIRE = 2, + EVENT_ENRAGE = 3 +}; + +class boss_thorngrin_the_tender : public CreatureScript +{ + public: boss_thorngrin_the_tender() : CreatureScript("thorngrin_the_tender") { } + + struct boss_thorngrin_the_tenderAI : public BossAI + { + boss_thorngrin_the_tenderAI(Creature* creature) : BossAI(creature, DATA_THORNGRIN_THE_TENDER) { } + + void Reset() + { + _phase1 = true; + _phase2 = true; + } + + void EnterCombat(Unit* /*who*/) + { + Talk(SAY_AGGRO); + _events.Reset(); + _events.ScheduleEvent(EVENT_SACRIFICE, 5700); + _events.ScheduleEvent(EVENT_HELLFIRE, IsHeroic() ? urand(17400, 19300) : 18000); + _events.ScheduleEvent(EVENT_ENRAGE, 12000); + } + + void KilledUnit(Unit* /*victim*/) + { + Talk(SAY_KILL); + } + + void JustDied(Unit* /*killer*/) + { + Talk(SAY_DEATH); + } + + void DamageTaken(Unit* /*killer*/, uint32 &damage) + { + if (me->HealthBelowPctDamaged(50, damage) && _phase1) + { + _phase1 = false; + Talk(SAY_50_PERCENT_HP); + } + if (me->HealthBelowPctDamaged(20, damage) && _phase2) + { + _phase2 = false; + Talk(SAY_20_PERCENT_HP); + } + } + + void UpdateAI(uint32 const diff) + { + if (!UpdateVictim()) + return; + + _events.Update(diff); + + if (me->HasUnitState(UNIT_STATE_CASTING)) + return; + + while (uint32 eventId = _events.ExecuteEvent()) + { + switch (eventId) + { + case EVENT_SACRIFICE: + if (Unit* target = SelectTarget(SELECT_TARGET_RANDOM, 1, 0.0f, true)) + { + Talk(SAY_CAST_SACRIFICE); + DoCast(target, SPELL_SACRIFICE, true); + } + _events.ScheduleEvent(EVENT_SACRIFICE, 29400); + break; + case EVENT_HELLFIRE: + Talk(SAY_CAST_HELLFIRE); + DoCastVictim(DUNGEON_MODE(SPELL_HELLFIRE_NORMAL, SPELL_HELLFIRE_HEROIC), true); + _events.ScheduleEvent(EVENT_HELLFIRE, IsHeroic() ? urand(17400, 19300) : 18000); + break; + case EVENT_ENRAGE: + Talk(EMOTE_ENRAGE); + DoCast(me, SPELL_ENRAGE); + _events.ScheduleEvent(EVENT_ENRAGE, 33000); + break; + default: + break; + } + } + + DoMeleeAttackIfReady(); + } + + private: + EventMap _events; + bool _phase1; + bool _phase2; + }; + + CreatureAI* GetAI(Creature* creature) const + { + return new boss_thorngrin_the_tenderAI(creature); + } +}; + +void AddSC_boss_thorngrin_the_tender() +{ + new boss_thorngrin_the_tender(); +} \ No newline at end of file -- cgit v1.2.3 From 56096b7704885de6685cd051a555b79e8093fd75 Mon Sep 17 00:00:00 2001 From: Vincent_Michael Date: Wed, 2 Jan 2013 02:43:41 +0100 Subject: DB/Creatures: Some fix for Wyrmrest Skytalon Closes #8733 --- sql/updates/world/2013_01_02_00_world_misc.sql | 7 +++++++ src/server/scripts/Outland/TempestKeep/botanica/the_botanica.h | 10 +++++----- 2 files changed, 12 insertions(+), 5 deletions(-) create mode 100644 sql/updates/world/2013_01_02_00_world_misc.sql (limited to 'sql') diff --git a/sql/updates/world/2013_01_02_00_world_misc.sql b/sql/updates/world/2013_01_02_00_world_misc.sql new file mode 100644 index 00000000000..8527b8ab145 --- /dev/null +++ b/sql/updates/world/2013_01_02_00_world_misc.sql @@ -0,0 +1,7 @@ +DELETE FROM `creature_template_addon` WHERE `entry`=32535; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(32535, 0, 0, 0x3020400, 0x1, 0, '60534'); + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=32535; +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUE +(32535, 61245, 1, 0); diff --git a/src/server/scripts/Outland/TempestKeep/botanica/the_botanica.h b/src/server/scripts/Outland/TempestKeep/botanica/the_botanica.h index 034792ea37c..d5657dc7048 100644 --- a/src/server/scripts/Outland/TempestKeep/botanica/the_botanica.h +++ b/src/server/scripts/Outland/TempestKeep/botanica/the_botanica.h @@ -23,11 +23,11 @@ uint32 const EncounterCount = 5; enum DataTypes { - DATA_COMMANDER_SARANNIS = 1, - DATA_HIGH_BOTANIST_FREYWINN = 2, - DATA_THORNGRIN_THE_TENDER = 3, - DATA_LAJ = 4, - DATA_WARP_SPLINTER = 5 + DATA_COMMANDER_SARANNIS = 0, + DATA_HIGH_BOTANIST_FREYWINN = 1, + DATA_THORNGRIN_THE_TENDER = 2, + DATA_LAJ = 3, + DATA_WARP_SPLINTER = 4 }; enum CreatureIds -- cgit v1.2.3 From 1062a0b40f0d7000b7de5ca4df89afb94b13c40c Mon Sep 17 00:00:00 2001 From: Malcrom Date: Tue, 1 Jan 2013 22:28:29 -0330 Subject: Core/Scripts: Added spell scripting for Commander Sarannis. Added Instance Template for The Botanica. Thanks to Vincent Michael --- .../world/2013_01_02_01_world_spell_script.sql | 3 ++ .../2013_01_02_02_world_instance_template.sql | 1 + .../botanica/boss_commander_sarannis.cpp | 45 ++++++++++++++++++++++ 3 files changed, 49 insertions(+) create mode 100644 sql/updates/world/2013_01_02_01_world_spell_script.sql create mode 100644 sql/updates/world/2013_01_02_02_world_instance_template.sql (limited to 'sql') diff --git a/sql/updates/world/2013_01_02_01_world_spell_script.sql b/sql/updates/world/2013_01_02_01_world_spell_script.sql new file mode 100644 index 00000000000..a839ca6dc7b --- /dev/null +++ b/sql/updates/world/2013_01_02_01_world_spell_script.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=34803; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(34803,'spell_commander_sarannis_summon_reinforcements'); diff --git a/sql/updates/world/2013_01_02_02_world_instance_template.sql b/sql/updates/world/2013_01_02_02_world_instance_template.sql new file mode 100644 index 00000000000..f63a2c3ba2e --- /dev/null +++ b/sql/updates/world/2013_01_02_02_world_instance_template.sql @@ -0,0 +1 @@ +UPDATE `instance_template` SET `script`='instance_the_botanica' WHERE `map`=553; diff --git a/src/server/scripts/Outland/TempestKeep/botanica/boss_commander_sarannis.cpp b/src/server/scripts/Outland/TempestKeep/botanica/boss_commander_sarannis.cpp index f64276940aa..6b232a2ad17 100644 --- a/src/server/scripts/Outland/TempestKeep/botanica/boss_commander_sarannis.cpp +++ b/src/server/scripts/Outland/TempestKeep/botanica/boss_commander_sarannis.cpp @@ -18,6 +18,7 @@ #include "ScriptMgr.h" #include "ScriptedCreature.h" #include "the_botanica.h" +#include "SpellScript.h" enum Says { @@ -134,6 +135,50 @@ class boss_commander_sarannis : public CreatureScript } }; +Position const PosSummonReinforcements[4] = +{ + { 160.4483f, 287.6435f, -3.887904f, 2.3841f }, + { 153.4406f, 289.9929f, -4.736916f, 2.3841f }, + { 154.4137f, 292.8956f, -4.683603f, 2.3841f }, + { 157.1544f, 294.2599f, -4.726504f, 2.3841f } +}; + +enum Creatures +{ + NPC_SUMMONED_BLOODWARDER_MENDER = 20083, + NPC_SUMMONED_BLOODWARDER_RESERVIST = 20078 +}; + +class spell_commander_sarannis_summon_reinforcements : public SpellScriptLoader +{ + public: + spell_commander_sarannis_summon_reinforcements() : SpellScriptLoader("spell_commander_sarannis_summon_reinforcements") { } + + class spell_commander_sarannis_summon_reinforcements_SpellScript : public SpellScript + { + PrepareSpellScript(spell_commander_sarannis_summon_reinforcements_SpellScript); + + void HandleCast(SpellEffIndex /*effIndex*/) + { + GetCaster()->SummonCreature(NPC_SUMMONED_BLOODWARDER_MENDER, PosSummonReinforcements[0], TEMPSUMMON_CORPSE_DESPAWN); + GetCaster()->SummonCreature(NPC_SUMMONED_BLOODWARDER_RESERVIST, PosSummonReinforcements[1], TEMPSUMMON_CORPSE_DESPAWN); + GetCaster()->SummonCreature(NPC_SUMMONED_BLOODWARDER_RESERVIST, PosSummonReinforcements[2], TEMPSUMMON_CORPSE_DESPAWN); + if (GetCaster()->GetMap()->IsHeroic()) + GetCaster()->SummonCreature(NPC_SUMMONED_BLOODWARDER_RESERVIST, PosSummonReinforcements[3], TEMPSUMMON_CORPSE_DESPAWN); + } + + void Register() + { + OnEffectHitTarget += SpellEffectFn(spell_commander_sarannis_summon_reinforcements_SpellScript::HandleCast, EFFECT_0, SPELL_EFFECT_DUMMY); + } + }; + + SpellScript* GetSpellScript() const + { + return new spell_commander_sarannis_summon_reinforcements_SpellScript(); + } +}; + void AddSC_boss_commander_sarannis() { new boss_commander_sarannis(); -- cgit v1.2.3 From e0db317530a60c65527936c1e2b356d67fbe0137 Mon Sep 17 00:00:00 2001 From: Vincent_Michael Date: Wed, 2 Jan 2013 03:06:55 +0100 Subject: SQL: Fix sql import problem --- sql/updates/world/2013_01_01_01_world_creature_text.sql | 4 ++-- .../scripts/Outland/TempestKeep/botanica/boss_commander_sarannis.cpp | 1 + 2 files changed, 3 insertions(+), 2 deletions(-) (limited to 'sql') diff --git a/sql/updates/world/2013_01_01_01_world_creature_text.sql b/sql/updates/world/2013_01_01_01_world_creature_text.sql index 9b7a0e2a240..c0055f8e1d0 100644 --- a/sql/updates/world/2013_01_01_01_world_creature_text.sql +++ b/sql/updates/world/2013_01_01_01_world_creature_text.sql @@ -1,5 +1,5 @@ -- NPC talk text convert from creature_ai_text. Moving boss to cpp. -UPDATE `creature_template` SET `AIName`= '', `ScriptName`= 'boss_commander_sarannis' WHERE entry`=17976; +UPDATE `creature_template` SET `AIName`= '', `ScriptName`= 'boss_commander_sarannis' WHERE `entry`=17976; DELETE FROM `creature_ai_scripts` WHERE `creature_id`=17976; DELETE FROM `creature_ai_texts` WHERE `entry` BETWEEN -39 AND -34; DELETE FROM `creature_text` WHERE `entry` IN (17976); @@ -14,7 +14,7 @@ INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`pr (17976,6,0, 'I have not yet... begun to...',14,0,100,0,0,11079, 'Commander Sarannis - On Death Say'); -- NPC talk text convert from creature_ai_text. Moving boss to cpp. -UPDATE `creature_template` SET `AIName`= '', `ScriptName`= 'thorngrin_the_tender' WHERE entry`=17978; +UPDATE `creature_template` SET `AIName`= '', `ScriptName`= 'thorngrin_the_tender' WHERE `entry`=17978; DELETE FROM `creature_ai_scripts` WHERE `creature_id`=17978; DELETE FROM `creature_ai_texts` WHERE entry BETWEEN -16 AND -9; DELETE FROM `creature_text` WHERE `entry` IN (17978); diff --git a/src/server/scripts/Outland/TempestKeep/botanica/boss_commander_sarannis.cpp b/src/server/scripts/Outland/TempestKeep/botanica/boss_commander_sarannis.cpp index 6b232a2ad17..fe89925b6f9 100644 --- a/src/server/scripts/Outland/TempestKeep/botanica/boss_commander_sarannis.cpp +++ b/src/server/scripts/Outland/TempestKeep/botanica/boss_commander_sarannis.cpp @@ -182,4 +182,5 @@ class spell_commander_sarannis_summon_reinforcements : public SpellScriptLoader void AddSC_boss_commander_sarannis() { new boss_commander_sarannis(); + new spell_commander_sarannis_summon_reinforcements(); } -- cgit v1.2.3 From 438c908faa1e5a6bedbdb326e12977eec179d5af Mon Sep 17 00:00:00 2001 From: Malcrom Date: Wed, 2 Jan 2013 00:19:57 -0330 Subject: DB/SAI: Improve SAI for Summoned Bloodwarder Mender. Add SAI for Summoned Bloodwarder Reservist --- sql/updates/world/2013_01_02_03_world_sai.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 sql/updates/world/2013_01_02_03_world_sai.sql (limited to 'sql') diff --git a/sql/updates/world/2013_01_02_03_world_sai.sql b/sql/updates/world/2013_01_02_03_world_sai.sql new file mode 100644 index 00000000000..6f6318b55bd --- /dev/null +++ b/sql/updates/world/2013_01_02_03_world_sai.sql @@ -0,0 +1,18 @@ +-- Summoned Bloodwarder Mender SAI +SET @ENTRY := 20083; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,63,0,100,7,0,0,0,0,11,34815,0,0,0,0,0,1,0,0,0,0,0,0,0,'Summoned Bloodwarder Mender - Just Created - Cast Teleport Effect'), +(@ENTRY,0,1,0,0,0,100,6,5000,5000,185000,185000,11,34809,0,0,0,0,0,1,0,0,0,0,0,0,0,'Summoned Bloodwarder Mender - Combat - Cast Holy Fury'), +(@ENTRY,0,2,0,0,0,100,2,8000,8000,10000,14000,11,17194,0,0,0,0,0,2,0,0,0,0,0,0,0,'Summoned Bloodwarder Mender (Normal) - Combat - Cast Mind Blast'), +(@ENTRY,0,3,0,0,0,100,4,8000,8000,10000,14000,11,17287,0,0,0,0,0,2,0,0,0,0,0,0,0,'Summoned Bloodwarder Mender (Heroic) - Combat - Cast Mind Blast'), +(@ENTRY,0,4,0,2,0,100,7,0,30,0,0,11,35096,0,0,0,0,0,1,0,0,0,0,0,0,0,"Summoned Bloodwarder Mender - At 30% Health - Cast Greater Heal"); + +-- Summoned Bloodwarder Reservist SAI +SET @ENTRY := 20078; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,63,0,100,7,0,0,0,0,11,34815,0,0,0,0,0,1,0,0,0,0,0,0,0,'Summoned Bloodwarder Mender - Just Created - Cast Teleport Effect'), +(@ENTRY,0,1,0,0,0,100,6,4000,8000,10000,12000,11,34820,0,0,0,0,0,2,0,0,0,0,0,0,0,'Summoned Bloodwarder Mender - Combat - Cast Arcane Strike'); -- cgit v1.2.3 From 52fd561f47297f01560f6571724225fef9c5485a Mon Sep 17 00:00:00 2001 From: Vincent_Michael Date: Wed, 2 Jan 2013 05:15:53 +0100 Subject: DB/Creature: Removed "Grand Apothecary Putress" from Shattrath City Patch 3.0.3 (2008-11-04): Removed from Shattrath City. --- sql/updates/world/2013_01_02_04_world_creature.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 sql/updates/world/2013_01_02_04_world_creature.sql (limited to 'sql') diff --git a/sql/updates/world/2013_01_02_04_world_creature.sql b/sql/updates/world/2013_01_02_04_world_creature.sql new file mode 100644 index 00000000000..686909ce57e --- /dev/null +++ b/sql/updates/world/2013_01_02_04_world_creature.sql @@ -0,0 +1 @@ +DELETE FROM `creature` WHERE `id`=28318; -- Grand Apothecary Putress -- cgit v1.2.3 From 423fb042704f89770bac6a9d7456d52a7f71e972 Mon Sep 17 00:00:00 2001 From: Trista Date: Wed, 2 Jan 2013 06:34:32 +0200 Subject: Script/EoE: Some fixes here and there * Add db support for Power Sparks, Teleports and Drakes * Fix Power Sparks animations and texts and add support for giving buff to players + warning * Fix Power Spark way of stacking - should be MultiSlot aura, didn't stack before either way * Teleporters mechanic is fixed and will summon only 1 spark per 30-35 sec * Fixed players getting mounted on 3rd phase * Cleanned some wrong aggro handling, but whole aggro/attack system should be rewritten to get it working blizz That is for today, this doesn't fix the whole instance by any means! --- .../world/2013_01_02_05_eye_of_eternity.sql | 27 ++++ src/server/game/Spells/Auras/SpellAuras.cpp | 12 +- src/server/game/Spells/SpellInfo.cpp | 2 +- .../Northrend/Nexus/EyeOfEternity/boss_malygos.cpp | 142 ++++++++------------- 4 files changed, 89 insertions(+), 94 deletions(-) create mode 100644 sql/updates/world/2013_01_02_05_eye_of_eternity.sql (limited to 'sql') diff --git a/sql/updates/world/2013_01_02_05_eye_of_eternity.sql b/sql/updates/world/2013_01_02_05_eye_of_eternity.sql new file mode 100644 index 00000000000..89cc8f08cce --- /dev/null +++ b/sql/updates/world/2013_01_02_05_eye_of_eternity.sql @@ -0,0 +1,27 @@ +-- Add missing text and update old one +-- Malygos +UPDATE `creature_text` SET `probability`=100 WHERE `entry`=28859; -- Was at 0 for some reason +UPDATE `creature_text` SET `text`='Unthinkable! The mortals will destroy... everything! My sister, what have you...',`sound`=14540 WHERE `entry`=28859 AND `groupid`=14 AND `id`=0; +DELETE FROM `creature_text` WHERE `entry`=28859 AND `groupid` IN (15,16); +DELETE FROM `creature_text` WHERE `entry`=30084; +INSERT INTO `creature_text` (`entry`,`groupid`,`text`,`type`,`probability`,`sound`,`comment`) VALUES +(28859,15, '%s fixes his eyes on you!', 42,100,0, 'Malygos'), +(28859,16, 'I am without limits here. The rules of your cherished reality do not apply. In this realm, I am in control!',14,100,14515, 'Malygos'), +(30084,0, 'A Power Spark forms from a nearby rift!',41,100,14522, 'Power spark to portal'); +-- Alexstrasza, add missing sounds +UPDATE `creature_text` SET `probability`=100,`sound`=14406 WHERE `entry`=32295 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `probability`=100,`sound`=14407 WHERE `entry`=32295 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `probability`=100,`sound`=14408 WHERE `entry`=32295 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `probability`=100,`sound`=14409 WHERE `entry`=32295 AND `groupid`=3 AND `id`=0; + +-- Update portal InhabitType, otherwise it falls on summon +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry`=30118; + +-- Update drakes templates +UPDATE `creature_template` SET `unit_flags`=8,`InhabitType`=4 WHERE `entry`=30161; -- no fly aura present only enabled gravity in sniffs + +-- Addon data +DELETE FROM `creature_template_addon` WHERE `entry` IN (30084,30161); +INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(30084,0,0,50331648,1,0,'55845'), -- Power Spark +(30161,0,0,50331648,1,0,'60534'); -- Wyrmrest Skytalon (uses no fly aura) diff --git a/src/server/game/Spells/Auras/SpellAuras.cpp b/src/server/game/Spells/Auras/SpellAuras.cpp index b5cabba8929..d018747aa71 100644 --- a/src/server/game/Spells/Auras/SpellAuras.cpp +++ b/src/server/game/Spells/Auras/SpellAuras.cpp @@ -910,8 +910,16 @@ bool Aura::CanBeSaved() const // Incanter's Absorbtion - considering the minimal duration and problems with aura stacking // we skip saving this aura - if (GetId() == 44413) - return false; + // Also for some reason other auras put as MultiSlot crash core on keeping them after restart, + // so put here only these for which you are sure they get removed + switch (GetId()) + { + case 44413: // Incanter's Absorption + case 40075: // Fel Flak Fire + case 55849: // Power Spark + return false; + break; + } // don't save auras removed by proc system if (IsUsingCharges() && !GetCharges()) diff --git a/src/server/game/Spells/SpellInfo.cpp b/src/server/game/Spells/SpellInfo.cpp index 06c861bd388..a8c0ca06efe 100644 --- a/src/server/game/Spells/SpellInfo.cpp +++ b/src/server/game/Spells/SpellInfo.cpp @@ -1027,7 +1027,7 @@ bool SpellInfo::IsPassiveStackableWithRanks() const bool SpellInfo::IsMultiSlotAura() const { - return IsPassive() || Id == 40075 || Id == 44413; // No other way to make 40075 have more than 1 copy of aura + return IsPassive() || Id == 55849 || Id == 40075 || Id == 44413; // Power Spark, Fel Flak Fire, Incanter's Absorption } bool SpellInfo::IsDeathPersistent() const diff --git a/src/server/scripts/Northrend/Nexus/EyeOfEternity/boss_malygos.cpp b/src/server/scripts/Northrend/Nexus/EyeOfEternity/boss_malygos.cpp index 85414e3808c..fcbc87ad47d 100644 --- a/src/server/scripts/Northrend/Nexus/EyeOfEternity/boss_malygos.cpp +++ b/src/server/scripts/Northrend/Nexus/EyeOfEternity/boss_malygos.cpp @@ -35,10 +35,13 @@ Script Data End */ #include "eye_of_eternity.h" #include "ScriptedEscortAI.h" #include "Player.h" +#include "Vehicle.h" +#include "CombatAI.h" +#include "CreatureTextMgr.h" enum Achievements { - ACHIEV_TIMED_START_EVENT = 20387, + ACHIEV_TIMED_START_EVENT = 20387, }; enum Events @@ -132,25 +135,36 @@ enum MalygosEvents #define TEN_MINUTES 600000 -enum MalygosSays +enum Texts { - SAY_AGGRO_P_ONE, - SAY_KILLED_PLAYER_P_ONE, - SAY_END_P_ONE, - SAY_AGGRO_P_TWO, - SAY_ANTI_MAGIC_SHELL, // not sure when execute it - SAY_MAGIC_BLAST, // not sure when execute it - SAY_KILLED_PLAYER_P_TWO, - SAY_END_P_TWO, - SAY_INTRO_P_THREE, - SAY_AGGRO_P_THREE, - SAY_SURGE_POWER, // not sure when execute it - SAY_BUFF_SPARK, - SAY_KILLED_PLAYER_P_THREE, - SAY_SPELL_CASTING_P_THREE, - SAY_DEATH + // Malygos + SAY_AGGRO_P_ONE = 0, + SAY_KILLED_PLAYER_P_ONE = 1, + SAY_END_P_ONE = 2, + SAY_AGGRO_P_TWO = 3, + SAY_ANTI_MAGIC_SHELL = 4, // not sure when execute it + SAY_MAGIC_BLAST = 5, // not sure when execute it + SAY_KILLED_PLAYER_P_TWO = 6, + SAY_END_P_TWO = 7, + SAY_INTRO_P_THREE = 8, + SAY_AGGRO_P_THREE = 9, + SAY_SURGE_POWER = 10, // not sure when execute it + SAY_BUFF_SPARK = 11, + SAY_KILLED_PLAYER_P_THREE = 12, + SAY_SPELL_CASTING_P_THREE = 13, + SAY_DEATH, + + // Alexstrasza + SAY_ONE = 0, + SAY_TWO = 1, + SAY_THREE = 2, + SAY_FOUR = 3, + + // Power Sparks + EMOTE_POWER_SPARK_SUMMONED = 0 }; + #define MAX_HOVER_DISK_WAYPOINTS 18 // Sniffed data (x, y,z) @@ -178,7 +192,7 @@ const Position HoverDiskWaypoints[MAX_HOVER_DISK_WAYPOINTS] = #define GROUND_Z 268 -// Source: Sniffs (x, y,z) +// Source: Sniffs (x,y,z) #define MALYGOS_MAX_WAYPOINTS 16 const Position MalygosPhaseTwoWaypoints[MALYGOS_MAX_WAYPOINTS] = { @@ -316,6 +330,7 @@ public: // The rest is handled in the AI of the vehicle. target->CastSpell(target, SPELL_SUMMOM_RED_DRAGON, true); + me->Attack(target, false); } } @@ -748,13 +763,18 @@ public: _instance = creature->GetInstanceScript(); } - void Reset() + void SpellHit(Unit* /*caster*/, const SpellInfo* spell) { - _summonTimer = urand(5, 7)*IN_MILLISECONDS; + if (spell->Id == SPELL_PORTAL_OPENED) + { + DoCast(me, SPELL_SUMMON_POWER_PARK, true); + } } void UpdateAI(uint32 const diff) { + // When duration of oppened riff visual ends, + // closed one should be cast if (!me->HasAura(SPELL_PORTAL_VISUAL_CLOSED) && !me->HasAura(SPELL_PORTAL_OPENED)) DoCast(me, SPELL_PORTAL_VISUAL_CLOSED, true); @@ -770,16 +790,6 @@ public: } } } - - if (!me->HasAura(SPELL_PORTAL_OPENED)) - return; - - if (_summonTimer <= diff) - { - DoCast(SPELL_SUMMON_POWER_PARK); - _summonTimer = urand(5, 7)*IN_MILLISECONDS; - } else - _summonTimer -= diff; } void JustSummoned(Creature* summon) @@ -811,6 +821,8 @@ public: _instance = creature->GetInstanceScript(); MoveToMalygos(); + // Talk range was not enough for this encounter + sCreatureTextMgr->SendChat(me, EMOTE_POWER_SPARK_SUMMONED, 0, CHAT_MSG_ADDON, LANG_ADDON, TEXT_RANGE_MAP); } void EnterEvadeMode() @@ -853,14 +865,9 @@ public: } } - void DamageTaken(Unit* /*done_by*/, uint32& damage) + void JustDied(Unit* /*killer*/) { - if (damage > me->GetMaxHealth()) - { - damage = 0; - DoCast(me, SPELL_POWER_SPARK_DEATH, true); - me->DespawnOrUnsummon(1000); - } + me->CastSpell(me, SPELL_POWER_SPARK_DEATH, true); // not supposed to hide the fact it's there by not selectable } private: @@ -903,8 +910,7 @@ public: else { // Error found: This is not called if the passenger is a player - - if (unit->GetTypeId() == TYPEID_UNIT) + if (unit->GetTypeId() == TYPEID_UNIT || unit->GetTypeId() == TYPEID_PLAYER) { // This will only be called if the passenger dies if (_instance) @@ -1012,7 +1018,7 @@ public: }; }; -// SmartAI does not work correctly for this (vehicles) +// SmartAI does not work correctly for vehicles class npc_wyrmrest_skytalon : public CreatureScript { public: @@ -1023,14 +1029,13 @@ public: return new npc_wyrmrest_skytalonAI (creature); } - struct npc_wyrmrest_skytalonAI : public NullCreatureAI + struct npc_wyrmrest_skytalonAI : public VehicleAI { - npc_wyrmrest_skytalonAI(Creature* creature) : NullCreatureAI(creature) - { - _instance = creature->GetInstanceScript(); + npc_wyrmrest_skytalonAI(Creature* creature) : VehicleAI(creature) { } - _timer = 1000; - _entered = false; + void IsSummonedBy(Unit* summoner) + { + summoner->CastSpell(me, SPELL_RIDE_RED_DRAGON, true); } void PassengerBoarded(Unit* /*unit*/, int8 /*seat*/, bool apply) @@ -1038,54 +1043,9 @@ public: if (!apply) me->DespawnOrUnsummon(); } - - // we can't call this in reset function, it fails. - void MakePlayerEnter() - { - if (!_instance) - return; - - if (Unit* summoner = me->ToTempSummon()->GetSummoner()) - { - if (Creature* malygos = Unit::GetCreature(*me, _instance->GetData64(DATA_MALYGOS))) - { - summoner->CastSpell(me, SPELL_RIDE_RED_DRAGON, true); - float victimThreat = malygos->getThreatManager().getThreat(summoner); - malygos->getThreatManager().resetAllAggro(); - malygos->AI()->AttackStart(me); - malygos->AddThreat(me, victimThreat); - } - } - } - - void UpdateAI(const uint32 diff) - { - if (!_entered) - { - if (_timer <= diff) - { - MakePlayerEnter(); - _entered = true; - } else - _timer -= diff; - } - } - - private: - InstanceScript* _instance; - uint32 _timer; - bool _entered; }; }; -enum AlexstraszaYells -{ - SAY_ONE, - SAY_TWO, - SAY_THREE, - SAY_FOUR -}; - class npc_alexstrasza_eoe : public CreatureScript { public: -- cgit v1.2.3