Hit bonus: Difference between revisions

Hit bonus (view source)

625 bytes added , 13:55, 1 October 2021

add queries for ToHit

8,290

edits

@@ Line 6: / Line 6: @@
 == Items by Hit Bonus ==
-{{missing info| We should add a cargo query to show weapons (and armor) that have a hit bonus value, but I don't think we've loaded that value into cargo yet. There are fewer than 20 such items, I believe.}}
+=== Equippable Items ===
+{{#cargo_query:
+  | tables = ItemsTable=IT
+  | fields =
+      CONCAT('{{((}}favilink id{{!}}',CONCAT(IT.ObjectID),'{{))}}')=Weapon or Equipment,
+      CONCAT(CASE WHEN ToHit > 0 THEN CONCAT('+',ToHit) ELSE ToHit END)=To Hit
+  | where = ToHit IS NOT NULL AND ToHit <> 0 AND _pageNamespace = 0
+  | format = table
+  | order by = _pageTitle
+}}
+=== Natural Weapons ===
+{{#cargo_query:
+  | tables = ItemsTable=IT
+  | fields =
+      CONCAT('{{((}}favilink id{{!}}',CONCAT(IT.ObjectID),CONCAT(CASE WHEN _pageTitle LIKE '%(%' THEN CONCAT('{{!}}{{(}}lc:',_pageTitle,'{{)}}') ELSE '' END),'{{))}}')=Weapon or Equipment,
+      CONCAT(CASE WHEN ToHit > 0 THEN CONCAT('+',ToHit) ELSE ToHit END)=To Hit
+  | where = ToHit IS NOT NULL AND ToHit <> 0 AND _pageNamespace <> 0
+  | format = table
+  | order by = _pageTitle
+}}
 [[Category:Battle Mechanics]]