User:Korgat: Difference between revisions

User:Korgat (edit)

Revision as of 04:17, 19 February 2024

2,484 bytes added , 19 February

→‎Stats Equipment

Korgat

308

edits

@@ Line 1,968: / Line 1,968: @@
 = Stats Equipment =
+{{ImageLocation|Stealth_Icon.png|Stealth|
+<hr>
+'''Bonus'''
+<hr>
+{{#cargo_compound_query:
+tables=equipment; where = (special like "%Stealth%" AND special NOT REGEXP "Advantage" AND special NOT REGEXP "Disadvantage")
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
+|tables=weapons; where = (special like "%Stealth%" AND special NOT REGEXP "Advantage" AND special NOT REGEXP "Disadvantage")
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
+|format=list
+|delimiter=<br>
+}}
+<hr>
+'''Advantage'''
+<hr>
+{{#cargo_compound_query:
+tables=equipment; where = (special like "%Stealth%" AND special like "%Advantage%" AND special NOT REGEXP "Disadvantage")
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
+|tables=weapons; where = (special like "%Stealth%" AND special like "%Advantage%" AND special NOT REGEXP "Disadvantage")
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
+|format=list
+|delimiter=<br>
+}}
+<hr>
+'''No Disadvantage'''
+<hr>
+{{#cargo_compound_query:
+tables=equipment; where = (special like "%Stealth%" AND special like "%Disadvantage%")
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
+|tables=weapons; where = (special like "%Stealth%" AND special like "%Disadvantage%")
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
+|format=list
+|delimiter=<br>
+}}
+}}
 {{ImageLocation|Sleight_of_Hand_Icon.png|Sleight of Hand|
 <hr>
-'''Items'''
+'''Bonus'''
+<hr>
+{{#cargo_compound_query:
+tables=equipment; where = (special like "%Sleight%" AND special NOT REGEXP "Advantage")
+    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 special NOT REGEXP "Advantage")
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
+|format=list
+|delimiter=<br>
+}}
+<hr>
+'''Advantage'''
 <hr>
 {{#cargo_compound_query:
-tables=equipment; where = (special like "%Sleight%")
+tables=equipment; where = (special like "%Sleight%" AND special like "%Advantage%")
      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%")
+|tables=weapons; where = (special like "%Sleight%" AND special like "%Advantage%")
      AND rarity != "common" AND legacy IS NULL;
    fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type