Template:Item table/doc

This subpage provides documentation for Template:Item table.

Overview

This template creates an advanced list for modifiers based on performing an cargo query.

Specialized Templates

There are also specialized sub templates for the following item types available:

skill gems - Template:Item table/skill gems

Query Templates

There are also several query templates based on this template in order to reduce query duplication:

Parameters

Main Parameters

Parameter	Value	Description
default	str	If specified, the value of this will be returned of there are no results for the specified query.
large	bool	Whether to show large inventory icons Default: No
no_html	bool	Don't show HTML infoboxes on hover. Advisable to enable this on very large lists, as it makes the resulting table much smaller. In particular if the page hits the wiki limits for size.
q_<param>	—	It is possible to add any parameters of the cargo query (field names) by prefixing them with `q_`. Specifying at least q_where and q_limit is highly recommended. q_limit is restricted to a maximum of 300. Additional tables can be specified using q_tables.

Display control parameters

All these parameters are binary, so as long you specify something like icon=1 it will show up. If something is not available on the item you're fetching it will show up as "N/A"

Parameter	Description	Local
base_item	Shows the base item (i.e. of an unique item).
class	Show the item class.
rarity	Show the rarity of the item.
rarity_id	Show the rarity id of the item which is not dependent on the game language.
essence	Shows the essence tier.
drop_level	Shows the drop level of the item.
stack_size	Show the maximum stack size (not in currency tab).
stack_size_currency_tab	Show the maximum stack size in the currency tab.
level	the level requirement of the item.
str	the strength requirement of the item.
int	the intelligence requirement of the item.
dex	the dexterity requirement of the item.
ar	Shows how much armour the item provides.
ev	Shows how much evasion the item provides.
es	Shows how much energy shield the item provides.
block	Shows how much block the item provides.
damage	Shows the damage values of a weapon. This includes any added elemental or chaos damage in the appropriate colour(s).
aps	Shows the attacks per second value of a weapon.
crit	Shows the local critical strike chance of a weapon.
flask_life	Shows how much life the flask recovers per use.
flask_life_per_second	Shows how much life the flask recovers per second when in use.
flask_life_per_charge	Shows how much life the flask recovers per charge when used.
flask_mana	Shows how much mana the flask recovers per use.
flask_mana_per_second	Shows how much mana the flask recovers per second when in use.
flask_mana_per_charge	Shows how much mana the flask recovers per charge when used.
flask	Shows various generic flask properties: Duration of the flask How many flask charges are consumed per single use Maximum number of flask charges held
buff	Shows the effect of the buffs granted by the item (generally applicable to Utility Flasks).
physical_dps	Shows physical damage per second.
fire_dps	Shows fire damage per second.
cold_dps	Shows cold damage per second.
lightning_dps	Shows lightning damage per second.
chaos_dps	Shows chaos damage per second.
elemental_dps	Shows the combined elemental damage per second (i.e. fire damage, cold damage and lightning damage).
poison_dps	Shows the combined damage that can apply to poison (i.e. physical damage and chaos damage).
dps	Shows the total combined damage per second (i.e. physical damage, fire damage, cold damage, lightning damage and chaos damage).
stat	the complete stat text of the item (both implicit and explicit stats derived from mods) in a single column.
item_limit	Shows the item limit of an item.
jewel_radius	Show the radius of a jewel.
map_tier	Show the map tier.
map_level	Show the map level.
map_guild_character	Show the character a map produces for a guild tag.
atlas_tier	Show the atlas tier based on the region upgrade level.
atlas_level	Show the atlas level based on the region upgrade level.
master_level_requirement	Shows the required level of the forsaken master in order to purchase the doodad.
master	Shows the forsaken master name where the doodad can be purchased at.
master_favour_cost	Shows the how much favour the doodad costs when purchased at a forsaken master.
variations	Shows the number of possible variations of the doodad.
description	Shows the description text of the item.
flavour_text	Shows the flavour text of the item.
help_text	Shows the help_text of the item.
objective	Shows the objective section from a prophecy page crated with `{{Prophecy description}}`.
reward	Shows the reward section from a prophecy page crated with `{{Prophecy description}}`.
seal_cost	Shows the seal cost of a prophecy.
prediction_text	Shows the prediction text of a prophecy.
buff_icon	Shows the buff icon associated with the item's buff.
release_version	Shows which version the item was released.
removal_version	Shows which version the item was removed.
drop_enabled	Shows whether the item is considered drop_enabled and can be normally obtained.
drop_leagues	Shows which leagues the item can be obtained in.
drop_areas	Shows which areas the item can be obtained in.
drop_monsters	Shows which monsters the item can be obtained from.
drop_text	Shows drop restriction information that doesn't fit into other categories.
quest_name	Shows quest names that the item can be obtained from.
quest_act	Shows which act the quest can be found in.
purchase_cost	Shows the cost of buying from an NPC vendor.
sell_price	Shows the currencies received when selling the item to an NPC vendor.
boss_name	Shows the bosses of the map.
boss_number	Shows the number of bosses in the map.
legacy	Shows legacy stats where the data is queried from `{{Legacy variant table row}}`.
granted_skills	Shows skills granted by the item.
alternate_art	Shows the alternate arts the item may have.

Multi-option parameters

These parameters will active multiple options at once. They should be used for "default" lists, as additional variables may be added over time:

Parameter	Description	Parameters activated
weapon	Show weapon information.	damage aps crit
prophecy	Show prophecy information.	prediction_text seal_cost
version	Enables all options relevant to versions.	release_version removal_version
drop	Show information related on how an item is obtained.	drop_level drop_enabled drop_leagues drop_areas drop_text
doodad	Enables all options relevant to hideout doodads.	master_level_requirement master master_favour_cost variation_count
quest	Enables all options relevant to quests.	quest_name quest_act
price	Enables all options relevant to prices.	purchase_cost sell_price
boss	Enables all options relevant to bosses.	boss_name boss_number

Stat parameters

It is possible to directly query any stats on the item. The stats are an aggregate from all modifiers on the item (this means it will include implicit values).

Queried stats are sorted into columns, and a column can hold any arbitrary number of stats (but at least one) and there can be any number of columns.

The columns will be sorted by the average value of the stat. If multiple stats are specified for a single column, this is the average of all individual stat averages.

The following prefixes are used:

Columns: stat_column<i>_
Stat: stat<j>_

<i> and <j> need to be replaced with the number starting at 1.

Parameter	Value	Description
stat_column<i>_header	str	Header to use in table for the stat. If left empty, the id of stat will be used
stat_column<i>_format	str	Lua string.format specifier. Note that the number of formatter must match the number of stats for the specific column or an error will be raised. If left empty, all result will simply be shown in a comma-separated list.
stat_column<i>_stat_format	str	Acceptable values: separate - separate entries using comma separation for the specified format add - add up all the acceptable stats into a single value; uses 0 if not available
stat_column<i>_order	int	Ordering priority for showing this column. Defaults to a very high value.
stat_column<i>_stat<j>_id	str	Identifier of the stat. If you are not sure what this is, consider checking the sub objects created on items - it will be stored in Property:Has stat id

Examples

Show item limit

{{Item table
|q_where=items._pageName="Self-Flagellation"
|large=1
|stat=1
|item_limit=1
}}

Yields:

Item	Stats

Show possible "Maximum Life" rolls on unique items with at least +100 life

{{Item table
|q_tables=item_stats
|q_join=items._pageID=item_stats._pageID
|q_where=items.rarity_id="unique" AND item_stats.id="base_maximum_life" AND item_stats.min > 100
|large=1
|level=1
|stat=1
|stat_column1_header=Life
|stat_column1_format=+%s to maximum Life
|stat_column1_stat1_id=base_maximum_life
}}