Thrown weapon combat: Difference between revisions

Thrown weapon combat (view source)

Revision as of 23:59, 18 January 2024

970 bytes added , 18 January

update queries to show thrown daggers

Egocarib

Bureaucrats, Interface administrators, Administrators

8,290

edits

@@ Line 82: / Line 82: @@
 = List of Thrown Weapons =
 <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;">
 === Miscellaneous Thrown Items ===
-{{#cargo_query:tables=GeneralData,ItemsTable
+{{#cargo_query:
-| join on=GeneralData.ObjectID=ItemsTable.ObjectID
+| tables   = GeneralData=GD, ItemsTable=IT, PhysicalProperties=PP
-| fields=CONCAT('{{((}}favilink{{!}}',CONCAT(GeneralData._pageName),'{{))}}')=Item,CONCAT('{{((}}PV{{))}}',CONCAT(ItemsTable.MaxPV))=Max PV,CONCAT('{{((}}Heart{{))}}{{((}}dice tooltip{{!}}',CONCAT(ItemsTable.Damage),'{{))}}')=Damage
+| join on  = GD.JoinKey=IT.JoinKey, GD.JoinKey=PP.JoinKey
-| where=GeneralData.Categories='Thrown Weapons'
+| fields   = CONCAT('{{((}}favilink id{{!}}',CONCAT(GD.ObjectID),'{{))}}')=Item,
-| order by=ItemsTable.MaxPV DESC,ItemsTable.Damage DESC
+             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 ===
-{{#cargo_query:tables=GeneralData,ItemsTable
+{{#cargo_query:
-| join on=GeneralData.ObjectID=ItemsTable.ObjectID
+| tables   = GeneralData=GD, ItemsTable=IT, PhysicalProperties=PP
-| fields=CONCAT('{{((}}favilink{{!}}',CONCAT(GeneralData._pageName),'{{))}}')=Item,CONCAT('{{((}}PV{{))}}',CONCAT(ItemsTable.MaxPV))=Max PV,CONCAT('{{((}}Heart{{))}}',CONCAT(ItemsTable.Damage))=Damage
+| join on  = GD.JoinKey=IT.JoinKey, GD.JoinKey=PP.JoinKey
-| where=GeneralData.Categories='Tonics'
+| fields   = CONCAT('{{((}}favilink id{{!}}',CONCAT(GD.ObjectID),'{{))}}')=Item,
-| order by=Item
+             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 ===
-{{#cargo_query:tables=GeneralData,ItemsTable
+{{#cargo_query:
-| join on=GeneralData.ObjectID=ItemsTable.ObjectID
+| tables   = GeneralData=GD, ItemsTable=IT, PhysicalProperties=PP
-| fields=CONCAT('{{((}}favilink id{{!}}',GeneralData.ObjectID,'{{))}}')=Item,CONCAT('{{((}}PV{{))}}',CONCAT(ItemsTable.MaxPV))=PV,CONCAT('{{((}}Heart{{))}}',CONCAT(ItemsTable.Damage))=Damage
+| join on  = GD.JoinKey=IT.JoinKey, GD.JoinKey=PP.JoinKey
-| where=GeneralData.Categories='Grenades'
+| fields   = CONCAT('{{((}}favilink id{{!}}',CONCAT(GD.ObjectID),'{{))}}')=Item,
-| order by=Item
+             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
 }}