Ad placeholder

User:Korgat: Difference between revisions

Jump to navigation Jump to search

User:Korgat (edit)

Revision as of 04:36, 18 February 2024

4,984 bytes added ,  18 February
no edit summary
No edit summary
No edit summary
Line 252: Line 252:
}}
}}
}}
}}
 
<br>
{{ImageLocation|Lower City.jpg|Lower City|The Lower City is accessed after passing through [[Wyrm's Rock Fortress]].<br>
<hr>
[[Lower City]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (
              where_to_find like "%Lower City%" AND
              where_to_find NOT REGEXP 'Lower City Sewers' AND
              where_to_find NOT REGEXP 'Forge of the Nine' AND
              where_to_find NOT REGEXP 'Stormshore Tabernacle' AND
              where_to_find NOT REGEXP 'Stormshore Armoury' AND
              where_to_find NOT REGEXP 'Sorcerous Sundries' AND
              where_to_find NOT REGEXP 'Wine Festival' AND
              where_to_find NOT REGEXP "Devil's Fee" AND
              where_to_find NOT REGEXP "Philgrave's Mansion" AND
              where_to_find NOT REGEXP 'Steel Watch Foundry' AND
              where_to_find NOT REGEXP 'Undercity Ruins')
    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 "%Lower City%" AND
              where_to_find NOT REGEXP 'Lower City Sewers' AND
              where_to_find NOT REGEXP 'Forge of the Nine' AND
              where_to_find NOT REGEXP 'Stormshore Tabernacle' AND
              where_to_find NOT REGEXP 'Stormshore Armoury' AND
              where_to_find NOT REGEXP 'Sorcerous Sundries' AND
              where_to_find NOT REGEXP 'Wine Festival' AND
              where_to_find NOT REGEXP "Devil's Fee" AND
              where_to_find NOT REGEXP "Philgrave's Mansion" AND
              where_to_find NOT REGEXP 'Steel Watch Foundry' AND
              where_to_find NOT REGEXP 'Undercity Ruins')
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}
{{ImageLocation|Stormshore Armoury.jpg|Stormshore Armoury|An outdoor smithy with a glowing red hot furnace in the back corner.<br>
<hr>
[[Gloomy Fentonson]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%")
    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 "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
[[Fytz|Fytz The Firecracker]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Fytz%")
    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 "%Stormshore Armoury%" AND where_to_find like "%Fytz%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
}}


= Equipment By Act and Region =
= Equipment By Act and Region =
Line 665: Line 730:
               where_to_find NOT REGEXP 'Forge of the Nine' AND  
               where_to_find NOT REGEXP 'Forge of the Nine' AND  
               where_to_find NOT REGEXP 'Stormshore Tabernacle' AND  
               where_to_find NOT REGEXP 'Stormshore Tabernacle' AND  
              where_to_find NOT REGEXP 'Stormshore Armoury' AND
               where_to_find NOT REGEXP 'Sorcerous Sundries' AND  
               where_to_find NOT REGEXP 'Sorcerous Sundries' AND  
               where_to_find NOT REGEXP 'Wine Festival' AND  
               where_to_find NOT REGEXP 'Wine Festival' AND  
               where_to_find NOT REGEXP "Devil's Fee" AND  
               where_to_find NOT REGEXP "Devil's Fee" AND  
              where_to_find NOT REGEXP "The Counting House" AND
               where_to_find NOT REGEXP "Philgrave's Mansion" AND  
               where_to_find NOT REGEXP "Philgrave's Mansion" AND  
               where_to_find NOT REGEXP 'Steel Watch Foundry' AND  
               where_to_find NOT REGEXP 'Steel Watch Foundry' AND  
Line 680: Line 747:
               where_to_find NOT REGEXP 'Forge of the Nine' AND  
               where_to_find NOT REGEXP 'Forge of the Nine' AND  
               where_to_find NOT REGEXP 'Stormshore Tabernacle' AND  
               where_to_find NOT REGEXP 'Stormshore Tabernacle' AND  
              where_to_find NOT REGEXP 'Stormshore Armoury' AND
               where_to_find NOT REGEXP 'Sorcerous Sundries' AND  
               where_to_find NOT REGEXP 'Sorcerous Sundries' AND  
               where_to_find NOT REGEXP 'Wine Festival' AND  
               where_to_find NOT REGEXP 'Wine Festival' AND  
               where_to_find NOT REGEXP "Devil's Fee" AND  
               where_to_find NOT REGEXP "Devil's Fee" AND  
              where_to_find NOT REGEXP "The Counting House" AND
               where_to_find NOT REGEXP "Philgrave's Mansion" AND  
               where_to_find NOT REGEXP "Philgrave's Mansion" AND  
               where_to_find NOT REGEXP 'Steel Watch Foundry' AND  
               where_to_find NOT REGEXP 'Steel Watch Foundry' AND  
Line 721: Line 790:
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Stormshore Tabernacle]]")=Location,
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Stormshore Tabernacle]]")=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 "%Stormshore Armoury%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[Stormshore Armoury]]")=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 "%Stormshore Armoury%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[Stormshore Armoury]]")=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 754: Line 834:
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Devil's Fee]]")=Location,
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Devil's Fee]]")=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 "%The Counting House%"
    AND rarity != "common" AND legacy IS NULL;
  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, armour_class=AC
|tables=weapons; where = where_to_find like "%The Counting House%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[The Counting House]]")=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
Korgat
308
edits
Retrieved from "https://bg3.wiki/wiki/Special:MobileDiff/153567"

Navigation menu