Difference between revisions of "Template:CoAbility"
Jump to navigation
Jump to search
>@DeletedUser41383047 |
>Mornsta-gpuser |
||
| Line 44: | Line 44: | ||
<p style="margin:15px auto;border-bottom:1px solid;margin-bottom:15px;font-size:1.2em;font-variant-caps: small-caps;font-weight:bold">Adventurers With This Co-ability</p> | <p style="margin:15px auto;border-bottom:1px solid;margin-bottom:15px;font-size:1.2em;font-variant-caps: small-caps;font-weight:bold">Adventurers With This Co-ability</p> | ||
{{#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= | {{#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= | ||
| − | :''There are no adventurers with this co-ability.''}} | + | :''There are no adventurers with this co-ability.''|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, | ||
| + | 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}} | ||
[[Category:Co-abilities]]</includeonly> | [[Category:Co-abilities]]</includeonly> | ||