Difference between revisions of "Template:AbilityTableEntry"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Mornsta-gpuser
>Mornsta-gpuser
Line 5: Line 5:
 
| {{{Details|}}}
 
| {{{Details|}}}
 
| {{#cargo_query:tables=Adventurers|fields=CONCAT('[[File:',Id,' 0',VariationId,' r0',Rarity,'.png|24px|link=',_pageName,']] [[',_pageName,']]')|where=Abilities11="{{{Id|}}}" OR Abilities12="{{{Id|}}}" OR Abilities13="{{{Id|}}}" OR Abilities14="{{{Id|}}}" OR Abilities21="{{{Id|}}}" OR Abilities22="{{{Id|}}}" OR Abilities23="{{{Id|}}}" OR Abilities24="{{{Id|}}}" OR Abilities31="{{{Id|}}}" OR Abilities32="{{{Id|}}}" OR Abilities33="{{{Id|}}}" OR Abilities34="{{{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=Abilities11="{{{Id|}}}" OR Abilities12="{{{Id|}}}" OR Abilities13="{{{Id|}}}" OR Abilities14="{{{Id|}}}" OR Abilities21="{{{Id|}}}" OR Abilities22="{{{Id|}}}" OR Abilities23="{{{Id|}}}" OR Abilities24="{{{Id|}}}" OR Abilities31="{{{Id|}}}" OR Abilities32="{{{Id|}}}" OR Abilities33="{{{Id|}}}" OR Abilities34="{{{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
+
Rarity DESC, Id DESC}}
    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}}
 
 
| {{#cargo_query:tables=Wyrmprints|fields=CONCAT('[[File:',BaseId,' 0',VariationId,'.png|24px|link=',_pageName,']] [[',_pageName,']]')|where=Abilities11="{{{Id|}}}" OR Abilities12="{{{Id|}}}" OR Abilities21="{{{Id|}}}" OR Abilities22="{{{Id|}}}" OR Abilities31="{{{Id|}}}" OR Abilities32="{{{Id|}}}"|format=ul|group by=_pageName|default=|order by= Rarity DESC, ReleaseDate DESC, BaseId DESC}}
 
| {{#cargo_query:tables=Wyrmprints|fields=CONCAT('[[File:',BaseId,' 0',VariationId,'.png|24px|link=',_pageName,']] [[',_pageName,']]')|where=Abilities11="{{{Id|}}}" OR Abilities12="{{{Id|}}}" OR Abilities21="{{{Id|}}}" OR Abilities22="{{{Id|}}}" OR Abilities31="{{{Id|}}}" OR Abilities32="{{{Id|}}}"|format=ul|group by=_pageName|default=|order by= Rarity DESC, ReleaseDate DESC, BaseId DESC}}
 
| {{#cargo_query:tables=Dragons|fields=CONCAT('[[File:',BaseId,' 0',VariationId,'.png|24px|link=',_pageName,']] [[',_pageName,']]')|where=Abilities11="{{{Id|}}}" OR Abilities12="{{{Id|}}}" OR Abilities21="{{{Id|}}}" OR Abilities22="{{{Id|}}}"|format=ul|group by=_pageName|default=|order by=  
 
| {{#cargo_query:tables=Dragons|fields=CONCAT('[[File:',BaseId,' 0',VariationId,'.png|24px|link=',_pageName,']] [[',_pageName,']]')|where=Abilities11="{{{Id|}}}" OR Abilities12="{{{Id|}}}" OR Abilities21="{{{Id|}}}" OR Abilities22="{{{Id|}}}"|format=ul|group by=_pageName|default=|order by=  
    CASE ElementalType
+
ElementalType ASC,  
    WHEN 'Flame' THEN 1
 
    WHEN 'Water' THEN 2
 
    WHEN 'Wind' THEN 3
 
    WHEN 'Light' THEN 4
 
    WHEN 'Shadow' THEN 5
 
    ELSE 0
 
    END ASC,  
 
 
     Rarity DESC, Id DESC}}
 
     Rarity DESC, Id DESC}}
 
| {{#cargo_query:tables=Weapons|fields=CONCAT('[[File:',BaseId,' 01 ',FormId,'.png|24px|link=',_pageName,']] [[',_pageName,']]')|where=Abilities11="{{{Id|}}}" OR Abilities21="{{{Id|}}}"|format=ul|group by=_pageName|default=|order by=  
 
| {{#cargo_query:tables=Weapons|fields=CONCAT('[[File:',BaseId,' 01 ',FormId,'.png|24px|link=',_pageName,']] [[',_pageName,']]')|where=Abilities11="{{{Id|}}}" OR Abilities21="{{{Id|}}}"|format=ul|group by=_pageName|default=|order by=  
    CASE ElementalType
+
ElementalType
    WHEN 'Flame' THEN 1
+
ASC,  
    WHEN 'Water' THEN 2
+
Type
    WHEN 'Wind' THEN 3
+
ASC,
    WHEN 'Light' THEN 4
 
    WHEN 'Shadow' THEN 5
 
    ELSE 6
 
    END ASC,  
 
    CASE Type
 
    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}}
 
     Rarity DESC, Id DESC}}
 
|-
 
|-
 
</includeonly>
 
</includeonly>

Revision as of 01:09, 13 March 2019