Difference between revisions of "Template:ChainCoAbilityTableEntry"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Eave
(Created page with "<includeonly> | [[File:{{{Icon|}}}.png|80px|link={{{PageName|}}}]] | style="text-align:center;" | [[{{{PageName|}}}|{{{Name|}}}]] | style="text-align:center;" | {{{Details|}}}...")
>Eave
m (filter playable adventurers only)
 
(16 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
<includeonly>
 
<includeonly>
| [[File:{{{Icon|}}}.png|80px|link={{{PageName|}}}]]
+
| [[File:{{{Icon|}}}.png|80px|link={{{Name|}}}]]
| style="text-align:center;" | [[{{{PageName|}}}|{{{Name|}}}]]
+
| style="text-align:center;" | [[{{{Name|}}}|{{{Name|}}}]]
| style="text-align:center;" | {{{Details|}}}
+
| {{#cargo_query:tables=Adventurers,ChainCoAbilities
| {{#cargo_query:tables=Adventurers|fields=CONCAT('[[File:',Id,' 0',VariationId,' r0',Rarity,'.png|24px|link=',_pageName,']] [[',_pageName,']]')||where=ExAbility2Data1="{{{Id|}}}" OR ExAbility2Data2="{{{Id|}}}" OR ExAbility2Data3="{{{Id|}}}" OR ExAbility2Data4="{{{Id|}}}" OR ExAbility2Data5="{{{Id|}}}"|format=ul|group by=_pageName|default=|order by= ElementalTypeId ASC, WeaponTypeId ASC, Rarity DESC, IdLong DESC, FullName ASC}}
+
  |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>

Latest revision as of 20:05, 3 April 2020