User:Korgat: Difference between revisions
(9 intermediate revisions by the same user not shown) | |||
Line 203: | Line 203: | ||
== [[Act Three]] == | == [[Act Three]] == | ||
<br> | |||
<hr> | |||
<hr> | |||
'''Wyrm's Crossing''' | |||
<hr> | |||
<hr> | |||
{{ImageLocation|Rivington.jpg|Rivington|The southern-most district of Baldur's Gate, located south of [[Wyrm's Crossing]].<br> | {{ImageLocation|Rivington.jpg|Rivington|The southern-most district of Baldur's Gate, located south of [[Wyrm's Crossing]].<br> | ||
<hr> | <hr> | ||
Line 409: | Line 415: | ||
}} | }} | ||
<br> | <br> | ||
<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> | {{ImageLocation|Lower City.jpg|Lower City|The Lower City is accessed after passing through [[Wyrm's Rock Fortress]].<br> | ||
<hr> | <hr> | ||
Line 603: | Line 614: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation| | {{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> | <hr> | ||
Sold by [[ | Sold by [[Helsik]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = (where_to_find like "% | 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=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 "%Devil's Fee%" AND where_to_find like "%Helsik%") | ||
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 618: | Line 629: | ||
}} | }} | ||
<hr> | <hr> | ||
[[Devil's Fee]] | |||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = (where_to_find like "% | 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=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 "%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=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 631: | Line 642: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation| | <br> | ||
{{ImageLocation|Stormshore Armoury.jpg|Stormshore Armoury|An outdoor smithy with a glowing red hot furnace in the back corner.<br> | |||
<hr> | <hr> | ||
Sold by [[ | Sold by [[Gloomy Fentonson]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = ( | 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=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 Armoury%" AND where_to_find like "%Gloomy Fentonson%") | ||
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 | ||
Line 652: | Line 658: | ||
}} | }} | ||
<hr> | <hr> | ||
Sold by [[ | Sold by [[Fytz|Fytz The Firecracker]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = ( | 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=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 Armoury%" AND where_to_find like "%Fytz%") | ||
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 673: | Line 671: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation| | {{ImageLocation|Sorcerous Sundries.jpg|Sorcerous Sundries|A large magical marketplace, and home to the wizard [[Lorroakan]]<br> | ||
<hr> | <hr> | ||
Sold by [[ | Sold by [[Lorroakan's Projection]] (or [[Rolan]]) | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = ( | tables=equipment; where = ( | ||
where_to_find like "% | where_to_find like "%Sorcerous Sundries%" AND | ||
where_to_find like "%Sold%" AND | |||
where_to_find like "% | where_to_find like "%Lorroakan's Projection%") | ||
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 "% | where_to_find like "%Sorcerous Sundries%" AND | ||
where_to_find like "%Sold%" AND | |||
where_to_find like "% | where_to_find like "%Lorroakan's Projection%") | ||
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 694: | Line 692: | ||
}} | }} | ||
<hr> | <hr> | ||
[[ | Sold by [[Tolna Tome-Monger]] | ||
<hr> | |||
<i>No special equipment</i> | |||
<hr> | |||
[[Sorcerous Sundries]] | |||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = ( | tables=equipment; where = ( | ||
where_to_find like "% | where_to_find like "%Sorcerous Sundries%" AND | ||
where_to_find NOT REGEXP "Sold" AND | where_to_find NOT REGEXP "Sold" AND | ||
where_to_find NOT REGEXP " | where_to_find NOT REGEXP "Sorcerous Vault") | ||
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 "% | where_to_find like "%Sorcerous Sundries%" AND | ||
where_to_find NOT REGEXP "Sold" AND | where_to_find NOT REGEXP "Sold" AND | ||
where_to_find NOT REGEXP " | where_to_find NOT REGEXP "Sorcerous Vault") | ||
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 713: | Line 715: | ||
}} | }} | ||
}} | }} | ||
{{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: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "%Ramazith's Tower%" | |||
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 "%Ramazith's Tower%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
|tables=weapons; where = | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
AND rarity != "common" AND legacy IS NULL; | |format=list | ||
fields= | |delimiter=<br> | ||
}} | |||
}} | |||
{{ImageLocation|Sorcerous Vault.webp|Sorcerous Vault|A secret vault within [[Sorcerous Sundries]] accessible from [[Ramazith's Tower]].<br> | |||
|tables=equipment; where = where_to_find like "% | <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> | |||
}} | |||
|tables=equipment; where = where_to_find like "% | <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: | |||
tables=equipment; where = ( | |||
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= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
|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; | 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 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= | 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("[[ | 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("[[ | 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 = | |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 = | |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 "% | |tables=equipment; where = where_to_find like "%Blighted Village%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act One]]")=Act,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("[[Act One]]")=Act,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 "%Sunlit Wetlands%" OR where_to_find like "%Putrid Bog%") | |||
|tables=equipment; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act One]]")=Act,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("[[Act One]]")=Act,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("[[Act One]]")=Act,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("[[Act One]]")=Act,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("[[Act One]]")=Act,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("[[Act One]]")=Act,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("[[Act One]]")=Act,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("[[Act One]]")=Act,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 = where_to_find like "%Underdark%" | |||
tables=equipment; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | 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 = where_to_find like "% | |tables=weapons; where = where_to_find like "%Underdark%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | 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, 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 "%Grymforge%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | 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, 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 "%Grymforge%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | 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 | ||
|tables=equipment; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | |format=dynamic table | ||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[ | |rows per page=1000 | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |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; | |||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Ruined Battlefield]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | 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 "%Ruined Battlefield%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[ | 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 Two]]")=Act,CONCAT("[[ | 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 Two]]")=Act,CONCAT("[[ | 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 Two]]")=Act,CONCAT("[[ | 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 Two]]")=Act,CONCAT("[[ | 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 Two]]")=Act,CONCAT("[[ | 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 Two]]")=Act,CONCAT("[[ | 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 "%Grand Mausoleum%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Grand Mausoleum]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
tables=equipment; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[ | |||
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 = | |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("[[ | 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 = | |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("[[ | 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("[[ | 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("[[ | 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("[[ | 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("[[ | 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("[[Rivington]]")=Act,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("[[Rivington]]")=Act,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 = ( | |tables=equipment; where = (where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%") | ||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Requisitioned Barn]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[ | |||
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 "%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("[[Rivington]]")=Act,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("[[ | 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, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = | |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("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Angleiron's Cellar]]")=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 "%Angleiron's Cellar%" | ||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Angleiron's Cellar]]")=Location, | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[ | |||
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 "%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("[[ | 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, 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%" 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("[[ | 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 "% | |tables=equipment; where = where_to_find like "%Wyrm's Crossing%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Crossing]]")=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 "%Wyrm's Crossing%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Crossing]]")=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 "%Wyrm's Rock Fortress%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Rock Fortress]]")=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 "%Wyrm's Rock Fortress%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Rock Fortress]]")=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 "%Stormshore Armoury | |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; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City]]")=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 "%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; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City]]")=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 "%Lower City Sewers%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City Sewers]]")=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 "%Lower City Sewers%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City Sewers]]")=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 "%Forge of the Nine%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Forge of the Nine]]")=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 "%Forge of the Nine%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Forge of the Nine]]")=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 "%Stormshore Tabernacle%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Stormshore Tabernacle]]")=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 "%Stormshore Tabernacle%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Stormshore Tabernacle]]")=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 "%Stormshore Armoury%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[ | fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[Stormshore Armoury]]")=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 "%Stormshore Armoury%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[ | fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[Stormshore Armoury]]")=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 "%Sorcerous Sundries%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Sorcerous Sundries]]")=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 "%Sorcerous Sundries%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Sorcerous Sundries]]")=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 "%Wine Festival%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wine Festival]]")=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 "%Wine Festival%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wine Festival]]")=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 "%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 | |||
= | |||
== <span class="mw-customtoggle-b0" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act One == | |tables=equipment; where = where_to_find like "%Undercity Ruins%" | ||
<div id="mw-customcollapsible-b0" class="mw-collapsible mw-collapsed"> | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Undercity Ruins]]")=Location, | |||
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;" | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
! style="width: 14%;" | Region | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
! style="width: 17%;" | Location | |tables=weapons; where = where_to_find like "%Undercity Ruins%" | ||
! style="width: 21%;" | Bonus | AND rarity != "common" AND legacy IS NULL; | ||
! style="width: 48%;" | Description | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Undercity Ruins]]")=Location, | ||
|- | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
| <!-- Region -->[[Blighted Village]] | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|| <!-- Location -->[[Apothecary's Cellar]] | |||
|| <!-- Bonus -->{{SAI|Forbidden Knowledge}} | |||
|| <!-- Description -->Gain +1 bonus to {{Ability|Wisdom}} {{SavingThrow}}s and [[Ability Checks]]. | |format=dynamic table | ||
|- | |rows per page=1000 | ||
| <!-- Region -->[[Blighted Village]] | |hidden fields=Effects, Where To Find, Type, AC, Dmg | ||
|| <!-- Location -->[[Apothecary's Cellar]] | |column widths=6%,16%,,,,13%,4%,6% | ||
|| <!-- Bonus -->{{SAI|Speak with Dead}} | }} | ||
|| <!-- Description -->Gain {{SAI|Speak with Dead}} spell once per long rest from [[Necromancy of Thay]]. | </div> | ||
|- | |||
| <!-- Region -->[[Goblin Camp]] | <!-- | ||
|| <!-- Location -->[[Shattered Sanctum#Centre|Shattered Sanctum Centre]] | {{WeaponsTableHeader}} | ||
|| <!-- Bonus -->[[File:Absolute_symbol.png|25px]][[Absolute's Brand]] | {{#cargo_query: tables = weapons | ||
|| <!-- Description -->Gain the use of unique special effects on [[:Category:Absolute_Equipment|Absolute Equipment]].<br>Gain unique dialogue options with followers of the [[Absolute]]. | | 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]] | | <!-- Region -->[[Goblin Camp]] | ||
Line 1,895: | Line 1,969: | ||
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 "%Rivington%" | ||
) | ) | ||
| format = table | | format = table | ||
}} | }} | ||
}} | }} | ||
=== [[Rings]] === | === [[Rings]] === | ||
{{SpoilerBox|act=3|custom=[[Rings]].| | {{SpoilerBox|act=3|custom=[[Rings]].| | ||
{{#cargo_query: tables = equipment | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | | order by = rarity_order | ||
| where = | | where = | ||
type = "Rings" | type = "Rings" | ||
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 "%Rivington%" | ||
) | ) | ||
| format = table | | format = table | ||
}} | }} | ||
}} | }} | ||
}} | }} | ||
--> | --> | ||
= Stats Equipment = | = Stats Equipment = | ||
{{ImageLocation| | {{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: | {{#cargo_compound_query: | ||
tables=equipment; where = (special like "% | tables=equipment; where = (special like "%Arcana%" AND special NOT REGEXP "Advantage") | ||
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 = (special like "% | |tables=weapons; where = (special like "%Arcana%" AND special NOT REGEXP "Advantage") | ||
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 1,935: | Line 2,110: | ||
}} | }} | ||
}} | }} | ||
[[Template:ImageLocation]] | [[Template:ImageLocation]] | ||
[[Special:CargoTables]] [[Special:Drilldown]] | [[Special:CargoTables]] [[Special:Drilldown]] | ||
{{Gameplay mechanics}} | {{Gameplay mechanics}} |
Latest revision as of 05:39, 19 February 2024
Chronology[edit | edit source]
Act One[edit | edit source]
The player arrives on the Nautiloid immediately after character creation.
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark")
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
The remnants of what appears to have once been a chapel, eroded by time.
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Dank Crypt%"
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
The Emerald Grove, also known as Silvanus' Grove and Druid's Grove.
Sold by Arron
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (
(where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND where_to_find like "%Arron%") AND where_to_find NOT REGEXP "Strange Ox" AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
Sold by Dammon
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (
(where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND where_to_find like "%Dammon%") AND where_to_find NOT REGEXP "Strange Ox" AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
Sold by Auntie Ethel
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__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 ORDER BY `type` LIMIT 100
Sold by Volo
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__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 ORDER BY `type` LIMIT 100
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__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 ORDER BY `type` LIMIT 100
Forest is a sub-area of the Wilderness. It is found west of the Emerald Grove.
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Forest%"
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Owlbear Nest%"
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
The Risen Road is a long stretch of road that connects Elturel and Baldur's Gate.
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Risen Road%"
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
An isolated wizard tower deep in the Underdark protected by Arcane Cannons
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Arcane Tower%"
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
Act Two[edit | edit source]
The Thorm family mausoleum, resting place of Melodia Thorm and entrance to the Gauntlet of Shar
Gauntlet of Shar
Act Three[edit | edit source]
Wyrm's Crossing
The southern-most district of Baldur's Gate, located south of Wyrm's Crossing.
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__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 ORDER BY `type` LIMIT 100
The general store in Rivington, run by a Dragonborn Exxvikyap.
Sold by Exxvikyap
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__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 ORDER BY `type` LIMIT 100
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__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 ORDER BY `type` LIMIT 100
The Requisitioned Barn is a donation center for refugees heading to Baldur's Gate.
Sold by Ferg Drogher
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Ferg Drogher%")
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
Sold by Mattis
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Mattis%Rivington%")
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
An extraplanar circus which moves from plane to plane, "thrilling all" who stop by.
Sold by Popper
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Circus of the Last Days%" AND where_to_find like "%Popper%")
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__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 ORDER BY `type` LIMIT 100
A temple dedicated to Ilmater, currently grieving the loss of their head priest.
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__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 ORDER BY `type` LIMIT 100
The Ironhand Gnomes who escaped the Grymforge have taken up residence in this cellar.
Sold by Bumpnagel
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Angleiron's Cellar%"
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
Sits between Rivington and the Wyrm's Rock Fortress, and must be crossed to enter the City.
Sold by Entharl Danthelon
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Wyrm's Crossing%" AND where_to_find like "%Entharl Danthelon%")
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Wyrm's Crossing%" AND where_to_find NOT REGEXP "Entharl Danthelon")
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
Connected to the south by Wyrm's Crossing, and the north by the Lower City.
Sold by Arkleia Oloril
No special equipment
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Wyrm's Rock Fortress%"
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
Lower City
The Lower City is accessed after passing through Wyrm's Rock Fortress.
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__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 "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 ORDER BY `type` LIMIT 100
A house of worship located in the northeastern part of the Lower City, near the Basilisk Gate.
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Stormshore Tabernacle%"
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
A tavern located north-west of Stormshore Tabernacle and the Basilisk Gate waypoint
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Elfsong Tavern Basement%"
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Knights of the Shield Hideout%"
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
Entrances include manhole covers in the city streets, and inside specific buildings.
Sold by Severn
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Severn%"
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
Sold by Sticky Dondo
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Sticky Dondo%"
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
Sold by Voiceless Penitent Bareki
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Bareki%"
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` 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 ORDER BY `type` LIMIT 100
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` 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 ORDER BY `type` LIMIT 100
The outside of the Forge of the Nine. A stone patio is equipped with a forge and smithing station.
Sold by Dammon
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Forge of the Nine%" AND where_to_find like "%Dammon%")
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Forge of the Nine%" AND where_to_find NOT REGEXP 'Dammon')
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
Owned by Helsik, there are all sorts of devilish artifacts and curios on display around the store.
Sold by Helsik
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Devil's Fee%" AND where_to_find like "%Helsik%")
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Devil's Fee%" AND where_to_find NOT REGEXP "Helsik")
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
An outdoor smithy with a glowing red hot furnace in the back corner.
Sold by Gloomy Fentonson
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%")
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
Sold by Fytz The Firecracker
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Fytz%")
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
A large magical marketplace, and home to the wizard Lorroakan
Sold by Lorroakan's Projection (or Rolan)
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` 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 ORDER BY `type` LIMIT 100
Sold by Tolna Tome-Monger
No special equipment
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` 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 ORDER BY `type` LIMIT 100
The home of the wizard Lorroakan, only accessible from Sorcerous Sundries.
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Ramazith's Tower%"
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
A secret vault within Sorcerous Sundries accessible from Ramazith's Tower.
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE where_to_find like "%Sorcerous Vault%"
AND rarity != "common" AND legacy IS NULL ORDER BY `type` LIMIT 100
Located by the waterfront next to the Counting House and Felogyr's Fireworks
Sold by Mystic Carrion
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__weapons` WHERE (
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 ORDER BY `type` LIMIT 100
Function: CargoSQLQuery::run Query: SELECT CONCAT("File:", image, "", _pageName,"") AS `Item` FROM `cargo__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 ORDER BY `type` LIMIT 100
Equipment By Act and Region[edit | edit source]
[Show/hide] Act One[edit | edit source]
[Show/hide] Act Two[edit | edit source]
[Show/hide] Act Three[edit | edit source]
High Utility Permanent Bonuses[edit | edit source]
See Permanent Bonuses or Permanent bonus table for a complete list of bonuses.
[Show/hide] Act One[edit | edit source]
[Show/hide] Act Two[edit | edit source]
Region | Location | Bonus | Description |
---|---|---|---|
Ruined Battlefield | Kar'niss | Gain immunity to the . | |
Moonrise Towers | Main Floor | Potion of Everlasting Vigour | Gain +2 . |
Moonrise Towers | Mind Flayer Colony | [note 2] | Gain Advantage on Saving throws. |
Moonrise Towers | Gain a charge of Bardic Inspiration that is stronger than usual (1d12). | ||
Reithwin Town | Arabella | Entangle an Undead or shadow creature until long rest. |
[Show/hide] Act Three[edit | edit source]
Region | Location | Bonus | Description |
---|---|---|---|
Wyrm's Lookout | Astral Plane | Gain all 5 inner ring Tier 1 Illithid Powers. Gain access to Tier 3 Illithid Powers. Gain . | |
Rivington | Circus of the Last Days | Gain a +1d4 bonus to Attack rolls and Saving throws. | |
Lower City | Crimson Draughts | Your blood is now highly flammable and will explode on contact with fire. | |
Lower City | House of Grief | Patriar's Memory | Gain +1 . |
Lower City | House of Grief | <Stolen> Memory | Gain +2 to an Ability Score of your choice. |
Lower City | Ramazith's Tower | Create 4 ghouls that fight alongside you. | |
Lower City | Ramazith's Tower | Gain -5 and a sickly green aura. | |
Lower City | Ramazith's Tower | Gain immediately and also once after every Long Rest. | |
Lower City | Steel Watch Foundry | Slayer Knowledge | Gain Advantage on Saving Throws against being by a Bhaalspawn Slayer |
Dye Previews[edit | edit source]
Medium Armour | Heavy Armour | ||
---|---|---|---|
Chain Shirt +1 | Dyes | ||
Chain Shirt +2 | Dyes | Plate Armour +2 | Dyes |
Dark Justiciar Half Plate | Dyes | Blackguard's Plate | Dyes |
Stats Equipment[edit | edit source]
Dexterity
Bonus
Shadeclinger Armour
Drow Studded Leather Armour
Smuggler's Ring
Gloomstrand Shield
Advantage
Elegant Studded Leather
Assassin's Shortsword
No Disadvantage
Dexterity
Bonus
Winkling Gloves
Dark Displacement Gloves
Nimblefinger Gloves
Knock Knuckle Gloves
Gloves of Power
Unlucky Thief's Gloves
Smuggler's Ring
Advantage
Template:ImageLocation
Special:CargoTables Special:Drilldown