Difference between revisions of "User:Mornsta/Sandbox2"

Revision as of 12:16, 5 March 2019

Lua error: Error: Table Abilities not found..

Icon	Name	Might Value	Description	Adventurers with Ability	Wyrmprints with Ability	Dragons with Ability	Weapons with Ability

@@ Line 19: / Line 19: @@
 }}</pre>-->
-{{#cargo_query:
+{| class="wikitable sortable" style="text-align:center;"
-tables=NPCs
+! Icon
-|fields=_pageName, CONCAT('[[',_pageName,'/Stories]]')
+! Name
-|group by=_pageName
+! Might Value
+! Description
+! Adventurers with Ability
+! Wyrmprints with Ability
+! Dragons with Ability
+! Weapons with Ability
+|-
+{{#invoke:CargoQuery|main
+|q?tables=Abilities
+|q?fields=Id=Id,AbilityIconName=Icon,_pageName=Name,Details=Details,PartyPowerWeight=Might
+|q?groupBy=_pageName
+|q?orderBy=
+CASE
+WHEN ID IS NULL THEN 0
+WHEN Id < 10 THEN 1
+WHEN Id < 100 THEN 2
+ELSE 0
+END ASC,
+Id ASC
+|q?limit=999
+|template=AbilityTableEntry
 }}
+|}