Difference between revisions of "Template:AbilityTableEntry"
Jump to navigation
Jump to search
imported>Elaeagnifolia |
>Mornsta-gpuser |
||
| Line 4: | Line 4: | ||
| {{{Might|}}} | | {{{Might|}}} | ||
| {{{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=}} | + | | {{#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=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=}} | + | CASE ElementalType |
| − | | {{#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=}} | + | WHEN 'Flame' THEN 1 |
| − | | {{#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=}} | + | 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=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= | ||
| + | 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}} | ||
| + | | {{#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 | ||
| + | WHEN 'Flame' THEN 1 | ||
| + | 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}} | ||
|- | |- | ||
</includeonly> | </includeonly> | ||