Template:Query base armours: Difference between revisions
Jump to navigation
Jump to search
(Query by class_id) |
Tag: Undo |
||
(11 intermediate revisions by 3 users not shown) | |||
Line 2: | Line 2: | ||
{{Query base items | {{Query base items | ||
|where=armours.armour_range_average > 0 AND armours.evasion_range_average = 0 AND armours.energy_shield_range_average = 0 {{#if:{{{item_class|}}}|AND items.class_id="{{{item_class|}}}"|}} | |where=armours.armour_range_average > 0 AND armours.evasion_range_average = 0 AND armours.energy_shield_range_average = 0 {{#if:{{{item_class|}}}|AND items.class_id="{{{item_class|}}}"|}} AND items.rarity_id LIKE "normal" | ||
|large=1 | |large=1 | ||
|level=1 | |level=1 | ||
Line 8: | Line 8: | ||
|ar=1 | |ar=1 | ||
|stat=1 | |stat=1 | ||
|block={{#ifeq:{{{item_class|}}}| | |block={{#ifeq:{{{item_class|}}}|Shield|1|}} | ||
}} | }} | ||
Line 14: | Line 14: | ||
{{Query base items | {{Query base items | ||
|where=armours.armour_range_average = 0 AND armours.evasion_range_average > 0 AND armours.energy_shield_range_average = 0 {{#if:{{{item_class|}}}|AND items.class_id="{{{item_class|}}}"|}} | |where=armours.armour_range_average = 0 AND armours.evasion_range_average > 0 AND armours.energy_shield_range_average = 0 {{#if:{{{item_class|}}}|AND items.class_id="{{{item_class|}}}"|}} AND items.rarity_id LIKE "normal" | ||
|large=1 | |large=1 | ||
|level=1 | |level=1 | ||
Line 20: | Line 20: | ||
|ev=1 | |ev=1 | ||
|stat=1 | |stat=1 | ||
|block={{#ifeq:{{{item_class|}}}| | |block={{#ifeq:{{{item_class|}}}|Shield|1|}} | ||
}} | }} | ||
Line 26: | Line 26: | ||
{{Query base items | {{Query base items | ||
|where=armours.armour_range_average = 0 AND armours.evasion_range_average = 0 AND armours.energy_shield_range_average > 0 {{#if:{{{item_class|}}}|AND items.class_id="{{{item_class|}}}"|}} | |where=armours.armour_range_average = 0 AND armours.evasion_range_average = 0 AND armours.energy_shield_range_average > 0 {{#if:{{{item_class|}}}|AND items.class_id="{{{item_class|}}}"|}} AND items.rarity_id LIKE "normal" | ||
|large=1 | |large=1 | ||
|level=1 | |level=1 | ||
Line 32: | Line 32: | ||
|es=1 | |es=1 | ||
|stat=1 | |stat=1 | ||
|block={{#ifeq:{{{item_class|}}}| | |block={{#ifeq:{{{item_class|}}}|Shield|1|}} | ||
}} | }} | ||
Line 38: | Line 38: | ||
{{Query base items | {{Query base items | ||
|where=armours.armour_range_average > 0 AND armours.evasion_range_average > 0 AND armours.energy_shield_range_average = 0 {{#if:{{{item_class|}}}|AND items.class_id="{{{item_class|}}}"|}} | |where=armours.armour_range_average > 0 AND armours.evasion_range_average > 0 AND armours.energy_shield_range_average = 0 {{#if:{{{item_class|}}}|AND items.class_id="{{{item_class|}}}"|}} AND items.rarity_id LIKE "normal" | ||
|large=1 | |large=1 | ||
|level=1 | |level=1 | ||
Line 46: | Line 46: | ||
|ev=1 | |ev=1 | ||
|stat=1 | |stat=1 | ||
|block={{#ifeq:{{{item_class|}}}| | |block={{#ifeq:{{{item_class|}}}|Shield|1|}} | ||
}} | }} | ||
Line 52: | Line 52: | ||
{{Query base items | {{Query base items | ||
|where=armours.armour_range_average > 0 AND armours.evasion_range_average = 0 AND armours.energy_shield_range_average > 0 {{#if:{{{item_class|}}}|AND items.class_id="{{{item_class|}}}"|}} | |where=armours.armour_range_average > 0 AND armours.evasion_range_average = 0 AND armours.energy_shield_range_average > 0 {{#if:{{{item_class|}}}|AND items.class_id="{{{item_class|}}}"|}} AND items.rarity_id LIKE "normal" | ||
|large=1 | |large=1 | ||
|level=1 | |level=1 | ||
Line 60: | Line 60: | ||
|es=1 | |es=1 | ||
|stat=1 | |stat=1 | ||
|block={{#ifeq:{{{item_class|}}}| | |block={{#ifeq:{{{item_class|}}}|Shield|1|}} | ||
}} | }} | ||
===Energy Shield | ===Evasion/Energy Shield ([[Dexterity]]/[[Intelligence]])=== | ||
{{Query base items | {{Query base items | ||
|where=armours.armour_range_average = 0 AND armours.evasion_range_average > 0 AND armours.energy_shield_range_average > 0 {{#if:{{{item_class|}}}|AND items.class_id="{{{item_class|}}}"|}} | |where=armours.armour_range_average = 0 AND armours.evasion_range_average > 0 AND armours.energy_shield_range_average > 0 {{#if:{{{item_class|}}}|AND items.class_id="{{{item_class|}}}"|}} AND items.rarity_id LIKE "normal" | ||
|large=1 | |large=1 | ||
|level=1 | |level=1 | ||
Line 74: | Line 74: | ||
|es=1 | |es=1 | ||
|stat=1 | |stat=1 | ||
|block={{#ifeq:{{{item_class|}}}| | |block={{#ifeq:{{{item_class|}}}|Shield|1|}} | ||
|q_sort=Has level requirement | |q_sort=Has level requirement | ||
}} | }} | ||
Line 81: | Line 81: | ||
{{Query base items | {{Query base items | ||
|where=armours.armour_range_average > 0 AND armours.evasion_range_average > 0 AND armours.energy_shield_range_average > 0 {{#if:{{{item_class|}}}|AND items.class_id="{{{item_class|}}}"|}} | |where=armours.armour_range_average > 0 AND armours.evasion_range_average > 0 AND armours.energy_shield_range_average > 0 {{#if:{{{item_class|}}}|AND items.class_id="{{{item_class|}}}"|}} AND items.rarity_id LIKE "normal" | ||
|large=1 | |large=1 | ||
|level=1 | |level=1 | ||
Line 91: | Line 91: | ||
|es=1 | |es=1 | ||
|stat=1 | |stat=1 | ||
|block={{#ifeq:{{{item_class|}}}| | |block={{#ifeq:{{{item_class|}}}|Shield|1|}} | ||
|q_sort=Has level requirement | |q_sort=Has level requirement | ||
}}}}</includeonly><noinclude> | }}}}</includeonly><noinclude> | ||
{{Documentation}} | {{Documentation}} | ||
</noinclude> | </noinclude> |
Latest revision as of 01:57, 30 October 2024
Overview
This template queries for base armours based on a item class.
For more information, see Template:Item table.
The above documentation is transcluded from Template:Query base armours/doc.
Editors can experiment in this template's sandbox and testcases pages.
Please add categories to the /doc subpage. Subpages of this template.
Editors can experiment in this template's sandbox and testcases pages.
Please add categories to the /doc subpage. Subpages of this template.