8,290
edits
(stubbbbbbbb) |
(add queries for ToHit) |
||
(One intermediate revision by the same user not shown) | |||
Line 6: | Line 6: | ||
== Items by Hit Bonus == | == Items by Hit Bonus == | ||
{{ | === 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]] |