8,290
edits
Glass zebra (talk | contribs) (typo ~~) |
(update queries to show thrown daggers) |
||
Line 82: | Line 82: | ||
= List of Thrown Weapons = | = List of Thrown Weapons = | ||
<div style="display:flex;flex-wrap:wrap;"> | <div style="display:flex;flex-wrap:wrap;"> | ||
<div style="margin-right: 2.5em;"> | |||
=== Thrown Blades === | |||
{{#cargo_query: | |||
| tables = GeneralData=GD, ItemsTable=IT, PhysicalProperties=PP | |||
| join on = GD.JoinKey=IT.JoinKey, GD.JoinKey=PP.JoinKey | |||
| fields = CONCAT('{{((}}favilink id{{!}}',CONCAT(GD.ObjectID),'{{))}}')=Item, | |||
CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV, | |||
CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}')=Damage | |||
| where = PP.Throwable='1' AND GD.Categories='Short Blades' | |||
| order by = IT.MaxPV DESC, IT.Damage DESC | |||
| format = table | |||
}} | |||
</div> | |||
<div style="margin-right: 2.5em;"> | <div style="margin-right: 2.5em;"> | ||
=== Miscellaneous Thrown Items === | === Miscellaneous Thrown Items === | ||
{{#cargo_query:tables=GeneralData,ItemsTable | {{#cargo_query: | ||
| join on= | | tables = GeneralData=GD, ItemsTable=IT, PhysicalProperties=PP | ||
| fields=CONCAT('{{((}}favilink{{!}}',CONCAT( | | join on = GD.JoinKey=IT.JoinKey, GD.JoinKey=PP.JoinKey | ||
| where= | | fields = CONCAT('{{((}}favilink id{{!}}',CONCAT(GD.ObjectID),'{{))}}')=Item, | ||
| order by= | CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV, | ||
| format=table | CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}')=Damage | ||
| where = PP.Throwable='1' AND GD.Categories<>'Short Blades' AND GD.Categories<>'Tonics' AND GD.Categories<>'Grenades' | |||
| order by = IT.MaxPV DESC, IT.Damage DESC | |||
| format = table | |||
}} | }} | ||
Line 97: | Line 115: | ||
=== Tonics === | === Tonics === | ||
{{#cargo_query:tables=GeneralData,ItemsTable | {{#cargo_query: | ||
| join on= | | tables = GeneralData=GD, ItemsTable=IT, PhysicalProperties=PP | ||
| fields=CONCAT('{{((}}favilink{{!}}',CONCAT( | | join on = GD.JoinKey=IT.JoinKey, GD.JoinKey=PP.JoinKey | ||
| where= | | fields = CONCAT('{{((}}favilink id{{!}}',CONCAT(GD.ObjectID),'{{))}}')=Item, | ||
| order by= | CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV, | ||
| format=table | CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}')=Damage | ||
| where = PP.Throwable='1' AND GD.Categories='Tonics' | |||
| order by = IT.MaxPV DESC, IT.Damage DESC | |||
| format = table | |||
}} | }} | ||
Line 109: | Line 130: | ||
=== Grenades === | === Grenades === | ||
{{#cargo_query:tables=GeneralData,ItemsTable | {{#cargo_query: | ||
| join on= | | tables = GeneralData=GD, ItemsTable=IT, PhysicalProperties=PP | ||
| fields=CONCAT('{{((}}favilink id{{!}}', | | join on = GD.JoinKey=IT.JoinKey, GD.JoinKey=PP.JoinKey | ||
| where= | | fields = CONCAT('{{((}}favilink id{{!}}',CONCAT(GD.ObjectID),'{{))}}')=Item, | ||
| order by= | CONCAT('{{((}}PV{{))}}',CONCAT(IT.MaxPV))=Max PV, | ||
| format=table | CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(IT.Damage),'{{))}}')=Damage | ||
| where = PP.Throwable='1' AND GD.Categories='Grenades' | |||
| order by = IT.MaxPV DESC, IT.Damage DESC | |||
| format = table | |||
}} | }} | ||