308
edits→Act Three
(→Act One: Auntie Ethel and Volo) |
|||
(12 intermediate revisions by the same user not shown) | |||
Line 34: | Line 34: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation|Silvanus%27_Grove_SW.png|Emerald Grove|The Emerald Grove, also known as Silvanus' Grove and Druid's Grove.<br> | {{ImageLocation|Silvanus%27_Grove_SW.png|Emerald Grove|The Emerald Grove, also known as Silvanus' Grove and Druid's Grove.<br> | ||
<hr> | <hr> | ||
Line 138: | Line 137: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation| | {{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 = where_to_find like "% | tables=equipment; where = where_to_find like "%Forest%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[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 "%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 152: | Line 151: | ||
|delimiter=<br> | |delimiter=<br> | ||
}} | }} | ||
<hr> | <hr> | ||
[[ | [[Owlbear Nest]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "% | tables=equipment; where = where_to_find like "%Owlbear Nest%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[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 "%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 167: | Line 164: | ||
|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 = where_to_find like "% | tables=equipment; where = where_to_find like "%Risen Road%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Risen Road%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 181: | Line 180: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation|Arcane Tower.jpg|Arcane Tower|An isolated wizard tower deep in the [[Underdark]] protected by Arcane Cannons<br> | |||
{{ImageLocation|Arcane Tower.jpg|Arcane Tower|An isolated wizard tower protected by Arcane Cannons|tall=y}} | <hr> | ||
[[Arcane Tower]] | |||
== [[Act Two]] == | <hr> | ||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Arcane Tower%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = where_to_find like "%Arcane Tower%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
|tall=y}} | |||
== [[Act Two]] == | |||
{{ImageLocation|Grand Mausoleum Vestibule.jpg|Grand Mausoleum|The Thorm family mausoleum, resting place of Melodia Thorm and entrance to the Gauntlet of Shar<br> | {{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]] | [[Gauntlet of Shar]] | ||
Line 191: | Line 203: | ||
== [[Act Three]] == | == [[Act Three]] == | ||
<br> | |||
<hr> | |||
<hr> | |||
'''Wyrm's Crossing''' | |||
<hr> | |||
<hr> | |||
{{ImageLocation|Rivington.jpg|Rivington|The southern-most district of Baldur's Gate, located south of [[Wyrm's Crossing]].<br> | {{ImageLocation|Rivington.jpg|Rivington|The southern-most district of Baldur's Gate, located south of [[Wyrm's Crossing]].<br> | ||
<hr> | <hr> | ||
Line 397: | Line 415: | ||
}} | }} | ||
<br> | <br> | ||
<hr> | |||
<hr> | |||
'''Lower City''' | |||
<hr> | |||
<hr> | |||
{{ImageLocation|Lower City.jpg|Lower City|The Lower City is accessed after passing through [[Wyrm's Rock Fortress]].<br> | {{ImageLocation|Lower City.jpg|Lower City|The Lower City is accessed after passing through [[Wyrm's Rock Fortress]].<br> | ||
<hr> | <hr> | ||
Line 591: | Line 614: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation| | {{ImageLocation|Devil's Fee.jpg|Devil's Fee|Owned by [[Helsik]], there are all sorts of devilish artifacts and curios on display around the store.<br> | ||
<hr> | <hr> | ||
Sold by [[ | Sold by [[Helsik]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = (where_to_find like "% | tables=equipment; where = (where_to_find like "%Devil's Fee%" AND where_to_find like "%Helsik%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = (where_to_find like "% | |tables=weapons; where = (where_to_find like "%Devil's Fee%" AND where_to_find like "%Helsik%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 606: | Line 629: | ||
}} | }} | ||
<hr> | <hr> | ||
[[Devil's Fee]] | |||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = (where_to_find like "% | tables=equipment; where = (where_to_find like "%Devil's Fee%" AND where_to_find NOT REGEXP "Helsik") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = (where_to_find like "% | |tables=weapons; where = (where_to_find like "%Devil's Fee%" AND where_to_find NOT REGEXP "Helsik") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 619: | Line 642: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation| | <br> | ||
{{ImageLocation|Stormshore Armoury.jpg|Stormshore Armoury|An outdoor smithy with a glowing red hot furnace in the back corner.<br> | |||
<hr> | <hr> | ||
Sold by [[Lorroakan's Projection]] (or [[Rolan]]) | Sold by [[Gloomy Fentonson]] | ||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
Sold by [[Fytz|Fytz The Firecracker]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Fytz%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Fytz%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Sorcerous Sundries.jpg|Sorcerous Sundries|A large magical marketplace, and home to the wizard [[Lorroakan]]<br> | |||
<hr> | |||
Sold by [[Lorroakan's Projection]] (or [[Rolan]]) | |||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
Line 649: | Line 701: | ||
tables=equipment; where = ( | tables=equipment; where = ( | ||
where_to_find like "%Sorcerous Sundries%" AND | where_to_find like "%Sorcerous Sundries%" AND | ||
where_to_find NOT REGEXP "Sold") | where_to_find NOT REGEXP "Sold" AND | ||
where_to_find NOT REGEXP "Sorcerous Vault") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=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 "%Sorcerous Sundries%" AND | where_to_find like "%Sorcerous Sundries%" AND | ||
where_to_find NOT REGEXP "Sold") | where_to_find NOT REGEXP "Sold" AND | ||
where_to_find NOT REGEXP "Sorcerous Vault") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 661: | Line 715: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation|Ramazith's View.jpg|Ramazith's Tower|The home of the wizard [[Lorroakan]], only accessible from [[Sorcerous Sundries]].<br> | |||
<hr> | |||
[[Ramazith's Tower]] | |||
<hr> | |||
< | |||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "%Ramazith's Tower%" | |||
tables=equipment; where = | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "%Ramazith's Tower%" | |||
|tables=weapons; where = | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
|format=list | |||
|delimiter=<br> | |||
}} | |||
|tables=equipment; where = where_to_find like "% | }} | ||
{{ImageLocation|Sorcerous Vault.webp|Sorcerous Vault|A secret vault within [[Sorcerous Sundries]] accessible from [[Ramazith's Tower]].<br> | |||
<hr> | |||
[[Sorcerous Vault]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Sorcerous Vault%" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = where_to_find like "%Sorcerous Vault%" | |||
|tables=weapons; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
|format=list | |||
|delimiter=<br> | |||
}} | |||
|tables=equipment; where = where_to_find like "% | <br>{{RarityItem|The Tharchiate Codex|20}} | ||
}} | |||
<br> | |||
{{ImageLocation|Philgrave's Mansion.jpg|Philgrave's Mansion|Located by the waterfront next to the [[Counting House]] and [[Felogyr's Fireworks]]<br> | |||
<hr> | |||
Sold by [[Mystic Carrion]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
where_to_find like "%Philgrave's Mansion%" AND | |||
(where_to_find like "%Sold%" OR where_to_find like "%bought%") AND | |||
where_to_find like "%Mystic Carrion%") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = ( | |||
where_to_find like "%Philgrave's Mansion%" AND | |||
|tables=weapons; where = where_to_find like "% | (where_to_find like "%Sold%" OR where_to_find like "%bought%") AND | ||
where_to_find like "%Mystic Carrion%") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
[[Philgrave's Mansion]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
where_to_find like "%Philgrave's Mansion%" AND | |||
where_to_find NOT REGEXP "Sold" AND | |||
where_to_find NOT REGEXP "bought") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = ( | |||
where_to_find like "%Philgrave's Mansion%" AND | |||
|tables=weapons; where = (where_to_find like "% | where_to_find NOT REGEXP "Sold" AND | ||
where_to_find NOT REGEXP "bought") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields= | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[ | = Equipment By Act and Region = | ||
== <span class="mw-customtoggle-0" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act One == | |||
<div id="mw-customcollapsible-0" class="mw-collapsible mw-collapsed"> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Prologue]]")=Act,CONCAT("[[Nautiloid]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = (where_to_find like "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Prologue]]")=Act,CONCAT("[[Nautiloid]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Ravaged Beach%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Ravaged Beach]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Ravaged Beach%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Ravaged Beach]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Dank Crypt%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Overgrown Ruins]]")=Act,CONCAT("[[Dank Crypt]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Dank Crypt%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Overgrown Ruins]]")=Act,CONCAT("[[Dank Crypt]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Druid Grove]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Druid Grove]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = | |tables=equipment; where = where_to_find like "%The Risen Road%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[The Risen Road]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = | |tables=weapons; where = where_to_find like "%The Risen Road%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[The Risen Road]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Forest%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Forest]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Forest%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Forest]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Owlbear Nest%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Forest]]")=Act,CONCAT("[[Owlbear Nest]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Forest%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Forest]]")=Act,CONCAT("[[Owlbear Nest]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Blighted Village%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Blighted Village]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Blighted Village%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Blighted Village]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = (where_to_find like "%Sunlit Wetlands%" OR where_to_find like "%Putrid Bog%") | |||
|tables=equipment; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Sunlit Wetlands]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = (where_to_find like "%Sunlit Wetlands%" OR where_to_find like "%Putrid Bog%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Sunlit Wetlands]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Goblin Camp%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Goblin Camp]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Goblin Camp%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Goblin Camp]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Waukeen's Rest%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Waukeen's Rest]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Waukeen's Rest%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Waukeen's Rest]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Mountain Pass%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Mountain Pass]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Mountain Pass%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Mountain Pass]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "%Underdark%" | |||
tables=equipment; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Underdark]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Underdark%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Underdark]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Grymforge%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Grymforge]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Grymforge%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Grymforge]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Rosymorn Monastery%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Rosymorn Monastery]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Rosymorn Monastery%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Rosymorn Monastery]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Crèche Y'llek%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Crèche Y'llek]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Crèche Y'llek%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Crèche Y'llek]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | |format=dynamic table | ||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[ | |rows per page=1000 | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |hidden fields=Effects, Where To Find, Type, AC, Dmg | ||
|column widths=6%,16%,,,,13%,4%,6% | |||
}} | |||
</div> | |||
== <span class="mw-customtoggle-1" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act Two == | |||
<div id="mw-customcollapsible-1" class="mw-collapsible mw-collapsed"> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Ruined Battlefield%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Ruined Battlefield]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Ruined Battlefield%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Ruined Battlefield]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Last Light Inn%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Last Light Inn]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Last Light Inn%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Last Light Inn]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Reithwin Town%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Reithwin Town]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Reithwin Town%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Reithwin Town]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Moonrise%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Moonrise]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Moonrise%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Moonrise]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "%Grand Mausoleum%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Grand Mausoleum]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
tables=equipment; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[ | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Grand Mausoleum%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Grand Mausoleum]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = | |tables=equipment; where = where_to_find like "%Gauntlet of Shar%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Gauntlet of Shar]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = | |tables=weapons; where = where_to_find like "%Gauntlet of Shar%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Gauntlet of Shar]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Shadowfell%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Shadowfell]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Shadowfell%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Shadowfell]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Mind Flayer Colony%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Mind Flayer Colony]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Mind Flayer Colony%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Mind Flayer Colony]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[ | |format=dynamic table | ||
|rows per page=1000 | |||
|hidden fields=Effects, Where To Find, Type, AC, Dmg | |||
|column widths=6%,16%,,,,13%,4%,6% | |||
}} | |||
</div> | |||
== <span class="mw-customtoggle-2" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act Three == | |||
<div id="mw-customcollapsible-2" class="mw-collapsible mw-collapsed"> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Rivington General%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington General]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Rivington General%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington General]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = ( | |tables=equipment; where = (where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%") | ||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Requisitioned Barn]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[ | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = ( | |tables=weapons; where = (where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Requisitioned Barn]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Circus of the Last Days%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Circus of the Last Days]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Circus of the Last Days%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Circus of the Last Days]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Open Hand Temple%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Open Hand Temple]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Open Hand Temple%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Open Hand Temple]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = | |tables=equipment; where = where_to_find like "%Angleiron's Cellar%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Angleiron's Cellar]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = | |tables=weapons; where = where_to_find like "%Angleiron's Cellar%" | ||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Angleiron's Cellar]]")=Location, | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[ | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = ( | ||
where_to_find like "%Rivington%" AND | |||
where_to_find NOT REGEXP "Rivington General" AND | |||
where_to_find NOT REGEXP "Ferg Drogher" AND | |||
where_to_find NOT REGEXP "Mattis" AND | |||
where_to_find NOT REGEXP "Circus of the Last Days" AND | |||
where_to_find NOT REGEXP "Open Hand Temple" AND | |||
where_to_find NOT REGEXP "Angleiron's Cellar") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = ( | ||
where_to_find like "%Rivington%" AND | |||
where_to_find NOT REGEXP "Rivington General" AND | |||
where_to_find NOT REGEXP "Ferg Drogher" AND | |||
where_to_find NOT REGEXP "Mattis" AND | |||
where_to_find NOT REGEXP "Circus of the Last Days" AND | |||
where_to_find NOT REGEXP "Open Hand Temple" AND | |||
where_to_find NOT REGEXP "Angleiron's Cellar") | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Wyrm's Crossing%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Crossing]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Wyrm's Crossing%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Crossing]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Wyrm's Rock Fortress%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Rock Fortress]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Wyrm's Rock Fortress%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Rock Fortress]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "%Stormshore Armoury | |tables=equipment; where = ( | ||
where_to_find like "%Lower City%" AND | |||
where_to_find NOT REGEXP 'Lower City Sewers' AND | |||
where_to_find NOT REGEXP 'Undercity Ruins' AND | |||
where_to_find NOT REGEXP 'Forge of the Nine' AND | |||
where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | |||
where_to_find NOT REGEXP 'Stormshore Armoury' AND | |||
where_to_find NOT REGEXP 'Sorcerous Sundries' AND | |||
where_to_find NOT REGEXP 'Wine Festival' AND | |||
where_to_find NOT REGEXP "Devil's Fee" AND | |||
where_to_find NOT REGEXP "The Counting House" AND | |||
where_to_find NOT REGEXP "Philgrave's Mansion" AND | |||
where_to_find NOT REGEXP 'Steel Watch Foundry' AND | |||
where_to_find NOT REGEXP 'Undercity Ruins') | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = ( | ||
where_to_find like "%Lower City%" AND | |||
where_to_find NOT REGEXP 'Lower City Sewers' AND | |||
where_to_find NOT REGEXP 'Undercity Ruins' AND | |||
where_to_find NOT REGEXP 'Forge of the Nine' AND | |||
where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | |||
where_to_find NOT REGEXP 'Stormshore Armoury' AND | |||
where_to_find NOT REGEXP 'Sorcerous Sundries' AND | |||
where_to_find NOT REGEXP 'Wine Festival' AND | |||
where_to_find NOT REGEXP "Devil's Fee" AND | |||
where_to_find NOT REGEXP "The Counting House" AND | |||
where_to_find NOT REGEXP "Philgrave's Mansion" AND | |||
where_to_find NOT REGEXP 'Steel Watch Foundry' AND | |||
where_to_find NOT REGEXP 'Undercity Ruins') | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Lower City Sewers%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City Sewers]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Lower City Sewers%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City Sewers]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Forge of the Nine%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Forge of the Nine]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Forge of the Nine%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Forge of the Nine]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Stormshore Tabernacle%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | 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("[[ | 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 Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Sorcerous Sundries]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Sorcerous Sundries%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Sorcerous Sundries]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "% | |tables=equipment; where = where_to_find like "%Wine Festival%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wine Festival]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Wine Festival%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wine Festival]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "%Philgrave%s Mansion%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | |||
|tables=weapons; where = where_to_find like "%Philgrave%s Mansion%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
|tables=equipment; where = where_to_find like "%Devil%Fee%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Devil's Fee]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | |||
|tables=weapons; where = where_to_find like "%Devil%Fee%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Devil's Fee]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
|tables=equipment; where = where_to_find like "%The Counting House%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[The Counting House]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | |||
|tables=weapons; where = where_to_find like "%The Counting House%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[The Counting House]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
| | |tables=equipment; where = where_to_find like "%Steel Watch Foundry%" | ||
AND rarity != "common" AND legacy IS NULL; | |||
| | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Steel Watch Foundry]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | |||
|tables=weapons; where = where_to_find like "%Steel Watch Foundry%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Steel Watch Foundry]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
= | |||
See [[Permanent Bonuses]] or [[Permanent bonus table]] for a complete list of bonuses. | |tables=equipment; where = where_to_find like "%Undercity Ruins%" | ||
AND rarity != "common" AND legacy IS NULL; | |||
== <span class="mw-customtoggle-b0" style="font-size:small; display:inline-block; float:right;"><span class="mw-customtoggletext">[Show/hide]</span></span> Act One == | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Undercity Ruins]]")=Location, | ||
<div id="mw-customcollapsible-b0" class="mw-collapsible mw-collapsed"> | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | |||
{| class="wikitable" style="margin-left: auto; margin-right: auto; border: none;" | |tables=weapons; where = where_to_find like "%Undercity Ruins%" | ||
! style="width: 14%;" | Region | AND rarity != "common" AND legacy IS NULL; | ||
! style="width: 17%;" | Location | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Undercity Ruins]]")=Location, | ||
! style="width: 21%;" | Bonus | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
! style="width: 48%;" | Description | 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 -->[[Goblin Camp]] | | <!-- 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]] | || <!-- Location -->[[Shattered Sanctum#Centre|Shattered Sanctum Centre]] | ||
|| <!-- Bonus -->[[File:Absolute_symbol.png|25px]][[Absolute's Brand]] | || <!-- Bonus -->[[File:Absolute_symbol.png|25px]][[Absolute's Brand]] | ||
Line 1,836: | Line 1,962: | ||
}} | }} | ||
=== [[Amulets]] === | === [[Amulets]] === | ||
{{SpoilerBox|act=3|custom=[[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 = | | where = | ||
type = "Amulets" | type = "Amulets" | ||
AND rarity != "common" | AND rarity != "common" | ||
AND legacy IS NULL | AND legacy IS NULL | ||
AND ( | AND ( | ||
where_to_find like "%Rivington%" | where_to_find like "%Rivington%" | ||
) | ) | ||
| format = table | | format = table | ||
}} | }} | ||
}} | }} | ||
=== [[Rings]] === | === [[Rings]] === | ||
{{SpoilerBox|act=3|custom=[[Rings]].| | {{SpoilerBox|act=3|custom=[[Rings]].| | ||
{{#cargo_query: tables = equipment | {{#cargo_query: tables = equipment | ||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | | fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | ||
| order by = rarity_order | | order by = rarity_order | ||
| where = | | where = | ||
type = "Rings" | type = "Rings" | ||
AND rarity != "common" | AND rarity != "common" | ||
AND legacy IS NULL | AND legacy IS NULL | ||
AND ( | AND ( | ||
where_to_find like "%Rivington%" | where_to_find like "%Rivington%" | ||
) | ) | ||
| format = table | | format = table | ||
}} | }} | ||
}} | |||
}} | |||
--> | |||
= Stats Equipment = | |||
{{ImageLocation|Strength_Score_Icon.png|Strength| | |||
<hr> | |||
'''Bonus''' | |||
<hr> | |||
{{RarityItem|Gauntlets of Hill Giant Strength|20}} | |||
{{RarityItem|The Mighty Cloth|20}} | |||
<hr> | |||
'''Advantage''' | |||
<hr> | |||
{{RarityItem|The Mighty Cloth|20}} | |||
}} | |||
{{ImageLocation|Dexterity_Score_Icon.png|Dexterity| | |||
<hr> | |||
'''Bonus''' | |||
<hr> | |||
{{RarityItem|Gloves of Dexterity|20}}<br> | |||
{{RarityItem|The Graceful Cloth|20}} | |||
<hr> | |||
'''Advantage''' | |||
<hr> | |||
{{RarityItem|The Graceful Cloth|20}} | |||
}} | |||
{{ImageLocation|Intelligence_Score_Icon.png|Intelligence| | |||
<hr> | |||
'''Bonus''' | |||
<hr> | |||
{{RarityItem|Warped Headband of Intellect|20}} | |||
}} | |||
<hr> | |||
{{ImageLocation|Stealth_Icon.png|Stealth|Dexterity | |||
<hr> | |||
'''Bonus''' | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (special like "%Stealth%" AND special NOT REGEXP "Advantage" AND special NOT REGEXP "Disadvantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (special like "%Stealth%" AND special NOT REGEXP "Advantage" AND special NOT REGEXP "Disadvantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
'''Advantage''' | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (special like "%Stealth%" AND special like "%Advantage%" AND special NOT REGEXP "Disadvantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (special like "%Stealth%" AND special like "%Advantage%" AND special NOT REGEXP "Disadvantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
'''No Disadvantage''' | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (special like "%Stealth%" AND special like "%Disadvantage%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (special like "%Stealth%" AND special like "%Disadvantage%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Sleight_of_Hand_Icon.png|Sleight of Hand|Dexterity | |||
<hr> | |||
'''Bonus''' | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (special like "%Sleight%" AND special NOT REGEXP "Advantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (special like "%Sleight%" AND special NOT REGEXP "Advantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
'''Advantage''' | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (special like "%Sleight%" AND special like "%Advantage%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (special like "%Sleight%" AND special like "%Advantage%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Arcana_Icon.png|Arcana|Intelligence | |||
<hr> | |||
'''Bonus''' | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (special like "%Arcana%" AND special NOT REGEXP "Advantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (special like "%Arcana%" AND special NOT REGEXP "Advantage") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | }} | ||
}} | }} | ||
[[Template:ImageLocation]] | [[Template:ImageLocation]] | ||
[[Special:CargoTables]] [[Special:Drilldown]] | [[Special:CargoTables]] [[Special:Drilldown]] | ||
{{Gameplay mechanics}} | {{Gameplay mechanics}} |