Ad placeholder

User:Korgat: Difference between revisions

Jump to navigation Jump to search

User:Korgat (edit)

Revision as of 02:43, 19 February 2024

2,176 bytes added ,  19 February
no edit summary
No edit summary
Line 621: Line 621:
{{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>
Sold by [[Lorroakan's Projection]] (or [[Rolan]]):
Sold by [[Lorroakan's Projection]] (or [[Rolan]])
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
Line 655: Line 655:
     where_to_find like "%Sorcerous Sundries%" AND
     where_to_find like "%Sorcerous Sundries%" AND
     where_to_find NOT REGEXP "Sold")
     where_to_find NOT REGEXP "Sold")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<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;
     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 1,171: Line 1,211:
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
     special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg


|tables=equipment; where = where_to_find like "%Philgrave%s Mansion%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=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 "%Philgrave%s Mansion%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=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 "%Devil%Fee%"  
|tables=equipment; where = where_to_find like "%Devil%Fee%"  
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
Line 1,190: Line 1,241:
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[The Counting House]]")=Location,
   fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[The Counting House]]")=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 "%Philgrave%s Mansion%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=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 "%Philgrave%s Mansion%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=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,868: Line 1,908:


-->
-->
= Stats Equipment =
{{ImageLocation|Prologue.webp|Sleight of Hand|
{{#cargo_compound_query:
tables=equipment; where = (special like "%Sleight%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (special like "%Sleight%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
[[Template:ImageLocation]]
[[Template:ImageLocation]]
[[Special:CargoTables]] [[Special:Drilldown]]
[[Special:CargoTables]] [[Special:Drilldown]]
{{Gameplay mechanics}}
{{Gameplay mechanics}}
Korgat
308
edits
Retrieved from "https://bg3.wiki/wiki/Special:MobileDiff/153758"

Navigation menu