User:Korgat: Difference between revisions

User:Korgat (edit)

Revision as of 06:02, 17 February 2024

5,532 bytes added , 17 February

no edit summary

Korgat

308

edits

@@ Line 103: / Line 103: @@
 == [[Act Three]] ==
-{{ImageLocation|Open Hand Temple Front.jpg|Open Hand Temple|A temple dedicated to Ilmater, currently grieving the loss of their head priest<br>
+{{ImageLocation|Rivington.jpg|Rivington|The southern-most district of Baldur's Gate, located south of [[Wyrm's Crossing]].<br>
-[[Open Hand Temple Cellar]]<br>
+<hr>
-[[Under Temple Cave Area]]
+[[Rivington]]
+<hr>
+{{#cargo_compound_query:
+tables=equipment; where = (
+              where_to_find like "%Rivington%" AND
+              where_to_find NOT REGEXP "Rivington General" AND
+              where_to_find NOT REGEXP "Ferg Drogher" AND
+              where_to_find NOT REGEXP "Mattis" AND
+              where_to_find NOT REGEXP "Circus of the Last Days" AND
+              where_to_find NOT REGEXP "Open Hand Temple" AND
+              where_to_find NOT REGEXP "Angleiron's Cellar")
+    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%" AND
+              where_to_find NOT REGEXP "Rivington General" AND
+              where_to_find NOT REGEXP "Ferg Drogher" AND
+              where_to_find NOT REGEXP "Mattis" AND
+              where_to_find NOT REGEXP "Circus of the Last Days" AND
+              where_to_find NOT REGEXP "Open Hand Temple" AND
+              where_to_find NOT REGEXP "Angleiron's Cellar")
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
+|format=list
+|delimiter=<br>
+}}
+}}
+{{ImageLocation|Rivington General.jpg|Rivington General|The general store in [[Rivington]], run by a Dragonborn [[Exxvikyap]].<br>
+<hr>
+[[Rivington General]]
+<hr>
+{{#cargo_compound_query:
+tables=equipment; where = where_to_find like "%Rivington General%"
+    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 rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
+|format=list
+|delimiter=<br>
+}}
+}}
+{{ImageLocation|Requisitioned Barn.jpg|Requisitioned Barn|The '''Requisitioned Barn''' is a donation center for refugees heading to Baldur's Gate.<br>
+<hr>
+[[Requisitioned Barn]]
+<hr>
+{{#cargo_compound_query:
+tables=equipment; where = (where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%")
+    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 "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%")
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
+|format=list
+|delimiter=<br>
+}}
+}}
+<br>
+{{ImageLocation|Circus of the Last Days.jpg|Circus of the Last Days|An extraplanar circus which moves from plane to plane, "thrilling all" who stop by.<br>
+<hr>
+[[Circus of the Last Days]]
+<hr>
+{{#cargo_compound_query:
+tables=equipment; where = where_to_find like "%Circus of the Last Days%"
+    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 "%Circus of the Last Days%"
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
+|format=list
+|delimiter=<br>
+}}
+}}
+{{ImageLocation|Open Hand Temple.jpg|Open Hand Temple|A temple dedicated to Ilmater, currently grieving the loss of their head priest.<br>
+<hr>
+[[Open Hand Temple]]
+<hr>
+{{#cargo_compound_query:
+tables=equipment; where = where_to_find like "%Open Hand Temple%"
+    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 "%Open Hand Temple%"
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
+|format=list
+|delimiter=<br>
+}}
+}}
+{{ImageLocation|Ironhand_Cave_Location_Blocked.png|Angleiron's Cellar|The [[Clan Ironhand|Ironhand Gnomes]] who escaped the [[Grymforge]] have taken up residence in this cellar.<br>
+<hr>
+[[Angleiron's Cellar]]
+<hr>
+{{#cargo_compound_query:
+tables=equipment; where = where_to_find like "%Angleiron's Cellar%"
+    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 "%Angleiron's Cellar%"
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
+|format=list
+|delimiter=<br>
+}}
 }}
@@ Line 414: / Line 515: @@
 tables=equipment; where = where_to_find like "%Rivington General%"
      AND rarity != "common" AND legacy IS NULL;
-   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Rivington General]]")=Location,
+   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington General]]")=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 "%Rivington General%"
      AND rarity != "common" AND legacy IS NULL;
-   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Rivington General]]")=Location,
+   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington General]]")=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 "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%"
+|tables=equipment; where = (where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%")
      AND rarity != "common" AND legacy IS NULL;
-   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Requisitioned Barn]]")=Location,
+   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Requisitioned Barn]]")=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 "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%"
+|tables=weapons; where = (where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%")
      AND rarity != "common" AND legacy IS NULL;
-   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Requisitioned Barn]]")=Location,
+   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Requisitioned Barn]]")=Location,
      CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
      special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
@@ Line 436: / Line 537: @@
 |tables=equipment; where = where_to_find like "%Circus of the Last Days%"
      AND rarity != "common" AND legacy IS NULL;
-   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Circus of the Last Days]]")=Location,
+   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Circus of the Last Days]]")=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 "%Circus of the Last Days%"
      AND rarity != "common" AND legacy IS NULL;
-   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Circus of the Last Days]]")=Location,
+   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Circus of the Last Days]]")=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 "%Open Hand Temple%"
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Open Hand Temple]]")=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 "%Open Hand Temple%"
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Open Hand Temple]]")=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 "%Angleiron's Cellar%"
      AND rarity != "common" AND legacy IS NULL;
-   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Angleiron's Cellar]]")=Location,
+   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Angleiron's Cellar]]")=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 "%Angleiron's Cellar%"
      AND rarity != "common" AND legacy IS NULL;
-   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Angleiron's Cellar]]")=Location,
+   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Angleiron's Cellar]]")=Location,
      CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
      special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
@@ Line 462: / Line 574: @@
                where_to_find NOT REGEXP "Mattis" AND
                where_to_find NOT REGEXP "Circus of the Last Days" AND
+              where_to_find NOT REGEXP "Open Hand Temple" AND
                where_to_find NOT REGEXP "Angleiron's Cellar")
      AND rarity != "common" AND legacy IS NULL;
-   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Rivington]]")=Location,
+   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington]]")=Location,
      CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item,
      special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC
@@ Line 473: / Line 586: @@
                where_to_find NOT REGEXP "Mattis" AND
                where_to_find NOT REGEXP "Circus of the Last Days" AND
+              where_to_find NOT REGEXP "Open Hand Temple" AND
                where_to_find NOT REGEXP "Angleiron's Cellar")
      AND rarity != "common" AND legacy IS NULL;
-   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Rivington]]")=Location,
+   fields=CONCAT("[[Rivington]]")=Act,CONCAT("[[Rivington]]")=Location,
      CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item,
      special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg