Ad placeholder

User:Korgat: Difference between revisions

Jump to navigation Jump to search
1,150 bytes added ,  18 February
→‎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:
308
edits

Navigation menu