Difference between revisions of "Template:CoAbilityTableEntry"

Revision as of 01:15, 13 March 2019

@@ Line 5: / Line 5: @@
 | style="text-align:center;" | {{{Details|}}}
 | {{#cargo_query:tables=Adventurers|fields=CONCAT('[[File:',Id,' 0',VariationId,' r0',Rarity,'.png|24px|link=',_pageName,']] [[',_pageName,']]')||where=ExAbilityData1="{{{Id|}}}" OR ExAbilityData2="{{{Id|}}}" OR ExAbilityData3="{{{Id|}}}" OR ExAbilityData4="{{{Id|}}}" OR ExAbilityData5="{{{Id|}}}"|format=ul|group by=_pageName|default=|order by=
-    CASE ElementalType
+ElementalType
-    WHEN 'Flame' THEN 1
+ASC,
-    WHEN 'Water' THEN 2
+WeaponType
-    WHEN 'Wind' THEN 3
+ASC,
-    WHEN 'Light' THEN 4
-    WHEN 'Shadow' THEN 5
-    ELSE 0
-    END ASC,
-    CASE WeaponType
-    WHEN 'Sword' THEN 1
-    WHEN 'Blade' THEN 2
-    WHEN 'Dagger' THEN 3
-    WHEN 'Axe' THEN 4
-    WHEN 'Lance' THEN 5
-    WHEN 'Bow' THEN 6
-    WHEN 'Wand' THEN 7
-    WHEN 'Staff' THEN 8
-    ELSE 0
-    END ASC,
      Rarity DESC, Id DESC}}
 |-
 </includeonly><noinclude>[[Category:Templates]]</noinclude>