User:Korgat: Difference between revisions
No edit summary |
|||
(35 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
__NOTOC__ | __NOTOC__ | ||
= | = Chronology = | ||
== [[Act One]] == | |||
{{ImageLocation|Prologue.webp|Prologue|The player arrives on the Nautiloid immediately after character creation.<br> | |||
<hr> | |||
[[Nautiloid]] | |||
<hr> | |||
{{#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; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (where_to_find like "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Overgrown_Ruins.png|Overgrown Ruins|The remnants of what appears to have once been a chapel, eroded by time.<br> | |||
<hr> | |||
[[Dank Crypt]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Dank Crypt%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = where_to_find like "%Dank Crypt%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Silvanus%27_Grove_SW.png|Emerald Grove|The Emerald Grove, also known as Silvanus' Grove and Druid's Grove.<br> | |||
<hr> | |||
Sold by [[Arron]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; 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; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=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; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
Sold by [[Dammon]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; 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; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=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; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
Sold by [[Auntie Ethel]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
(where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | |||
where_to_find like "%Auntie Ethel%") AND | |||
where_to_find NOT REGEXP "Strange Ox" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = ( | |||
(where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | |||
where_to_find like "%Auntie Ethel%") AND | |||
where_to_find NOT REGEXP "Strange Ox" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
Sold by [[Volo]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
(where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | |||
where_to_find like "%Volo%") AND | |||
where_to_find NOT REGEXP "Strange Ox" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = ( | |||
(where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | |||
where_to_find like "%Volo%") AND | |||
where_to_find NOT REGEXP "Strange Ox" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
[[Druid Grove]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
((where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | |||
where_to_find NOT REGEXP "Dammon" AND | |||
where_to_find NOT REGEXP "Arron" AND | |||
where_to_find NOT REGEXP "Auntie Ethel" AND | |||
where_to_find NOT REGEXP "Volo") OR | |||
where_to_find like "%Strange Ox%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = ( | |||
((where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | |||
where_to_find NOT REGEXP "Dammon" AND | |||
where_to_find NOT REGEXP "Arron" AND | |||
where_to_find NOT REGEXP "Auntie Ethel" AND | |||
where_to_find NOT REGEXP "Volo") OR | |||
where_to_find like "%Strange Ox%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Forest.jpg|Forest|Forest is a sub-area of the Wilderness. It is found west of the Emerald Grove.<br> | |||
<hr> | |||
[[Forest]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Forest%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = where_to_find like "%Forest%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
[[Owlbear Nest]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Owlbear Nest%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = where_to_find like "%Owlbear Nest%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|The Risen Road.jpg|The Risen Road|'''The Risen Road''' is a long stretch of road that connects [[Elturel]] and [[Baldur's Gate]].<br> | |||
<hr> | |||
[[The Risen Road]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Risen Road%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = where_to_find like "%Risen Road%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Arcane Tower.jpg|Arcane Tower|An isolated wizard tower deep in the [[Underdark]] protected by Arcane Cannons<br> | |||
<hr> | |||
[[Arcane Tower]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Arcane Tower%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = where_to_find like "%Arcane Tower%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
|tall=y}} | |||
== [[Act Two]] == | |||
{{ImageLocation|Grand Mausoleum Vestibule.jpg|Grand Mausoleum|The Thorm family mausoleum, resting place of Melodia Thorm and entrance to the Gauntlet of Shar<br> | |||
[[Gauntlet of Shar]] | |||
}} | |||
== [[Act Three]] == | |||
<br> | |||
<hr> | |||
<hr> | |||
'''Wyrm's Crossing''' | |||
<hr> | |||
<hr> | |||
{{ImageLocation|Rivington.jpg|Rivington|The southern-most district of Baldur's Gate, located south of [[Wyrm's Crossing]].<br> | |||
<hr> | |||
[[Rivington]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
where_to_find like "%Rivington%" AND | |||
where_to_find NOT REGEXP "Rivington General" AND | |||
where_to_find NOT REGEXP "Ferg Drogher" AND | |||
where_to_find NOT REGEXP "Mattis" AND | |||
where_to_find NOT REGEXP "Circus of the Last Days" AND | |||
where_to_find NOT REGEXP "Open Hand Temple" AND | |||
where_to_find NOT REGEXP "Angleiron's Cellar") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = ( | |||
where_to_find like "%Rivington%" AND | |||
where_to_find NOT REGEXP "Rivington General" AND | |||
where_to_find NOT REGEXP "Ferg Drogher" AND | |||
where_to_find NOT REGEXP "Mattis" AND | |||
where_to_find NOT REGEXP "Circus of the Last Days" AND | |||
where_to_find NOT REGEXP "Open Hand Temple" AND | |||
where_to_find NOT REGEXP "Angleiron's Cellar") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Rivington General.jpg|Rivington General|The general store in [[Rivington]], run by a Dragonborn [[Exxvikyap]].<br> | |||
<hr> | |||
Sold by [[Exxvikyap]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
where_to_find like "%Rivington General%" AND | |||
where_to_find like "%Exxvikyap%" AND | |||
(where_to_find like "%Purchased%" OR where_to_find like "%Sold%" OR where_to_find like "%bought%")) | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = ( | |||
where_to_find like "%Rivington General%" AND | |||
where_to_find like "%Exxvikyap%" AND | |||
(where_to_find like "%Purchased%" OR where_to_find like "%Sold%" OR where_to_find like "%bought%")) | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
[[Rivington General]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
where_to_find like "%Rivington General%" AND | |||
where_to_find NOT REGEXP "Purchased" AND | |||
where_to_find NOT REGEXP "Sold" AND | |||
where_to_find NOT REGEXP "bought") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = ( | |||
where_to_find like "%Rivington General%" AND | |||
where_to_find NOT REGEXP "Purchased" AND | |||
where_to_find NOT REGEXP "Sold" AND | |||
where_to_find NOT REGEXP "bought") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Requisitioned Barn.jpg|Requisitioned Barn|The '''Requisitioned Barn''' is a donation center for refugees heading to Baldur's Gate.<br> | |||
<hr> | |||
Sold by [[Ferg Drogher]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Ferg Drogher%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (where_to_find like "%Ferg Drogher%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
Sold by [[Mattis]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Mattis%Rivington%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (where_to_find like "%Mattis%Rivington%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Circus of the Last Days.jpg|Circus of the Last Days|An extraplanar circus which moves from plane to plane, "thrilling all" who stop by.<br> | |||
<hr> | |||
Sold by [[Popper]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find like "%Popper%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find like "%Popper%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
[[Circus of the Last Days]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find NOT REGEXP "Popper") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find NOT REGEXP "Popper") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
<br> | |||
{{ImageLocation|Open Hand Temple.jpg|Open Hand Temple|A temple dedicated to Ilmater, currently grieving the loss of their head priest.<br> | |||
<hr> | |||
[[Open Hand Temple]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Open Hand Temple%" AND uid != "MAG_OfSharpCaster_Hat" AND uid != "MAG_Projectile_Shoes") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (where_to_find like "%Open Hand Temple%" AND uid != "MAG_OfSharpCaster_Hat" AND uid != "MAG_Projectile_Shoes") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Ironhand_Cave_Location_Blocked.png|Angleiron's Cellar|The [[Clan Ironhand|Ironhand Gnomes]] who escaped the [[Grymforge]] have taken up residence in this cellar.<br> | |||
<hr> | |||
Sold by [[Bumpnagel]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Angleiron's Cellar%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = where_to_find like "%Angleiron's Cellar%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Wyrm's Crossing Side.jpg|Wyrm's Crossing|Sits between [[Rivington]] and the [[Wyrm's Rock Fortress]], and must be crossed to enter the [[Lower City|City]].<br> | |||
<hr> | |||
Sold by [[Entharl Danthelon]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find like "%Entharl Danthelon%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find like "%Entharl Danthelon%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
[[Wyrm's Crossing]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find NOT REGEXP "Entharl Danthelon") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find NOT REGEXP "Entharl Danthelon") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Wyrm's Rock Fortress.jpg|Wyrm's Rock Fortress|Connected to the south by [[Wyrm's Crossing]], and the north by the [[Lower City]].<br> | |||
<hr> | |||
Sold by [[Arkleia Oloril]] | |||
<hr> | |||
<i>No special equipment</i> | |||
<hr> | |||
[[Wyrm's Rock Fortress]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Wyrm's Rock Fortress%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = where_to_find like "%Wyrm's Rock Fortress%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<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> | |||
<hr> | |||
[[Lower City]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
where_to_find like "%Lower City%" AND | |||
where_to_find NOT REGEXP 'Lower City Sewers' AND | |||
where_to_find NOT REGEXP 'Undercity Ruins' AND | |||
where_to_find NOT REGEXP 'Forge of the Nine' AND | |||
where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | |||
where_to_find NOT REGEXP 'Stormshore Armoury' AND | |||
where_to_find NOT REGEXP 'Sorcerous Sundries' AND | |||
where_to_find NOT REGEXP 'Wine Festival' AND | |||
where_to_find NOT REGEXP "Devil's Fee" AND | |||
where_to_find NOT REGEXP "Philgrave's Mansion" AND | |||
where_to_find NOT REGEXP 'Steel Watch Foundry' AND | |||
where_to_find NOT REGEXP 'Undercity Ruins') | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|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 "Philgrave's Mansion" AND | |||
where_to_find NOT REGEXP 'Steel Watch Foundry' AND | |||
where_to_find NOT REGEXP 'Undercity Ruins') | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Stormshore tabernacle.jpg|Stormshore Tabernacle|A house of worship located in the northeastern part of the [[Lower City]], near the Basilisk Gate.<br> | |||
<hr> | |||
[[Stormshore Tabernacle]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Stormshore Tabernacle%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = where_to_find like "%Stormshore Tabernacle%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Elfsong Tavern Street View.jpg|Elfsong Tavern|A tavern located north-west of [[Stormshore Tabernacle]] and the Basilisk Gate [[waypoint]]<br> | |||
<hr> | |||
[[Elfsong_Tavern#Elfsong_Tavern_Basement|Elfsong Tavern Basement]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Elfsong Tavern Basement%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = where_to_find like "%Elfsong Tavern Basement%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
[[Knights of the Shield Hideout]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Knights of the Shield Hideout%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = where_to_find like "%Knights of the Shield Hideout%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Lower City Sewers North.jpg|Lower City Sewers|Entrances include manhole covers in the city streets, and inside specific buildings.<br> | |||
<hr> | |||
Sold by [[Severn]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Severn%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = where_to_find like "%Severn%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
Sold by [[Sticky Dondo]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Sticky Dondo%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = where_to_find like "%Sticky Dondo%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
Sold by [[Voiceless Penitent Bareki]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Bareki%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = where_to_find like "%Bareki%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
[[Lower City Sewers]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
where_to_find like "%Lower City Sewers%" AND | |||
where_to_find NOT REGEXP "Severn" AND | |||
where_to_find NOT REGEXP "Sticky Dondo" AND | |||
where_to_find NOT REGEXP "Bareki") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=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; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
[[Undercity Ruins]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
where_to_find like "%Undercity Ruins%" AND | |||
where_to_find NOT REGEXP "Severn" AND | |||
where_to_find NOT REGEXP "Sticky Dondo" AND | |||
where_to_find NOT REGEXP "Bareki") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=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; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
<br> | |||
{{ImageLocation|Forge of the Nine.jpg|Forge of the Nine|The outside of the Forge of the Nine. A stone patio is equipped with a forge and smithing station.<br> | |||
<hr> | |||
Sold by [[Dammon]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Forge of the Nine%" AND where_to_find like "%Dammon%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (where_to_find like "%Forge of the Nine%" AND where_to_find like "%Dammon%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
[[Forge of the Nine|Basement]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Forge of the Nine%" AND where_to_find NOT REGEXP 'Dammon') | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (where_to_find like "%Forge of the Nine%" AND where_to_find NOT REGEXP 'Dammon') | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Devil's Fee.jpg|Devil's Fee|Owned by [[Helsik]], there are all sorts of devilish artifacts and curios on display around the store.<br> | |||
<hr> | |||
Sold by [[Helsik]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Devil's Fee%" AND where_to_find like "%Helsik%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (where_to_find like "%Devil's Fee%" AND where_to_find like "%Helsik%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
[[Devil's Fee]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Devil's Fee%" AND where_to_find NOT REGEXP "Helsik") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (where_to_find like "%Devil's Fee%" AND where_to_find NOT REGEXP "Helsik") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
<br> | |||
{{ImageLocation|Stormshore Armoury.jpg|Stormshore Armoury|An outdoor smithy with a glowing red hot furnace in the back corner.<br> | |||
<hr> | |||
Sold by [[Gloomy Fentonson]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
Sold by [[Fytz|Fytz The Firecracker]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Fytz%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Fytz%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Sorcerous Sundries.jpg|Sorcerous Sundries|A large magical marketplace, and home to the wizard [[Lorroakan]]<br> | |||
<hr> | |||
Sold by [[Lorroakan's Projection]] (or [[Rolan]]) | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
where_to_find like "%Sorcerous Sundries%" AND | |||
where_to_find like "%Sold%" AND | |||
where_to_find like "%Lorroakan's Projection%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=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; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
Sold by [[Tolna Tome-Monger]] | |||
<hr> | |||
<i>No special equipment</i> | |||
<hr> | |||
[[Sorcerous Sundries]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
where_to_find like "%Sorcerous Sundries%" AND | |||
where_to_find NOT REGEXP "Sold" AND | |||
where_to_find NOT REGEXP "Sorcerous Vault") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=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; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Ramazith's View.jpg|Ramazith's Tower|The home of the wizard [[Lorroakan]], only accessible from [[Sorcerous Sundries]].<br> | |||
<hr> | |||
[[Ramazith's Tower]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Ramazith's Tower%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
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; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Sorcerous Vault.webp|Sorcerous Vault|A secret vault within [[Sorcerous Sundries]] accessible from [[Ramazith's Tower]].<br> | |||
<hr> | |||
[[Sorcerous Vault]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Sorcerous Vault%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = where_to_find like "%Sorcerous Vault%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<br>{{RarityItem|The Tharchiate Codex|20}} | |||
}} | |||
<br> | |||
{{ImageLocation|Philgrave's Mansion.jpg|Philgrave's Mansion|Located by the waterfront next to the [[Counting House]] and [[Felogyr's Fireworks]]<br> | |||
<hr> | |||
Sold by [[Mystic Carrion]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
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; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = ( | |||
where_to_find like "%Philgrave's Mansion%" AND | |||
(where_to_find like "%Sold%" OR where_to_find like "%bought%") AND | |||
where_to_find like "%Mystic Carrion%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
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; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = ( | |||
where_to_find like "%Philgrave's Mansion%" AND | |||
where_to_find NOT REGEXP "Sold" AND | |||
where_to_find NOT REGEXP "bought") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
= Equipment By Act and Region = | = Equipment By Act and Region = | ||
Line 62: | Line 797: | ||
tables=equipment; where = (where_to_find like "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark") | 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 "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark") | |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 | ||
Line 82: | Line 817: | ||
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 | ||
Line 95: | Line 830: | ||
|tables=equipment; where = (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") | |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 "%Emerald Grove%" OR where_to_find like "%Druid Grove%") | |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 | ||
Line 106: | Line 841: | ||
|tables=equipment; where = where_to_find like "%The Risen Road%" | |tables=equipment; where = where_to_find like "%The Risen Road%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[The Risen Road]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "%The Risen Road%" | |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 | ||
Line 117: | Line 852: | ||
|tables=equipment; where = where_to_find like "%Forest%" | |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 "%Forest%" | |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 "%Owlbear Nest%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Forest]]")=Act,CONCAT("[[Owlbear Nest]]")=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 "%Forest%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Forest]]")=Act,CONCAT("[[Owlbear Nest]]")=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 "%Blighted Village%" | |tables=equipment; where = where_to_find like "%Blighted Village%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
Line 233: | Line 979: | ||
}} | }} | ||
</div> | </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 == | == <span class="mw-customtoggle-1" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act Two == | ||
Line 347: | Line 1,094: | ||
tables=equipment; where = where_to_find like "%Rivington General%" | tables=equipment; where = where_to_find like "%Rivington General%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington General]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "%Rivington General%" | |tables=weapons; where = where_to_find like "%Rivington General%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington General]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%" | |tables=equipment; where = (where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Requisitioned Barn]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%" | |tables=weapons; where = (where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Requisitioned Barn]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
Line 369: | Line 1,116: | ||
|tables=equipment; where = where_to_find like "%Circus of the Last Days%" | |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 "%Circus of the Last Days%" | |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 "%Open Hand Temple%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Open Hand Temple]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | |||
|tables=weapons; where = where_to_find like "%Open Hand Temple%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Open Hand Temple]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
|tables=equipment; where = where_to_find like "%Angleiron's Cellar%" | |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 = where_to_find like "%Angleiron's Cellar%" | |tables=weapons; where = where_to_find like "%Angleiron's Cellar%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | 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, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
Line 395: | Line 1,153: | ||
where_to_find NOT REGEXP "Mattis" AND | where_to_find NOT REGEXP "Mattis" AND | ||
where_to_find NOT REGEXP "Circus of the Last Days" 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") | 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 | ||
Line 406: | Line 1,165: | ||
where_to_find NOT REGEXP "Mattis" AND | where_to_find NOT REGEXP "Mattis" AND | ||
where_to_find NOT REGEXP "Circus of the Last Days" 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") | 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 | ||
Line 423: | Line 1,183: | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "%Wyrm's Rock Fortress%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Rock Fortress]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | |||
|tables=weapons; where = where_to_find like "%Wyrm's Rock Fortress%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Rock Fortress]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
|tables=equipment; where = ( | |tables=equipment; where = ( | ||
where_to_find like "%Lower City%" AND | where_to_find like "%Lower City%" AND | ||
where_to_find NOT REGEXP 'Lower City Sewers' 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 'Forge of the Nine' AND | ||
where_to_find NOT REGEXP 'Stormshore Tabernacle' 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 'Sorcerous Sundries' AND | ||
where_to_find NOT REGEXP 'Wine Festival' AND | where_to_find NOT REGEXP 'Wine Festival' AND | ||
where_to_find NOT REGEXP "Devil's Fee" 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 "Philgrave's Mansion" AND | ||
where_to_find NOT REGEXP 'Steel Watch Foundry' AND | where_to_find NOT REGEXP 'Steel Watch Foundry' AND | ||
Line 441: | Line 1,215: | ||
where_to_find like "%Lower City%" AND | where_to_find like "%Lower City%" AND | ||
where_to_find NOT REGEXP 'Lower City Sewers' 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 'Forge of the Nine' AND | ||
where_to_find NOT REGEXP 'Stormshore Tabernacle' 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 'Sorcerous Sundries' AND | ||
where_to_find NOT REGEXP 'Wine Festival' AND | where_to_find NOT REGEXP 'Wine Festival' AND | ||
where_to_find NOT REGEXP "Devil's Fee" 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 "Philgrave's Mansion" AND | ||
where_to_find NOT REGEXP 'Steel Watch Foundry' AND | where_to_find NOT REGEXP 'Steel Watch Foundry' AND | ||
Line 484: | Line 1,261: | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Stormshore Tabernacle]]")=Location, | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Stormshore Tabernacle]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
|tables=equipment; where = where_to_find like "%Stormshore Armoury%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[Stormshore Armoury]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | |||
|tables=weapons; where = where_to_find like "%Stormshore Armoury%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[Stormshore Armoury]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | 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 | ||
Line 509: | Line 1,297: | ||
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%" | |tables=equipment; where = where_to_find like "%Devil%Fee%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
Line 520: | Line 1,319: | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%The Counting House%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[The Counting House]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%The Counting House%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[The Counting House]]")=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 | ||
Line 735: | Line 1,534: | ||
= Dye Previews = | |||
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;" | |||
! style="width: 40%;" | Medium Armour | |||
! style="width: 10%;" | [[File:Dark_Amethyst_Dye_Detail.png|25px|link=https://bg3-dyes.tumblr.com/tagged/medium+armour]] | |||
! style="width: 40%;" | Heavy Armour | |||
! style="width: 10%;" | [[File:Dark_Amethyst_Dye_Detail.png|25px|link=https://bg3-dyes.tumblr.com/tagged/heavy+armour]] | |||
|- | |||
| {{ItemIcon|name=Chain Shirt +1|size=25|show_rarity=1}} [[Chain Shirt +1|{{RarityColor|uncommon|Chain Shirt +1}}]] | |||
|| [https://64.media.tumblr.com/46b29ffd14bece381933372cb6a0227b/00edac1c71a28b5f-ab/s1280x1920/644dff86c07dd2ba17b768bfd1120408eccadae2.png Dyes] | |||
|| | |||
|| | |||
|- | |||
| {{ItemIcon|name=Chain Shirt +2|size=25|show_rarity=1}} [[Chain Shirt +1|{{RarityColor|rare|Chain Shirt +2}}]] | |||
|| [https://64.media.tumblr.com/49c4560a04fc8198830c32ee6c5cae87/28a28e3124da3197-90/s1280x1920/2069c7673e58d43b89f2f6ba61d9f8efaa75e340.png Dyes] | |||
|| {{ItemIcon|name=Plate Armour +2|size=25|show_rarity=1}} [[Plate Armour +1|{{RarityColor|rare|Plate Armour +2}}]] | |||
|| [https://64.media.tumblr.com/1646e63dff137f11059102d85bbc45c6/08ccd38d3d0757c6-ee/s1280x1920/de2a864edfc4faa04febb8c721a1a64b89d04cd6.png Dyes] | |||
|- | |||
| {{ItemIcon|name=Dark Justiciar Half-Plate (Very Rare)|size=25|show_rarity=1}} [[Dark Justiciar Half-Plate (Very Rare)|{{RarityColor|very rare|Dark Justiciar Half Plate}}]] | |||
|| [https://64.media.tumblr.com/f1bfc59b449900e95c0fe37bb0430560/1a42314c8972fc71-02/s1280x1920/4f0e185e431ad6f6d4f1a286c03b799330042751.png Dyes] | |||
|| {{ItemIcon|name=Blackguard's Plate|size=25|show_rarity=1}} [[Blackguard's Plate|{{RarityColor|very rare|Blackguard's Plate}}]] | |||
|| [https://64.media.tumblr.com/b1ce0174ed6967db06d947f2e0abe3ff/d3e2e9ec4d78abec-5a/s1280x1920/26dcb8a9b4fb177c8c464b79af0e9d6c91d612c6.png Dyes] | |||
|} | |||
Line 801: | Line 1,623: | ||
<!-- | <!-- | ||
{| class="wikitable" | |||
|+ Equipment | |||
! [[File:Helmet_Icon.png|50px|link=Headwear]] | |||
! | |||
! | |||
|- | |||
! [[File:Cloak_B_Unfaded_Icon.png|50px|link=Cloaks]] | |||
! | |||
! | |||
|- | |||
! [[File:Plate_Armour_Icon.png|50px|link=Armour]] | |||
! | |||
! [[File:Amulet_Necklace_A_Gold_A_1_Unfaded_Icon.png|50px|link=Amulets]] | |||
|- | |||
! [[File:Metallic_Gloves_Icon.png|50px|link=Handwear]] | |||
! | |||
! [[File:Ring_A_Simple_Gold_Unfaded_Icon.png|50px|link=Rings]] | |||
|- | |||
! [[File:Metallic_Boots_Icon.png|50px|link=Footwear]] | |||
! | |||
! | |||
|- | |||
! [[File:Longsword_Item_Icon.png|50px|link=Weapons]] | |||
! [[File:Item_WPN_HUM_Shield_D_0_Unfaded_Icon.png|50px|link=Shields]] | |||
! [[File:Longbow_Item_Icon.png|50px|link=Bow]] | |||
|} | |||
= Resistance Equipment = | = Resistance Equipment = | ||
Line 1,144: | Line 1,994: | ||
--> | --> | ||
= Stats Equipment = | |||
{{ImageLocation|Strength_Score_Icon.png|Strength| | |||
<hr> | |||
'''Bonus''' | |||
<hr> | |||
{{RarityItem|Gauntlets of Hill Giant Strength|20}} | |||
{{RarityItem|The Mighty Cloth|20}} | |||
<hr> | |||
'''Advantage''' | |||
<hr> | |||
{{RarityItem|The Mighty Cloth|20}} | |||
}} | |||
{{ImageLocation|Dexterity_Score_Icon.png|Dexterity| | |||
<hr> | |||
'''Bonus''' | |||
<hr> | |||
{{RarityItem|Gloves of Dexterity|20}}<br> | |||
{{RarityItem|The Graceful Cloth|20}} | |||
<hr> | |||
'''Advantage''' | |||
<hr> | |||
{{RarityItem|The Graceful Cloth|20}} | |||
}} | |||
{{ImageLocation|Intelligence_Score_Icon.png|Intelligence| | |||
<hr> | |||
'''Bonus''' | |||
<hr> | |||
{{RarityItem|Warped Headband of Intellect|20}} | |||
}} | |||
<hr> | |||
{{ImageLocation|Stealth_Icon.png|Stealth|Dexterity | |||
<hr> | |||
'''Bonus''' | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (special like "%Stealth%" AND special NOT REGEXP "Advantage" AND special NOT REGEXP "Disadvantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (special like "%Stealth%" AND special NOT REGEXP "Advantage" AND special NOT REGEXP "Disadvantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
'''Advantage''' | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (special like "%Stealth%" AND special like "%Advantage%" AND special NOT REGEXP "Disadvantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (special like "%Stealth%" AND special like "%Advantage%" AND special NOT REGEXP "Disadvantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
'''No Disadvantage''' | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (special like "%Stealth%" AND special like "%Disadvantage%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (special like "%Stealth%" AND special like "%Disadvantage%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Sleight_of_Hand_Icon.png|Sleight of Hand|Dexterity | |||
<hr> | |||
'''Bonus''' | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (special like "%Sleight%" AND special NOT REGEXP "Advantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (special like "%Sleight%" AND special NOT REGEXP "Advantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
'''Advantage''' | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (special like "%Sleight%" AND special like "%Advantage%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (special like "%Sleight%" AND special like "%Advantage%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Arcana_Icon.png|Arcana|Intelligence | |||
<hr> | |||
'''Bonus''' | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (special like "%Arcana%" AND special NOT REGEXP "Advantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (special like "%Arcana%" AND special NOT REGEXP "Advantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
[[Template:ImageLocation]] | |||
[[Special:CargoTables]] [[Special:Drilldown]] | |||
{{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