Difference between revisions of "Template:ChainCoAbilityTableEntry"
Jump to navigation
Jump to search
>Eave (switch to combining table entries into single entry for each generic ability name) |
>Eave m (filter playable adventurers only) |
||
| (14 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
| [[File:{{{Icon|}}}.png|80px|link={{{Name|}}}]] | | [[File:{{{Icon|}}}.png|80px|link={{{Name|}}}]] | ||
| style="text-align:center;" | [[{{{Name|}}}|{{{Name|}}}]] | | style="text-align:center;" | [[{{{Name|}}}|{{{Name|}}}]] | ||
| − | | {{#cargo_query:tables=Adventurers|fields=CONCAT('[[File:',Id,' 0',VariationId,' r0',Rarity,'.png|24px|link=',_pageName,']] [[',_pageName,']]') | + | | {{#cargo_query:tables=Adventurers,ChainCoAbilities |
| + | |join on=Adventurers.ExAbility2Data5=ChainCoAbilities.Id | ||
| + | |fields=CONCAT('{{Tooltip|[[File:', Adventurers.Id, ' 0', VariationId,' r0', Rarity ,'.png|24px|link=', Adventurers._pageName, ']] [[', Adventurers._pageName, ']]|', ChainCoAbilities.Details, '}}') | ||
| + | |where=ChainCoAbilities.GenericName="{{{Name|}}}" AND Adventurers.IsPlayable | ||
| + | |group by=Adventurers._pageName | ||
| + | |order by=ChainCoAbilities.Id DESC,Adventurers._pageName | ||
| + | |format=ul|default=}} | ||
|- | |- | ||
</includeonly><noinclude>[[Category:Templates]]</noinclude> | </includeonly><noinclude>[[Category:Templates]]</noinclude> | ||