User:Korgat: Difference between revisions

User:Korgat (edit)

Revision as of 02:43, 19 February 2024

2,176 bytes added , 19 February

no edit summary

Korgat

308

edits

@@ Line 621: / Line 621: @@
 {{ImageLocation|Sorcerous Sundries.jpg|Sorcerous Sundries|A large magical marketplace, and home to the wizard [[Lorroakan]]<br>
 <hr>
-Sold by [[Lorroakan's Projection]] (or [[Rolan]]):
+Sold by [[Lorroakan's Projection]] (or [[Rolan]])
 <hr>
 {{#cargo_compound_query:
@@ Line 655: / Line 655: @@
      where_to_find like "%Sorcerous Sundries%" AND
      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;
    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
+|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%"
      AND rarity != "common" AND legacy IS NULL;
@@ Line 1,190: / Line 1,241: @@
      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, 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
@@ 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]]
 [[Special:CargoTables]] [[Special:Drilldown]]
 {{Gameplay mechanics}}