Difference between revisions of "Template:CoAbilityTableEntry"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Mornsta-gpuser
>Eave
m (fix the conditional)
 
(15 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
<includeonly>
 
<includeonly>
| [[File:{{{Icon|}}}.png|80px|link={{{Name|}}}]]
+
| [[File:{{{Icon|}}}.png|80px|link={{{PageName|}}}]]
| style="text-align:center;" | [[{{{Name|}}}]]
+
| style="text-align:center;" | [[{{{PageName|}}}|{{{Name|}}}]]
 
| style="text-align:center;" | {{{Might|}}}
 
| style="text-align:center;" | {{{Might|}}}
 
| style="text-align:center;" | {{{Details|}}}
 
| 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=  
+
| {{#cargo_query:tables=Adventurers|fields=CONCAT('[[File:',Id,' 0',VariationId,' r0',Rarity,'.png|24px|link=',_pageName,']] [[',_pageName,']]')||where=IsPlayable AND (ExAbilityData1="{{{Id|}}}" OR ExAbilityData2="{{{Id|}}}" OR ExAbilityData3="{{{Id|}}}" OR ExAbilityData4="{{{Id|}}}" OR ExAbilityData5="{{{Id|}}}")|format=ul|group by=_pageName|default=|order by= ElementalTypeId ASC, WeaponTypeId ASC, Rarity DESC, Id DESC, FullName ASC}}
    CASE ElementalType
 
    WHEN 'Flame' THEN 1
 
    WHEN 'Water' THEN 2
 
    WHEN 'Wind' THEN 3
 
    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>
 
</includeonly><noinclude>[[Category:Templates]]</noinclude>

Latest revision as of 17:43, 8 April 2020