User:Korgat: Difference between revisions

Jump to navigation Jump to search
 
Line 614: Line 614:
}}
}}
}}
}}
{{ImageLocation|Stormshore Armoury.jpg|Stormshore Armoury|An outdoor smithy with a glowing red hot furnace in the back corner.<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>
<hr>
Sold by [[Gloomy Fentonson]]
Sold by [[Helsik]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%")
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 "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%")
|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>
Sold by [[Fytz|Fytz The Firecracker]]
[[Devil's Fee]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Fytz%")
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 "%Stormshore Armoury%" AND where_to_find like "%Fytz%")
|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|Philgrave's Mansion.jpg|Philgrave's Mansion|Located by the waterfront next to the [[Counting House]] and [[Felogyr's Fireworks]]<br>
<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 [[Mystic Carrion]]
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%")
    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=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%")
    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=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>
[[Philgrave's Mansion]]
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%")
    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("[[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%")
    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("[[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:
}}
}}
}}
}}
<br>
{{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>
}}
}}
}}


Retrieved from "https://bg3.wiki/wiki/User:Korgat"