308
edits→Act Three
No edit summary |
|||
(17 intermediate revisions by the same user not shown) | |||
Line 34: | Line 34: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation|Silvanus%27_Grove_SW.png|Emerald Grove|The Emerald Grove, also known as Silvanus' Grove and Druid's Grove.<br> | {{ImageLocation|Silvanus%27_Grove_SW.png|Emerald Grove|The Emerald Grove, also known as Silvanus' Grove and Druid's Grove.<br> | ||
<hr> | <hr> | ||
[[ | Sold by [[Arron]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = ( | tables=equipment; where = ( | ||
(where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | |||
where_to_find | where_to_find like "%Arron%") AND | ||
where_to_find | where_to_find NOT REGEXP "Strange Ox" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = ( | |tables=weapons; where = ( | ||
(where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | |||
where_to_find | where_to_find like "%Arron%") AND | ||
where_to_find | where_to_find NOT REGEXP "Strange Ox" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 74: | Line 73: | ||
|delimiter=<br> | |delimiter=<br> | ||
}} | }} | ||
<hr> | <hr> | ||
[[ | Sold by [[Auntie Ethel]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "% | tables=equipment; where = ( | ||
(where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | |||
where_to_find like "%Auntie Ethel%") AND | |||
where_to_find NOT REGEXP "Strange Ox" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = ( | ||
(where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | |||
where_to_find like "%Auntie Ethel%") AND | |||
where_to_find NOT REGEXP "Strange Ox" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 89: | Line 92: | ||
|delimiter=<br> | |delimiter=<br> | ||
}} | }} | ||
<hr> | <hr> | ||
[[ | Sold by [[Volo]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "% | tables=equipment; where = ( | ||
(where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | |||
where_to_find like "%Volo%") AND | |||
where_to_find NOT REGEXP "Strange Ox" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = ( | ||
(where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | |||
where_to_find like "%Volo%") AND | |||
where_to_find NOT REGEXP "Strange Ox" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 105: | Line 112: | ||
}} | }} | ||
<hr> | <hr> | ||
[[ | [[Druid Grove]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "% | tables=equipment; where = ( | ||
((where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | |||
where_to_find NOT REGEXP "Dammon" AND | |||
where_to_find NOT REGEXP "Arron" AND | |||
where_to_find NOT REGEXP "Auntie Ethel" AND | |||
where_to_find NOT REGEXP "Volo") OR | |||
where_to_find like "%Strange Ox%") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = ( | ||
((where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | |||
where_to_find NOT REGEXP "Dammon" AND | |||
where_to_find NOT REGEXP "Arron" AND | |||
where_to_find NOT REGEXP "Auntie Ethel" AND | |||
where_to_find NOT REGEXP "Volo") OR | |||
where_to_find like "%Strange Ox%") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 118: | Line 137: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation|Forest.jpg|Forest|Forest is a sub-area of the Wilderness. It is found west of the Emerald Grove.<br> | |||
{{ImageLocation| | |||
<hr> | <hr> | ||
[[ | [[Forest]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = | tables=equipment; where = where_to_find like "%Forest%" | ||
AND rarity != "common" AND legacy IS NULL; | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = | |tables=weapons; where = where_to_find like "%Forest%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 156: | Line 151: | ||
|delimiter=<br> | |delimiter=<br> | ||
}} | }} | ||
<hr> | <hr> | ||
[[Owlbear Nest]] | |||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = | tables=equipment; where = where_to_find like "%Owlbear Nest%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = | |tables=weapons; where = where_to_find like "%Owlbear Nest%" | ||
AND rarity != "common" AND legacy IS NULL; | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
|format=list | |format=list | ||
|delimiter=<br> | |delimiter=<br> | ||
}} | }} | ||
}} | |||
{{ImageLocation|The Risen Road.jpg|The Risen Road|'''The Risen Road''' is a long stretch of road that connects [[Elturel]] and [[Baldur's Gate]].<br> | |||
<hr> | <hr> | ||
[[ | [[The Risen Road]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = | tables=equipment; where = where_to_find like "%Risen Road%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = | |tables=weapons; where = where_to_find like "%Risen Road%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 199: | Line 180: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation| | {{ImageLocation|Arcane Tower.jpg|Arcane Tower|An isolated wizard tower deep in the [[Underdark]] protected by Arcane Cannons<br> | ||
<hr> | <hr> | ||
[[Arcane Tower]] | |||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = | tables=equipment; where = where_to_find like "%Arcane Tower%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = | |tables=weapons; where = where_to_find like "%Arcane Tower%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 213: | Line 194: | ||
|delimiter=<br> | |delimiter=<br> | ||
}} | }} | ||
|tall=y}} | |||
== [[Act Two]] == | |||
{{ImageLocation|Grand Mausoleum Vestibule.jpg|Grand Mausoleum|The Thorm family mausoleum, resting place of Melodia Thorm and entrance to the Gauntlet of Shar<br> | |||
[[Gauntlet of Shar]] | |||
| | |||
}} | }} | ||
== [[Act Three]] == | |||
<br> | |||
<hr> | |||
<hr> | <hr> | ||
'''Wyrm's Crossing''' | |||
<hr> | <hr> | ||
<hr> | <hr> | ||
[[ | {{ImageLocation|Rivington.jpg|Rivington|The southern-most district of Baldur's Gate, located south of [[Wyrm's Crossing]].<br> | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | [[Rivington]] | ||
tables=equipment; where = (where_to_find like "%Circus of the Last Days | <hr> | ||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
where_to_find like "%Rivington%" AND | |||
where_to_find NOT REGEXP "Rivington General" AND | |||
where_to_find NOT REGEXP "Ferg Drogher" AND | |||
where_to_find NOT REGEXP "Mattis" AND | |||
where_to_find NOT REGEXP "Circus of the Last Days" AND | |||
where_to_find NOT REGEXP "Open Hand Temple" AND | |||
where_to_find NOT REGEXP "Angleiron's Cellar") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = (where_to_find like "%Circus of the Last Days | |tables=weapons; where = ( | ||
where_to_find like "%Rivington%" AND | |||
where_to_find NOT REGEXP "Rivington General" AND | |||
where_to_find NOT REGEXP "Ferg Drogher" AND | |||
where_to_find NOT REGEXP "Mattis" AND | |||
where_to_find NOT REGEXP "Circus of the Last Days" AND | |||
where_to_find NOT REGEXP "Open Hand Temple" AND | |||
where_to_find NOT REGEXP "Angleiron's Cellar") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 255: | Line 238: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation|Rivington General.jpg|Rivington General|The general store in [[Rivington]], run by a Dragonborn [[Exxvikyap]].<br> | |||
{{ImageLocation| | |||
<hr> | <hr> | ||
[[ | Sold by [[Exxvikyap]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = (where_to_find like "% | tables=equipment; where = ( | ||
where_to_find like "%Rivington General%" AND | |||
where_to_find like "%Exxvikyap%" AND | |||
(where_to_find like "%Purchased%" OR where_to_find like "%Sold%" OR where_to_find like "%bought%")) | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = (where_to_find like "% | |tables=weapons; where = ( | ||
where_to_find like "%Rivington General%" AND | |||
where_to_find like "%Exxvikyap%" AND | |||
(where_to_find like "%Purchased%" OR where_to_find like "%Sold%" OR where_to_find like "%bought%")) | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 270: | Line 258: | ||
|delimiter=<br> | |delimiter=<br> | ||
}} | }} | ||
<hr> | <hr> | ||
[[Rivington General]] | |||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "% | tables=equipment; where = ( | ||
where_to_find like "%Rivington General%" AND | |||
where_to_find NOT REGEXP "Purchased" AND | |||
where_to_find NOT REGEXP "Sold" AND | |||
where_to_find NOT REGEXP "bought") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = ( | ||
where_to_find like "%Rivington General%" AND | |||
where_to_find NOT REGEXP "Purchased" AND | |||
where_to_find NOT REGEXP "Sold" AND | |||
where_to_find NOT REGEXP "bought") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 286: | Line 280: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation| | {{ImageLocation|Requisitioned Barn.jpg|Requisitioned Barn|The '''Requisitioned Barn''' is a donation center for refugees heading to Baldur's Gate.<br> | ||
<hr> | <hr> | ||
Sold by [[ | Sold by [[Ferg Drogher]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = (where_to_find like "% | tables=equipment; where = (where_to_find like "%Ferg Drogher%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = (where_to_find like "% | |tables=weapons; where = (where_to_find like "%Ferg Drogher%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 301: | Line 295: | ||
}} | }} | ||
<hr> | <hr> | ||
[[ | Sold by [[Mattis]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = (where_to_find like "% | tables=equipment; where = (where_to_find like "%Mattis%Rivington%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = (where_to_find like "% | |tables=weapons; where = (where_to_find like "%Mattis%Rivington%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 314: | Line 308: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation| | {{ImageLocation|Circus of the Last Days.jpg|Circus of the Last Days|An extraplanar circus which moves from plane to plane, "thrilling all" who stop by.<br> | ||
<hr> | <hr> | ||
Sold by [[ | Sold by [[Popper]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find like "%Popper%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find like "%Popper%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | <hr> | ||
[[ | [[Circus of the Last Days]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "% | tables=equipment; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find NOT REGEXP "Popper") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find NOT REGEXP "Popper") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 334: | Line 337: | ||
}} | }} | ||
<br> | <br> | ||
{{ImageLocation| | {{ImageLocation|Open Hand Temple.jpg|Open Hand Temple|A temple dedicated to Ilmater, currently grieving the loss of their head priest.<br> | ||
<hr> | <hr> | ||
[[ | [[Open Hand Temple]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = ( | tables=equipment; where = (where_to_find like "%Open Hand Temple%" AND uid != "MAG_OfSharpCaster_Hat" AND uid != "MAG_Projectile_Shoes") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = ( | |tables=weapons; where = (where_to_find like "%Open Hand Temple%" AND uid != "MAG_OfSharpCaster_Hat" AND uid != "MAG_Projectile_Shoes") | ||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | }} | ||
{{ImageLocation|Ironhand_Cave_Location_Blocked.png|Angleiron's Cellar|The [[Clan Ironhand|Ironhand Gnomes]] who escaped the [[Grymforge]] have taken up residence in this cellar.<br> | |||
{{ImageLocation| | |||
<hr> | <hr> | ||
[[ | Sold by [[Bumpnagel]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "% | tables=equipment; where = where_to_find like "%Angleiron's Cellar%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Angleiron's Cellar%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 388: | Line 367: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation| | {{ImageLocation|Wyrm's Crossing Side.jpg|Wyrm's Crossing|Sits between [[Rivington]] and the [[Wyrm's Rock Fortress]], and must be crossed to enter the [[Lower City|City]].<br> | ||
<hr> | <hr> | ||
[[ | Sold by [[Entharl Danthelon]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "% | tables=equipment; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find like "%Entharl Danthelon%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find like "%Entharl Danthelon%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 403: | Line 382: | ||
}} | }} | ||
<hr> | <hr> | ||
[[ | [[Wyrm's Crossing]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "% | tables=equipment; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find NOT REGEXP "Entharl Danthelon") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find NOT REGEXP "Entharl Danthelon") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 416: | Line 395: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation| | {{ImageLocation|Wyrm's Rock Fortress.jpg|Wyrm's Rock Fortress|Connected to the south by [[Wyrm's Crossing]], and the north by the [[Lower City]].<br> | ||
<hr> | <hr> | ||
[[ | Sold by [[Arkleia Oloril]] | ||
<hr> | <hr> | ||
<i>No special equipment</i> | |||
<hr> | <hr> | ||
[[ | [[Wyrm's Rock Fortress]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "% | tables=equipment; where = where_to_find like "%Wyrm's Rock Fortress%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Wyrm's Rock Fortress%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 445: | Line 415: | ||
}} | }} | ||
<br> | <br> | ||
<hr> | <hr> | ||
<hr> | <hr> | ||
'''Lower City''' | |||
<hr> | |||
<hr> | |||
{{ImageLocation|Lower City.jpg|Lower City|The Lower City is accessed after passing through [[Wyrm's Rock Fortress]].<br> | |||
| | |||
<hr> | <hr> | ||
[[ | [[Lower City]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = (where_to_find like "%Forge of the Nine | tables=equipment; where = ( | ||
where_to_find like "%Lower City%" AND | |||
where_to_find NOT REGEXP 'Lower City Sewers' AND | |||
where_to_find NOT REGEXP 'Undercity Ruins' AND | |||
where_to_find NOT REGEXP 'Forge of the Nine' AND | |||
where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | |||
where_to_find NOT REGEXP 'Stormshore Armoury' AND | |||
where_to_find NOT REGEXP 'Sorcerous Sundries' AND | |||
where_to_find NOT REGEXP 'Wine Festival' AND | |||
where_to_find NOT REGEXP "Devil's Fee" AND | |||
where_to_find NOT REGEXP "Philgrave's Mansion" AND | |||
where_to_find NOT REGEXP 'Steel Watch Foundry' AND | |||
where_to_find NOT REGEXP 'Undercity Ruins') | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = (where_to_find like "%Forge of the Nine | |tables=weapons; where = ( | ||
AND rarity != "common" AND legacy IS NULL; | where_to_find like "%Lower City%" AND | ||
where_to_find NOT REGEXP 'Lower City Sewers' AND | |||
where_to_find NOT REGEXP 'Undercity Ruins' AND | |||
where_to_find NOT REGEXP 'Forge of the Nine' AND | |||
where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | |||
where_to_find NOT REGEXP 'Stormshore Armoury' AND | |||
where_to_find NOT REGEXP 'Sorcerous Sundries' AND | |||
where_to_find NOT REGEXP 'Wine Festival' AND | |||
where_to_find NOT REGEXP "Devil's Fee" AND | |||
where_to_find NOT REGEXP "Philgrave's Mansion" AND | |||
where_to_find NOT REGEXP 'Steel Watch Foundry' AND | |||
where_to_find NOT REGEXP 'Undercity Ruins') | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
|format=list | |format=list | ||
Line 473: | Line 459: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation|Stormshore | {{ImageLocation|Stormshore tabernacle.jpg|Stormshore Tabernacle|A house of worship located in the northeastern part of the [[Lower City]], near the Basilisk Gate.<br> | ||
<hr> | <hr> | ||
[[Stormshore Tabernacle]] | |||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = | tables=equipment; where = where_to_find like "%Stormshore Tabernacle%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = | |tables=weapons; where = where_to_find like "%Stormshore Tabernacle%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 487: | Line 473: | ||
|delimiter=<br> | |delimiter=<br> | ||
}} | }} | ||
}} | |||
{{ImageLocation|Elfsong Tavern Street View.jpg|Elfsong Tavern|A tavern located north-west of [[Stormshore Tabernacle]] and the Basilisk Gate [[waypoint]]<br> | |||
<hr> | <hr> | ||
[[Elfsong_Tavern#Elfsong_Tavern_Basement|Elfsong Tavern Basement]] | |||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = | tables=equipment; where = where_to_find like "%Elfsong Tavern Basement%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = | |tables=weapons; where = where_to_find like "%Elfsong Tavern Basement%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 500: | Line 488: | ||
|delimiter=<br> | |delimiter=<br> | ||
}} | }} | ||
<hr> | |||
[[Knights of the Shield Hideout]] | |||
<hr> | |||
[[ | |||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "% | tables=equipment; where = where_to_find like "%Knights of the Shield Hideout%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Knights of the Shield Hideout%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 516: | Line 502: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation|Lower City Sewers North.jpg|Lower City Sewers|Entrances include manhole covers in the city streets, and inside specific buildings.<br> | |||
<hr> | |||
Sold by [[Severn]] | |||
<hr> | |||
< | |||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "%Severn%" | |||
tables=equipment; where = | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "%Severn%" | |||
|tables=weapons; where = | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
Sold by [[Sticky Dondo]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Sticky Dondo%" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "%Sticky Dondo%" | |||
|tables=weapons; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
Sold by [[Voiceless Penitent Bareki]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Bareki%" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "%Bareki%" | |||
|tables=weapons; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
[[Lower City Sewers]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
where_to_find like "%Lower City Sewers%" AND | |||
where_to_find NOT REGEXP "Severn" AND | |||
where_to_find NOT REGEXP "Sticky Dondo" AND | |||
where_to_find NOT REGEXP "Bareki") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = ( | |||
where_to_find like "%Lower City Sewers%" AND | |||
|tables=weapons; where = (where_to_find like "% | where_to_find NOT REGEXP "Severn" AND | ||
where_to_find NOT REGEXP "Sticky Dondo" AND | |||
where_to_find NOT REGEXP "Bareki") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
[[Undercity Ruins]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
where_to_find like "%Undercity Ruins%" AND | |||
where_to_find NOT REGEXP "Severn" AND | |||
where_to_find NOT REGEXP "Sticky Dondo" AND | |||
where_to_find NOT REGEXP "Bareki") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = ( | |||
where_to_find like "%Undercity Ruins%" AND | |||
|tables=weapons; where = where_to_find like "% | where_to_find NOT REGEXP "Severn" AND | ||
where_to_find NOT REGEXP "Sticky Dondo" AND | |||
where_to_find NOT REGEXP "Bareki") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
|format=list | |||
|delimiter=<br> | |||
}} | |||
|tables=equipment; where = where_to_find like "% | }} | ||
<br> | |||
{{ImageLocation|Forge of the Nine.jpg|Forge of the Nine|The outside of the Forge of the Nine. A stone patio is equipped with a forge and smithing station.<br> | |||
<hr> | |||
Sold by [[Dammon]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Forge of the Nine%" AND where_to_find like "%Dammon%") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = (where_to_find like "%Forge of the Nine%" AND where_to_find like "%Dammon%") | |||
|tables=weapons; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
|format=list | |||
|delimiter=<br> | |||
}} | |||
|tables=equipment; where = where_to_find like "% | <hr> | ||
[[Forge of the Nine|Basement]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Forge of the Nine%" AND where_to_find NOT REGEXP 'Dammon') | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = (where_to_find like "%Forge of the Nine%" AND where_to_find NOT REGEXP 'Dammon') | |||
|tables=weapons; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
|format=list | |||
|delimiter=<br> | |||
}} | |||
|tables=equipment; where = where_to_find like "% | }} | ||
{{ImageLocation|Devil's Fee.jpg|Devil's Fee|Owned by [[Helsik]], there are all sorts of devilish artifacts and curios on display around the store.<br> | |||
<hr> | |||
Sold by [[Helsik]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Devil's Fee%" AND where_to_find like "%Helsik%") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = (where_to_find like "%Devil's Fee%" AND where_to_find like "%Helsik%") | |||
|tables=weapons; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
[[Devil's Fee]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Devil's Fee%" AND where_to_find NOT REGEXP "Helsik") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = (where_to_find like "%Devil's Fee%" AND where_to_find NOT REGEXP "Helsik") | |||
AND rarity != "common" AND legacy IS NULL; | |||
|tables=weapons; where = (where_to_find like "% | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
AND rarity != "common" AND legacy IS NULL; | |format=list | ||
fields= | |delimiter=<br> | ||
}} | |||
}} | |||
<br> | |||
|tables=equipment; where = where_to_find like "% | {{ImageLocation|Stormshore Armoury.jpg|Stormshore Armoury|An outdoor smithy with a glowing red hot furnace in the back corner.<br> | ||
<hr> | |||
Sold by [[Gloomy Fentonson]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%") | |||
|tables=weapons; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
|format=list | |||
|delimiter=<br> | |||
}} | |||
|tables=equipment; where = where_to_find like "% | <hr> | ||
Sold by [[Fytz|Fytz The Firecracker]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Fytz%") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Fytz%") | |||
|tables=weapons; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
|format=list | |||
|delimiter=<br> | |||
}} | |||
| | }} | ||
{{ImageLocation|Sorcerous Sundries.jpg|Sorcerous Sundries|A large magical marketplace, and home to the wizard [[Lorroakan]]<br> | |||
<hr> | |||
Sold by [[Lorroakan's Projection]] (or [[Rolan]]) | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
where_to_find like "%Sorcerous Sundries%" AND | |||
where_to_find like "%Sold%" AND | |||
where_to_find like "%Lorroakan's Projection%") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = ( | |||
where_to_find like "%Sorcerous Sundries%" AND | |||
|tables=weapons; where = where_to_find like "% | where_to_find like "%Sold%" AND | ||
where_to_find like "%Lorroakan's Projection%") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
Sold by [[Tolna Tome-Monger]] | |||
<hr> | |||
<i>No special equipment</i> | |||
<hr> | |||
[[Sorcerous Sundries]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
where_to_find like "%Sorcerous Sundries%" AND | |||
where_to_find NOT REGEXP "Sold" AND | |||
where_to_find NOT REGEXP "Sorcerous Vault") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = ( | |||
where_to_find like "%Sorcerous Sundries%" AND | |||
|tables=weapons; where = where_to_find like "% | where_to_find NOT REGEXP "Sold" AND | ||
where_to_find NOT REGEXP "Sorcerous Vault") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
|format=list | |||
|delimiter=<br> | |||
}} | |||
|tables=equipment; where = where_to_find like "% | }} | ||
{{ImageLocation|Ramazith's View.jpg|Ramazith's Tower|The home of the wizard [[Lorroakan]], only accessible from [[Sorcerous Sundries]].<br> | |||
<hr> | |||
[[Ramazith's Tower]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Ramazith's Tower%" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "%Ramazith's Tower%" | |||
|tables=weapons; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
|format=list | |||
|delimiter=<br> | |||
}} | |||
|tables=equipment; where = where_to_find like "% | }} | ||
{{ImageLocation|Sorcerous Vault.webp|Sorcerous Vault|A secret vault within [[Sorcerous Sundries]] accessible from [[Ramazith's Tower]].<br> | |||
<hr> | |||
[[Sorcerous Vault]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Sorcerous Vault%" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "%Sorcerous Vault%" | |||
|tables=weapons; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<br>{{RarityItem|The Tharchiate Codex|20}} | |||
}} | }} | ||
< | <br> | ||
{{ImageLocation|Philgrave's Mansion.jpg|Philgrave's Mansion|Located by the waterfront next to the [[Counting House]] and [[Felogyr's Fireworks]]<br> | |||
<hr> | |||
Sold by [[Mystic Carrion]] | |||
< | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = ( | |||
tables=equipment; where = where_to_find like "% | where_to_find like "%Philgrave's Mansion%" AND | ||
(where_to_find like "%Sold%" OR where_to_find like "%bought%") AND | |||
where_to_find like "%Mystic Carrion%") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = ( | |||
where_to_find like "%Philgrave's Mansion%" AND | |||
|tables=weapons; where = where_to_find like "% | (where_to_find like "%Sold%" OR where_to_find like "%bought%") AND | ||
where_to_find like "%Mystic Carrion%") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item | |format=list | ||
|delimiter=<br> | |||
}} | |||
<hr> | |||
[[Philgrave's Mansion]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
where_to_find like "%Philgrave's Mansion%" AND | |||
where_to_find NOT REGEXP "Sold" AND | |||
where_to_find NOT REGEXP "bought") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = ( | |||
where_to_find like "%Philgrave's Mansion%" AND | |||
where_to_find NOT REGEXP "Sold" AND | |||
where_to_find NOT REGEXP "bought") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
= Equipment By Act and Region = | |||
== <span class="mw-customtoggle-0" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act One == | |||
<div id="mw-customcollapsible-0" class="mw-collapsible mw-collapsed"> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Prologue]]")=Act,CONCAT("[[Nautiloid]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = (where_to_find like "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Prologue]]")=Act,CONCAT("[[Nautiloid]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Ravaged Beach%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Ravaged Beach]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Ravaged Beach%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Ravaged Beach]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Dank Crypt%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Overgrown Ruins]]")=Act,CONCAT("[[Dank Crypt]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Dank Crypt%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Overgrown Ruins]]")=Act,CONCAT("[[Dank Crypt]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Druid Grove]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Druid Grove]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%The Risen Road%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[The Risen Road]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%The Risen Road%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[The Risen Road]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Forest%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Forest]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Forest%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Forest]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Owlbear Nest%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Forest]]")=Act,CONCAT("[[Owlbear Nest]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Forest%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Forest]]")=Act,CONCAT("[[Owlbear Nest]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "%Blighted Village%" | |||
tables=equipment; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Blighted Village]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Blighted Village%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Blighted Village]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = (where_to_find like "% | |tables=equipment; where = (where_to_find like "%Sunlit Wetlands%" OR where_to_find like "%Putrid Bog%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Sunlit Wetlands]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = (where_to_find like "% | |tables=weapons; where = (where_to_find like "%Sunlit Wetlands%" OR where_to_find like "%Putrid Bog%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Sunlit Wetlands]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Goblin Camp%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Goblin Camp]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Goblin Camp%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Goblin Camp]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Waukeen's Rest%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Waukeen's Rest]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Waukeen's Rest%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Waukeen's Rest]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Mountain Pass%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Mountain Pass]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Mountain Pass%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Mountain Pass]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = | |||
|tables=equipment; where = where_to_find like "%Underdark%" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Underdark]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = | |tables=weapons; where = where_to_find like "%Underdark%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Underdark]]")=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 "%Grymforge%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Grymforge]]")=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 "%Grymforge%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Grymforge]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Rosymorn Monastery%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Rosymorn Monastery]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Rosymorn Monastery%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Rosymorn Monastery]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Crèche Y'llek%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Crèche Y'llek]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Crèche Y'llek%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Crèche Y'llek]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | 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% | |||
}} | |||
</div> | |||
== <span class="mw-customtoggle-1" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act Two == | |||
<div id="mw-customcollapsible-1" class="mw-collapsible mw-collapsed"> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Ruined Battlefield%" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Ruined Battlefield]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = | |tables=weapons; where = where_to_find like "%Ruined Battlefield%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Ruined Battlefield]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Last Light Inn%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Last Light Inn]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Last Light Inn%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Last Light Inn]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Reithwin Town%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Reithwin Town]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Reithwin Town%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Reithwin Town]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Moonrise%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Moonrise]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Moonrise%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Moonrise]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Grand Mausoleum%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Grand Mausoleum]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Grand Mausoleum%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Grand Mausoleum]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Gauntlet of Shar%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Gauntlet of Shar]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Gauntlet of Shar%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Gauntlet of Shar]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Shadowfell%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Shadowfell]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Shadowfell%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Shadowfell]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Mind Flayer Colony%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Mind Flayer Colony]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Mind Flayer Colony%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Mind Flayer Colony]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[ | |format=dynamic table | ||
|rows per page=1000 | |||
|hidden fields=Effects, Where To Find, Type, AC, Dmg | |||
|column widths=6%,16%,,,,13%,4%,6% | |||
}} | |||
</div> | |||
== <span class="mw-customtoggle-2" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act Three == | |||
<div id="mw-customcollapsible-2" class="mw-collapsible mw-collapsed"> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Rivington General%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington General]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Rivington General%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington General]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = (where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Requisitioned Barn]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = (where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Requisitioned Barn]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Circus of the Last Days%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Circus of the Last Days]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Circus of the Last Days%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Circus of the Last Days]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Open Hand Temple%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Open Hand Temple]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Open Hand Temple%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Open Hand Temple]]")=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 "%Angleiron's Cellar%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Angleiron's Cellar]]")=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 "%Angleiron's Cellar%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Angleiron's Cellar]]")=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 "%Rivington%" AND | |||
where_to_find NOT REGEXP "Rivington General" AND | |||
where_to_find NOT REGEXP "Ferg Drogher" AND | |||
where_to_find NOT REGEXP "Mattis" AND | |||
where_to_find NOT REGEXP "Circus of the Last Days" AND | |||
where_to_find NOT REGEXP "Open Hand Temple" AND | |||
where_to_find NOT REGEXP "Angleiron's Cellar") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington]]")=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 "%Rivington%" AND | |||
where_to_find NOT REGEXP "Rivington General" AND | |||
where_to_find NOT REGEXP "Ferg Drogher" AND | |||
where_to_find NOT REGEXP "Mattis" AND | |||
where_to_find NOT REGEXP "Circus of the Last Days" AND | |||
where_to_find NOT REGEXP "Open Hand Temple" AND | |||
where_to_find NOT REGEXP "Angleiron's Cellar") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "%Wyrm's Crossing%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Crossing]]")=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 "%Wyrm's Crossing%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Crossing]]")=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 "%Wyrm's Rock Fortress%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Rock Fortress]]")=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 "%Wyrm's Rock Fortress%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Rock Fortress]]")=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 "%Lower City%" AND | |||
where_to_find NOT REGEXP 'Lower City Sewers' AND | |||
where_to_find NOT REGEXP 'Undercity Ruins' AND | |||
where_to_find NOT REGEXP 'Forge of the Nine' AND | |||
where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | |||
where_to_find NOT REGEXP 'Stormshore Armoury' AND | |||
where_to_find NOT REGEXP 'Sorcerous Sundries' AND | |||
where_to_find NOT REGEXP 'Wine Festival' AND | |||
where_to_find NOT REGEXP "Devil's Fee" AND | |||
where_to_find NOT REGEXP "The Counting House" AND | |||
where_to_find NOT REGEXP "Philgrave's Mansion" AND | |||
where_to_find NOT REGEXP 'Steel Watch Foundry' AND | |||
where_to_find NOT REGEXP 'Undercity Ruins') | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City]]")=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 "%Lower City%" AND | ||
where_to_find NOT REGEXP 'Lower City Sewers' AND | |||
where_to_find NOT REGEXP 'Undercity Ruins' AND | |||
where_to_find NOT REGEXP 'Forge of the Nine' AND | |||
where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | |||
where_to_find NOT REGEXP 'Stormshore Armoury' AND | |||
where_to_find NOT REGEXP 'Sorcerous Sundries' AND | |||
where_to_find NOT REGEXP 'Wine Festival' AND | |||
| | where_to_find NOT REGEXP "Devil's Fee" AND | ||
| | where_to_find NOT REGEXP "The Counting House" AND | ||
where_to_find NOT REGEXP "Philgrave's Mansion" AND | |||
where_to_find NOT REGEXP 'Steel Watch Foundry' AND | |||
where_to_find NOT REGEXP 'Undercity Ruins') | |||
| | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City]]")=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 "%Lower City Sewers%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City Sewers]]")=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 "%Lower City Sewers%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City Sewers]]")=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 "%Forge of the Nine%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Forge of the Nine]]")=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 "%Forge of the Nine%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Forge of the Nine]]")=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 "%Stormshore Tabernacle%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Stormshore Tabernacle]]")=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 "%Stormshore Tabernacle%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Stormshore Tabernacle]]")=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 "%Stormshore Armoury%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[Stormshore Armoury]]")=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 "%Stormshore Armoury%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[Stormshore Armoury]]")=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 "%Sorcerous Sundries%" | ||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Sorcerous Sundries]]")=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 "%Sorcerous Sundries%" | ||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Sorcerous Sundries]]")=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 "%Wine Festival%" | ||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wine Festival]]")=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 "%Wine Festival%" | ||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wine Festival]]")=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 "%Philgrave%s Mansion%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=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 "%Philgrave%s Mansion%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=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 "%Devil%Fee%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Devil's Fee]]")=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 "%Devil%Fee%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
|| | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Devil's Fee]]")=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 "%The Counting House%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[The Counting House]]")=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 "%The Counting House%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[The Counting House]]")=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 "%Steel Watch Foundry%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Steel Watch Foundry]]")=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 "%Steel Watch Foundry%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Steel Watch Foundry]]")=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 "%Undercity Ruins%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Undercity Ruins]]")=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 "%Undercity Ruins%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Undercity Ruins]]")=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% | |||
}} | |||
</div> | |||
<!-- | |||
{{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. | |||
== <span class="mw-customtoggle-b0" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act One == | |||
<div id="mw-customcollapsible-b0" class="mw-collapsible mw-collapsed"> | |||
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;" | |||
! 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]]. | |||
|} | |} | ||
</div> | |||
== <span class="mw-customtoggle-b1" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act Two == | |||
<div id="mw-customcollapsible-b1" class="mw-collapsible mw-collapsed"> | |||
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;" | |||
| | ! 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. | |||
|} | |||
</div> | |||
--> | == <span class="mw-customtoggle-b2" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act Three == | ||
< | <div id="mw-customcollapsible-b2" class="mw-collapsible mw-collapsed"> | ||
= | {| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;" | ||
! 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 5 inner ring [[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}} | |||
</div> | |||
= | = Dye Previews = | ||
{ | {| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;" | ||
! style="width: 40%;" | Medium Armour | |||
! style="width: 10%;" | [[File:Dark_Amethyst_Dye_Detail.png|25px|link=https://bg3-dyes.tumblr.com/tagged/medium+armour]] | |||
| | ! style="width: 40%;" | Heavy Armour | ||
! style="width: 10%;" | [[File:Dark_Amethyst_Dye_Detail.png|25px|link=https://bg3-dyes.tumblr.com/tagged/heavy+armour]] | |||
| | |- | ||
| {{ItemIcon|name=Chain Shirt +1|size=25|show_rarity=1}} [[Chain Shirt +1|{{RarityColor|uncommon|Chain Shirt +1}}]] | |||
|| [https://64.media.tumblr.com/46b29ffd14bece381933372cb6a0227b/00edac1c71a28b5f-ab/s1280x1920/644dff86c07dd2ba17b768bfd1120408eccadae2.png Dyes] | |||
|| | |||
{{ | || | ||
{{ | |- | ||
| | | {{ItemIcon|name=Chain Shirt +2|size=25|show_rarity=1}} [[Chain Shirt +1|{{RarityColor|rare|Chain Shirt +2}}]] | ||
| | || [https://64.media.tumblr.com/49c4560a04fc8198830c32ee6c5cae87/28a28e3124da3197-90/s1280x1920/2069c7673e58d43b89f2f6ba61d9f8efaa75e340.png Dyes] | ||
| | || {{ItemIcon|name=Plate Armour +2|size=25|show_rarity=1}} [[Plate Armour +1|{{RarityColor|rare|Plate Armour +2}}]] | ||
| | || [https://64.media.tumblr.com/1646e63dff137f11059102d85bbc45c6/08ccd38d3d0757c6-ee/s1280x1920/de2a864edfc4faa04febb8c721a1a64b89d04cd6.png Dyes] | ||
|- | |||
| {{ItemIcon|name=Dark Justiciar Half-Plate (Very Rare)|size=25|show_rarity=1}} [[Dark Justiciar Half-Plate (Very Rare)|{{RarityColor|very rare|Dark Justiciar Half Plate}}]] | |||
|| [https://64.media.tumblr.com/f1bfc59b449900e95c0fe37bb0430560/1a42314c8972fc71-02/s1280x1920/4f0e185e431ad6f6d4f1a286c03b799330042751.png Dyes] | |||
{{ | || {{ItemIcon|name=Blackguard's Plate|size=25|show_rarity=1}} [[Blackguard's Plate|{{RarityColor|very rare|Blackguard's Plate}}]] | ||
{{ | || [https://64.media.tumblr.com/b1ce0174ed6967db06d947f2e0abe3ff/d3e2e9ec4d78abec-5a/s1280x1920/26dcb8a9b4fb177c8c464b79af0e9d6c91d612c6.png Dyes] | ||
|} | |||
| | |||
| | |||
| | <!-- class="mw-collapsible mw-collapsed"--> | ||
}} | <!-- | ||
}} | {{Tab | ||
|one=The Dark Urge | |||
|one-name=Story Spoiler Page | |||
{{ | |two=The Dark Urge (Origin) | ||
| | |two-name=Origin Page | ||
| | }} | ||
| | |||
| | {{Infobox | ||
}} | |name = Infobox/doc | ||
|bodystyle = | |||
{{ | |||
{{ | |||
| | |||
| | |||
| | |||
=== | |titlestyle = | ||
|abovestyle = background:#cfc; | |||
|subheaderstyle = | |||
| | |title = Test Infobox | ||
| | |above = Above text | ||
| | |subheader = Subheader above image | ||
|subheader2 = Second subheader | |||
|imagestyle = | |||
|captionstyle = | |||
|image = [[File:Example-serious.jpg|200px|alt=Example alt text]] | |||
|caption = Caption displayed below File:Example-serious.jpg | |||
|headerstyle = background:#ccf; | |||
|labelstyle = background:#ddf; | |||
|datastyle = | |||
|header1 = Header defined alone | |||
| | | label1 = | ||
| data1 = | |||
|header2 = | |||
| label2 = Label defined alone does not display (needs data, or is suppressed) | |||
| data2 = | |||
|header3 = | |||
| label3 = | |||
| data3 = Data defined alone | |||
|header4 = All three defined (header, label, data, all with same number) | |||
| label4 = does not display (same number as a header) | |||
| data4 = does not display (same number as a header) | |||
|header5 = | |||
| label5 = Label and data defined (label) | |||
| data5 = Label and data defined (data) | |||
|belowstyle = background:#ddf; | |||
|below = Below text | |||
}} | }} | ||
== | {| class="mw-collapsible mw-collapsed wikitable" style="margin-left:1.6em;" | ||
{ | |- | ||
! Header 1 | |||
| | ! Header 2 | ||
| | |- | ||
| | | row 1, cell 1 | ||
| row 1, cell 2 | |||
|- | |||
| row 2, cell 1 | |||
| row 2, cell 2 | |||
|} | |||
--> | |||
<!-- | |||
{| class="wikitable" | |||
|+ Equipment | |||
! [[File:Helmet_Icon.png|50px|link=Headwear]] | |||
| | ! | ||
! | |||
|- | |||
! [[File:Cloak_B_Unfaded_Icon.png|50px|link=Cloaks]] | |||
! | |||
{{#cargo_query: tables = equipment | ! | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br> | |- | ||
| order by = rarity_order | ! [[File:Plate_Armour_Icon.png|50px|link=Armour]] | ||
| where = | ! | ||
! [[File:Amulet_Necklace_A_Gold_A_1_Unfaded_Icon.png|50px|link=Amulets]] | |||
|- | |||
! [[File:Metallic_Gloves_Icon.png|50px|link=Handwear]] | |||
! | |||
! [[File:Ring_A_Simple_Gold_Unfaded_Icon.png|50px|link=Rings]] | |||
|- | |||
! [[File:Metallic_Boots_Icon.png|50px|link=Footwear]] | |||
! | |||
! | |||
|- | |||
! [[File:Longsword_Item_Icon.png|50px|link=Weapons]] | |||
! [[File:Item_WPN_HUM_Shield_D_0_Unfaded_Icon.png|50px|link=Shields]] | |||
! [[File:Longbow_Item_Icon.png|50px|link=Bow]] | |||
|} | |||
= Resistance Equipment = | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = rarity != "common" AND special like "%Resistance%" AND legacy IS NULL | |||
| format = table | | format = table | ||
}} | }} | ||
= Equipment By Build = | |||
=== [[Radiant]] Compound Query (testing)=== | |||
== | {{#cargo_compound_query: | ||
{{ | tables=equipment; | ||
[[File: | where=rarity != "common" AND special like "%Radiant%" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | |||
|tables=weapons; | |||
=== | where=rarity != "common" AND special like "%Radiant%" AND legacy IS NULL | ||
|format=table | |||
}} | |||
=== [[Radiant]] === | |||
{{#cargo_query: tables = equipment | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br> | | 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 = rarity != "common" AND special like "%Radiant%" AND legacy IS NULL | ||
| format = table | | format = table | ||
}} | }} | ||
{{#cargo_query: tables = weapons | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = rarity != "common" AND special like "%Radiant%" AND legacy IS NULL | |||
| format = table | |||
}} | }} | ||
=== [[Necrotic]] === | |||
{{SpoilerBox| | |||
=== [[ | |||
{{SpoilerBox | |||
{{#cargo_query: tables = equipment | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br> | | 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 = rarity != "common" AND special like "%Necrotic%" AND legacy IS NULL | ||
| format = table | | format = table | ||
}} | }} | ||
{{#cargo_query: tables = weapons | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | |||
{{#cargo_query: tables = | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br> | |||
| order by = rarity_order | | order by = rarity_order | ||
| where = | | where = rarity != "common" AND special like "%Necrotic%" AND legacy IS NULL | ||
| format = table | | format = table | ||
}} | }} | ||
}} | }} | ||
=== [[ | |||
{{SpoilerBox|act= | --> | ||
{{#cargo_query: tables = | <!-- | ||
= Equipment By Act = | |||
Equipment lists separated by Act. | |||
== Act One == | |||
{{SpoilerBox|act=1|custom=Equipment for Act One.| | |||
[[File:Chapter 1.webp|500px|link=Act One]] | |||
{{SpoilerBox|act=1|custom=[[Headwear]].| | |||
{{#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 = | | order by = rarity_order | ||
| where = | | where = (type = "Helmets" OR type = "Headwear") AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL | ||
| format = table | | format = table | ||
}} | }} | ||
}} | }} | ||
{{SpoilerBox|act=1|custom=[[Cloaks]].| | |||
{{SpoilerBox|act= | |||
{{#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 = type = "Cloaks" AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL | ||
| format = table | |||
}} | |||
}} | |||
{{SpoilerBox|act=1|custom=[[Armour]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = type like "% Armour%" AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL | |||
| format = table | |||
}} | |||
}} | |||
{{SpoilerBox|act=1|custom=[[Handwear]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = type = "Gloves" AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL | |||
| format = table | |||
}} | |||
}} | |||
{{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 legacy IS NULL | ||
AND ( | AND ( | ||
where_to_find like "% | 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 | |||
}} | |||
}} | |||
}} | |||
== Act Two == | |||
{{SpoilerBox|act=2|custom=Equipment for Act Two.| | |||
[[File:Chapter 2.webp|500px|link=Act Two]] | |||
=== [[Headwear]] === | |||
{{SpoilerBox|act=2|custom=[[Headwear]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = (type = "Helmets" OR type = "Headwear") AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL | |||
| format = table | |||
}} | |||
}} | |||
=== [[Cloaks]] === | |||
{{SpoilerBox|act=2|custom=[[Cloaks]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = type = "Cloaks" AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL | |||
| format = table | |||
}} | |||
}} | |||
=== [[Armour]] === | |||
{{SpoilerBox|act=2|custom=[[Armour]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = type like "% Armour%" AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL | |||
| format = table | |||
}} | |||
}} | |||
=== [[Handwear]] === | |||
{{SpoilerBox|act=2|custom=[[Handwear]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = type = "Gloves" AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL | |||
| format = table | |||
}} | |||
}} | |||
=== [[Weapons]] === | |||
{{SpoilerBox|act=2|custom=[[Weapons]].| | |||
{{#cargo_query: tables = weapons | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = type | |||
| where = | |||
rarity != "common" | |||
AND legacy IS NULL | |||
AND ( | |||
where_to_find like "%Ruined Battlefield%" OR | |||
where_to_find like "%Last Light Inn%" OR | |||
where_to_find like "%Reithwin Town%" OR | |||
where_to_find like "%Moonrise%" OR | |||
where_to_find like "%Grand Mausoleum%" OR | |||
where_to_find like "%Gauntlet of Shar%" OR | |||
where_to_find like "%Shadowfell%" | |||
) | |||
| format = table | |||
}} | |||
}} | |||
=== [[Shields]] === | |||
{{SpoilerBox|act=2|custom=[[Shields]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = | |||
type = "Shields" | |||
AND rarity != "common" | |||
AND legacy IS NULL | |||
AND ( | |||
where_to_find like "%Ruined Battlefield%" OR | |||
where_to_find like "%Last Light Inn%" OR | |||
where_to_find like "%Reithwin Town%" OR | |||
where_to_find like "%Moonrise%" OR | |||
where_to_find like "%Grand Mausoleum%" OR | |||
where_to_find like "%Gauntlet of Shar%" OR | |||
where_to_find like "%Shadowfell%" | |||
) | ) | ||
| format = table | | format = table | ||
Line 1,691: | Line 1,845: | ||
}} | }} | ||
=== [[Amulets]] === | === [[Amulets]] === | ||
{{SpoilerBox|act=3|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 = | ||
type = "Amulets" | type = "Amulets" | ||
AND rarity != "common" | AND rarity != "common" | ||
AND legacy IS NULL | AND legacy IS NULL | ||
AND ( | AND ( | ||
where_to_find like "%Rivington%" | where_to_find like "%Ruined Battlefield%" OR | ||
) | where_to_find like "%Last Light Inn%" OR | ||
| format = table | where_to_find like "%Reithwin Town%" OR | ||
}} | where_to_find like "%Moonrise%" OR | ||
}} | where_to_find like "%Grand Mausoleum%" OR | ||
=== [[Rings]] === | where_to_find like "%Gauntlet of Shar%" OR | ||
{{SpoilerBox|act=3|custom=[[Rings]].| | where_to_find like "%Shadowfell%" | ||
{{#cargo_query: tables = equipment | ) | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | | format = table | ||
| order by = rarity_order | }} | ||
| where = | }} | ||
type = "Rings" | === [[Rings]] === | ||
AND rarity != "common" | {{SpoilerBox|act=2|custom=[[Rings]].| | ||
AND legacy IS NULL | {{#cargo_query: tables = equipment | ||
AND ( | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
where_to_find like "%Rivington%" | | order by = rarity_order | ||
) | | where = | ||
| format = table | type = "Rings" | ||
}} | AND rarity != "common" | ||
AND legacy IS NULL | |||
AND ( | |||
where_to_find like "%Ruined Battlefield%" OR | |||
where_to_find like "%Last Light Inn%" OR | |||
where_to_find like "%Reithwin Town%" OR | |||
where_to_find like "%Moonrise%" OR | |||
where_to_find like "%Grand Mausoleum%" OR | |||
where_to_find like "%Gauntlet of Shar%" OR | |||
where_to_find like "%Shadowfell%" | |||
) | |||
| format = table | |||
}} | |||
}} | |||
}} | |||
== Act Three == | |||
{{SpoilerBox|act=3|custom=Equipment for Act Three.| | |||
[[File:Chapter 3.webp|500px|link=Act Three]] | |||
=== [[Headwear]] === | |||
{{SpoilerBox|act=3|custom=[[Headwear]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = (type = "Helmets" OR type = "Headwear") AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL | |||
| format = table | |||
}} | |||
}} | |||
=== [[Cloaks]] === | |||
{{SpoilerBox|act=3|custom=[[Cloaks]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = type = "Cloaks" AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL | |||
| format = table | |||
}} | |||
}} | |||
=== [[Armour]] === | |||
{{SpoilerBox|act=3|custom=[[Armour]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = type like "% Armour%" AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL | |||
| format = table | |||
}} | |||
}} | |||
=== [[Handwear]] === | |||
{{SpoilerBox|act=3|custom=[[Handwear]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = type = "Gloves" AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL | |||
| format = table | |||
}} | |||
}} | |||
=== [[Weapons]] === | |||
{{SpoilerBox|act=3|custom=[[Weapons]].| | |||
{{#cargo_query: tables = weapons | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = type | |||
| where = | |||
rarity != "common" | |||
AND legacy IS NULL | |||
AND ( | |||
where_to_find like "%Rivington%" | |||
) | |||
| format = table | |||
}} | |||
}} | |||
=== [[Shields]] === | |||
{{SpoilerBox|act=3|custom=[[Shields]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = | |||
type = "Shields" | |||
AND rarity != "common" | |||
AND legacy IS NULL | |||
AND ( | |||
where_to_find like "%Rivington%" | |||
) | |||
| format = table | |||
}} | |||
}} | |||
=== [[Amulets]] === | |||
{{SpoilerBox|act=3|custom=[[Amulets]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = | |||
type = "Amulets" | |||
AND rarity != "common" | |||
AND legacy IS NULL | |||
AND ( | |||
where_to_find like "%Rivington%" | |||
) | |||
| format = table | |||
}} | |||
}} | |||
=== [[Rings]] === | |||
{{SpoilerBox|act=3|custom=[[Rings]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = | |||
type = "Rings" | |||
AND rarity != "common" | |||
AND legacy IS NULL | |||
AND ( | |||
where_to_find like "%Rivington%" | |||
) | |||
| format = table | |||
}} | |||
}} | |||
}} | |||
--> | |||
= Stats Equipment = | |||
{{ImageLocation|Strength_Score_Icon.png|Strength| | |||
<hr> | |||
'''Bonus''' | |||
<hr> | |||
{{RarityItem|Gauntlets of Hill Giant Strength|20}} | |||
{{RarityItem|The Mighty Cloth|20}} | |||
<hr> | |||
'''Advantage''' | |||
<hr> | |||
{{RarityItem|The Mighty Cloth|20}} | |||
}} | |||
{{ImageLocation|Dexterity_Score_Icon.png|Dexterity| | |||
<hr> | |||
'''Bonus''' | |||
<hr> | |||
{{RarityItem|Gloves of Dexterity|20}}<br> | |||
{{RarityItem|The Graceful Cloth|20}} | |||
<hr> | |||
'''Advantage''' | |||
<hr> | |||
{{RarityItem|The Graceful Cloth|20}} | |||
}} | |||
{{ImageLocation|Intelligence_Score_Icon.png|Intelligence| | |||
<hr> | |||
'''Bonus''' | |||
<hr> | |||
{{RarityItem|Warped Headband of Intellect|20}} | |||
}} | |||
<hr> | |||
{{ImageLocation|Stealth_Icon.png|Stealth|Dexterity | |||
<hr> | |||
'''Bonus''' | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (special like "%Stealth%" AND special NOT REGEXP "Advantage" AND special NOT REGEXP "Disadvantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (special like "%Stealth%" AND special NOT REGEXP "Advantage" AND special NOT REGEXP "Disadvantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
'''Advantage''' | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (special like "%Stealth%" AND special like "%Advantage%" AND special NOT REGEXP "Disadvantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (special like "%Stealth%" AND special like "%Advantage%" AND special NOT REGEXP "Disadvantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
'''No Disadvantage''' | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (special like "%Stealth%" AND special like "%Disadvantage%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (special like "%Stealth%" AND special like "%Disadvantage%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Sleight_of_Hand_Icon.png|Sleight of Hand|Dexterity | |||
<hr> | |||
'''Bonus''' | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (special like "%Sleight%" AND special NOT REGEXP "Advantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (special like "%Sleight%" AND special NOT REGEXP "Advantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
'''Advantage''' | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (special like "%Sleight%" AND special like "%Advantage%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (special like "%Sleight%" AND special like "%Advantage%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Arcana_Icon.png|Arcana|Intelligence | |||
<hr> | |||
'''Bonus''' | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (special like "%Arcana%" AND special NOT REGEXP "Advantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (special like "%Arcana%" AND special NOT REGEXP "Advantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | }} | ||
}} | }} | ||
[[Template:ImageLocation]] | [[Template:ImageLocation]] | ||
[[Special:CargoTables]] [[Special:Drilldown]] | [[Special:CargoTables]] [[Special:Drilldown]] | ||
{{Gameplay mechanics}} | {{Gameplay mechanics}} |