User:Korgat: Difference between revisions

Jump to navigation Jump to search

User:Korgat (edit)

Revision as of 06:39, 19 February 2024

42,304 bytes added ,  19 February
→‎Act Three
No edit summary
 
(34 intermediate revisions by the same user not shown)
Line 1: Line 1:
__NOTOC__
__NOTOC__


= Chronology =


== [[Act One]] ==
{{ImageLocation|Prologue.webp|Prologue|The player arrives on the Nautiloid immediately after character creation.<br>
<hr>
[[Nautiloid]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Overgrown_Ruins.png|Overgrown Ruins|The remnants of what appears to have once been a chapel, eroded by time.<br>
<hr>
[[Dank Crypt]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Dank Crypt%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Dank Crypt%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Silvanus%27_Grove_SW.png|Emerald Grove|The Emerald Grove, also known as Silvanus' Grove and Druid's Grove.<br>
<hr>
Sold by [[Arron]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (
    (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
    where_to_find like "%Arron%") AND
    where_to_find NOT REGEXP "Strange Ox"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
    (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
    where_to_find like "%Arron%") AND
    where_to_find NOT REGEXP "Strange Ox"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
Sold by [[Dammon]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (
    (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
    where_to_find like "%Dammon%") AND
    where_to_find NOT REGEXP "Strange Ox"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
    (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
    where_to_find like "%Dammon%") AND
    where_to_find NOT REGEXP "Strange Ox"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
Sold by [[Auntie Ethel]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (
    (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
    where_to_find like "%Auntie Ethel%") AND
    where_to_find NOT REGEXP "Strange Ox"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
    (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
    where_to_find like "%Auntie Ethel%") AND
    where_to_find NOT REGEXP "Strange Ox"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
Sold by [[Volo]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (
    (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
    where_to_find like "%Volo%") AND
    where_to_find NOT REGEXP "Strange Ox"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
    (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
    where_to_find like "%Volo%") AND
    where_to_find NOT REGEXP "Strange Ox"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
[[Druid Grove]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (
    ((where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
    where_to_find NOT REGEXP "Dammon" AND
    where_to_find NOT REGEXP "Arron" AND
    where_to_find NOT REGEXP "Auntie Ethel" AND
    where_to_find NOT REGEXP "Volo") OR
    where_to_find like "%Strange Ox%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
    ((where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
    where_to_find NOT REGEXP "Dammon" AND
    where_to_find NOT REGEXP "Arron" AND
    where_to_find NOT REGEXP "Auntie Ethel" AND
    where_to_find NOT REGEXP "Volo") OR
    where_to_find like "%Strange Ox%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Forest.jpg|Forest|Forest is a sub-area of the Wilderness. It is found west of the Emerald Grove.<br>
<hr>
[[Forest]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Forest%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Forest%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
[[Owlbear Nest]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Owlbear Nest%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Owlbear Nest%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|The Risen Road.jpg|The Risen Road|'''The Risen Road''' is a long stretch of road that connects [[Elturel]] and [[Baldur's Gate]].<br>
<hr>
[[The Risen Road]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Risen Road%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Risen Road%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Arcane Tower.jpg|Arcane Tower|An isolated wizard tower deep in the [[Underdark]] protected by Arcane Cannons<br>
<hr>
[[Arcane Tower]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Arcane Tower%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Arcane Tower%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
|tall=y}}
== [[Act Two]] ==
{{ImageLocation|Grand Mausoleum Vestibule.jpg|Grand Mausoleum|The Thorm family mausoleum, resting place of Melodia Thorm and entrance to the Gauntlet of Shar<br>
[[Gauntlet of Shar]]
}}
== [[Act Three]] ==
<br>
<hr>
<hr>
'''Wyrm's Crossing'''
<hr>
<hr>
{{ImageLocation|Rivington.jpg|Rivington|The southern-most district of Baldur's Gate, located south of [[Wyrm's Crossing]].<br>
<hr>
[[Rivington]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (
              where_to_find like "%Rivington%" AND
              where_to_find NOT REGEXP "Rivington General" AND
              where_to_find NOT REGEXP "Ferg Drogher" AND
              where_to_find NOT REGEXP "Mattis" AND
              where_to_find NOT REGEXP "Circus of the Last Days" AND
              where_to_find NOT REGEXP "Open Hand Temple" AND
              where_to_find NOT REGEXP "Angleiron's Cellar")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
              where_to_find like "%Rivington%" AND
              where_to_find NOT REGEXP "Rivington General" AND
              where_to_find NOT REGEXP "Ferg Drogher" AND
              where_to_find NOT REGEXP "Mattis" AND
              where_to_find NOT REGEXP "Circus of the Last Days" AND
              where_to_find NOT REGEXP "Open Hand Temple" AND
              where_to_find NOT REGEXP "Angleiron's Cellar")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Rivington General.jpg|Rivington General|The general store in [[Rivington]], run by a Dragonborn [[Exxvikyap]].<br>
<hr>
Sold by [[Exxvikyap]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (
    where_to_find like "%Rivington General%" AND
    where_to_find like "%Exxvikyap%" AND
    (where_to_find like "%Purchased%" OR where_to_find like "%Sold%" OR where_to_find like "%bought%"))
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
    where_to_find like "%Rivington General%" AND
    where_to_find like "%Exxvikyap%" AND
    (where_to_find like "%Purchased%" OR where_to_find like "%Sold%" OR where_to_find like "%bought%"))
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
[[Rivington General]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (
    where_to_find like "%Rivington General%" AND
    where_to_find NOT REGEXP "Purchased" AND
    where_to_find NOT REGEXP "Sold" AND
    where_to_find NOT REGEXP "bought")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
    where_to_find like "%Rivington General%" AND
    where_to_find NOT REGEXP "Purchased" AND
    where_to_find NOT REGEXP "Sold" AND
    where_to_find NOT REGEXP "bought")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Requisitioned Barn.jpg|Requisitioned Barn|The '''Requisitioned Barn''' is a donation center for refugees heading to Baldur's Gate.<br>
<hr>
Sold by [[Ferg Drogher]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Ferg Drogher%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Ferg Drogher%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
Sold by [[Mattis]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Mattis%Rivington%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Mattis%Rivington%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Circus of the Last Days.jpg|Circus of the Last Days|An extraplanar circus which moves from plane to plane, "thrilling all" who stop by.<br>
<hr>
Sold by [[Popper]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find like "%Popper%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find like "%Popper%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
[[Circus of the Last Days]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find NOT REGEXP "Popper")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find NOT REGEXP "Popper")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
<br>
{{ImageLocation|Open Hand Temple.jpg|Open Hand Temple|A temple dedicated to Ilmater, currently grieving the loss of their head priest.<br>
<hr>
[[Open Hand Temple]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Open Hand Temple%" AND uid != "MAG_OfSharpCaster_Hat" AND uid != "MAG_Projectile_Shoes")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Open Hand Temple%" AND uid != "MAG_OfSharpCaster_Hat" AND uid != "MAG_Projectile_Shoes")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Ironhand_Cave_Location_Blocked.png|Angleiron's Cellar|The [[Clan Ironhand|Ironhand Gnomes]] who escaped the [[Grymforge]] have taken up residence in this cellar.<br>
<hr>
Sold by [[Bumpnagel]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Angleiron's Cellar%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Angleiron's Cellar%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Wyrm's Crossing Side.jpg|Wyrm's Crossing|Sits between [[Rivington]] and the [[Wyrm's Rock Fortress]], and must be crossed to enter the [[Lower City|City]].<br>
<hr>
Sold by [[Entharl Danthelon]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find like "%Entharl Danthelon%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find like "%Entharl Danthelon%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
[[Wyrm's Crossing]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find NOT REGEXP "Entharl Danthelon")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find NOT REGEXP "Entharl Danthelon")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Wyrm's Rock Fortress.jpg|Wyrm's Rock Fortress|Connected to the south by [[Wyrm's Crossing]], and the north by the [[Lower City]].<br>
<hr>
Sold by [[Arkleia Oloril]]
<hr>
<i>No special equipment</i>
<hr>
[[Wyrm's Rock Fortress]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Wyrm's Rock Fortress%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Wyrm's Rock Fortress%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
<br>
<hr>
<hr>
'''Lower City'''
<hr>
<hr>
{{ImageLocation|Lower City.jpg|Lower City|The Lower City is accessed after passing through [[Wyrm's Rock Fortress]].<br>
<hr>
[[Lower City]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (
              where_to_find like "%Lower City%" AND
              where_to_find NOT REGEXP 'Lower City Sewers' AND
              where_to_find NOT REGEXP 'Undercity Ruins' AND
              where_to_find NOT REGEXP 'Forge of the Nine' AND
              where_to_find NOT REGEXP 'Stormshore Tabernacle' AND
              where_to_find NOT REGEXP 'Stormshore Armoury' AND
              where_to_find NOT REGEXP 'Sorcerous Sundries' AND
              where_to_find NOT REGEXP 'Wine Festival' AND
              where_to_find NOT REGEXP "Devil's Fee" AND
              where_to_find NOT REGEXP "Philgrave's Mansion" AND
              where_to_find NOT REGEXP 'Steel Watch Foundry' AND
              where_to_find NOT REGEXP 'Undercity Ruins')
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
              where_to_find like "%Lower City%" AND
              where_to_find NOT REGEXP 'Lower City Sewers' AND
              where_to_find NOT REGEXP 'Undercity Ruins' AND
              where_to_find NOT REGEXP 'Forge of the Nine' AND
              where_to_find NOT REGEXP 'Stormshore Tabernacle' AND
              where_to_find NOT REGEXP 'Stormshore Armoury' AND
              where_to_find NOT REGEXP 'Sorcerous Sundries' AND
              where_to_find NOT REGEXP 'Wine Festival' AND
              where_to_find NOT REGEXP "Devil's Fee" AND
              where_to_find NOT REGEXP "Philgrave's Mansion" AND
              where_to_find NOT REGEXP 'Steel Watch Foundry' AND
              where_to_find NOT REGEXP 'Undercity Ruins')
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Stormshore tabernacle.jpg|Stormshore Tabernacle|A house of worship located in the northeastern part of the [[Lower City]], near the Basilisk Gate.<br>
<hr>
[[Stormshore Tabernacle]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Stormshore Tabernacle%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Stormshore Tabernacle%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Elfsong Tavern Street View.jpg|Elfsong Tavern|A tavern located north-west of [[Stormshore Tabernacle]] and the Basilisk Gate [[waypoint]]<br>
<hr>
[[Elfsong_Tavern#Elfsong_Tavern_Basement|Elfsong Tavern Basement]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Elfsong Tavern Basement%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Elfsong Tavern Basement%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
[[Knights of the Shield Hideout]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Knights of the Shield Hideout%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Knights of the Shield Hideout%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Lower City Sewers North.jpg|Lower City Sewers|Entrances include manhole covers in the city streets, and inside specific buildings.<br>
<hr>
Sold by [[Severn]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Severn%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Severn%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
Sold by [[Sticky Dondo]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Sticky Dondo%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Sticky Dondo%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
Sold by [[Voiceless Penitent Bareki]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Bareki%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Bareki%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
[[Lower City Sewers]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (
    where_to_find like "%Lower City Sewers%" AND
    where_to_find NOT REGEXP "Severn" AND
    where_to_find NOT REGEXP "Sticky Dondo" AND
    where_to_find NOT REGEXP "Bareki")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
    where_to_find like "%Lower City Sewers%" AND
    where_to_find NOT REGEXP "Severn" AND
    where_to_find NOT REGEXP "Sticky Dondo" AND
    where_to_find NOT REGEXP "Bareki")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
[[Undercity Ruins]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (
    where_to_find like "%Undercity Ruins%" AND
    where_to_find NOT REGEXP "Severn" AND
    where_to_find NOT REGEXP "Sticky Dondo" AND
    where_to_find NOT REGEXP "Bareki")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
    where_to_find like "%Undercity Ruins%" AND
    where_to_find NOT REGEXP "Severn" AND
    where_to_find NOT REGEXP "Sticky Dondo" AND
    where_to_find NOT REGEXP "Bareki")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
<br>
{{ImageLocation|Forge of the Nine.jpg|Forge of the Nine|The outside of the Forge of the Nine. A stone patio is equipped with a forge and smithing station.<br>
<hr>
Sold by [[Dammon]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Forge of the Nine%" AND where_to_find like "%Dammon%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Forge of the Nine%" AND where_to_find like "%Dammon%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
[[Forge of the Nine|Basement]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Forge of the Nine%" AND where_to_find NOT REGEXP 'Dammon')
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Forge of the Nine%" AND where_to_find NOT REGEXP 'Dammon')
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Devil's Fee.jpg|Devil's Fee|Owned by [[Helsik]], there are all sorts of devilish artifacts and curios on display around the store.<br>
<hr>
Sold by [[Helsik]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Devil's Fee%" AND where_to_find like "%Helsik%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Devil's Fee%" AND where_to_find like "%Helsik%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
[[Devil's Fee]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Devil's Fee%" AND where_to_find NOT REGEXP "Helsik")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Devil's Fee%" AND where_to_find NOT REGEXP "Helsik")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
<br>
{{ImageLocation|Stormshore Armoury.jpg|Stormshore Armoury|An outdoor smithy with a glowing red hot furnace in the back corner.<br>
<hr>
Sold by [[Gloomy Fentonson]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
Sold by [[Fytz|Fytz The Firecracker]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Fytz%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Fytz%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Sorcerous Sundries.jpg|Sorcerous Sundries|A large magical marketplace, and home to the wizard [[Lorroakan]]<br>
<hr>
Sold by [[Lorroakan's Projection]] (or [[Rolan]])
<hr>
{{#cargo_compound_query:
tables=equipment; where = (
    where_to_find like "%Sorcerous Sundries%" AND
    where_to_find like "%Sold%" AND
    where_to_find like "%Lorroakan's Projection%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
    where_to_find like "%Sorcerous Sundries%" AND
    where_to_find like "%Sold%" AND
    where_to_find like "%Lorroakan's Projection%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
Sold by [[Tolna Tome-Monger]]
<hr>
<i>No special equipment</i>
<hr>
[[Sorcerous Sundries]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (
    where_to_find like "%Sorcerous Sundries%" AND
    where_to_find NOT REGEXP "Sold" AND
    where_to_find NOT REGEXP "Sorcerous Vault")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
    where_to_find like "%Sorcerous Sundries%" AND
    where_to_find NOT REGEXP "Sold" AND
    where_to_find NOT REGEXP "Sorcerous Vault")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Ramazith's View.jpg|Ramazith's Tower|The home of the wizard [[Lorroakan]], only accessible from [[Sorcerous Sundries]].<br>
<hr>
[[Ramazith's Tower]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Ramazith's Tower%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Ramazith's Tower%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Sorcerous Vault.webp|Sorcerous Vault|A secret vault within [[Sorcerous Sundries]] accessible from [[Ramazith's Tower]].<br>
<hr>
[[Sorcerous Vault]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Sorcerous Vault%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Sorcerous Vault%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<br>{{RarityItem|The Tharchiate Codex|20}}
}}
<br>
{{ImageLocation|Philgrave's Mansion.jpg|Philgrave's Mansion|Located by the waterfront next to the [[Counting House]] and [[Felogyr's Fireworks]]<br>
<hr>
Sold by [[Mystic Carrion]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (
    where_to_find like "%Philgrave's Mansion%" AND
    (where_to_find like "%Sold%" OR where_to_find like "%bought%") AND
    where_to_find like "%Mystic Carrion%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
    where_to_find like "%Philgrave's Mansion%" AND
    (where_to_find like "%Sold%" OR where_to_find like "%bought%") AND
    where_to_find like "%Mystic Carrion%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
[[Philgrave's Mansion]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (
    where_to_find like "%Philgrave's Mansion%" AND
    where_to_find NOT REGEXP "Sold" AND
    where_to_find NOT REGEXP "bought")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
    where_to_find like "%Philgrave's Mansion%" AND
    where_to_find NOT REGEXP "Sold" AND
    where_to_find NOT REGEXP "bought")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}


= Equipment By Act and Region =
= Equipment By Act and Region =
Line 12: Line 797:
tables=equipment; where = (where_to_find like "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark")
tables=equipment; where = (where_to_find like "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Nautiloid]]")=Location,  
   fields=CONCAT("[[Prologue]]")=Act,CONCAT("[[Nautiloid]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = (where_to_find like "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark")
|tables=weapons; where = (where_to_find like "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Nautiloid]]")=Location,
   fields=CONCAT("[[Prologue]]")=Act,CONCAT("[[Nautiloid]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
Line 32: Line 817:
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg


|tables=equipment; where = where_to_find like "%Overgrown Ruins%"
|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("[[Act One]]")=Act,CONCAT("[[Overgrown Ruins]]")=Location,  
   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 "%Overgrown Ruins%"
|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("[[Act One]]")=Act,CONCAT("[[Overgrown Ruins]]")=Location,
   fields=CONCAT("[[Overgrown Ruins]]")=Act,CONCAT("[[Dank Crypt]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg     
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg     
Line 45: Line 830:
|tables=equipment; where = (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%")
|tables=equipment; where = (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Druid Grove]]")=Location,  
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Druid Grove]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%")
|tables=weapons; where = (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Druid Grove]]")=Location,
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Druid Grove]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
Line 56: Line 841:
|tables=equipment; where = where_to_find like "%The Risen Road%"
|tables=equipment; where = where_to_find like "%The Risen Road%"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[The Risen Road]]")=Location,  
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[The Risen Road]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%The Risen Road%"
|tables=weapons; where = where_to_find like "%The Risen Road%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[The Risen Road]]")=Location,
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[The Risen Road]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
Line 67: Line 852:
|tables=equipment; where = where_to_find like "%Forest%"
|tables=equipment; where = where_to_find like "%Forest%"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Forest]]")=Location,  
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Forest]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Forest%"
|tables=weapons; where = where_to_find like "%Forest%"
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Forest]]")=Location,
   fields=CONCAT("[[Wilderness]]")=Act,CONCAT("[[Forest]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
 
|tables=equipment; where = where_to_find like "%Owlbear Nest%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Forest]]")=Act,CONCAT("[[Owlbear Nest]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Forest%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Forest]]")=Act,CONCAT("[[Owlbear Nest]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
   
|tables=equipment; where = where_to_find like "%Blighted Village%"
|tables=equipment; where = where_to_find like "%Blighted Village%"
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
Line 298: Line 1,094:
tables=equipment; where = where_to_find like "%Rivington General%"  
tables=equipment; where = where_to_find like "%Rivington General%"  
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Rivington General]]")=Location,  
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington General]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Rivington General%"  
|tables=weapons; where = where_to_find like "%Rivington General%"  
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Rivington General]]")=Location,
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington General]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
      
      
|tables=equipment; where = where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%"
|tables=equipment; where = (where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Requisitioned Barn]]")=Location,  
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Requisitioned Barn]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%"
|tables=weapons; where = (where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Requisitioned Barn]]")=Location,
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Requisitioned Barn]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
Line 320: Line 1,116:
|tables=equipment; where = where_to_find like "%Circus of the Last Days%"  
|tables=equipment; where = where_to_find like "%Circus of the Last Days%"  
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Circus of the Last Days]]")=Location,  
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Circus of the Last Days]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Circus of the Last Days%"  
|tables=weapons; where = where_to_find like "%Circus of the Last Days%"  
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Circus of the Last Days]]")=Location,
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Circus of the Last Days]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg


|tables=equipment; where = where_to_find like "%Open Hand Temple%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Open Hand Temple]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Open Hand Temple%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Open Hand Temple]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
   
|tables=equipment; where = where_to_find like "%Angleiron's Cellar%"  
|tables=equipment; where = where_to_find like "%Angleiron's Cellar%"  
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Angleiron's Cellar]]")=Location,  
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Angleiron's Cellar]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
|tables=weapons; where = where_to_find like "%Angleiron's Cellar%"  
|tables=weapons; where = where_to_find like "%Angleiron's Cellar%"  
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Angleiron's Cellar]]")=Location,
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Angleiron's Cellar]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
Line 346: Line 1,153:
               where_to_find NOT REGEXP "Mattis" AND  
               where_to_find NOT REGEXP "Mattis" AND  
               where_to_find NOT REGEXP "Circus of the Last Days" AND  
               where_to_find NOT REGEXP "Circus of the Last Days" AND  
              where_to_find NOT REGEXP "Open Hand Temple" AND
               where_to_find NOT REGEXP "Angleiron's Cellar")
               where_to_find NOT REGEXP "Angleiron's Cellar")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Rivington]]")=Location,  
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington]]")=Location,  
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
     special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC  
Line 357: Line 1,165:
               where_to_find NOT REGEXP "Mattis" AND  
               where_to_find NOT REGEXP "Mattis" AND  
               where_to_find NOT REGEXP "Circus of the Last Days" AND  
               where_to_find NOT REGEXP "Circus of the Last Days" AND  
              where_to_find NOT REGEXP "Open Hand Temple" AND
               where_to_find NOT REGEXP "Angleiron's Cellar")
               where_to_find NOT REGEXP "Angleiron's Cellar")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Rivington]]")=Location,
   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
Line 374: Line 1,183:
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg


|tables=equipment; where = where_to_find like "%Wyrm's Rock Fortress%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Rock Fortress]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Wyrm's Rock Fortress%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Wyrm's Rock Fortress]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
   
|tables=equipment; where = (
|tables=equipment; where = (
               where_to_find like "%Lower City%" AND  
               where_to_find like "%Lower City%" AND  
               where_to_find NOT REGEXP 'Lower City Sewers' AND  
               where_to_find NOT REGEXP 'Lower City Sewers' AND  
              where_to_find NOT REGEXP 'Undercity Ruins' AND
               where_to_find NOT REGEXP 'Forge of the Nine' AND  
               where_to_find NOT REGEXP 'Forge of the Nine' AND  
               where_to_find NOT REGEXP 'Stormshore Tabernacle' AND  
               where_to_find NOT REGEXP 'Stormshore Tabernacle' AND  
              where_to_find NOT REGEXP 'Stormshore Armoury' AND
               where_to_find NOT REGEXP 'Sorcerous Sundries' AND  
               where_to_find NOT REGEXP 'Sorcerous Sundries' AND  
               where_to_find NOT REGEXP 'Wine Festival' AND  
               where_to_find NOT REGEXP 'Wine Festival' AND  
               where_to_find NOT REGEXP "Devil's Fee" AND  
               where_to_find NOT REGEXP "Devil's Fee" AND  
              where_to_find NOT REGEXP "The Counting House" AND
               where_to_find NOT REGEXP "Philgrave's Mansion" AND  
               where_to_find NOT REGEXP "Philgrave's Mansion" AND  
               where_to_find NOT REGEXP 'Steel Watch Foundry' AND  
               where_to_find NOT REGEXP 'Steel Watch Foundry' AND  
Line 392: Line 1,215:
               where_to_find like "%Lower City%" AND  
               where_to_find like "%Lower City%" AND  
               where_to_find NOT REGEXP 'Lower City Sewers' AND  
               where_to_find NOT REGEXP 'Lower City Sewers' AND  
              where_to_find NOT REGEXP 'Undercity Ruins' AND
               where_to_find NOT REGEXP 'Forge of the Nine' AND  
               where_to_find NOT REGEXP 'Forge of the Nine' AND  
               where_to_find NOT REGEXP 'Stormshore Tabernacle' AND  
               where_to_find NOT REGEXP 'Stormshore Tabernacle' AND  
              where_to_find NOT REGEXP 'Stormshore Armoury' AND
               where_to_find NOT REGEXP 'Sorcerous Sundries' AND  
               where_to_find NOT REGEXP 'Sorcerous Sundries' AND  
               where_to_find NOT REGEXP 'Wine Festival' AND  
               where_to_find NOT REGEXP 'Wine Festival' AND  
               where_to_find NOT REGEXP "Devil's Fee" AND  
               where_to_find NOT REGEXP "Devil's Fee" AND  
              where_to_find NOT REGEXP "The Counting House" AND
               where_to_find NOT REGEXP "Philgrave's Mansion" AND  
               where_to_find NOT REGEXP "Philgrave's Mansion" AND  
               where_to_find NOT REGEXP 'Steel Watch Foundry' AND  
               where_to_find NOT REGEXP 'Steel Watch Foundry' AND  
Line 435: Line 1,261:
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Stormshore Tabernacle]]")=Location,
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Stormshore Tabernacle]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
   
|tables=equipment; where = where_to_find like "%Stormshore Armoury%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[Stormshore Armoury]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Stormshore Armoury%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[Stormshore Armoury]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
Line 460: Line 1,297:
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg


|tables=equipment; where = where_to_find like "%Philgrave%s Mansion%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
|tables=weapons; where = where_to_find like "%Philgrave%s Mansion%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=Location,
    CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
    special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
   
|tables=equipment; where = where_to_find like "%Devil%Fee%"  
|tables=equipment; where = where_to_find like "%Devil%Fee%"  
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
Line 471: Line 1,319:
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg


|tables=equipment; where = where_to_find like "%Philgrave%s Mansion%"  
|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("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=Location,  
   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 "%Philgrave%s Mansion%"  
|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("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=Location,
   fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[The Counting House]]")=Location,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
Line 1,146: Line 1,994:


-->
-->
= Stats Equipment =
{{ImageLocation|Strength_Score_Icon.png|Strength|
<hr>
'''Bonus'''
<hr>
{{RarityItem|Gauntlets of Hill Giant Strength|20}}
{{RarityItem|The Mighty Cloth|20}}
<hr>
'''Advantage'''
<hr>
{{RarityItem|The Mighty Cloth|20}}
}}
{{ImageLocation|Dexterity_Score_Icon.png|Dexterity|
<hr>
'''Bonus'''
<hr>
{{RarityItem|Gloves of Dexterity|20}}<br>
{{RarityItem|The Graceful Cloth|20}}
<hr>
'''Advantage'''
<hr>
{{RarityItem|The Graceful Cloth|20}}
}}
{{ImageLocation|Intelligence_Score_Icon.png|Intelligence|
<hr>
'''Bonus'''
<hr>
{{RarityItem|Warped Headband of Intellect|20}}
}}
<hr>
{{ImageLocation|Stealth_Icon.png|Stealth|Dexterity
<hr>
'''Bonus'''
<hr>
{{#cargo_compound_query:
tables=equipment; where = (special like "%Stealth%" AND special NOT REGEXP "Advantage" AND special NOT REGEXP "Disadvantage")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (special like "%Stealth%" AND special NOT REGEXP "Advantage" AND special NOT REGEXP "Disadvantage")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
'''Advantage'''
<hr>
{{#cargo_compound_query:
tables=equipment; where = (special like "%Stealth%" AND special like "%Advantage%" AND special NOT REGEXP "Disadvantage")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (special like "%Stealth%" AND special like "%Advantage%" AND special NOT REGEXP "Disadvantage")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
'''No Disadvantage'''
<hr>
{{#cargo_compound_query:
tables=equipment; where = (special like "%Stealth%" AND special like "%Disadvantage%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (special like "%Stealth%" AND special like "%Disadvantage%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Sleight_of_Hand_Icon.png|Sleight of Hand|Dexterity
<hr>
'''Bonus'''
<hr>
{{#cargo_compound_query:
tables=equipment; where = (special like "%Sleight%" AND special NOT REGEXP "Advantage")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (special like "%Sleight%" AND special NOT REGEXP "Advantage")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
'''Advantage'''
<hr>
{{#cargo_compound_query:
tables=equipment; where = (special like "%Sleight%" AND special like "%Advantage%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (special like "%Sleight%" AND special like "%Advantage%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Arcana_Icon.png|Arcana|Intelligence
<hr>
'''Bonus'''
<hr>
{{#cargo_compound_query:
tables=equipment; where = (special like "%Arcana%" AND special NOT REGEXP "Advantage")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (special like "%Arcana%" AND special NOT REGEXP "Advantage")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
[[Template:ImageLocation]]
[[Special:CargoTables]] [[Special:Drilldown]]
{{Gameplay mechanics}}
{{Gameplay mechanics}}
Korgat
308
edits
Retrieved from "https://bg3.wiki/wiki/Special:MobileDiff/153254...153815"

Navigation menu