Difference between revisions of "Template:SkillTableEntry"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Mornsta-gpuser
>Mornsta-gpuser
Line 8: Line 8:
 
| {{{Lv2|}}}
 
| {{{Lv2|}}}
 
| {{#ifeq: {{{Hide|}}} | 1 | - | {{{Lv3|}}} }}
 
| {{#ifeq: {{{Hide|}}} | 1 | - | {{{Lv3|}}} }}
−
| {{#cargo_query:tables=Adventurers|fields=CONCAT('[[File:',Id,' 0',VariationId,' r0',Rarity,'.png|24px|link=',_pageName,']] [[',_pageName,']]')|where=Skill1Name="{{{Name|{{PAGENAME}}}}}" OR Skill2Name="{{{Name|{{PAGENAME}}}}}"|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=Skill1Name="{{{Name|{{PAGENAME}}}}}" OR Skill2Name="{{{Name|{{PAGENAME}}}}}"|format=ul|group by=_pageName|default=|order by=ElementalType ASC, WeaponType ASC, Rarity DESC, Id DESC}}
−
    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}}
 
 
| {{#cargo_query:tables=Weapons|fields=CONCAT('[[File:',BaseId,' 0',VariationId,' ',FormId,'.png|24px|link=',_pageName,']] [[',_pageName,']]')|where=SkillName="{{{Name|{{PAGENAME}}}}}"|format=ul|group by=_pageName|default=|order by=  
 
| {{#cargo_query:tables=Weapons|fields=CONCAT('[[File:',BaseId,' 0',VariationId,' ',FormId,'.png|24px|link=',_pageName,']] [[',_pageName,']]')|where=SkillName="{{{Name|{{PAGENAME}}}}}"|format=ul|group by=_pageName|default=|order by=  
−
    CASE ElementalType
+
ElementalType ASC, Type ASC, Rarity DESC, Id DESC}}
−
    WHEN 'Flame' THEN 1
+
| {{#cargo_query:tables=Dragons|fields=CONCAT('[[File:',BaseId,' 0',VariationId,'.png|24px|link=',_pageName,']] [[',_pageName,']]')|where=SkillName="{{{Name|{{PAGENAME}}}}}"|format=ul|group by=_pageName|default=|order by=ElementalType ASC, Rarity DESC, Id DESC}}
−
    WHEN 'Water' THEN 2
 
−
    WHEN 'Wind' THEN 3
 
−
    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}}
 
−
| {{#cargo_query:tables=Dragons|fields=CONCAT('[[File:',BaseId,' 0',VariationId,'.png|24px|link=',_pageName,']] [[',_pageName,']]')|where=SkillName="{{{Name|{{PAGENAME}}}}}"|format=ul|group by=_pageName|default=|order by=  
 
−
    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,  
 
−
    Rarity DESC, Id DESC}}
 
 
|-
 
|-
 
</includeonly><noinclude>[[Category:Templates]]</noinclude>
 
</includeonly><noinclude>[[Category:Templates]]</noinclude>

Revision as of 01:07, 13 March 2019

Retrieved from "https://dlwiki.cherrymint.live/index.php?title=Template:SkillTableEntry&oldid=239843"