Template:Query base armours/testcases

  ===Armour (Strength)===

Lua error: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'HOLDS "%normal%")) AND `cargo__items`.`_pageNamespace` IN (0,10016) GROUP BY...' at line 7 Function: CargoSQLQuery::run Query: SELECT `cargo__items`.`_pageID` AS `items._pageID`,`cargo__items`.`_pageName` AS `items._pageName`,`cargo__items`.`name` AS `items.name`,`cargo__items`.`inventory_icon` AS `items.inventory_icon`,`cargo__items`.`html` AS `items.html`,`cargo__items`.`size_x` AS `items.size_x`,`cargo__items`.`size_y` AS `items.size_y`,`cargo__items`.`required_level_range_maximum` AS `items.required_level_range_maximum`,`cargo__items`.`required_level_range_text` AS `items.required_level_range_text`,`cargo__items`.`required_level_range_colour` AS `items.required_level_range_colour`,`cargo__items`.`required_strength_range_maximum` AS `items.required_strength_range_maximum`,`cargo__items`.`required_strength_range_text` AS `items.required_strength_range_text`,`cargo__items`.`required_strength_range_colour` AS `items.required_strength_range_colour`,`cargo__armours`.`armour_range_maximum` AS `armours.armour_range_maximum`,`cargo__armours`.`armour_range_text` AS `armours.armour_range_text`,`cargo__armours`.`armour_range_colour` AS `armours.armour_range_colour`,`cargo__items`.`stat_text` AS `items.stat_text` FROM `cargo__items` LEFT OUTER JOIN `cargo__armours` ON ((`cargo__items`.`_pageID`=`cargo__armours`.`_pageID`)) LEFT OUTER JOIN `cargo__versions` ON ((`cargo__items`.`release_version`=`cargo__versions`.`version`)) WHERE (`cargo__items`.`drop_enabled` = true

AND (`cargo__items`.`release_version` IS NULL OR `cargo__items`.`release_version` IS NOT NULL ) AND `cargo__items`.`base_item` IS NULL AND `cargo__items`.`base_item_id` IS NULL AND `cargo__items`.`base_item_page` IS NULL AND (`cargo__armours`.`armour_range_average` > 0 AND `cargo__armours`.`evasion_range_average` = 0 AND `cargo__armours`.`energy_shield_range_average` = 0 AND `cargo__items`.`class_id`="Body Armour" AND `cargo__items`.`rarity_id` HOLDS "%normal%")) AND `cargo__items`.`_pageNamespace` IN (0,10016) GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`required_level_range_maximum`,`cargo__items`.`name` LIMIT 5000

.

Evasion (Dexterity)

Item			EV	Stats
Leather Vest	1	0	30	—
Quilted Vest	1	10	44	—
Pathfinder Coat	11	24	78	—
Shrouded Vest	16	34	102	—
Rhoahide Coat	22	47	131	—
Studded Vest	26	55	150	—
Scout's Vest	33	68	184	—
Serpentscale Coat	36	75	198	—
Patchwork Vest	45	94	242	—
Hunting Coat	48	99	256	—
Riding Coat	51	105	271	—
Layered Vest	55	113	290	—
Runner Vest	59	122	309	—
Lizardscale Coat	62	128	324	—
Swiftstalker Coat	65	157	406	+(30–20)% reduced Slowing Potency of Debuffs on You
Slipstrike Vest	70	157	487	—
Wyrmscale Coat	75	157	406	(30-40)% increased Elemental Ailment Threshold

Energy Shield (Intelligence)

Item			ES	Stats
Tattered Robe	1	1	28	—
Feathered Robe	5	13	35	—
Hexer's Robe	11	24	44	—
Bone Raiment	16	34	52	—
Silk Robe	22	47	61	—
Keth Raiment	28	59	70	—
Votive Raiment	33	68	78	—
Altar Robe	40	83	89	—
Avian Robe	45	94	97	—
Cursespeaker's Robe	48	99	101	—
Luxurious Robe	51	105	106	—
River Raiment	55	113	112	—
Adherent's Raiment	59	122	119	—
Ceremonial Robe	62	128	123	—
Vile Robe	65	157	184	—
Flowing Raiment	70	157	153	(40-50)% increased Mana Regeneration Rate
Sacramental Robe	75	157	153	(40-50)% faster start of Energy Shield Recharge

Armour/Evasion (Strength/Dexterity)

Item				AR	EV	Stats
Chain Mail	1	1	1	25	16	—
Rogue Armour	11	14	14	53	43	—
Vagabond Armour	16	20	20	67	56	—
Cloaked Mail	26	31	31	95	83	—
Explorer Armour	33	39	39	114	101	—
Scale Mail	37	43	43	125	112	—
Chain Hauberk	45	51	51	148	133	—
Scoundrel Armour	48	55	55	156	141	—
Wanderer Armour	51	59	59	165	149	—
Mantled Mail	55	62	62	176	159	—
Trailblazer Armour	59	67	67	187	170	—
Golden Mail	62	70	70	195	178	—
Dastard Armour	65	86	86	245	223	(60-80) to maximum Life
Shrouded Mail	70	86	86	245	223	(20-25)% to Lightning Resistance
Shrouded Mail	70	86	86	245	223	(20-25)% to Cold Resistance
Shrouded Mail	70	86	86	245	223	(20-25)% to Fire Resistance
Death Mail	75	86	86	294	268	—

Armour/Energy Shield (Strength/Intelligence)

Item				AR	ES	Stats
Pilgrim Vestments	1	1	1	25	16	—
Pelt Mantle	12	14	14	50	23	—
Mail Vestments	16	20	20	67	28	—
Shaman Mantle	28	33	33	100	39	—
Ironclad Vestments	33	39	39	114	43	—
Sacrificial Mantle	36	41	41	123	46	—
Templar Vestments	45	51	51	148	53	—
Bearskin Mantle	48	55	55	156	56	—
Chain Vestments	51	59	59	165	58	—
Occultist Mantle	55	62	62	176	62	—
Plated Vestments	59	67	67	187	65	—
Heartcarver Mantle	62	70	70	195	68	—
Wolfskin Mantle	65	86	86	294	101	—
Conjurer Mantle	70	86	86	245	84	+(20-30) to Spirit
Death Mantle	75	86	86	245	84	+1% to all Maximum Elemental Resistances

Evasion/Energy Shield (Dexterity/Intelligence)

Item				EV	ES	Stats
Hermit Garb	1	1	1	16	16	—
Waxed Jacket	11	14	14	43	24	—
Marabout Garb	16	20	20	56	28	—
Wayfarer Jacket	28	33	33	88	39	—
Anchorite Garb	33	39	39	101	43	—
Scalper's Jacket	39	45	45	117	48	—
Ascetic Garb	45	51	51	133	53	—
Oiled Jacket	48	55	55	141	56	—
Evangelist Garb	51	59	59	149	58	—
Itinerant Jacket	55	62	62	159	62	—
Hatungo Garb	59	67	67	170	65	—
Hawker's Jacket	62	70	70	178	68	—
Sleek Jacket	65	86	86	268	101	—
Rambler Jacket	70	86	86	223	84	(7-13)% to Chaos Resistance
Falconer's Jacket	75	86	86	223	84	5% increased movement speed

Armour/Evasion/Energy Shield (Strength/Dexterity/Intelligence)

No results found