Editing User:Korgat
Jump to navigation
Jump to search
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 34: | Line 34: | ||
}} | }} | ||
}} | }} | ||
<hr> | |||
{{ImageLocation|Silvanus%27_Grove_SW.png|Emerald Grove|The Emerald Grove, also known as Silvanus' Grove and Druid's Grove.<br> | {{ImageLocation|Silvanus%27_Grove_SW.png|Emerald Grove|The Emerald Grove, also known as Silvanus' Grove and Druid's Grove.<br> | ||
<hr> | <hr> | ||
[[Druid Grove]] | |||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = ( | tables=equipment; where = ( | ||
(where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | ((where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | ||
where_to_find | where_to_find NOT REGEXP "Dammon") OR | ||
where_to_find | where_to_find like "%Strange Ox%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = ( | |tables=weapons; where = ( | ||
(where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | ((where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | ||
where_to_find | where_to_find NOT REGEXP "Dammon") OR | ||
where_to_find | where_to_find like "%Strange Ox%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 55: | Line 56: | ||
}} | }} | ||
<hr> | <hr> | ||
[[Dammon]] | |||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
Line 73: | Line 74: | ||
|delimiter=<br> | |delimiter=<br> | ||
}} | }} | ||
}} | |||
{{ImageLocation|The Risen Road.jpg|The Risen Road|'''The Risen Road''' is a long stretch of road that connects [[Elturel]] and [[Baldur's Gate]].<br> | |||
<hr> | <hr> | ||
[[The Risen Road]] | |||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = | tables=equipment; where = where_to_find like "%The Risen Road%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = | |tables=weapons; where = where_to_find like "%The Risen Road%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 92: | Line 89: | ||
|delimiter=<br> | |delimiter=<br> | ||
}} | }} | ||
}} | |||
{{ImageLocation|Forest.jpg|Forest|Forest is a sub-area of the Wilderness. It is found west of the Emerald Grove.<br> | |||
<hr> | <hr> | ||
[[Forest]] | |||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = | tables=equipment; where = where_to_find like "%Forest%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = | |tables=weapons; where = where_to_find like "%Forest%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 112: | Line 105: | ||
}} | }} | ||
<hr> | <hr> | ||
[[ | [[Owlbear Nest]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = | tables=equipment; where = where_to_find like "%Owlbear Nest%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = | |tables=weapons; where = where_to_find like "%Owlbear Nest%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 137: | Line 118: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation| | <br> | ||
{{ImageLocation|Arcane Tower.jpg|Arcane Tower|An isolated wizard tower protected by Arcane Cannons|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]] == | |||
{{ImageLocation|Rivington.jpg|Rivington|The southern-most district of Baldur's Gate, located south of [[Wyrm's Crossing]].<br> | |||
<hr> | <hr> | ||
[[ | [[Rivington]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
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("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = ( | ||
where_to_find like "%Rivington%" AND | |||
where_to_find NOT REGEXP "Rivington General" AND | |||
where_to_find NOT REGEXP "Ferg Drogher" AND | |||
where_to_find NOT REGEXP "Mattis" AND | |||
where_to_find NOT REGEXP "Circus of the Last Days" AND | |||
where_to_find NOT REGEXP "Open Hand Temple" AND | |||
where_to_find NOT REGEXP "Angleiron's Cellar") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 151: | Line 156: | ||
|delimiter=<br> | |delimiter=<br> | ||
}} | }} | ||
}} | |||
{{ImageLocation|Rivington General.jpg|Rivington General|The general store in [[Rivington]], run by a Dragonborn [[Exxvikyap]].<br> | |||
<hr> | <hr> | ||
[[ | [[Rivington General]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "% | tables=equipment; where = where_to_find like "%Rivington General%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Rivington General%" | ||
AND 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 165: | Line 172: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation| | {{ImageLocation|Requisitioned Barn.jpg|Requisitioned Barn|The '''Requisitioned Barn''' is a donation center for refugees heading to Baldur's Gate.<br> | ||
<hr> | <hr> | ||
[[ | [[Ferg Drogher]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "% | tables=equipment; where = (where_to_find like "%Ferg Drogher%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = (where_to_find like "%Ferg Drogher%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 179: | Line 186: | ||
|delimiter=<br> | |delimiter=<br> | ||
}} | }} | ||
<hr> | <hr> | ||
[[ | [[Mattis]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "% | tables=equipment; where = (where_to_find like "%Mattis%Rivington%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = (where_to_find like "%Mattis%Rivington%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 194: | Line 199: | ||
|delimiter=<br> | |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> | |||
<br> | |||
<hr> | <hr> | ||
[[Circus of the Last Days]] | |||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = | 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("[[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 "%Circus of the Last Days%" | ||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |format=list | ||
|delimiter=<br> | |delimiter=<br> | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation| | <br> | ||
{{ImageLocation|Open Hand Temple.jpg|Open Hand Temple|A temple dedicated to Ilmater, currently grieving the loss of their head priest.<br> | |||
<hr> | <hr> | ||
[[Open Hand Temple]] | |||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = | tables=equipment; where = where_to_find like "%Open Hand Temple%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = | |tables=weapons; where = where_to_find like "%Open Hand Temple%" | ||
AND 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 258: | Line 230: | ||
|delimiter=<br> | |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> | <hr> | ||
[[ | [[Angleiron's Cellar]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
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("[[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 "%Angleiron's Cellar%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 280: | Line 246: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation| | {{ImageLocation|Wyrm's Crossing Side.jpg|Wyrm's Crossing|Sits between [[Rivington]] and the [[Wyrm's Rock Fortress]], and must be crossed to enter the [[Lower City|City]].<br> | ||
<hr> | <hr> | ||
[[Wyrm's Crossing]] | |||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = | 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("[[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 "%Wyrm's Crossing%" | ||
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 294: | Line 260: | ||
|delimiter=<br> | |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> | <hr> | ||
[[Wyrm's Rock Fortress]] | |||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = | tables=equipment; where = where_to_find like "%Wyrm's Rock Fortress%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = | |tables=weapons; where = where_to_find like "%Wyrm's Rock Fortress%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 308: | Line 276: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation| | <br> | ||
{{ImageLocation|Lower City.jpg|Lower City|The Lower City is accessed after passing through [[Wyrm's Rock Fortress]].<br> | |||
<hr> | <hr> | ||
[[Lower City]] | |||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = (where_to_find like "% | tables=equipment; where = ( | ||
where_to_find like "%Lower City%" AND | |||
where_to_find NOT REGEXP 'Lower City Sewers' AND | |||
where_to_find NOT REGEXP 'Undercity Ruins' AND | |||
where_to_find NOT REGEXP 'Forge of the Nine' AND | |||
where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | |||
where_to_find NOT REGEXP 'Stormshore Armoury' AND | |||
where_to_find NOT REGEXP 'Sorcerous Sundries' AND | |||
where_to_find NOT REGEXP 'Wine Festival' AND | |||
where_to_find NOT REGEXP "Devil's Fee" AND | |||
where_to_find NOT REGEXP "Philgrave's Mansion" AND | |||
where_to_find NOT REGEXP 'Steel Watch Foundry' AND | |||
where_to_find NOT REGEXP 'Undercity Ruins') | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = (where_to_find like "% | |tables=weapons; where = ( | ||
AND rarity != "common" AND legacy IS NULL; | where_to_find like "%Lower City%" AND | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | 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 | |format=list | ||
|delimiter=<br> | |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> | <hr> | ||
[[ | [[Stormshore Tabernacle]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = | tables=equipment; where = where_to_find like "%Stormshore Tabernacle%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = | |tables=weapons; where = where_to_find like "%Stormshore Tabernacle%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 336: | Line 331: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation|Elfsong Tavern Street View.jpg|Elfsong Tavern|A tavern located north-west of [[Stormshore Tabernacle]] and the Basilisk Gate [[waypoint]]<br> | |||
{{ImageLocation| | |||
<hr> | <hr> | ||
[[ | [[Elfsong_Tavern#Elfsong_Tavern_Basement|Elfsong Tavern Basement]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = | tables=equipment; where = where_to_find like "%Elfsong Tavern Basement%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = | |tables=weapons; where = where_to_find like "%Elfsong Tavern Basement%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 351: | Line 345: | ||
|delimiter=<br> | |delimiter=<br> | ||
}} | }} | ||
<hr> | <hr> | ||
[[Knights of the Shield Hideout]] | |||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "% | tables=equipment; where = where_to_find like "%Knights of the Shield Hideout%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Knights of the Shield Hideout%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 367: | Line 359: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation| | {{ImageLocation|Lower City Sewers North.jpg|Lower City Sewers|Entrances include manhole covers in the city streets, and inside specific buildings.<br> | ||
<hr> | <hr> | ||
[[Lower City Sewers]] | |||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = | 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("[[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 "%Lower City Sewers%" | ||
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 382: | Line 374: | ||
}} | }} | ||
<hr> | <hr> | ||
[[ | [[Undercity Ruins]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = | tables=equipment; where = where_to_find like "%Undercity Ruins%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = | |tables=weapons; where = where_to_find like "%Undercity Ruins%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 395: | Line 387: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation| | <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> | <hr> | ||
[[ | [[Dammon]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "% | tables=equipment; where = (where_to_find like "%Forge of the Nine%" AND where_to_find like "%Dammon%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=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 "%Forge of the Nine%" AND where_to_find like "%Dammon%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 413: | Line 402: | ||
|delimiter=<br> | |delimiter=<br> | ||
}} | }} | ||
<hr> | <hr> | ||
[[Forge of the Nine|Basement]] | |||
<hr> | <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; | |||
{{ImageLocation| | 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|Stormshore Armoury.jpg|Stormshore Armoury|An outdoor smithy with a glowing red hot furnace in the back corner.<br> | |||
<hr> | <hr> | ||
[[ | [[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 | ||
|delimiter=<br> | |delimiter=<br> | ||
}} | }} | ||
<hr> | <hr> | ||
[[ | [[Fytz|Fytz The Firecracker]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "%Stormshore | 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 = where_to_find like "%Stormshore | |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 474: | Line 444: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation| | {{ImageLocation|Sorcerous Sundries.jpg|Sorcerous Sundries|A large magical marketplace, and home to the wizard [[Lorroakan]]<br> | ||
<hr> | <hr> | ||
[[ | [[Sorcerous Sundries]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
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("[[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 "%Sorcerous Sundries%" | ||
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 488: | Line 458: | ||
|delimiter=<br> | |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: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "% | |||
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("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item | fields=CONCAT("[[Prologue]]")=Act,CONCAT("[[Nautiloid]]")=Location, | ||
|tables=weapons; where = where_to_find like "% | 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 "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item | fields=CONCAT("[[Prologue]]")=Act,CONCAT("[[Nautiloid]]")=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 "%Ravaged Beach%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Ravaged Beach]]")=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 "%Ravaged Beach%" | |||
tables=equipment; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item | |||
|tables=weapons; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Ravaged Beach]]")=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 "%Dank Crypt%" | |||
tables=equipment; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item | fields=CONCAT("[[Overgrown Ruins]]")=Act,CONCAT("[[Dank Crypt]]")=Location, | ||
|tables=weapons; where = where_to_find like "% | 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 "%Dank Crypt%" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item | fields=CONCAT("[[Overgrown Ruins]]")=Act,CONCAT("[[Dank Crypt]]")=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 "%Emerald Grove%" OR where_to_find like "%Druid Grove%") | |||
tables=equipment; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item | fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Druid Grove]]")=Location, | ||
|tables=weapons; where = where_to_find like "% | 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 "%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("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item | fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Druid Grove]]")=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 Risen Road%" | |||
[[ | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[The Risen Road]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
tables= | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "%The Risen Road%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[The Risen Road]]")=Location, | |||
where_to_find | 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 "%Forest%" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item | fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Forest]]")=Location, | ||
|tables=weapons; where = | 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; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item | fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Forest]]")=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 "%Owlbear Nest%" | |||
tables=equipment; where = | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item | fields=CONCAT("[[Forest]]")=Act,CONCAT("[[Owlbear Nest]]")=Location, | ||
|tables=weapons; where = | 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; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item | 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 = | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Blighted Village]]")=Location, | ||
|tables=weapons; where = | 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 "%Blighted Village%" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Blighted Village]]")=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 "%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("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Sunlit Wetlands]]")=Location, | ||
|tables=weapons; where = (where_to_find like "% | 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 "%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("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Sunlit Wetlands]]")=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 "%Goblin Camp%" | |||
tables=equipment; where = | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Goblin Camp]]")=Location, | ||
|tables=weapons; where = | 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 "%Goblin Camp%" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Goblin Camp]]")=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 "%Waukeen's Rest%" | |||
tables=equipment; where = | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Waukeen's Rest]]")=Location, | ||
|tables=weapons; where = | 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 "%Waukeen's Rest%" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Waukeen's Rest]]")=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 "%Mountain Pass%" | |||
tables=equipment; where = | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Mountain Pass]]")=Location, | ||
|tables=weapons; where = | 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 "%Mountain Pass%" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Mountain Pass]]")=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 "%Underdark%" | |||
tables=equipment; where = | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Underdark]]")=Location, | ||
|tables=weapons; where = | 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 "%Underdark%" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Underdark]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
|tables=equipment; where = where_to_find like "%Grymforge%" | |||
tables=equipment; where = | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Grymforge]]")=Location, | ||
|tables=weapons; where = | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | |||
|tables=weapons; where = where_to_find like "%Grymforge%" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Grymforge]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
|tables=equipment; where = where_to_find like "%Rosymorn Monastery%" | |||
tables=equipment; where = | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Rosymorn Monastery]]")=Location, | ||
|tables=weapons; where = | 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 "%Rosymorn Monastery%" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Rosymorn Monastery]]")=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 "%Crèche Y'llek%" | |||
tables=equipment; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Crèche Y'llek]]")=Location, | ||
|tables=weapons; where = where_to_find like "% | 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 "%Crèche Y'llek%" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Crèche Y'llek]]")=Location, | ||
|format= | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
| | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|format=dynamic table | |||
|rows per page=1000 | |||
|hidden fields=Effects, Where To Find, Type, AC, Dmg | |||
|column widths=6%,16%,,,,13%,4%,6% | |||
}} | }} | ||
</div> | |||
< | |||
== <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: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "% | |||
tables=equipment; where = where_to_find like "%Ruined Battlefield%" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Ruined Battlefield]]")=Location, | ||
|tables=weapons; where = where_to_find like "% | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | |||
|tables=weapons; where = where_to_find like "%Ruined Battlefield%" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Ruined Battlefield]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
|tables=equipment; where = where_to_find like "%Last Light Inn%" | |||
tables=equipment; where = | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Last Light Inn]]")=Location, | ||
|tables=weapons; where = | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | |||
|tables=weapons; where = where_to_find like "%Last Light Inn%" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Last Light Inn]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
|tables=equipment; where = where_to_find like "%Reithwin Town%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Reithwin Town]]")=Location, | |||
| | |||
tables=equipment; where = | |||
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, 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 "%Reithwin Town%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=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 | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Moonrise]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Moonrise%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Moonrise]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Grand Mausoleum%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Grand Mausoleum]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Grand Mausoleum%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Grand Mausoleum]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = | |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("[[ | |format=dynamic table | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |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, | |||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Rivington General%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington General]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = (where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Requisitioned Barn]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = (where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Requisitioned Barn]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = | |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 = | |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 = where_to_find like "% | |tables=equipment; where = where_to_find like "%Angleiron's Cellar%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | 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 "% | |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 | ||
|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 "%Wyrm's Crossing%" | |||
|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 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 | 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 | 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 | 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 "% | |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("[[Act | 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 = ( | ||
AND rarity != "common" AND legacy IS NULL; | where_to_find like "%Lower City%" AND | ||
fields=CONCAT("[[Act | where_to_find NOT REGEXP 'Lower City Sewers' AND | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | where_to_find NOT REGEXP 'Undercity Ruins' AND | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | where_to_find NOT REGEXP 'Forge of the Nine' AND | ||
where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | |||
where_to_find NOT REGEXP 'Stormshore Armoury' AND | |||
where_to_find NOT REGEXP 'Sorcerous Sundries' AND | |||
where_to_find NOT REGEXP 'Wine Festival' AND | |||
where_to_find NOT REGEXP "Devil's Fee" AND | |||
where_to_find NOT REGEXP "The Counting House" AND | |||
where_to_find NOT REGEXP "Philgrave's Mansion" AND | |||
where_to_find NOT REGEXP 'Steel Watch Foundry' AND | |||
where_to_find NOT REGEXP 'Undercity Ruins') | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
|tables=equipment; where = where_to_find like "%Lower City Sewers%" | |||
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 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 | 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 | 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 | 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 | 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 | 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("[[ | 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("[[ | 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 | 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 | 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 | 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 | 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 "% | |tables=equipment; where = where_to_find like "%Devil%Fee%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Devil's Fee]]")=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 "%Devil%Fee%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Devil's Fee]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%The 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 | ||
|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%" | |||
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 | |||
|tables=weapons; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=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 "%Steel Watch Foundry%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Steel Watch Foundry]]")=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 "%Steel Watch Foundry%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Steel Watch Foundry]]")=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 "%Undercity Ruins%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Undercity Ruins]]")=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 "%Undercity Ruins%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Undercity Ruins]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
| | |format=dynamic table | ||
|rows per page=1000 | |||
|hidden fields=Effects, Where To Find, Type, AC, Dmg | |||
|column widths=6%,16%,,,,13%,4%,6% | |||
}} | |||
| | </div> | ||
<!-- | |||
{{WeaponsTableHeader}} | |||
{{#cargo_query: tables = weapons | |||
| fields = _pageName=page, name, uid, image, rarity, enchantment, damage, damage_type, extra_damage, extra_damage_type, weight_kg, weight_lb, price, special, special_weapon_actions | |||
| order by = rarity_order, name | |||
| where = rarity != "common" AND legacy IS NULL AND where_to_find like "%Gauntlet of Shar%" | |||
| default = {{WeaponsTableEmpty}} | |||
| format = template | |||
| template = WeaponsTableRow | |||
| named args = yes | |||
}} | |||
{{WeaponsTableFooter}} | |||
--> | |||
= High Utility Permanent Bonuses = | |||
See [[Permanent Bonuses]] or [[Permanent bonus table]] for a complete list of bonuses. | |||
== <span class="mw-customtoggle-b0" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act One == | |||
<div id="mw-customcollapsible-b0" class="mw-collapsible mw-collapsed"> | |||
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;" | |||
! style="width: 14%;" | Region | |||
! style="width: 17%;" | Location | |||
! style="width: 21%;" | Bonus | |||
! style="width: 48%;" | Description | |||
|- | |||
| <!-- Region -->[[Blighted Village]] | |||
|| <!-- Location -->[[Apothecary's Cellar]] | |||
|| <!-- Bonus -->{{SAI|Forbidden Knowledge}} | |||
|| <!-- Description -->Gain +1 bonus to {{Ability|Wisdom}} {{SavingThrow}}s and [[Ability Checks]]. | |||
|- | |||
| <!-- Region -->[[Blighted Village]] | |||
|| <!-- Location -->[[Apothecary's Cellar]] | |||
|| <!-- Bonus -->{{SAI|Speak with Dead}} | |||
|| <!-- Description -->Gain {{SAI|Speak with Dead}} spell once per long rest from [[Necromancy of Thay]]. | |||
|- | |||
| <!-- Region -->[[Goblin Camp]] | |||
|| <!-- Location -->[[Shattered Sanctum#Centre|Shattered Sanctum Centre]] | |||
|| <!-- Bonus -->[[File:Absolute_symbol.png|25px]][[Absolute's Brand]] | |||
|| <!-- Description -->Gain the use of unique special effects on [[:Category:Absolute_Equipment|Absolute Equipment]].<br>Gain unique dialogue options with followers of the [[Absolute]]. | |||
|- | |||
| <!-- Region -->[[Goblin Camp]] | |||
|| <!-- Location -->[[Shattered Sanctum#East|Shattered Sanctum East]] | |||
|| <!-- Bonus -->{{cond|See Invisibility}} | |||
|| <!-- Description -->Grants a permanent {{cond|See Invisibility}} effect from [[Volo's Ersatz Eye (passive feature)|Volo's Ersatz Eye]]. | |||
|- | |||
| <!-- Region -->[[Goblin Camp]] | |||
|| <!-- Location -->[[Shattered Sanctum#East|Shattered Sanctum East]] | |||
|| <!-- Bonus -->{{cond|Loviatar's Love}}{{note|Effect is permanently lost if the character dies and is revived.}} | |||
|| <!-- Description -->When you have 30% [[Hit Points]] or less, you gain a '''+2''' bonus to {{Attack Roll}}s and {{Ability|Wisdom}} {{SavingThrow}}s for 3 turns. | |||
|- | |||
| <!-- Region -->[[Sunlit Wetlands]] | |||
|| <!-- Location -->[[Riverside Teahouse]] | |||
|| <!-- Bonus -->{{cond|Paid the Price}} | |||
|| <!-- Description -->Gain +1 bonus to [[Intimidation]] checks.<br>Gain {{Disadvantage}} on [[Perception]] checks.<br>Gain {{Disadvantage}} when attacking Hags. | |||
|- | |||
| <!-- Region -->[[Sunlit Wetlands]] | |||
|| <!-- Location -->[[Riverside Teahouse]] | |||
|| <!-- Bonus -->[[File:Generic_Feature_Icon.webp|25px]][[Auntie Ethel's Hair|Auntie Ethel's Boon]] | |||
|| <!-- Description -->Gain +1 to an [[Ability Scores|Ability Score]] of choice. Can be raised above 20. | |||
|- | |||
| <!-- Region -->[[Underdark]] | |||
|| <!-- Location -->[[Myconid Colony]] | |||
|| <!-- Bonus -->{{SAI|Survival Instinct}} | |||
|| <!-- Description -->Gain the additional [[Illithid Powers|illithid power]] {{Icon|Cleric Tadpole Survival Instinct.png|30|link=Survival Instinct}}[[Survival Instinct]] | |||
|- | |||
| <!-- Region -->[[Underdark]] | |||
|| <!-- Location -->[[The Festering Cove]] | |||
|| <!-- Bonus -->{{Condition inline|BOOOAL's Blessing}} | |||
|| <!-- Description -->Gain {{Advantage}} on {{Attack Roll}}s against {{cond|Bleeding}} targets. | |||
|- | |||
| <!-- Region -->[[Rosymorn Monastery]] | |||
|| <!-- Location -->[[Crèche Y'llek#Infirmary|Crèche Y'llek Infirmary]] | |||
|| <!-- Bonus -->{{SAI|Awakened}} | |||
|| <!-- Description -->You can use all of your Illithid powers as a [[Bonus Action]]. | |||
|} | |||
</div> | |||
== <span class="mw-customtoggle-b1" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act Two == | |||
<div id="mw-customcollapsible-b1" class="mw-collapsible mw-collapsed"> | |||
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;" | |||
! style="width: 14%;" | Region | |||
! style="width: 17%;" | Location | |||
! style="width: 21%;" | Bonus | |||
! style="width: 48%;" | Description | |||
|- | |||
| <!-- Region -->[[Ruined Battlefield]] | |||
|| <!-- Location -->[[Seek_Protection_from_the_Shadow_Curse#The lantern's power|Kar'niss]] | |||
|| <!-- Bonus -->{{cond|Pixie Blessing}} | |||
|| <!-- Description -->Gain immunity to the {{cond|Shadow Curse}}. | |||
|- | |||
| <!-- Region -->[[Moonrise Towers]] | |||
|| <!-- Location -->[[Moonrise Towers#Main floor|Main Floor]] | |||
|| <!-- Bonus -->[[File:POT_Potion_of_Everlasting_Vigour_Faded.png|25px]][[Potion of Everlasting Vigour]] | |||
|| <!-- Description -->Gain +2 {{Ability|Strength}}. | |||
|- | |||
| <!-- Region -->[[Moonrise Towers]] | |||
|| <!-- Location -->[[Mind Flayer Colony]] | |||
|| <!-- Bonus -->{{cond|Githzerai Mind Barrier}}{{note|Effect is permanently lost if the character dies and is revived.}} | |||
|| <!-- Description -->Gain {{Advantage}} on {{Ability|Intelligence}} {{SavingThrow}}s. | |||
|- | |||
| <!-- Region -->[[Moonrise Towers]] | |||
|| <!-- Location --> | |||
|| <!-- Bonus -->{{SAI|Bardic Inspiration|Improved Bardic Inspiration}} | |||
|| <!-- Description -->Gain a charge of Bardic Inspiration that is stronger than usual ({{DieIcon|d12|Slashing}}'''1d12'''). | |||
|- | |||
| <!-- Region -->[[Reithwin Town]] | |||
|| <!-- Location -->[[Find Arabella's Parents#Breaking the news|Arabella]] | |||
|| <!-- Bonus -->{{SAI|Arabella's Shadow Entangle}} | |||
|| <!-- Description -->Entangle an Undead or shadow creature until long rest. | |||
|} | |||
</div> | |||
== <span class="mw-customtoggle-b2" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act Three == | |||
<div id="mw-customcollapsible-b2" class="mw-collapsible mw-collapsed"> | |||
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;" | |||
! style="width: 14%;" | Region | |||
! style="width: 17%;" | Location | |||
! style="width: 21%;" | Bonus | |||
! style="width: 48%;" | Description | |||
|- | |||
| <!-- Region -->[[Help Your Protector|Wyrm's Lookout]] | |||
|| <!-- Location -->[[Astral Plane]] | |||
|| <!-- Bonus -->{{SAI|Partial Ceremorphosis}} | |||
|| <!-- Description -->Gain all 5 inner ring [[Illithid_powers#List_of_illithid_powers|Tier 1 Illithid Powers]].<br>Gain access to [[Illithid_powers#Elite_Powers|Tier 3 Illithid Powers]].<br>Gain {{SAI|Fly (Illithid Power)|Fly}}. | |||
|- | |||
| <!-- Region -->[[Rivington]] | |||
|| <!-- Location -->[[Circus of the Last Days]] | |||
|| <!-- Bonus -->{{cond|Sweet Stone Features}} | |||
|| <!-- Description -->Gain a {{DieIcon|d4|Slashing}} '''+1d4''' bonus to {{Attack Roll}}s and {{SavingThrow}}s. | |||
|- | |||
| <!-- Region -->[[Lower City]] | |||
|| <!-- Location -->[[Crimson Draughts]] | |||
|| <!-- Bonus -->{{SAI|Unstable Blood}} | |||
|| <!-- Description -->Your blood is now highly flammable and will explode on contact with fire. | |||
|- | |||
| <!-- Region -->[[Lower City]] | |||
|| <!-- Location --> [[House of Grief]] | |||
|| <!-- Bonus -->[[Mirror of Loss|Patriar's Memory]] | |||
|| <!-- Description -->Gain +1 {{Ability|Charisma}}. | |||
|- | |||
| <!-- Region -->[[Lower City]] | |||
|| <!-- Location --> [[House of Grief]] | |||
|| <!-- Bonus -->[[Mirror of Loss#Using_the_mirror|<Stolen> Memory]] | |||
|| <!-- Description -->Gain +2 to an [[Ability Score]] of your choice. | |||
|- | |||
| <!-- Region -->[[Lower City]] | |||
|| <!-- Location -->[[Ramazith's Tower]] | |||
|| <!-- Bonus -->{{SAI|Danse Macabre}} | |||
|| <!-- Description -->Create 4 [[ghoul|ghouls]] that fight alongside you. | |||
|- | |||
| <!-- Region -->[[Lower City]] | |||
|| <!-- Location -->[[Ramazith's Tower]] | |||
|| <!-- Bonus -->{{cond|Tharchiate Withering}} | |||
|| <!-- Description -->Gain -5 {{Ability|Constitution}} and a sickly green aura. | |||
|- | |||
| <!-- Region -->[[Lower City]] | |||
|| <!-- Location -->[[Ramazith's Tower]] | |||
|| <!-- Bonus -->{{SAI|The Tharchiate Codex: Blessing|Tharchiate Codex: Blessing}} | |||
|| <!-- Description -->Gain {{Cond|Tharchiate Vigour}} immediately and also once after every [[Long Rest]]. | |||
|- | |||
| <!-- Region -->[[Lower City]] | |||
|| <!-- Location -->[[Steel Watch Foundry]] | |||
|| <!-- Bonus -->[[Slayer Knowledge]] | |||
|| <!-- Description -->Gain {{Advantage}} on [[Saving Throws]] against being {{Cond|Frightened}} by a [[Bhaalspawn]] Slayer | |||
|} | |||
{{notelist}} | |||
</div> | |||
| | = Dye Previews = | ||
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;" | |||
! style="width: 40%;" | Medium Armour | |||
! style="width: 10%;" | [[File:Dark_Amethyst_Dye_Detail.png|25px|link=https://bg3-dyes.tumblr.com/tagged/medium+armour]] | |||
! style="width: 40%;" | Heavy Armour | |||
! style="width: 10%;" | [[File:Dark_Amethyst_Dye_Detail.png|25px|link=https://bg3-dyes.tumblr.com/tagged/heavy+armour]] | |||
|- | |||
| {{ItemIcon|name=Chain Shirt +1|size=25|show_rarity=1}} [[Chain Shirt +1|{{RarityColor|uncommon|Chain Shirt +1}}]] | |||
|| [https://64.media.tumblr.com/46b29ffd14bece381933372cb6a0227b/00edac1c71a28b5f-ab/s1280x1920/644dff86c07dd2ba17b768bfd1120408eccadae2.png Dyes] | |||
|| | |||
|| | |||
| | |- | ||
| {{ItemIcon|name=Chain Shirt +2|size=25|show_rarity=1}} [[Chain Shirt +1|{{RarityColor|rare|Chain Shirt +2}}]] | |||
|| [https://64.media.tumblr.com/49c4560a04fc8198830c32ee6c5cae87/28a28e3124da3197-90/s1280x1920/2069c7673e58d43b89f2f6ba61d9f8efaa75e340.png Dyes] | |||
|| {{ItemIcon|name=Plate Armour +2|size=25|show_rarity=1}} [[Plate Armour +1|{{RarityColor|rare|Plate Armour +2}}]] | |||
|| [https://64.media.tumblr.com/1646e63dff137f11059102d85bbc45c6/08ccd38d3d0757c6-ee/s1280x1920/de2a864edfc4faa04febb8c721a1a64b89d04cd6.png Dyes] | |||
| | |- | ||
| {{ItemIcon|name=Dark Justiciar Half-Plate (Very Rare)|size=25|show_rarity=1}} [[Dark Justiciar Half-Plate (Very Rare)|{{RarityColor|very rare|Dark Justiciar Half Plate}}]] | |||
|| [https://64.media.tumblr.com/f1bfc59b449900e95c0fe37bb0430560/1a42314c8972fc71-02/s1280x1920/4f0e185e431ad6f6d4f1a286c03b799330042751.png Dyes] | |||
|| {{ItemIcon|name=Blackguard's Plate|size=25|show_rarity=1}} [[Blackguard's Plate|{{RarityColor|very rare|Blackguard's Plate}}]] | |||
|| [https://64.media.tumblr.com/b1ce0174ed6967db06d947f2e0abe3ff/d3e2e9ec4d78abec-5a/s1280x1920/26dcb8a9b4fb177c8c464b79af0e9d6c91d612c6.png Dyes] | |||
|} | |||
| | |||
| | |||
<!-- class="mw-collapsible mw-collapsed"--> | |||
<!-- | <!-- | ||
{{ | {{Tab | ||
|one=The Dark Urge | |||
| | |one-name=Story Spoiler Page | ||
| | |two=The Dark Urge (Origin) | ||
|two-name=Origin Page | |||
| | }} | ||
| | |||
= | {{Infobox | ||
|name = Infobox/doc | |||
|bodystyle = | |||
|titlestyle = | |||
|abovestyle = background:#cfc; | |||
|subheaderstyle = | |||
|title = Test Infobox | |||
|above = Above text | |||
|subheader = Subheader above image | |||
|subheader2 = Second subheader | |||
== | |imagestyle = | ||
|captionstyle = | |||
|image = [[File:Example-serious.jpg|200px|alt=Example alt text]] | |||
|caption = Caption displayed below File:Example-serious.jpg | |||
|headerstyle = background:#ccf; | |||
|labelstyle = background:#ddf; | |||
|datastyle = | |||
|header1 = Header defined alone | |||
| | | label1 = | ||
| | | data1 = | ||
|| | |header2 = | ||
|| | | label2 = Label defined alone does not display (needs data, or is suppressed) | ||
|| | | data2 = | ||
|header3 = | |||
| | | label3 = | ||
| | | data3 = Data defined alone | ||
|header4 = All three defined (header, label, data, all with same number) | |||
| | | label4 = does not display (same number as a header) | ||
| data4 = does not display (same number as a header) | |||
|header5 = | |||
| label5 = Label and data defined (label) | |||
| data5 = Label and data defined (data) | |||
|belowstyle = background:#ddf; | |||
|below = Below text | |||
}} | |||
{| class="mw-collapsible mw-collapsed wikitable" style="margin-left:1.6em;" | |||
|- | |- | ||
! Header 1 | |||
! Header 2 | |||
|- | |- | ||
| | | row 1, cell 1 | ||
| | | row 1, cell 2 | ||
|- | |- | ||
| | | row 2, cell 1 | ||
|| | | row 2, cell 2 | ||
|} | |||
--> | |||
<!-- | |||
{| class="wikitable" | |||
|+ Equipment | |||
! [[File:Helmet_Icon.png|50px|link=Headwear]] | |||
! | |||
! | |||
|- | |- | ||
! [[File:Cloak_B_Unfaded_Icon.png|50px|link=Cloaks]] | |||
|| | ! | ||
! | |||
|- | |- | ||
! [[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 = | |||
== | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
! | | where = rarity != "common" AND special like "%Resistance%" AND legacy IS NULL | ||
| format = table | |||
}} | |||
! | |||
= Equipment By Build = | |||
=== [[Radiant]] Compound Query (testing)=== | |||
| | {{#cargo_compound_query: | ||
|| | tables=equipment; | ||
where=rarity != "common" AND special like "%Radiant%" AND legacy IS NULL; | |||
| | fields=CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | ||
|tables=weapons; | |||
where=rarity != "common" AND special like "%Radiant%" AND legacy IS NULL | |||
| | |format=table | ||
}} | |||
=== [[Radiant]] === | |||
| | {{#cargo_query: tables = equipment | ||
|| | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | |||
| | | where = rarity != "common" AND special like "%Radiant%" AND legacy IS NULL | ||
| | | format = table | ||
}} | |||
{{#cargo_query: tables = weapons | |||
|| | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | |||
| where = rarity != "common" AND special like "%Radiant%" AND legacy IS NULL | |||
| format = table | |||
}} | |||
=== [[Necrotic]] === | |||
{{SpoilerBox| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = rarity != "common" AND special like "%Necrotic%" AND legacy IS NULL | |||
| format = table | |||
}} | |||
{{#cargo_query: tables = weapons | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = rarity != "common" AND special like "%Necrotic%" AND legacy IS NULL | |||
| format = table | |||
}} | |||
}} | |||
--> | |||
<!-- | |||
= Equipment By Act = | |||
Equipment lists separated by Act. | |||
== | == Act One == | ||
{{SpoilerBox|act=1|custom=Equipment for Act One.| | |||
{| | [[File:Chapter 1.webp|500px|link=Act One]] | ||
{{SpoilerBox|act=1|custom=[[Headwear]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = (type = "Helmets" OR type = "Headwear") AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL | |||
|| | | format = table | ||
}} | |||
| | }} | ||
| | {{SpoilerBox|act=1|custom=[[Cloaks]].| | ||
| | {{#cargo_query: tables = equipment | ||
| | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | |||
| where = type = "Cloaks" AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL | |||
| | | format = table | ||
| | }} | ||
| | }} | ||
{{SpoilerBox|act=1|custom=[[Armour]].| | |||
| | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
|| | | where = type like "% Armour%" AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL | ||
| format = table | |||
|| | }} | ||
| | }} | ||
| | {{SpoilerBox|act=1|custom=[[Handwear]].| | ||
| | {{#cargo_query: tables = equipment | ||
|| | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | |||
| | | where = type = "Gloves" AND rarity != "common" AND where_to_find like "%Act One%" AND legacy IS NULL | ||
| | | format = table | ||
| | }} | ||
}} | |||
|| | {{SpoilerBox|act=1|custom=[[Weapons]].| | ||
{{#cargo_query: tables = weapons | |||
| | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, type=Type, special=Effects, where_to_find=Location | ||
| order by = type | |||
|| | | where = | ||
rarity != "common" | |||
| | AND legacy IS NULL | ||
| | AND ( | ||
| | where_to_find like "%Wilderness%" OR | ||
where_to_find like "%Underdark%" OR | |||
| | where_to_find like "%Grymforge%" OR | ||
| | where_to_find like "%Rosymorn Monastery%" | ||
| | ) | ||
| format = table | |||
|| | }} | ||
| | }} | ||
}} | |||
== Act Two == | |||
{{SpoilerBox|act=2|custom=Equipment for Act Two.| | |||
[[File:Chapter 2.webp|500px|link=Act Two]] | |||
= | === [[Headwear]] === | ||
{| | {{SpoilerBox|act=2|custom=[[Headwear]].| | ||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
! | | where = (type = "Helmets" OR type = "Headwear") AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL | ||
| | | format = table | ||
}} | |||
}} | |||
|| | === [[Cloaks]] === | ||
| | {{SpoilerBox|act=2|custom=[[Cloaks]].| | ||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
|| | | where = type = "Cloaks" AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL | ||
| format = table | |||
| | }} | ||
}} | |||
|| [ | === [[Armour]] === | ||
{{SpoilerBox|act=2|custom=[[Armour]].| | |||
{{#cargo_query: tables = equipment | |||
| | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | |||
| where = type like "% Armour%" AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL | |||
| format = table | |||
}} | |||
}} | |||
=== [[Handwear]] === | |||
{{SpoilerBox|act=2|custom=[[Handwear]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = type = "Gloves" AND rarity != "common" AND where_to_find like "%Act Two%" AND legacy IS NULL | |||
| format = table | |||
}} | |||
}} | |||
=== [[Weapons]] === | |||
{{SpoilerBox|act=2|custom=[[Weapons]].| | |||
{{#cargo_query: tables = weapons | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = type | |||
| where = | |||
rarity != "common" | |||
AND legacy IS NULL | |||
AND ( | |||
where_to_find like "%Ruined Battlefield%" OR | |||
where_to_find like "%Last Light Inn%" OR | |||
where_to_find like "%Reithwin Town%" OR | |||
where_to_find like "%Moonrise%" OR | |||
where_to_find like "%Grand Mausoleum%" OR | |||
where_to_find like "%Gauntlet of Shar%" OR | |||
where_to_find like "%Shadowfell%" | |||
) | |||
| format = table | |||
}} | |||
}} | |||
=== [[Shields]] === | |||
{{SpoilerBox|act=2|custom=[[Shields]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = | |||
type = "Shields" | |||
AND rarity != "common" | |||
AND legacy IS NULL | |||
AND ( | |||
where_to_find like "%Ruined Battlefield%" OR | |||
where_to_find like "%Last Light Inn%" OR | |||
where_to_find like "%Reithwin Town%" OR | |||
where_to_find like "%Moonrise%" OR | |||
where_to_find like "%Grand Mausoleum%" OR | |||
where_to_find like "%Gauntlet of Shar%" OR | |||
where_to_find like "%Shadowfell%" | |||
) | |||
| format = table | |||
}} | |||
}} | |||
=== [[Amulets]] === | |||
{{SpoilerBox|act=2|custom=[[Amulets]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = | |||
type = "Amulets" | |||
AND rarity != "common" | |||
AND legacy IS NULL | |||
AND ( | |||
where_to_find like "%Ruined Battlefield%" OR | |||
where_to_find like "%Last Light Inn%" OR | |||
where_to_find like "%Reithwin Town%" OR | |||
where_to_find like "%Moonrise%" OR | |||
where_to_find like "%Grand Mausoleum%" OR | |||
where_to_find like "%Gauntlet of Shar%" OR | |||
where_to_find like "%Shadowfell%" | |||
) | |||
| format = table | |||
}} | |||
}} | }} | ||
=== [[Rings]] === | |||
{| | {{SpoilerBox|act=2|custom=[[Rings]].| | ||
| | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| | | where = | ||
| | type = "Rings" | ||
AND rarity != "common" | |||
| | AND legacy IS NULL | ||
| | AND ( | ||
where_to_find like "%Ruined Battlefield%" OR | |||
where_to_find like "%Last Light Inn%" OR | |||
where_to_find like "%Reithwin Town%" OR | |||
where_to_find like "%Moonrise%" OR | |||
where_to_find like "%Grand Mausoleum%" OR | |||
where_to_find like "%Gauntlet of Shar%" OR | |||
where_to_find like "%Shadowfell%" | |||
) | |||
| format = table | |||
}} | |||
}} | |||
}} | |||
== Act Three == | |||
{{SpoilerBox|act=3|custom=Equipment for Act Three.| | |||
[[File:Chapter 3.webp|500px|link=Act Three]] | |||
| | |||
=== [[Headwear]] === | |||
{{SpoilerBox|act=3|custom=[[Headwear]].| | |||
| | |||
{{#cargo_query: tables = equipment | {{#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 = rarity != "common" AND | | where = (type = "Helmets" OR type = "Headwear") AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL | ||
| format = table | | format = table | ||
}} | }} | ||
}} | }} | ||
=== [[ | === [[Cloaks]] === | ||
{{SpoilerBox|act=3|custom=[[Cloaks]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = type = "Cloaks" AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL | |||
| format = table | |||
}} | |||
}} | |||
=== [[Armour]] === | |||
{{SpoilerBox|act=3|custom=[[Armour]].| | |||
{{#cargo_query: tables = equipment | {{#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 = rarity != "common" AND | | where = type like "% Armour%" AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL | ||
| format = table | | format = table | ||
}} | }} | ||
{{#cargo_query: tables = | }} | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | === [[Handwear]] === | ||
{{SpoilerBox|act=3|custom=[[Handwear]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | | order by = rarity_order | ||
| where = rarity != "common" AND | | where = type = "Gloves" AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL | ||
| format = table | | format = table | ||
}} | }} | ||
}} | }} | ||
=== [[Weapons]] === | |||
{{SpoilerBox|act=3|custom=[[Weapons]].| | |||
{{#cargo_query: tables = weapons | {{#cargo_query: tables = weapons | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>", _pageName)=Item, special=Effects, where_to_find=Location | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = | | order by = type | ||
| where = rarity != "common" AND | | where = | ||
rarity != "common" | |||
AND legacy IS NULL | |||
AND ( | |||
where_to_find like "%Rivington%" | |||
) | |||
| format = table | | format = table | ||
}} | }} | ||
}} | }} | ||
=== [[Shields]] === | |||
{{SpoilerBox|act=3|custom=[[Shields]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
[[ | |||
{{SpoilerBox|act= | |||
{{#cargo_query: tables = equipment | |||
| 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 = "Shields" | |||
AND rarity != "common" | |||
AND legacy IS NULL | |||
AND ( | |||
where_to_find like "%Rivington%" | |||
) | |||
| format = table | | format = table | ||
}} | }} | ||
}} | }} | ||
{{SpoilerBox|act= | === [[Amulets]] === | ||
{{SpoilerBox|act=3|custom=[[Amulets]].| | |||
{{#cargo_query: tables = equipment | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | | order by = rarity_order | ||
| where = type = " | | where = | ||
type = "Amulets" | |||
AND rarity != "common" | |||
AND legacy IS NULL | |||
AND ( | |||
where_to_find like "%Rivington%" | |||
) | |||
| format = table | | format = table | ||
}} | }} | ||
}} | }} | ||
=== [[Rings]] === | |||
{{SpoilerBox|act=3|custom=[[Rings]].| | |||
{{SpoilerBox|act= | |||
{{#cargo_query: tables = equipment | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | | order by = rarity_order | ||
| where = | | where = | ||
rarity != "common" | type = "Rings" | ||
AND rarity != "common" | |||
AND legacy IS NULL | AND legacy IS NULL | ||
AND ( | AND ( | ||
where_to_find like "% | where_to_find like "%Rivington%" | ||
) | ) | ||
| format = table | | format = table | ||
Line 1,760: | Line 1,665: | ||
}} | }} | ||
--> | |||
--> | |||
[[Template:ImageLocation]] | [[Template:ImageLocation]] | ||
{{Gameplay mechanics}} | {{Gameplay mechanics}} |