User:Korgat: Difference between revisions

User:Korgat (edit)

Revision as of 19:52, 18 February 2024

1,746 bytes added , 18 February

→‎Act One: Auntie Ethel and Volo

Korgat

308

edits

@@ Line 68: / Line 68: @@
      (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
      where_to_find like "%Dammon%") AND
+    where_to_find NOT REGEXP "Strange Ox"
+    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 [[Auntie Ethel]]
+<hr>
+{{#cargo_compound_query:
+tables=equipment; where = (
+    (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
+    where_to_find like "%Auntie Ethel%") AND
+    where_to_find NOT REGEXP "Strange Ox"
+    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 "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
+    where_to_find like "%Auntie Ethel%") AND
+    where_to_find NOT REGEXP "Strange Ox"
+    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 [[Volo]]
+<hr>
+{{#cargo_compound_query:
+tables=equipment; where = (
+    (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
+    where_to_find like "%Volo%") AND
+    where_to_find NOT REGEXP "Strange Ox"
+    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 "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
+    where_to_find like "%Volo%") AND
      where_to_find NOT REGEXP "Strange Ox"
      AND rarity != "common" AND legacy IS NULL;
@@ Line 81: / Line 119: @@
      ((where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
      where_to_find NOT REGEXP "Dammon" AND
-     where_to_find NOT REGEXP "Arron") OR
+     where_to_find NOT REGEXP "Arron" AND
+    where_to_find NOT REGEXP "Auntie Ethel" AND
+    where_to_find NOT REGEXP "Volo") OR
      where_to_find like "%Strange Ox%")
      AND rarity != "common" AND legacy IS NULL;
@@ Line 88: / Line 128: @@
      ((where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
      where_to_find NOT REGEXP "Dammon" AND
-     where_to_find NOT REGEXP "Arron") OR
+     where_to_find NOT REGEXP "Arron" AND
+    where_to_find NOT REGEXP "Auntie Ethel" AND
+    where_to_find NOT REGEXP "Volo") OR
      where_to_find like "%Strange Ox%")
      AND rarity != "common" AND legacy IS NULL;