308
editsMore actions
no edit summary
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
= Equipment By Region = | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Ruined Battlefield%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Ruined Battlefield]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | |||
|tables=weapons; where = where_to_find like "%Ruined Battlefield%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Ruined Battlefield]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
|tables=equipment; where = where_to_find like "%Last Light Inn%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Last Light Inn]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | |||
|tables=weapons; where = where_to_find like "%Last Light Inn%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Last Light Inn]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
|tables=equipment; where = where_to_find like "%Reithwin Town%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Reithwin Town]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | |||
|tables=weapons; where = where_to_find like "%Reithwin Town%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Reithwin Town]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
|tables=equipment; where = where_to_find like "%Moonrise%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Moonrise]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | |||
|tables=weapons; where = where_to_find like "%Moonrise%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Moonrise]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
|tables=equipment; where = where_to_find like "%Grand Mausoleum%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Grand Mausoleum]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | |||
|tables=weapons; where = where_to_find like "%Grand Mausoleum%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Grand Mausoleum]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
|tables=equipment; where = where_to_find like "%Gauntlet of Shar%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Gauntlet of Shar]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | |||
|tables=weapons; where = where_to_find like "%Gauntlet of Shar%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Gauntlet of Shar]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
|tables=equipment; where = where_to_find like "%Shadowfell%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Shadowfell]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | |||
|tables=weapons; where = where_to_find like "%Shadowfell%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Shadowfell]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
|format=dynamic table | |||
|rows per page=1000 | |||
|hidden fields=Effects, Where To Find, Type, AC, Dmg | |||
|column widths=6%,16%,,,,13%,4%,6% | |||
}} | |||
<!-- | |||
{{WeaponsTableHeader}} | |||
{{#cargo_query: tables = weapons | |||
| fields = _pageName=page, name, uid, image, rarity, enchantment, damage, damage_type, extra_damage, extra_damage_type, weight_kg, weight_lb, price, special, special_weapon_actions | |||
| order by = rarity_order, name | |||
| where = rarity != "common" AND legacy IS NULL AND where_to_find like "%Gauntlet of Shar%" | |||
| default = {{WeaponsTableEmpty}} | |||
| format = template | |||
| template = WeaponsTableRow | |||
| named args = yes | |||
}} | |||
{{WeaponsTableFooter}} | |||
--> | |||
= High Utility Permanent Bonuses = | |||
See [[Permanent Bonuses]] or [[Permanent bonus table]] for a complete list of bonuses. | |||
{| class="wikitable mw-collapsible mw-collapsed" style="margin-left: auto; margin-right: auto; border: none;" | |||
! style="width: 100%;" | High Utility Permanent Bonuses | |||
|- | |||
| | |||
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;" | |||
|+ Act One | |||
! style="width: 14%;" | Region | |||
! style="width: 17%;" | Location | |||
! style="width: 21%;" | Bonus | |||
! style="width: 48%;" | Description | |||
|- | |||
| <!-- Region -->[[Blighted Village]] | |||
|| <!-- Location -->[[Apothecary's Cellar]] | |||
|| <!-- Bonus -->{{SAI|Forbidden Knowledge}} | |||
|| <!-- Description -->Gain +1 bonus to {{Ability|Wisdom}} {{SavingThrow}}s and [[Ability Checks]]. | |||
|- | |||
| <!-- Region -->[[Blighted Village]] | |||
|| <!-- Location -->[[Apothecary's Cellar]] | |||
|| <!-- Bonus -->{{SAI|Speak with Dead}} | |||
|| <!-- Description -->Gain {{SAI|Speak with Dead}} spell once per long rest from [[Necromancy of Thay]]. | |||
|- | |||
| <!-- Region -->[[Goblin Camp]] | |||
|| <!-- Location -->[[Shattered Sanctum#Centre|Shattered Sanctum Centre]] | |||
|| <!-- Bonus -->[[File:Absolute_symbol.png|25px]][[Absolute's Brand]] | |||
|| <!-- Description -->Gain the use of unique special effects on [[:Category:Absolute_Equipment|Absolute Equipment]].<br>Gain unique dialogue options with followers of the [[Absolute]]. | |||
|- | |||
| <!-- Region -->[[Goblin Camp]] | |||
|| <!-- Location -->[[Shattered Sanctum#East|Shattered Sanctum East]] | |||
|| <!-- Bonus -->{{cond|See Invisibility}} | |||
|| <!-- Description -->Grants a permanent {{cond|See Invisibility}} effect from [[Volo's Ersatz Eye (passive feature)|Volo's Ersatz Eye]]. | |||
|- | |||
| <!-- Region -->[[Goblin Camp]] | |||
|| <!-- Location -->[[Shattered Sanctum#East|Shattered Sanctum East]] | |||
|| <!-- Bonus -->{{cond|Loviatar's Love}}{{note|Effect is permanently lost if the character dies and is revived.}} | |||
|| <!-- Description -->When you have 30% [[Hit Points]] or less, you gain a '''+2''' bonus to {{Attack Roll}}s and {{Ability|Wisdom}} {{SavingThrow}}s for 3 turns. | |||
|- | |||
| <!-- Region -->[[Sunlit Wetlands]] | |||
|| <!-- Location -->[[Riverside Teahouse]] | |||
|| <!-- Bonus -->{{cond|Paid the Price}} | |||
|| <!-- Description -->Gain +1 bonus to [[Intimidation]] checks.<br>Gain {{Disadvantage}} on [[Perception]] checks.<br>Gain {{Disadvantage}} when attacking Hags. | |||
|- | |||
| <!-- Region -->[[Sunlit Wetlands]] | |||
|| <!-- Location -->[[Riverside Teahouse]] | |||
|| <!-- Bonus -->[[File:Generic_Feature_Icon.webp|25px]][[Auntie Ethel's Hair|Auntie Ethel's Boon]] | |||
|| <!-- Description -->Gain +1 to an [[Ability Scores|Ability Score]] of choice. Can be raised above 20. | |||
|- | |||
| <!-- Region -->[[Underdark]] | |||
|| <!-- Location -->[[Myconid Colony]] | |||
|| <!-- Bonus -->{{SAI|Survival Instinct}} | |||
|| <!-- Description -->Gain the additional [[Illithid Powers|illithid power]] {{Icon|Cleric Tadpole Survival Instinct.png|30|link=Survival Instinct}}[[Survival Instinct]] | |||
|- | |||
| <!-- Region -->[[Underdark]] | |||
|| <!-- Location -->[[The Festering Cove]] | |||
|| <!-- Bonus -->{{Condition inline|BOOOAL's Blessing}} | |||
|| <!-- Description -->Gain {{Advantage}} on {{Attack Roll}}s against {{cond|Bleeding}} targets. | |||
|- | |||
| <!-- Region -->[[Rosymorn Monastery]] | |||
|| <!-- Location -->[[Crèche Y'llek#Infirmary|Crèche Y'llek Infirmary]] | |||
|| <!-- Bonus -->{{SAI|Awakened}} | |||
|| <!-- Description -->You can use all of your Illithid powers as a [[Bonus Action]]. | |||
|} | |||
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;" | |||
|+ Act Two | |||
! style="width: 14%;" | Region | |||
! style="width: 17%;" | Location | |||
! style="width: 21%;" | Bonus | |||
! style="width: 48%;" | Description | |||
|- | |||
| <!-- Region -->[[Ruined Battlefield]] | |||
|| <!-- Location -->[[Seek_Protection_from_the_Shadow_Curse#The lantern's power|Kar'niss]] | |||
|| <!-- Bonus -->{{cond|Pixie Blessing}} | |||
|| <!-- Description -->Gain immunity to the {{cond|Shadow Curse}}. | |||
|- | |||
| <!-- Region -->[[Moonrise Towers]] | |||
|| <!-- Location -->[[Moonrise Towers#Main floor|Main Floor]] | |||
|| <!-- Bonus -->[[File:POT_Potion_of_Everlasting_Vigour_Faded.png|25px]][[Potion of Everlasting Vigour]] | |||
|| <!-- Description -->Gain +2 {{Ability|Strength}}. | |||
|- | |||
| <!-- Region -->[[Moonrise Towers]] | |||
|| <!-- Location -->[[Mind Flayer Colony]] | |||
|| <!-- Bonus -->{{cond|Githzerai Mind Barrier}}{{note|Effect is permanently lost if the character dies and is revived.}} | |||
|| <!-- Description -->Gain {{Advantage}} on {{Ability|Intelligence}} {{SavingThrow}}s. | |||
|- | |||
| <!-- Region -->[[Moonrise Towers]] | |||
|| <!-- Location --> | |||
|| <!-- Bonus -->{{SAI|Bardic Inspiration|Improved Bardic Inspiration}} | |||
|| <!-- Description -->Gain a charge of Bardic Inspiration that is stronger than usual ({{DieIcon|d12|Slashing}}'''1d12'''). | |||
|- | |||
| <!-- Region -->[[Reithwin Town]] | |||
|| <!-- Location -->[[Find Arabella's Parents#Breaking the news|Arabella]] | |||
|| <!-- Bonus -->{{SAI|Arabella's Shadow Entangle}} | |||
|| <!-- Description -->Entangle an Undead or shadow creature until long rest. | |||
|} | |||
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;" | |||
|+ Act Three | |||
! style="width: 14%;" | Region | |||
! style="width: 17%;" | Location | |||
! style="width: 21%;" | Bonus | |||
! style="width: 48%;" | Description | |||
|- | |||
| <!-- Region -->[[Help Your Protector|Wyrm's Lookout]] | |||
|| <!-- Location -->[[Astral Plane]] | |||
|| <!-- Bonus -->{{SAI|Partial Ceremorphosis}} | |||
|| <!-- Description -->Gain all [[Illithid_powers#List_of_illithid_powers|Tier 1 Illithid Powers]].<br>Gain access to [[Illithid_powers#Elite_Powers|Tier 3 Illithid Powers]].<br>Gain {{SAI|Fly (Illithid Power)|Fly}}. | |||
|- | |||
| <!-- Region -->[[Rivington]] | |||
|| <!-- Location -->[[Circus of the Last Days]] | |||
|| <!-- Bonus -->{{cond|Sweet Stone Features}} | |||
|| <!-- Description -->Gain a {{DieIcon|d4|Slashing}} '''+1d4''' bonus to {{Attack Roll}}s and {{SavingThrow}}s. | |||
|- | |||
| <!-- Region -->[[Lower City]] | |||
|| <!-- Location -->[[Crimson Draughts]] | |||
|| <!-- Bonus -->{{SAI|Unstable Blood}} | |||
|| <!-- Description -->Your blood is now highly flammable and will explode on contact with fire. | |||
|- | |||
| <!-- Region -->[[Lower City]] | |||
|| <!-- Location --> [[House of Grief]] | |||
|| <!-- Bonus -->[[Mirror of Loss|Patriar's Memory]] | |||
|| <!-- Description -->Gain +1 {{Ability|Charisma}}. | |||
|- | |||
| <!-- Region -->[[Lower City]] | |||
|| <!-- Location --> [[House of Grief]] | |||
|| <!-- Bonus -->[[Mirror of Loss#Using_the_mirror|<Stolen> Memory]] | |||
|| <!-- Description -->Gain +2 to an [[Ability Score]] of your choice. | |||
|- | |||
| <!-- Region -->[[Lower City]] | |||
|| <!-- Location -->[[Ramazith's Tower]] | |||
|| <!-- Bonus -->{{SAI|Danse Macabre}} | |||
|| <!-- Description -->Create 4 [[ghoul|ghouls]] that fight alongside you. | |||
|- | |||
| <!-- Region -->[[Lower City]] | |||
|| <!-- Location -->[[Ramazith's Tower]] | |||
|| <!-- Bonus -->{{cond|Tharchiate Withering}} | |||
|| <!-- Description -->Gain -5 {{Ability|Constitution}} and a sickly green aura. | |||
|- | |||
| <!-- Region -->[[Lower City]] | |||
|| <!-- Location -->[[Ramazith's Tower]] | |||
|| <!-- Bonus -->{{SAI|The Tharchiate Codex: Blessing|Tharchiate Codex: Blessing}} | |||
|| <!-- Description -->Gain {{Cond|Tharchiate Vigour}} immediately and also once after every [[Long Rest]]. | |||
|- | |||
| <!-- Region -->[[Lower City]] | |||
|| <!-- Location -->[[Steel Watch Foundry]] | |||
|| <!-- Bonus -->[[Slayer Knowledge]] | |||
|| <!-- Description -->Gain {{Advantage}} on [[Saving Throws]] against being {{Cond|Frightened}} by a [[Bhaalspawn]] Slayer | |||
|} | |||
{{notelist}} | |||
|} | |||
| Line 153: | Line 412: | ||
{{SpoilerBox|act=1|custom=[[Headwear]].| | {{SpoilerBox|act=1|custom=[[Headwear]].| | ||
{{#cargo_query: tables = equipment | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | | order by = rarity_order | ||
| where = (type = "Helmets" OR type = "Headwear") AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL | | where = (type = "Helmets" OR type = "Headwear") AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL | ||
| Line 161: | Line 420: | ||
{{SpoilerBox|act=1|custom=[[Cloaks]].| | {{SpoilerBox|act=1|custom=[[Cloaks]].| | ||
{{#cargo_query: tables = equipment | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | | order by = rarity_order | ||
| where = type = "Cloaks" AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL | | where = type = "Cloaks" AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL | ||
| Line 169: | Line 428: | ||
{{SpoilerBox|act=1|custom=[[Armour]].| | {{SpoilerBox|act=1|custom=[[Armour]].| | ||
{{#cargo_query: tables = equipment | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | | order by = rarity_order | ||
| where = type like "% Armour%" AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL | | where = type like "% Armour%" AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL | ||
| Line 177: | Line 436: | ||
{{SpoilerBox|act=1|custom=[[Handwear]].| | {{SpoilerBox|act=1|custom=[[Handwear]].| | ||
{{#cargo_query: tables = equipment | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | | order by = rarity_order | ||
| where = type = "Gloves" AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL | | where = type = "Gloves" AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL | ||
| Line 184: | Line 443: | ||
}} | }} | ||
{{SpoilerBox|act=1|custom=[[Weapons]].| | {{SpoilerBox|act=1|custom=[[Weapons]].| | ||
{{#cargo_query: tables = weapons | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, type=Type, special=Effects, where_to_find=Location | |||
| order by = type | |||
| where = | |||
rarity != "common" | |||
AND legacy IS NULL | |||
AND ( | |||
where_to_find like "%Wilderness%" OR | |||
where_to_find like "%Underdark%" OR | |||
where_to_find like "%Grymforge%" OR | |||
where_to_find like "%Rosymorn Monastery%" | |||
) | |||
| format = table | |||
}} | |||
}} | }} | ||
}} | }} | ||
| Line 197: | Line 469: | ||
{{SpoilerBox|act=2|custom=[[Headwear]].| | {{SpoilerBox|act=2|custom=[[Headwear]].| | ||
{{#cargo_query: tables = equipment | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | | order by = rarity_order | ||
| where = (type = "Helmets" OR type = "Headwear") AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL | | where = (type = "Helmets" OR type = "Headwear") AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL | ||
| Line 206: | Line 478: | ||
{{SpoilerBox|act=2|custom=[[Cloaks]].| | {{SpoilerBox|act=2|custom=[[Cloaks]].| | ||
{{#cargo_query: tables = equipment | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | | order by = rarity_order | ||
| where = type = "Cloaks" AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL | | where = type = "Cloaks" AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL | ||
| Line 215: | Line 487: | ||
{{SpoilerBox|act=2|custom=[[Armour]].| | {{SpoilerBox|act=2|custom=[[Armour]].| | ||
{{#cargo_query: tables = equipment | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | | order by = rarity_order | ||
| where = type like "% Armour%" AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL | | where = type like "% Armour%" AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL | ||
| Line 224: | Line 496: | ||
{{SpoilerBox|act=2|custom=[[Handwear]].| | {{SpoilerBox|act=2|custom=[[Handwear]].| | ||
{{#cargo_query: tables = equipment | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | | order by = rarity_order | ||
| where = type = "Gloves" AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL | | where = type = "Gloves" AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL | ||
| Line 233: | Line 505: | ||
{{SpoilerBox|act=2|custom=[[Weapons]].| | {{SpoilerBox|act=2|custom=[[Weapons]].| | ||
{{#cargo_query: tables = weapons | {{#cargo_query: tables = weapons | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = | | order by = type | ||
| where = | | where = | ||
rarity != "common" | rarity != "common" | ||
| Line 254: | Line 526: | ||
{{SpoilerBox|act=2|custom=[[Shields]].| | {{SpoilerBox|act=2|custom=[[Shields]].| | ||
{{#cargo_query: tables = equipment | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | | order by = rarity_order | ||
| where = | | where = | ||
| Line 275: | Line 547: | ||
{{SpoilerBox|act=2|custom=[[Amulets]].| | {{SpoilerBox|act=2|custom=[[Amulets]].| | ||
{{#cargo_query: tables = equipment | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | | order by = rarity_order | ||
| where = | | where = | ||
| Line 297: | Line 569: | ||
{{SpoilerBox|act=2|custom=[[Rings]].| | {{SpoilerBox|act=2|custom=[[Rings]].| | ||
{{#cargo_query: tables = equipment | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | | order by = rarity_order | ||
| where = | | where = | ||
| Line 327: | Line 599: | ||
{{SpoilerBox|act=3|custom=[[Headwear]].| | {{SpoilerBox|act=3|custom=[[Headwear]].| | ||
{{#cargo_query: tables = equipment | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | | order by = rarity_order | ||
| where = (type = "Helmets" OR type = "Headwear") AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL | | where = (type = "Helmets" OR type = "Headwear") AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL | ||
| Line 336: | Line 608: | ||
{{SpoilerBox|act=3|custom=[[Cloaks]].| | {{SpoilerBox|act=3|custom=[[Cloaks]].| | ||
{{#cargo_query: tables = equipment | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | | order by = rarity_order | ||
| where = type = "Cloaks" AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL | | where = type = "Cloaks" AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL | ||
| Line 345: | Line 617: | ||
{{SpoilerBox|act=3|custom=[[Armour]].| | {{SpoilerBox|act=3|custom=[[Armour]].| | ||
{{#cargo_query: tables = equipment | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | | order by = rarity_order | ||
| where = type like "% Armour%" AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL | | where = type like "% Armour%" AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL | ||
| Line 354: | Line 626: | ||
{{SpoilerBox|act=3|custom=[[Handwear]].| | {{SpoilerBox|act=3|custom=[[Handwear]].| | ||
{{#cargo_query: tables = equipment | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | | order by = rarity_order | ||
| where = type = "Gloves" AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL | | where = type = "Gloves" AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL | ||
| Line 362: | Line 634: | ||
}} | }} | ||