User:Korgat: Difference between revisions

User:Korgat (edit)

Revision as of 19:41, 18 February 2024

2,084 bytes added , 18 February

→‎Act Three

Korgat

308

edits

@@ Line 417: / Line 417: @@
 }}
 {{ImageLocation|Lower City Sewers North.jpg|Lower City Sewers|Entrances include manhole covers in the city streets, and inside specific buildings.<br>
+<hr>
+Sold by [[Severn]]
+<hr>
+{{#cargo_compound_query:
+tables=equipment; where = where_to_find like "%Severn%"
+    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 "%Severn%"
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
+|format=list
+|delimiter=<br>
+}}
+<hr>
+Sold by [[Sticky Dondo]]
+<hr>
+{{#cargo_compound_query:
+tables=equipment; where = where_to_find like "%Sticky Dondo%"
+    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 "%Sticky Dondo%"
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
+|format=list
+|delimiter=<br>
+}}
+<hr>
+Sold by [[Voiceless Penitent Bareki]]
+<hr>
+{{#cargo_compound_query:
+tables=equipment; where = where_to_find like "%Bareki%"
+    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 "%Bareki%"
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
+|format=list
+|delimiter=<br>
+}}
 <hr>
 [[Lower City Sewers]]
 <hr>
 {{#cargo_compound_query:
-tables=equipment; where = where_to_find like "%Lower City Sewers%"
+tables=equipment; where = (
+    where_to_find like "%Lower City Sewers%" AND
+    where_to_find NOT REGEXP "Severn" AND
+    where_to_find NOT REGEXP "Sticky Dondo" AND
+    where_to_find NOT REGEXP "Bareki")
      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 Sewers%"
+|tables=weapons; where = (
+    where_to_find like "%Lower City Sewers%" AND
+    where_to_find NOT REGEXP "Severn" AND
+    where_to_find NOT REGEXP "Sticky Dondo" AND
+    where_to_find NOT REGEXP "Bareki")
      AND rarity != "common" AND legacy IS NULL;
    fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
@@ Line 434: / Line 481: @@
 <hr>
 {{#cargo_compound_query:
-tables=equipment; where = where_to_find like "%Undercity Ruins%"
+tables=equipment; where = (
+    where_to_find like "%Undercity Ruins%" AND
+    where_to_find NOT REGEXP "Severn" AND
+    where_to_find NOT REGEXP "Sticky Dondo" AND
+    where_to_find NOT REGEXP "Bareki")
      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 "%Undercity Ruins%"
+|tables=weapons; where = (
+    where_to_find like "%Undercity Ruins%" AND
+    where_to_find NOT REGEXP "Severn" AND
+    where_to_find NOT REGEXP "Sticky Dondo" AND
+    where_to_find NOT REGEXP "Bareki")
      AND rarity != "common" AND legacy IS NULL;
    fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type