308
editsUser:Korgat: Difference between revisions
Jump to navigation
Jump to search
→Act Three: merchants
No edit summary |
(→Act Three: merchants) |
||
| Line 162: | Line 162: | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "%Rivington General%" | 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> | |||
}} | |||
<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; | 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 "%Rivington General%" | |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; | 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 174: | Line 201: | ||
{{ImageLocation|Requisitioned Barn.jpg|Requisitioned Barn|The '''Requisitioned Barn''' is a donation center for refugees heading to Baldur's Gate.<br> | {{ImageLocation|Requisitioned Barn.jpg|Requisitioned Barn|The '''Requisitioned Barn''' is a donation center for refugees heading to Baldur's Gate.<br> | ||
<hr> | <hr> | ||
[[Ferg Drogher]] | Sold by [[Ferg Drogher]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
| Line 187: | Line 214: | ||
}} | }} | ||
<hr> | <hr> | ||
[[Mattis]] | Sold by [[Mattis]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
| Line 390: | Line 417: | ||
{{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> | {{ImageLocation|Forge of the Nine.jpg|Forge of the Nine|The outside of the Forge of the Nine. A stone patio is equipped with a forge and smithing station.<br> | ||
<hr> | <hr> | ||
[[Dammon]] | Sold by [[Dammon]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
| Line 418: | Line 445: | ||
{{ImageLocation|Stormshore Armoury.jpg|Stormshore Armoury|An outdoor smithy with a glowing red hot furnace in the back corner.<br> | {{ImageLocation|Stormshore Armoury.jpg|Stormshore Armoury|An outdoor smithy with a glowing red hot furnace in the back corner.<br> | ||
<hr> | <hr> | ||
[[Gloomy Fentonson]] | Sold by [[Gloomy Fentonson]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
| Line 431: | Line 458: | ||
}} | }} | ||
<hr> | <hr> | ||
[[Fytz|Fytz The Firecracker]] | Sold by [[Fytz|Fytz The Firecracker]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||