Difference between revisions of "Adventurer Grid"

From Dragalia Lost Wiki
Jump to navigation Jump to search
(it's better this way)
>Eave
m (pass through EditSkillId for filtering purposes)
 
(100 intermediate revisions by 6 users not shown)
Line 1: Line 1:
 
{{CharacterListHeader}}
 
{{CharacterListHeader}}
 
{{CharacterListFilter}}
 
{{CharacterListFilter}}
−
 
 
<div style="display:flex;flex-wrap:wrap;justify-content:center;margin-top:10px">
 
<div style="display:flex;flex-wrap:wrap;justify-content:center;margin-top:10px">
−
{{#cargo_query:tables=Adventurers
+
{{#invoke:CargoQuery|main
−
|fields=_pageName=PageName,FullName=Name,ElementalType=Element,WeaponType=Weapon,Rarity,Id=InternalId,CharaType=Type,VariationId=VariationId,Title=Title,Abilities11,Abilities21,Abilities31
+
|q?tables=Adventurers
−
|where=IsPlayable!=0
+
|q?fields=_pageName=PageName,FullName=Name,ElementalType=Element,WeaponType=Weapon,Rarity,Availability=Availability,Id=InternalId,CharaType=Type,VariationId=VariationId,Title=Title,Abilities11,Abilities21,Abilities31,MaxLimitBreakCount,EditSkillId
−
|format=template
+
|q?where=IsPlayable!=0 AND ReleaseDate <= NOW()
 
|template=CharacterGridEntry
 
|template=CharacterGridEntry
−
|named args=yes
+
|q?groupBy=_pageName
−
|group by=_pageName
+
|q?limit=999
−
|order by=  
+
|q?orderBy= ElementalTypeId ASC, WeaponTypeId ASC, Rarity DESC, IdLong DESC, FullName ASC
−
    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 Rarity
 
−
    WHEN '5' THEN 1
 
−
    WHEN '4' THEN 2
 
−
    WHEN '3' THEN 3
 
−
    ELSE 0
 
−
    END ASC,
 
−
    FullName ASC, Id DESC
 
 
}}
 
}}
 
</div>
 
</div>

Latest revision as of 00:26, 27 June 2020

Affliction Resistance

">
">
">
">
">
">
">