User:Korgat: Difference between revisions

User:Korgat (edit)

Revision as of 15:26, 18 February 2024

1,627 bytes added , 18 February

no edit summary

Korgat

308

edits

@@ Line 40: / Line 40: @@
 <hr>
 {{#cargo_compound_query:
-tables=equipment; where = (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%")
+tables=equipment; where = (
+    ((where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND
+    where_to_find NOT REGEXP "Dammon") OR
+    where_to_find like "%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 NOT REGEXP "Dammon") OR
+    where_to_find like "%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>
+[[Dammon]]
+<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 "%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
-|tables=weapons; where = (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%")
+|tables=weapons; where = (
+    (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
@@ Line 365: / Line 390: @@
 {{ImageLocation|Forge of the Nine.jpg|Forge of the Nine|The outside of the Forge of the Nine. A stone patio is equipped with a forge and smithing station.<br>
 <hr>
-[[Forge of the Nine]]
+[[Dammon]]
+<hr>
+{{#cargo_compound_query:
+tables=equipment; where = (where_to_find like "%Forge of the Nine%" AND where_to_find like "%Dammon%")
+    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 "%Forge of the Nine%" AND where_to_find like "%Dammon%")
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
+|format=list
+|delimiter=<br>
+}}
+<hr>
+[[Forge of the Nine|Basement]]
 <hr>
 {{#cargo_compound_query:
-tables=equipment; where = where_to_find like "%Forge of the Nine%"
+tables=equipment; where = (where_to_find like "%Forge of the Nine%" AND where_to_find NOT REGEXP 'Dammon')
      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 "%Forge of the Nine%"
+|tables=weapons; where = (where_to_find like "%Forge of the Nine%" AND where_to_find NOT REGEXP 'Dammon')
      AND rarity != "common" AND legacy IS NULL;
    fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type