308
edits→Act Three
(2 intermediate revisions by the same user not shown) | |||
Line 614: | 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 629: | 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 642: | Line 642: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation| | <br> | ||
{{ImageLocation|Stormshore Armoury.jpg|Stormshore Armoury|An outdoor smithy with a glowing red hot furnace in the back corner.<br> | |||
<hr> | <hr> | ||
Sold by [[ | Sold by [[Gloomy Fentonson]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = ( | tables=equipment; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = ( | |tables=weapons; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 663: | Line 658: | ||
}} | }} | ||
<hr> | <hr> | ||
[[ | Sold by [[Fytz|Fytz The Firecracker]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = ( | tables=equipment; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Fytz%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | ||
|tables=weapons; where = ( | |tables=weapons; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Fytz%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | ||
Line 682: | Line 671: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation|Sorcerous Sundries.jpg|Sorcerous Sundries|A large magical marketplace, and home to the wizard [[Lorroakan]]<br> | {{ImageLocation|Sorcerous Sundries.jpg|Sorcerous Sundries|A large magical marketplace, and home to the wizard [[Lorroakan]]<br> | ||
<hr> | <hr> | ||
Line 758: | Line 746: | ||
<br>{{RarityItem|The Tharchiate Codex|20}} | <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: | {{#cargo_compound_query: | ||
tables=equipment; where = ( | |||
tables=equipment; where = (where_to_find like "% | 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=CONCAT("[[Act One]]")=Act,CONCAT("[[ | 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 = | |||
== <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("[[Act One]]")=Act,CONCAT("[[Ravaged Beach]]")=Location, | fields=CONCAT("[[Prologue]]")=Act,CONCAT("[[Nautiloid]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
|tables=equipment; where = where_to_find like "%Ravaged Beach%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Ravaged Beach]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | |||
|tables=weapons; where = where_to_find like "%Ravaged Beach%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
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 | ||
Line 1,958: | Line 1,987: | ||
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> | <hr> | ||
{{ImageLocation|Stealth_Icon.png|Stealth|Dexterity | |||
{{ImageLocation|Stealth_Icon.png|Stealth| | |||
<hr> | <hr> | ||
'''Bonus''' | '''Bonus''' | ||
Line 2,020: | Line 2,067: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation|Sleight_of_Hand_Icon.png|Sleight of Hand| | {{ImageLocation|Sleight_of_Hand_Icon.png|Sleight of Hand|Dexterity | ||
<hr> | <hr> | ||
'''Bonus''' | '''Bonus''' | ||
Line 2,048: | Line 2,095: | ||
}} | }} | ||
}} | }} | ||
{{ImageLocation|Arcana_Icon.png|Arcana|Intelligence | |||
{{ImageLocation|Arcana_Icon.png|Arcana| | |||
<hr> | <hr> | ||
'''Bonus''' | '''Bonus''' |