Difference between revisions of "User:Mornsta/Sandbox4"

Revision as of 03:17, 8 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 1: / Line 1: @@
+==Uncategorized Abilities==
+{| class="wikitable sortable" style="text-align:center;"
+! Icon
+! Name
+! 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?where=(AbilityGroup!=19801) AND (AbilityGroup NOT BETWEEN 10201 AND 10210) AND (AbilityGroup!=10699) AND (AbilityGroup NOT BETWEEN 10301 AND 10305) AND (AbilityGroup NOT BETWEEN 10401 AND 10501) AND (AbilityGroup!=10101) AND (AbilityGroup!=10102) AND (AbilityGroup!=10103) AND (AbilityGroup!=10104) AND (AbilityGroup!=19901)
+|q?groupBy=_pageName
+|q?orderBy=AbilityGroup ASC,
+AbilityIconName ASC,
+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
+}}
+|}