308
editsMore actions
→Act Three
| 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 757: | Line 745: | ||
}} | }} | ||
<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: | |||
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> | |||
}} | |||
}} | }} | ||